HIVE-18797 : ExprConstNodeDesc's getExprString should put appropriate qualifier with...
[hive.git] / ql / src / test / results / clientpositive / perf / tez / query22.q.out
1 PREHOOK: query: explain
2 select  i_product_name
3              ,i_brand
4              ,i_class
5              ,i_category
6              ,avg(inv_quantity_on_hand) qoh
7        from inventory
8            ,date_dim
9            ,item
10            ,warehouse
11        where inv_date_sk=d_date_sk
12               and inv_item_sk=i_item_sk
13               and inv_warehouse_sk = w_warehouse_sk
14               and d_month_seq between 1212 and 1212 + 11
15        group by rollup(i_product_name
16                        ,i_brand
17                        ,i_class
18                        ,i_category)
19 order by qoh, i_product_name, i_brand, i_class, i_category
20 limit 100
21 PREHOOK: type: QUERY
22 POSTHOOK: query: explain
23 select  i_product_name
24              ,i_brand
25              ,i_class
26              ,i_category
27              ,avg(inv_quantity_on_hand) qoh
28        from inventory
29            ,date_dim
30            ,item
31            ,warehouse
32        where inv_date_sk=d_date_sk
33               and inv_item_sk=i_item_sk
34               and inv_warehouse_sk = w_warehouse_sk
35               and d_month_seq between 1212 and 1212 + 11
36        group by rollup(i_product_name
37                        ,i_brand
38                        ,i_class
39                        ,i_category)
40 order by qoh, i_product_name, i_brand, i_class, i_category
41 limit 100
42 POSTHOOK: type: QUERY
43 Plan optimized by CBO.
44
45 Vertex dependency in root stage
46 Reducer 2 <- Map 1 (SIMPLE_EDGE), Map 7 (SIMPLE_EDGE)
47 Reducer 3 <- Map 8 (SIMPLE_EDGE), Reducer 2 (SIMPLE_EDGE)
48 Reducer 4 <- Map 9 (SIMPLE_EDGE), Reducer 3 (SIMPLE_EDGE)
49 Reducer 5 <- Reducer 4 (SIMPLE_EDGE)
50 Reducer 6 <- Reducer 5 (SIMPLE_EDGE)
51
52 Stage-0
53   Fetch Operator
54     limit:100
55     Stage-1
56       Reducer 6
57       File Output Operator [FS_29]
58         Limit [LIM_28] (rows=100 width=15)
59           Number of rows:100
60           Select Operator [SEL_27] (rows=125060762 width=15)
61             Output:["_col0","_col1","_col2","_col3","_col4"]
62           <-Reducer 5 [SIMPLE_EDGE]
63             SHUFFLE [RS_26]
64               Select Operator [SEL_25] (rows=125060762 width=15)
65                 Output:["_col0","_col1","_col2","_col3","_col4"]
66                 Group By Operator [GBY_24] (rows=125060762 width=15)
67                   Output:["_col0","_col1","_col2","_col3","_col5"],aggregations:["avg(VALUE._col0)"],keys:KEY._col0, KEY._col1, KEY._col2, KEY._col3, KEY._col4
68                 <-Reducer 4 [SIMPLE_EDGE]
69                   SHUFFLE [RS_23]
70                     PartitionCols:_col0, _col1, _col2, _col3, _col4
71                     Group By Operator [GBY_22] (rows=250121525 width=15)
72                       Output:["_col0","_col1","_col2","_col3","_col4","_col5"],aggregations:["avg(_col3)"],keys:_col8, _col9, _col10, _col11, 0L
73                       Merge Join Operator [MERGEJOIN_45] (rows=50024305 width=15)
74                         Conds:RS_18._col1=RS_19._col0(Inner),Output:["_col3","_col8","_col9","_col10","_col11"]
75                       <-Map 9 [SIMPLE_EDGE]
76                         SHUFFLE [RS_19]
77                           PartitionCols:_col0
78                           Select Operator [SEL_11] (rows=462000 width=1436)
79                             Output:["_col0","_col1","_col2","_col3","_col4"]
80                             Filter Operator [FIL_42] (rows=462000 width=1436)
81                               predicate:i_item_sk is not null
82                               TableScan [TS_9] (rows=462000 width=1436)
83                                 default@item,item,Tbl:COMPLETE,Col:NONE,Output:["i_item_sk","i_brand","i_class","i_category","i_product_name"]
84                       <-Reducer 3 [SIMPLE_EDGE]
85                         SHUFFLE [RS_18]
86                           PartitionCols:_col1
87                           Merge Join Operator [MERGEJOIN_44] (rows=45476640 width=15)
88                             Conds:RS_15._col2=RS_16._col0(Inner),Output:["_col1","_col3"]
89                           <-Map 8 [SIMPLE_EDGE]
90                             SHUFFLE [RS_16]
91                               PartitionCols:_col0
92                               Select Operator [SEL_8] (rows=27 width=1029)
93                                 Output:["_col0"]
94                                 Filter Operator [FIL_41] (rows=27 width=1029)
95                                   predicate:w_warehouse_sk is not null
96                                   TableScan [TS_6] (rows=27 width=1029)
97                                     default@warehouse,warehouse,Tbl:COMPLETE,Col:NONE,Output:["w_warehouse_sk"]
98                           <-Reducer 2 [SIMPLE_EDGE]
99                             SHUFFLE [RS_15]
100                               PartitionCols:_col2
101                               Merge Join Operator [MERGEJOIN_43] (rows=41342400 width=15)
102                                 Conds:RS_12._col0=RS_13._col0(Inner),Output:["_col1","_col2","_col3"]
103                               <-Map 1 [SIMPLE_EDGE]
104                                 SHUFFLE [RS_12]
105                                   PartitionCols:_col0
106                                   Select Operator [SEL_2] (rows=37584000 width=15)
107                                     Output:["_col0","_col1","_col2","_col3"]
108                                     Filter Operator [FIL_39] (rows=37584000 width=15)
109                                       predicate:(inv_date_sk is not null and inv_item_sk is not null and inv_warehouse_sk is not null)
110                                       TableScan [TS_0] (rows=37584000 width=15)
111                                         default@inventory,inventory,Tbl:COMPLETE,Col:NONE,Output:["inv_date_sk","inv_item_sk","inv_warehouse_sk","inv_quantity_on_hand"]
112                               <-Map 7 [SIMPLE_EDGE]
113                                 SHUFFLE [RS_13]
114                                   PartitionCols:_col0
115                                   Select Operator [SEL_5] (rows=8116 width=1119)
116                                     Output:["_col0"]
117                                     Filter Operator [FIL_40] (rows=8116 width=1119)
118                                       predicate:(d_date_sk is not null and d_month_seq BETWEEN 1212 AND 1223)
119                                       TableScan [TS_3] (rows=73049 width=1119)
120                                         default@date_dim,date_dim,Tbl:COMPLETE,Col:NONE,Output:["d_date_sk","d_month_seq"]
121