HIVE-18797 : ExprConstNodeDesc's getExprString should put appropriate qualifier with...
[hive.git] / ql / src / test / results / clientpositive / input_part5.q.out
1 PREHOOK: query: create table tmptable(key string, value string, hr string, ds string)
2 PREHOOK: type: CREATETABLE
3 PREHOOK: Output: database:default
4 PREHOOK: Output: default@tmptable
5 POSTHOOK: query: create table tmptable(key string, value string, hr string, ds string)
6 POSTHOOK: type: CREATETABLE
7 POSTHOOK: Output: database:default
8 POSTHOOK: Output: default@tmptable
9 PREHOOK: query: EXPLAIN
10 insert overwrite table tmptable
11 SELECT x.* FROM SRCPART x WHERE x.ds = '2008-04-08' and x.key < 100
12 PREHOOK: type: QUERY
13 POSTHOOK: query: EXPLAIN
14 insert overwrite table tmptable
15 SELECT x.* FROM SRCPART x WHERE x.ds = '2008-04-08' and x.key < 100
16 POSTHOOK: type: QUERY
17 STAGE DEPENDENCIES:
18   Stage-1 is a root stage
19   Stage-7 depends on stages: Stage-1 , consists of Stage-4, Stage-3, Stage-5
20   Stage-4
21   Stage-0 depends on stages: Stage-4, Stage-3, Stage-6
22   Stage-2 depends on stages: Stage-0
23   Stage-3
24   Stage-5
25   Stage-6 depends on stages: Stage-5
26
27 STAGE PLANS:
28   Stage: Stage-1
29     Map Reduce
30       Map Operator Tree:
31           TableScan
32             alias: x
33             Statistics: Num rows: 1000 Data size: 10624 Basic stats: COMPLETE Column stats: NONE
34             Filter Operator
35               predicate: (UDFToDouble(key) < 100.0D) (type: boolean)
36               Statistics: Num rows: 333 Data size: 3537 Basic stats: COMPLETE Column stats: NONE
37               Select Operator
38                 expressions: key (type: string), value (type: string), '2008-04-08' (type: string), hr (type: string)
39                 outputColumnNames: _col0, _col1, _col2, _col3
40                 Statistics: Num rows: 333 Data size: 3537 Basic stats: COMPLETE Column stats: NONE
41                 File Output Operator
42                   compressed: false
43                   Statistics: Num rows: 333 Data size: 3537 Basic stats: COMPLETE Column stats: NONE
44                   table:
45                       input format: org.apache.hadoop.mapred.TextInputFormat
46                       output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
47                       serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
48                       name: default.tmptable
49                 Select Operator
50                   expressions: _col0 (type: string), _col1 (type: string), _col2 (type: string), _col3 (type: string)
51                   outputColumnNames: key, value, hr, ds
52                   Statistics: Num rows: 333 Data size: 3537 Basic stats: COMPLETE Column stats: NONE
53                   Group By Operator
54                     aggregations: compute_stats(key, 'hll'), compute_stats(value, 'hll'), compute_stats(hr, 'hll'), compute_stats(ds, 'hll')
55                     mode: hash
56                     outputColumnNames: _col0, _col1, _col2, _col3
57                     Statistics: Num rows: 1 Data size: 1760 Basic stats: COMPLETE Column stats: NONE
58                     Reduce Output Operator
59                       sort order: 
60                       Statistics: Num rows: 1 Data size: 1760 Basic stats: COMPLETE Column stats: NONE
61                       value expressions: _col0 (type: struct<columntype:string,maxlength:bigint,sumlength:bigint,count:bigint,countnulls:bigint,bitvector:binary>), _col1 (type: struct<columntype:string,maxlength:bigint,sumlength:bigint,count:bigint,countnulls:bigint,bitvector:binary>), _col2 (type: struct<columntype:string,maxlength:bigint,sumlength:bigint,count:bigint,countnulls:bigint,bitvector:binary>), _col3 (type: struct<columntype:string,maxlength:bigint,sumlength:bigint,count:bigint,countnulls:bigint,bitvector:binary>)
62       Reduce Operator Tree:
63         Group By Operator
64           aggregations: compute_stats(VALUE._col0), compute_stats(VALUE._col1), compute_stats(VALUE._col2), compute_stats(VALUE._col3)
65           mode: mergepartial
66           outputColumnNames: _col0, _col1, _col2, _col3
67           Statistics: Num rows: 1 Data size: 1760 Basic stats: COMPLETE Column stats: NONE
68           File Output Operator
69             compressed: false
70             Statistics: Num rows: 1 Data size: 1760 Basic stats: COMPLETE Column stats: NONE
71             table:
72                 input format: org.apache.hadoop.mapred.SequenceFileInputFormat
73                 output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
74                 serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
75
76   Stage: Stage-7
77     Conditional Operator
78
79   Stage: Stage-4
80     Move Operator
81       files:
82           hdfs directory: true
83 #### A masked pattern was here ####
84
85   Stage: Stage-0
86     Move Operator
87       tables:
88           replace: true
89           table:
90               input format: org.apache.hadoop.mapred.TextInputFormat
91               output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
92               serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
93               name: default.tmptable
94
95   Stage: Stage-2
96     Stats Work
97       Basic Stats Work:
98       Column Stats Desc:
99           Columns: key, value, hr, ds
100           Column Types: string, string, string, string
101           Table: default.tmptable
102
103   Stage: Stage-3
104     Map Reduce
105       Map Operator Tree:
106           TableScan
107             File Output Operator
108               compressed: false
109               table:
110                   input format: org.apache.hadoop.mapred.TextInputFormat
111                   output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
112                   serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
113                   name: default.tmptable
114
115   Stage: Stage-5
116     Map Reduce
117       Map Operator Tree:
118           TableScan
119             File Output Operator
120               compressed: false
121               table:
122                   input format: org.apache.hadoop.mapred.TextInputFormat
123                   output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
124                   serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
125                   name: default.tmptable
126
127   Stage: Stage-6
128     Move Operator
129       files:
130           hdfs directory: true
131 #### A masked pattern was here ####
132
133 PREHOOK: query: insert overwrite table tmptable
134 SELECT x.* FROM SRCPART x WHERE x.ds = '2008-04-08' and x.key < 100
135 PREHOOK: type: QUERY
136 PREHOOK: Input: default@srcpart
137 PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
138 PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=12
139 PREHOOK: Output: default@tmptable
140 POSTHOOK: query: insert overwrite table tmptable
141 SELECT x.* FROM SRCPART x WHERE x.ds = '2008-04-08' and x.key < 100
142 POSTHOOK: type: QUERY
143 POSTHOOK: Input: default@srcpart
144 POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
145 POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=12
146 POSTHOOK: Output: default@tmptable
147 POSTHOOK: Lineage: tmptable.ds SIMPLE [(srcpart)x.FieldSchema(name:hr, type:string, comment:null), ]
148 POSTHOOK: Lineage: tmptable.hr SIMPLE []
149 POSTHOOK: Lineage: tmptable.key SIMPLE [(srcpart)x.FieldSchema(name:key, type:string, comment:default), ]
150 POSTHOOK: Lineage: tmptable.value SIMPLE [(srcpart)x.FieldSchema(name:value, type:string, comment:default), ]
151 PREHOOK: query: select * from tmptable x sort by x.key,x.value,x.ds,x.hr
152 PREHOOK: type: QUERY
153 PREHOOK: Input: default@tmptable
154 #### A masked pattern was here ####
155 POSTHOOK: query: select * from tmptable x sort by x.key,x.value,x.ds,x.hr
156 POSTHOOK: type: QUERY
157 POSTHOOK: Input: default@tmptable
158 #### A masked pattern was here ####
159 0       val_0   2008-04-08      11
160 0       val_0   2008-04-08      11
161 0       val_0   2008-04-08      11
162 0       val_0   2008-04-08      12
163 0       val_0   2008-04-08      12
164 0       val_0   2008-04-08      12
165 10      val_10  2008-04-08      11
166 10      val_10  2008-04-08      12
167 11      val_11  2008-04-08      11
168 11      val_11  2008-04-08      12
169 12      val_12  2008-04-08      11
170 12      val_12  2008-04-08      11
171 12      val_12  2008-04-08      12
172 12      val_12  2008-04-08      12
173 15      val_15  2008-04-08      11
174 15      val_15  2008-04-08      11
175 15      val_15  2008-04-08      12
176 15      val_15  2008-04-08      12
177 17      val_17  2008-04-08      11
178 17      val_17  2008-04-08      12
179 18      val_18  2008-04-08      11
180 18      val_18  2008-04-08      11
181 18      val_18  2008-04-08      12
182 18      val_18  2008-04-08      12
183 19      val_19  2008-04-08      11
184 19      val_19  2008-04-08      12
185 2       val_2   2008-04-08      11
186 2       val_2   2008-04-08      12
187 20      val_20  2008-04-08      11
188 20      val_20  2008-04-08      12
189 24      val_24  2008-04-08      11
190 24      val_24  2008-04-08      11
191 24      val_24  2008-04-08      12
192 24      val_24  2008-04-08      12
193 26      val_26  2008-04-08      11
194 26      val_26  2008-04-08      11
195 26      val_26  2008-04-08      12
196 26      val_26  2008-04-08      12
197 27      val_27  2008-04-08      11
198 27      val_27  2008-04-08      12
199 28      val_28  2008-04-08      11
200 28      val_28  2008-04-08      12
201 30      val_30  2008-04-08      11
202 30      val_30  2008-04-08      12
203 33      val_33  2008-04-08      11
204 33      val_33  2008-04-08      12
205 34      val_34  2008-04-08      11
206 34      val_34  2008-04-08      12
207 35      val_35  2008-04-08      11
208 35      val_35  2008-04-08      11
209 35      val_35  2008-04-08      11
210 35      val_35  2008-04-08      12
211 35      val_35  2008-04-08      12
212 35      val_35  2008-04-08      12
213 37      val_37  2008-04-08      11
214 37      val_37  2008-04-08      11
215 37      val_37  2008-04-08      12
216 37      val_37  2008-04-08      12
217 4       val_4   2008-04-08      11
218 4       val_4   2008-04-08      12
219 41      val_41  2008-04-08      11
220 41      val_41  2008-04-08      12
221 42      val_42  2008-04-08      11
222 42      val_42  2008-04-08      11
223 42      val_42  2008-04-08      12
224 42      val_42  2008-04-08      12
225 43      val_43  2008-04-08      11
226 43      val_43  2008-04-08      12
227 44      val_44  2008-04-08      11
228 44      val_44  2008-04-08      12
229 47      val_47  2008-04-08      11
230 47      val_47  2008-04-08      12
231 5       val_5   2008-04-08      11
232 5       val_5   2008-04-08      11
233 5       val_5   2008-04-08      11
234 5       val_5   2008-04-08      12
235 5       val_5   2008-04-08      12
236 5       val_5   2008-04-08      12
237 51      val_51  2008-04-08      11
238 51      val_51  2008-04-08      11
239 51      val_51  2008-04-08      12
240 51      val_51  2008-04-08      12
241 53      val_53  2008-04-08      11
242 53      val_53  2008-04-08      12
243 54      val_54  2008-04-08      11
244 54      val_54  2008-04-08      12
245 57      val_57  2008-04-08      11
246 57      val_57  2008-04-08      12
247 58      val_58  2008-04-08      11
248 58      val_58  2008-04-08      11
249 58      val_58  2008-04-08      12
250 58      val_58  2008-04-08      12
251 64      val_64  2008-04-08      11
252 64      val_64  2008-04-08      12
253 65      val_65  2008-04-08      11
254 65      val_65  2008-04-08      12
255 66      val_66  2008-04-08      11
256 66      val_66  2008-04-08      12
257 67      val_67  2008-04-08      11
258 67      val_67  2008-04-08      11
259 67      val_67  2008-04-08      12
260 67      val_67  2008-04-08      12
261 69      val_69  2008-04-08      11
262 69      val_69  2008-04-08      12
263 70      val_70  2008-04-08      11
264 70      val_70  2008-04-08      11
265 70      val_70  2008-04-08      11
266 70      val_70  2008-04-08      12
267 70      val_70  2008-04-08      12
268 70      val_70  2008-04-08      12
269 72      val_72  2008-04-08      11
270 72      val_72  2008-04-08      11
271 72      val_72  2008-04-08      12
272 72      val_72  2008-04-08      12
273 74      val_74  2008-04-08      11
274 74      val_74  2008-04-08      12
275 76      val_76  2008-04-08      11
276 76      val_76  2008-04-08      11
277 76      val_76  2008-04-08      12
278 76      val_76  2008-04-08      12
279 77      val_77  2008-04-08      11
280 77      val_77  2008-04-08      12
281 78      val_78  2008-04-08      11
282 78      val_78  2008-04-08      12
283 8       val_8   2008-04-08      11
284 8       val_8   2008-04-08      12
285 80      val_80  2008-04-08      11
286 80      val_80  2008-04-08      12
287 82      val_82  2008-04-08      11
288 82      val_82  2008-04-08      12
289 83      val_83  2008-04-08      11
290 83      val_83  2008-04-08      11
291 83      val_83  2008-04-08      12
292 83      val_83  2008-04-08      12
293 84      val_84  2008-04-08      11
294 84      val_84  2008-04-08      11
295 84      val_84  2008-04-08      12
296 84      val_84  2008-04-08      12
297 85      val_85  2008-04-08      11
298 85      val_85  2008-04-08      12
299 86      val_86  2008-04-08      11
300 86      val_86  2008-04-08      12
301 87      val_87  2008-04-08      11
302 87      val_87  2008-04-08      12
303 9       val_9   2008-04-08      11
304 9       val_9   2008-04-08      12
305 90      val_90  2008-04-08      11
306 90      val_90  2008-04-08      11
307 90      val_90  2008-04-08      11
308 90      val_90  2008-04-08      12
309 90      val_90  2008-04-08      12
310 90      val_90  2008-04-08      12
311 92      val_92  2008-04-08      11
312 92      val_92  2008-04-08      12
313 95      val_95  2008-04-08      11
314 95      val_95  2008-04-08      11
315 95      val_95  2008-04-08      12
316 95      val_95  2008-04-08      12
317 96      val_96  2008-04-08      11
318 96      val_96  2008-04-08      12
319 97      val_97  2008-04-08      11
320 97      val_97  2008-04-08      11
321 97      val_97  2008-04-08      12
322 97      val_97  2008-04-08      12
323 98      val_98  2008-04-08      11
324 98      val_98  2008-04-08      11
325 98      val_98  2008-04-08      12
326 98      val_98  2008-04-08      12