== Physical Plan ==
VeloxColumnarToRow (90)
+- TakeOrderedAndProjectExecTransformer (89)
   +- ^ RegularHashAggregateExecTransformer (87)
      +- ^ InputIteratorTransformer (86)
         +- ColumnarExchange (84)
            +- VeloxResizeBatches (83)
               +- ^ ProjectExecTransformer (81)
                  +- ^ FlushableHashAggregateExecTransformer (80)
                     +- ^ ProjectExecTransformer (79)
                        +- ^ InputIteratorTransformer (78)
                           +- ColumnarUnion (76)
                              :- ^ ProjectExecTransformer (42)
                              :  +- ^ RegularHashAggregateExecTransformer (41)
                              :     +- ^ InputIteratorTransformer (40)
                              :        +- ColumnarExchange (38)
                              :           +- VeloxResizeBatches (37)
                              :              +- ^ ProjectExecTransformer (35)
                              :                 +- ^ FlushableHashAggregateExecTransformer (34)
                              :                    +- ^ ProjectExecTransformer (33)
                              :                       +- ^ BroadcastHashJoinExecTransformer Inner BuildRight (32)
                              :                          :- ^ ProjectExecTransformer (24)
                              :                          :  +- ^ BroadcastHashJoinExecTransformer Inner BuildRight (23)
                              :                          :     :- ^ ProjectExecTransformer (15)
                              :                          :     :  +- ^ BroadcastHashJoinExecTransformer Inner BuildRight (14)
                              :                          :     :     :- ^ ProjectExecTransformer (10)
                              :                          :     :     :  +- ^ BroadcastHashJoinExecTransformer Inner BuildRight (9)
                              :                          :     :     :     :- ^ FilterExecTransformer (2)
                              :                          :     :     :     :  +- ^ FileSourceScanExecTransformer parquet spark_catalog.default.web_sales (1)
                              :                          :     :     :     +- ^ InputIteratorTransformer (8)
                              :                          :     :     :        +- ColumnarBroadcastExchange (6)
                              :                          :     :     :           +- ^ FilterExecTransformer (4)
                              :                          :     :     :              +- ^ FileSourceScanExecTransformer parquet spark_catalog.default.warehouse (3)
                              :                          :     :     +- ^ InputIteratorTransformer (13)
                              :                          :     :        +- ReusedExchange (11)
                              :                          :     +- ^ InputIteratorTransformer (22)
                              :                          :        +- ColumnarBroadcastExchange (20)
                              :                          :           +- ^ ProjectExecTransformer (18)
                              :                          :              +- ^ FilterExecTransformer (17)
                              :                          :                 +- ^ FileSourceScanExecTransformer parquet spark_catalog.default.time_dim (16)
                              :                          +- ^ InputIteratorTransformer (31)
                              :                             +- ColumnarBroadcastExchange (29)
                              :                                +- ^ ProjectExecTransformer (27)
                              :                                   +- ^ FilterExecTransformer (26)
                              :                                      +- ^ FileSourceScanExecTransformer parquet spark_catalog.default.ship_mode (25)
                              +- ^ ProjectExecTransformer (74)
                                 +- ^ RegularHashAggregateExecTransformer (73)
                                    +- ^ InputIteratorTransformer (72)
                                       +- ColumnarExchange (70)
                                          +- VeloxResizeBatches (69)
                                             +- ^ ProjectExecTransformer (67)
                                                +- ^ FlushableHashAggregateExecTransformer (66)
                                                   +- ^ ProjectExecTransformer (65)
                                                      +- ^ BroadcastHashJoinExecTransformer Inner BuildRight (64)
                                                         :- ^ ProjectExecTransformer (60)
                                                         :  +- ^ BroadcastHashJoinExecTransformer Inner BuildRight (59)
                                                         :     :- ^ ProjectExecTransformer (55)
                                                         :     :  +- ^ BroadcastHashJoinExecTransformer Inner BuildRight (54)
                                                         :     :     :- ^ ProjectExecTransformer (50)
                                                         :     :     :  +- ^ BroadcastHashJoinExecTransformer Inner BuildRight (49)
                                                         :     :     :     :- ^ FilterExecTransformer (45)
                                                         :     :     :     :  +- ^ FileSourceScanExecTransformer parquet spark_catalog.default.catalog_sales (44)
                                                         :     :     :     +- ^ InputIteratorTransformer (48)
                                                         :     :     :        +- ReusedExchange (46)
                                                         :     :     +- ^ InputIteratorTransformer (53)
                                                         :     :        +- ReusedExchange (51)
                                                         :     +- ^ InputIteratorTransformer (58)
                                                         :        +- ReusedExchange (56)
                                                         +- ^ InputIteratorTransformer (63)
                                                            +- ReusedExchange (61)


