You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by dj...@apache.org on 2018/05/08 18:42:41 UTC
[36/58] [abbrv] hive git commit: HIVE-18910 : Migrate to Murmur hash
for shuffle and bucketing (Deepak Jaiswal, reviewed by Jasone Dere)
http://git-wip-us.apache.org/repos/asf/hive/blob/091fd962/ql/src/test/results/clientpositive/llap/insert_values_orig_table_use_metadata.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/insert_values_orig_table_use_metadata.q.out b/ql/src/test/results/clientpositive/llap/insert_values_orig_table_use_metadata.q.out
index 9179be5..26808e4 100644
--- a/ql/src/test/results/clientpositive/llap/insert_values_orig_table_use_metadata.q.out
+++ b/ql/src/test/results/clientpositive/llap/insert_values_orig_table_use_metadata.q.out
@@ -102,6 +102,7 @@ Retention: 0
Table Type: MANAGED_TABLE
Table Parameters:
COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\",\"COLUMN_STATS\":{\"cbigint\":\"true\",\"cboolean1\":\"true\",\"cboolean2\":\"true\",\"cdouble\":\"true\",\"cfloat\":\"true\",\"cint\":\"true\",\"csmallint\":\"true\",\"cstring1\":\"true\",\"cstring2\":\"true\",\"ctimestamp1\":\"true\",\"ctimestamp2\":\"true\",\"ctinyint\":\"true\"}}
+ bucketing_version 2
numFiles 0
numRows 0
rawDataSize 0
@@ -167,6 +168,7 @@ Retention: 0
#### A masked pattern was here ####
Table Type: MANAGED_TABLE
Table Parameters:
+ bucketing_version 2
numFiles 1
totalSize 295438
transactional true
@@ -372,6 +374,7 @@ Retention: 0
#### A masked pattern was here ####
Table Type: MANAGED_TABLE
Table Parameters:
+ bucketing_version 2
numFiles 1
totalSize 1574
transactional true
@@ -504,6 +507,7 @@ Retention: 0
#### A masked pattern was here ####
Table Type: MANAGED_TABLE
Table Parameters:
+ bucketing_version 2
numFiles 2
totalSize 3149
transactional true
@@ -632,6 +636,7 @@ Retention: 0
#### A masked pattern was here ####
Table Type: MANAGED_TABLE
Table Parameters:
+ bucketing_version 2
numFiles 3
totalSize 298588
transactional true
http://git-wip-us.apache.org/repos/asf/hive/blob/091fd962/ql/src/test/results/clientpositive/llap/intersect_all.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/intersect_all.q.out b/ql/src/test/results/clientpositive/llap/intersect_all.q.out
index 9c67a99..d0719a3 100644
--- a/ql/src/test/results/clientpositive/llap/intersect_all.q.out
+++ b/ql/src/test/results/clientpositive/llap/intersect_all.q.out
@@ -290,506 +290,506 @@ POSTHOOK: query: select * from src intersect all select * from src
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
POSTHOOK: Output: hdfs://### HDFS PATH ###
-0 val_0
-0 val_0
-0 val_0
-103 val_103
-103 val_103
+104 val_104
+104 val_104
105 val_105
-116 val_116
+113 val_113
+113 val_113
+118 val_118
+118 val_118
+12 val_12
+12 val_12
120 val_120
120 val_120
-129 val_129
-129 val_129
-131 val_131
+133 val_133
136 val_136
155 val_155
-157 val_157
+158 val_158
160 val_160
+162 val_162
+168 val_168
+17 val_17
+170 val_170
+175 val_175
+175 val_175
+18 val_18
+18 val_18
180 val_180
-183 val_183
-190 val_190
-191 val_191
-191 val_191
-193 val_193
-193 val_193
-193 val_193
-205 val_205
-205 val_205
-207 val_207
-207 val_207
-213 val_213
-213 val_213
-223 val_223
-223 val_223
+186 val_186
+19 val_19
+197 val_197
+197 val_197
+200 val_200
+200 val_200
+216 val_216
+216 val_216
+218 val_218
+222 val_222
+224 val_224
+224 val_224
+228 val_228
235 val_235
-238 val_238
-238 val_238
+237 val_237
+237 val_237
239 val_239
239 val_239
-24 val_24
-24 val_24
-248 val_248
-260 val_260
+244 val_244
+247 val_247
+256 val_256
+256 val_256
+263 val_263
+273 val_273
+273 val_273
+273 val_273
28 val_28
+283 val_283
286 val_286
-298 val_298
-298 val_298
-298 val_298
-305 val_305
+292 val_292
306 val_306
-307 val_307
-307 val_307
308 val_308
-315 val_315
-317 val_317
-317 val_317
-321 val_321
-321 val_321
+327 val_327
+327 val_327
+327 val_327
33 val_33
-331 val_331
-331 val_331
-356 val_356
-360 val_360
+348 val_348
+348 val_348
+348 val_348
+348 val_348
+348 val_348
+353 val_353
+353 val_353
+362 val_362
366 val_366
-367 val_367
-367 val_367
-368 val_368
-37 val_37
-37 val_37
-378 val_378
-379 val_379
-382 val_382
-382 val_382
-389 val_389
-395 val_395
-395 val_395
-400 val_400
-402 val_402
-406 val_406
-406 val_406
-406 val_406
-406 val_406
-407 val_407
-42 val_42
-42 val_42
-430 val_430
-430 val_430
-430 val_430
+396 val_396
+396 val_396
+396 val_396
+397 val_397
+397 val_397
+401 val_401
+401 val_401
+401 val_401
+401 val_401
+401 val_401
+409 val_409
+409 val_409
+409 val_409
+411 val_411
+419 val_419
+427 val_427
+43 val_43
+432 val_432
436 val_436
-44 val_44
-452 val_452
-466 val_466
-466 val_466
-466 val_466
-467 val_467
+439 val_439
+439 val_439
+443 val_443
+453 val_453
+460 val_460
+462 val_462
+462 val_462
+47 val_47
472 val_472
-480 val_480
-480 val_480
-480 val_480
-484 val_484
485 val_485
-487 val_487
-495 val_495
496 val_496
-498 val_498
-498 val_498
-498 val_498
-51 val_51
-51 val_51
-57 val_57
-58 val_58
-58 val_58
-65 val_65
-66 val_66
-69 val_69
+54 val_54
+64 val_64
70 val_70
70 val_70
70 val_70
-78 val_78
8 val_8
-92 val_92
-96 val_96
-104 val_104
-104 val_104
-111 val_111
+83 val_83
+83 val_83
+84 val_84
+84 val_84
+85 val_85
+90 val_90
+90 val_90
+90 val_90
+0 val_0
+0 val_0
+0 val_0
+103 val_103
+103 val_103
114 val_114
-118 val_118
-118 val_118
-12 val_12
-12 val_12
-133 val_133
+125 val_125
+125 val_125
138 val_138
138 val_138
138 val_138
138 val_138
+146 val_146
+146 val_146
+150 val_150
+152 val_152
+152 val_152
153 val_153
156 val_156
-162 val_162
-168 val_168
-174 val_174
-174 val_174
-176 val_176
-176 val_176
-178 val_178
-181 val_181
-186 val_186
+157 val_157
+165 val_165
+165 val_165
+172 val_172
+172 val_172
+177 val_177
+179 val_179
+179 val_179
187 val_187
187 val_187
187 val_187
-192 val_192
-197 val_197
-197 val_197
-199 val_199
-199 val_199
-199 val_199
-2 val_2
-201 val_201
-203 val_203
-203 val_203
-208 val_208
-208 val_208
-208 val_208
-214 val_214
-218 val_218
-219 val_219
-219 val_219
-230 val_230
-230 val_230
-230 val_230
-230 val_230
-230 val_230
-237 val_237
-237 val_237
-249 val_249
-256 val_256
-256 val_256
-257 val_257
-277 val_277
-277 val_277
-277 val_277
-277 val_277
-278 val_278
-278 val_278
-284 val_284
-285 val_285
-310 val_310
+195 val_195
+195 val_195
+196 val_196
+217 val_217
+217 val_217
+242 val_242
+242 val_242
+248 val_248
+252 val_252
+265 val_265
+265 val_265
+27 val_27
+272 val_272
+272 val_272
+280 val_280
+280 val_280
+291 val_291
+305 val_305
+309 val_309
+309 val_309
+311 val_311
+311 val_311
+311 val_311
+315 val_315
+317 val_317
+317 val_317
322 val_322
322 val_322
-327 val_327
-327 val_327
-327 val_327
333 val_333
333 val_333
-336 val_336
-338 val_338
-341 val_341
-344 val_344
-344 val_344
-348 val_348
-348 val_348
-348 val_348
-348 val_348
-348 val_348
-351 val_351
-362 val_362
+34 val_34
+345 val_345
+35 val_35
+35 val_35
+35 val_35
+356 val_356
364 val_364
-374 val_374
-392 val_392
-397 val_397
-397 val_397
+368 val_368
+369 val_369
+369 val_369
+369 val_369
+37 val_37
+37 val_37
+373 val_373
+377 val_377
4 val_4
-403 val_403
-403 val_403
-403 val_403
+402 val_402
404 val_404
404 val_404
-419 val_419
-421 val_421
-427 val_427
-429 val_429
-429 val_429
-437 val_437
-438 val_438
-438 val_438
-438 val_438
-439 val_439
-439 val_439
+413 val_413
+413 val_413
+42 val_42
+42 val_42
+430 val_430
+430 val_430
+430 val_430
+431 val_431
+431 val_431
+431 val_431
+444 val_444
+449 val_449
+452 val_452
454 val_454
454 val_454
454 val_454
-455 val_455
-460 val_460
+457 val_457
463 val_463
463 val_463
+466 val_466
+466 val_466
+466 val_466
470 val_470
-478 val_478
-478 val_478
-479 val_479
+475 val_475
+481 val_481
489 val_489
489 val_489
489 val_489
489 val_489
491 val_491
-492 val_492
-492 val_492
-53 val_53
-67 val_67
-67 val_67
-82 val_82
-90 val_90
-90 val_90
-90 val_90
-97 val_97
-97 val_97
-10 val_10
-125 val_125
-125 val_125
-134 val_134
-134 val_134
-143 val_143
+57 val_57
+65 val_65
+66 val_66
+74 val_74
+76 val_76
+76 val_76
+78 val_78
+9 val_9
+92 val_92
+95 val_95
+95 val_95
+100 val_100
+100 val_100
+119 val_119
+119 val_119
+119 val_119
+128 val_128
+128 val_128
+128 val_128
+129 val_129
+129 val_129
145 val_145
-149 val_149
-149 val_149
-150 val_150
-158 val_158
-163 val_163
-164 val_164
-164 val_164
-166 val_166
-17 val_17
-170 val_170
-172 val_172
-172 val_172
-189 val_189
-19 val_19
-195 val_195
-195 val_195
-196 val_196
+167 val_167
+167 val_167
+167 val_167
+174 val_174
+174 val_174
+178 val_178
+181 val_181
+193 val_193
+193 val_193
+193 val_193
+199 val_199
+199 val_199
+199 val_199
20 val_20
-209 val_209
-209 val_209
-216 val_216
-216 val_216
-217 val_217
-217 val_217
-224 val_224
-224 val_224
-228 val_228
-229 val_229
-229 val_229
+201 val_201
+213 val_213
+213 val_213
+214 val_214
+219 val_219
+219 val_219
+221 val_221
+221 val_221
+223 val_223
+223 val_223
+226 val_226
233 val_233
233 val_233
241 val_241
-244 val_244
-247 val_247
-255 val_255
-255 val_255
-258 val_258
-26 val_26
-26 val_26
-263 val_263
-265 val_265
-265 val_265
-266 val_266
-272 val_272
-272 val_272
-273 val_273
-273 val_273
-273 val_273
-274 val_274
+249 val_249
+260 val_260
+262 val_262
+277 val_277
+277 val_277
+277 val_277
+277 val_277
281 val_281
281 val_281
-291 val_291
-296 val_296
-30 val_30
+287 val_287
+288 val_288
+288 val_288
+298 val_298
+298 val_298
+298 val_298
302 val_302
-309 val_309
-309 val_309
-316 val_316
-316 val_316
-316 val_316
-318 val_318
-318 val_318
-318 val_318
-325 val_325
-325 val_325
-332 val_332
-335 val_335
-339 val_339
-342 val_342
-342 val_342
-345 val_345
-353 val_353
-353 val_353
-369 val_369
-369 val_369
-369 val_369
-373 val_373
+310 val_310
+323 val_323
+336 val_336
+341 val_341
+344 val_344
+344 val_344
+351 val_351
375 val_375
-377 val_377
+382 val_382
+382 val_382
384 val_384
384 val_384
384 val_384
-386 val_386
-394 val_394
-396 val_396
-396 val_396
-396 val_396
+393 val_393
+395 val_395
+395 val_395
399 val_399
399 val_399
-401 val_401
-401 val_401
-401 val_401
-401 val_401
-401 val_401
-41 val_41
-413 val_413
-413 val_413
-414 val_414
-414 val_414
-431 val_431
-431 val_431
-431 val_431
-446 val_446
-448 val_448
-449 val_449
+403 val_403
+403 val_403
+403 val_403
+406 val_406
+406 val_406
+406 val_406
+406 val_406
+418 val_418
+435 val_435
+455 val_455
459 val_459
459 val_459
-462 val_462
-462 val_462
-468 val_468
-468 val_468
-468 val_468
-468 val_468
-47 val_47
+477 val_477
+478 val_478
+478 val_478
+479 val_479
482 val_482
-490 val_490
493 val_493
494 val_494
+495 val_495
497 val_497
5 val_5
5 val_5
5 val_5
-54 val_54
-74 val_74
+58 val_58
+58 val_58
+67 val_67
+67 val_67
77 val_77
80 val_80
-84 val_84
-84 val_84
-85 val_85
-87 val_87
-9 val_9
-95 val_95
-95 val_95
-100 val_100
-100 val_100
+86 val_86
+97 val_97
+97 val_97
+98 val_98
+98 val_98
+10 val_10
11 val_11
-113 val_113
-113 val_113
-119 val_119
-119 val_119
-119 val_119
+111 val_111
+116 val_116
126 val_126
-128 val_128
-128 val_128
-128 val_128
+131 val_131
+134 val_134
+134 val_134
137 val_137
137 val_137
-146 val_146
-146 val_146
+143 val_143
+149 val_149
+149 val_149
15 val_15
15 val_15
-152 val_152
-152 val_152
-165 val_165
-165 val_165
-167 val_167
-167 val_167
-167 val_167
+163 val_163
+164 val_164
+164 val_164
+166 val_166
169 val_169
169 val_169
169 val_169
169 val_169
-175 val_175
-175 val_175
-177 val_177
-179 val_179
-179 val_179
-18 val_18
-18 val_18
+176 val_176
+176 val_176
+183 val_183
+189 val_189
+190 val_190
+191 val_191
+191 val_191
+192 val_192
194 val_194
-200 val_200
-200 val_200
+2 val_2
202 val_202
-221 val_221
-221 val_221
-222 val_222
-226 val_226
-242 val_242
-242 val_242
-252 val_252
-262 val_262
-27 val_27
+203 val_203
+203 val_203
+205 val_205
+205 val_205
+207 val_207
+207 val_207
+208 val_208
+208 val_208
+208 val_208
+209 val_209
+209 val_209
+229 val_229
+229 val_229
+230 val_230
+230 val_230
+230 val_230
+230 val_230
+230 val_230
+238 val_238
+238 val_238
+24 val_24
+24 val_24
+255 val_255
+255 val_255
+257 val_257
+258 val_258
+26 val_26
+26 val_26
+266 val_266
+274 val_274
275 val_275
-280 val_280
-280 val_280
+278 val_278
+278 val_278
282 val_282
282 val_282
-283 val_283
-287 val_287
-288 val_288
-288 val_288
+284 val_284
+285 val_285
289 val_289
-292 val_292
-311 val_311
-311 val_311
-311 val_311
-323 val_323
-34 val_34
-35 val_35
-35 val_35
-35 val_35
+296 val_296
+30 val_30
+307 val_307
+307 val_307
+316 val_316
+316 val_316
+316 val_316
+318 val_318
+318 val_318
+318 val_318
+321 val_321
+321 val_321
+325 val_325
+325 val_325
+331 val_331
+331 val_331
+332 val_332
+335 val_335
+338 val_338
+339 val_339
+342 val_342
+342 val_342
+360 val_360
365 val_365
-393 val_393
-409 val_409
-409 val_409
-409 val_409
-411 val_411
+367 val_367
+367 val_367
+374 val_374
+378 val_378
+379 val_379
+386 val_386
+389 val_389
+392 val_392
+394 val_394
+400 val_400
+407 val_407
+41 val_41
+414 val_414
+414 val_414
417 val_417
417 val_417
417 val_417
-418 val_418
+421 val_421
424 val_424
424 val_424
-43 val_43
-432 val_432
-435 val_435
-443 val_443
-444 val_444
-453 val_453
-457 val_457
+429 val_429
+429 val_429
+437 val_437
+438 val_438
+438 val_438
+438 val_438
+44 val_44
+446 val_446
+448 val_448
458 val_458
458 val_458
+467 val_467
+468 val_468
+468 val_468
+468 val_468
+468 val_468
469 val_469
469 val_469
469 val_469
469 val_469
469 val_469
-475 val_475
-477 val_477
-481 val_481
+480 val_480
+480 val_480
+480 val_480
483 val_483
-64 val_64
+484 val_484
+487 val_487
+490 val_490
+492 val_492
+492 val_492
+498 val_498
+498 val_498
+498 val_498
+51 val_51
+51 val_51
+53 val_53
+69 val_69
72 val_72
72 val_72
-76 val_76
-76 val_76
-83 val_83
-83 val_83
-86 val_86
-98 val_98
-98 val_98
+82 val_82
+87 val_87
+96 val_96
PREHOOK: query: explain select * from src intersect all select * from src intersect all select * from src intersect all select * from src
PREHOOK: type: QUERY
POSTHOOK: query: explain select * from src intersect all select * from src intersect all select * from src intersect all select * from src
@@ -1033,506 +1033,506 @@ POSTHOOK: query: select * from src intersect all select * from src intersect all
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
POSTHOOK: Output: hdfs://### HDFS PATH ###
-0 val_0
-0 val_0
-0 val_0
-103 val_103
-103 val_103
+104 val_104
+104 val_104
105 val_105
-116 val_116
+113 val_113
+113 val_113
+118 val_118
+118 val_118
+12 val_12
+12 val_12
120 val_120
120 val_120
-129 val_129
-129 val_129
-131 val_131
+133 val_133
136 val_136
155 val_155
-157 val_157
+158 val_158
160 val_160
+162 val_162
+168 val_168
+17 val_17
+170 val_170
+175 val_175
+175 val_175
+18 val_18
+18 val_18
180 val_180
-183 val_183
-190 val_190
-191 val_191
-191 val_191
-193 val_193
-193 val_193
-193 val_193
-205 val_205
-205 val_205
-207 val_207
-207 val_207
-213 val_213
-213 val_213
-223 val_223
-223 val_223
+186 val_186
+19 val_19
+197 val_197
+197 val_197
+200 val_200
+200 val_200
+216 val_216
+216 val_216
+218 val_218
+222 val_222
+224 val_224
+224 val_224
+228 val_228
235 val_235
-238 val_238
-238 val_238
+237 val_237
+237 val_237
239 val_239
239 val_239
-24 val_24
-24 val_24
-248 val_248
-260 val_260
+244 val_244
+247 val_247
+256 val_256
+256 val_256
+263 val_263
+273 val_273
+273 val_273
+273 val_273
28 val_28
+283 val_283
286 val_286
-298 val_298
-298 val_298
-298 val_298
-305 val_305
+292 val_292
306 val_306
-307 val_307
-307 val_307
308 val_308
+327 val_327
+327 val_327
+327 val_327
+33 val_33
+348 val_348
+348 val_348
+348 val_348
+348 val_348
+348 val_348
+353 val_353
+353 val_353
+362 val_362
+366 val_366
+396 val_396
+396 val_396
+396 val_396
+397 val_397
+397 val_397
+401 val_401
+401 val_401
+401 val_401
+401 val_401
+401 val_401
+409 val_409
+409 val_409
+409 val_409
+411 val_411
+419 val_419
+427 val_427
+43 val_43
+432 val_432
+436 val_436
+439 val_439
+439 val_439
+443 val_443
+453 val_453
+460 val_460
+462 val_462
+462 val_462
+47 val_47
+472 val_472
+485 val_485
+496 val_496
+54 val_54
+64 val_64
+70 val_70
+70 val_70
+70 val_70
+8 val_8
+83 val_83
+83 val_83
+84 val_84
+84 val_84
+85 val_85
+90 val_90
+90 val_90
+90 val_90
+0 val_0
+0 val_0
+0 val_0
+103 val_103
+103 val_103
+114 val_114
+125 val_125
+125 val_125
+138 val_138
+138 val_138
+138 val_138
+138 val_138
+146 val_146
+146 val_146
+150 val_150
+152 val_152
+152 val_152
+153 val_153
+156 val_156
+157 val_157
+165 val_165
+165 val_165
+172 val_172
+172 val_172
+177 val_177
+179 val_179
+179 val_179
+187 val_187
+187 val_187
+187 val_187
+195 val_195
+195 val_195
+196 val_196
+217 val_217
+217 val_217
+242 val_242
+242 val_242
+248 val_248
+252 val_252
+265 val_265
+265 val_265
+27 val_27
+272 val_272
+272 val_272
+280 val_280
+280 val_280
+291 val_291
+305 val_305
+309 val_309
+309 val_309
+311 val_311
+311 val_311
+311 val_311
315 val_315
317 val_317
317 val_317
-321 val_321
-321 val_321
-33 val_33
-331 val_331
-331 val_331
+322 val_322
+322 val_322
+333 val_333
+333 val_333
+34 val_34
+345 val_345
+35 val_35
+35 val_35
+35 val_35
356 val_356
-360 val_360
-366 val_366
-367 val_367
-367 val_367
+364 val_364
368 val_368
+369 val_369
+369 val_369
+369 val_369
37 val_37
37 val_37
-378 val_378
-379 val_379
-382 val_382
-382 val_382
-389 val_389
-395 val_395
-395 val_395
-400 val_400
+373 val_373
+377 val_377
+4 val_4
402 val_402
-406 val_406
-406 val_406
-406 val_406
-406 val_406
-407 val_407
+404 val_404
+404 val_404
+413 val_413
+413 val_413
42 val_42
42 val_42
430 val_430
430 val_430
430 val_430
-436 val_436
-44 val_44
+431 val_431
+431 val_431
+431 val_431
+444 val_444
+449 val_449
452 val_452
+454 val_454
+454 val_454
+454 val_454
+457 val_457
+463 val_463
+463 val_463
466 val_466
466 val_466
466 val_466
-467 val_467
-472 val_472
-480 val_480
-480 val_480
-480 val_480
-484 val_484
-485 val_485
-487 val_487
-495 val_495
-496 val_496
-498 val_498
-498 val_498
-498 val_498
-51 val_51
-51 val_51
+470 val_470
+475 val_475
+481 val_481
+489 val_489
+489 val_489
+489 val_489
+489 val_489
+491 val_491
57 val_57
-58 val_58
-58 val_58
65 val_65
66 val_66
-69 val_69
-70 val_70
-70 val_70
-70 val_70
+74 val_74
+76 val_76
+76 val_76
78 val_78
-8 val_8
+9 val_9
92 val_92
-96 val_96
-104 val_104
-104 val_104
-111 val_111
-114 val_114
-118 val_118
-118 val_118
-12 val_12
-12 val_12
-133 val_133
-138 val_138
-138 val_138
-138 val_138
-138 val_138
-153 val_153
-156 val_156
-162 val_162
-168 val_168
+95 val_95
+95 val_95
+100 val_100
+100 val_100
+119 val_119
+119 val_119
+119 val_119
+128 val_128
+128 val_128
+128 val_128
+129 val_129
+129 val_129
+145 val_145
+167 val_167
+167 val_167
+167 val_167
174 val_174
174 val_174
-176 val_176
-176 val_176
178 val_178
181 val_181
-186 val_186
-187 val_187
-187 val_187
-187 val_187
-192 val_192
-197 val_197
-197 val_197
+193 val_193
+193 val_193
+193 val_193
199 val_199
199 val_199
199 val_199
-2 val_2
+20 val_20
201 val_201
-203 val_203
-203 val_203
-208 val_208
-208 val_208
-208 val_208
+213 val_213
+213 val_213
214 val_214
-218 val_218
219 val_219
219 val_219
-230 val_230
-230 val_230
-230 val_230
-230 val_230
-230 val_230
-237 val_237
-237 val_237
+221 val_221
+221 val_221
+223 val_223
+223 val_223
+226 val_226
+233 val_233
+233 val_233
+241 val_241
249 val_249
-256 val_256
-256 val_256
-257 val_257
+260 val_260
+262 val_262
277 val_277
277 val_277
277 val_277
277 val_277
-278 val_278
-278 val_278
-284 val_284
-285 val_285
+281 val_281
+281 val_281
+287 val_287
+288 val_288
+288 val_288
+298 val_298
+298 val_298
+298 val_298
+302 val_302
310 val_310
-322 val_322
-322 val_322
-327 val_327
-327 val_327
-327 val_327
-333 val_333
-333 val_333
+323 val_323
336 val_336
-338 val_338
341 val_341
344 val_344
344 val_344
-348 val_348
-348 val_348
-348 val_348
-348 val_348
-348 val_348
351 val_351
-362 val_362
-364 val_364
-374 val_374
-392 val_392
-397 val_397
-397 val_397
-4 val_4
+375 val_375
+382 val_382
+382 val_382
+384 val_384
+384 val_384
+384 val_384
+393 val_393
+395 val_395
+395 val_395
+399 val_399
+399 val_399
403 val_403
403 val_403
403 val_403
-404 val_404
-404 val_404
-419 val_419
-421 val_421
-427 val_427
-429 val_429
-429 val_429
-437 val_437
-438 val_438
-438 val_438
-438 val_438
-439 val_439
-439 val_439
-454 val_454
-454 val_454
-454 val_454
+406 val_406
+406 val_406
+406 val_406
+406 val_406
+418 val_418
+435 val_435
455 val_455
-460 val_460
-463 val_463
-463 val_463
-470 val_470
+459 val_459
+459 val_459
+477 val_477
478 val_478
478 val_478
479 val_479
-489 val_489
-489 val_489
-489 val_489
-489 val_489
-491 val_491
-492 val_492
-492 val_492
-53 val_53
+482 val_482
+493 val_493
+494 val_494
+495 val_495
+497 val_497
+5 val_5
+5 val_5
+5 val_5
+58 val_58
+58 val_58
67 val_67
67 val_67
-82 val_82
-90 val_90
-90 val_90
-90 val_90
+77 val_77
+80 val_80
+86 val_86
97 val_97
97 val_97
+98 val_98
+98 val_98
10 val_10
-125 val_125
-125 val_125
+11 val_11
+111 val_111
+116 val_116
+126 val_126
+131 val_131
134 val_134
134 val_134
+137 val_137
+137 val_137
143 val_143
-145 val_145
149 val_149
149 val_149
-150 val_150
-158 val_158
+15 val_15
+15 val_15
163 val_163
164 val_164
164 val_164
166 val_166
-17 val_17
-170 val_170
-172 val_172
-172 val_172
+169 val_169
+169 val_169
+169 val_169
+169 val_169
+176 val_176
+176 val_176
+183 val_183
189 val_189
-19 val_19
-195 val_195
-195 val_195
-196 val_196
-20 val_20
+190 val_190
+191 val_191
+191 val_191
+192 val_192
+194 val_194
+2 val_2
+202 val_202
+203 val_203
+203 val_203
+205 val_205
+205 val_205
+207 val_207
+207 val_207
+208 val_208
+208 val_208
+208 val_208
209 val_209
209 val_209
-216 val_216
-216 val_216
-217 val_217
-217 val_217
-224 val_224
-224 val_224
-228 val_228
229 val_229
229 val_229
-233 val_233
-233 val_233
-241 val_241
-244 val_244
-247 val_247
+230 val_230
+230 val_230
+230 val_230
+230 val_230
+230 val_230
+238 val_238
+238 val_238
+24 val_24
+24 val_24
255 val_255
255 val_255
+257 val_257
258 val_258
26 val_26
26 val_26
-263 val_263
-265 val_265
-265 val_265
266 val_266
-272 val_272
-272 val_272
-273 val_273
-273 val_273
-273 val_273
274 val_274
-281 val_281
-281 val_281
-291 val_291
+275 val_275
+278 val_278
+278 val_278
+282 val_282
+282 val_282
+284 val_284
+285 val_285
+289 val_289
296 val_296
30 val_30
-302 val_302
-309 val_309
-309 val_309
+307 val_307
+307 val_307
316 val_316
316 val_316
316 val_316
318 val_318
318 val_318
318 val_318
+321 val_321
+321 val_321
325 val_325
325 val_325
+331 val_331
+331 val_331
332 val_332
335 val_335
+338 val_338
339 val_339
342 val_342
342 val_342
-345 val_345
-353 val_353
-353 val_353
-369 val_369
-369 val_369
-369 val_369
-373 val_373
-375 val_375
-377 val_377
-384 val_384
-384 val_384
-384 val_384
+360 val_360
+365 val_365
+367 val_367
+367 val_367
+374 val_374
+378 val_378
+379 val_379
386 val_386
+389 val_389
+392 val_392
394 val_394
-396 val_396
-396 val_396
-396 val_396
-399 val_399
-399 val_399
-401 val_401
-401 val_401
-401 val_401
-401 val_401
-401 val_401
+400 val_400
+407 val_407
41 val_41
-413 val_413
-413 val_413
414 val_414
414 val_414
-431 val_431
-431 val_431
-431 val_431
-446 val_446
-448 val_448
-449 val_449
-459 val_459
-459 val_459
-462 val_462
-462 val_462
-468 val_468
-468 val_468
-468 val_468
-468 val_468
-47 val_47
-482 val_482
-490 val_490
-493 val_493
-494 val_494
-497 val_497
-5 val_5
-5 val_5
-5 val_5
-54 val_54
-74 val_74
-77 val_77
-80 val_80
-84 val_84
-84 val_84
-85 val_85
-87 val_87
-9 val_9
-95 val_95
-95 val_95
-100 val_100
-100 val_100
-11 val_11
-113 val_113
-113 val_113
-119 val_119
-119 val_119
-119 val_119
-126 val_126
-128 val_128
-128 val_128
-128 val_128
-137 val_137
-137 val_137
-146 val_146
-146 val_146
-15 val_15
-15 val_15
-152 val_152
-152 val_152
-165 val_165
-165 val_165
-167 val_167
-167 val_167
-167 val_167
-169 val_169
-169 val_169
-169 val_169
-169 val_169
-175 val_175
-175 val_175
-177 val_177
-179 val_179
-179 val_179
-18 val_18
-18 val_18
-194 val_194
-200 val_200
-200 val_200
-202 val_202
-221 val_221
-221 val_221
-222 val_222
-226 val_226
-242 val_242
-242 val_242
-252 val_252
-262 val_262
-27 val_27
-275 val_275
-280 val_280
-280 val_280
-282 val_282
-282 val_282
-283 val_283
-287 val_287
-288 val_288
-288 val_288
-289 val_289
-292 val_292
-311 val_311
-311 val_311
-311 val_311
-323 val_323
-34 val_34
-35 val_35
-35 val_35
-35 val_35
-365 val_365
-393 val_393
-409 val_409
-409 val_409
-409 val_409
-411 val_411
417 val_417
417 val_417
417 val_417
-418 val_418
+421 val_421
424 val_424
424 val_424
-43 val_43
-432 val_432
-435 val_435
-443 val_443
-444 val_444
-453 val_453
-457 val_457
+429 val_429
+429 val_429
+437 val_437
+438 val_438
+438 val_438
+438 val_438
+44 val_44
+446 val_446
+448 val_448
458 val_458
458 val_458
+467 val_467
+468 val_468
+468 val_468
+468 val_468
+468 val_468
469 val_469
469 val_469
469 val_469
469 val_469
469 val_469
-475 val_475
-477 val_477
-481 val_481
+480 val_480
+480 val_480
+480 val_480
483 val_483
-64 val_64
+484 val_484
+487 val_487
+490 val_490
+492 val_492
+492 val_492
+498 val_498
+498 val_498
+498 val_498
+51 val_51
+51 val_51
+53 val_53
+69 val_69
72 val_72
72 val_72
-76 val_76
-76 val_76
-83 val_83
-83 val_83
-86 val_86
-98 val_98
-98 val_98
+82 val_82
+87 val_87
+96 val_96
PREHOOK: query: explain select value from a group by value intersect all select key from b group by key
PREHOOK: type: QUERY
POSTHOOK: query: explain select value from a group by value intersect all select key from b group by key
http://git-wip-us.apache.org/repos/asf/hive/blob/091fd962/ql/src/test/results/clientpositive/llap/intersect_distinct.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/intersect_distinct.q.out b/ql/src/test/results/clientpositive/llap/intersect_distinct.q.out
index 444c222..8d94099 100644
--- a/ql/src/test/results/clientpositive/llap/intersect_distinct.q.out
+++ b/ql/src/test/results/clientpositive/llap/intersect_distinct.q.out
@@ -281,315 +281,315 @@ POSTHOOK: query: select * from src intersect distinct select * from src
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
POSTHOOK: Output: hdfs://### HDFS PATH ###
-0 val_0
-103 val_103
+104 val_104
105 val_105
-116 val_116
+113 val_113
+118 val_118
+12 val_12
120 val_120
-129 val_129
-131 val_131
+133 val_133
136 val_136
155 val_155
-157 val_157
+158 val_158
160 val_160
+162 val_162
+168 val_168
+17 val_17
+170 val_170
+175 val_175
+18 val_18
180 val_180
-183 val_183
-190 val_190
-191 val_191
-193 val_193
-205 val_205
-207 val_207
-213 val_213
-223 val_223
+186 val_186
+19 val_19
+197 val_197
+200 val_200
+216 val_216
+218 val_218
+222 val_222
+224 val_224
+228 val_228
235 val_235
-238 val_238
+237 val_237
239 val_239
-24 val_24
-248 val_248
-260 val_260
+244 val_244
+247 val_247
+256 val_256
+263 val_263
+273 val_273
28 val_28
+283 val_283
286 val_286
-298 val_298
-305 val_305
+292 val_292
306 val_306
-307 val_307
308 val_308
+327 val_327
+33 val_33
+348 val_348
+353 val_353
+362 val_362
+366 val_366
+396 val_396
+397 val_397
+401 val_401
+409 val_409
+411 val_411
+419 val_419
+427 val_427
+43 val_43
+432 val_432
+436 val_436
+439 val_439
+443 val_443
+453 val_453
+460 val_460
+462 val_462
+47 val_47
+472 val_472
+485 val_485
+496 val_496
+54 val_54
+64 val_64
+70 val_70
+8 val_8
+83 val_83
+84 val_84
+85 val_85
+90 val_90
+0 val_0
+103 val_103
+114 val_114
+125 val_125
+138 val_138
+146 val_146
+150 val_150
+152 val_152
+153 val_153
+156 val_156
+157 val_157
+165 val_165
+172 val_172
+177 val_177
+179 val_179
+187 val_187
+195 val_195
+196 val_196
+217 val_217
+242 val_242
+248 val_248
+252 val_252
+265 val_265
+27 val_27
+272 val_272
+280 val_280
+291 val_291
+305 val_305
+309 val_309
+311 val_311
315 val_315
317 val_317
-321 val_321
-33 val_33
-331 val_331
+322 val_322
+333 val_333
+34 val_34
+345 val_345
+35 val_35
356 val_356
-360 val_360
-366 val_366
-367 val_367
+364 val_364
368 val_368
+369 val_369
37 val_37
-378 val_378
-379 val_379
-382 val_382
-389 val_389
-395 val_395
-400 val_400
+373 val_373
+377 val_377
+4 val_4
402 val_402
-406 val_406
-407 val_407
+404 val_404
+413 val_413
42 val_42
430 val_430
-436 val_436
-44 val_44
+431 val_431
+444 val_444
+449 val_449
452 val_452
+454 val_454
+457 val_457
+463 val_463
466 val_466
-467 val_467
-472 val_472
-480 val_480
-484 val_484
-485 val_485
-487 val_487
-495 val_495
-496 val_496
-498 val_498
-51 val_51
+470 val_470
+475 val_475
+481 val_481
+489 val_489
+491 val_491
57 val_57
-58 val_58
65 val_65
66 val_66
-69 val_69
-70 val_70
+74 val_74
+76 val_76
78 val_78
-8 val_8
+9 val_9
92 val_92
-96 val_96
-104 val_104
-111 val_111
-114 val_114
-118 val_118
-12 val_12
-133 val_133
-138 val_138
-153 val_153
-156 val_156
-162 val_162
-168 val_168
+95 val_95
+100 val_100
+119 val_119
+128 val_128
+129 val_129
+145 val_145
+167 val_167
174 val_174
-176 val_176
178 val_178
181 val_181
-186 val_186
-187 val_187
-192 val_192
-197 val_197
+193 val_193
199 val_199
-2 val_2
+20 val_20
201 val_201
-203 val_203
-208 val_208
+213 val_213
214 val_214
-218 val_218
219 val_219
-230 val_230
-237 val_237
+221 val_221
+223 val_223
+226 val_226
+233 val_233
+241 val_241
249 val_249
-256 val_256
-257 val_257
+260 val_260
+262 val_262
277 val_277
-278 val_278
-284 val_284
-285 val_285
+281 val_281
+287 val_287
+288 val_288
+298 val_298
+302 val_302
310 val_310
-322 val_322
-327 val_327
-333 val_333
+323 val_323
336 val_336
-338 val_338
341 val_341
344 val_344
-348 val_348
351 val_351
-362 val_362
-364 val_364
-374 val_374
-392 val_392
-397 val_397
-4 val_4
+375 val_375
+382 val_382
+384 val_384
+393 val_393
+395 val_395
+399 val_399
403 val_403
-404 val_404
-419 val_419
-421 val_421
-427 val_427
-429 val_429
-437 val_437
-438 val_438
-439 val_439
-454 val_454
+406 val_406
+418 val_418
+435 val_435
455 val_455
-460 val_460
-463 val_463
-470 val_470
+459 val_459
+477 val_477
478 val_478
479 val_479
-489 val_489
-491 val_491
-492 val_492
-53 val_53
+482 val_482
+493 val_493
+494 val_494
+495 val_495
+497 val_497
+5 val_5
+58 val_58
67 val_67
-82 val_82
-90 val_90
+77 val_77
+80 val_80
+86 val_86
97 val_97
+98 val_98
10 val_10
-125 val_125
+11 val_11
+111 val_111
+116 val_116
+126 val_126
+131 val_131
134 val_134
+137 val_137
143 val_143
-145 val_145
149 val_149
-150 val_150
-158 val_158
+15 val_15
163 val_163
164 val_164
166 val_166
-17 val_17
-170 val_170
-172 val_172
+169 val_169
+176 val_176
+183 val_183
189 val_189
-19 val_19
-195 val_195
-196 val_196
-20 val_20
+190 val_190
+191 val_191
+192 val_192
+194 val_194
+2 val_2
+202 val_202
+203 val_203
+205 val_205
+207 val_207
+208 val_208
209 val_209
-216 val_216
-217 val_217
-224 val_224
-228 val_228
229 val_229
-233 val_233
-241 val_241
-244 val_244
-247 val_247
+230 val_230
+238 val_238
+24 val_24
255 val_255
+257 val_257
258 val_258
26 val_26
-263 val_263
-265 val_265
266 val_266
-272 val_272
-273 val_273
274 val_274
-281 val_281
-291 val_291
+275 val_275
+278 val_278
+282 val_282
+284 val_284
+285 val_285
+289 val_289
296 val_296
30 val_30
-302 val_302
-309 val_309
+307 val_307
316 val_316
318 val_318
+321 val_321
325 val_325
+331 val_331
332 val_332
335 val_335
-339 val_339
-342 val_342
-345 val_345
-353 val_353
-369 val_369
-373 val_373
-375 val_375
-377 val_377
-384 val_384
-386 val_386
-394 val_394
-396 val_396
-399 val_399
-401 val_401
-41 val_41
-413 val_413
-414 val_414
-431 val_431
-446 val_446
-448 val_448
-449 val_449
-459 val_459
-462 val_462
-468 val_468
-47 val_47
-482 val_482
-490 val_490
-493 val_493
-494 val_494
-497 val_497
-5 val_5
-54 val_54
-74 val_74
-77 val_77
-80 val_80
-84 val_84
-85 val_85
-87 val_87
-9 val_9
-95 val_95
-100 val_100
-11 val_11
-113 val_113
-119 val_119
-126 val_126
-128 val_128
-137 val_137
-146 val_146
-15 val_15
-152 val_152
-165 val_165
-167 val_167
-169 val_169
-175 val_175
-177 val_177
-179 val_179
-18 val_18
-194 val_194
-200 val_200
-202 val_202
-221 val_221
-222 val_222
-226 val_226
-242 val_242
-252 val_252
-262 val_262
-27 val_27
-275 val_275
-280 val_280
-282 val_282
-283 val_283
-287 val_287
-288 val_288
-289 val_289
-292 val_292
-311 val_311
-323 val_323
-34 val_34
-35 val_35
+338 val_338
+339 val_339
+342 val_342
+360 val_360
365 val_365
-393 val_393
-409 val_409
-411 val_411
+367 val_367
+374 val_374
+378 val_378
+379 val_379
+386 val_386
+389 val_389
+392 val_392
+394 val_394
+400 val_400
+407 val_407
+41 val_41
+414 val_414
417 val_417
-418 val_418
+421 val_421
424 val_424
-43 val_43
-432 val_432
-435 val_435
-443 val_443
-444 val_444
-453 val_453
-457 val_457
+429 val_429
+437 val_437
+438 val_438
+44 val_44
+446 val_446
+448 val_448
458 val_458
+467 val_467
+468 val_468
469 val_469
-475 val_475
-477 val_477
-481 val_481
+480 val_480
483 val_483
-64 val_64
+484 val_484
+487 val_487
+490 val_490
+492 val_492
+498 val_498
+51 val_51
+53 val_53
+69 val_69
72 val_72
-76 val_76
-83 val_83
-86 val_86
-98 val_98
+82 val_82
+87 val_87
+96 val_96
PREHOOK: query: explain select * from src intersect distinct select * from src intersect distinct select * from src intersect distinct select * from src
PREHOOK: type: QUERY
POSTHOOK: query: explain select * from src intersect distinct select * from src intersect distinct select * from src intersect distinct select * from src
@@ -826,315 +826,315 @@ POSTHOOK: query: select * from src intersect distinct select * from src intersec
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
POSTHOOK: Output: hdfs://### HDFS PATH ###
-0 val_0
-103 val_103
+104 val_104
105 val_105
-116 val_116
+113 val_113
+118 val_118
+12 val_12
120 val_120
-129 val_129
-131 val_131
+133 val_133
136 val_136
155 val_155
-157 val_157
+158 val_158
160 val_160
+162 val_162
+168 val_168
+17 val_17
+170 val_170
+175 val_175
+18 val_18
180 val_180
-183 val_183
-190 val_190
-191 val_191
-193 val_193
-205 val_205
-207 val_207
-213 val_213
-223 val_223
+186 val_186
+19 val_19
+197 val_197
+200 val_200
+216 val_216
+218 val_218
+222 val_222
+224 val_224
+228 val_228
235 val_235
-238 val_238
+237 val_237
239 val_239
-24 val_24
-248 val_248
-260 val_260
+244 val_244
+247 val_247
+256 val_256
+263 val_263
+273 val_273
28 val_28
+283 val_283
286 val_286
-298 val_298
-305 val_305
+292 val_292
306 val_306
-307 val_307
308 val_308
+327 val_327
+33 val_33
+348 val_348
+353 val_353
+362 val_362
+366 val_366
+396 val_396
+397 val_397
+401 val_401
+409 val_409
+411 val_411
+419 val_419
+427 val_427
+43 val_43
+432 val_432
+436 val_436
+439 val_439
+443 val_443
+453 val_453
+460 val_460
+462 val_462
+47 val_47
+472 val_472
+485 val_485
+496 val_496
+54 val_54
+64 val_64
+70 val_70
+8 val_8
+83 val_83
+84 val_84
+85 val_85
+90 val_90
+0 val_0
+103 val_103
+114 val_114
+125 val_125
+138 val_138
+146 val_146
+150 val_150
+152 val_152
+153 val_153
+156 val_156
+157 val_157
+165 val_165
+172 val_172
+177 val_177
+179 val_179
+187 val_187
+195 val_195
+196 val_196
+217 val_217
+242 val_242
+248 val_248
+252 val_252
+265 val_265
+27 val_27
+272 val_272
+280 val_280
+291 val_291
+305 val_305
+309 val_309
+311 val_311
315 val_315
317 val_317
-321 val_321
-33 val_33
-331 val_331
+322 val_322
+333 val_333
+34 val_34
+345 val_345
+35 val_35
356 val_356
-360 val_360
-366 val_366
-367 val_367
+364 val_364
368 val_368
+369 val_369
37 val_37
-378 val_378
-379 val_379
-382 val_382
-389 val_389
-395 val_395
-400 val_400
+373 val_373
+377 val_377
+4 val_4
402 val_402
-406 val_406
-407 val_407
+404 val_404
+413 val_413
42 val_42
430 val_430
-436 val_436
-44 val_44
+431 val_431
+444 val_444
+449 val_449
452 val_452
+454 val_454
+457 val_457
+463 val_463
466 val_466
-467 val_467
-472 val_472
-480 val_480
-484 val_484
-485 val_485
-487 val_487
-495 val_495
-496 val_496
-498 val_498
-51 val_51
+470 val_470
+475 val_475
+481 val_481
+489 val_489
+491 val_491
57 val_57
-58 val_58
65 val_65
66 val_66
-69 val_69
-70 val_70
+74 val_74
+76 val_76
78 val_78
-8 val_8
+9 val_9
92 val_92
-96 val_96
-104 val_104
-111 val_111
-114 val_114
-118 val_118
-12 val_12
-133 val_133
-138 val_138
-153 val_153
-156 val_156
-162 val_162
-168 val_168
+95 val_95
+100 val_100
+119 val_119
+128 val_128
+129 val_129
+145 val_145
+167 val_167
174 val_174
-176 val_176
178 val_178
181 val_181
-186 val_186
-187 val_187
-192 val_192
-197 val_197
+193 val_193
199 val_199
-2 val_2
+20 val_20
201 val_201
-203 val_203
-208 val_208
+213 val_213
214 val_214
-218 val_218
219 val_219
-230 val_230
-237 val_237
+221 val_221
+223 val_223
+226 val_226
+233 val_233
+241 val_241
249 val_249
-256 val_256
-257 val_257
+260 val_260
+262 val_262
277 val_277
-278 val_278
-284 val_284
-285 val_285
+281 val_281
+287 val_287
+288 val_288
+298 val_298
+302 val_302
310 val_310
-322 val_322
-327 val_327
-333 val_333
+323 val_323
336 val_336
-338 val_338
341 val_341
344 val_344
-348 val_348
351 val_351
-362 val_362
-364 val_364
-374 val_374
-392 val_392
-397 val_397
-4 val_4
+375 val_375
+382 val_382
+384 val_384
+393 val_393
+395 val_395
+399 val_399
403 val_403
-404 val_404
-419 val_419
-421 val_421
-427 val_427
-429 val_429
-437 val_437
-438 val_438
-439 val_439
-454 val_454
+406 val_406
+418 val_418
+435 val_435
455 val_455
-460 val_460
-463 val_463
-470 val_470
+459 val_459
+477 val_477
478 val_478
479 val_479
-489 val_489
-491 val_491
-492 val_492
-53 val_53
+482 val_482
+493 val_493
+494 val_494
+495 val_495
+497 val_497
+5 val_5
+58 val_58
67 val_67
-82 val_82
-90 val_90
+77 val_77
+80 val_80
+86 val_86
97 val_97
+98 val_98
10 val_10
-125 val_125
+11 val_11
+111 val_111
+116 val_116
+126 val_126
+131 val_131
134 val_134
+137 val_137
143 val_143
-145 val_145
149 val_149
-150 val_150
-158 val_158
+15 val_15
163 val_163
164 val_164
166 val_166
-17 val_17
-170 val_170
-172 val_172
+169 val_169
+176 val_176
+183 val_183
189 val_189
-19 val_19
-195 val_195
-196 val_196
-20 val_20
+190 val_190
+191 val_191
+192 val_192
+194 val_194
+2 val_2
+202 val_202
+203 val_203
+205 val_205
+207 val_207
+208 val_208
209 val_209
-216 val_216
-217 val_217
-224 val_224
-228 val_228
229 val_229
-233 val_233
-241 val_241
-244 val_244
-247 val_247
+230 val_230
+238 val_238
+24 val_24
255 val_255
+257 val_257
258 val_258
26 val_26
-263 val_263
-265 val_265
266 val_266
-272 val_272
-273 val_273
274 val_274
-281 val_281
-291 val_291
+275 val_275
+278 val_278
+282 val_282
+284 val_284
+285 val_285
+289 val_289
296 val_296
30 val_30
-302 val_302
-309 val_309
+307 val_307
316 val_316
318 val_318
+321 val_321
325 val_325
+331 val_331
332 val_332
335 val_335
+338 val_338
339 val_339
342 val_342
-345 val_345
-353 val_353
-369 val_369
-373 val_373
-375 val_375
-377 val_377
-384 val_384
+360 val_360
+365 val_365
+367 val_367
+374 val_374
+378 val_378
+379 val_379
386 val_386
+389 val_389
+392 val_392
394 val_394
-396 val_396
-399 val_399
-401 val_401
+400 val_400
+407 val_407
41 val_41
-413 val_413
414 val_414
-431 val_431
-446 val_446
-448 val_448
-449 val_449
-459 val_459
-462 val_462
-468 val_468
-47 val_47
-482 val_482
-490 val_490
-493 val_493
-494 val_494
-497 val_497
-5 val_5
-54 val_54
-74 val_74
-77 val_77
-80 val_80
-84 val_84
-85 val_85
-87 val_87
-9 val_9
-95 val_95
-100 val_100
-11 val_11
-113 val_113
-119 val_119
-126 val_126
-128 val_128
-137 val_137
-146 val_146
-15 val_15
-152 val_152
-165 val_165
-167 val_167
-169 val_169
-175 val_175
-177 val_177
-179 val_179
-18 val_18
-194 val_194
-200 val_200
-202 val_202
-221 val_221
-222 val_222
-226 val_226
-242 val_242
-252 val_252
-262 val_262
-27 val_27
-275 val_275
-280 val_280
-282 val_282
-283 val_283
-287 val_287
-288 val_288
-289 val_289
-292 val_292
-311 val_311
-323 val_323
-34 val_34
-35 val_35
-365 val_365
-393 val_393
-409 val_409
-411 val_411
417 val_417
-418 val_418
+421 val_421
424 val_424
-43 val_43
-432 val_432
-435 val_435
-443 val_443
-444 val_444
-453 val_453
-457 val_457
+429 val_429
+437 val_437
+438 val_438
+44 val_44
+446 val_446
+448 val_448
458 val_458
+467 val_467
+468 val_468
469 val_469
-475 val_475
-477 val_477
-481 val_481
+480 val_480
483 val_483
-64 val_64
+484 val_484
+487 val_487
+490 val_490
+492 val_492
+498 val_498
+51 val_51
+53 val_53
+69 val_69
72 val_72
-76 val_76
-83 val_83
-86 val_86
-98 val_98
+82 val_82
+87 val_87
+96 val_96
PREHOOK: query: explain select value from a group by value intersect distinct select key from b group by key
PREHOOK: type: QUERY
POSTHOOK: query: explain select value from a group by value intersect distinct select key from b group by key
http://git-wip-us.apache.org/repos/asf/hive/blob/091fd962/ql/src/test/results/clientpositive/llap/join32_lessSize.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/join32_lessSize.q.out b/ql/src/test/results/clientpositive/llap/join32_lessSize.q.out
index f8622da..927fa87 100644
--- a/ql/src/test/results/clientpositive/llap/join32_lessSize.q.out
+++ b/ql/src/test/results/clientpositive/llap/join32_lessSize.q.out
@@ -90,6 +90,7 @@ STAGE PLANS:
properties:
COLUMN_STATS_ACCURATE {"BASIC_STATS":"true","COLUMN_STATS":{"key":"true","value":"true"}}
bucket_count -1
+ bucketing_version 2
column.name.delimiter ,
columns key,value
columns.comments 'default','default'
@@ -111,6 +112,7 @@ STAGE PLANS:
properties:
COLUMN_STATS_ACCURATE {"BASIC_STATS":"true","COLUMN_STATS":{"key":"true","value":"true"}}
bucket_count -1
+ bucketing_version 2
column.name.delimiter ,
columns key,value
columns.comments 'default','default'
@@ -166,6 +168,7 @@ STAGE PLANS:
properties:
COLUMN_STATS_ACCURATE {"BASIC_STATS":"true","COLUMN_STATS":{"key":"true","value":"true"}}
bucket_count -1
+ bucketing_version 2
column.name.delimiter ,
columns key,value
columns.comments 'default','default'
@@ -187,6 +190,7 @@ STAGE PLANS:
properties:
COLUMN_STATS_ACCURATE {"BASIC_STATS":"true","COLUMN_STATS":{"key":"true","value":"true"}}
bucket_count -1
+ bucketing_version 2
column.name.delimiter ,
columns key,value
columns.comments 'default','default'
@@ -266,6 +270,7 @@ STAGE PLANS:
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
properties:
bucket_count -1
+ bucketing_version 2
column.name.delimiter ,
columns key,value
columns.comments 'default','default'
@@ -313,6 +318,7 @@ STAGE PLANS:
properties:
COLUMN_STATS_ACCURATE {"BASIC_STATS":"true","COLUMN_STATS":{"key":"true","val2":"true","value":"true"}}
bucket_count -1
+ bucketing_version 2
column.name.delimiter ,
columns key,value,val2
columns.comments
@@ -394,6 +400,7 @@ STAGE PLANS:
properties:
COLUMN_STATS_ACCURATE {"BASIC_STATS":"true","COLUMN_STATS":{"key":"true","val2":"true","value":"true"}}
bucket_count -1
+ bucketing_version 2
column.name.delimiter ,
columns key,value,val2
columns.comments
@@ -616,6 +623,7 @@ STAGE PLANS:
properties:
COLUMN_STATS_ACCURATE {"BASIC_STATS":"true","COLUMN_STATS":{"key":"true","value":"true"}}
bucket_count -1
+ bucketing_version 2
column.name.delimiter ,
columns key,value
columns.comments 'default','default'
@@ -637,6 +645,7 @@ STAGE PLANS:
properties:
COLUMN_STATS_ACCURATE {"BASIC_STATS":"true","COLUMN_STATS":{"key":"true","value":"true"}}
bucket_count -1
+ bucketing_version 2
column.name.delimiter ,
columns key,value
columns.comments 'default','default'
@@ -692,6 +701,7 @@ STAGE PLANS:
properties:
COLUMN_STATS_ACCURATE {"BASIC_STATS":"true","COLUMN_STATS":{"key":"true","value":"true"}}
bucket_count -1
+ bucketing_version 2
column.name.delimiter ,
columns key,value
columns.comments 'default','default'
@@ -713,6 +723,7 @@ STAGE PLANS:
properties:
COLUMN_STATS_ACCURATE {"BASIC_STATS":"true","COLUMN_STATS":{"key":"true","value":"true"}}
bucket_count -1
+ bucketing_version 2
column.name.delimiter ,
columns key,value
columns.comments 'default','default'
@@ -767,6 +778,7 @@ STAGE PLANS:
properties:
COLUMN_STATS_ACCURATE {"BASIC_STATS":"true","COLUMN_STATS":{"key":"true","value":"true"}}
bucket_count -1
+ bucketing_version 2
column.name.delimiter ,
columns key,value
columns.comments 'default','default'
@@ -788,6 +800,7 @@ STAGE PLANS:
properties:
COLUMN_STATS_ACCURATE {"BASIC_STATS":"true","COLUMN_STATS":{"key":"true","value":"true"}}
bucket_count -1
+ bucketing_version 2
column.name.delimiter ,
columns key,value
columns.comments 'default','default'
@@ -843,6 +856,7 @@ STAGE PLANS:
properties:
COLUMN_STATS_ACCURATE {"BASIC_STATS":"true","COLUMN_STATS":{"key":"true","value":"true"}}
bucket_count -1
+ bucketing_version 2
column.name.delimiter ,
columns key,value
columns.comments 'default','default'
@@ -864,6 +878,7 @@ STAGE PLANS:
properties:
COLUMN_STATS_ACCURATE {"BASIC_STATS":"true","COLUMN_STATS":{"key":"true","value":"true"}}
bucket_count -1
+ bucketing_version 2
column.name.delimiter ,
columns key,value
columns.comments 'default','default'
@@ -935,6 +950,7 @@ STAGE PLANS:
properties:
COLUMN_STATS_ACCURATE {"BASIC_STATS":"true","COLUMN_STATS":{"key":"true","val2":"true","value":"true"}}
bucket_count -1
+ bucketing_version 2
column.name.delimiter ,
columns key,value,val2
columns.comments
@@ -1016,6 +1032,7 @@ STAGE PLANS:
properties:
COLUMN_STATS_ACCURATE {"BASIC_STATS":"true","COLUMN_STATS":{"key":"true","val2":"true","value":"true"}}
bucket_count -1
+ bucketing_version 2
column.name.delimiter ,
columns key,value,val2
columns.comments
@@ -1245,6 +1262,7 @@ STAGE PLANS:
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
properties:
bucket_count -1
+ bucketing_version 2
column.name.delimiter ,
columns key,value
columns.comments 'default','default'
@@ -1314,6 +1332,7 @@ STAGE PLANS:
properties:
COLUMN_STATS_ACCURATE {"BASIC_STATS":"true","COLUMN_STATS":{"key":"true","value":"true"}}
bucket_count -1
+ bucketing_version 2
column.name.delimiter ,
columns key,value
columns.comments 'default','default'
@@ -1335,6 +1354,7 @@ STAGE PLANS:
properties:
COLUMN_STATS_ACCURATE {"BASIC_STATS":"true","COLUMN_STATS":{"key":"true","value":"true"}}
bucket_count -1
+ bucketing_version 2
column.name.delimiter ,
columns key,value
columns.comments 'default','default'
@@ -1390,6 +1410,7 @@ STAGE PLANS:
properties:
COLUMN_STATS_ACCURATE {"BASIC_STATS":"true","COLUMN_STATS":{"key":"true","value":"true"}}
bucket_count -1
+ bucketing_version 2
column.name.delimiter ,
columns key,value
columns.comments 'default','default'
@@ -1411,6 +1432,7 @@ STAGE PLANS:
properties:
COLUMN_STATS_ACCURATE {"BASIC_STATS":"true","COLUMN_STATS":{"key":"true","value":"true"}}
bucket_count -1
+ bucketing_version 2
column.name.delimiter ,
columns key,value
columns.comments 'default','default'
@@ -1460,6 +1482,7 @@ STAGE PLANS:
properties:
COLUMN_STATS_ACCURATE {"BASIC_STATS":"true","COLUMN_STATS":{"key":"true","val2":"true","value":"true"}}
bucket_count -1
+ bucketing_version 2
column.name.delimiter ,
columns key,value,val2
columns.comments
@@ -1541,6 +1564,7 @@ STAGE PLANS:
properties:
COLUMN_STATS_ACCURATE {"BASIC_STATS":"true","COLUMN_STATS":{"key":"true","val2":"true","value":"true"}}
bucket_count -1
+ bucketing_version 2
column.name.delimiter ,
columns key,value,val2
columns.comments
@@ -1772,6 +1796,7 @@ STAGE PLANS:
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
properties:
bucket_count -1
+ bucketing_version 2
column.name.delimiter ,
columns key,value
columns.comments 'default','default'
@@ -1820,6 +1845,7 @@ STAGE PLANS:
properties:
COLUMN_STATS_ACCURATE {"BASIC_STATS":"true","COLUMN_STATS":{"key":"true","value":"true"}}
bucket_count -1
+ bucketing_version 2
column.name.delimiter ,
columns key,value
columns.comments 'default','default'
@@ -1841,6 +1867,7 @@ STAGE PLANS:
properties:
COLUMN_STATS_ACCURATE {"BASIC_STATS":"true","COLUMN_STATS":{"key":"true","value":"true"}}
bucket_count -1
+ bucketing_version 2
column.name.delimiter ,
columns key,value
columns.comments 'default','default'
@@ -1896,6 +1923,7 @@ STAGE PLANS:
properties:
COLUMN_STATS_ACCURATE {"BASIC_STATS":"true","COLUMN_STATS":{"key":"true","value":"true"}}
bucket_count -1
+ bucketing_version 2
column.name.delimiter ,
columns key,value
columns.comments 'default','default'
@@ -1917,6 +1945,7 @@ STAGE PLANS:
properties:
COLUMN_STATS_ACCURATE {"BASIC_STATS":"true","COLUMN_STATS":{"key":"true","value":"true"}}
bucket_count -1
+ bucketing_version 2
column.name.delimiter ,
columns key,value
columns.comments 'default','default'
@@ -1966,6 +1995,7 @@ STAGE PLANS:
properties:
COLUMN_STATS_ACCURATE {"BASIC_STATS":"true","COLUMN_STATS":{"key":"true","val2":"true","value":"true"}}
bucket_count -1
+ bucketing_version 2
column.name.delimiter ,
columns key,value,val2
columns.comments
@@ -2073,6 +2103,7 @@ STAGE PLANS:
properties:
COLUMN_STATS_ACCURATE {"BASIC_STATS":"true","COLUMN_STATS":{"key":"true","val2":"true","value":"true"}}
bucket_count -1
+ bucketing_version 2
column.name.delimiter ,
columns key,value,val2
columns.comments
http://git-wip-us.apache.org/repos/asf/hive/blob/091fd962/ql/src/test/results/clientpositive/llap/lateral_view.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/lateral_view.q.out b/ql/src/test/results/clientpositive/llap/lateral_view.q.out
index 20e4437..ba7ee2e 100644
--- a/ql/src/test/results/clientpositive/llap/lateral_view.q.out
+++ b/ql/src/test/results/clientpositive/llap/lateral_view.q.out
@@ -716,16 +716,16 @@ LATERAL VIEW explode(value) myTable AS myCol
POSTHOOK: type: QUERY
POSTHOOK: Input: default@tmp_pyang_src_rcfile
#### A masked pattern was here ####
-["val_0"] val_0
+["val_100"] val_100
["val_10"] val_10
-["val_104"] val_104
-["val_105"] val_105
["val_111"] val_111
["val_113"] val_113
-["val_114"] val_114
-["val_116"] val_116
-["val_119"] val_119
["val_103"] val_103
-["val_100"] val_100
+["val_104"] val_104
+["val_105"] val_105
["val_11"] val_11
+["val_114"] val_114
["val_118"] val_118
+["val_0"] val_0
+["val_116"] val_116
+["val_119"] val_119
http://git-wip-us.apache.org/repos/asf/hive/blob/091fd962/ql/src/test/results/clientpositive/llap/lineage2.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/lineage2.q.out b/ql/src/test/results/clientpositive/llap/lineage2.q.out
index bac5863..da98117 100644
--- a/ql/src/test/results/clientpositive/llap/lineage2.q.out
+++ b/ql/src/test/results/clientpositive/llap/lineage2.q.out
@@ -143,18 +143,18 @@ PREHOOK: Input: default@dest1
{"version":"1.0","engine":"tez","database":"default","hash":"f74475552dc79e09d4e75116c0cc9f37","queryText":"select key, count(1) a from dest1 group by key","edges":[{"sources":[2],"targets":[0],"edgeType":"PROJECTION"},{"sources":[3],"targets":[1],"expression":"count(*)","edgeType":"PROJECTION"}],"vertices":[{"id":0,"vertexType":"COLUMN","vertexId":"key"},{"id":1,"vertexType":"COLUMN","vertexId":"a"},{"id":2,"vertexType":"COLUMN","vertexId":"default.dest1.key"},{"id":3,"vertexType":"TABLE","vertexId":"default.dest1"}]}
128 2
213 2
-278 2
-369 2
- 20
-150 2
-238 2
+401 2
66 2
146 2
224 2
-255 2
+238 2
273 2
+ 20
+150 2
+255 2
+278 2
311 2
-401 2
+369 2
406 2
98 2
PREHOOK: query: select key k, count(*) from dest1 group by key
@@ -164,18 +164,18 @@ PREHOOK: Input: default@dest1
{"version":"1.0","engine":"tez","database":"default","hash":"3a519d9badc7e8b87b42ba96a6f922ef","queryText":"select key k, count(*) from dest1 group by key","edges":[{"sources":[2],"targets":[0],"edgeType":"PROJECTION"},{"sources":[3],"targets":[1],"expression":"count(*)","edgeType":"PROJECTION"}],"vertices":[{"id":0,"vertexType":"COLUMN","vertexId":"k"},{"id":1,"vertexType":"COLUMN","vertexId":"_c1"},{"id":2,"vertexType":"COLUMN","vertexId":"default.dest1.key"},{"id":3,"vertexType":"TABLE","vertexId":"default.dest1"}]}
128 2
213 2
-278 2
-369 2
- 20
-150 2
-238 2
+401 2
66 2
146 2
224 2
-255 2
+238 2
273 2
+ 20
+150 2
+255 2
+278 2
311 2
-401 2
+369 2
406 2
98 2
PREHOOK: query: select key k, count(value) from dest1 group by key
@@ -185,18 +185,18 @@ PREHOOK: Input: default@dest1
{"version":"1.0","engine":"tez","database":"default","hash":"1253b0d8b57dc384abbcaa0fb30dff88","queryText":"select key k, count(value) from dest1 group by key","edges":[{"sources":[2],"targets":[0],"edgeType":"PROJECTION"},{"sources":[3],"targets":[1],"expression":"count(default.dest1.value)","edgeType":"PROJECTION"}],"vertices":[{"id":0,"vertexType":"COLUMN","vertexId":"k"},{"id":1,"vertexType":"COLUMN","vertexId":"_c1"},{"id":2,"vertexType":"COLUMN","vertexId":"default.dest1.key"},{"id":3,"vertexType":"COLUMN","vertexId":"default.dest1.value"}]}
128 2
213 2
-278 2
-369 2
- 20
-150 2
-238 2
+401 2
66 2
146 2
224 2
-255 2
+238 2
273 2
+ 20
+150 2
+255 2
+278 2
311 2
-401 2
+369 2
406 2
98 2
PREHOOK: query: select value, max(length(key)) from dest1 group by value
@@ -205,23 +205,23 @@ PREHOOK: Input: default@dest1
#### A masked pattern was here ####
{"version":"1.0","engine":"tez","database":"default","hash":"eb9155fd36ab5b8c92dc3c8c21be2378","queryText":"select value, max(length(key)) from dest1 group by value","edges":[{"sources":[2],"targets":[0],"edgeType":"PROJECTION"},{"sources":[3],"targets":[1],"expression":"max(length(dest1.key))","edgeType":"PROJECTION"}],"vertices":[{"id":0,"vertexType":"COLUMN","vertexId":"value"},{"id":1,"vertexType":"COLUMN","vertexId":"_c1"},{"id":2,"vertexType":"COLUMN","vertexId":"default.dest1.value"},{"id":3,"vertexType":"COLUMN","vertexId":"default.dest1.key"}]}
val_146 3
-val_27 0
+val_213 3
+val_238 3
+val_278 3
+val_406 3
val_409 0
-val_484 0
val_66 2
+val_265 0
+val_27 0
3
+val_150 3
val_165 0
-val_238 3
val_193 0
-val_213 3
val_255 3
-val_265 0
val_273 3
-val_278 3
-val_401 3
-val_150 3
val_311 3
-val_406 3
+val_401 3
+val_484 0
val_98 2
PREHOOK: query: select value, max(length(key)) from dest1 group by value order by value limit 5
PREHOOK: type: QUERY
http://git-wip-us.apache.org/repos/asf/hive/blob/091fd962/ql/src/test/results/clientpositive/llap/list_bucket_dml_10.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/list_bucket_dml_10.q.out b/ql/src/test/results/clientpositive/llap/list_bucket_dml_10.q.out
index 2bf96d0..5e9d191 100644
--- a/ql/src/test/results/clientpositive/llap/list_bucket_dml_10.q.out
+++ b/ql/src/test/results/clientpositive/llap/list_bucket_dml_10.q.out
@@ -59,6 +59,7 @@ STAGE PLANS:
output format: org.apache.hadoop.hive.ql.io.RCFileOutputFormat
properties:
bucket_count -1
+ bucketing_version 2
column.name.delimiter ,
columns key,value
columns.comments
@@ -108,6 +109,7 @@ STAGE PLANS:
properties:
COLUMN_STATS_ACCURATE {"BASIC_STATS":"true","COLUMN_STATS":{"key":"true","value":"true"}}
bucket_count -1
+ bucketing_version 2
column.name.delimiter ,
columns key,value
columns.comments 'default','default'
@@ -129,6 +131,7 @@ STAGE PLANS:
properties:
COLUMN_STATS_ACCURATE {"BASIC_STATS":"true","COLUMN_STATS":{"key":"true","value":"true"}}
bucket_count -1
+ bucketing_version 2
column.name.delimiter ,
columns key,value
columns.comments 'default','default'
@@ -201,6 +204,7 @@ STAGE PLANS:
output format: org.apache.hadoop.hive.ql.io.RCFileOutputFormat
properties:
bucket_count -1
+ bucketing_version 2
column.name.delimiter ,
columns key,value
columns.comments
http://git-wip-us.apache.org/repos/asf/hive/blob/091fd962/ql/src/test/results/clientpositive/llap/llap_nullscan.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/llap_nullscan.q.out b/ql/src/test/results/clientpositive/llap/llap_nullscan.q.out
index 911b65a..aa0e6e4 100644
--- a/ql/src/test/results/clientpositive/llap/llap_nullscan.q.out
+++ b/ql/src/test/results/clientpositive/llap/llap_nullscan.q.out
@@ -87,6 +87,7 @@ STAGE PLANS:
properties:
COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"}
bucket_count -1
+ bucketing_version 2
column.name.delimiter ,
columns key,value,ds,hr
columns.comments
@@ -109,6 +110,7 @@ STAGE PLANS:
properties:
COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"}
bucket_count -1
+ bucketing_version 2
column.name.delimiter ,
columns key,value,ds,hr
columns.comments
http://git-wip-us.apache.org/repos/asf/hive/blob/091fd962/ql/src/test/results/clientpositive/llap/llap_smb.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/llap_smb.q.out b/ql/src/test/results/clientpositive/llap/llap_smb.q.out
index 44d78f5..d526fd3 100644
--- a/ql/src/test/results/clientpositive/llap/llap_smb.q.out
+++ b/ql/src/test/results/clientpositive/llap/llap_smb.q.out
@@ -172,26 +172,26 @@ POSTHOOK: Input: default@orc_a@y=2001/q=8
POSTHOOK: Input: default@orc_a@y=2001/q=9
POSTHOOK: Input: default@orc_b
#### A masked pattern was here ####
-2000 2 6578
-2001 8 9438
-2000 3 6149
-2000 5 5720
+2000 0 6721
+2000 4 7865
+2000 7 6149
2000 9 8151
+2001 3 6149
+2001 7 6149
+2000 2 6578
2001 0 6721
2001 1 7493
2001 2 6578
-2001 4 7865
2001 9 8151
2000 1 7493
-2000 7 6149
+2000 3 6149
+2000 5 5720
+2000 6 5577
2000 8 9438
2001 6 5577
-2001 7 6149
-2000 0 6721
-2000 4 7865
-2000 6 5577
-2001 3 6149
+2001 4 7865
2001 5 5720
+2001 8 9438
PREHOOK: query: explain
select y,q,count(*) from orc_a a join orc_b b on a.id=b.id group by y,q
PREHOOK: type: QUERY
@@ -321,26 +321,26 @@ POSTHOOK: Input: default@orc_a@y=2001/q=8
POSTHOOK: Input: default@orc_a@y=2001/q=9
POSTHOOK: Input: default@orc_b
#### A masked pattern was here ####
-2000 2 6578
-2001 8 9438
-2000 3 6149
-2000 5 5720
+2000 0 6721
+2000 4 7865
+2000 7 6149
2000 9 8151
+2001 3 6149
+2001 7 6149
+2000 2 6578
2001 0 6721
2001 1 7493
2001 2 6578
-2001 4 7865
2001 9 8151
2000 1 7493
-2000 7 6149
+2000 3 6149
+2000 5 5720
+2000 6 5577
2000 8 9438
2001 6 5577
-2001 7 6149
-2000 0 6721
-2000 4 7865
-2000 6 5577
-2001 3 6149
+2001 4 7865
2001 5 5720
+2001 8 9438
PREHOOK: query: DROP TABLE orc_a
PREHOOK: type: DROPTABLE
PREHOOK: Input: default@orc_a
http://git-wip-us.apache.org/repos/asf/hive/blob/091fd962/ql/src/test/results/clientpositive/llap/mapjoin_mapjoin.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/mapjoin_mapjoin.q.out b/ql/src/test/results/clientpositive/llap/mapjoin_mapjoin.q.out
index c4361de..89be933 100644
--- a/ql/src/test/results/clientpositive/llap/mapjoin_mapjoin.q.out
+++ b/ql/src/test/results/clientpositive/llap/mapjoin_mapjoin.q.out
@@ -112,6 +112,7 @@ STAGE PLANS:
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
properties:
bucket_count -1
+ bucketing_version 2
column.name.delimiter ,
columns key,value
columns.comments 'default','default'
@@ -160,6 +161,7 @@ STAGE PLANS:
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
properties:
bucket_count -1
+ bucketing_version 2
column.name.delimiter ,
columns key,value
columns.comments 'default','default'
@@ -208,6 +210,7 @@ STAGE PLANS:
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
properties:
bucket_count -1
+ bucketing_version 2
column.name.delimiter ,
columns key,value
columns.comments 'default','default'
@@ -256,6 +259,7 @@ STAGE PLANS:
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
properties:
bucket_count -1
+ bucketing_version 2
column.name.delimiter ,
columns key,value
columns.comments 'default','default'
@@ -311,6 +315,7 @@ STAGE PLANS:
properties:
COLUMN_STATS_ACCURATE {"BASIC_STATS":"true","COLUMN_STATS":{"key":"true","value":"true"}}
bucket_count -1
+ bucketing_version 2
column.name.delimiter ,
columns key,value
columns.comments 'default','default'
@@ -332,6 +337,7 @@ STAGE PLANS:
properties:
COLUMN_STATS_ACCURATE {"BASIC_STATS":"true","COLUMN_STATS":{"key":"true","value":"true"}}
bucket_count -1
+ bucketing_version 2
column.name.delimiter ,
columns key,value
columns.comments 'default','default'
@@ -386,6 +392,7 @@ STAGE PLANS:
properties:
COLUMN_STATS_ACCURATE {"BASIC_STATS":"true","COLUMN_STATS":{"key":"true","value":"true"}}
bucket_count -1
+ bucketing_version 2
column.name.delimiter ,
columns key,value
columns.comments 'default','default'
@@ -407,6 +414,7 @@ STAGE PLANS:
properties:
COLUMN_STATS_ACCURATE {"BASIC_STATS":"true","COLUMN_STATS":{"key":"true","value":"true"}}
bucket_count -1
+ bucketing_version 2
column.name.delimiter ,
columns key,value
columns.comments 'default','default'
http://git-wip-us.apache.org/repos/asf/hive/blob/091fd962/ql/src/test/results/clientpositive/llap/materialized_view_create.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/materialized_view_create.q.out b/ql/src/test/results/clientpositive/llap/materialized_view_create.q.out
index 8952304..2181f83 100644
--- a/ql/src/test/results/clientpositive/llap/materialized_view_create.q.out
+++ b/ql/src/test/results/clientpositive/llap/materialized_view_create.q.out
@@ -46,6 +46,7 @@ Retention: 0
Table Type: MATERIALIZED_VIEW
Table Parameters:
COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\"}
+ bucketing_version 2
numFiles 1
numRows 5
rawDataSize 1025
@@ -106,6 +107,7 @@ Retention: 0
Table Type: MATERIALIZED_VIEW
Table Parameters:
COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\"}
+ bucketing_version 2
numFiles 1
numRows 5
rawDataSize 580
@@ -179,8 +181,8 @@ POSTHOOK: type: QUERY
POSTHOOK: Input: default@cmv_mat_view4
#### A masked pattern was here ####
1 10.30
-2 172345.34
3 988.56
+2 172345.34
PREHOOK: query: describe extended cmv_mat_view4
PREHOOK: type: DESCTABLE
PREHOOK: Input: default@cmv_mat_view4
@@ -240,6 +242,7 @@ PREHOOK: type: SHOW_TBLPROPERTIES
POSTHOOK: query: show tblproperties cmv_mat_view5
POSTHOOK: type: SHOW_TBLPROPERTIES
COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"}
+bucketing_version 2
key value
numFiles 1
numRows 5
http://git-wip-us.apache.org/repos/asf/hive/blob/091fd962/ql/src/test/results/clientpositive/llap/materialized_view_create_rewrite.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/materialized_view_create_rewrite.q.out b/ql/src/test/results/clientpositive/llap/materialized_view_create_rewrite.q.out
index f9879f7..654a15c 100644
--- a/ql/src/test/results/clientpositive/llap/materialized_view_create_rewrite.q.out
+++ b/ql/src/test/results/clientpositive/llap/materialized_view_create_rewrite.q.out
@@ -65,6 +65,7 @@ PREHOOK: type: SHOW_TBLPROPERTIES
POSTHOOK: query: show tblproperties cmv_mat_view
POSTHOOK: type: SHOW_TBLPROPERTIES
COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"}
+bucketing_version 2
numFiles 1
numRows 2
rawDataSize 408
@@ -97,6 +98,7 @@ PREHOOK: type: SHOW_TBLPROPERTIES
POSTHOOK: query: show tblproperties cmv_mat_view2
POSTHOOK: type: SHOW_TBLPROPERTIES
COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"}
+bucketing_version 2
numFiles 1
numRows 2
rawDataSize 232
http://git-wip-us.apache.org/repos/asf/hive/blob/091fd962/ql/src/test/results/clientpositive/llap/materialized_view_create_rewrite_2.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/materialized_view_create_rewrite_2.q.out b/ql/src/test/results/clientpositive/llap/materialized_view_create_rewrite_2.q.out
index 9c3c336..66431a5 100644
--- a/ql/src/test/results/clientpositive/llap/materialized_view_create_rewrite_2.q.out
+++ b/ql/src/test/results/clientpositive/llap/materialized_view_create_rewrite_2.q.out
@@ -126,8 +126,8 @@ POSTHOOK: query: select b from cmv_basetable where c > 20.0 group by a, b
POSTHOOK: type: QUERY
POSTHOOK: Input: default@cmv_basetable
#### A masked pattern was here ####
-bonnie
calvin
+bonnie
PREHOOK: query: create materialized view cmv_mat_view_2 enable rewrite
as select b, c from cmv_basetable where c > 10.0 group by a, b, c
PREHOOK: type: CREATE_MATERIALIZED_VIEW
@@ -216,8 +216,8 @@ POSTHOOK: query: select b from cmv_basetable where c > 20.0 group by a, b
POSTHOOK: type: QUERY
POSTHOOK: Input: default@cmv_basetable
#### A masked pattern was here ####
-bonnie
calvin
+bonnie
PREHOOK: query: create materialized view cmv_mat_view_3 enable rewrite
as select a, b, c from cmv_basetable where c > 10.0 group by a, b, c
PREHOOK: type: CREATE_MATERIALIZED_VIEW
@@ -308,8 +308,8 @@ POSTHOOK: type: QUERY
POSTHOOK: Input: default@cmv_basetable
POSTHOOK: Input: default@cmv_mat_view_3
#### A masked pattern was here ####
-bonnie
calvin
+bonnie
PREHOOK: query: create materialized view cmv_mat_view_4 enable rewrite
as select a, b from cmv_basetable group by a, b
PREHOOK: type: CREATE_MATERIALIZED_VIEW
@@ -393,8 +393,8 @@ POSTHOOK: type: QUERY
POSTHOOK: Input: default@cmv_basetable
POSTHOOK: Input: default@cmv_mat_view_4
#### A masked pattern was here ####
-bob
alfred
+bob
bonnie
charlie
calvin
@@ -499,8 +499,8 @@ POSTHOOK: Input: default@cmv_basetable
POSTHOOK: Input: default@cmv_basetable_2
POSTHOOK: Input: default@cmv_mat_view_5
#### A masked pattern was here ####
-3
1
+3
PREHOOK: query: explain
select cmv_basetable.a
from cmv_basetable join cmv_basetable_2 on (cmv_basetable.a = cmv_basetable_2.a)
http://git-wip-us.apache.org/repos/asf/hive/blob/091fd962/ql/src/test/results/clientpositive/llap/materialized_view_create_rewrite_3.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/materialized_view_create_rewrite_3.q.out b/ql/src/test/results/clientpositive/llap/materialized_view_create_rewrite_3.q.out
index bd0f903..dad8ebe 100644
--- a/ql/src/test/results/clientpositive/llap/materialized_view_create_rewrite_3.q.out
+++ b/ql/src/test/results/clientpositive/llap/materialized_view_create_rewrite_3.q.out
@@ -278,8 +278,8 @@ POSTHOOK: Input: default@cmv_basetable
POSTHOOK: Input: default@cmv_basetable_2
POSTHOOK: Input: default@cmv_mat_view
#### A masked pattern was here ####
-3
1
+3
PREHOOK: query: insert into cmv_basetable_2 values
(3, 'charlie', 15.8, 1)
PREHOOK: type: QUERY
@@ -431,9 +431,9 @@ POSTHOOK: type: QUERY
POSTHOOK: Input: default@cmv_basetable
POSTHOOK: Input: default@cmv_basetable_2
#### A masked pattern was here ####
+1
3
3
-1
PREHOOK: query: EXPLAIN
ALTER MATERIALIZED VIEW cmv_mat_view REBUILD
PREHOOK: type: QUERY
@@ -690,9 +690,9 @@ POSTHOOK: Input: default@cmv_basetable
POSTHOOK: Input: default@cmv_basetable_2
POSTHOOK: Input: default@cmv_mat_view
#### A masked pattern was here ####
+1
3
3
-1
PREHOOK: query: DELETE FROM cmv_basetable_2 WHERE a = 3
PREHOOK: type: QUERY
PREHOOK: Input: default@cmv_basetable_2
http://git-wip-us.apache.org/repos/asf/hive/blob/091fd962/ql/src/test/results/clientpositive/llap/materialized_view_create_rewrite_4.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/materialized_view_create_rewrite_4.q.out b/ql/src/test/results/clientpositive/llap/materialized_view_create_rewrite_4.q.out
index 2f88037..3224b5d 100644
--- a/ql/src/test/results/clientpositive/llap/materialized_view_create_rewrite_4.q.out
+++ b/ql/src/test/results/clientpositive/llap/materialized_view_create_rewrite_4.q.out
@@ -264,6 +264,7 @@ Retention: 0
Table Type: MATERIALIZED_VIEW
Table Parameters:
COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\",\"COLUMN_STATS\":{\"_c2\":\"true\",\"a\":\"true\",\"c\":\"true\"}}
+ bucketing_version 2
numFiles 2
numRows 2
rawDataSize 248
@@ -421,8 +422,8 @@ POSTHOOK: type: QUERY
POSTHOOK: Input: default@cmv_basetable
POSTHOOK: Input: default@cmv_basetable_2
#### A masked pattern was here ####
-3 6
1 2
+3 6
PREHOOK: query: insert into cmv_basetable_2 values
(3, 'charlie', 15.8, 1)
PREHOOK: type: QUERY
@@ -490,6 +491,7 @@ Retention: 0
Table Type: MATERIALIZED_VIEW
Table Parameters:
COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\",\"COLUMN_STATS\":{\"_c2\":\"true\",\"a\":\"true\",\"c\":\"true\"}}
+ bucketing_version 2
numFiles 2
numRows 2
rawDataSize 248
@@ -647,9 +649,9 @@ POSTHOOK: type: QUERY
POSTHOOK: Input: default@cmv_basetable
POSTHOOK: Input: default@cmv_basetable_2
#### A masked pattern was here ####
+1 2
3 2
3 6
-1 2
PREHOOK: query: EXPLAIN
ALTER MATERIALIZED VIEW cmv_mat_view REBUILD
PREHOOK: type: QUERY
@@ -933,6 +935,7 @@ Retention: 0
#### A masked pattern was here ####
Table Type: MATERIALIZED_VIEW
Table Parameters:
+ bucketing_version 2
numFiles 3
totalSize 1453
transactional true
@@ -1005,8 +1008,8 @@ POSTHOOK: Input: default@cmv_basetable
POSTHOOK: Input: default@cmv_basetable_2
POSTHOOK: Input: default@cmv_mat_view
#### A masked pattern was here ####
-3 6
1 2
+3 6
3 2
PREHOOK: query: UPDATE cmv_basetable_2 SET a=2 WHERE a=1
PREHOOK: type: QUERY
http://git-wip-us.apache.org/repos/asf/hive/blob/091fd962/ql/src/test/results/clientpositive/llap/materialized_view_create_rewrite_5.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/materialized_view_create_rewrite_5.q.out b/ql/src/test/results/clientpositive/llap/materialized_view_create_rewrite_5.q.out
index d69f962..ed8834e 100644
--- a/ql/src/test/results/clientpositive/llap/materialized_view_create_rewrite_5.q.out
+++ b/ql/src/test/results/clientpositive/llap/materialized_view_create_rewrite_5.q.out
@@ -398,6 +398,7 @@ Retention: 0
#### A masked pattern was here ####
Table Type: MATERIALIZED_VIEW
Table Parameters:
+ bucketing_version 2
numFiles 2
totalSize 1055
transactional true
http://git-wip-us.apache.org/repos/asf/hive/blob/091fd962/ql/src/test/results/clientpositive/llap/materialized_view_create_rewrite_dummy.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/materialized_view_create_rewrite_dummy.q.out b/ql/src/test/results/clientpositive/llap/materialized_view_create_rewrite_dummy.q.out
index f9879f7..654a15c 100644
--- a/ql/src/test/results/clientpositive/llap/materialized_view_create_rewrite_dummy.q.out
+++ b/ql/src/test/results/clientpositive/llap/materialized_view_create_rewrite_dummy.q.out
@@ -65,6 +65,7 @@ PREHOOK: type: SHOW_TBLPROPERTIES
POSTHOOK: query: show tblproperties cmv_mat_view
POSTHOOK: type: SHOW_TBLPROPERTIES
COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"}
+bucketing_version 2
numFiles 1
numRows 2
rawDataSize 408
@@ -97,6 +98,7 @@ PREHOOK: type: SHOW_TBLPROPERTIES
POSTHOOK: query: show tblproperties cmv_mat_view2
POSTHOOK: type: SHOW_TBLPROPERTIES
COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"}
+bucketing_version 2
numFiles 1
numRows 2
rawDataSize 232
http://git-wip-us.apache.org/repos/asf/hive/blob/091fd962/ql/src/test/results/clientpositive/llap/materialized_view_create_rewrite_multi_db.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/materialized_view_create_rewrite_multi_db.q.out b/ql/src/test/results/clientpositive/llap/materialized_view_create_rewrite_multi_db.q.out
index af56032..c728546 100644
--- a/ql/src/test/results/clientpositive/llap/materialized_view_create_rewrite_multi_db.q.out
+++ b/ql/src/test/results/clientpositive/llap/materialized_view_create_rewrite_multi_db.q.out
@@ -89,6 +89,7 @@ PREHOOK: type: SHOW_TBLPROPERTIES
POSTHOOK: query: show tblproperties cmv_mat_view
POSTHOOK: type: SHOW_TBLPROPERTIES
COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"}
+bucketing_version 2
numFiles 1
numRows 2
rawDataSize 408
@@ -121,6 +122,7 @@ PREHOOK: type: SHOW_TBLPROPERTIES
POSTHOOK: query: show tblproperties cmv_mat_view2
POSTHOOK: type: SHOW_TBLPROPERTIES
COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"}
+bucketing_version 2
numFiles 1
numRows 2
rawDataSize 232
http://git-wip-us.apache.org/repos/asf/hive/blob/091fd962/ql/src/test/results/clientpositive/llap/materialized_view_create_rewrite_rebuild_dummy.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/materialized_view_create_rewrite_rebuild_dummy.q.out b/ql/src/test/results/clientpositive/llap/materialized_view_create_rewrite_rebuild_dummy.q.out
index bd0f903..dad8ebe 100644
--- a/ql/src/test/results/clientpositive/llap/materialized_view_create_rewrite_rebuild_dummy.q.out
+++ b/ql/src/test/results/clientpositive/llap/materialized_view_create_rewrite_rebuild_dummy.q.out
@@ -278,8 +278,8 @@ POSTHOOK: Input: default@cmv_basetable
POSTHOOK: Input: default@cmv_basetable_2
POSTHOOK: Input: default@cmv_mat_view
#### A masked pattern was here ####
-3
1
+3
PREHOOK: query: insert into cmv_basetable_2 values
(3, 'charlie', 15.8, 1)
PREHOOK: type: QUERY
@@ -431,9 +431,9 @@ POSTHOOK: type: QUERY
POSTHOOK: Input: default@cmv_basetable
POSTHOOK: Input: default@cmv_basetable_2
#### A masked pattern was here ####
+1
3
3
-1
PREHOOK: query: EXPLAIN
ALTER MATERIALIZED VIEW cmv_mat_view REBUILD
PREHOOK: type: QUERY
@@ -690,9 +690,9 @@ POSTHOOK: Input: default@cmv_basetable
POSTHOOK: Input: default@cmv_basetable_2
POSTHOOK: Input: default@cmv_mat_view
#### A masked pattern was here ####
+1
3
3
-1
PREHOOK: query: DELETE FROM cmv_basetable_2 WHERE a = 3
PREHOOK: type: QUERY
PREHOOK: Input: default@cmv_basetable_2
http://git-wip-us.apache.org/repos/asf/hive/blob/091fd962/ql/src/test/results/clientpositive/llap/materialized_view_create_rewrite_time_window.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/materialized_view_create_rewrite_time_window.q.out b/ql/src/test/results/clientpositive/llap/materialized_view_create_rewrite_time_window.q.out
index e820e5c..d45ccde 100644
--- a/ql/src/test/results/clientpositive/llap/materialized_view_create_rewrite_time_window.q.out
+++ b/ql/src/test/results/clientpositive/llap/materialized_view_create_rewrite_time_window.q.out
@@ -250,6 +250,7 @@ Retention: 0
Table Type: MATERIALIZED_VIEW
Table Parameters:
COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\"}
+ bucketing_version 2
numFiles 2
numRows 2
rawDataSize 232
@@ -403,8 +404,8 @@ POSTHOOK: type: QUERY
POSTHOOK: Input: default@cmv_basetable
POSTHOOK: Input: default@cmv_basetable_2
#### A masked pattern was here ####
-3
1
+3
PREHOOK: query: insert into cmv_basetable_2 values
(3, 'charlie', 15.8, 1)
PREHOOK: type: QUERY
@@ -471,6 +472,7 @@ Retention: 0
Table Type: MATERIALIZED_VIEW
Table Parameters:
COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\"}
+ bucketing_version 2
numFiles 2
numRows 2
rawDataSize 232
@@ -544,8 +546,8 @@ POSTHOOK: Input: default@cmv_basetable
POSTHOOK: Input: default@cmv_basetable_2
POSTHOOK: Input: default@cmv_mat_view
#### A masked pattern was here ####
-3
1
+3
PREHOOK: query: EXPLAIN
ALTER MATERIALIZED VIEW cmv_mat_view REBUILD
PREHOOK: type: QUERY
@@ -773,11 +775,12 @@ Retention: 0
Table Type: MATERIALIZED_VIEW
Table Parameters:
COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\",\"COLUMN_STATS\":{\"a\":\"true\",\"c\":\"true\"}}
- numFiles 3
+ bucketing_version 2
+ numFiles 2
numRows 3
rawDataSize 348
rewriting.time.window 300s
- totalSize 877
+ totalSize 616
#### A masked pattern was here ####
# Storage Information
@@ -846,9 +849,9 @@ POSTHOOK: Input: default@cmv_basetable
POSTHOOK: Input: default@cmv_basetable_2
POSTHOOK: Input: default@cmv_mat_view
#### A masked pattern was here ####
+1
3
3
-1
PREHOOK: query: drop materialized view cmv_mat_view
PREHOOK: type: DROP_MATERIALIZED_VIEW
PREHOOK: Input: default@cmv_mat_view
http://git-wip-us.apache.org/repos/asf/hive/blob/091fd962/ql/src/test/results/clientpositive/llap/materialized_view_describe.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/materialized_view_describe.q.out b/ql/src/test/results/clientpositive/llap/materialized_view_describe.q.out
index efd60d4..b80d7b64 100644
--- a/ql/src/test/results/clientpositive/llap/materialized_view_describe.q.out
+++ b/ql/src/test/results/clientpositive/llap/materialized_view_describe.q.out
@@ -67,6 +67,7 @@ Retention: 0
Table Type: MATERIALIZED_VIEW
Table Parameters:
COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\"}
+ bucketing_version 2
comment this is the first view
key foo
numFiles 1
@@ -93,6 +94,7 @@ PREHOOK: type: SHOW_TBLPROPERTIES
POSTHOOK: query: show tblproperties cmv_mat_view
POSTHOOK: type: SHOW_TBLPROPERTIES
COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"}
+bucketing_version 2
comment this is the first view
key foo
numFiles 1
@@ -154,6 +156,7 @@ Retention: 0
Table Type: MATERIALIZED_VIEW
Table Parameters:
COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\"}
+ bucketing_version 2
comment this is the second view
key alice
key2 bob
@@ -234,6 +237,7 @@ Retention: 0
Table Type: MATERIALIZED_VIEW
Table Parameters:
COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\"}
+ bucketing_version 2
comment this is the third view
numFiles 1
numRows 5
@@ -276,8 +280,8 @@ POSTHOOK: type: QUERY
POSTHOOK: Input: default@cmv_mat_view3
#### A masked pattern was here ####
1
-2
3
+2
PREHOOK: query: drop materialized view cmv_mat_view3
PREHOOK: type: DROP_MATERIALIZED_VIEW
PREHOOK: Input: default@cmv_mat_view3
@@ -323,6 +327,7 @@ Retention: 0
Table Type: MATERIALIZED_VIEW
Table Parameters:
COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\"}
+ bucketing_version 2
comment this is the last view
numFiles 1
numRows 5