/
simplified.txt
31 lines (31 loc) · 1.68 KB
/
simplified.txt
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
TakeOrderedAndProject [brand,brand_id,d_year,sum_agg]
WholeStageCodegen (4)
HashAggregate [d_year,i_brand,i_brand_id,sum] [brand,brand_id,sum,sum(UnscaledValue(ss_net_profit)),sum_agg]
InputAdapter
Exchange [d_year,i_brand,i_brand_id] #1
WholeStageCodegen (3)
HashAggregate [d_year,i_brand,i_brand_id,ss_net_profit] [sum,sum]
Project [d_year,i_brand,i_brand_id,ss_net_profit]
BroadcastHashJoin [d_date_sk,ss_sold_date_sk]
Project [i_brand,i_brand_id,ss_net_profit,ss_sold_date_sk]
BroadcastHashJoin [i_item_sk,ss_item_sk]
Filter [ss_item_sk,ss_sold_date_sk]
ColumnarToRow
InputAdapter
Scan parquet default.store_sales [ss_item_sk,ss_net_profit,ss_sold_date_sk]
InputAdapter
BroadcastExchange #2
WholeStageCodegen (1)
Project [i_brand,i_brand_id,i_item_sk]
Filter [i_item_sk,i_manufact_id]
ColumnarToRow
InputAdapter
Scan parquet default.item [i_brand,i_brand_id,i_item_sk,i_manufact_id]
InputAdapter
BroadcastExchange #3
WholeStageCodegen (2)
Project [d_date_sk,d_year]
Filter [d_date_sk,d_moy]
ColumnarToRow
InputAdapter
Scan parquet default.date_dim [d_date_sk,d_moy,d_year]