(1) FileSourceScanExecTransformer parquet spark_catalog.default.web_sales
Output [7]: [ws_sold_time_sk#1, ws_ship_mode_sk#2, ws_warehouse_sk#3, ws_quantity#4, ws_ext_sales_price#5, ws_net_paid#6, ws_sold_date_sk#7]
Batched: true
Location: InMemoryFileIndex []
PartitionFilters: [isnotnull(ws_sold_date_sk#7), dynamicpruningexpression(ws_sold_date_sk#7 IN dynamicpruning#8)]
PushedFilters: [IsNotNull(ws_warehouse_sk), IsNotNull(ws_sold_time_sk), IsNotNull(ws_ship_mode_sk)]
ReadSchema: struct<ws_sold_time_sk:int,ws_ship_mode_sk:int,ws_warehouse_sk:int,ws_quantity:int,ws_ext_sales_price:decimal(7,2),ws_net_paid:decimal(7,2)>

(2) FilterExecTransformer
Input [7]: [ws_sold_time_sk#1, ws_ship_mode_sk#2, ws_warehouse_sk#3, ws_quantity#4, ws_ext_sales_price#5, ws_net_paid#6, ws_sold_date_sk#7]
Arguments: ((isnotnull(ws_warehouse_sk#3) AND isnotnull(ws_sold_time_sk#1)) AND isnotnull(ws_ship_mode_sk#2))

(3) FileSourceScanExecTransformer parquet spark_catalog.default.warehouse
Output [7]: [w_warehouse_sk#9, w_warehouse_name#10, w_warehouse_sq_ft#11, w_city#12, w_county#13, w_state#14, w_country#15]
Batched: true
Location: InMemoryFileIndex [{warehouse_dir}/warehouse]
PushedFilters: [IsNotNull(w_warehouse_sk)]
ReadSchema: struct<w_warehouse_sk:int,w_warehouse_name:string,w_warehouse_sq_ft:int,w_city:string,w_county:string,w_state:string,w_country:string>

(4) FilterExecTransformer
Input [7]: [w_warehouse_sk#9, w_warehouse_name#10, w_warehouse_sq_ft#11, w_city#12, w_county#13, w_state#14, w_country#15]
Arguments: isnotnull(w_warehouse_sk#9)

(5) WholeStageCodegenTransformer (2)
Input [7]: [w_warehouse_sk#9, w_warehouse_name#10, w_warehouse_sq_ft#11, w_city#12, w_county#13, w_state#14, w_country#15]
Arguments: false

(6) ColumnarBroadcastExchange
Input [7]: [w_warehouse_sk#9, w_warehouse_name#10, w_warehouse_sq_ft#11, w_city#12, w_county#13, w_state#14, w_country#15]
Arguments: HashedRelationBroadcastMode(List(cast(input[0, int, false] as bigint)),false), [plan_id=1]

(7) InputAdapter
Input [7]: [w_warehouse_sk#9, w_warehouse_name#10, w_warehouse_sq_ft#11, w_city#12, w_county#13, w_state#14, w_country#15]

(8) InputIteratorTransformer
Input [7]: [w_warehouse_sk#9, w_warehouse_name#10, w_warehouse_sq_ft#11, w_city#12, w_county#13, w_state#14, w_country#15]

(9) BroadcastHashJoinExecTransformer
Left keys [1]: [ws_warehouse_sk#3]
Right keys [1]: [w_warehouse_sk#9]
Join type: Inner
Join condition: None

(10) ProjectExecTransformer
Output [12]: [ws_sold_time_sk#1, ws_ship_mode_sk#2, ws_quantity#4, ws_ext_sales_price#5, ws_net_paid#6, ws_sold_date_sk#7, w_warehouse_name#10, w_warehouse_sq_ft#11, w_city#12, w_county#13, w_state#14, w_country#15]
Input [14]: [ws_sold_time_sk#1, ws_ship_mode_sk#2, ws_warehouse_sk#3, ws_quantity#4, ws_ext_sales_price#5, ws_net_paid#6, ws_sold_date_sk#7, w_warehouse_sk#9, w_warehouse_name#10, w_warehouse_sq_ft#11, w_city#12, w_county#13, w_state#14, w_country#15]

(11) ReusedExchange [Reuses operator id: 94]
Output [3]: [d_date_sk#16, d_year#17, d_moy#18]

(12) InputAdapter
Input [3]: [d_date_sk#16, d_year#17, d_moy#18]

(13) InputIteratorTransformer
Input [3]: [d_date_sk#16, d_year#17, d_moy#18]

(14) BroadcastHashJoinExecTransformer
Left keys [1]: [ws_sold_date_sk#7]
Right keys [1]: [d_date_sk#16]
Join type: Inner
Join condition: None

(15) ProjectExecTransformer
Output [13]: [ws_sold_time_sk#1, ws_ship_mode_sk#2, ws_quantity#4, ws_ext_sales_price#5, ws_net_paid#6, w_warehouse_name#10, w_warehouse_sq_ft#11, w_city#12, w_county#13, w_state#14, w_country#15, d_year#17, d_moy#18]
Input [15]: [ws_sold_time_sk#1, ws_ship_mode_sk#2, ws_quantity#4, ws_ext_sales_price#5, ws_net_paid#6, ws_sold_date_sk#7, w_warehouse_name#10, w_warehouse_sq_ft#11, w_city#12, w_county#13, w_state#14, w_country#15, d_date_sk#16, d_year#17, d_moy#18]

(16) FileSourceScanExecTransformer parquet spark_catalog.default.time_dim
Output [2]: [t_time_sk#19, t_time#20]
Batched: true
Location: InMemoryFileIndex [{warehouse_dir}/time_dim]
PushedFilters: [IsNotNull(t_time), GreaterThanOrEqual(t_time,30838), LessThanOrEqual(t_time,59638), IsNotNull(t_time_sk)]
ReadSchema: struct<t_time_sk:int,t_time:int>

(17) FilterExecTransformer
Input [2]: [t_time_sk#19, t_time#20]
Arguments: (((isnotnull(t_time#20) AND (t_time#20 >= 30838)) AND (t_time#20 <= 59638)) AND isnotnull(t_time_sk#19))

(18) ProjectExecTransformer
Output [1]: [t_time_sk#19]
Input [2]: [t_time_sk#19, t_time#20]

(19) WholeStageCodegenTransformer (4)
Input [1]: [t_time_sk#19]
Arguments: false

(20) ColumnarBroadcastExchange
Input [1]: [t_time_sk#19]
Arguments: HashedRelationBroadcastMode(List(cast(input[0, int, true] as bigint)),false), [plan_id=2]

(21) InputAdapter
Input [1]: [t_time_sk#19]

(22) InputIteratorTransformer
Input [1]: [t_time_sk#19]

(23) BroadcastHashJoinExecTransformer
Left keys [1]: [ws_sold_time_sk#1]
Right keys [1]: [t_time_sk#19]
Join type: Inner
Join condition: None

(24) ProjectExecTransformer
Output [12]: [ws_ship_mode_sk#2, ws_quantity#4, ws_ext_sales_price#5, ws_net_paid#6, w_warehouse_name#10, w_warehouse_sq_ft#11, w_city#12, w_county#13, w_state#14, w_country#15, d_year#17, d_moy#18]
Input [14]: [ws_sold_time_sk#1, ws_ship_mode_sk#2, ws_quantity#4, ws_ext_sales_price#5, ws_net_paid#6, w_warehouse_name#10, w_warehouse_sq_ft#11, w_city#12, w_county#13, w_state#14, w_country#15, d_year#17, d_moy#18, t_time_sk#19]

(25) FileSourceScanExecTransformer parquet spark_catalog.default.ship_mode
Output [2]: [sm_ship_mode_sk#21, sm_carrier#22]
Batched: true
Location: InMemoryFileIndex [{warehouse_dir}/ship_mode]
PushedFilters: [In(sm_carrier, [BARIAN              ,DHL                 ]), IsNotNull(sm_ship_mode_sk)]
ReadSchema: struct<sm_ship_mode_sk:int,sm_carrier:string>

(26) FilterExecTransformer
Input [2]: [sm_ship_mode_sk#21, sm_carrier#22]
Arguments: (sm_carrier#22 IN (DHL                 ,BARIAN              ) AND isnotnull(sm_ship_mode_sk#21))

(27) ProjectExecTransformer
Output [1]: [sm_ship_mode_sk#21]
Input [2]: [sm_ship_mode_sk#21, sm_carrier#22]

(28) WholeStageCodegenTransformer (5)
Input [1]: [sm_ship_mode_sk#21]
Arguments: false

(29) ColumnarBroadcastExchange
Input [1]: [sm_ship_mode_sk#21]
Arguments: HashedRelationBroadcastMode(List(cast(input[0, int, true] as bigint)),false), [plan_id=3]

(30) InputAdapter
Input [1]: [sm_ship_mode_sk#21]

(31) InputIteratorTransformer
Input [1]: [sm_ship_mode_sk#21]

(32) BroadcastHashJoinExecTransformer
Left keys [1]: [ws_ship_mode_sk#2]
Right keys [1]: [sm_ship_mode_sk#21]
Join type: Inner
Join condition: None

(33) ProjectExecTransformer
Output [31]: [w_warehouse_name#10, w_warehouse_sq_ft#11, w_city#12, w_county#13, w_state#14, w_country#15, d_year#17, CASE WHEN (d_moy#18 = 1) THEN (ws_ext_sales_price#5 * cast(ws_quantity#4 as decimal(10,0))) ELSE 0.00 END AS _pre_1#23, CASE WHEN (d_moy#18 = 2) THEN (ws_ext_sales_price#5 * cast(ws_quantity#4 as decimal(10,0))) ELSE 0.00 END AS _pre_2#24, CASE WHEN (d_moy#18 = 3) THEN (ws_ext_sales_price#5 * cast(ws_quantity#4 as decimal(10,0))) ELSE 0.00 END AS _pre_3#25, CASE WHEN (d_moy#18 = 4) THEN (ws_ext_sales_price#5 * cast(ws_quantity#4 as decimal(10,0))) ELSE 0.00 END AS _pre_4#26, CASE WHEN (d_moy#18 = 5) THEN (ws_ext_sales_price#5 * cast(ws_quantity#4 as decimal(10,0))) ELSE 0.00 END AS _pre_5#27, CASE WHEN (d_moy#18 = 6) THEN (ws_ext_sales_price#5 * cast(ws_quantity#4 as decimal(10,0))) ELSE 0.00 END AS _pre_6#28, CASE WHEN (d_moy#18 = 7) THEN (ws_ext_sales_price#5 * cast(ws_quantity#4 as decimal(10,0))) ELSE 0.00 END AS _pre_7#29, CASE WHEN (d_moy#18 = 8) THEN (ws_ext_sales_price#5 * cast(ws_quantity#4 as decimal(10,0))) ELSE 0.00 END AS _pre_8#30, CASE WHEN (d_moy#18 = 9) THEN (ws_ext_sales_price#5 * cast(ws_quantity#4 as decimal(10,0))) ELSE 0.00 END AS _pre_9#31, CASE WHEN (d_moy#18 = 10) THEN (ws_ext_sales_price#5 * cast(ws_quantity#4 as decimal(10,0))) ELSE 0.00 END AS _pre_10#32, CASE WHEN (d_moy#18 = 11) THEN (ws_ext_sales_price#5 * cast(ws_quantity#4 as decimal(10,0))) ELSE 0.00 END AS _pre_11#33, CASE WHEN (d_moy#18 = 12) THEN (ws_ext_sales_price#5 * cast(ws_quantity#4 as decimal(10,0))) ELSE 0.00 END AS _pre_12#34, CASE WHEN (d_moy#18 = 1) THEN (ws_net_paid#6 * cast(ws_quantity#4 as decimal(10,0))) ELSE 0.00 END AS _pre_13#35, CASE WHEN (d_moy#18 = 2) THEN (ws_net_paid#6 * cast(ws_quantity#4 as decimal(10,0))) ELSE 0.00 END AS _pre_14#36, CASE WHEN (d_moy#18 = 3) THEN (ws_net_paid#6 * cast(ws_quantity#4 as decimal(10,0))) ELSE 0.00 END AS _pre_15#37, CASE WHEN (d_moy#18 = 4) THEN (ws_net_paid#6 * cast(ws_quantity#4 as decimal(10,0))) ELSE 0.00 END AS _pre_16#38, CASE WHEN (d_moy#18 = 5) THEN (ws_net_paid#6 * cast(ws_quantity#4 as decimal(10,0))) ELSE 0.00 END AS _pre_17#39, CASE WHEN (d_moy#18 = 6) THEN (ws_net_paid#6 * cast(ws_quantity#4 as decimal(10,0))) ELSE 0.00 END AS _pre_18#40, CASE WHEN (d_moy#18 = 7) THEN (ws_net_paid#6 * cast(ws_quantity#4 as decimal(10,0))) ELSE 0.00 END AS _pre_19#41, CASE WHEN (d_moy#18 = 8) THEN (ws_net_paid#6 * cast(ws_quantity#4 as decimal(10,0))) ELSE 0.00 END AS _pre_20#42, CASE WHEN (d_moy#18 = 9) THEN (ws_net_paid#6 * cast(ws_quantity#4 as decimal(10,0))) ELSE 0.00 END AS _pre_21#43, CASE WHEN (d_moy#18 = 10) THEN (ws_net_paid#6 * cast(ws_quantity#4 as decimal(10,0))) ELSE 0.00 END AS _pre_22#44, CASE WHEN (d_moy#18 = 11) THEN (ws_net_paid#6 * cast(ws_quantity#4 as decimal(10,0))) ELSE 0.00 END AS _pre_23#45, CASE WHEN (d_moy#18 = 12) THEN (ws_net_paid#6 * cast(ws_quantity#4 as decimal(10,0))) ELSE 0.00 END AS _pre_24#46]
Input [13]: [ws_ship_mode_sk#2, ws_quantity#4, ws_ext_sales_price#5, ws_net_paid#6, w_warehouse_name#10, w_warehouse_sq_ft#11, w_city#12, w_county#13, w_state#14, w_country#15, d_year#17, d_moy#18, sm_ship_mode_sk#21]

(34) FlushableHashAggregateExecTransformer
Input [31]: [w_warehouse_name#10, w_warehouse_sq_ft#11, w_city#12, w_county#13, w_state#14, w_country#15, d_year#17, _pre_1#23, _pre_2#24, _pre_3#25, _pre_4#26, _pre_5#27, _pre_6#28, _pre_7#29, _pre_8#30, _pre_9#31, _pre_10#32, _pre_11#33, _pre_12#34, _pre_13#35, _pre_14#36, _pre_15#37, _pre_16#38, _pre_17#39, _pre_18#40, _pre_19#41, _pre_20#42, _pre_21#43, _pre_22#44, _pre_23#45, _pre_24#46]
Keys [7]: [w_warehouse_name#10, w_warehouse_sq_ft#11, w_city#12, w_county#13, w_state#14, w_country#15, d_year#17]
Functions [24]: [partial_sum(_pre_1#23), partial_sum(_pre_2#24), partial_sum(_pre_3#25), partial_sum(_pre_4#26), partial_sum(_pre_5#27), partial_sum(_pre_6#28), partial_sum(_pre_7#29), partial_sum(_pre_8#30), partial_sum(_pre_9#31), partial_sum(_pre_10#32), partial_sum(_pre_11#33), partial_sum(_pre_12#34), partial_sum(_pre_13#35), partial_sum(_pre_14#36), partial_sum(_pre_15#37), partial_sum(_pre_16#38), partial_sum(_pre_17#39), partial_sum(_pre_18#40), partial_sum(_pre_19#41), partial_sum(_pre_20#42), partial_sum(_pre_21#43), partial_sum(_pre_22#44), partial_sum(_pre_23#45), partial_sum(_pre_24#46)]
Aggregate Attributes [48]: [sum#47, isEmpty#48, sum#49, isEmpty#50, sum#51, isEmpty#52, sum#53, isEmpty#54, sum#55, isEmpty#56, sum#57, isEmpty#58, sum#59, isEmpty#60, sum#61, isEmpty#62, sum#63, isEmpty#64, sum#65, isEmpty#66, sum#67, isEmpty#68, sum#69, isEmpty#70, sum#71, isEmpty#72, sum#73, isEmpty#74, sum#75, isEmpty#76, sum#77, isEmpty#78, sum#79, isEmpty#80, sum#81, isEmpty#82, sum#83, isEmpty#84, sum#85, isEmpty#86, sum#87, isEmpty#88, sum#89, isEmpty#90, sum#91, isEmpty#92, sum#93, isEmpty#94]
Results [55]: [w_warehouse_name#10, w_warehouse_sq_ft#11, w_city#12, w_county#13, w_state#14, w_country#15, d_year#17, sum#95, isEmpty#96, sum#97, isEmpty#98, sum#99, isEmpty#100, sum#101, isEmpty#102, sum#103, isEmpty#104, sum#105, isEmpty#106, sum#107, isEmpty#108, sum#109, isEmpty#110, sum#111, isEmpty#112, sum#113, isEmpty#114, sum#115, isEmpty#116, sum#117, isEmpty#118, sum#119, isEmpty#120, sum#121, isEmpty#122, sum#123, isEmpty#124, sum#125, isEmpty#126, sum#127, isEmpty#128, sum#129, isEmpty#130, sum#131, isEmpty#132, sum#133, isEmpty#134, sum#135, isEmpty#136, sum#137, isEmpty#138, sum#139, isEmpty#140, sum#141, isEmpty#142]

(35) ProjectExecTransformer
Output [56]: [hash(w_warehouse_name#10, w_warehouse_sq_ft#11, w_city#12, w_county#13, w_state#14, w_country#15, d_year#17, 42) AS hash_partition_key#143, w_warehouse_name#10, w_warehouse_sq_ft#11, w_city#12, w_county#13, w_state#14, w_country#15, d_year#17, sum#95, isEmpty#96, sum#97, isEmpty#98, sum#99, isEmpty#100, sum#101, isEmpty#102, sum#103, isEmpty#104, sum#105, isEmpty#106, sum#107, isEmpty#108, sum#109, isEmpty#110, sum#111, isEmpty#112, sum#113, isEmpty#114, sum#115, isEmpty#116, sum#117, isEmpty#118, sum#119, isEmpty#120, sum#121, isEmpty#122, sum#123, isEmpty#124, sum#125, isEmpty#126, sum#127, isEmpty#128, sum#129, isEmpty#130, sum#131, isEmpty#132, sum#133, isEmpty#134, sum#135, isEmpty#136, sum#137, isEmpty#138, sum#139, isEmpty#140, sum#141, isEmpty#142]
Input [55]: [w_warehouse_name#10, w_warehouse_sq_ft#11, w_city#12, w_county#13, w_state#14, w_country#15, d_year#17, sum#95, isEmpty#96, sum#97, isEmpty#98, sum#99, isEmpty#100, sum#101, isEmpty#102, sum#103, isEmpty#104, sum#105, isEmpty#106, sum#107, isEmpty#108, sum#109, isEmpty#110, sum#111, isEmpty#112, sum#113, isEmpty#114, sum#115, isEmpty#116, sum#117, isEmpty#118, sum#119, isEmpty#120, sum#121, isEmpty#122, sum#123, isEmpty#124, sum#125, isEmpty#126, sum#127, isEmpty#128, sum#129, isEmpty#130, sum#131, isEmpty#132, sum#133, isEmpty#134, sum#135, isEmpty#136, sum#137, isEmpty#138, sum#139, isEmpty#140, sum#141, isEmpty#142]

(36) WholeStageCodegenTransformer (6)
Input [56]: [hash_partition_key#143, w_warehouse_name#10, w_warehouse_sq_ft#11, w_city#12, w_county#13, w_state#14, w_country#15, d_year#17, sum#95, isEmpty#96, sum#97, isEmpty#98, sum#99, isEmpty#100, sum#101, isEmpty#102, sum#103, isEmpty#104, sum#105, isEmpty#106, sum#107, isEmpty#108, sum#109, isEmpty#110, sum#111, isEmpty#112, sum#113, isEmpty#114, sum#115, isEmpty#116, sum#117, isEmpty#118, sum#119, isEmpty#120, sum#121, isEmpty#122, sum#123, isEmpty#124, sum#125, isEmpty#126, sum#127, isEmpty#128, sum#129, isEmpty#130, sum#131, isEmpty#132, sum#133, isEmpty#134, sum#135, isEmpty#136, sum#137, isEmpty#138, sum#139, isEmpty#140, sum#141, isEmpty#142]
Arguments: false

(37) VeloxResizeBatches
Input [56]: [hash_partition_key#143, w_warehouse_name#10, w_warehouse_sq_ft#11, w_city#12, w_county#13, w_state#14, w_country#15, d_year#17, sum#95, isEmpty#96, sum#97, isEmpty#98, sum#99, isEmpty#100, sum#101, isEmpty#102, sum#103, isEmpty#104, sum#105, isEmpty#106, sum#107, isEmpty#108, sum#109, isEmpty#110, sum#111, isEmpty#112, sum#113, isEmpty#114, sum#115, isEmpty#116, sum#117, isEmpty#118, sum#119, isEmpty#120, sum#121, isEmpty#122, sum#123, isEmpty#124, sum#125, isEmpty#126, sum#127, isEmpty#128, sum#129, isEmpty#130, sum#131, isEmpty#132, sum#133, isEmpty#134, sum#135, isEmpty#136, sum#137, isEmpty#138, sum#139, isEmpty#140, sum#141, isEmpty#142]
Arguments: 1024, 2147483647, 10485760

(38) ColumnarExchange
Input [56]: [hash_partition_key#143, w_warehouse_name#10, w_warehouse_sq_ft#11, w_city#12, w_county#13, w_state#14, w_country#15, d_year#17, sum#95, isEmpty#96, sum#97, isEmpty#98, sum#99, isEmpty#100, sum#101, isEmpty#102, sum#103, isEmpty#104, sum#105, isEmpty#106, sum#107, isEmpty#108, sum#109, isEmpty#110, sum#111, isEmpty#112, sum#113, isEmpty#114, sum#115, isEmpty#116, sum#117, isEmpty#118, sum#119, isEmpty#120, sum#121, isEmpty#122, sum#123, isEmpty#124, sum#125, isEmpty#126, sum#127, isEmpty#128, sum#129, isEmpty#130, sum#131, isEmpty#132, sum#133, isEmpty#134, sum#135, isEmpty#136, sum#137, isEmpty#138, sum#139, isEmpty#140, sum#141, isEmpty#142]
Arguments: hashpartitioning(w_warehouse_name#10, w_warehouse_sq_ft#11, w_city#12, w_county#13, w_state#14, w_country#15, d_year#17, 1), ENSURE_REQUIREMENTS, [w_warehouse_name#10, w_warehouse_sq_ft#11, w_city#12, w_county#13, w_state#14, w_country#15, d_year#17, sum#95, isEmpty#96, sum#97, isEmpty#98, sum#99, isEmpty#100, sum#101, isEmpty#102, sum#103, isEmpty#104, sum#105, isEmpty#106, sum#107, isEmpty#108, sum#109, isEmpty#110, sum#111, isEmpty#112, sum#113, isEmpty#114, sum#115, isEmpty#116, sum#117, isEmpty#118, sum#119, isEmpty#120, sum#121, isEmpty#122, sum#123, isEmpty#124, sum#125, isEmpty#126, sum#127, isEmpty#128, sum#129, isEmpty#130, sum#131, isEmpty#132, sum#133, isEmpty#134, sum#135, isEmpty#136, sum#137, isEmpty#138, sum#139, isEmpty#140, sum#141, isEmpty#142], [plan_id=4], [shuffle_writer_type=hash]

(39) InputAdapter
Input [55]: [w_warehouse_name#10, w_warehouse_sq_ft#11, w_city#12, w_county#13, w_state#14, w_country#15, d_year#17, sum#95, isEmpty#96, sum#97, isEmpty#98, sum#99, isEmpty#100, sum#101, isEmpty#102, sum#103, isEmpty#104, sum#105, isEmpty#106, sum#107, isEmpty#108, sum#109, isEmpty#110, sum#111, isEmpty#112, sum#113, isEmpty#114, sum#115, isEmpty#116, sum#117, isEmpty#118, sum#119, isEmpty#120, sum#121, isEmpty#122, sum#123, isEmpty#124, sum#125, isEmpty#126, sum#127, isEmpty#128, sum#129, isEmpty#130, sum#131, isEmpty#132, sum#133, isEmpty#134, sum#135, isEmpty#136, sum#137, isEmpty#138, sum#139, isEmpty#140, sum#141, isEmpty#142]

(40) InputIteratorTransformer
Input [55]: [w_warehouse_name#10, w_warehouse_sq_ft#11, w_city#12, w_county#13, w_state#14, w_country#15, d_year#17, sum#95, isEmpty#96, sum#97, isEmpty#98, sum#99, isEmpty#100, sum#101, isEmpty#102, sum#103, isEmpty#104, sum#105, isEmpty#106, sum#107, isEmpty#108, sum#109, isEmpty#110, sum#111, isEmpty#112, sum#113, isEmpty#114, sum#115, isEmpty#116, sum#117, isEmpty#118, sum#119, isEmpty#120, sum#121, isEmpty#122, sum#123, isEmpty#124, sum#125, isEmpty#126, sum#127, isEmpty#128, sum#129, isEmpty#130, sum#131, isEmpty#132, sum#133, isEmpty#134, sum#135, isEmpty#136, sum#137, isEmpty#138, sum#139, isEmpty#140, sum#141, isEmpty#142]

(41) RegularHashAggregateExecTransformer
Input [55]: [w_warehouse_name#10, w_warehouse_sq_ft#11, w_city#12, w_county#13, w_state#14, w_country#15, d_year#17, sum#95, isEmpty#96, sum#97, isEmpty#98, sum#99, isEmpty#100, sum#101, isEmpty#102, sum#103, isEmpty#104, sum#105, isEmpty#106, sum#107, isEmpty#108, sum#109, isEmpty#110, sum#111, isEmpty#112, sum#113, isEmpty#114, sum#115, isEmpty#116, sum#117, isEmpty#118, sum#119, isEmpty#120, sum#121, isEmpty#122, sum#123, isEmpty#124, sum#125, isEmpty#126, sum#127, isEmpty#128, sum#129, isEmpty#130, sum#131, isEmpty#132, sum#133, isEmpty#134, sum#135, isEmpty#136, sum#137, isEmpty#138, sum#139, isEmpty#140, sum#141, isEmpty#142]
Keys [7]: [w_warehouse_name#10, w_warehouse_sq_ft#11, w_city#12, w_county#13, w_state#14, w_country#15, d_year#17]
Functions [24]: [sum(CASE WHEN (d_moy#18 = 1) THEN (ws_ext_sales_price#5 * cast(ws_quantity#4 as decimal(10,0))) ELSE 0.00 END), sum(CASE WHEN (d_moy#18 = 2) THEN (ws_ext_sales_price#5 * cast(ws_quantity#4 as decimal(10,0))) ELSE 0.00 END), sum(CASE WHEN (d_moy#18 = 3) THEN (ws_ext_sales_price#5 * cast(ws_quantity#4 as decimal(10,0))) ELSE 0.00 END), sum(CASE WHEN (d_moy#18 = 4) THEN (ws_ext_sales_price#5 * cast(ws_quantity#4 as decimal(10,0))) ELSE 0.00 END), sum(CASE WHEN (d_moy#18 = 5) THEN (ws_ext_sales_price#5 * cast(ws_quantity#4 as decimal(10,0))) ELSE 0.00 END), sum(CASE WHEN (d_moy#18 = 6) THEN (ws_ext_sales_price#5 * cast(ws_quantity#4 as decimal(10,0))) ELSE 0.00 END), sum(CASE WHEN (d_moy#18 = 7) THEN (ws_ext_sales_price#5 * cast(ws_quantity#4 as decimal(10,0))) ELSE 0.00 END), sum(CASE WHEN (d_moy#18 = 8) THEN (ws_ext_sales_price#5 * cast(ws_quantity#4 as decimal(10,0))) ELSE 0.00 END), sum(CASE WHEN (d_moy#18 = 9) THEN (ws_ext_sales_price#5 * cast(ws_quantity#4 as decimal(10,0))) ELSE 0.00 END), sum(CASE WHEN (d_moy#18 = 10) THEN (ws_ext_sales_price#5 * cast(ws_quantity#4 as decimal(10,0))) ELSE 0.00 END), sum(CASE WHEN (d_moy#18 = 11) THEN (ws_ext_sales_price#5 * cast(ws_quantity#4 as decimal(10,0))) ELSE 0.00 END), sum(CASE WHEN (d_moy#18 = 12) THEN (ws_ext_sales_price#5 * cast(ws_quantity#4 as decimal(10,0))) ELSE 0.00 END), sum(CASE WHEN (d_moy#18 = 1) THEN (ws_net_paid#6 * cast(ws_quantity#4 as decimal(10,0))) ELSE 0.00 END), sum(CASE WHEN (d_moy#18 = 2) THEN (ws_net_paid#6 * cast(ws_quantity#4 as decimal(10,0))) ELSE 0.00 END), sum(CASE WHEN (d_moy#18 = 3) THEN (ws_net_paid#6 * cast(ws_quantity#4 as decimal(10,0))) ELSE 0.00 END), sum(CASE WHEN (d_moy#18 = 4) THEN (ws_net_paid#6 * cast(ws_quantity#4 as decimal(10,0))) ELSE 0.00 END), sum(CASE WHEN (d_moy#18 = 5) THEN (ws_net_paid#6 * cast(ws_quantity#4 as decimal(10,0))) ELSE 0.00 END), sum(CASE WHEN (d_moy#18 = 6) THEN (ws_net_paid#6 * cast(ws_quantity#4 as decimal(10,0))) ELSE 0.00 END), sum(CASE WHEN (d_moy#18 = 7) THEN (ws_net_paid#6 * cast(ws_quantity#4 as decimal(10,0))) ELSE 0.00 END), sum(CASE WHEN (d_moy#18 = 8) THEN (ws_net_paid#6 * cast(ws_quantity#4 as decimal(10,0))) ELSE 0.00 END), sum(CASE WHEN (d_moy#18 = 9) THEN (ws_net_paid#6 * cast(ws_quantity#4 as decimal(10,0))) ELSE 0.00 END), sum(CASE WHEN (d_moy#18 = 10) THEN (ws_net_paid#6 * cast(ws_quantity#4 as decimal(10,0))) ELSE 0.00 END), sum(CASE WHEN (d_moy#18 = 11) THEN (ws_net_paid#6 * cast(ws_quantity#4 as decimal(10,0))) ELSE 0.00 END), sum(CASE WHEN (d_moy#18 = 12) THEN (ws_net_paid#6 * cast(ws_quantity#4 as decimal(10,0))) ELSE 0.00 END)]
Aggregate Attributes [24]: [sum(CASE WHEN (d_moy#18 = 1) THEN (ws_ext_sales_price#5 * cast(ws_quantity#4 as decimal(10,0))) ELSE 0.00 END)#144, sum(CASE WHEN (d_moy#18 = 2) THEN (ws_ext_sales_price#5 * cast(ws_quantity#4 as decimal(10,0))) ELSE 0.00 END)#145, sum(CASE WHEN (d_moy#18 = 3) THEN (ws_ext_sales_price#5 * cast(ws_quantity#4 as decimal(10,0))) ELSE 0.00 END)#146, sum(CASE WHEN (d_moy#18 = 4) THEN (ws_ext_sales_price#5 * cast(ws_quantity#4 as decimal(10,0))) ELSE 0.00 END)#147, sum(CASE WHEN (d_moy#18 = 5) THEN (ws_ext_sales_price#5 * cast(ws_quantity#4 as decimal(10,0))) ELSE 0.00 END)#148, sum(CASE WHEN (d_moy#18 = 6) THEN (ws_ext_sales_price#5 * cast(ws_quantity#4 as decimal(10,0))) ELSE 0.00 END)#149, sum(CASE WHEN (d_moy#18 = 7) THEN (ws_ext_sales_price#5 * cast(ws_quantity#4 as decimal(10,0))) ELSE 0.00 END)#150, sum(CASE WHEN (d_moy#18 = 8) THEN (ws_ext_sales_price#5 * cast(ws_quantity#4 as decimal(10,0))) ELSE 0.00 END)#151, sum(CASE WHEN (d_moy#18 = 9) THEN (ws_ext_sales_price#5 * cast(ws_quantity#4 as decimal(10,0))) ELSE 0.00 END)#152, sum(CASE WHEN (d_moy#18 = 10) THEN (ws_ext_sales_price#5 * cast(ws_quantity#4 as decimal(10,0))) ELSE 0.00 END)#153, sum(CASE WHEN (d_moy#18 = 11) THEN (ws_ext_sales_price#5 * cast(ws_quantity#4 as decimal(10,0))) ELSE 0.00 END)#154, sum(CASE WHEN (d_moy#18 = 12) THEN (ws_ext_sales_price#5 * cast(ws_quantity#4 as decimal(10,0))) ELSE 0.00 END)#155, sum(CASE WHEN (d_moy#18 = 1) THEN (ws_net_paid#6 * cast(ws_quantity#4 as decimal(10,0))) ELSE 0.00 END)#156, sum(CASE WHEN (d_moy#18 = 2) THEN (ws_net_paid#6 * cast(ws_quantity#4 as decimal(10,0))) ELSE 0.00 END)#157, sum(CASE WHEN (d_moy#18 = 3) THEN (ws_net_paid#6 * cast(ws_quantity#4 as decimal(10,0))) ELSE 0.00 END)#158, sum(CASE WHEN (d_moy#18 = 4) THEN (ws_net_paid#6 * cast(ws_quantity#4 as decimal(10,0))) ELSE 0.00 END)#159, sum(CASE WHEN (d_moy#18 = 5) THEN (ws_net_paid#6 * cast(ws_quantity#4 as decimal(10,0))) ELSE 0.00 END)#160, sum(CASE WHEN (d_moy#18 = 6) THEN (ws_net_paid#6 * cast(ws_quantity#4 as decimal(10,0))) ELSE 0.00 END)#161, sum(CASE WHEN (d_moy#18 = 7) THEN (ws_net_paid#6 * cast(ws_quantity#4 as decimal(10,0))) ELSE 0.00 END)#162, sum(CASE WHEN (d_moy#18 = 8) THEN (ws_net_paid#6 * cast(ws_quantity#4 as decimal(10,0))) ELSE 0.00 END)#163, sum(CASE WHEN (d_moy#18 = 9) THEN (ws_net_paid#6 * cast(ws_quantity#4 as decimal(10,0))) ELSE 0.00 END)#164, sum(CASE WHEN (d_moy#18 = 10) THEN (ws_net_paid#6 * cast(ws_quantity#4 as decimal(10,0))) ELSE 0.00 END)#165, sum(CASE WHEN (d_moy#18 = 11) THEN (ws_net_paid#6 * cast(ws_quantity#4 as decimal(10,0))) ELSE 0.00 END)#166, sum(CASE WHEN (d_moy#18 = 12) THEN (ws_net_paid#6 * cast(ws_quantity#4 as decimal(10,0))) ELSE 0.00 END)#167]
Results [31]: [w_warehouse_name#10, w_warehouse_sq_ft#11, w_city#12, w_county#13, w_state#14, w_country#15, d_year#17, sum(CASE WHEN (d_moy#18 = 1) THEN (ws_ext_sales_price#5 * cast(ws_quantity#4 as decimal(10,0))) ELSE 0.00 END)#144, sum(CASE WHEN (d_moy#18 = 2) THEN (ws_ext_sales_price#5 * cast(ws_quantity#4 as decimal(10,0))) ELSE 0.00 END)#145, sum(CASE WHEN (d_moy#18 = 3) THEN (ws_ext_sales_price#5 * cast(ws_quantity#4 as decimal(10,0))) ELSE 0.00 END)#146, sum(CASE WHEN (d_moy#18 = 4) THEN (ws_ext_sales_price#5 * cast(ws_quantity#4 as decimal(10,0))) ELSE 0.00 END)#147, sum(CASE WHEN (d_moy#18 = 5) THEN (ws_ext_sales_price#5 * cast(ws_quantity#4 as decimal(10,0))) ELSE 0.00 END)#148, sum(CASE WHEN (d_moy#18 = 6) THEN (ws_ext_sales_price#5 * cast(ws_quantity#4 as decimal(10,0))) ELSE 0.00 END)#149, sum(CASE WHEN (d_moy#18 = 7) THEN (ws_ext_sales_price#5 * cast(ws_quantity#4 as decimal(10,0))) ELSE 0.00 END)#150, sum(CASE WHEN (d_moy#18 = 8) THEN (ws_ext_sales_price#5 * cast(ws_quantity#4 as decimal(10,0))) ELSE 0.00 END)#151, sum(CASE WHEN (d_moy#18 = 9) THEN (ws_ext_sales_price#5 * cast(ws_quantity#4 as decimal(10,0))) ELSE 0.00 END)#152, sum(CASE WHEN (d_moy#18 = 10) THEN (ws_ext_sales_price#5 * cast(ws_quantity#4 as decimal(10,0))) ELSE 0.00 END)#153, sum(CASE WHEN (d_moy#18 = 11) THEN (ws_ext_sales_price#5 * cast(ws_quantity#4 as decimal(10,0))) ELSE 0.00 END)#154, sum(CASE WHEN (d_moy#18 = 12) THEN (ws_ext_sales_price#5 * cast(ws_quantity#4 as decimal(10,0))) ELSE 0.00 END)#155, sum(CASE WHEN (d_moy#18 = 1) THEN (ws_net_paid#6 * cast(ws_quantity#4 as decimal(10,0))) ELSE 0.00 END)#156, sum(CASE WHEN (d_moy#18 = 2) THEN (ws_net_paid#6 * cast(ws_quantity#4 as decimal(10,0))) ELSE 0.00 END)#157, sum(CASE WHEN (d_moy#18 = 3) THEN (ws_net_paid#6 * cast(ws_quantity#4 as decimal(10,0))) ELSE 0.00 END)#158, sum(CASE WHEN (d_moy#18 = 4) THEN (ws_net_paid#6 * cast(ws_quantity#4 as decimal(10,0))) ELSE 0.00 END)#159, sum(CASE WHEN (d_moy#18 = 5) THEN (ws_net_paid#6 * cast(ws_quantity#4 as decimal(10,0))) ELSE 0.00 END)#160, sum(CASE WHEN (d_moy#18 = 6) THEN (ws_net_paid#6 * cast(ws_quantity#4 as decimal(10,0))) ELSE 0.00 END)#161, sum(CASE WHEN (d_moy#18 = 7) THEN (ws_net_paid#6 * cast(ws_quantity#4 as decimal(10,0))) ELSE 0.00 END)#162, sum(CASE WHEN (d_moy#18 = 8) THEN (ws_net_paid#6 * cast(ws_quantity#4 as decimal(10,0))) ELSE 0.00 END)#163, sum(CASE WHEN (d_moy#18 = 9) THEN (ws_net_paid#6 * cast(ws_quantity#4 as decimal(10,0))) ELSE 0.00 END)#164, sum(CASE WHEN (d_moy#18 = 10) THEN (ws_net_paid#6 * cast(ws_quantity#4 as decimal(10,0))) ELSE 0.00 END)#165, sum(CASE WHEN (d_moy#18 = 11) THEN (ws_net_paid#6 * cast(ws_quantity#4 as decimal(10,0))) ELSE 0.00 END)#166, sum(CASE WHEN (d_moy#18 = 12) THEN (ws_net_paid#6 * cast(ws_quantity#4 as decimal(10,0))) ELSE 0.00 END)#167]

(42) ProjectExecTransformer
Output [32]: [w_warehouse_name#10, w_warehouse_sq_ft#11, w_city#12, w_county#13, w_state#14, w_country#15, DHL,BARIAN AS ship_carriers#168, d_year#17 AS year#169, sum(CASE WHEN (d_moy#18 = 1) THEN (ws_ext_sales_price#5 * cast(ws_quantity#4 as decimal(10,0))) ELSE 0.00 END)#144 AS jan_sales#170, sum(CASE WHEN (d_moy#18 = 2) THEN (ws_ext_sales_price#5 * cast(ws_quantity#4 as decimal(10,0))) ELSE 0.00 END)#145 AS feb_sales#171, sum(CASE WHEN (d_moy#18 = 3) THEN (ws_ext_sales_price#5 * cast(ws_quantity#4 as decimal(10,0))) ELSE 0.00 END)#146 AS mar_sales#172, sum(CASE WHEN (d_moy#18 = 4) THEN (ws_ext_sales_price#5 * cast(ws_quantity#4 as decimal(10,0))) ELSE 0.00 END)#147 AS apr_sales#173, sum(CASE WHEN (d_moy#18 = 5) THEN (ws_ext_sales_price#5 * cast(ws_quantity#4 as decimal(10,0))) ELSE 0.00 END)#148 AS may_sales#174, sum(CASE WHEN (d_moy#18 = 6) THEN (ws_ext_sales_price#5 * cast(ws_quantity#4 as decimal(10,0))) ELSE 0.00 END)#149 AS jun_sales#175, sum(CASE WHEN (d_moy#18 = 7) THEN (ws_ext_sales_price#5 * cast(ws_quantity#4 as decimal(10,0))) ELSE 0.00 END)#150 AS jul_sales#176, sum(CASE WHEN (d_moy#18 = 8) THEN (ws_ext_sales_price#5 * cast(ws_quantity#4 as decimal(10,0))) ELSE 0.00 END)#151 AS aug_sales#177, sum(CASE WHEN (d_moy#18 = 9) THEN (ws_ext_sales_price#5 * cast(ws_quantity#4 as decimal(10,0))) ELSE 0.00 END)#152 AS sep_sales#178, sum(CASE WHEN (d_moy#18 = 10) THEN (ws_ext_sales_price#5 * cast(ws_quantity#4 as decimal(10,0))) ELSE 0.00 END)#153 AS oct_sales#179, sum(CASE WHEN (d_moy#18 = 11) THEN (ws_ext_sales_price#5 * cast(ws_quantity#4 as decimal(10,0))) ELSE 0.00 END)#154 AS nov_sales#180, sum(CASE WHEN (d_moy#18 = 12) THEN (ws_ext_sales_price#5 * cast(ws_quantity#4 as decimal(10,0))) ELSE 0.00 END)#155 AS dec_sales#181, sum(CASE WHEN (d_moy#18 = 1) THEN (ws_net_paid#6 * cast(ws_quantity#4 as decimal(10,0))) ELSE 0.00 END)#156 AS jan_net#182, sum(CASE WHEN (d_moy#18 = 2) THEN (ws_net_paid#6 * cast(ws_quantity#4 as decimal(10,0))) ELSE 0.00 END)#157 AS feb_net#183, sum(CASE WHEN (d_moy#18 = 3) THEN (ws_net_paid#6 * cast(ws_quantity#4 as decimal(10,0))) ELSE 0.00 END)#158 AS mar_net#184, sum(CASE WHEN (d_moy#18 = 4) THEN (ws_net_paid#6 * cast(ws_quantity#4 as decimal(10,0))) ELSE 0.00 END)#159 AS apr_net#185, sum(CASE WHEN (d_moy#18 = 5) THEN (ws_net_paid#6 * cast(ws_quantity#4 as decimal(10,0))) ELSE 0.00 END)#160 AS may_net#186, sum(CASE WHEN (d_moy#18 = 6) THEN (ws_net_paid#6 * cast(ws_quantity#4 as decimal(10,0))) ELSE 0.00 END)#161 AS jun_net#187, sum(CASE WHEN (d_moy#18 = 7) THEN (ws_net_paid#6 * cast(ws_quantity#4 as decimal(10,0))) ELSE 0.00 END)#162 AS jul_net#188, sum(CASE WHEN (d_moy#18 = 8) THEN (ws_net_paid#6 * cast(ws_quantity#4 as decimal(10,0))) ELSE 0.00 END)#163 AS aug_net#189, sum(CASE WHEN (d_moy#18 = 9) THEN (ws_net_paid#6 * cast(ws_quantity#4 as decimal(10,0))) ELSE 0.00 END)#164 AS sep_net#190, sum(CASE WHEN (d_moy#18 = 10) THEN (ws_net_paid#6 * cast(ws_quantity#4 as decimal(10,0))) ELSE 0.00 END)#165 AS oct_net#191, sum(CASE WHEN (d_moy#18 = 11) THEN (ws_net_paid#6 * cast(ws_quantity#4 as decimal(10,0))) ELSE 0.00 END)#166 AS nov_net#192, sum(CASE WHEN (d_moy#18 = 12) THEN (ws_net_paid#6 * cast(ws_quantity#4 as decimal(10,0))) ELSE 0.00 END)#167 AS dec_net#193]
Input [31]: [w_warehouse_name#10, w_warehouse_sq_ft#11, w_city#12, w_county#13, w_state#14, w_country#15, d_year#17, sum(CASE WHEN (d_moy#18 = 1) THEN (ws_ext_sales_price#5 * cast(ws_quantity#4 as decimal(10,0))) ELSE 0.00 END)#144, sum(CASE WHEN (d_moy#18 = 2) THEN (ws_ext_sales_price#5 * cast(ws_quantity#4 as decimal(10,0))) ELSE 0.00 END)#145, sum(CASE WHEN (d_moy#18 = 3) THEN (ws_ext_sales_price#5 * cast(ws_quantity#4 as decimal(10,0))) ELSE 0.00 END)#146, sum(CASE WHEN (d_moy#18 = 4) THEN (ws_ext_sales_price#5 * cast(ws_quantity#4 as decimal(10,0))) ELSE 0.00 END)#147, sum(CASE WHEN (d_moy#18 = 5) THEN (ws_ext_sales_price#5 * cast(ws_quantity#4 as decimal(10,0))) ELSE 0.00 END)#148, sum(CASE WHEN (d_moy#18 = 6) THEN (ws_ext_sales_price#5 * cast(ws_quantity#4 as decimal(10,0))) ELSE 0.00 END)#149, sum(CASE WHEN (d_moy#18 = 7) THEN (ws_ext_sales_price#5 * cast(ws_quantity#4 as decimal(10,0))) ELSE 0.00 END)#150, sum(CASE WHEN (d_moy#18 = 8) THEN (ws_ext_sales_price#5 * cast(ws_quantity#4 as decimal(10,0))) ELSE 0.00 END)#151, sum(CASE WHEN (d_moy#18 = 9) THEN (ws_ext_sales_price#5 * cast(ws_quantity#4 as decimal(10,0))) ELSE 0.00 END)#152, sum(CASE WHEN (d_moy#18 = 10) THEN (ws_ext_sales_price#5 * cast(ws_quantity#4 as decimal(10,0))) ELSE 0.00 END)#153, sum(CASE WHEN (d_moy#18 = 11) THEN (ws_ext_sales_price#5 * cast(ws_quantity#4 as decimal(10,0))) ELSE 0.00 END)#154, sum(CASE WHEN (d_moy#18 = 12) THEN (ws_ext_sales_price#5 * cast(ws_quantity#4 as decimal(10,0))) ELSE 0.00 END)#155, sum(CASE WHEN (d_moy#18 = 1) THEN (ws_net_paid#6 * cast(ws_quantity#4 as decimal(10,0))) ELSE 0.00 END)#156, sum(CASE WHEN (d_moy#18 = 2) THEN (ws_net_paid#6 * cast(ws_quantity#4 as decimal(10,0))) ELSE 0.00 END)#157, sum(CASE WHEN (d_moy#18 = 3) THEN (ws_net_paid#6 * cast(ws_quantity#4 as decimal(10,0))) ELSE 0.00 END)#158, sum(CASE WHEN (d_moy#18 = 4) THEN (ws_net_paid#6 * cast(ws_quantity#4 as decimal(10,0))) ELSE 0.00 END)#159, sum(CASE WHEN (d_moy#18 = 5) THEN (ws_net_paid#6 * cast(ws_quantity#4 as decimal(10,0))) ELSE 0.00 END)#160, sum(CASE WHEN (d_moy#18 = 6) THEN (ws_net_paid#6 * cast(ws_quantity#4 as decimal(10,0))) ELSE 0.00 END)#161, sum(CASE WHEN (d_moy#18 = 7) THEN (ws_net_paid#6 * cast(ws_quantity#4 as decimal(10,0))) ELSE 0.00 END)#162, sum(CASE WHEN (d_moy#18 = 8) THEN (ws_net_paid#6 * cast(ws_quantity#4 as decimal(10,0))) ELSE 0.00 END)#163, sum(CASE WHEN (d_moy#18 = 9) THEN (ws_net_paid#6 * cast(ws_quantity#4 as decimal(10,0))) ELSE 0.00 END)#164, sum(CASE WHEN (d_moy#18 = 10) THEN (ws_net_paid#6 * cast(ws_quantity#4 as decimal(10,0))) ELSE 0.00 END)#165, sum(CASE WHEN (d_moy#18 = 11) THEN (ws_net_paid#6 * cast(ws_quantity#4 as decimal(10,0))) ELSE 0.00 END)#166, sum(CASE WHEN (d_moy#18 = 12) THEN (ws_net_paid#6 * cast(ws_quantity#4 as decimal(10,0))) ELSE 0.00 END)#167]

(43) WholeStageCodegenTransformer (7)
Input [32]: [w_warehouse_name#10, w_warehouse_sq_ft#11, w_city#12, w_county#13, w_state#14, w_country#15, ship_carriers#168, year#169, jan_sales#170, feb_sales#171, mar_sales#172, apr_sales#173, may_sales#174, jun_sales#175, jul_sales#176, aug_sales#177, sep_sales#178, oct_sales#179, nov_sales#180, dec_sales#181, jan_net#182, feb_net#183, mar_net#184, apr_net#185, may_net#186, jun_net#187, jul_net#188, aug_net#189, sep_net#190, oct_net#191, nov_net#192, dec_net#193]
Arguments: false

(44) FileSourceScanExecTransformer parquet spark_catalog.default.catalog_sales
Output [7]: [cs_sold_time_sk#194, cs_ship_mode_sk#195, cs_warehouse_sk#196, cs_quantity#197, cs_sales_price#198, cs_net_paid_inc_tax#199, cs_sold_date_sk#200]
Batched: true
Location: InMemoryFileIndex []
PartitionFilters: [isnotnull(cs_sold_date_sk#200), dynamicpruningexpression(cs_sold_date_sk#200 IN dynamicpruning#8)]
PushedFilters: [IsNotNull(cs_warehouse_sk), IsNotNull(cs_sold_time_sk), IsNotNull(cs_ship_mode_sk)]
ReadSchema: struct<cs_sold_time_sk:int,cs_ship_mode_sk:int,cs_warehouse_sk:int,cs_quantity:int,cs_sales_price:decimal(7,2),cs_net_paid_inc_tax:decimal(7,2)>

(45) FilterExecTransformer
Input [7]: [cs_sold_time_sk#194, cs_ship_mode_sk#195, cs_warehouse_sk#196, cs_quantity#197, cs_sales_price#198, cs_net_paid_inc_tax#199, cs_sold_date_sk#200]
Arguments: ((isnotnull(cs_warehouse_sk#196) AND isnotnull(cs_sold_time_sk#194)) AND isnotnull(cs_ship_mode_sk#195))

(46) ReusedExchange [Reuses operator id: 6]
Output [7]: [w_warehouse_sk#201, w_warehouse_name#202, w_warehouse_sq_ft#203, w_city#204, w_county#205, w_state#206, w_country#207]

(47) InputAdapter
Input [7]: [w_warehouse_sk#201, w_warehouse_name#202, w_warehouse_sq_ft#203, w_city#204, w_county#205, w_state#206, w_country#207]

(48) InputIteratorTransformer
Input [7]: [w_warehouse_sk#201, w_warehouse_name#202, w_warehouse_sq_ft#203, w_city#204, w_county#205, w_state#206, w_country#207]

(49) BroadcastHashJoinExecTransformer
Left keys [1]: [cs_warehouse_sk#196]
Right keys [1]: [w_warehouse_sk#201]
Join type: Inner
Join condition: None

(50) ProjectExecTransformer
Output [12]: [cs_sold_time_sk#194, cs_ship_mode_sk#195, cs_quantity#197, cs_sales_price#198, cs_net_paid_inc_tax#199, cs_sold_date_sk#200, w_warehouse_name#202, w_warehouse_sq_ft#203, w_city#204, w_county#205, w_state#206, w_country#207]
Input [14]: [cs_sold_time_sk#194, cs_ship_mode_sk#195, cs_warehouse_sk#196, cs_quantity#197, cs_sales_price#198, cs_net_paid_inc_tax#199, cs_sold_date_sk#200, w_warehouse_sk#201, w_warehouse_name#202, w_warehouse_sq_ft#203, w_city#204, w_county#205, w_state#206, w_country#207]

(51) ReusedExchange [Reuses operator id: 94]
Output [3]: [d_date_sk#208, d_year#209, d_moy#210]

(52) InputAdapter
Input [3]: [d_date_sk#208, d_year#209, d_moy#210]

(53) InputIteratorTransformer
Input [3]: [d_date_sk#208, d_year#209, d_moy#210]

(54) BroadcastHashJoinExecTransformer
Left keys [1]: [cs_sold_date_sk#200]
Right keys [1]: [d_date_sk#208]
Join type: Inner
Join condition: None

(55) ProjectExecTransformer
Output [13]: [cs_sold_time_sk#194, cs_ship_mode_sk#195, cs_quantity#197, cs_sales_price#198, cs_net_paid_inc_tax#199, w_warehouse_name#202, w_warehouse_sq_ft#203, w_city#204, w_county#205, w_state#206, w_country#207, d_year#209, d_moy#210]
Input [15]: [cs_sold_time_sk#194, cs_ship_mode_sk#195, cs_quantity#197, cs_sales_price#198, cs_net_paid_inc_tax#199, cs_sold_date_sk#200, w_warehouse_name#202, w_warehouse_sq_ft#203, w_city#204, w_county#205, w_state#206, w_country#207, d_date_sk#208, d_year#209, d_moy#210]

(56) ReusedExchange [Reuses operator id: 20]
Output [1]: [t_time_sk#211]

(57) InputAdapter
Input [1]: [t_time_sk#211]

(58) InputIteratorTransformer
Input [1]: [t_time_sk#211]

(59) BroadcastHashJoinExecTransformer
Left keys [1]: [cs_sold_time_sk#194]
Right keys [1]: [t_time_sk#211]
Join type: Inner
Join condition: None

(60) ProjectExecTransformer
Output [12]: [cs_ship_mode_sk#195, cs_quantity#197, cs_sales_price#198, cs_net_paid_inc_tax#199, w_warehouse_name#202, w_warehouse_sq_ft#203, w_city#204, w_county#205, w_state#206, w_country#207, d_year#209, d_moy#210]
Input [14]: [cs_sold_time_sk#194, cs_ship_mode_sk#195, cs_quantity#197, cs_sales_price#198, cs_net_paid_inc_tax#199, w_warehouse_name#202, w_warehouse_sq_ft#203, w_city#204, w_county#205, w_state#206, w_country#207, d_year#209, d_moy#210, t_time_sk#211]

(61) ReusedExchange [Reuses operator id: 29]
Output [1]: [sm_ship_mode_sk#212]

(62) InputAdapter
Input [1]: [sm_ship_mode_sk#212]

(63) InputIteratorTransformer
Input [1]: [sm_ship_mode_sk#212]

(64) BroadcastHashJoinExecTransformer
Left keys [1]: [cs_ship_mode_sk#195]
Right keys [1]: [sm_ship_mode_sk#212]
Join type: Inner
Join condition: None

(65) ProjectExecTransformer
Output [31]: [w_warehouse_name#202, w_warehouse_sq_ft#203, w_city#204, w_county#205, w_state#206, w_country#207, d_year#209, CASE WHEN (d_moy#210 = 1) THEN (cs_sales_price#198 * cast(cs_quantity#197 as decimal(10,0))) ELSE 0.00 END AS _pre_25#213, CASE WHEN (d_moy#210 = 2) THEN (cs_sales_price#198 * cast(cs_quantity#197 as decimal(10,0))) ELSE 0.00 END AS _pre_26#214, CASE WHEN (d_moy#210 = 3) THEN (cs_sales_price#198 * cast(cs_quantity#197 as decimal(10,0))) ELSE 0.00 END AS _pre_27#215, CASE WHEN (d_moy#210 = 4) THEN (cs_sales_price#198 * cast(cs_quantity#197 as decimal(10,0))) ELSE 0.00 END AS _pre_28#216, CASE WHEN (d_moy#210 = 5) THEN (cs_sales_price#198 * cast(cs_quantity#197 as decimal(10,0))) ELSE 0.00 END AS _pre_29#217, CASE WHEN (d_moy#210 = 6) THEN (cs_sales_price#198 * cast(cs_quantity#197 as decimal(10,0))) ELSE 0.00 END AS _pre_30#218, CASE WHEN (d_moy#210 = 7) THEN (cs_sales_price#198 * cast(cs_quantity#197 as decimal(10,0))) ELSE 0.00 END AS _pre_31#219, CASE WHEN (d_moy#210 = 8) THEN (cs_sales_price#198 * cast(cs_quantity#197 as decimal(10,0))) ELSE 0.00 END AS _pre_32#220, CASE WHEN (d_moy#210 = 9) THEN (cs_sales_price#198 * cast(cs_quantity#197 as decimal(10,0))) ELSE 0.00 END AS _pre_33#221, CASE WHEN (d_moy#210 = 10) THEN (cs_sales_price#198 * cast(cs_quantity#197 as decimal(10,0))) ELSE 0.00 END AS _pre_34#222, CASE WHEN (d_moy#210 = 11) THEN (cs_sales_price#198 * cast(cs_quantity#197 as decimal(10,0))) ELSE 0.00 END AS _pre_35#223, CASE WHEN (d_moy#210 = 12) THEN (cs_sales_price#198 * cast(cs_quantity#197 as decimal(10,0))) ELSE 0.00 END AS _pre_36#224, CASE WHEN (d_moy#210 = 1) THEN (cs_net_paid_inc_tax#199 * cast(cs_quantity#197 as decimal(10,0))) ELSE 0.00 END AS _pre_37#225, CASE WHEN (d_moy#210 = 2) THEN (cs_net_paid_inc_tax#199 * cast(cs_quantity#197 as decimal(10,0))) ELSE 0.00 END AS _pre_38#226, CASE WHEN (d_moy#210 = 3) THEN (cs_net_paid_inc_tax#199 * cast(cs_quantity#197 as decimal(10,0))) ELSE 0.00 END AS _pre_39#227, CASE WHEN (d_moy#210 = 4) THEN (cs_net_paid_inc_tax#199 * cast(cs_quantity#197 as decimal(10,0))) ELSE 0.00 END AS _pre_40#228, CASE WHEN (d_moy#210 = 5) THEN (cs_net_paid_inc_tax#199 * cast(cs_quantity#197 as decimal(10,0))) ELSE 0.00 END AS _pre_41#229, CASE WHEN (d_moy#210 = 6) THEN (cs_net_paid_inc_tax#199 * cast(cs_quantity#197 as decimal(10,0))) ELSE 0.00 END AS _pre_42#230, CASE WHEN (d_moy#210 = 7) THEN (cs_net_paid_inc_tax#199 * cast(cs_quantity#197 as decimal(10,0))) ELSE 0.00 END AS _pre_43#231, CASE WHEN (d_moy#210 = 8) THEN (cs_net_paid_inc_tax#199 * cast(cs_quantity#197 as decimal(10,0))) ELSE 0.00 END AS _pre_44#232, CASE WHEN (d_moy#210 = 9) THEN (cs_net_paid_inc_tax#199 * cast(cs_quantity#197 as decimal(10,0))) ELSE 0.00 END AS _pre_45#233, CASE WHEN (d_moy#210 = 10) THEN (cs_net_paid_inc_tax#199 * cast(cs_quantity#197 as decimal(10,0))) ELSE 0.00 END AS _pre_46#234, CASE WHEN (d_moy#210 = 11) THEN (cs_net_paid_inc_tax#199 * cast(cs_quantity#197 as decimal(10,0))) ELSE 0.00 END AS _pre_47#235, CASE WHEN (d_moy#210 = 12) THEN (cs_net_paid_inc_tax#199 * cast(cs_quantity#197 as decimal(10,0))) ELSE 0.00 END AS _pre_48#236]
Input [13]: [cs_ship_mode_sk#195, cs_quantity#197, cs_sales_price#198, cs_net_paid_inc_tax#199, w_warehouse_name#202, w_warehouse_sq_ft#203, w_city#204, w_county#205, w_state#206, w_country#207, d_year#209, d_moy#210, sm_ship_mode_sk#212]

(66) FlushableHashAggregateExecTransformer
Input [31]: [w_warehouse_name#202, w_warehouse_sq_ft#203, w_city#204, w_county#205, w_state#206, w_country#207, d_year#209, _pre_25#213, _pre_26#214, _pre_27#215, _pre_28#216, _pre_29#217, _pre_30#218, _pre_31#219, _pre_32#220, _pre_33#221, _pre_34#222, _pre_35#223, _pre_36#224, _pre_37#225, _pre_38#226, _pre_39#227, _pre_40#228, _pre_41#229, _pre_42#230, _pre_43#231, _pre_44#232, _pre_45#233, _pre_46#234, _pre_47#235, _pre_48#236]
Keys [7]: [w_warehouse_name#202, w_warehouse_sq_ft#203, w_city#204, w_county#205, w_state#206, w_country#207, d_year#209]
Functions [24]: [partial_sum(_pre_25#213), partial_sum(_pre_26#214), partial_sum(_pre_27#215), partial_sum(_pre_28#216), partial_sum(_pre_29#217), partial_sum(_pre_30#218), partial_sum(_pre_31#219), partial_sum(_pre_32#220), partial_sum(_pre_33#221), partial_sum(_pre_34#222), partial_sum(_pre_35#223), partial_sum(_pre_36#224), partial_sum(_pre_37#225), partial_sum(_pre_38#226), partial_sum(_pre_39#227), partial_sum(_pre_40#228), partial_sum(_pre_41#229), partial_sum(_pre_42#230), partial_sum(_pre_43#231), partial_sum(_pre_44#232), partial_sum(_pre_45#233), partial_sum(_pre_46#234), partial_sum(_pre_47#235), partial_sum(_pre_48#236)]
Aggregate Attributes [48]: [sum#237, isEmpty#238, sum#239, isEmpty#240, sum#241, isEmpty#242, sum#243, isEmpty#244, sum#245, isEmpty#246, sum#247, isEmpty#248, sum#249, isEmpty#250, sum#251, isEmpty#252, sum#253, isEmpty#254, sum#255, isEmpty#256, sum#257, isEmpty#258, sum#259, isEmpty#260, sum#261, isEmpty#262, sum#263, isEmpty#264, sum#265, isEmpty#266, sum#267, isEmpty#268, sum#269, isEmpty#270, sum#271, isEmpty#272, sum#273, isEmpty#274, sum#275, isEmpty#276, sum#277, isEmpty#278, sum#279, isEmpty#280, sum#281, isEmpty#282, sum#283, isEmpty#284]
Results [55]: [w_warehouse_name#202, w_warehouse_sq_ft#203, w_city#204, w_county#205, w_state#206, w_country#207, d_year#209, sum#285, isEmpty#286, sum#287, isEmpty#288, sum#289, isEmpty#290, sum#291, isEmpty#292, sum#293, isEmpty#294, sum#295, isEmpty#296, sum#297, isEmpty#298, sum#299, isEmpty#300, sum#301, isEmpty#302, sum#303, isEmpty#304, sum#305, isEmpty#306, sum#307, isEmpty#308, sum#309, isEmpty#310, sum#311, isEmpty#312, sum#313, isEmpty#314, sum#315, isEmpty#316, sum#317, isEmpty#318, sum#319, isEmpty#320, sum#321, isEmpty#322, sum#323, isEmpty#324, sum#325, isEmpty#326, sum#327, isEmpty#328, sum#329, isEmpty#330, sum#331, isEmpty#332]

(67) ProjectExecTransformer
Output [56]: [hash(w_warehouse_name#202, w_warehouse_sq_ft#203, w_city#204, w_county#205, w_state#206, w_country#207, d_year#209, 42) AS hash_partition_key#333, w_warehouse_name#202, w_warehouse_sq_ft#203, w_city#204, w_county#205, w_state#206, w_country#207, d_year#209, sum#285, isEmpty#286, sum#287, isEmpty#288, sum#289, isEmpty#290, sum#291, isEmpty#292, sum#293, isEmpty#294, sum#295, isEmpty#296, sum#297, isEmpty#298, sum#299, isEmpty#300, sum#301, isEmpty#302, sum#303, isEmpty#304, sum#305, isEmpty#306, sum#307, isEmpty#308, sum#309, isEmpty#310, sum#311, isEmpty#312, sum#313, isEmpty#314, sum#315, isEmpty#316, sum#317, isEmpty#318, sum#319, isEmpty#320, sum#321, isEmpty#322, sum#323, isEmpty#324, sum#325, isEmpty#326, sum#327, isEmpty#328, sum#329, isEmpty#330, sum#331, isEmpty#332]
Input [55]: [w_warehouse_name#202, w_warehouse_sq_ft#203, w_city#204, w_county#205, w_state#206, w_country#207, d_year#209, sum#285, isEmpty#286, sum#287, isEmpty#288, sum#289, isEmpty#290, sum#291, isEmpty#292, sum#293, isEmpty#294, sum#295, isEmpty#296, sum#297, isEmpty#298, sum#299, isEmpty#300, sum#301, isEmpty#302, sum#303, isEmpty#304, sum#305, isEmpty#306, sum#307, isEmpty#308, sum#309, isEmpty#310, sum#311, isEmpty#312, sum#313, isEmpty#314, sum#315, isEmpty#316, sum#317, isEmpty#318, sum#319, isEmpty#320, sum#321, isEmpty#322, sum#323, isEmpty#324, sum#325, isEmpty#326, sum#327, isEmpty#328, sum#329, isEmpty#330, sum#331, isEmpty#332]

(68) WholeStageCodegenTransformer (13)
Input [56]: [hash_partition_key#333, w_warehouse_name#202, w_warehouse_sq_ft#203, w_city#204, w_county#205, w_state#206, w_country#207, d_year#209, sum#285, isEmpty#286, sum#287, isEmpty#288, sum#289, isEmpty#290, sum#291, isEmpty#292, sum#293, isEmpty#294, sum#295, isEmpty#296, sum#297, isEmpty#298, sum#299, isEmpty#300, sum#301, isEmpty#302, sum#303, isEmpty#304, sum#305, isEmpty#306, sum#307, isEmpty#308, sum#309, isEmpty#310, sum#311, isEmpty#312, sum#313, isEmpty#314, sum#315, isEmpty#316, sum#317, isEmpty#318, sum#319, isEmpty#320, sum#321, isEmpty#322, sum#323, isEmpty#324, sum#325, isEmpty#326, sum#327, isEmpty#328, sum#329, isEmpty#330, sum#331, isEmpty#332]
Arguments: false

(69) VeloxResizeBatches
Input [56]: [hash_partition_key#333, w_warehouse_name#202, w_warehouse_sq_ft#203, w_city#204, w_county#205, w_state#206, w_country#207, d_year#209, sum#285, isEmpty#286, sum#287, isEmpty#288, sum#289, isEmpty#290, sum#291, isEmpty#292, sum#293, isEmpty#294, sum#295, isEmpty#296, sum#297, isEmpty#298, sum#299, isEmpty#300, sum#301, isEmpty#302, sum#303, isEmpty#304, sum#305, isEmpty#306, sum#307, isEmpty#308, sum#309, isEmpty#310, sum#311, isEmpty#312, sum#313, isEmpty#314, sum#315, isEmpty#316, sum#317, isEmpty#318, sum#319, isEmpty#320, sum#321, isEmpty#322, sum#323, isEmpty#324, sum#325, isEmpty#326, sum#327, isEmpty#328, sum#329, isEmpty#330, sum#331, isEmpty#332]
Arguments: 1024, 2147483647, 10485760

(70) ColumnarExchange
Input [56]: [hash_partition_key#333, w_warehouse_name#202, w_warehouse_sq_ft#203, w_city#204, w_county#205, w_state#206, w_country#207, d_year#209, sum#285, isEmpty#286, sum#287, isEmpty#288, sum#289, isEmpty#290, sum#291, isEmpty#292, sum#293, isEmpty#294, sum#295, isEmpty#296, sum#297, isEmpty#298, sum#299, isEmpty#300, sum#301, isEmpty#302, sum#303, isEmpty#304, sum#305, isEmpty#306, sum#307, isEmpty#308, sum#309, isEmpty#310, sum#311, isEmpty#312, sum#313, isEmpty#314, sum#315, isEmpty#316, sum#317, isEmpty#318, sum#319, isEmpty#320, sum#321, isEmpty#322, sum#323, isEmpty#324, sum#325, isEmpty#326, sum#327, isEmpty#328, sum#329, isEmpty#330, sum#331, isEmpty#332]
Arguments: hashpartitioning(w_warehouse_name#202, w_warehouse_sq_ft#203, w_city#204, w_county#205, w_state#206, w_country#207, d_year#209, 1), ENSURE_REQUIREMENTS, [w_warehouse_name#202, w_warehouse_sq_ft#203, w_city#204, w_county#205, w_state#206, w_country#207, d_year#209, sum#285, isEmpty#286, sum#287, isEmpty#288, sum#289, isEmpty#290, sum#291, isEmpty#292, sum#293, isEmpty#294, sum#295, isEmpty#296, sum#297, isEmpty#298, sum#299, isEmpty#300, sum#301, isEmpty#302, sum#303, isEmpty#304, sum#305, isEmpty#306, sum#307, isEmpty#308, sum#309, isEmpty#310, sum#311, isEmpty#312, sum#313, isEmpty#314, sum#315, isEmpty#316, sum#317, isEmpty#318, sum#319, isEmpty#320, sum#321, isEmpty#322, sum#323, isEmpty#324, sum#325, isEmpty#326, sum#327, isEmpty#328, sum#329, isEmpty#330, sum#331, isEmpty#332], [plan_id=5], [shuffle_writer_type=hash]

(71) InputAdapter
Input [55]: [w_warehouse_name#202, w_warehouse_sq_ft#203, w_city#204, w_county#205, w_state#206, w_country#207, d_year#209, sum#285, isEmpty#286, sum#287, isEmpty#288, sum#289, isEmpty#290, sum#291, isEmpty#292, sum#293, isEmpty#294, sum#295, isEmpty#296, sum#297, isEmpty#298, sum#299, isEmpty#300, sum#301, isEmpty#302, sum#303, isEmpty#304, sum#305, isEmpty#306, sum#307, isEmpty#308, sum#309, isEmpty#310, sum#311, isEmpty#312, sum#313, isEmpty#314, sum#315, isEmpty#316, sum#317, isEmpty#318, sum#319, isEmpty#320, sum#321, isEmpty#322, sum#323, isEmpty#324, sum#325, isEmpty#326, sum#327, isEmpty#328, sum#329, isEmpty#330, sum#331, isEmpty#332]

(72) InputIteratorTransformer
Input [55]: [w_warehouse_name#202, w_warehouse_sq_ft#203, w_city#204, w_county#205, w_state#206, w_country#207, d_year#209, sum#285, isEmpty#286, sum#287, isEmpty#288, sum#289, isEmpty#290, sum#291, isEmpty#292, sum#293, isEmpty#294, sum#295, isEmpty#296, sum#297, isEmpty#298, sum#299, isEmpty#300, sum#301, isEmpty#302, sum#303, isEmpty#304, sum#305, isEmpty#306, sum#307, isEmpty#308, sum#309, isEmpty#310, sum#311, isEmpty#312, sum#313, isEmpty#314, sum#315, isEmpty#316, sum#317, isEmpty#318, sum#319, isEmpty#320, sum#321, isEmpty#322, sum#323, isEmpty#324, sum#325, isEmpty#326, sum#327, isEmpty#328, sum#329, isEmpty#330, sum#331, isEmpty#332]

(73) RegularHashAggregateExecTransformer
Input [55]: [w_warehouse_name#202, w_warehouse_sq_ft#203, w_city#204, w_county#205, w_state#206, w_country#207, d_year#209, sum#285, isEmpty#286, sum#287, isEmpty#288, sum#289, isEmpty#290, sum#291, isEmpty#292, sum#293, isEmpty#294, sum#295, isEmpty#296, sum#297, isEmpty#298, sum#299, isEmpty#300, sum#301, isEmpty#302, sum#303, isEmpty#304, sum#305, isEmpty#306, sum#307, isEmpty#308, sum#309, isEmpty#310, sum#311, isEmpty#312, sum#313, isEmpty#314, sum#315, isEmpty#316, sum#317, isEmpty#318, sum#319, isEmpty#320, sum#321, isEmpty#322, sum#323, isEmpty#324, sum#325, isEmpty#326, sum#327, isEmpty#328, sum#329, isEmpty#330, sum#331, isEmpty#332]
Keys [7]: [w_warehouse_name#202, w_warehouse_sq_ft#203, w_city#204, w_county#205, w_state#206, w_country#207, d_year#209]
Functions [24]: [sum(CASE WHEN (d_moy#210 = 1) THEN (cs_sales_price#198 * cast(cs_quantity#197 as decimal(10,0))) ELSE 0.00 END), sum(CASE WHEN (d_moy#210 = 2) THEN (cs_sales_price#198 * cast(cs_quantity#197 as decimal(10,0))) ELSE 0.00 END), sum(CASE WHEN (d_moy#210 = 3) THEN (cs_sales_price#198 * cast(cs_quantity#197 as decimal(10,0))) ELSE 0.00 END), sum(CASE WHEN (d_moy#210 = 4) THEN (cs_sales_price#198 * cast(cs_quantity#197 as decimal(10,0))) ELSE 0.00 END), sum(CASE WHEN (d_moy#210 = 5) THEN (cs_sales_price#198 * cast(cs_quantity#197 as decimal(10,0))) ELSE 0.00 END), sum(CASE WHEN (d_moy#210 = 6) THEN (cs_sales_price#198 * cast(cs_quantity#197 as decimal(10,0))) ELSE 0.00 END), sum(CASE WHEN (d_moy#210 = 7) THEN (cs_sales_price#198 * cast(cs_quantity#197 as decimal(10,0))) ELSE 0.00 END), sum(CASE WHEN (d_moy#210 = 8) THEN (cs_sales_price#198 * cast(cs_quantity#197 as decimal(10,0))) ELSE 0.00 END), sum(CASE WHEN (d_moy#210 = 9) THEN (cs_sales_price#198 * cast(cs_quantity#197 as decimal(10,0))) ELSE 0.00 END), sum(CASE WHEN (d_moy#210 = 10) THEN (cs_sales_price#198 * cast(cs_quantity#197 as decimal(10,0))) ELSE 0.00 END), sum(CASE WHEN (d_moy#210 = 11) THEN (cs_sales_price#198 * cast(cs_quantity#197 as decimal(10,0))) ELSE 0.00 END), sum(CASE WHEN (d_moy#210 = 12) THEN (cs_sales_price#198 * cast(cs_quantity#197 as decimal(10,0))) ELSE 0.00 END), sum(CASE WHEN (d_moy#210 = 1) THEN (cs_net_paid_inc_tax#199 * cast(cs_quantity#197 as decimal(10,0))) ELSE 0.00 END), sum(CASE WHEN (d_moy#210 = 2) THEN (cs_net_paid_inc_tax#199 * cast(cs_quantity#197 as decimal(10,0))) ELSE 0.00 END), sum(CASE WHEN (d_moy#210 = 3) THEN (cs_net_paid_inc_tax#199 * cast(cs_quantity#197 as decimal(10,0))) ELSE 0.00 END), sum(CASE WHEN (d_moy#210 = 4) THEN (cs_net_paid_inc_tax#199 * cast(cs_quantity#197 as decimal(10,0))) ELSE 0.00 END), sum(CASE WHEN (d_moy#210 = 5) THEN (cs_net_paid_inc_tax#199 * cast(cs_quantity#197 as decimal(10,0))) ELSE 0.00 END), sum(CASE WHEN (d_moy#210 = 6) THEN (cs_net_paid_inc_tax#199 * cast(cs_quantity#197 as decimal(10,0))) ELSE 0.00 END), sum(CASE WHEN (d_moy#210 = 7) THEN (cs_net_paid_inc_tax#199 * cast(cs_quantity#197 as decimal(10,0))) ELSE 0.00 END), sum(CASE WHEN (d_moy#210 = 8) THEN (cs_net_paid_inc_tax#199 * cast(cs_quantity#197 as decimal(10,0))) ELSE 0.00 END), sum(CASE WHEN (d_moy#210 = 9) THEN (cs_net_paid_inc_tax#199 * cast(cs_quantity#197 as decimal(10,0))) ELSE 0.00 END), sum(CASE WHEN (d_moy#210 = 10) THEN (cs_net_paid_inc_tax#199 * cast(cs_quantity#197 as decimal(10,0))) ELSE 0.00 END), sum(CASE WHEN (d_moy#210 = 11) THEN (cs_net_paid_inc_tax#199 * cast(cs_quantity#197 as decimal(10,0))) ELSE 0.00 END), sum(CASE WHEN (d_moy#210 = 12) THEN (cs_net_paid_inc_tax#199 * cast(cs_quantity#197 as decimal(10,0))) ELSE 0.00 END)]
Aggregate Attributes [24]: [sum(CASE WHEN (d_moy#210 = 1) THEN (cs_sales_price#198 * cast(cs_quantity#197 as decimal(10,0))) ELSE 0.00 END)#334, sum(CASE WHEN (d_moy#210 = 2) THEN (cs_sales_price#198 * cast(cs_quantity#197 as decimal(10,0))) ELSE 0.00 END)#335, sum(CASE WHEN (d_moy#210 = 3) THEN (cs_sales_price#198 * cast(cs_quantity#197 as decimal(10,0))) ELSE 0.00 END)#336, sum(CASE WHEN (d_moy#210 = 4) THEN (cs_sales_price#198 * cast(cs_quantity#197 as decimal(10,0))) ELSE 0.00 END)#337, sum(CASE WHEN (d_moy#210 = 5) THEN (cs_sales_price#198 * cast(cs_quantity#197 as decimal(10,0))) ELSE 0.00 END)#338, sum(CASE WHEN (d_moy#210 = 6) THEN (cs_sales_price#198 * cast(cs_quantity#197 as decimal(10,0))) ELSE 0.00 END)#339, sum(CASE WHEN (d_moy#210 = 7) THEN (cs_sales_price#198 * cast(cs_quantity#197 as decimal(10,0))) ELSE 0.00 END)#340, sum(CASE WHEN (d_moy#210 = 8) THEN (cs_sales_price#198 * cast(cs_quantity#197 as decimal(10,0))) ELSE 0.00 END)#341, sum(CASE WHEN (d_moy#210 = 9) THEN (cs_sales_price#198 * cast(cs_quantity#197 as decimal(10,0))) ELSE 0.00 END)#342, sum(CASE WHEN (d_moy#210 = 10) THEN (cs_sales_price#198 * cast(cs_quantity#197 as decimal(10,0))) ELSE 0.00 END)#343, sum(CASE WHEN (d_moy#210 = 11) THEN (cs_sales_price#198 * cast(cs_quantity#197 as decimal(10,0))) ELSE 0.00 END)#344, sum(CASE WHEN (d_moy#210 = 12) THEN (cs_sales_price#198 * cast(cs_quantity#197 as decimal(10,0))) ELSE 0.00 END)#345, sum(CASE WHEN (d_moy#210 = 1) THEN (cs_net_paid_inc_tax#199 * cast(cs_quantity#197 as decimal(10,0))) ELSE 0.00 END)#346, sum(CASE WHEN (d_moy#210 = 2) THEN (cs_net_paid_inc_tax#199 * cast(cs_quantity#197 as decimal(10,0))) ELSE 0.00 END)#347, sum(CASE WHEN (d_moy#210 = 3) THEN (cs_net_paid_inc_tax#199 * cast(cs_quantity#197 as decimal(10,0))) ELSE 0.00 END)#348, sum(CASE WHEN (d_moy#210 = 4) THEN (cs_net_paid_inc_tax#199 * cast(cs_quantity#197 as decimal(10,0))) ELSE 0.00 END)#349, sum(CASE WHEN (d_moy#210 = 5) THEN (cs_net_paid_inc_tax#199 * cast(cs_quantity#197 as decimal(10,0))) ELSE 0.00 END)#350, sum(CASE WHEN (d_moy#210 = 6) THEN (cs_net_paid_inc_tax#199 * cast(cs_quantity#197 as decimal(10,0))) ELSE 0.00 END)#351, sum(CASE WHEN (d_moy#210 = 7) THEN (cs_net_paid_inc_tax#199 * cast(cs_quantity#197 as decimal(10,0))) ELSE 0.00 END)#352, sum(CASE WHEN (d_moy#210 = 8) THEN (cs_net_paid_inc_tax#199 * cast(cs_quantity#197 as decimal(10,0))) ELSE 0.00 END)#353, sum(CASE WHEN (d_moy#210 = 9) THEN (cs_net_paid_inc_tax#199 * cast(cs_quantity#197 as decimal(10,0))) ELSE 0.00 END)#354, sum(CASE WHEN (d_moy#210 = 10) THEN (cs_net_paid_inc_tax#199 * cast(cs_quantity#197 as decimal(10,0))) ELSE 0.00 END)#355, sum(CASE WHEN (d_moy#210 = 11) THEN (cs_net_paid_inc_tax#199 * cast(cs_quantity#197 as decimal(10,0))) ELSE 0.00 END)#356, sum(CASE WHEN (d_moy#210 = 12) THEN (cs_net_paid_inc_tax#199 * cast(cs_quantity#197 as decimal(10,0))) ELSE 0.00 END)#357]
Results [31]: [w_warehouse_name#202, w_warehouse_sq_ft#203, w_city#204, w_county#205, w_state#206, w_country#207, d_year#209, sum(CASE WHEN (d_moy#210 = 1) THEN (cs_sales_price#198 * cast(cs_quantity#197 as decimal(10,0))) ELSE 0.00 END)#334, sum(CASE WHEN (d_moy#210 = 2) THEN (cs_sales_price#198 * cast(cs_quantity#197 as decimal(10,0))) ELSE 0.00 END)#335, sum(CASE WHEN (d_moy#210 = 3) THEN (cs_sales_price#198 * cast(cs_quantity#197 as decimal(10,0))) ELSE 0.00 END)#336, sum(CASE WHEN (d_moy#210 = 4) THEN (cs_sales_price#198 * cast(cs_quantity#197 as decimal(10,0))) ELSE 0.00 END)#337, sum(CASE WHEN (d_moy#210 = 5) THEN (cs_sales_price#198 * cast(cs_quantity#197 as decimal(10,0))) ELSE 0.00 END)#338, sum(CASE WHEN (d_moy#210 = 6) THEN (cs_sales_price#198 * cast(cs_quantity#197 as decimal(10,0))) ELSE 0.00 END)#339, sum(CASE WHEN (d_moy#210 = 7) THEN (cs_sales_price#198 * cast(cs_quantity#197 as decimal(10,0))) ELSE 0.00 END)#340, sum(CASE WHEN (d_moy#210 = 8) THEN (cs_sales_price#198 * cast(cs_quantity#197 as decimal(10,0))) ELSE 0.00 END)#341, sum(CASE WHEN (d_moy#210 = 9) THEN (cs_sales_price#198 * cast(cs_quantity#197 as decimal(10,0))) ELSE 0.00 END)#342, sum(CASE WHEN (d_moy#210 = 10) THEN (cs_sales_price#198 * cast(cs_quantity#197 as decimal(10,0))) ELSE 0.00 END)#343, sum(CASE WHEN (d_moy#210 = 11) THEN (cs_sales_price#198 * cast(cs_quantity#197 as decimal(10,0))) ELSE 0.00 END)#344, sum(CASE WHEN (d_moy#210 = 12) THEN (cs_sales_price#198 * cast(cs_quantity#197 as decimal(10,0))) ELSE 0.00 END)#345, sum(CASE WHEN (d_moy#210 = 1) THEN (cs_net_paid_inc_tax#199 * cast(cs_quantity#197 as decimal(10,0))) ELSE 0.00 END)#346, sum(CASE WHEN (d_moy#210 = 2) THEN (cs_net_paid_inc_tax#199 * cast(cs_quantity#197 as decimal(10,0))) ELSE 0.00 END)#347, sum(CASE WHEN (d_moy#210 = 3) THEN (cs_net_paid_inc_tax#199 * cast(cs_quantity#197 as decimal(10,0))) ELSE 0.00 END)#348, sum(CASE WHEN (d_moy#210 = 4) THEN (cs_net_paid_inc_tax#199 * cast(cs_quantity#197 as decimal(10,0))) ELSE 0.00 END)#349, sum(CASE WHEN (d_moy#210 = 5) THEN (cs_net_paid_inc_tax#199 * cast(cs_quantity#197 as decimal(10,0))) ELSE 0.00 END)#350, sum(CASE WHEN (d_moy#210 = 6) THEN (cs_net_paid_inc_tax#199 * cast(cs_quantity#197 as decimal(10,0))) ELSE 0.00 END)#351, sum(CASE WHEN (d_moy#210 = 7) THEN (cs_net_paid_inc_tax#199 * cast(cs_quantity#197 as decimal(10,0))) ELSE 0.00 END)#352, sum(CASE WHEN (d_moy#210 = 8) THEN (cs_net_paid_inc_tax#199 * cast(cs_quantity#197 as decimal(10,0))) ELSE 0.00 END)#353, sum(CASE WHEN (d_moy#210 = 9) THEN (cs_net_paid_inc_tax#199 * cast(cs_quantity#197 as decimal(10,0))) ELSE 0.00 END)#354, sum(CASE WHEN (d_moy#210 = 10) THEN (cs_net_paid_inc_tax#199 * cast(cs_quantity#197 as decimal(10,0))) ELSE 0.00 END)#355, sum(CASE WHEN (d_moy#210 = 11) THEN (cs_net_paid_inc_tax#199 * cast(cs_quantity#197 as decimal(10,0))) ELSE 0.00 END)#356, sum(CASE WHEN (d_moy#210 = 12) THEN (cs_net_paid_inc_tax#199 * cast(cs_quantity#197 as decimal(10,0))) ELSE 0.00 END)#357]

(74) ProjectExecTransformer
Output [32]: [w_warehouse_name#202, w_warehouse_sq_ft#203, w_city#204, w_county#205, w_state#206, w_country#207, DHL,BARIAN AS ship_carriers#358, d_year#209 AS year#359, sum(CASE WHEN (d_moy#210 = 1) THEN (cs_sales_price#198 * cast(cs_quantity#197 as decimal(10,0))) ELSE 0.00 END)#334 AS jan_sales#360, sum(CASE WHEN (d_moy#210 = 2) THEN (cs_sales_price#198 * cast(cs_quantity#197 as decimal(10,0))) ELSE 0.00 END)#335 AS feb_sales#361, sum(CASE WHEN (d_moy#210 = 3) THEN (cs_sales_price#198 * cast(cs_quantity#197 as decimal(10,0))) ELSE 0.00 END)#336 AS mar_sales#362, sum(CASE WHEN (d_moy#210 = 4) THEN (cs_sales_price#198 * cast(cs_quantity#197 as decimal(10,0))) ELSE 0.00 END)#337 AS apr_sales#363, sum(CASE WHEN (d_moy#210 = 5) THEN (cs_sales_price#198 * cast(cs_quantity#197 as decimal(10,0))) ELSE 0.00 END)#338 AS may_sales#364, sum(CASE WHEN (d_moy#210 = 6) THEN (cs_sales_price#198 * cast(cs_quantity#197 as decimal(10,0))) ELSE 0.00 END)#339 AS jun_sales#365, sum(CASE WHEN (d_moy#210 = 7) THEN (cs_sales_price#198 * cast(cs_quantity#197 as decimal(10,0))) ELSE 0.00 END)#340 AS jul_sales#366, sum(CASE WHEN (d_moy#210 = 8) THEN (cs_sales_price#198 * cast(cs_quantity#197 as decimal(10,0))) ELSE 0.00 END)#341 AS aug_sales#367, sum(CASE WHEN (d_moy#210 = 9) THEN (cs_sales_price#198 * cast(cs_quantity#197 as decimal(10,0))) ELSE 0.00 END)#342 AS sep_sales#368, sum(CASE WHEN (d_moy#210 = 10) THEN (cs_sales_price#198 * cast(cs_quantity#197 as decimal(10,0))) ELSE 0.00 END)#343 AS oct_sales#369, sum(CASE WHEN (d_moy#210 = 11) THEN (cs_sales_price#198 * cast(cs_quantity#197 as decimal(10,0))) ELSE 0.00 END)#344 AS nov_sales#370, sum(CASE WHEN (d_moy#210 = 12) THEN (cs_sales_price#198 * cast(cs_quantity#197 as decimal(10,0))) ELSE 0.00 END)#345 AS dec_sales#371, sum(CASE WHEN (d_moy#210 = 1) THEN (cs_net_paid_inc_tax#199 * cast(cs_quantity#197 as decimal(10,0))) ELSE 0.00 END)#346 AS jan_net#372, sum(CASE WHEN (d_moy#210 = 2) THEN (cs_net_paid_inc_tax#199 * cast(cs_quantity#197 as decimal(10,0))) ELSE 0.00 END)#347 AS feb_net#373, sum(CASE WHEN (d_moy#210 = 3) THEN (cs_net_paid_inc_tax#199 * cast(cs_quantity#197 as decimal(10,0))) ELSE 0.00 END)#348 AS mar_net#374, sum(CASE WHEN (d_moy#210 = 4) THEN (cs_net_paid_inc_tax#199 * cast(cs_quantity#197 as decimal(10,0))) ELSE 0.00 END)#349 AS apr_net#375, sum(CASE WHEN (d_moy#210 = 5) THEN (cs_net_paid_inc_tax#199 * cast(cs_quantity#197 as decimal(10,0))) ELSE 0.00 END)#350 AS may_net#376, sum(CASE WHEN (d_moy#210 = 6) THEN (cs_net_paid_inc_tax#199 * cast(cs_quantity#197 as decimal(10,0))) ELSE 0.00 END)#351 AS jun_net#377, sum(CASE WHEN (d_moy#210 = 7) THEN (cs_net_paid_inc_tax#199 * cast(cs_quantity#197 as decimal(10,0))) ELSE 0.00 END)#352 AS jul_net#378, sum(CASE WHEN (d_moy#210 = 8) THEN (cs_net_paid_inc_tax#199 * cast(cs_quantity#197 as decimal(10,0))) ELSE 0.00 END)#353 AS aug_net#379, sum(CASE WHEN (d_moy#210 = 9) THEN (cs_net_paid_inc_tax#199 * cast(cs_quantity#197 as decimal(10,0))) ELSE 0.00 END)#354 AS sep_net#380, sum(CASE WHEN (d_moy#210 = 10) THEN (cs_net_paid_inc_tax#199 * cast(cs_quantity#197 as decimal(10,0))) ELSE 0.00 END)#355 AS oct_net#381, sum(CASE WHEN (d_moy#210 = 11) THEN (cs_net_paid_inc_tax#199 * cast(cs_quantity#197 as decimal(10,0))) ELSE 0.00 END)#356 AS nov_net#382, sum(CASE WHEN (d_moy#210 = 12) THEN (cs_net_paid_inc_tax#199 * cast(cs_quantity#197 as decimal(10,0))) ELSE 0.00 END)#357 AS dec_net#383]
Input [31]: [w_warehouse_name#202, w_warehouse_sq_ft#203, w_city#204, w_county#205, w_state#206, w_country#207, d_year#209, sum(CASE WHEN (d_moy#210 = 1) THEN (cs_sales_price#198 * cast(cs_quantity#197 as decimal(10,0))) ELSE 0.00 END)#334, sum(CASE WHEN (d_moy#210 = 2) THEN (cs_sales_price#198 * cast(cs_quantity#197 as decimal(10,0))) ELSE 0.00 END)#335, sum(CASE WHEN (d_moy#210 = 3) THEN (cs_sales_price#198 * cast(cs_quantity#197 as decimal(10,0))) ELSE 0.00 END)#336, sum(CASE WHEN (d_moy#210 = 4) THEN (cs_sales_price#198 * cast(cs_quantity#197 as decimal(10,0))) ELSE 0.00 END)#337, sum(CASE WHEN (d_moy#210 = 5) THEN (cs_sales_price#198 * cast(cs_quantity#197 as decimal(10,0))) ELSE 0.00 END)#338, sum(CASE WHEN (d_moy#210 = 6) THEN (cs_sales_price#198 * cast(cs_quantity#197 as decimal(10,0))) ELSE 0.00 END)#339, sum(CASE WHEN (d_moy#210 = 7) THEN (cs_sales_price#198 * cast(cs_quantity#197 as decimal(10,0))) ELSE 0.00 END)#340, sum(CASE WHEN (d_moy#210 = 8) THEN (cs_sales_price#198 * cast(cs_quantity#197 as decimal(10,0))) ELSE 0.00 END)#341, sum(CASE WHEN (d_moy#210 = 9) THEN (cs_sales_price#198 * cast(cs_quantity#197 as decimal(10,0))) ELSE 0.00 END)#342, sum(CASE WHEN (d_moy#210 = 10) THEN (cs_sales_price#198 * cast(cs_quantity#197 as decimal(10,0))) ELSE 0.00 END)#343, sum(CASE WHEN (d_moy#210 = 11) THEN (cs_sales_price#198 * cast(cs_quantity#197 as decimal(10,0))) ELSE 0.00 END)#344, sum(CASE WHEN (d_moy#210 = 12) THEN (cs_sales_price#198 * cast(cs_quantity#197 as decimal(10,0))) ELSE 0.00 END)#345, sum(CASE WHEN (d_moy#210 = 1) THEN (cs_net_paid_inc_tax#199 * cast(cs_quantity#197 as decimal(10,0))) ELSE 0.00 END)#346, sum(CASE WHEN (d_moy#210 = 2) THEN (cs_net_paid_inc_tax#199 * cast(cs_quantity#197 as decimal(10,0))) ELSE 0.00 END)#347, sum(CASE WHEN (d_moy#210 = 3) THEN (cs_net_paid_inc_tax#199 * cast(cs_quantity#197 as decimal(10,0))) ELSE 0.00 END)#348, sum(CASE WHEN (d_moy#210 = 4) THEN (cs_net_paid_inc_tax#199 * cast(cs_quantity#197 as decimal(10,0))) ELSE 0.00 END)#349, sum(CASE WHEN (d_moy#210 = 5) THEN (cs_net_paid_inc_tax#199 * cast(cs_quantity#197 as decimal(10,0))) ELSE 0.00 END)#350, sum(CASE WHEN (d_moy#210 = 6) THEN (cs_net_paid_inc_tax#199 * cast(cs_quantity#197 as decimal(10,0))) ELSE 0.00 END)#351, sum(CASE WHEN (d_moy#210 = 7) THEN (cs_net_paid_inc_tax#199 * cast(cs_quantity#197 as decimal(10,0))) ELSE 0.00 END)#352, sum(CASE WHEN (d_moy#210 = 8) THEN (cs_net_paid_inc_tax#199 * cast(cs_quantity#197 as decimal(10,0))) ELSE 0.00 END)#353, sum(CASE WHEN (d_moy#210 = 9) THEN (cs_net_paid_inc_tax#199 * cast(cs_quantity#197 as decimal(10,0))) ELSE 0.00 END)#354, sum(CASE WHEN (d_moy#210 = 10) THEN (cs_net_paid_inc_tax#199 * cast(cs_quantity#197 as decimal(10,0))) ELSE 0.00 END)#355, sum(CASE WHEN (d_moy#210 = 11) THEN (cs_net_paid_inc_tax#199 * cast(cs_quantity#197 as decimal(10,0))) ELSE 0.00 END)#356, sum(CASE WHEN (d_moy#210 = 12) THEN (cs_net_paid_inc_tax#199 * cast(cs_quantity#197 as decimal(10,0))) ELSE 0.00 END)#357]

(75) WholeStageCodegenTransformer (14)
Input [32]: [w_warehouse_name#202, w_warehouse_sq_ft#203, w_city#204, w_county#205, w_state#206, w_country#207, ship_carriers#358, year#359, jan_sales#360, feb_sales#361, mar_sales#362, apr_sales#363, may_sales#364, jun_sales#365, jul_sales#366, aug_sales#367, sep_sales#368, oct_sales#369, nov_sales#370, dec_sales#371, jan_net#372, feb_net#373, mar_net#374, apr_net#375, may_net#376, jun_net#377, jul_net#378, aug_net#379, sep_net#380, oct_net#381, nov_net#382, dec_net#383]
Arguments: false

(76) ColumnarUnion
Arguments: UnknownPartitioning(0)

(77) InputAdapter
Input [32]: [w_warehouse_name#10, w_warehouse_sq_ft#11, w_city#12, w_county#13, w_state#14, w_country#15, ship_carriers#168, year#169, jan_sales#170, feb_sales#171, mar_sales#172, apr_sales#173, may_sales#174, jun_sales#175, jul_sales#176, aug_sales#177, sep_sales#178, oct_sales#179, nov_sales#180, dec_sales#181, jan_net#182, feb_net#183, mar_net#184, apr_net#185, may_net#186, jun_net#187, jul_net#188, aug_net#189, sep_net#190, oct_net#191, nov_net#192, dec_net#193]

(78) InputIteratorTransformer
Input [32]: [w_warehouse_name#10, w_warehouse_sq_ft#11, w_city#12, w_county#13, w_state#14, w_country#15, ship_carriers#168, year#169, jan_sales#170, feb_sales#171, mar_sales#172, apr_sales#173, may_sales#174, jun_sales#175, jul_sales#176, aug_sales#177, sep_sales#178, oct_sales#179, nov_sales#180, dec_sales#181, jan_net#182, feb_net#183, mar_net#184, apr_net#185, may_net#186, jun_net#187, jul_net#188, aug_net#189, sep_net#190, oct_net#191, nov_net#192, dec_net#193]

(79) ProjectExecTransformer
Output [44]: [w_warehouse_name#10, w_warehouse_sq_ft#11, w_city#12, w_county#13, w_state#14, w_country#15, ship_carriers#168, year#169, jan_sales#170, feb_sales#171, mar_sales#172, apr_sales#173, may_sales#174, jun_sales#175, jul_sales#176, aug_sales#177, sep_sales#178, oct_sales#179, nov_sales#180, dec_sales#181, jan_net#182, feb_net#183, mar_net#184, apr_net#185, may_net#186, jun_net#187, jul_net#188, aug_net#189, sep_net#190, oct_net#191, nov_net#192, dec_net#193, (jan_sales#170 / cast(w_warehouse_sq_ft#11 as decimal(10,0))) AS _pre_49#384, (feb_sales#171 / cast(w_warehouse_sq_ft#11 as decimal(10,0))) AS _pre_50#385, (mar_sales#172 / cast(w_warehouse_sq_ft#11 as decimal(10,0))) AS _pre_51#386, (apr_sales#173 / cast(w_warehouse_sq_ft#11 as decimal(10,0))) AS _pre_52#387, (may_sales#174 / cast(w_warehouse_sq_ft#11 as decimal(10,0))) AS _pre_53#388, (jun_sales#175 / cast(w_warehouse_sq_ft#11 as decimal(10,0))) AS _pre_54#389, (jul_sales#176 / cast(w_warehouse_sq_ft#11 as decimal(10,0))) AS _pre_55#390, (aug_sales#177 / cast(w_warehouse_sq_ft#11 as decimal(10,0))) AS _pre_56#391, (sep_sales#178 / cast(w_warehouse_sq_ft#11 as decimal(10,0))) AS _pre_57#392, (oct_sales#179 / cast(w_warehouse_sq_ft#11 as decimal(10,0))) AS _pre_58#393, (nov_sales#180 / cast(w_warehouse_sq_ft#11 as decimal(10,0))) AS _pre_59#394, (dec_sales#181 / cast(w_warehouse_sq_ft#11 as decimal(10,0))) AS _pre_60#395]
Input [32]: [w_warehouse_name#10, w_warehouse_sq_ft#11, w_city#12, w_county#13, w_state#14, w_country#15, ship_carriers#168, year#169, jan_sales#170, feb_sales#171, mar_sales#172, apr_sales#173, may_sales#174, jun_sales#175, jul_sales#176, aug_sales#177, sep_sales#178, oct_sales#179, nov_sales#180, dec_sales#181, jan_net#182, feb_net#183, mar_net#184, apr_net#185, may_net#186, jun_net#187, jul_net#188, aug_net#189, sep_net#190, oct_net#191, nov_net#192, dec_net#193]

(80) FlushableHashAggregateExecTransformer
Input [44]: [w_warehouse_name#10, w_warehouse_sq_ft#11, w_city#12, w_county#13, w_state#14, w_country#15, ship_carriers#168, year#169, jan_sales#170, feb_sales#171, mar_sales#172, apr_sales#173, may_sales#174, jun_sales#175, jul_sales#176, aug_sales#177, sep_sales#178, oct_sales#179, nov_sales#180, dec_sales#181, jan_net#182, feb_net#183, mar_net#184, apr_net#185, may_net#186, jun_net#187, jul_net#188, aug_net#189, sep_net#190, oct_net#191, nov_net#192, dec_net#193, _pre_49#384, _pre_50#385, _pre_51#386, _pre_52#387, _pre_53#388, _pre_54#389, _pre_55#390, _pre_56#391, _pre_57#392, _pre_58#393, _pre_59#394, _pre_60#395]
Keys [8]: [w_warehouse_name#10, w_warehouse_sq_ft#11, w_city#12, w_county#13, w_state#14, w_country#15, ship_carriers#168, year#169]
Functions [36]: [partial_sum(jan_sales#170), partial_sum(feb_sales#171), partial_sum(mar_sales#172), partial_sum(apr_sales#173), partial_sum(may_sales#174), partial_sum(jun_sales#175), partial_sum(jul_sales#176), partial_sum(aug_sales#177), partial_sum(sep_sales#178), partial_sum(oct_sales#179), partial_sum(nov_sales#180), partial_sum(dec_sales#181), partial_sum(_pre_49#384), partial_sum(_pre_50#385), partial_sum(_pre_51#386), partial_sum(_pre_52#387), partial_sum(_pre_53#388), partial_sum(_pre_54#389), partial_sum(_pre_55#390), partial_sum(_pre_56#391), partial_sum(_pre_57#392), partial_sum(_pre_58#393), partial_sum(_pre_59#394), partial_sum(_pre_60#395), partial_sum(jan_net#182), partial_sum(feb_net#183), partial_sum(mar_net#184), partial_sum(apr_net#185), partial_sum(may_net#186), partial_sum(jun_net#187), partial_sum(jul_net#188), partial_sum(aug_net#189), partial_sum(sep_net#190), partial_sum(oct_net#191), partial_sum(nov_net#192), partial_sum(dec_net#193)]
Aggregate Attributes [72]: [sum#396, isEmpty#397, sum#398, isEmpty#399, sum#400, isEmpty#401, sum#402, isEmpty#403, sum#404, isEmpty#405, sum#406, isEmpty#407, sum#408, isEmpty#409, sum#410, isEmpty#411, sum#412, isEmpty#413, sum#414, isEmpty#415, sum#416, isEmpty#417, sum#418, isEmpty#419, sum#420, isEmpty#421, sum#422, isEmpty#423, sum#424, isEmpty#425, sum#426, isEmpty#427, sum#428, isEmpty#429, sum#430, isEmpty#431, sum#432, isEmpty#433, sum#434, isEmpty#435, sum#436, isEmpty#437, sum#438, isEmpty#439, sum#440, isEmpty#441, sum#442, isEmpty#443, sum#444, isEmpty#445, sum#446, isEmpty#447, sum#448, isEmpty#449, sum#450, isEmpty#451, sum#452, isEmpty#453, sum#454, isEmpty#455, sum#456, isEmpty#457, sum#458, isEmpty#459, sum#460, isEmpty#461, sum#462, isEmpty#463, sum#464, isEmpty#465, sum#466, isEmpty#467]
Results [80]: [w_warehouse_name#10, w_warehouse_sq_ft#11, w_city#12, w_county#13, w_state#14, w_country#15, ship_carriers#168, year#169, sum#468, isEmpty#469, sum#470, isEmpty#471, sum#472, isEmpty#473, sum#474, isEmpty#475, sum#476, isEmpty#477, sum#478, isEmpty#479, sum#480, isEmpty#481, sum#482, isEmpty#483, sum#484, isEmpty#485, sum#486, isEmpty#487, sum#488, isEmpty#489, sum#490, isEmpty#491, sum#492, isEmpty#493, sum#494, isEmpty#495, sum#496, isEmpty#497, sum#498, isEmpty#499, sum#500, isEmpty#501, sum#502, isEmpty#503, sum#504, isEmpty#505, sum#506, isEmpty#507, sum#508, isEmpty#509, sum#510, isEmpty#511, sum#512, isEmpty#513, sum#514, isEmpty#515, sum#516, isEmpty#517, sum#518, isEmpty#519, sum#520, isEmpty#521, sum#522, isEmpty#523, sum#524, isEmpty#525, sum#526, isEmpty#527, sum#528, isEmpty#529, sum#530, isEmpty#531, sum#532, isEmpty#533, sum#534, isEmpty#535, sum#536, isEmpty#537, sum#538, isEmpty#539]

(81) ProjectExecTransformer
Output [81]: [hash(w_warehouse_name#10, w_warehouse_sq_ft#11, w_city#12, w_county#13, w_state#14, w_country#15, ship_carriers#168, year#169, 42) AS hash_partition_key#540, w_warehouse_name#10, w_warehouse_sq_ft#11, w_city#12, w_county#13, w_state#14, w_country#15, ship_carriers#168, year#169, sum#468, isEmpty#469, sum#470, isEmpty#471, sum#472, isEmpty#473, sum#474, isEmpty#475, sum#476, isEmpty#477, sum#478, isEmpty#479, sum#480, isEmpty#481, sum#482, isEmpty#483, sum#484, isEmpty#485, sum#486, isEmpty#487, sum#488, isEmpty#489, sum#490, isEmpty#491, sum#492, isEmpty#493, sum#494, isEmpty#495, sum#496, isEmpty#497, sum#498, isEmpty#499, sum#500, isEmpty#501, sum#502, isEmpty#503, sum#504, isEmpty#505, sum#506, isEmpty#507, sum#508, isEmpty#509, sum#510, isEmpty#511, sum#512, isEmpty#513, sum#514, isEmpty#515, sum#516, isEmpty#517, sum#518, isEmpty#519, sum#520, isEmpty#521, sum#522, isEmpty#523, sum#524, isEmpty#525, sum#526, isEmpty#527, sum#528, isEmpty#529, sum#530, isEmpty#531, sum#532, isEmpty#533, sum#534, isEmpty#535, sum#536, isEmpty#537, sum#538, isEmpty#539]
Input [80]: [w_warehouse_name#10, w_warehouse_sq_ft#11, w_city#12, w_county#13, w_state#14, w_country#15, ship_carriers#168, year#169, sum#468, isEmpty#469, sum#470, isEmpty#471, sum#472, isEmpty#473, sum#474, isEmpty#475, sum#476, isEmpty#477, sum#478, isEmpty#479, sum#480, isEmpty#481, sum#482, isEmpty#483, sum#484, isEmpty#485, sum#486, isEmpty#487, sum#488, isEmpty#489, sum#490, isEmpty#491, sum#492, isEmpty#493, sum#494, isEmpty#495, sum#496, isEmpty#497, sum#498, isEmpty#499, sum#500, isEmpty#501, sum#502, isEmpty#503, sum#504, isEmpty#505, sum#506, isEmpty#507, sum#508, isEmpty#509, sum#510, isEmpty#511, sum#512, isEmpty#513, sum#514, isEmpty#515, sum#516, isEmpty#517, sum#518, isEmpty#519, sum#520, isEmpty#521, sum#522, isEmpty#523, sum#524, isEmpty#525, sum#526, isEmpty#527, sum#528, isEmpty#529, sum#530, isEmpty#531, sum#532, isEmpty#533, sum#534, isEmpty#535, sum#536, isEmpty#537, sum#538, isEmpty#539]

(82) WholeStageCodegenTransformer (15)
Input [81]: [hash_partition_key#540, w_warehouse_name#10, w_warehouse_sq_ft#11, w_city#12, w_county#13, w_state#14, w_country#15, ship_carriers#168, year#169, sum#468, isEmpty#469, sum#470, isEmpty#471, sum#472, isEmpty#473, sum#474, isEmpty#475, sum#476, isEmpty#477, sum#478, isEmpty#479, sum#480, isEmpty#481, sum#482, isEmpty#483, sum#484, isEmpty#485, sum#486, isEmpty#487, sum#488, isEmpty#489, sum#490, isEmpty#491, sum#492, isEmpty#493, sum#494, isEmpty#495, sum#496, isEmpty#497, sum#498, isEmpty#499, sum#500, isEmpty#501, sum#502, isEmpty#503, sum#504, isEmpty#505, sum#506, isEmpty#507, sum#508, isEmpty#509, sum#510, isEmpty#511, sum#512, isEmpty#513, sum#514, isEmpty#515, sum#516, isEmpty#517, sum#518, isEmpty#519, sum#520, isEmpty#521, sum#522, isEmpty#523, sum#524, isEmpty#525, sum#526, isEmpty#527, sum#528, isEmpty#529, sum#530, isEmpty#531, sum#532, isEmpty#533, sum#534, isEmpty#535, sum#536, isEmpty#537, sum#538, isEmpty#539]
Arguments: false

(83) VeloxResizeBatches
Input [81]: [hash_partition_key#540, w_warehouse_name#10, w_warehouse_sq_ft#11, w_city#12, w_county#13, w_state#14, w_country#15, ship_carriers#168, year#169, sum#468, isEmpty#469, sum#470, isEmpty#471, sum#472, isEmpty#473, sum#474, isEmpty#475, sum#476, isEmpty#477, sum#478, isEmpty#479, sum#480, isEmpty#481, sum#482, isEmpty#483, sum#484, isEmpty#485, sum#486, isEmpty#487, sum#488, isEmpty#489, sum#490, isEmpty#491, sum#492, isEmpty#493, sum#494, isEmpty#495, sum#496, isEmpty#497, sum#498, isEmpty#499, sum#500, isEmpty#501, sum#502, isEmpty#503, sum#504, isEmpty#505, sum#506, isEmpty#507, sum#508, isEmpty#509, sum#510, isEmpty#511, sum#512, isEmpty#513, sum#514, isEmpty#515, sum#516, isEmpty#517, sum#518, isEmpty#519, sum#520, isEmpty#521, sum#522, isEmpty#523, sum#524, isEmpty#525, sum#526, isEmpty#527, sum#528, isEmpty#529, sum#530, isEmpty#531, sum#532, isEmpty#533, sum#534, isEmpty#535, sum#536, isEmpty#537, sum#538, isEmpty#539]
Arguments: 1024, 2147483647, 10485760

(84) ColumnarExchange
Input [81]: [hash_partition_key#540, w_warehouse_name#10, w_warehouse_sq_ft#11, w_city#12, w_county#13, w_state#14, w_country#15, ship_carriers#168, year#169, sum#468, isEmpty#469, sum#470, isEmpty#471, sum#472, isEmpty#473, sum#474, isEmpty#475, sum#476, isEmpty#477, sum#478, isEmpty#479, sum#480, isEmpty#481, sum#482, isEmpty#483, sum#484, isEmpty#485, sum#486, isEmpty#487, sum#488, isEmpty#489, sum#490, isEmpty#491, sum#492, isEmpty#493, sum#494, isEmpty#495, sum#496, isEmpty#497, sum#498, isEmpty#499, sum#500, isEmpty#501, sum#502, isEmpty#503, sum#504, isEmpty#505, sum#506, isEmpty#507, sum#508, isEmpty#509, sum#510, isEmpty#511, sum#512, isEmpty#513, sum#514, isEmpty#515, sum#516, isEmpty#517, sum#518, isEmpty#519, sum#520, isEmpty#521, sum#522, isEmpty#523, sum#524, isEmpty#525, sum#526, isEmpty#527, sum#528, isEmpty#529, sum#530, isEmpty#531, sum#532, isEmpty#533, sum#534, isEmpty#535, sum#536, isEmpty#537, sum#538, isEmpty#539]
Arguments: hashpartitioning(w_warehouse_name#10, w_warehouse_sq_ft#11, w_city#12, w_county#13, w_state#14, w_country#15, ship_carriers#168, year#169, 1), ENSURE_REQUIREMENTS, [w_warehouse_name#10, w_warehouse_sq_ft#11, w_city#12, w_county#13, w_state#14, w_country#15, ship_carriers#168, year#169, sum#468, isEmpty#469, sum#470, isEmpty#471, sum#472, isEmpty#473, sum#474, isEmpty#475, sum#476, isEmpty#477, sum#478, isEmpty#479, sum#480, isEmpty#481, sum#482, isEmpty#483, sum#484, isEmpty#485, sum#486, isEmpty#487, sum#488, isEmpty#489, sum#490, isEmpty#491, sum#492, isEmpty#493, sum#494, isEmpty#495, sum#496, isEmpty#497, sum#498, isEmpty#499, sum#500, isEmpty#501, sum#502, isEmpty#503, sum#504, isEmpty#505, sum#506, isEmpty#507, sum#508, isEmpty#509, sum#510, isEmpty#511, sum#512, isEmpty#513, sum#514, isEmpty#515, sum#516, isEmpty#517, sum#518, isEmpty#519, sum#520, isEmpty#521, sum#522, isEmpty#523, sum#524, isEmpty#525, sum#526, isEmpty#527, sum#528, isEmpty#529, sum#530, isEmpty#531, sum#532, isEmpty#533, sum#534, isEmpty#535, sum#536, isEmpty#537, sum#538, isEmpty#539], [plan_id=6], [shuffle_writer_type=hash]

(85) InputAdapter
Input [80]: [w_warehouse_name#10, w_warehouse_sq_ft#11, w_city#12, w_county#13, w_state#14, w_country#15, ship_carriers#168, year#169, sum#468, isEmpty#469, sum#470, isEmpty#471, sum#472, isEmpty#473, sum#474, isEmpty#475, sum#476, isEmpty#477, sum#478, isEmpty#479, sum#480, isEmpty#481, sum#482, isEmpty#483, sum#484, isEmpty#485, sum#486, isEmpty#487, sum#488, isEmpty#489, sum#490, isEmpty#491, sum#492, isEmpty#493, sum#494, isEmpty#495, sum#496, isEmpty#497, sum#498, isEmpty#499, sum#500, isEmpty#501, sum#502, isEmpty#503, sum#504, isEmpty#505, sum#506, isEmpty#507, sum#508, isEmpty#509, sum#510, isEmpty#511, sum#512, isEmpty#513, sum#514, isEmpty#515, sum#516, isEmpty#517, sum#518, isEmpty#519, sum#520, isEmpty#521, sum#522, isEmpty#523, sum#524, isEmpty#525, sum#526, isEmpty#527, sum#528, isEmpty#529, sum#530, isEmpty#531, sum#532, isEmpty#533, sum#534, isEmpty#535, sum#536, isEmpty#537, sum#538, isEmpty#539]

(86) InputIteratorTransformer
Input [80]: [w_warehouse_name#10, w_warehouse_sq_ft#11, w_city#12, w_county#13, w_state#14, w_country#15, ship_carriers#168, year#169, sum#468, isEmpty#469, sum#470, isEmpty#471, sum#472, isEmpty#473, sum#474, isEmpty#475, sum#476, isEmpty#477, sum#478, isEmpty#479, sum#480, isEmpty#481, sum#482, isEmpty#483, sum#484, isEmpty#485, sum#486, isEmpty#487, sum#488, isEmpty#489, sum#490, isEmpty#491, sum#492, isEmpty#493, sum#494, isEmpty#495, sum#496, isEmpty#497, sum#498, isEmpty#499, sum#500, isEmpty#501, sum#502, isEmpty#503, sum#504, isEmpty#505, sum#506, isEmpty#507, sum#508, isEmpty#509, sum#510, isEmpty#511, sum#512, isEmpty#513, sum#514, isEmpty#515, sum#516, isEmpty#517, sum#518, isEmpty#519, sum#520, isEmpty#521, sum#522, isEmpty#523, sum#524, isEmpty#525, sum#526, isEmpty#527, sum#528, isEmpty#529, sum#530, isEmpty#531, sum#532, isEmpty#533, sum#534, isEmpty#535, sum#536, isEmpty#537, sum#538, isEmpty#539]

(87) RegularHashAggregateExecTransformer
Input [80]: [w_warehouse_name#10, w_warehouse_sq_ft#11, w_city#12, w_county#13, w_state#14, w_country#15, ship_carriers#168, year#169, sum#468, isEmpty#469, sum#470, isEmpty#471, sum#472, isEmpty#473, sum#474, isEmpty#475, sum#476, isEmpty#477, sum#478, isEmpty#479, sum#480, isEmpty#481, sum#482, isEmpty#483, sum#484, isEmpty#485, sum#486, isEmpty#487, sum#488, isEmpty#489, sum#490, isEmpty#491, sum#492, isEmpty#493, sum#494, isEmpty#495, sum#496, isEmpty#497, sum#498, isEmpty#499, sum#500, isEmpty#501, sum#502, isEmpty#503, sum#504, isEmpty#505, sum#506, isEmpty#507, sum#508, isEmpty#509, sum#510, isEmpty#511, sum#512, isEmpty#513, sum#514, isEmpty#515, sum#516, isEmpty#517, sum#518, isEmpty#519, sum#520, isEmpty#521, sum#522, isEmpty#523, sum#524, isEmpty#525, sum#526, isEmpty#527, sum#528, isEmpty#529, sum#530, isEmpty#531, sum#532, isEmpty#533, sum#534, isEmpty#535, sum#536, isEmpty#537, sum#538, isEmpty#539]
Keys [8]: [w_warehouse_name#10, w_warehouse_sq_ft#11, w_city#12, w_county#13, w_state#14, w_country#15, ship_carriers#168, year#169]
Functions [36]: [sum(jan_sales#170), sum(feb_sales#171), sum(mar_sales#172), sum(apr_sales#173), sum(may_sales#174), sum(jun_sales#175), sum(jul_sales#176), sum(aug_sales#177), sum(sep_sales#178), sum(oct_sales#179), sum(nov_sales#180), sum(dec_sales#181), sum((jan_sales#170 / cast(w_warehouse_sq_ft#11 as decimal(10,0)))), sum((feb_sales#171 / cast(w_warehouse_sq_ft#11 as decimal(10,0)))), sum((mar_sales#172 / cast(w_warehouse_sq_ft#11 as decimal(10,0)))), sum((apr_sales#173 / cast(w_warehouse_sq_ft#11 as decimal(10,0)))), sum((may_sales#174 / cast(w_warehouse_sq_ft#11 as decimal(10,0)))), sum((jun_sales#175 / cast(w_warehouse_sq_ft#11 as decimal(10,0)))), sum((jul_sales#176 / cast(w_warehouse_sq_ft#11 as decimal(10,0)))), sum((aug_sales#177 / cast(w_warehouse_sq_ft#11 as decimal(10,0)))), sum((sep_sales#178 / cast(w_warehouse_sq_ft#11 as decimal(10,0)))), sum((oct_sales#179 / cast(w_warehouse_sq_ft#11 as decimal(10,0)))), sum((nov_sales#180 / cast(w_warehouse_sq_ft#11 as decimal(10,0)))), sum((dec_sales#181 / cast(w_warehouse_sq_ft#11 as decimal(10,0)))), sum(jan_net#182), sum(feb_net#183), sum(mar_net#184), sum(apr_net#185), sum(may_net#186), sum(jun_net#187), sum(jul_net#188), sum(aug_net#189), sum(sep_net#190), sum(oct_net#191), sum(nov_net#192), sum(dec_net#193)]
Aggregate Attributes [36]: [sum(jan_sales#170)#541, sum(feb_sales#171)#542, sum(mar_sales#172)#543, sum(apr_sales#173)#544, sum(may_sales#174)#545, sum(jun_sales#175)#546, sum(jul_sales#176)#547, sum(aug_sales#177)#548, sum(sep_sales#178)#549, sum(oct_sales#179)#550, sum(nov_sales#180)#551, sum(dec_sales#181)#552, sum((jan_sales#170 / cast(w_warehouse_sq_ft#11 as decimal(10,0))))#553, sum((feb_sales#171 / cast(w_warehouse_sq_ft#11 as decimal(10,0))))#554, sum((mar_sales#172 / cast(w_warehouse_sq_ft#11 as decimal(10,0))))#555, sum((apr_sales#173 / cast(w_warehouse_sq_ft#11 as decimal(10,0))))#556, sum((may_sales#174 / cast(w_warehouse_sq_ft#11 as decimal(10,0))))#557, sum((jun_sales#175 / cast(w_warehouse_sq_ft#11 as decimal(10,0))))#558, sum((jul_sales#176 / cast(w_warehouse_sq_ft#11 as decimal(10,0))))#559, sum((aug_sales#177 / cast(w_warehouse_sq_ft#11 as decimal(10,0))))#560, sum((sep_sales#178 / cast(w_warehouse_sq_ft#11 as decimal(10,0))))#561, sum((oct_sales#179 / cast(w_warehouse_sq_ft#11 as decimal(10,0))))#562, sum((nov_sales#180 / cast(w_warehouse_sq_ft#11 as decimal(10,0))))#563, sum((dec_sales#181 / cast(w_warehouse_sq_ft#11 as decimal(10,0))))#564, sum(jan_net#182)#565, sum(feb_net#183)#566, sum(mar_net#184)#567, sum(apr_net#185)#568, sum(may_net#186)#569, sum(jun_net#187)#570, sum(jul_net#188)#571, sum(aug_net#189)#572, sum(sep_net#190)#573, sum(oct_net#191)#574, sum(nov_net#192)#575, sum(dec_net#193)#576]
Results [44]: [w_warehouse_name#10, w_warehouse_sq_ft#11, w_city#12, w_county#13, w_state#14, w_country#15, ship_carriers#168, year#169, sum(jan_sales#170)#541 AS jan_sales#577, sum(feb_sales#171)#542 AS feb_sales#578, sum(mar_sales#172)#543 AS mar_sales#579, sum(apr_sales#173)#544 AS apr_sales#580, sum(may_sales#174)#545 AS may_sales#581, sum(jun_sales#175)#546 AS jun_sales#582, sum(jul_sales#176)#547 AS jul_sales#583, sum(aug_sales#177)#548 AS aug_sales#584, sum(sep_sales#178)#549 AS sep_sales#585, sum(oct_sales#179)#550 AS oct_sales#586, sum(nov_sales#180)#551 AS nov_sales#587, sum(dec_sales#181)#552 AS dec_sales#588, sum((jan_sales#170 / cast(w_warehouse_sq_ft#11 as decimal(10,0))))#553 AS jan_sales_per_sq_foot#589, sum((feb_sales#171 / cast(w_warehouse_sq_ft#11 as decimal(10,0))))#554 AS feb_sales_per_sq_foot#590, sum((mar_sales#172 / cast(w_warehouse_sq_ft#11 as decimal(10,0))))#555 AS mar_sales_per_sq_foot#591, sum((apr_sales#173 / cast(w_warehouse_sq_ft#11 as decimal(10,0))))#556 AS apr_sales_per_sq_foot#592, sum((may_sales#174 / cast(w_warehouse_sq_ft#11 as decimal(10,0))))#557 AS may_sales_per_sq_foot#593, sum((jun_sales#175 / cast(w_warehouse_sq_ft#11 as decimal(10,0))))#558 AS jun_sales_per_sq_foot#594, sum((jul_sales#176 / cast(w_warehouse_sq_ft#11 as decimal(10,0))))#559 AS jul_sales_per_sq_foot#595, sum((aug_sales#177 / cast(w_warehouse_sq_ft#11 as decimal(10,0))))#560 AS aug_sales_per_sq_foot#596, sum((sep_sales#178 / cast(w_warehouse_sq_ft#11 as decimal(10,0))))#561 AS sep_sales_per_sq_foot#597, sum((oct_sales#179 / cast(w_warehouse_sq_ft#11 as decimal(10,0))))#562 AS oct_sales_per_sq_foot#598, sum((nov_sales#180 / cast(w_warehouse_sq_ft#11 as decimal(10,0))))#563 AS nov_sales_per_sq_foot#599, sum((dec_sales#181 / cast(w_warehouse_sq_ft#11 as decimal(10,0))))#564 AS dec_sales_per_sq_foot#600, sum(jan_net#182)#565 AS jan_net#601, sum(feb_net#183)#566 AS feb_net#602, sum(mar_net#184)#567 AS mar_net#603, sum(apr_net#185)#568 AS apr_net#604, sum(may_net#186)#569 AS may_net#605, sum(jun_net#187)#570 AS jun_net#606, sum(jul_net#188)#571 AS jul_net#607, sum(aug_net#189)#572 AS aug_net#608, sum(sep_net#190)#573 AS sep_net#609, sum(oct_net#191)#574 AS oct_net#610, sum(nov_net#192)#575 AS nov_net#611, sum(dec_net#193)#576 AS dec_net#612]

(88) WholeStageCodegenTransformer (16)
Input [44]: [w_warehouse_name#10, w_warehouse_sq_ft#11, w_city#12, w_county#13, w_state#14, w_country#15, ship_carriers#168, year#169, jan_sales#577, feb_sales#578, mar_sales#579, apr_sales#580, may_sales#581, jun_sales#582, jul_sales#583, aug_sales#584, sep_sales#585, oct_sales#586, nov_sales#587, dec_sales#588, jan_sales_per_sq_foot#589, feb_sales_per_sq_foot#590, mar_sales_per_sq_foot#591, apr_sales_per_sq_foot#592, may_sales_per_sq_foot#593, jun_sales_per_sq_foot#594, jul_sales_per_sq_foot#595, aug_sales_per_sq_foot#596, sep_sales_per_sq_foot#597, oct_sales_per_sq_foot#598, nov_sales_per_sq_foot#599, dec_sales_per_sq_foot#600, jan_net#601, feb_net#602, mar_net#603, apr_net#604, may_net#605, jun_net#606, jul_net#607, aug_net#608, sep_net#609, oct_net#610, nov_net#611, dec_net#612]
Arguments: false

(89) TakeOrderedAndProjectExecTransformer
Input [44]: [w_warehouse_name#10, w_warehouse_sq_ft#11, w_city#12, w_county#13, w_state#14, w_country#15, ship_carriers#168, year#169, jan_sales#577, feb_sales#578, mar_sales#579, apr_sales#580, may_sales#581, jun_sales#582, jul_sales#583, aug_sales#584, sep_sales#585, oct_sales#586, nov_sales#587, dec_sales#588, jan_sales_per_sq_foot#589, feb_sales_per_sq_foot#590, mar_sales_per_sq_foot#591, apr_sales_per_sq_foot#592, may_sales_per_sq_foot#593, jun_sales_per_sq_foot#594, jul_sales_per_sq_foot#595, aug_sales_per_sq_foot#596, sep_sales_per_sq_foot#597, oct_sales_per_sq_foot#598, nov_sales_per_sq_foot#599, dec_sales_per_sq_foot#600, jan_net#601, feb_net#602, mar_net#603, apr_net#604, may_net#605, jun_net#606, jul_net#607, aug_net#608, sep_net#609, oct_net#610, nov_net#611, dec_net#612]
Arguments: 100, [w_warehouse_name#10 ASC NULLS FIRST], [w_warehouse_name#10, w_warehouse_sq_ft#11, w_city#12, w_county#13, w_state#14, w_country#15, ship_carriers#168, year#169, jan_sales#577, feb_sales#578, mar_sales#579, apr_sales#580, may_sales#581, jun_sales#582, jul_sales#583, aug_sales#584, sep_sales#585, oct_sales#586, nov_sales#587, dec_sales#588, jan_sales_per_sq_foot#589, feb_sales_per_sq_foot#590, mar_sales_per_sq_foot#591, apr_sales_per_sq_foot#592, may_sales_per_sq_foot#593, jun_sales_per_sq_foot#594, jul_sales_per_sq_foot#595, aug_sales_per_sq_foot#596, sep_sales_per_sq_foot#597, oct_sales_per_sq_foot#598, nov_sales_per_sq_foot#599, dec_sales_per_sq_foot#600, jan_net#601, feb_net#602, mar_net#603, apr_net#604, may_net#605, jun_net#606, jul_net#607, aug_net#608, sep_net#609, oct_net#610, nov_net#611, dec_net#612], 0

(90) VeloxColumnarToRow
Input [44]: [w_warehouse_name#10, w_warehouse_sq_ft#11, w_city#12, w_county#13, w_state#14, w_country#15, ship_carriers#168, year#169, jan_sales#577, feb_sales#578, mar_sales#579, apr_sales#580, may_sales#581, jun_sales#582, jul_sales#583, aug_sales#584, sep_sales#585, oct_sales#586, nov_sales#587, dec_sales#588, jan_sales_per_sq_foot#589, feb_sales_per_sq_foot#590, mar_sales_per_sq_foot#591, apr_sales_per_sq_foot#592, may_sales_per_sq_foot#593, jun_sales_per_sq_foot#594, jul_sales_per_sq_foot#595, aug_sales_per_sq_foot#596, sep_sales_per_sq_foot#597, oct_sales_per_sq_foot#598, nov_sales_per_sq_foot#599, dec_sales_per_sq_foot#600, jan_net#601, feb_net#602, mar_net#603, apr_net#604, may_net#605, jun_net#606, jul_net#607, aug_net#608, sep_net#609, oct_net#610, nov_net#611, dec_net#612]

===== Subqueries =====

Subquery:1 Hosting operator id = 1 Hosting Expression = ws_sold_date_sk#7 IN dynamicpruning#8
ColumnarBroadcastExchange (94)
+- ^ FilterExecTransformer (92)
   +- ^ FileSourceScanExecTransformer parquet spark_catalog.default.date_dim (91)


(91) FileSourceScanExecTransformer parquet spark_catalog.default.date_dim
Output [3]: [d_date_sk#16, d_year#17, d_moy#18]
Batched: true
Location: InMemoryFileIndex [{warehouse_dir}/date_dim]
PushedFilters: [IsNotNull(d_year), EqualTo(d_year,2001), IsNotNull(d_date_sk)]
ReadSchema: struct<d_date_sk:int,d_year:int,d_moy:int>

(92) FilterExecTransformer
Input [3]: [d_date_sk#16, d_year#17, d_moy#18]
Arguments: ((isnotnull(d_year#17) AND (d_year#17 = 2001)) AND isnotnull(d_date_sk#16))

(93) WholeStageCodegenTransformer (1)
Input [3]: [d_date_sk#16, d_year#17, d_moy#18]
Arguments: false

(94) ColumnarBroadcastExchange
Input [3]: [d_date_sk#16, d_year#17, d_moy#18]
Arguments: HashedRelationBroadcastMode(List(cast(input[0, int, false] as bigint)),false), [plan_id=7]

Subquery:2 Hosting operator id = 44 Hosting Expression = cs_sold_date_sk#200 IN dynamicpruning#8


