HIVE-18797 : ExprConstNodeDesc's getExprString should put appropriate qualifier with...
[hive.git] / ql / src / test / results / clientpositive / perf / tez / query67.q.out
1 PREHOOK: query: explain
2 select  *
3 from (select i_category
4             ,i_class
5             ,i_brand
6             ,i_product_name
7             ,d_year
8             ,d_qoy
9             ,d_moy
10             ,s_store_id
11             ,sumsales
12             ,rank() over (partition by i_category order by sumsales desc) rk
13       from (select i_category
14                   ,i_class
15                   ,i_brand
16                   ,i_product_name
17                   ,d_year
18                   ,d_qoy
19                   ,d_moy
20                   ,s_store_id
21                   ,sum(coalesce(ss_sales_price*ss_quantity,0)) sumsales
22             from store_sales
23                 ,date_dim
24                 ,store
25                 ,item
26        where  ss_sold_date_sk=d_date_sk
27           and ss_item_sk=i_item_sk
28           and ss_store_sk = s_store_sk
29           and d_month_seq between 1212 and 1212+11
30        group by  rollup(i_category, i_class, i_brand, i_product_name, d_year, d_qoy, d_moy,s_store_id))dw1) dw2
31 where rk <= 100
32 order by i_category
33         ,i_class
34         ,i_brand
35         ,i_product_name
36         ,d_year
37         ,d_qoy
38         ,d_moy
39         ,s_store_id
40         ,sumsales
41         ,rk
42 limit 100
43 PREHOOK: type: QUERY
44 POSTHOOK: query: explain
45 select  *
46 from (select i_category
47             ,i_class
48             ,i_brand
49             ,i_product_name
50             ,d_year
51             ,d_qoy
52             ,d_moy
53             ,s_store_id
54             ,sumsales
55             ,rank() over (partition by i_category order by sumsales desc) rk
56       from (select i_category
57                   ,i_class
58                   ,i_brand
59                   ,i_product_name
60                   ,d_year
61                   ,d_qoy
62                   ,d_moy
63                   ,s_store_id
64                   ,sum(coalesce(ss_sales_price*ss_quantity,0)) sumsales
65             from store_sales
66                 ,date_dim
67                 ,store
68                 ,item
69        where  ss_sold_date_sk=d_date_sk
70           and ss_item_sk=i_item_sk
71           and ss_store_sk = s_store_sk
72           and d_month_seq between 1212 and 1212+11
73        group by  rollup(i_category, i_class, i_brand, i_product_name, d_year, d_qoy, d_moy,s_store_id))dw1) dw2
74 where rk <= 100
75 order by i_category
76         ,i_class
77         ,i_brand
78         ,i_product_name
79         ,d_year
80         ,d_qoy
81         ,d_moy
82         ,s_store_id
83         ,sumsales
84         ,rk
85 limit 100
86 POSTHOOK: type: QUERY
87 Plan optimized by CBO.
88
89 Vertex dependency in root stage
90 Reducer 2 <- Map 1 (SIMPLE_EDGE), Map 8 (SIMPLE_EDGE)
91 Reducer 3 <- Map 9 (SIMPLE_EDGE), Reducer 2 (SIMPLE_EDGE)
92 Reducer 4 <- Map 10 (SIMPLE_EDGE), Reducer 3 (SIMPLE_EDGE)
93 Reducer 5 <- Reducer 4 (SIMPLE_EDGE)
94 Reducer 6 <- Reducer 5 (SIMPLE_EDGE)
95 Reducer 7 <- Reducer 6 (SIMPLE_EDGE)
96
97 Stage-0
98   Fetch Operator
99     limit:100
100     Stage-1
101       Reducer 7
102       File Output Operator [FS_37]
103         Limit [LIM_36] (rows=100 width=88)
104           Number of rows:100
105           Select Operator [SEL_35] (rows=1149975358 width=88)
106             Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6","_col7","_col8","_col9"]
107           <-Reducer 6 [SIMPLE_EDGE]
108             SHUFFLE [RS_34]
109               Select Operator [SEL_30] (rows=1149975358 width=88)
110                 Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6","_col7","_col8","_col9"]
111                 Filter Operator [FIL_47] (rows=1149975358 width=88)
112                   predicate:(rank_window_0 <= 100)
113                   PTF Operator [PTF_29] (rows=3449926075 width=88)
114                     Function definitions:[{},{"name:":"windowingtablefunction","order by:":"_col8 DESC NULLS LAST","partition by:":"_col0"}]
115                     Select Operator [SEL_28] (rows=3449926075 width=88)
116                       Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6","_col7","_col8"]
117                     <-Reducer 5 [SIMPLE_EDGE]
118                       SHUFFLE [RS_27]
119                         PartitionCols:_col0
120                         Select Operator [SEL_26] (rows=3449926075 width=88)
121                           Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6","_col7","_col8"]
122                           Group By Operator [GBY_25] (rows=3449926075 width=88)
123                             Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6","_col7","_col9"],aggregations:["sum(VALUE._col0)"],keys:KEY._col0, KEY._col1, KEY._col2, KEY._col3, KEY._col4, KEY._col5, KEY._col6, KEY._col7, KEY._col8
124                           <-Reducer 4 [SIMPLE_EDGE]
125                             SHUFFLE [RS_24]
126                               PartitionCols:_col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8
127                               Group By Operator [GBY_23] (rows=6899852151 width=88)
128                                 Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6","_col7","_col8","_col9"],aggregations:["sum(_col8)"],keys:_col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, 0L
129                                 Select Operator [SEL_21] (rows=766650239 width=88)
130                                   Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6","_col7","_col8"]
131                                   Merge Join Operator [MERGEJOIN_54] (rows=766650239 width=88)
132                                     Conds:RS_18._col1=RS_19._col0(Inner),Output:["_col3","_col4","_col7","_col8","_col9","_col11","_col13","_col14","_col15","_col16"]
133                                   <-Map 10 [SIMPLE_EDGE]
134                                     SHUFFLE [RS_19]
135                                       PartitionCols:_col0
136                                       Select Operator [SEL_11] (rows=462000 width=1436)
137                                         Output:["_col0","_col1","_col2","_col3","_col4"]
138                                         Filter Operator [FIL_51] (rows=462000 width=1436)
139                                           predicate:i_item_sk is not null
140                                           TableScan [TS_9] (rows=462000 width=1436)
141                                             default@item,item,Tbl:COMPLETE,Col:NONE,Output:["i_item_sk","i_brand","i_class","i_category","i_product_name"]
142                                   <-Reducer 3 [SIMPLE_EDGE]
143                                     SHUFFLE [RS_18]
144                                       PartitionCols:_col1
145                                       Merge Join Operator [MERGEJOIN_53] (rows=696954748 width=88)
146                                         Conds:RS_15._col2=RS_16._col0(Inner),Output:["_col1","_col3","_col4","_col7","_col8","_col9","_col11"]
147                                       <-Map 9 [SIMPLE_EDGE]
148                                         SHUFFLE [RS_16]
149                                           PartitionCols:_col0
150                                           Select Operator [SEL_8] (rows=1704 width=1910)
151                                             Output:["_col0","_col1"]
152                                             Filter Operator [FIL_50] (rows=1704 width=1910)
153                                               predicate:s_store_sk is not null
154                                               TableScan [TS_6] (rows=1704 width=1910)
155                                                 default@store,store,Tbl:COMPLETE,Col:NONE,Output:["s_store_sk","s_store_id"]
156                                       <-Reducer 2 [SIMPLE_EDGE]
157                                         SHUFFLE [RS_15]
158                                           PartitionCols:_col2
159                                           Merge Join Operator [MERGEJOIN_52] (rows=633595212 width=88)
160                                             Conds:RS_12._col0=RS_13._col0(Inner),Output:["_col1","_col2","_col3","_col4","_col7","_col8","_col9"]
161                                           <-Map 1 [SIMPLE_EDGE]
162                                             SHUFFLE [RS_12]
163                                               PartitionCols:_col0
164                                               Select Operator [SEL_2] (rows=575995635 width=88)
165                                                 Output:["_col0","_col1","_col2","_col3","_col4"]
166                                                 Filter Operator [FIL_48] (rows=575995635 width=88)
167                                                   predicate:(ss_item_sk is not null and ss_sold_date_sk is not null and ss_store_sk is not null)
168                                                   TableScan [TS_0] (rows=575995635 width=88)
169                                                     default@store_sales,store_sales,Tbl:COMPLETE,Col:NONE,Output:["ss_sold_date_sk","ss_item_sk","ss_store_sk","ss_quantity","ss_sales_price"]
170                                           <-Map 8 [SIMPLE_EDGE]
171                                             SHUFFLE [RS_13]
172                                               PartitionCols:_col0
173                                               Select Operator [SEL_5] (rows=8116 width=1119)
174                                                 Output:["_col0","_col2","_col3","_col4"]
175                                                 Filter Operator [FIL_49] (rows=8116 width=1119)
176                                                   predicate:(d_date_sk is not null and d_month_seq BETWEEN 1212 AND 1223)
177                                                   TableScan [TS_3] (rows=73049 width=1119)
178                                                     default@date_dim,date_dim,Tbl:COMPLETE,Col:NONE,Output:["d_date_sk","d_month_seq","d_year","d_moy","d_qoy"]
179