HIVE-18797 : ExprConstNodeDesc's getExprString should put appropriate qualifier with...
[hive.git] / ql / src / test / results / clientpositive / spark / union.q.out
1 PREHOOK: query: EXPLAIN
2 FROM (
3   FROM src select src.key, src.value WHERE src.key < 100
4   UNION ALL
5   FROM src SELECT src.* WHERE src.key > 100
6 ) unioninput
7 INSERT OVERWRITE DIRECTORY 'target/warehouse/union.out' SELECT unioninput.*
8 PREHOOK: type: QUERY
9 POSTHOOK: query: EXPLAIN
10 FROM (
11   FROM src select src.key, src.value WHERE src.key < 100
12   UNION ALL
13   FROM src SELECT src.* WHERE src.key > 100
14 ) unioninput
15 INSERT OVERWRITE DIRECTORY 'target/warehouse/union.out' SELECT unioninput.*
16 POSTHOOK: type: QUERY
17 STAGE DEPENDENCIES:
18   Stage-1 is a root stage
19   Stage-0 depends on stages: Stage-1
20
21 STAGE PLANS:
22   Stage: Stage-1
23     Spark
24 #### A masked pattern was here ####
25       Vertices:
26         Map 1 
27             Map Operator Tree:
28                 TableScan
29                   alias: src
30                   Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
31                   Filter Operator
32                     predicate: (UDFToDouble(key) < 100.0D) (type: boolean)
33                     Statistics: Num rows: 166 Data size: 1763 Basic stats: COMPLETE Column stats: NONE
34                     Select Operator
35                       expressions: key (type: string), value (type: string)
36                       outputColumnNames: _col0, _col1
37                       Statistics: Num rows: 166 Data size: 1763 Basic stats: COMPLETE Column stats: NONE
38                       File Output Operator
39                         compressed: false
40                         Statistics: Num rows: 332 Data size: 3526 Basic stats: COMPLETE Column stats: NONE
41                         table:
42                             input format: org.apache.hadoop.mapred.TextInputFormat
43                             output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
44                             serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
45         Map 2 
46             Map Operator Tree:
47                 TableScan
48                   alias: src
49                   Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
50                   Filter Operator
51                     predicate: (UDFToDouble(key) > 100.0D) (type: boolean)
52                     Statistics: Num rows: 166 Data size: 1763 Basic stats: COMPLETE Column stats: NONE
53                     Select Operator
54                       expressions: key (type: string), value (type: string)
55                       outputColumnNames: _col0, _col1
56                       Statistics: Num rows: 166 Data size: 1763 Basic stats: COMPLETE Column stats: NONE
57                       File Output Operator
58                         compressed: false
59                         Statistics: Num rows: 332 Data size: 3526 Basic stats: COMPLETE Column stats: NONE
60                         table:
61                             input format: org.apache.hadoop.mapred.TextInputFormat
62                             output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
63                             serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
64
65   Stage: Stage-0
66     Move Operator
67       files:
68           hdfs directory: true
69           destination: target/warehouse/union.out
70
71 PREHOOK: query: FROM (
72   FROM src select src.key, src.value WHERE src.key < 100
73   UNION ALL
74   FROM src SELECT src.* WHERE src.key > 100
75 ) unioninput
76 INSERT OVERWRITE DIRECTORY 'target/warehouse/union.out' SELECT unioninput.*
77 PREHOOK: type: QUERY
78 PREHOOK: Input: default@src
79 PREHOOK: Output: target/warehouse/union.out
80 POSTHOOK: query: FROM (
81   FROM src select src.key, src.value WHERE src.key < 100
82   UNION ALL
83   FROM src SELECT src.* WHERE src.key > 100
84 ) unioninput
85 INSERT OVERWRITE DIRECTORY 'target/warehouse/union.out' SELECT unioninput.*
86 POSTHOOK: type: QUERY
87 POSTHOOK: Input: default@src
88 POSTHOOK: Output: target/warehouse/union.out
89 238\ 1val_238
90 311\ 1val_311
91 165\ 1val_165
92 409\ 1val_409
93 255\ 1val_255
94 278\ 1val_278
95 484\ 1val_484
96 265\ 1val_265
97 193\ 1val_193
98 401\ 1val_401
99 150\ 1val_150
100 273\ 1val_273
101 224\ 1val_224
102 369\ 1val_369
103 128\ 1val_128
104 213\ 1val_213
105 146\ 1val_146
106 406\ 1val_406
107 429\ 1val_429
108 374\ 1val_374
109 152\ 1val_152
110 469\ 1val_469
111 145\ 1val_145
112 495\ 1val_495
113 327\ 1val_327
114 281\ 1val_281
115 277\ 1val_277
116 209\ 1val_209
117 403\ 1val_403
118 166\ 1val_166
119 417\ 1val_417
120 430\ 1val_430
121 252\ 1val_252
122 292\ 1val_292
123 219\ 1val_219
124 287\ 1val_287
125 153\ 1val_153
126 193\ 1val_193
127 338\ 1val_338
128 446\ 1val_446
129 459\ 1val_459
130 394\ 1val_394
131 237\ 1val_237
132 482\ 1val_482
133 174\ 1val_174
134 413\ 1val_413
135 494\ 1val_494
136 207\ 1val_207
137 199\ 1val_199
138 466\ 1val_466
139 208\ 1val_208
140 174\ 1val_174
141 399\ 1val_399
142 396\ 1val_396
143 247\ 1val_247
144 417\ 1val_417
145 489\ 1val_489
146 162\ 1val_162
147 377\ 1val_377
148 397\ 1val_397
149 309\ 1val_309
150 365\ 1val_365
151 266\ 1val_266
152 439\ 1val_439
153 342\ 1val_342
154 367\ 1val_367
155 325\ 1val_325
156 167\ 1val_167
157 195\ 1val_195
158 475\ 1val_475
159 113\ 1val_113
160 155\ 1val_155
161 203\ 1val_203
162 339\ 1val_339
163 455\ 1val_455
164 128\ 1val_128
165 311\ 1val_311
166 316\ 1val_316
167 302\ 1val_302
168 205\ 1val_205
169 149\ 1val_149
170 438\ 1val_438
171 345\ 1val_345
172 129\ 1val_129
173 170\ 1val_170
174 489\ 1val_489
175 157\ 1val_157
176 378\ 1val_378
177 221\ 1val_221
178 111\ 1val_111
179 280\ 1val_280
180 427\ 1val_427
181 277\ 1val_277
182 208\ 1val_208
183 356\ 1val_356
184 399\ 1val_399
185 169\ 1val_169
186 382\ 1val_382
187 498\ 1val_498
188 125\ 1val_125
189 386\ 1val_386
190 437\ 1val_437
191 469\ 1val_469
192 192\ 1val_192
193 286\ 1val_286
194 187\ 1val_187
195 176\ 1val_176
196 459\ 1val_459
197 138\ 1val_138
198 103\ 1val_103
199 239\ 1val_239
200 213\ 1val_213
201 216\ 1val_216
202 430\ 1val_430
203 278\ 1val_278
204 176\ 1val_176
205 289\ 1val_289
206 221\ 1val_221
207 318\ 1val_318
208 332\ 1val_332
209 311\ 1val_311
210 275\ 1val_275
211 137\ 1val_137
212 241\ 1val_241
213 333\ 1val_333
214 180\ 1val_180
215 284\ 1val_284
216 230\ 1val_230
217 181\ 1val_181
218 260\ 1val_260
219 404\ 1val_404
220 384\ 1val_384
221 489\ 1val_489
222 353\ 1val_353
223 373\ 1val_373
224 272\ 1val_272
225 138\ 1val_138
226 217\ 1val_217
227 348\ 1val_348
228 466\ 1val_466
229 411\ 1val_411
230 230\ 1val_230
231 208\ 1val_208
232 348\ 1val_348
233 463\ 1val_463
234 431\ 1val_431
235 179\ 1val_179
236 172\ 1val_172
237 129\ 1val_129
238 158\ 1val_158
239 119\ 1val_119
240 496\ 1val_496
241 322\ 1val_322
242 197\ 1val_197
243 468\ 1val_468
244 393\ 1val_393
245 454\ 1val_454
246 298\ 1val_298
247 199\ 1val_199
248 191\ 1val_191
249 418\ 1val_418
250 165\ 1val_165
251 327\ 1val_327
252 230\ 1val_230
253 205\ 1val_205
254 120\ 1val_120
255 131\ 1val_131
256 404\ 1val_404
257 436\ 1val_436
258 156\ 1val_156
259 469\ 1val_469
260 468\ 1val_468
261 308\ 1val_308
262 196\ 1val_196
263 288\ 1val_288
264 481\ 1val_481
265 457\ 1val_457
266 282\ 1val_282
267 197\ 1val_197
268 187\ 1val_187
269 318\ 1val_318
270 318\ 1val_318
271 409\ 1val_409
272 470\ 1val_470
273 137\ 1val_137
274 369\ 1val_369
275 316\ 1val_316
276 169\ 1val_169
277 413\ 1val_413
278 490\ 1val_490
279 364\ 1val_364
280 179\ 1val_179
281 118\ 1val_118
282 134\ 1val_134
283 395\ 1val_395
284 282\ 1val_282
285 138\ 1val_138
286 238\ 1val_238
287 419\ 1val_419
288 118\ 1val_118
289 307\ 1val_307
290 435\ 1val_435
291 277\ 1val_277
292 273\ 1val_273
293 306\ 1val_306
294 224\ 1val_224
295 309\ 1val_309
296 389\ 1val_389
297 327\ 1val_327
298 242\ 1val_242
299 369\ 1val_369
300 392\ 1val_392
301 272\ 1val_272
302 331\ 1val_331
303 401\ 1val_401
304 242\ 1val_242
305 452\ 1val_452
306 177\ 1val_177
307 226\ 1val_226
308 497\ 1val_497
309 402\ 1val_402
310 396\ 1val_396
311 317\ 1val_317
312 395\ 1val_395
313 336\ 1val_336
314 168\ 1val_168
315 229\ 1val_229
316 233\ 1val_233
317 143\ 1val_143
318 472\ 1val_472
319 322\ 1val_322
320 498\ 1val_498
321 160\ 1val_160
322 195\ 1val_195
323 321\ 1val_321
324 430\ 1val_430
325 119\ 1val_119
326 489\ 1val_489
327 458\ 1val_458
328 223\ 1val_223
329 492\ 1val_492
330 149\ 1val_149
331 449\ 1val_449
332 218\ 1val_218
333 228\ 1val_228
334 138\ 1val_138
335 453\ 1val_453
336 209\ 1val_209
337 468\ 1val_468
338 342\ 1val_342
339 230\ 1val_230
340 368\ 1val_368
341 103\ 1val_103
342 296\ 1val_296
343 113\ 1val_113
344 216\ 1val_216
345 367\ 1val_367
346 344\ 1val_344
347 167\ 1val_167
348 274\ 1val_274
349 219\ 1val_219
350 239\ 1val_239
351 485\ 1val_485
352 116\ 1val_116
353 223\ 1val_223
354 256\ 1val_256
355 263\ 1val_263
356 487\ 1val_487
357 480\ 1val_480
358 401\ 1val_401
359 288\ 1val_288
360 191\ 1val_191
361 244\ 1val_244
362 438\ 1val_438
363 128\ 1val_128
364 467\ 1val_467
365 432\ 1val_432
366 202\ 1val_202
367 316\ 1val_316
368 229\ 1val_229
369 469\ 1val_469
370 463\ 1val_463
371 280\ 1val_280
372 283\ 1val_283
373 331\ 1val_331
374 235\ 1val_235
375 193\ 1val_193
376 321\ 1val_321
377 335\ 1val_335
378 104\ 1val_104
379 466\ 1val_466
380 366\ 1val_366
381 175\ 1val_175
382 403\ 1val_403
383 483\ 1val_483
384 105\ 1val_105
385 257\ 1val_257
386 406\ 1val_406
387 409\ 1val_409
388 190\ 1val_190
389 406\ 1val_406
390 401\ 1val_401
391 114\ 1val_114
392 258\ 1val_258
393 203\ 1val_203
394 262\ 1val_262
395 348\ 1val_348
396 424\ 1val_424
397 396\ 1val_396
398 201\ 1val_201
399 217\ 1val_217
400 164\ 1val_164
401 431\ 1val_431
402 454\ 1val_454
403 478\ 1val_478
404 298\ 1val_298
405 125\ 1val_125
406 431\ 1val_431
407 164\ 1val_164
408 424\ 1val_424
409 187\ 1val_187
410 382\ 1val_382
411 397\ 1val_397
412 480\ 1val_480
413 291\ 1val_291
414 351\ 1val_351
415 255\ 1val_255
416 104\ 1val_104
417 163\ 1val_163
418 438\ 1val_438
419 119\ 1val_119
420 414\ 1val_414
421 200\ 1val_200
422 491\ 1val_491
423 237\ 1val_237
424 439\ 1val_439
425 360\ 1val_360
426 248\ 1val_248
427 479\ 1val_479
428 305\ 1val_305
429 417\ 1val_417
430 199\ 1val_199
431 444\ 1val_444
432 120\ 1val_120
433 429\ 1val_429
434 169\ 1val_169
435 443\ 1val_443
436 323\ 1val_323
437 325\ 1val_325
438 277\ 1val_277
439 230\ 1val_230
440 478\ 1val_478
441 178\ 1val_178
442 468\ 1val_468
443 310\ 1val_310
444 317\ 1val_317
445 333\ 1val_333
446 493\ 1val_493
447 460\ 1val_460
448 207\ 1val_207
449 249\ 1val_249
450 265\ 1val_265
451 480\ 1val_480
452 136\ 1val_136
453 353\ 1val_353
454 172\ 1val_172
455 214\ 1val_214
456 462\ 1val_462
457 233\ 1val_233
458 406\ 1val_406
459 133\ 1val_133
460 175\ 1val_175
461 189\ 1val_189
462 454\ 1val_454
463 375\ 1val_375
464 401\ 1val_401
465 421\ 1val_421
466 407\ 1val_407
467 384\ 1val_384
468 256\ 1val_256
469 134\ 1val_134
470 384\ 1val_384
471 379\ 1val_379
472 462\ 1val_462
473 492\ 1val_492
474 298\ 1val_298
475 341\ 1val_341
476 498\ 1val_498
477 146\ 1val_146
478 458\ 1val_458
479 362\ 1val_362
480 186\ 1val_186
481 285\ 1val_285
482 348\ 1val_348
483 167\ 1val_167
484 273\ 1val_273
485 183\ 1val_183
486 281\ 1val_281
487 344\ 1val_344
488 469\ 1val_469
489 315\ 1val_315
490 448\ 1val_448
491 152\ 1val_152
492 348\ 1val_348
493 307\ 1val_307
494 194\ 1val_194
495 414\ 1val_414
496 477\ 1val_477
497 222\ 1val_222
498 126\ 1val_126
499 169\ 1val_169
500 403\ 1val_403
501 400\ 1val_400
502 200\ 1val_200
503 86\ 1val_86
504 27\ 1val_27
505 98\ 1val_98
506 66\ 1val_66
507 37\ 1val_37
508 15\ 1val_15
509 82\ 1val_82
510 17\ 1val_17
511 0\ 1val_0
512 57\ 1val_57
513 20\ 1val_20
514 92\ 1val_92
515 47\ 1val_47
516 72\ 1val_72
517 4\ 1val_4
518 35\ 1val_35
519 54\ 1val_54
520 51\ 1val_51
521 65\ 1val_65
522 83\ 1val_83
523 12\ 1val_12
524 67\ 1val_67
525 84\ 1val_84
526 58\ 1val_58
527 8\ 1val_8
528 24\ 1val_24
529 42\ 1val_42
530 0\ 1val_0
531 96\ 1val_96
532 26\ 1val_26
533 51\ 1val_51
534 43\ 1val_43
535 95\ 1val_95
536 98\ 1val_98
537 85\ 1val_85
538 77\ 1val_77
539 0\ 1val_0
540 87\ 1val_87
541 15\ 1val_15
542 72\ 1val_72
543 90\ 1val_90
544 19\ 1val_19
545 10\ 1val_10
546 5\ 1val_5
547 58\ 1val_58
548 35\ 1val_35
549 95\ 1val_95
550 11\ 1val_11
551 34\ 1val_34
552 42\ 1val_42
553 78\ 1val_78
554 76\ 1val_76
555 41\ 1val_41
556 30\ 1val_30
557 64\ 1val_64
558 76\ 1val_76
559 74\ 1val_74
560 69\ 1val_69
561 33\ 1val_33
562 70\ 1val_70
563 5\ 1val_5
564 2\ 1val_2
565 35\ 1val_35
566 80\ 1val_80
567 44\ 1val_44
568 53\ 1val_53
569 90\ 1val_90
570 12\ 1val_12
571 5\ 1val_5
572 70\ 1val_70
573 24\ 1val_24
574 70\ 1val_70
575 83\ 1val_83
576 26\ 1val_26
577 67\ 1val_67
578 18\ 1val_18
579 9\ 1val_9
580 18\ 1val_18
581 97\ 1val_97
582 84\ 1val_84
583 28\ 1val_28
584 37\ 1val_37
585 90\ 1val_90
586 97\ 1val_97