You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by gu...@apache.org on 2014/03/27 22:45:23 UTC
svn commit: r1582488 [4/4] - in /hive/trunk/ql/src:
java/org/apache/hadoop/hive/ql/exec/tez/
java/org/apache/hadoop/hive/ql/optimizer/
java/org/apache/hadoop/hive/ql/parse/ java/org/apache/hadoop/hive/ql/plan/
test/queries/clientpositive/ test/results/...
Modified: hive/trunk/ql/src/test/results/clientpositive/tez/tez_union.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/tez/tez_union.q.out?rev=1582488&r1=1582487&r2=1582488&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/tez/tez_union.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/tez/tez_union.q.out Thu Mar 27 21:45:22 2014
@@ -79,1546 +79,55 @@ STAGE PLANS:
Fetch Operator
limit: -1
-PREHOOK: query: select s1.key as key, s1.value as value from src s1 join src s3 on s1.key=s3.key
+PREHOOK: query: create table ut as
+select s1.key as key, s1.value as value from src s1 join src s3 on s1.key=s3.key
UNION ALL
select s2.key as key, s2.value as value from src s2
-PREHOOK: type: QUERY
+PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@src
-#### A masked pattern was here ####
-POSTHOOK: query: select s1.key as key, s1.value as value from src s1 join src s3 on s1.key=s3.key
+POSTHOOK: query: create table ut as
+select s1.key as key, s1.value as value from src s1 join src s3 on s1.key=s3.key
UNION ALL
select s2.key as key, s2.value as value from src s2
-POSTHOOK: type: QUERY
+POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@src
+POSTHOOK: Output: default@ut
+PREHOOK: query: select * from ut order by key, value limit 20
+PREHOOK: type: QUERY
+PREHOOK: Input: default@ut
+#### A masked pattern was here ####
+POSTHOOK: query: select * from ut order by key, value limit 20
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@ut
#### A masked pattern was here ####
-238 val_238
-238 val_238
-86 val_86
-311 val_311
-311 val_311
-311 val_311
-27 val_27
-165 val_165
-165 val_165
-409 val_409
-409 val_409
-409 val_409
-255 val_255
-255 val_255
-278 val_278
-278 val_278
-98 val_98
-98 val_98
-484 val_484
-265 val_265
-265 val_265
-193 val_193
-193 val_193
-193 val_193
-401 val_401
-401 val_401
-401 val_401
-401 val_401
-401 val_401
-150 val_150
-273 val_273
-273 val_273
-273 val_273
-224 val_224
-224 val_224
-369 val_369
-369 val_369
-369 val_369
-66 val_66
-128 val_128
-128 val_128
-128 val_128
-213 val_213
-213 val_213
-146 val_146
-146 val_146
-406 val_406
-406 val_406
-406 val_406
-406 val_406
-429 val_429
-429 val_429
-374 val_374
-152 val_152
-152 val_152
-469 val_469
-469 val_469
-469 val_469
-469 val_469
-469 val_469
-145 val_145
-495 val_495
-37 val_37
-37 val_37
-327 val_327
-327 val_327
-327 val_327
-281 val_281
-281 val_281
-277 val_277
-277 val_277
-277 val_277
-277 val_277
-209 val_209
-209 val_209
-15 val_15
-15 val_15
-82 val_82
-403 val_403
-403 val_403
-403 val_403
-166 val_166
-417 val_417
-417 val_417
-417 val_417
-430 val_430
-430 val_430
-430 val_430
-252 val_252
-292 val_292
-219 val_219
-219 val_219
-287 val_287
-153 val_153
-193 val_193
-193 val_193
-193 val_193
-338 val_338
-446 val_446
-459 val_459
-459 val_459
-394 val_394
-237 val_237
-237 val_237
-482 val_482
-174 val_174
-174 val_174
-413 val_413
-413 val_413
-494 val_494
-207 val_207
-207 val_207
-199 val_199
-199 val_199
-199 val_199
-466 val_466
-466 val_466
-466 val_466
-208 val_208
-208 val_208
-208 val_208
-174 val_174
-174 val_174
-399 val_399
-399 val_399
-396 val_396
-396 val_396
-396 val_396
-247 val_247
-417 val_417
-417 val_417
-417 val_417
-489 val_489
-489 val_489
-489 val_489
-489 val_489
-162 val_162
-377 val_377
-397 val_397
-397 val_397
-309 val_309
-309 val_309
-365 val_365
-266 val_266
-439 val_439
-439 val_439
-342 val_342
-342 val_342
-367 val_367
-367 val_367
-325 val_325
-325 val_325
-167 val_167
-167 val_167
-167 val_167
-195 val_195
-195 val_195
-475 val_475
-17 val_17
-113 val_113
-113 val_113
-155 val_155
-203 val_203
-203 val_203
-339 val_339
0 val_0
0 val_0
0 val_0
-455 val_455
-128 val_128
-128 val_128
-128 val_128
-311 val_311
-311 val_311
-311 val_311
-316 val_316
-316 val_316
-316 val_316
-57 val_57
-302 val_302
-205 val_205
-205 val_205
-149 val_149
-149 val_149
-438 val_438
-438 val_438
-438 val_438
-345 val_345
-129 val_129
-129 val_129
-170 val_170
-20 val_20
-489 val_489
-489 val_489
-489 val_489
-489 val_489
-157 val_157
-378 val_378
-221 val_221
-221 val_221
-92 val_92
-111 val_111
-47 val_47
-72 val_72
-72 val_72
-4 val_4
-280 val_280
-280 val_280
-35 val_35
-35 val_35
-35 val_35
-427 val_427
-277 val_277
-277 val_277
-277 val_277
-277 val_277
-208 val_208
-208 val_208
-208 val_208
-356 val_356
-399 val_399
-399 val_399
-169 val_169
-169 val_169
-169 val_169
-169 val_169
-382 val_382
-382 val_382
-498 val_498
-498 val_498
-498 val_498
-125 val_125
-125 val_125
-386 val_386
-437 val_437
-469 val_469
-469 val_469
-469 val_469
-469 val_469
-469 val_469
-192 val_192
-286 val_286
-187 val_187
-187 val_187
-187 val_187
-176 val_176
-176 val_176
-54 val_54
-459 val_459
-459 val_459
-51 val_51
-51 val_51
-138 val_138
-138 val_138
-138 val_138
-138 val_138
-103 val_103
-103 val_103
-239 val_239
-239 val_239
-213 val_213
-213 val_213
-216 val_216
-216 val_216
-430 val_430
-430 val_430
-430 val_430
-278 val_278
-278 val_278
-176 val_176
-176 val_176
-289 val_289
-221 val_221
-221 val_221
-65 val_65
-318 val_318
-318 val_318
-318 val_318
-332 val_332
-311 val_311
-311 val_311
-311 val_311
-275 val_275
-137 val_137
-137 val_137
-241 val_241
-83 val_83
-83 val_83
-333 val_333
-333 val_333
-180 val_180
-284 val_284
-12 val_12
-12 val_12
-230 val_230
-230 val_230
-230 val_230
-230 val_230
-230 val_230
-181 val_181
-67 val_67
-67 val_67
-260 val_260
-404 val_404
-404 val_404
-384 val_384
-384 val_384
-384 val_384
-489 val_489
-489 val_489
-489 val_489
-489 val_489
-353 val_353
-353 val_353
-373 val_373
-272 val_272
-272 val_272
-138 val_138
-138 val_138
-138 val_138
-138 val_138
-217 val_217
-217 val_217
-84 val_84
-84 val_84
-348 val_348
-348 val_348
-348 val_348
-348 val_348
-348 val_348
-466 val_466
-466 val_466
-466 val_466
-58 val_58
-58 val_58
-8 val_8
-411 val_411
-230 val_230
-230 val_230
-230 val_230
-230 val_230
-230 val_230
-208 val_208
-208 val_208
-208 val_208
-348 val_348
-348 val_348
-348 val_348
-348 val_348
-348 val_348
-24 val_24
-24 val_24
-463 val_463
-463 val_463
-431 val_431
-431 val_431
-431 val_431
-179 val_179
-179 val_179
-172 val_172
-172 val_172
-42 val_42
-42 val_42
-129 val_129
-129 val_129
-158 val_158
-119 val_119
-119 val_119
-119 val_119
-496 val_496
0 val_0
0 val_0
0 val_0
-322 val_322
-322 val_322
-197 val_197
-197 val_197
-468 val_468
-468 val_468
-468 val_468
-468 val_468
-393 val_393
-454 val_454
-454 val_454
-454 val_454
-100 val_100
-100 val_100
-298 val_298
-298 val_298
-298 val_298
-199 val_199
-199 val_199
-199 val_199
-191 val_191
-191 val_191
-418 val_418
-96 val_96
-26 val_26
-26 val_26
-165 val_165
-165 val_165
-327 val_327
-327 val_327
-327 val_327
-230 val_230
-230 val_230
-230 val_230
-230 val_230
-230 val_230
-205 val_205
-205 val_205
-120 val_120
-120 val_120
-131 val_131
-51 val_51
-51 val_51
-404 val_404
-404 val_404
-43 val_43
-436 val_436
-156 val_156
-469 val_469
-469 val_469
-469 val_469
-469 val_469
-469 val_469
-468 val_468
-468 val_468
-468 val_468
-468 val_468
-308 val_308
-95 val_95
-95 val_95
-196 val_196
-288 val_288
-288 val_288
-481 val_481
-457 val_457
-98 val_98
-98 val_98
-282 val_282
-282 val_282
-197 val_197
-197 val_197
-187 val_187
-187 val_187
-187 val_187
-318 val_318
-318 val_318
-318 val_318
-318 val_318
-318 val_318
-318 val_318
-409 val_409
-409 val_409
-409 val_409
-470 val_470
-137 val_137
-137 val_137
-369 val_369
-369 val_369
-369 val_369
-316 val_316
-316 val_316
-316 val_316
-169 val_169
-169 val_169
-169 val_169
-169 val_169
-413 val_413
-413 val_413
-85 val_85
-77 val_77
0 val_0
0 val_0
0 val_0
-490 val_490
-87 val_87
-364 val_364
-179 val_179
-179 val_179
-118 val_118
-118 val_118
-134 val_134
-134 val_134
-395 val_395
-395 val_395
-282 val_282
-282 val_282
-138 val_138
-138 val_138
-138 val_138
-138 val_138
-238 val_238
-238 val_238
-419 val_419
-15 val_15
-15 val_15
-118 val_118
-118 val_118
-72 val_72
-72 val_72
-90 val_90
-90 val_90
-90 val_90
-307 val_307
-307 val_307
-19 val_19
-435 val_435
-10 val_10
-277 val_277
-277 val_277
-277 val_277
-277 val_277
-273 val_273
-273 val_273
-273 val_273
-306 val_306
-224 val_224
-224 val_224
-309 val_309
-309 val_309
-389 val_389
-327 val_327
-327 val_327
-327 val_327
-242 val_242
-242 val_242
-369 val_369
-369 val_369
-369 val_369
-392 val_392
-272 val_272
-272 val_272
-331 val_331
-331 val_331
-401 val_401
-401 val_401
-401 val_401
-401 val_401
-401 val_401
-242 val_242
-242 val_242
-452 val_452
-177 val_177
-226 val_226
-5 val_5
-5 val_5
-5 val_5
-497 val_497
-402 val_402
-396 val_396
-396 val_396
-396 val_396
-317 val_317
-317 val_317
-395 val_395
-395 val_395
-58 val_58
-58 val_58
-35 val_35
-35 val_35
-35 val_35
-336 val_336
-95 val_95
-95 val_95
-11 val_11
-168 val_168
-34 val_34
-229 val_229
-229 val_229
-233 val_233
-233 val_233
-143 val_143
-472 val_472
-322 val_322
-322 val_322
-498 val_498
-498 val_498
-498 val_498
-160 val_160
-195 val_195
-195 val_195
-42 val_42
-42 val_42
-321 val_321
-321 val_321
-430 val_430
-430 val_430
-430 val_430
-119 val_119
-119 val_119
-119 val_119
-489 val_489
-489 val_489
-489 val_489
-489 val_489
-458 val_458
-458 val_458
-78 val_78
-76 val_76
-76 val_76
-41 val_41
-223 val_223
-223 val_223
-492 val_492
-492 val_492
-149 val_149
-149 val_149
-449 val_449
-218 val_218
-228 val_228
-138 val_138
-138 val_138
-138 val_138
-138 val_138
-453 val_453
-30 val_30
-209 val_209
-209 val_209
-64 val_64
-468 val_468
-468 val_468
-468 val_468
-468 val_468
-76 val_76
-76 val_76
-74 val_74
-342 val_342
-342 val_342
-69 val_69
-230 val_230
-230 val_230
-230 val_230
-230 val_230
-230 val_230
-33 val_33
-368 val_368
-103 val_103
-103 val_103
-296 val_296
-113 val_113
-113 val_113
-216 val_216
-216 val_216
-367 val_367
-367 val_367
-344 val_344
-344 val_344
-167 val_167
-167 val_167
-167 val_167
-274 val_274
-219 val_219
-219 val_219
-239 val_239
-239 val_239
-485 val_485
-116 val_116
-223 val_223
-223 val_223
-256 val_256
-256 val_256
-263 val_263
-70 val_70
-70 val_70
-70 val_70
-487 val_487
-480 val_480
-480 val_480
-480 val_480
-401 val_401
-401 val_401
-401 val_401
-401 val_401
-401 val_401
-288 val_288
-288 val_288
-191 val_191
-191 val_191
-5 val_5
-5 val_5
-5 val_5
-244 val_244
-438 val_438
-438 val_438
-438 val_438
-128 val_128
-128 val_128
-128 val_128
-467 val_467
-432 val_432
-202 val_202
-316 val_316
-316 val_316
-316 val_316
-229 val_229
-229 val_229
-469 val_469
-469 val_469
-469 val_469
-469 val_469
-469 val_469
-463 val_463
-463 val_463
-280 val_280
-280 val_280
-2 val_2
-35 val_35
-35 val_35
-35 val_35
-283 val_283
-331 val_331
-331 val_331
-235 val_235
-80 val_80
-44 val_44
-193 val_193
-193 val_193
-193 val_193
-321 val_321
-321 val_321
-335 val_335
-104 val_104
-104 val_104
-466 val_466
-466 val_466
-466 val_466
-366 val_366
-175 val_175
-175 val_175
-403 val_403
-403 val_403
-403 val_403
-483 val_483
-53 val_53
-105 val_105
-257 val_257
-406 val_406
-406 val_406
-406 val_406
-406 val_406
-409 val_409
-409 val_409
-409 val_409
-190 val_190
-406 val_406
-406 val_406
-406 val_406
-406 val_406
-401 val_401
-401 val_401
-401 val_401
-401 val_401
-401 val_401
-114 val_114
-258 val_258
-90 val_90
-90 val_90
-90 val_90
-203 val_203
-203 val_203
-262 val_262
-348 val_348
-348 val_348
-348 val_348
-348 val_348
-348 val_348
-424 val_424
-424 val_424
-12 val_12
-12 val_12
-396 val_396
-396 val_396
-396 val_396
-201 val_201
-217 val_217
-217 val_217
-164 val_164
-164 val_164
-431 val_431
-431 val_431
-431 val_431
-454 val_454
-454 val_454
-454 val_454
-478 val_478
-478 val_478
-298 val_298
-298 val_298
-298 val_298
-125 val_125
-125 val_125
-431 val_431
-431 val_431
-431 val_431
-164 val_164
-164 val_164
-424 val_424
-424 val_424
-187 val_187
-187 val_187
-187 val_187
-382 val_382
-382 val_382
-5 val_5
-5 val_5
-5 val_5
-70 val_70
-70 val_70
-70 val_70
-397 val_397
-397 val_397
-480 val_480
-480 val_480
-480 val_480
-291 val_291
-24 val_24
-24 val_24
-351 val_351
-255 val_255
-255 val_255
-104 val_104
-104 val_104
-70 val_70
-70 val_70
-70 val_70
-163 val_163
-438 val_438
-438 val_438
-438 val_438
-119 val_119
-119 val_119
-119 val_119
-414 val_414
-414 val_414
-200 val_200
-200 val_200
-491 val_491
-237 val_237
-237 val_237
-439 val_439
-439 val_439
-360 val_360
-248 val_248
-479 val_479
-305 val_305
-417 val_417
-417 val_417
-417 val_417
-199 val_199
-199 val_199
-199 val_199
-444 val_444
-120 val_120
-120 val_120
-429 val_429
-429 val_429
-169 val_169
-169 val_169
-169 val_169
-169 val_169
-443 val_443
-323 val_323
-325 val_325
-325 val_325
-277 val_277
-277 val_277
-277 val_277
-277 val_277
-230 val_230
-230 val_230
-230 val_230
-230 val_230
-230 val_230
-478 val_478
-478 val_478
-178 val_178
-468 val_468
-468 val_468
-468 val_468
-468 val_468
-310 val_310
-317 val_317
-317 val_317
-333 val_333
-333 val_333
-493 val_493
-460 val_460
-207 val_207
-207 val_207
-249 val_249
-265 val_265
-265 val_265
-480 val_480
-480 val_480
-480 val_480
-83 val_83
-83 val_83
-136 val_136
-353 val_353
-353 val_353
-172 val_172
-172 val_172
-214 val_214
-462 val_462
-462 val_462
-233 val_233
-233 val_233
-406 val_406
-406 val_406
-406 val_406
-406 val_406
-133 val_133
-175 val_175
-175 val_175
-189 val_189
-454 val_454
-454 val_454
-454 val_454
-375 val_375
-401 val_401
-401 val_401
-401 val_401
-401 val_401
-401 val_401
-421 val_421
-407 val_407
-384 val_384
-384 val_384
-384 val_384
-256 val_256
-256 val_256
-26 val_26
-26 val_26
-134 val_134
-134 val_134
-67 val_67
-67 val_67
-384 val_384
-384 val_384
-384 val_384
-379 val_379
-18 val_18
-18 val_18
-462 val_462
-462 val_462
-492 val_492
-492 val_492
-100 val_100
-100 val_100
-298 val_298
-298 val_298
-298 val_298
-9 val_9
-341 val_341
-498 val_498
-498 val_498
-498 val_498
-146 val_146
-146 val_146
-458 val_458
-458 val_458
-362 val_362
-186 val_186
-285 val_285
-348 val_348
-348 val_348
-348 val_348
-348 val_348
-348 val_348
-167 val_167
-167 val_167
-167 val_167
-18 val_18
-18 val_18
-273 val_273
-273 val_273
-273 val_273
-183 val_183
-281 val_281
-281 val_281
-344 val_344
-344 val_344
-97 val_97
-97 val_97
-469 val_469
-469 val_469
-469 val_469
-469 val_469
-469 val_469
-315 val_315
-84 val_84
-84 val_84
-28 val_28
-37 val_37
-37 val_37
-448 val_448
-152 val_152
-152 val_152
-348 val_348
-348 val_348
-348 val_348
-348 val_348
-348 val_348
-307 val_307
-307 val_307
-194 val_194
-414 val_414
-414 val_414
-477 val_477
-222 val_222
-126 val_126
-90 val_90
-90 val_90
-90 val_90
-169 val_169
-169 val_169
-169 val_169
-169 val_169
-403 val_403
-403 val_403
-403 val_403
-400 val_400
-200 val_200
-200 val_200
-97 val_97
-97 val_97
-238 val_238
-86 val_86
-311 val_311
-27 val_27
-165 val_165
-409 val_409
-255 val_255
-278 val_278
-98 val_98
-484 val_484
-265 val_265
-193 val_193
-401 val_401
-150 val_150
-273 val_273
-224 val_224
-369 val_369
-66 val_66
-128 val_128
-213 val_213
-146 val_146
-406 val_406
-429 val_429
-374 val_374
-152 val_152
-469 val_469
-145 val_145
-495 val_495
-37 val_37
-327 val_327
-281 val_281
-277 val_277
-209 val_209
-15 val_15
-82 val_82
-403 val_403
-166 val_166
-417 val_417
-430 val_430
-252 val_252
-292 val_292
-219 val_219
-287 val_287
-153 val_153
-193 val_193
-338 val_338
-446 val_446
-459 val_459
-394 val_394
-237 val_237
-482 val_482
-174 val_174
-413 val_413
-494 val_494
-207 val_207
-199 val_199
-466 val_466
-208 val_208
-174 val_174
-399 val_399
-396 val_396
-247 val_247
-417 val_417
-489 val_489
-162 val_162
-377 val_377
-397 val_397
-309 val_309
-365 val_365
-266 val_266
-439 val_439
-342 val_342
-367 val_367
-325 val_325
-167 val_167
-195 val_195
-475 val_475
-17 val_17
-113 val_113
-155 val_155
-203 val_203
-339 val_339
0 val_0
-455 val_455
-128 val_128
-311 val_311
-316 val_316
-57 val_57
-302 val_302
-205 val_205
-149 val_149
-438 val_438
-345 val_345
-129 val_129
-170 val_170
-20 val_20
-489 val_489
-157 val_157
-378 val_378
-221 val_221
-92 val_92
-111 val_111
-47 val_47
-72 val_72
-4 val_4
-280 val_280
-35 val_35
-427 val_427
-277 val_277
-208 val_208
-356 val_356
-399 val_399
-169 val_169
-382 val_382
-498 val_498
-125 val_125
-386 val_386
-437 val_437
-469 val_469
-192 val_192
-286 val_286
-187 val_187
-176 val_176
-54 val_54
-459 val_459
-51 val_51
-138 val_138
-103 val_103
-239 val_239
-213 val_213
-216 val_216
-430 val_430
-278 val_278
-176 val_176
-289 val_289
-221 val_221
-65 val_65
-318 val_318
-332 val_332
-311 val_311
-275 val_275
-137 val_137
-241 val_241
-83 val_83
-333 val_333
-180 val_180
-284 val_284
-12 val_12
-230 val_230
-181 val_181
-67 val_67
-260 val_260
-404 val_404
-384 val_384
-489 val_489
-353 val_353
-373 val_373
-272 val_272
-138 val_138
-217 val_217
-84 val_84
-348 val_348
-466 val_466
-58 val_58
-8 val_8
-411 val_411
-230 val_230
-208 val_208
-348 val_348
-24 val_24
-463 val_463
-431 val_431
-179 val_179
-172 val_172
-42 val_42
-129 val_129
-158 val_158
-119 val_119
-496 val_496
0 val_0
-322 val_322
-197 val_197
-468 val_468
-393 val_393
-454 val_454
-100 val_100
-298 val_298
-199 val_199
-191 val_191
-418 val_418
-96 val_96
-26 val_26
-165 val_165
-327 val_327
-230 val_230
-205 val_205
-120 val_120
-131 val_131
-51 val_51
-404 val_404
-43 val_43
-436 val_436
-156 val_156
-469 val_469
-468 val_468
-308 val_308
-95 val_95
-196 val_196
-288 val_288
-481 val_481
-457 val_457
-98 val_98
-282 val_282
-197 val_197
-187 val_187
-318 val_318
-318 val_318
-409 val_409
-470 val_470
-137 val_137
-369 val_369
-316 val_316
-169 val_169
-413 val_413
-85 val_85
-77 val_77
0 val_0
-490 val_490
-87 val_87
-364 val_364
-179 val_179
-118 val_118
-134 val_134
-395 val_395
-282 val_282
-138 val_138
-238 val_238
-419 val_419
-15 val_15
-118 val_118
-72 val_72
-90 val_90
-307 val_307
-19 val_19
-435 val_435
10 val_10
-277 val_277
-273 val_273
-306 val_306
-224 val_224
-309 val_309
-389 val_389
-327 val_327
-242 val_242
-369 val_369
-392 val_392
-272 val_272
-331 val_331
-401 val_401
-242 val_242
-452 val_452
-177 val_177
-226 val_226
-5 val_5
-497 val_497
-402 val_402
-396 val_396
-317 val_317
-395 val_395
-58 val_58
-35 val_35
-336 val_336
-95 val_95
-11 val_11
-168 val_168
-34 val_34
-229 val_229
-233 val_233
-143 val_143
-472 val_472
-322 val_322
-498 val_498
-160 val_160
-195 val_195
-42 val_42
-321 val_321
-430 val_430
-119 val_119
-489 val_489
-458 val_458
-78 val_78
-76 val_76
-41 val_41
-223 val_223
-492 val_492
-149 val_149
-449 val_449
-218 val_218
-228 val_228
-138 val_138
-453 val_453
-30 val_30
-209 val_209
-64 val_64
-468 val_468
-76 val_76
-74 val_74
-342 val_342
-69 val_69
-230 val_230
-33 val_33
-368 val_368
-103 val_103
-296 val_296
-113 val_113
-216 val_216
-367 val_367
-344 val_344
-167 val_167
-274 val_274
-219 val_219
-239 val_239
-485 val_485
-116 val_116
-223 val_223
-256 val_256
-263 val_263
-70 val_70
-487 val_487
-480 val_480
-401 val_401
-288 val_288
-191 val_191
-5 val_5
-244 val_244
-438 val_438
-128 val_128
-467 val_467
-432 val_432
-202 val_202
-316 val_316
-229 val_229
-469 val_469
-463 val_463
-280 val_280
-2 val_2
-35 val_35
-283 val_283
-331 val_331
-235 val_235
-80 val_80
-44 val_44
-193 val_193
-321 val_321
-335 val_335
-104 val_104
-466 val_466
-366 val_366
-175 val_175
-403 val_403
-483 val_483
-53 val_53
-105 val_105
-257 val_257
-406 val_406
-409 val_409
-190 val_190
-406 val_406
-401 val_401
-114 val_114
-258 val_258
-90 val_90
-203 val_203
-262 val_262
-348 val_348
-424 val_424
-12 val_12
-396 val_396
-201 val_201
-217 val_217
-164 val_164
-431 val_431
-454 val_454
-478 val_478
-298 val_298
-125 val_125
-431 val_431
-164 val_164
-424 val_424
-187 val_187
-382 val_382
-5 val_5
-70 val_70
-397 val_397
-480 val_480
-291 val_291
-24 val_24
-351 val_351
-255 val_255
-104 val_104
-70 val_70
-163 val_163
-438 val_438
-119 val_119
-414 val_414
-200 val_200
-491 val_491
-237 val_237
-439 val_439
-360 val_360
-248 val_248
-479 val_479
-305 val_305
-417 val_417
-199 val_199
-444 val_444
-120 val_120
-429 val_429
-169 val_169
-443 val_443
-323 val_323
-325 val_325
-277 val_277
-230 val_230
-478 val_478
-178 val_178
-468 val_468
-310 val_310
-317 val_317
-333 val_333
-493 val_493
-460 val_460
-207 val_207
-249 val_249
-265 val_265
-480 val_480
-83 val_83
-136 val_136
-353 val_353
-172 val_172
-214 val_214
-462 val_462
-233 val_233
-406 val_406
-133 val_133
-175 val_175
-189 val_189
-454 val_454
-375 val_375
-401 val_401
-421 val_421
-407 val_407
-384 val_384
-256 val_256
-26 val_26
-134 val_134
-67 val_67
-384 val_384
-379 val_379
-18 val_18
-462 val_462
-492 val_492
+10 val_10
+100 val_100
+100 val_100
100 val_100
-298 val_298
-9 val_9
-341 val_341
-498 val_498
-146 val_146
-458 val_458
-362 val_362
-186 val_186
-285 val_285
-348 val_348
-167 val_167
-18 val_18
-273 val_273
-183 val_183
-281 val_281
-344 val_344
-97 val_97
-469 val_469
-315 val_315
-84 val_84
-28 val_28
-37 val_37
-448 val_448
-152 val_152
-348 val_348
-307 val_307
-194 val_194
-414 val_414
-477 val_477
-222 val_222
-126 val_126
-90 val_90
-169 val_169
-403 val_403
-400 val_400
-200 val_200
-97 val_97
+100 val_100
+100 val_100
+100 val_100
+PREHOOK: query: drop table ut
+PREHOOK: type: DROPTABLE
+PREHOOK: Input: default@ut
+PREHOOK: Output: default@ut
+POSTHOOK: query: drop table ut
+POSTHOOK: type: DROPTABLE
+POSTHOOK: Input: default@ut
+POSTHOOK: Output: default@ut
PREHOOK: query: explain
with u as (select * from src union all select * from src)
select count(*) from (select u1.key as k1, u2.key as k2 from
@@ -1736,16 +245,934 @@ STAGE PLANS:
Fetch Operator
limit: -1
-PREHOOK: query: with u as (select * from src union all select * from src)
-select count(*) from (select u1.key as k1, u2.key as k2 from
+PREHOOK: query: create table ut as
+with u as (select * from src union all select * from src)
+select count(*) as cnt from (select u1.key as k1, u2.key as k2 from
+u as u1 join u as u2 on (u1.key = u2.key)) a
+PREHOOK: type: CREATETABLE_AS_SELECT
+PREHOOK: Input: default@src
+POSTHOOK: query: create table ut as
+with u as (select * from src union all select * from src)
+select count(*) as cnt from (select u1.key as k1, u2.key as k2 from
u as u1 join u as u2 on (u1.key = u2.key)) a
+POSTHOOK: type: CREATETABLE_AS_SELECT
+POSTHOOK: Input: default@src
+POSTHOOK: Output: default@ut
+PREHOOK: query: select * from ut order by cnt limit 20
PREHOOK: type: QUERY
+PREHOOK: Input: default@ut
+#### A masked pattern was here ####
+POSTHOOK: query: select * from ut order by cnt limit 20
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@ut
+#### A masked pattern was here ####
+4112
+PREHOOK: query: drop table ut
+PREHOOK: type: DROPTABLE
+PREHOOK: Input: default@ut
+PREHOOK: Output: default@ut
+POSTHOOK: query: drop table ut
+POSTHOOK: type: DROPTABLE
+POSTHOOK: Input: default@ut
+POSTHOOK: Output: default@ut
+PREHOOK: query: explain select s1.key as skey, u1.key as ukey from
+src s1
+join (select * from src union all select * from src) u1 on s1.key = u1.key
+PREHOOK: type: QUERY
+POSTHOOK: query: explain select s1.key as skey, u1.key as ukey from
+src s1
+join (select * from src union all select * from src) u1 on s1.key = u1.key
+POSTHOOK: type: QUERY
+STAGE DEPENDENCIES:
+ Stage-1 is a root stage
+ Stage-0 is a root stage
+
+STAGE PLANS:
+ Stage: Stage-1
+ Tez
+ Edges:
+ Map 2 <- Map 1 (BROADCAST_EDGE), Union 3 (CONTAINS)
+ Map 4 <- Map 1 (BROADCAST_EDGE), Union 3 (CONTAINS)
+#### A masked pattern was here ####
+ Vertices:
+ Map 1
+ Map Operator Tree:
+ TableScan
+ alias: s1
+ Statistics: Num rows: 58 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
+ Reduce Output Operator
+ key expressions: key (type: string)
+ sort order: +
+ Map-reduce partition columns: key (type: string)
+ Statistics: Num rows: 58 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
+ value expressions: key (type: string)
+ Reduce Output Operator
+ key expressions: key (type: string)
+ sort order: +
+ Map-reduce partition columns: key (type: string)
+ Statistics: Num rows: 58 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
+ value expressions: key (type: string)
+ Map 2
+ Map Operator Tree:
+ TableScan
+ alias: src
+ Select Operator
+ expressions: key (type: string), value (type: string)
+ outputColumnNames: _col0, _col1
+ Map Join Operator
+ condition map:
+ Inner Join 0 to 1
+ condition expressions:
+ 0 {key}
+ 1 {_col0}
+ keys:
+ 0 key (type: string)
+ 1 _col0 (type: string)
+ outputColumnNames: _col0, _col4
+ Select Operator
+ expressions: _col0 (type: string), _col4 (type: string)
+ outputColumnNames: _col0, _col1
+ File Output Operator
+ compressed: false
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ Map 4
+ Map Operator Tree:
+ TableScan
+ alias: src
+ Select Operator
+ expressions: key (type: string), value (type: string)
+ outputColumnNames: _col0, _col1
+ Map Join Operator
+ condition map:
+ Inner Join 0 to 1
+ condition expressions:
+ 0 {key}
+ 1 {_col0}
+ keys:
+ 0 key (type: string)
+ 1 _col0 (type: string)
+ outputColumnNames: _col0, _col4
+ Select Operator
+ expressions: _col0 (type: string), _col4 (type: string)
+ outputColumnNames: _col0, _col1
+ File Output Operator
+ compressed: false
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ Union 3
+ Vertex: Union 3
+
+ Stage: Stage-0
+ Fetch Operator
+ limit: -1
+
+PREHOOK: query: create table ut as
+select s1.key as skey, u1.key as ukey from
+src s1
+join (select * from src union all select * from src) u1 on s1.key = u1.key
+PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@src
+POSTHOOK: query: create table ut as
+select s1.key as skey, u1.key as ukey from
+src s1
+join (select * from src union all select * from src) u1 on s1.key = u1.key
+POSTHOOK: type: CREATETABLE_AS_SELECT
+POSTHOOK: Input: default@src
+POSTHOOK: Output: default@ut
+PREHOOK: query: select * from ut order by skey, ukey limit 20
+PREHOOK: type: QUERY
+PREHOOK: Input: default@ut
#### A masked pattern was here ####
-POSTHOOK: query: with u as (select * from src union all select * from src)
-select count(*) from (select u1.key as k1, u2.key as k2 from
-u as u1 join u as u2 on (u1.key = u2.key)) a
+POSTHOOK: query: select * from ut order by skey, ukey limit 20
POSTHOOK: type: QUERY
+POSTHOOK: Input: default@ut
+#### A masked pattern was here ####
+0 0
+0 0
+0 0
+0 0
+0 0
+0 0
+0 0
+0 0
+0 0
+0 0
+0 0
+0 0
+0 0
+0 0
+0 0
+0 0
+0 0
+0 0
+10 10
+10 10
+PREHOOK: query: drop table ut
+PREHOOK: type: DROPTABLE
+PREHOOK: Input: default@ut
+PREHOOK: Output: default@ut
+POSTHOOK: query: drop table ut
+POSTHOOK: type: DROPTABLE
+POSTHOOK: Input: default@ut
+POSTHOOK: Output: default@ut
+PREHOOK: query: explain select s1.key as skey, u1.key as ukey, s8.key as lkey from
+src s1
+join (select s2.key as key from src s2 join src s3 on s2.key = s3.key
+ union all select s4.key from src s4 join src s5 on s4.key = s5.key
+ union all select s6.key from src s6 join src s7 on s6.key = s7.key) u1 on (s1.key = u1.key)
+join src s8 on (u1.key = s8.key)
+order by lkey
+PREHOOK: type: QUERY
+POSTHOOK: query: explain select s1.key as skey, u1.key as ukey, s8.key as lkey from
+src s1
+join (select s2.key as key from src s2 join src s3 on s2.key = s3.key
+ union all select s4.key from src s4 join src s5 on s4.key = s5.key
+ union all select s6.key from src s6 join src s7 on s6.key = s7.key) u1 on (s1.key = u1.key)
+join src s8 on (u1.key = s8.key)
+order by lkey
+POSTHOOK: type: QUERY
+STAGE DEPENDENCIES:
+ Stage-1 is a root stage
+ Stage-0 is a root stage
+
+STAGE PLANS:
+ Stage: Stage-1
+ Tez
+ Edges:
+ Map 2 <- Map 1 (BROADCAST_EDGE), Union 3 (CONTAINS), Map 5 (BROADCAST_EDGE), Map 8 (BROADCAST_EDGE)
+ Map 7 <- Map 1 (BROADCAST_EDGE), Map 6 (BROADCAST_EDGE), Union 3 (CONTAINS), Map 8 (BROADCAST_EDGE)
+ Map 9 <- Map 1 (BROADCAST_EDGE), Map 8 (BROADCAST_EDGE), Union 3 (CONTAINS), Map 10 (BROADCAST_EDGE)
+ Reducer 4 <- Union 3 (SIMPLE_EDGE)
+#### A masked pattern was here ####
+ Vertices:
+ Map 1
+ Map Operator Tree:
+ TableScan
+ alias: s1
+ Statistics: Num rows: 58 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
+ Reduce Output Operator
+ key expressions: key (type: string)
+ sort order: +
+ Map-reduce partition columns: key (type: string)
+ Statistics: Num rows: 58 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
+ value expressions: key (type: string)
+ Reduce Output Operator
+ key expressions: key (type: string)
+ sort order: +
+ Map-reduce partition columns: key (type: string)
+ Statistics: Num rows: 58 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
+ value expressions: key (type: string)
+ Reduce Output Operator
+ key expressions: key (type: string)
+ sort order: +
+ Map-reduce partition columns: key (type: string)
+ Statistics: Num rows: 58 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
+ value expressions: key (type: string)
+ Map 10
+ Map Operator Tree:
+ TableScan
+ alias: s5
+ Statistics: Num rows: 58 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
+ Reduce Output Operator
+ key expressions: key (type: string)
+ sort order: +
+ Map-reduce partition columns: key (type: string)
+ Statistics: Num rows: 58 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
+ Map 2
+ Map Operator Tree:
+ TableScan
+ alias: s2
+ Map Join Operator
+ condition map:
+ Inner Join 0 to 1
+ condition expressions:
+ 0 {key}
+ 1
+ keys:
+ 0 key (type: string)
+ 1 key (type: string)
+ outputColumnNames: _col0
+ Select Operator
+ expressions: _col0 (type: string)
+ outputColumnNames: _col0
+ Map Join Operator
+ condition map:
+ Inner Join 0 to 1
+ Inner Join 1 to 2
+ condition expressions:
+ 0 {key}
+ 1 {_col0}
+ 2 {key}
+ keys:
+ 0 key (type: string)
+ 1 _col0 (type: string)
+ 2 key (type: string)
+ outputColumnNames: _col0, _col4, _col5
+ Select Operator
+ expressions: _col0 (type: string), _col4 (type: string), _col5 (type: string)
+ outputColumnNames: _col0, _col1, _col2
+ Reduce Output Operator
+ key expressions: _col2 (type: string)
+ sort order: +
+ value expressions: _col0 (type: string), _col1 (type: string), _col2 (type: string)
+ Map 5
+ Map Operator Tree:
+ TableScan
+ alias: s3
+ Statistics: Num rows: 58 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
+ Reduce Output Operator
+ key expressions: key (type: string)
+ sort order: +
+ Map-reduce partition columns: key (type: string)
+ Statistics: Num rows: 58 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
+ Map 6
+ Map Operator Tree:
+ TableScan
+ alias: s7
+ Statistics: Num rows: 58 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
+ Reduce Output Operator
+ key expressions: key (type: string)
+ sort order: +
+ Map-reduce partition columns: key (type: string)
+ Statistics: Num rows: 58 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
+ Map 7
+ Map Operator Tree:
+ TableScan
+ alias: s6
+ Map Join Operator
+ condition map:
+ Inner Join 0 to 1
+ condition expressions:
+ 0 {key}
+ 1
+ keys:
+ 0 key (type: string)
+ 1 key (type: string)
+ outputColumnNames: _col0
+ Select Operator
+ expressions: _col0 (type: string)
+ outputColumnNames: _col0
+ Map Join Operator
+ condition map:
+ Inner Join 0 to 1
+ Inner Join 1 to 2
+ condition expressions:
+ 0 {key}
+ 1 {_col0}
+ 2 {key}
+ keys:
+ 0 key (type: string)
+ 1 _col0 (type: string)
+ 2 key (type: string)
+ outputColumnNames: _col0, _col4, _col5
+ Select Operator
+ expressions: _col0 (type: string), _col4 (type: string), _col5 (type: string)
+ outputColumnNames: _col0, _col1, _col2
+ Reduce Output Operator
+ key expressions: _col2 (type: string)
+ sort order: +
+ value expressions: _col0 (type: string), _col1 (type: string), _col2 (type: string)
+ Map 8
+ Map Operator Tree:
+ TableScan
+ alias: s8
+ Statistics: Num rows: 58 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
+ Reduce Output Operator
+ key expressions: key (type: string)
+ sort order: +
+ Map-reduce partition columns: key (type: string)
+ Statistics: Num rows: 58 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
+ value expressions: key (type: string)
+ Reduce Output Operator
+ key expressions: key (type: string)
+ sort order: +
+ Map-reduce partition columns: key (type: string)
+ Statistics: Num rows: 58 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
+ value expressions: key (type: string)
+ Reduce Output Operator
+ key expressions: key (type: string)
+ sort order: +
+ Map-reduce partition columns: key (type: string)
+ Statistics: Num rows: 58 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
+ value expressions: key (type: string)
+ Map 9
+ Map Operator Tree:
+ TableScan
+ alias: s4
+ Map Join Operator
+ condition map:
+ Inner Join 0 to 1
+ condition expressions:
+ 0 {key}
+ 1
+ keys:
+ 0 key (type: string)
+ 1 key (type: string)
+ outputColumnNames: _col0
+ Select Operator
+ expressions: _col0 (type: string)
+ outputColumnNames: _col0
+ Map Join Operator
+ condition map:
+ Inner Join 0 to 1
+ Inner Join 1 to 2
+ condition expressions:
+ 0 {key}
+ 1 {_col0}
+ 2 {key}
+ keys:
+ 0 key (type: string)
+ 1 _col0 (type: string)
+ 2 key (type: string)
+ outputColumnNames: _col0, _col4, _col5
+ Select Operator
+ expressions: _col0 (type: string), _col4 (type: string), _col5 (type: string)
+ outputColumnNames: _col0, _col1, _col2
+ Reduce Output Operator
+ key expressions: _col2 (type: string)
+ sort order: +
+ value expressions: _col0 (type: string), _col1 (type: string), _col2 (type: string)
+ Reducer 4
+ Reduce Operator Tree:
+ Extract
+ Statistics: Num rows: 415 Data size: 42193 Basic stats: COMPLETE Column stats: NONE
+ File Output Operator
+ compressed: false
+ Statistics: Num rows: 415 Data size: 42193 Basic stats: COMPLETE Column stats: NONE
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ Union 3
+ Vertex: Union 3
+
+ Stage: Stage-0
+ Fetch Operator
+ limit: -1
+
+PREHOOK: query: create table ut as
+select s1.key as skey, u1.key as ukey, s8.key as lkey from
+src s1
+join (select s2.key as key from src s2 join src s3 on s2.key = s3.key
+ union all select s4.key from src s4 join src s5 on s4.key = s5.key
+ union all select s6.key from src s6 join src s7 on s6.key = s7.key) u1 on (s1.key = u1.key)
+join src s8 on (u1.key = s8.key)
+order by lkey
+PREHOOK: type: CREATETABLE_AS_SELECT
+PREHOOK: Input: default@src
+POSTHOOK: query: create table ut as
+select s1.key as skey, u1.key as ukey, s8.key as lkey from
+src s1
+join (select s2.key as key from src s2 join src s3 on s2.key = s3.key
+ union all select s4.key from src s4 join src s5 on s4.key = s5.key
+ union all select s6.key from src s6 join src s7 on s6.key = s7.key) u1 on (s1.key = u1.key)
+join src s8 on (u1.key = s8.key)
+order by lkey
+POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@src
+POSTHOOK: Output: default@ut
+PREHOOK: query: select * from ut order by skey, ukey, lkey limit 100
+PREHOOK: type: QUERY
+PREHOOK: Input: default@ut
#### A masked pattern was here ####
-4112
+POSTHOOK: query: select * from ut order by skey, ukey, lkey limit 100
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@ut
+#### A masked pattern was here ####
+0 0 0
+0 0 0
+0 0 0
+0 0 0
+0 0 0
+0 0 0
+0 0 0
+0 0 0
+0 0 0
+0 0 0
+0 0 0
+0 0 0
+0 0 0
+0 0 0
+0 0 0
+0 0 0
+0 0 0
+0 0 0
+0 0 0
+0 0 0
+0 0 0
+0 0 0
+0 0 0
+0 0 0
+0 0 0
+0 0 0
+0 0 0
+0 0 0
+0 0 0
+0 0 0
+0 0 0
+0 0 0
+0 0 0
+0 0 0
+0 0 0
+0 0 0
+0 0 0
+0 0 0
+0 0 0
+0 0 0
+0 0 0
+0 0 0
+0 0 0
+0 0 0
+0 0 0
+0 0 0
+0 0 0
+0 0 0
+0 0 0
+0 0 0
+0 0 0
+0 0 0
+0 0 0
+0 0 0
+0 0 0
+0 0 0
+0 0 0
+0 0 0
+0 0 0
+0 0 0
+0 0 0
+0 0 0
+0 0 0
+0 0 0
+0 0 0
+0 0 0
+0 0 0
+0 0 0
+0 0 0
+0 0 0
+0 0 0
+0 0 0
+0 0 0
+0 0 0
+0 0 0
+0 0 0
+0 0 0
+0 0 0
+0 0 0
+0 0 0
+0 0 0
+0 0 0
+0 0 0
+0 0 0
+0 0 0
+0 0 0
+0 0 0
+0 0 0
+0 0 0
+0 0 0
+0 0 0
+0 0 0
+0 0 0
+0 0 0
+0 0 0
+0 0 0
+0 0 0
+0 0 0
+0 0 0
+0 0 0
+PREHOOK: query: drop table ut
+PREHOOK: type: DROPTABLE
+PREHOOK: Input: default@ut
+PREHOOK: Output: default@ut
+POSTHOOK: query: drop table ut
+POSTHOOK: type: DROPTABLE
+POSTHOOK: Input: default@ut
+POSTHOOK: Output: default@ut
+PREHOOK: query: explain
+select s2.key as key from src s2 join src s3 on s2.key = s3.key
+union all select s4.key from src s4 join src s5 on s4.key = s5.key
+PREHOOK: type: QUERY
+POSTHOOK: query: explain
+select s2.key as key from src s2 join src s3 on s2.key = s3.key
+union all select s4.key from src s4 join src s5 on s4.key = s5.key
+POSTHOOK: type: QUERY
+STAGE DEPENDENCIES:
+ Stage-1 is a root stage
+ Stage-0 is a root stage
+
+STAGE PLANS:
+ Stage: Stage-1
+ Tez
+ Edges:
+ Map 1 <- Union 2 (CONTAINS), Map 3 (BROADCAST_EDGE)
+ Map 4 <- Union 2 (CONTAINS), Map 5 (BROADCAST_EDGE)
+#### A masked pattern was here ####
+ Vertices:
+ Map 1
+ Map Operator Tree:
+ TableScan
+ alias: s2
+ Map Join Operator
+ condition map:
+ Inner Join 0 to 1
+ condition expressions:
+ 0 {key}
+ 1
+ keys:
+ 0 key (type: string)
+ 1 key (type: string)
+ outputColumnNames: _col0
+ Select Operator
+ expressions: _col0 (type: string)
+ outputColumnNames: _col0
+ Select Operator
+ expressions: _col0 (type: string)
+ outputColumnNames: _col0
+ File Output Operator
+ compressed: false
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ Map 3
+ Map Operator Tree:
+ TableScan
+ alias: s3
+ Statistics: Num rows: 58 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
+ Reduce Output Operator
+ key expressions: key (type: string)
+ sort order: +
+ Map-reduce partition columns: key (type: string)
+ Statistics: Num rows: 58 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
+ Map 4
+ Map Operator Tree:
+ TableScan
+ alias: s4
+ Map Join Operator
+ condition map:
+ Inner Join 0 to 1
+ condition expressions:
+ 0 {key}
+ 1
+ keys:
+ 0 key (type: string)
+ 1 key (type: string)
+ outputColumnNames: _col0
+ Select Operator
+ expressions: _col0 (type: string)
+ outputColumnNames: _col0
+ Select Operator
+ expressions: _col0 (type: string)
+ outputColumnNames: _col0
+ File Output Operator
+ compressed: false
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ Map 5
+ Map Operator Tree:
+ TableScan
+ alias: s5
+ Statistics: Num rows: 58 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
+ Reduce Output Operator
+ key expressions: key (type: string)
+ sort order: +
+ Map-reduce partition columns: key (type: string)
+ Statistics: Num rows: 58 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
+ Union 2
+ Vertex: Union 2
+
+ Stage: Stage-0
+ Fetch Operator
+ limit: -1
+
+PREHOOK: query: create table ut as
+select s2.key as key from src s2 join src s3 on s2.key = s3.key
+union all select s4.key from src s4 join src s5 on s4.key = s5.key
+PREHOOK: type: CREATETABLE_AS_SELECT
+PREHOOK: Input: default@src
+POSTHOOK: query: create table ut as
+select s2.key as key from src s2 join src s3 on s2.key = s3.key
+union all select s4.key from src s4 join src s5 on s4.key = s5.key
+POSTHOOK: type: CREATETABLE_AS_SELECT
+POSTHOOK: Input: default@src
+POSTHOOK: Output: default@ut
+PREHOOK: query: select * from ut order by key limit 30
+PREHOOK: type: QUERY
+PREHOOK: Input: default@ut
+#### A masked pattern was here ####
+POSTHOOK: query: select * from ut order by key limit 30
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@ut
+#### A masked pattern was here ####
+0
+0
+0
+0
+0
+0
+0
+0
+0
+0
+0
+0
+0
+0
+0
+0
+0
+0
+10
+10
+100
+100
+100
+100
+100
+100
+100
+100
+103
+103
+PREHOOK: query: drop table ut
+PREHOOK: type: DROPTABLE
+PREHOOK: Input: default@ut
+PREHOOK: Output: default@ut
+POSTHOOK: query: drop table ut
+POSTHOOK: type: DROPTABLE
+POSTHOOK: Input: default@ut
+POSTHOOK: Output: default@ut
+PREHOOK: query: explain
+select * from
+(select * from src union all select * from src) u
+left outer join src s on u.key = s.key
+PREHOOK: type: QUERY
+POSTHOOK: query: explain
+select * from
+(select * from src union all select * from src) u
+left outer join src s on u.key = s.key
+POSTHOOK: type: QUERY
+STAGE DEPENDENCIES:
+ Stage-1 is a root stage
+ Stage-0 is a root stage
+
+STAGE PLANS:
+ Stage: Stage-1
+ Tez
+ Edges:
+ Map 1 <- Union 2 (CONTAINS), Map 3 (BROADCAST_EDGE)
+ Map 4 <- Map 3 (BROADCAST_EDGE), Union 2 (CONTAINS)
+#### A masked pattern was here ####
+ Vertices:
+ Map 1
+ Map Operator Tree:
+ TableScan
+ alias: src
+ Select Operator
+ expressions: key (type: string), value (type: string)
+ outputColumnNames: _col0, _col1
+ Map Join Operator
+ condition map:
+ Left Outer Join0 to 1
+ condition expressions:
+ 0 {_col0} {_col1}
+ 1 {key} {value}
+ keys:
+ 0 _col0 (type: string)
+ 1 key (type: string)
+ outputColumnNames: _col0, _col1, _col2, _col3
+ Select Operator
+ expressions: _col0 (type: string), _col1 (type: string), _col2 (type: string), _col3 (type: string)
+ outputColumnNames: _col0, _col1, _col2, _col3
+ File Output Operator
+ compressed: false
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ Map 3
+ Map Operator Tree:
+ TableScan
+ alias: s
+ Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
+ Reduce Output Operator
+ key expressions: key (type: string)
+ sort order: +
+ Map-reduce partition columns: key (type: string)
+ Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
+ value expressions: key (type: string), value (type: string)
+ Reduce Output Operator
+ key expressions: key (type: string)
+ sort order: +
+ Map-reduce partition columns: key (type: string)
+ Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
+ value expressions: key (type: string), value (type: string)
+ Map 4
+ Map Operator Tree:
+ TableScan
+ alias: src
+ Select Operator
+ expressions: key (type: string), value (type: string)
+ outputColumnNames: _col0, _col1
+ Map Join Operator
+ condition map:
+ Left Outer Join0 to 1
+ condition expressions:
+ 0 {_col0} {_col1}
+ 1 {key} {value}
+ keys:
+ 0 _col0 (type: string)
+ 1 key (type: string)
+ outputColumnNames: _col0, _col1, _col2, _col3
+ Select Operator
+ expressions: _col0 (type: string), _col1 (type: string), _col2 (type: string), _col3 (type: string)
+ outputColumnNames: _col0, _col1, _col2, _col3
+ File Output Operator
+ compressed: false
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ Union 2
+ Vertex: Union 2
+
+ Stage: Stage-0
+ Fetch Operator
+ limit: -1
+
+PREHOOK: query: explain
+select u.key as ukey, s.key as skey from
+(select * from src union all select * from src) u
+right outer join src s on u.key = s.key
+PREHOOK: type: QUERY
+POSTHOOK: query: explain
+select u.key as ukey, s.key as skey from
+(select * from src union all select * from src) u
+right outer join src s on u.key = s.key
+POSTHOOK: type: QUERY
+STAGE DEPENDENCIES:
+ Stage-1 is a root stage
+ Stage-0 is a root stage
+
+STAGE PLANS:
+ Stage: Stage-1
+ Tez
+ Edges:
+ Map 1 <- Union 2 (CONTAINS)
+ Map 3 <- Union 2 (BROADCAST_EDGE)
+ Map 4 <- Union 2 (CONTAINS)
+#### A masked pattern was here ####
+ Vertices:
+ Map 1
+ Map Operator Tree:
+ TableScan
+ alias: src
+ Select Operator
+ expressions: key (type: string), value (type: string)
+ outputColumnNames: _col0, _col1
+ Reduce Output Operator
+ key expressions: _col0 (type: string)
+ sort order: +
+ Map-reduce partition columns: _col0 (type: string)
+ value expressions: _col0 (type: string)
+ Map 3
+ Map Operator Tree:
+ TableScan
+ alias: s
+ Statistics: Num rows: 58 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
+ Map Join Operator
+ condition map:
+ Right Outer Join0 to 1
+ condition expressions:
+ 0 {_col0}
+ 1 {key}
+ keys:
+ 0 _col0 (type: string)
+ 1 key (type: string)
+ outputColumnNames: _col0, _col2
+ Statistics: Num rows: 63 Data size: 12786 Basic stats: COMPLETE Column stats: NONE
+ Select Operator
+ expressions: _col0 (type: string), _col2 (type: string)
+ outputColumnNames: _col0, _col1
+ Statistics: Num rows: 63 Data size: 12786 Basic stats: COMPLETE Column stats: NONE
+ File Output Operator
+ compressed: false
+ Statistics: Num rows: 63 Data size: 12786 Basic stats: COMPLETE Column stats: NONE
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ Map 4
+ Map Operator Tree:
+ TableScan
+ alias: src
+ Select Operator
+ expressions: key (type: string), value (type: string)
+ outputColumnNames: _col0, _col1
+ Reduce Output Operator
+ key expressions: _col0 (type: string)
+ sort order: +
+ Map-reduce partition columns: _col0 (type: string)
+ value expressions: _col0 (type: string)
+ Union 2
+ Vertex: Union 2
+
+ Stage: Stage-0
+ Fetch Operator
+ limit: -1
+
+PREHOOK: query: create table ut as
+select u.key as ukey, s.key as skey from
+(select * from src union all select * from src) u
+right outer join src s on u.key = s.key
+PREHOOK: type: CREATETABLE_AS_SELECT
+PREHOOK: Input: default@src
+POSTHOOK: query: create table ut as
+select u.key as ukey, s.key as skey from
+(select * from src union all select * from src) u
+right outer join src s on u.key = s.key
+POSTHOOK: type: CREATETABLE_AS_SELECT
+POSTHOOK: Input: default@src
+POSTHOOK: Output: default@ut
+PREHOOK: query: select * from ut order by ukey, skey limit 20
+PREHOOK: type: QUERY
+PREHOOK: Input: default@ut
+#### A masked pattern was here ####
+POSTHOOK: query: select * from ut order by ukey, skey limit 20
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@ut
+#### A masked pattern was here ####
+0 0
+0 0
+0 0
+0 0
+0 0
+0 0
+0 0
+0 0
+0 0
+0 0
+0 0
+0 0
+0 0
+0 0
+0 0
+0 0
+0 0
+0 0
+10 10
+10 10
+PREHOOK: query: drop table ut
+PREHOOK: type: DROPTABLE
+PREHOOK: Input: default@ut
+PREHOOK: Output: default@ut
+POSTHOOK: query: drop table ut
+POSTHOOK: type: DROPTABLE
+POSTHOOK: Input: default@ut
+POSTHOOK: Output: default@ut
Modified: hive/trunk/ql/src/test/results/clientpositive/tez/vectorization_15.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/tez/vectorization_15.q.out?rev=1582488&r1=1582487&r2=1582488&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/tez/vectorization_15.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/tez/vectorization_15.q.out Thu Mar 27 21:45:22 2014
@@ -77,32 +77,32 @@ NULL true 10419.0 10 NULL -721614386 NUL
NULL true 14519.0 100xJdkyc NULL 729277608 NULL NULL -7.2927763428E8 14519.0 1155030.007 NULL NULL NULL -23.0 NULL 0.0 NULL NULL 7.2927763428E8 0.0
-62.0 NULL 15601.0 NULL -62 NULL 1969-12-31 16:00:09.889 0.0 NULL 15601.0 1241106.353 33.0 0.0 0.0 -23.0 62 NULL NULL -23 NULL NULL
-51.0 NULL -200.0 NULL -51 NULL 1969-12-31 15:59:55.423 0.0 NULL -200.0 -15910.599999999999 33.0 0.0 0.0 -23.0 51 NULL NULL -23 NULL NULL
--51.0 false NULL 10 -51 1058319346 1969-12-31 16:00:08.451 0.0 -1.05831937228E9 NULL NULL 33.0 0.0 0.0 NULL 51 0.0 1.058319397E9 -23 1.05831937228E9 0.0
--51.0 false NULL 10TYIE5S35U6dj3N -51 -469581869 1969-12-31 16:00:08.451 0.0 4.6958184272E8 NULL NULL 33.0 0.0 0.0 NULL 51 0.0 -4.69581818E8 -23 -4.6958184272E8 0.0
--51.0 false NULL 1Lh6Uoq3WhNtOqQHu7WN7U -51 -352637533 1969-12-31 16:00:08.451 0.0 3.5263750672E8 NULL NULL 33.0 0.0 0.0 NULL 51 0.0 -3.52637482E8 -23 -3.5263750672E8 0.0
--51.0 true NULL 04Y1mA17 -51 -114647521 1969-12-31 16:00:08.451 0.0 1.1464749472E8 NULL NULL 33.0 0.0 0.0 NULL 51 0.0 -1.1464747E8 -23 -1.1464749472E8 0.0
+-51.0 false NULL 10 -51 1058319346 1969-12-31 16:00:08.451 0.0 -1.05831937228E9 NULL NULL 33.0 0.0 0.0 NULL 51 0.0 1.05831942E9 -23 1.05831937228E9 0.0
+-51.0 false NULL 10TYIE5S35U6dj3N -51 -469581869 1969-12-31 16:00:08.451 0.0 4.6958184272E8 NULL NULL 33.0 0.0 0.0 NULL 51 0.0 -4.69581792E8 -23 -4.6958184272E8 0.0
+-51.0 false NULL 1Lh6Uoq3WhNtOqQHu7WN7U -51 -352637533 1969-12-31 16:00:08.451 0.0 3.5263750672E8 NULL NULL 33.0 0.0 0.0 NULL 51 0.0 -3.52637472E8 -23 -3.5263750672E8 0.0
+-51.0 true NULL 04Y1mA17 -51 -114647521 1969-12-31 16:00:08.451 0.0 1.1464749472E8 NULL NULL 33.0 0.0 0.0 NULL 51 0.0 -1.14647472E8 -23 -1.1464749472E8 0.0
-51.0 true NULL 10Wu570aLPO0p02P17FeH -51 405338893 1969-12-31 16:00:08.451 0.0 -4.0533891928E8 NULL NULL 33.0 0.0 0.0 NULL 51 0.0 4.05338944E8 -23 4.0533891928E8 0.0
-51.0 true NULL 3cQp060 -51 -226923315 1969-12-31 16:00:08.451 0.0 2.2692328872E8 NULL NULL 33.0 0.0 0.0 NULL 51 0.0 -2.26923264E8 -23 -2.2692328872E8 0.0
--51.0 true NULL 8EPG0Xi307qd -51 -328662044 1969-12-31 16:00:08.451 0.0 3.2866201772E8 NULL NULL 33.0 0.0 0.0 NULL 51 0.0 -3.28661993E8 -23 -3.2866201772E8 0.0
--51.0 true NULL 8iHtdkJ6d -51 1006818344 1969-12-31 16:00:08.451 0.0 -1.00681837028E9 NULL NULL 33.0 0.0 0.0 NULL 51 0.0 1.006818395E9 -23 1.00681837028E9 0.0
--51.0 true NULL QiOcvR0kt6r7f0R7fiPxQTCU -51 266531954 1969-12-31 16:00:08.451 0.0 -2.6653198028E8 NULL NULL 33.0 0.0 0.0 NULL 51 0.0 2.66532005E8 -23 2.6653198028E8 0.0
--51.0 true NULL Ybpj38RTTYl7CnJXPNx1g4C -51 -370919370 1969-12-31 16:00:08.451 0.0 3.7091934372E8 NULL NULL 33.0 0.0 0.0 NULL 51 0.0 -3.70919319E8 -23 -3.7091934372E8 0.0
+-51.0 true NULL 8EPG0Xi307qd -51 -328662044 1969-12-31 16:00:08.451 0.0 3.2866201772E8 NULL NULL 33.0 0.0 0.0 NULL 51 0.0 -3.28661984E8 -23 -3.2866201772E8 0.0
+-51.0 true NULL 8iHtdkJ6d -51 1006818344 1969-12-31 16:00:08.451 0.0 -1.00681837028E9 NULL NULL 33.0 0.0 0.0 NULL 51 0.0 1.00681843E9 -23 1.00681837028E9 0.0
+-51.0 true NULL QiOcvR0kt6r7f0R7fiPxQTCU -51 266531954 1969-12-31 16:00:08.451 0.0 -2.6653198028E8 NULL NULL 33.0 0.0 0.0 NULL 51 0.0 2.66532E8 -23 2.6653198028E8 0.0
+-51.0 true NULL Ybpj38RTTYl7CnJXPNx1g4C -51 -370919370 1969-12-31 16:00:08.451 0.0 3.7091934372E8 NULL NULL 33.0 0.0 0.0 NULL 51 0.0 -3.70919296E8 -23 -3.7091934372E8 0.0
-48.0 NULL -7196.0 NULL -48 NULL 1969-12-31 16:00:06.337 0.0 NULL -7196.0 -572463.388 33.0 0.0 0.0 -23.0 48 NULL NULL -23 NULL NULL
-6.0 NULL -200.0 NULL -6 NULL 1969-12-31 15:59:56.094 0.0 NULL -200.0 -15910.599999999999 3.0 0.0 0.0 -23.0 6 NULL NULL -5 NULL NULL
5.0 NULL 15601.0 NULL 5 NULL 1969-12-31 16:00:00.959 0.0 NULL 15601.0 1241106.353 3.0 0.0 0.0 -23.0 -5 NULL NULL -3 NULL NULL
-8.0 false NULL 10V3pN5r5lI2qWl2lG103 8 -362835731 1969-12-31 16:00:15.892 0.0 3.6283570472E8 NULL NULL 1.0 0.0 0.0 NULL -8 0.0 -3.62835739E8 -7 -3.6283570472E8 0.0
-8.0 false NULL 10c4qt584m5y6uWT 8 -183000142 1969-12-31 16:00:15.892 0.0 1.8300011572E8 NULL NULL 1.0 0.0 0.0 NULL -8 0.0 -1.8300015E8 -7 -1.8300011572E8 0.0
+8.0 false NULL 10V3pN5r5lI2qWl2lG103 8 -362835731 1969-12-31 16:00:15.892 0.0 3.6283570472E8 NULL NULL 1.0 0.0 0.0 NULL -8 0.0 -3.62835744E8 -7 -3.6283570472E8 0.0
+8.0 false NULL 10c4qt584m5y6uWT 8 -183000142 1969-12-31 16:00:15.892 0.0 1.8300011572E8 NULL NULL 1.0 0.0 0.0 NULL -8 0.0 -1.8300016E8 -7 -1.8300011572E8 0.0
8.0 false NULL 8GloEukQ0c68JDmnYL53 8 -722873402 1969-12-31 16:00:15.892 0.0 7.2287337572E8 NULL NULL 1.0 0.0 0.0 NULL -8 0.0 -7.2287341E8 -7 -7.2287337572E8 0.0
8.0 false NULL kA0XH5C5 8 -503903864 1969-12-31 16:00:15.892 0.0 5.0390383772E8 NULL NULL 1.0 0.0 0.0 NULL -8 0.0 -5.03903872E8 -7 -5.0390383772E8 0.0
-8.0 true NULL 100VTM7PEW8GH1uE 8 88129338 1969-12-31 16:00:15.892 0.0 -8.812936428E7 NULL NULL 1.0 0.0 0.0 NULL -8 0.0 8.812933E7 -7 8.812936428E7 0.0
-8.0 true NULL 1062158y 8 -1005155523 1969-12-31 16:00:15.892 0.0 1.00515549672E9 NULL NULL 1.0 0.0 0.0 NULL -8 0.0 -1.005155531E9 -7 -1.00515549672E9 0.0
-8.0 true NULL 1063cEnGjSal 8 -624769630 1969-12-31 16:00:15.892 0.0 6.2476960372E8 NULL NULL 1.0 0.0 0.0 NULL -8 0.0 -6.24769638E8 -7 -6.2476960372E8 0.0
-8.0 true NULL 4kMasVoB7lX1wc5i64bNk 8 683567667 1969-12-31 16:00:15.892 0.0 -6.8356769328E8 NULL NULL 1.0 0.0 0.0 NULL -8 0.0 6.83567659E8 -7 6.8356769328E8 0.0
-8.0 true NULL XH6I7A417 8 436627202 1969-12-31 16:00:15.892 0.0 -4.3662722828E8 NULL NULL 1.0 0.0 0.0 NULL -8 0.0 4.36627194E8 -7 4.3662722828E8 0.0
-11.0 false NULL 10pO8p1LNx4Y 11 271296824 1969-12-31 16:00:02.351 0.0 -2.7129685028E8 NULL NULL 0.0 0.0 0.0 NULL -11 0.0 2.71296813E8 -1 2.7129685028E8 0.0
-11.0 false NULL 1H6wGP 11 -560827082 1969-12-31 16:00:02.351 0.0 5.6082705572E8 NULL NULL 0.0 0.0 0.0 NULL -11 0.0 -5.60827093E8 -1 -5.6082705572E8 0.0
-11.0 false NULL 2a7V63IL7jK3o 11 -325931647 1969-12-31 16:00:02.351 0.0 3.2593162072E8 NULL NULL 0.0 0.0 0.0 NULL -11 0.0 -3.25931658E8 -1 -3.2593162072E8 0.0
-11.0 true NULL 10 11 92365813 1969-12-31 16:00:02.351 0.0 -9.236583928E7 NULL NULL 0.0 0.0 0.0 NULL -11 0.0 9.2365802E7 -1 9.236583928E7 0.0
+8.0 true NULL 100VTM7PEW8GH1uE 8 88129338 1969-12-31 16:00:15.892 0.0 -8.812936428E7 NULL NULL 1.0 0.0 0.0 NULL -8 0.0 8.8129328E7 -7 8.812936428E7 0.0
+8.0 true NULL 1062158y 8 -1005155523 1969-12-31 16:00:15.892 0.0 1.00515549672E9 NULL NULL 1.0 0.0 0.0 NULL -8 0.0 -1.00515552E9 -7 -1.00515549672E9 0.0
+8.0 true NULL 1063cEnGjSal 8 -624769630 1969-12-31 16:00:15.892 0.0 6.2476960372E8 NULL NULL 1.0 0.0 0.0 NULL -8 0.0 -6.247696E8 -7 -6.2476960372E8 0.0
+8.0 true NULL 4kMasVoB7lX1wc5i64bNk 8 683567667 1969-12-31 16:00:15.892 0.0 -6.8356769328E8 NULL NULL 1.0 0.0 0.0 NULL -8 0.0 6.8356768E8 -7 6.8356769328E8 0.0
+8.0 true NULL XH6I7A417 8 436627202 1969-12-31 16:00:15.892 0.0 -4.3662722828E8 NULL NULL 1.0 0.0 0.0 NULL -8 0.0 4.366272E8 -7 4.3662722828E8 0.0
+11.0 false NULL 10pO8p1LNx4Y 11 271296824 1969-12-31 16:00:02.351 0.0 -2.7129685028E8 NULL NULL 0.0 0.0 0.0 NULL -11 0.0 2.71296832E8 -1 2.7129685028E8 0.0
+11.0 false NULL 1H6wGP 11 -560827082 1969-12-31 16:00:02.351 0.0 5.6082705572E8 NULL NULL 0.0 0.0 0.0 NULL -11 0.0 -5.6082707E8 -1 -5.6082705572E8 0.0
+11.0 false NULL 2a7V63IL7jK3o 11 -325931647 1969-12-31 16:00:02.351 0.0 3.2593162072E8 NULL NULL 0.0 0.0 0.0 NULL -11 0.0 -3.25931648E8 -1 -3.2593162072E8 0.0
+11.0 true NULL 10 11 92365813 1969-12-31 16:00:02.351 0.0 -9.236583928E7 NULL NULL 0.0 0.0 0.0 NULL -11 0.0 9.2365808E7 -1 9.236583928E7 0.0
21.0 NULL 15601.0 NULL 21 NULL 1969-12-31 16:00:14.256 0.0 NULL 15601.0 1241106.353 12.0 0.0 0.0 -23.0 -21 NULL NULL -2 NULL NULL
32.0 NULL -200.0 NULL 32 NULL 1969-12-31 16:00:02.445 0.0 NULL -200.0 -15910.599999999999 1.0 0.0 0.0 -23.0 -32 NULL NULL -23 NULL NULL
36.0 NULL -200.0 NULL 36 NULL 1969-12-31 16:00:00.554 0.0 NULL -200.0 -15910.599999999999 33.0 0.0 0.0 -23.0 -36 NULL NULL -23 NULL NULL