You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by br...@apache.org on 2014/11/18 01:48:46 UTC
svn commit: r1640263 [9/12] - in /hive/branches/spark: ./
accumulo-handler/src/java/org/apache/hadoop/hive/accumulo/
accumulo-handler/src/java/org/apache/hadoop/hive/accumulo/mr/
accumulo-handler/src/java/org/apache/hadoop/hive/accumulo/predicate/ accu...
Modified: hive/branches/spark/ql/src/test/results/clientpositive/ctas_colname.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/ctas_colname.q.out?rev=1640263&r1=1640262&r2=1640263&view=diff
==============================================================================
--- hive/branches/spark/ql/src/test/results/clientpositive/ctas_colname.q.out (original)
+++ hive/branches/spark/ql/src/test/results/clientpositive/ctas_colname.q.out Tue Nov 18 00:48:40 2014
@@ -461,17 +461,22 @@ POSTHOOK: Input: default@x5
119 val_119 119
PREHOOK: query: -- sub queries
explain
-create table x6 as select * from (select *, max(key) from src1) a
+create table x6 as select * from (select *, key + 1 from src1) a
PREHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: query: -- sub queries
explain
-create table x6 as select * from (select *, max(key) from src1) a
+create table x6 as select * from (select *, key + 1 from src1) a
POSTHOOK: type: CREATETABLE_AS_SELECT
STAGE DEPENDENCIES:
Stage-1 is a root stage
- Stage-0 depends on stages: Stage-1
- Stage-3 depends on stages: Stage-0
- Stage-2 depends on stages: Stage-3
+ Stage-7 depends on stages: Stage-1 , consists of Stage-4, Stage-3, Stage-5
+ Stage-4
+ Stage-0 depends on stages: Stage-4, Stage-3, Stage-6
+ Stage-8 depends on stages: Stage-0
+ Stage-2 depends on stages: Stage-8
+ Stage-3
+ Stage-5
+ Stage-6 depends on stages: Stage-5
STAGE PLANS:
Stage: Stage-1
@@ -481,36 +486,26 @@ STAGE PLANS:
alias: src1
Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: key (type: string)
- outputColumnNames: key
+ expressions: key (type: string), value (type: string), (key + 1) (type: double)
+ outputColumnNames: _col0, _col1, _col2
Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE
- Group By Operator
- aggregations: max(key)
- mode: hash
- outputColumnNames: _col0
- Statistics: Num rows: 1 Data size: 84 Basic stats: COMPLETE Column stats: NONE
- Reduce Output Operator
- sort order:
- Statistics: Num rows: 1 Data size: 84 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col0 (type: string)
- Reduce Operator Tree:
- Group By Operator
- aggregations: max(VALUE._col0)
- mode: mergepartial
- outputColumnNames: _col0
- Statistics: Num rows: 1 Data size: 84 Basic stats: COMPLETE Column stats: NONE
- Select Operator
- expressions: _col0 (type: string), _col0 (type: string)
- outputColumnNames: _col0, _col1
- Statistics: Num rows: 1 Data size: 84 Basic stats: COMPLETE Column stats: NONE
- File Output Operator
- compressed: false
- Statistics: Num rows: 1 Data size: 84 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
- name: default.x6
+ File Output Operator
+ compressed: false
+ Statistics: Num rows: 25 Data size: 191 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
+ name: default.x6
+
+ Stage: Stage-7
+ Conditional Operator
+
+ Stage: Stage-4
+ Move Operator
+ files:
+ hdfs directory: true
+#### A masked pattern was here ####
Stage: Stage-0
Move Operator
@@ -518,10 +513,10 @@ STAGE PLANS:
hdfs directory: true
#### A masked pattern was here ####
- Stage: Stage-3
+ Stage: Stage-8
Create Table Operator:
Create Table
- columns: _col0 string, _c1 string
+ columns: key string, value string, _c1 double
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
serde name: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
@@ -530,12 +525,42 @@ STAGE PLANS:
Stage: Stage-2
Stats-Aggr Operator
-PREHOOK: query: create table x6 as select * from (select *, max(key) from src1) a
+ Stage: Stage-3
+ Map Reduce
+ Map Operator Tree:
+ TableScan
+ 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
+ name: default.x6
+
+ Stage: Stage-5
+ Map Reduce
+ Map Operator Tree:
+ TableScan
+ 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
+ name: default.x6
+
+ Stage: Stage-6
+ Move Operator
+ files:
+ hdfs directory: true
+#### A masked pattern was here ####
+
+PREHOOK: query: create table x6 as select * from (select *, key + 1 from src1) a
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@src1
PREHOOK: Output: database:default
PREHOOK: Output: default@x6
-POSTHOOK: query: create table x6 as select * from (select *, max(key) from src1) a
+POSTHOOK: query: create table x6 as select * from (select *, key + 1 from src1) a
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@src1
POSTHOOK: Output: database:default
@@ -548,8 +573,9 @@ POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@x6
# col_name data_type comment
-_col0 string
-_c1 string
+key string
+value string
+_c1 double
# Detailed Table Information
Database: default
@@ -561,9 +587,9 @@ Table Type: MANAGED_TABLE
Table Parameters:
COLUMN_STATS_ACCURATE true
numFiles 1
- numRows 1
- rawDataSize 5
- totalSize 6
+ numRows 25
+ rawDataSize 309
+ totalSize 334
#### A masked pattern was here ####
# Storage Information
@@ -584,12 +610,36 @@ POSTHOOK: query: select * from x6
POSTHOOK: type: QUERY
POSTHOOK: Input: default@x6
#### A masked pattern was here ####
-98 98
+ NULL
+ NULL
+ NULL
+ NULL
+ val_165 NULL
+ val_193 NULL
+ val_265 NULL
+ val_27 NULL
+ val_409 NULL
+ val_484 NULL
+128 129.0
+146 val_146 147.0
+150 val_150 151.0
+213 val_213 214.0
+224 225.0
+238 val_238 239.0
+255 val_255 256.0
+273 val_273 274.0
+278 val_278 279.0
+311 val_311 312.0
+369 370.0
+401 val_401 402.0
+406 val_406 407.0
+66 val_66 67.0
+98 val_98 99.0
PREHOOK: query: explain
-create table x7 as select * from (select * from src group by key) a
+create table x7 as select * from (select *, count(value) from src group by key, value) a
PREHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: query: explain
-create table x7 as select * from (select * from src group by key) a
+create table x7 as select * from (select *, count(value) from src group by key, value) a
POSTHOOK: type: CREATETABLE_AS_SELECT
STAGE DEPENDENCIES:
Stage-1 is a root stage
@@ -605,28 +655,31 @@ STAGE PLANS:
alias: src
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: key (type: string)
- outputColumnNames: key
+ expressions: key (type: string), value (type: string)
+ outputColumnNames: key, value
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Group By Operator
- keys: key (type: string)
+ aggregations: count(value)
+ keys: key (type: string), value (type: string)
mode: hash
- outputColumnNames: _col0
+ outputColumnNames: _col0, _col1, _col2
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
- key expressions: _col0 (type: string)
- sort order: +
- Map-reduce partition columns: _col0 (type: string)
+ key expressions: _col0 (type: string), _col1 (type: string)
+ sort order: ++
+ Map-reduce partition columns: _col0 (type: string), _col1 (type: string)
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
+ value expressions: _col2 (type: bigint)
Reduce Operator Tree:
Group By Operator
- keys: KEY._col0 (type: string)
+ aggregations: count(VALUE._col0)
+ keys: KEY._col0 (type: string), KEY._col1 (type: string)
mode: mergepartial
- outputColumnNames: _col0
+ outputColumnNames: _col0, _col1, _col2
Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: _col0 (type: string)
- outputColumnNames: _col0
+ expressions: _col0 (type: string), _col1 (type: string), _col2 (type: bigint)
+ outputColumnNames: _col0, _col1, _col2
Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
@@ -646,7 +699,7 @@ STAGE PLANS:
Stage: Stage-3
Create Table Operator:
Create Table
- columns: _col0 string
+ columns: _col0 string, _col1 string, _c1 bigint
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
serde name: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
@@ -655,12 +708,12 @@ STAGE PLANS:
Stage: Stage-2
Stats-Aggr Operator
-PREHOOK: query: create table x7 as select * from (select * from src group by key) a
+PREHOOK: query: create table x7 as select * from (select *, count(value) from src group by key, value) a
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@src
PREHOOK: Output: database:default
PREHOOK: Output: default@x7
-POSTHOOK: query: create table x7 as select * from (select * from src group by key) a
+POSTHOOK: query: create table x7 as select * from (select *, count(value) from src group by key, value) a
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@src
POSTHOOK: Output: database:default
@@ -674,6 +727,8 @@ POSTHOOK: Input: default@x7
# col_name data_type comment
_col0 string
+_col1 string
+_c1 bigint
# Detailed Table Information
Database: default
@@ -686,8 +741,8 @@ Table Parameters:
COLUMN_STATS_ACCURATE true
numFiles 1
numRows 309
- rawDataSize 864
- totalSize 1173
+ rawDataSize 3891
+ totalSize 4200
#### A masked pattern was here ####
# Storage Information
@@ -708,320 +763,320 @@ POSTHOOK: query: select * from x7
POSTHOOK: type: QUERY
POSTHOOK: Input: default@x7
#### A masked pattern was here ####
-0
-10
-100
-103
-104
-105
-11
-111
-113
-114
-116
-118
-119
-12
-120
-125
-126
-128
-129
-131
-133
-134
-136
-137
-138
-143
-145
-146
-149
-15
-150
-152
-153
-155
-156
-157
-158
-160
-162
-163
-164
-165
-166
-167
-168
-169
-17
-170
-172
-174
-175
-176
-177
-178
-179
-18
-180
-181
-183
-186
-187
-189
-19
-190
-191
-192
-193
-194
-195
-196
-197
-199
-2
-20
-200
-201
-202
-203
-205
-207
-208
-209
-213
-214
-216
-217
-218
-219
-221
-222
-223
-224
-226
-228
-229
-230
-233
-235
-237
-238
-239
-24
-241
-242
-244
-247
-248
-249
-252
-255
-256
-257
-258
-26
-260
-262
-263
-265
-266
-27
-272
-273
-274
-275
-277
-278
-28
-280
-281
-282
-283
-284
-285
-286
-287
-288
-289
-291
-292
-296
-298
-30
-302
-305
-306
-307
-308
-309
-310
-311
-315
-316
-317
-318
-321
-322
-323
-325
-327
-33
-331
-332
-333
-335
-336
-338
-339
-34
-341
-342
-344
-345
-348
-35
-351
-353
-356
-360
-362
-364
-365
-366
-367
-368
-369
-37
-373
-374
-375
-377
-378
-379
-382
-384
-386
-389
-392
-393
-394
-395
-396
-397
-399
-4
-400
-401
-402
-403
-404
-406
-407
-409
-41
-411
-413
-414
-417
-418
-419
-42
-421
-424
-427
-429
-43
-430
-431
-432
-435
-436
-437
-438
-439
-44
-443
-444
-446
-448
-449
-452
-453
-454
-455
-457
-458
-459
-460
-462
-463
-466
-467
-468
-469
-47
-470
-472
-475
-477
-478
-479
-480
-481
-482
-483
-484
-485
-487
-489
-490
-491
-492
-493
-494
-495
-496
-497
-498
-5
-51
-53
-54
-57
-58
-64
-65
-66
-67
-69
-70
-72
-74
-76
-77
-78
-8
-80
-82
-83
-84
-85
-86
-87
-9
-90
-92
-95
-96
-97
-98
+0 val_0 3
+10 val_10 1
+100 val_100 2
+103 val_103 2
+104 val_104 2
+105 val_105 1
+11 val_11 1
+111 val_111 1
+113 val_113 2
+114 val_114 1
+116 val_116 1
+118 val_118 2
+119 val_119 3
+12 val_12 2
+120 val_120 2
+125 val_125 2
+126 val_126 1
+128 val_128 3
+129 val_129 2
+131 val_131 1
+133 val_133 1
+134 val_134 2
+136 val_136 1
+137 val_137 2
+138 val_138 4
+143 val_143 1
+145 val_145 1
+146 val_146 2
+149 val_149 2
+15 val_15 2
+150 val_150 1
+152 val_152 2
+153 val_153 1
+155 val_155 1
+156 val_156 1
+157 val_157 1
+158 val_158 1
+160 val_160 1
+162 val_162 1
+163 val_163 1
+164 val_164 2
+165 val_165 2
+166 val_166 1
+167 val_167 3
+168 val_168 1
+169 val_169 4
+17 val_17 1
+170 val_170 1
+172 val_172 2
+174 val_174 2
+175 val_175 2
+176 val_176 2
+177 val_177 1
+178 val_178 1
+179 val_179 2
+18 val_18 2
+180 val_180 1
+181 val_181 1
+183 val_183 1
+186 val_186 1
+187 val_187 3
+189 val_189 1
+19 val_19 1
+190 val_190 1
+191 val_191 2
+192 val_192 1
+193 val_193 3
+194 val_194 1
+195 val_195 2
+196 val_196 1
+197 val_197 2
+199 val_199 3
+2 val_2 1
+20 val_20 1
+200 val_200 2
+201 val_201 1
+202 val_202 1
+203 val_203 2
+205 val_205 2
+207 val_207 2
+208 val_208 3
+209 val_209 2
+213 val_213 2
+214 val_214 1
+216 val_216 2
+217 val_217 2
+218 val_218 1
+219 val_219 2
+221 val_221 2
+222 val_222 1
+223 val_223 2
+224 val_224 2
+226 val_226 1
+228 val_228 1
+229 val_229 2
+230 val_230 5
+233 val_233 2
+235 val_235 1
+237 val_237 2
+238 val_238 2
+239 val_239 2
+24 val_24 2
+241 val_241 1
+242 val_242 2
+244 val_244 1
+247 val_247 1
+248 val_248 1
+249 val_249 1
+252 val_252 1
+255 val_255 2
+256 val_256 2
+257 val_257 1
+258 val_258 1
+26 val_26 2
+260 val_260 1
+262 val_262 1
+263 val_263 1
+265 val_265 2
+266 val_266 1
+27 val_27 1
+272 val_272 2
+273 val_273 3
+274 val_274 1
+275 val_275 1
+277 val_277 4
+278 val_278 2
+28 val_28 1
+280 val_280 2
+281 val_281 2
+282 val_282 2
+283 val_283 1
+284 val_284 1
+285 val_285 1
+286 val_286 1
+287 val_287 1
+288 val_288 2
+289 val_289 1
+291 val_291 1
+292 val_292 1
+296 val_296 1
+298 val_298 3
+30 val_30 1
+302 val_302 1
+305 val_305 1
+306 val_306 1
+307 val_307 2
+308 val_308 1
+309 val_309 2
+310 val_310 1
+311 val_311 3
+315 val_315 1
+316 val_316 3
+317 val_317 2
+318 val_318 3
+321 val_321 2
+322 val_322 2
+323 val_323 1
+325 val_325 2
+327 val_327 3
+33 val_33 1
+331 val_331 2
+332 val_332 1
+333 val_333 2
+335 val_335 1
+336 val_336 1
+338 val_338 1
+339 val_339 1
+34 val_34 1
+341 val_341 1
+342 val_342 2
+344 val_344 2
+345 val_345 1
+348 val_348 5
+35 val_35 3
+351 val_351 1
+353 val_353 2
+356 val_356 1
+360 val_360 1
+362 val_362 1
+364 val_364 1
+365 val_365 1
+366 val_366 1
+367 val_367 2
+368 val_368 1
+369 val_369 3
+37 val_37 2
+373 val_373 1
+374 val_374 1
+375 val_375 1
+377 val_377 1
+378 val_378 1
+379 val_379 1
+382 val_382 2
+384 val_384 3
+386 val_386 1
+389 val_389 1
+392 val_392 1
+393 val_393 1
+394 val_394 1
+395 val_395 2
+396 val_396 3
+397 val_397 2
+399 val_399 2
+4 val_4 1
+400 val_400 1
+401 val_401 5
+402 val_402 1
+403 val_403 3
+404 val_404 2
+406 val_406 4
+407 val_407 1
+409 val_409 3
+41 val_41 1
+411 val_411 1
+413 val_413 2
+414 val_414 2
+417 val_417 3
+418 val_418 1
+419 val_419 1
+42 val_42 2
+421 val_421 1
+424 val_424 2
+427 val_427 1
+429 val_429 2
+43 val_43 1
+430 val_430 3
+431 val_431 3
+432 val_432 1
+435 val_435 1
+436 val_436 1
+437 val_437 1
+438 val_438 3
+439 val_439 2
+44 val_44 1
+443 val_443 1
+444 val_444 1
+446 val_446 1
+448 val_448 1
+449 val_449 1
+452 val_452 1
+453 val_453 1
+454 val_454 3
+455 val_455 1
+457 val_457 1
+458 val_458 2
+459 val_459 2
+460 val_460 1
+462 val_462 2
+463 val_463 2
+466 val_466 3
+467 val_467 1
+468 val_468 4
+469 val_469 5
+47 val_47 1
+470 val_470 1
+472 val_472 1
+475 val_475 1
+477 val_477 1
+478 val_478 2
+479 val_479 1
+480 val_480 3
+481 val_481 1
+482 val_482 1
+483 val_483 1
+484 val_484 1
+485 val_485 1
+487 val_487 1
+489 val_489 4
+490 val_490 1
+491 val_491 1
+492 val_492 2
+493 val_493 1
+494 val_494 1
+495 val_495 1
+496 val_496 1
+497 val_497 1
+498 val_498 3
+5 val_5 3
+51 val_51 2
+53 val_53 1
+54 val_54 1
+57 val_57 1
+58 val_58 2
+64 val_64 1
+65 val_65 1
+66 val_66 1
+67 val_67 2
+69 val_69 1
+70 val_70 3
+72 val_72 2
+74 val_74 1
+76 val_76 2
+77 val_77 1
+78 val_78 1
+8 val_8 1
+80 val_80 1
+82 val_82 1
+83 val_83 2
+84 val_84 2
+85 val_85 1
+86 val_86 1
+87 val_87 1
+9 val_9 1
+90 val_90 3
+92 val_92 1
+95 val_95 2
+96 val_96 1
+97 val_97 2
+98 val_98 2
PREHOOK: query: explain
-create table x8 as select * from (select * from src group by key having key < 9) a
+create table x8 as select * from (select *, count(value) from src group by key, value having key < 9) a
PREHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: query: explain
-create table x8 as select * from (select * from src group by key having key < 9) a
+create table x8 as select * from (select *, count(value) from src group by key, value having key < 9) a
POSTHOOK: type: CREATETABLE_AS_SELECT
STAGE DEPENDENCIES:
Stage-1 is a root stage
@@ -1040,28 +1095,31 @@ STAGE PLANS:
predicate: (key < 9) (type: boolean)
Statistics: Num rows: 166 Data size: 1763 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: key (type: string)
- outputColumnNames: key
+ expressions: key (type: string), value (type: string)
+ outputColumnNames: key, value
Statistics: Num rows: 166 Data size: 1763 Basic stats: COMPLETE Column stats: NONE
Group By Operator
- keys: key (type: string)
+ aggregations: count(value)
+ keys: key (type: string), value (type: string)
mode: hash
- outputColumnNames: _col0
+ outputColumnNames: _col0, _col1, _col2
Statistics: Num rows: 166 Data size: 1763 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
- key expressions: _col0 (type: string)
- sort order: +
- Map-reduce partition columns: _col0 (type: string)
+ key expressions: _col0 (type: string), _col1 (type: string)
+ sort order: ++
+ Map-reduce partition columns: _col0 (type: string), _col1 (type: string)
Statistics: Num rows: 166 Data size: 1763 Basic stats: COMPLETE Column stats: NONE
+ value expressions: _col2 (type: bigint)
Reduce Operator Tree:
Group By Operator
- keys: KEY._col0 (type: string)
+ aggregations: count(VALUE._col0)
+ keys: KEY._col0 (type: string), KEY._col1 (type: string)
mode: mergepartial
- outputColumnNames: _col0
+ outputColumnNames: _col0, _col1, _col2
Statistics: Num rows: 83 Data size: 881 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: _col0 (type: string)
- outputColumnNames: _col0
+ expressions: _col0 (type: string), _col1 (type: string), _col2 (type: bigint)
+ outputColumnNames: _col0, _col1, _col2
Statistics: Num rows: 83 Data size: 881 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
@@ -1081,7 +1139,7 @@ STAGE PLANS:
Stage: Stage-3
Create Table Operator:
Create Table
- columns: _col0 string
+ columns: _col0 string, _col1 string, _c1 bigint
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
serde name: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
@@ -1090,12 +1148,12 @@ STAGE PLANS:
Stage: Stage-2
Stats-Aggr Operator
-PREHOOK: query: create table x8 as select * from (select * from src group by key having key < 9) a
+PREHOOK: query: create table x8 as select * from (select *, count(value) from src group by key, value having key < 9) a
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@src
PREHOOK: Output: database:default
PREHOOK: Output: default@x8
-POSTHOOK: query: create table x8 as select * from (select * from src group by key having key < 9) a
+POSTHOOK: query: create table x8 as select * from (select *, count(value) from src group by key, value having key < 9) a
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@src
POSTHOOK: Output: database:default
@@ -1109,6 +1167,8 @@ POSTHOOK: Input: default@x8
# col_name data_type comment
_col0 string
+_col1 string
+_c1 bigint
# Detailed Table Information
Database: default
@@ -1121,8 +1181,8 @@ Table Parameters:
COLUMN_STATS_ACCURATE true
numFiles 1
numRows 5
- rawDataSize 5
- totalSize 10
+ rawDataSize 45
+ totalSize 50
#### A masked pattern was here ####
# Storage Information
@@ -1143,11 +1203,11 @@ POSTHOOK: query: select * from x8
POSTHOOK: type: QUERY
POSTHOOK: Input: default@x8
#### A masked pattern was here ####
-0
-2
-4
-5
-8
+0 val_0 3
+2 val_2 1
+4 val_4 1
+5 val_5 3
+8 val_8 1
PREHOOK: query: explain
create table x9 as select * from (select max(value),key from src group by key having key < 9 AND max(value) IS NOT NULL) a
PREHOOK: type: CREATETABLE_AS_SELECT
Modified: hive/branches/spark/ql/src/test/results/clientpositive/database_drop.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/database_drop.q.out?rev=1640263&r1=1640262&r2=1640263&view=diff
==============================================================================
--- hive/branches/spark/ql/src/test/results/clientpositive/database_drop.q.out (original)
+++ hive/branches/spark/ql/src/test/results/clientpositive/database_drop.q.out Tue Nov 18 00:48:40 2014
@@ -352,6 +352,42 @@ POSTHOOK: type: CREATETABLE
#### A masked pattern was here ####
POSTHOOK: Output: database:db5
POSTHOOK: Output: db5@extab1
+PREHOOK: query: -- add a table, create index (give a name for index table)
+CREATE TABLE temp_tbl3 (id INT, name STRING)
+PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:db5
+PREHOOK: Output: db5@temp_tbl3
+POSTHOOK: query: -- add a table, create index (give a name for index table)
+CREATE TABLE temp_tbl3 (id INT, name STRING)
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:db5
+POSTHOOK: Output: db5@temp_tbl3
+PREHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/kv1.txt' into table temp_tbl3
+PREHOOK: type: LOAD
+#### A masked pattern was here ####
+PREHOOK: Output: db5@temp_tbl3
+POSTHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/kv1.txt' into table temp_tbl3
+POSTHOOK: type: LOAD
+#### A masked pattern was here ####
+POSTHOOK: Output: db5@temp_tbl3
+PREHOOK: query: CREATE INDEX temp_tbl3_idx ON TABLE temp_tbl3(id) AS 'COMPACT' with DEFERRED REBUILD IN TABLE temp_tbl3_idx_tbl
+PREHOOK: type: CREATEINDEX
+PREHOOK: Input: db5@temp_tbl3
+POSTHOOK: query: CREATE INDEX temp_tbl3_idx ON TABLE temp_tbl3(id) AS 'COMPACT' with DEFERRED REBUILD IN TABLE temp_tbl3_idx_tbl
+POSTHOOK: type: CREATEINDEX
+POSTHOOK: Input: db5@temp_tbl3
+POSTHOOK: Output: db5@temp_tbl3_idx_tbl
+PREHOOK: query: ALTER INDEX temp_tbl3_idx ON temp_tbl3 REBUILD
+PREHOOK: type: ALTERINDEX_REBUILD
+PREHOOK: Input: db5@temp_tbl3
+PREHOOK: Output: db5@temp_tbl3_idx_tbl
+POSTHOOK: query: ALTER INDEX temp_tbl3_idx ON temp_tbl3 REBUILD
+POSTHOOK: type: ALTERINDEX_REBUILD
+POSTHOOK: Input: db5@temp_tbl3
+POSTHOOK: Output: db5@temp_tbl3_idx_tbl
+POSTHOOK: Lineage: temp_tbl3_idx_tbl._bucketname SIMPLE [(temp_tbl3)temp_tbl3.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ]
+POSTHOOK: Lineage: temp_tbl3_idx_tbl._offsets EXPRESSION [(temp_tbl3)temp_tbl3.FieldSchema(name:BLOCK__OFFSET__INSIDE__FILE, type:bigint, comment:), ]
+POSTHOOK: Lineage: temp_tbl3_idx_tbl.id SIMPLE [(temp_tbl3)temp_tbl3.FieldSchema(name:id, type:int, comment:null), ]
PREHOOK: query: -- drop the database with cascade
DROP DATABASE db5 CASCADE
PREHOOK: type: DROPDATABASE
@@ -369,6 +405,8 @@ PREHOOK: Output: db5@part_tab3
PREHOOK: Output: db5@temp_tbl
PREHOOK: Output: db5@temp_tbl2
PREHOOK: Output: db5@temp_tbl2_view
+PREHOOK: Output: db5@temp_tbl3
+PREHOOK: Output: db5@temp_tbl3_idx_tbl
PREHOOK: Output: db5@temp_tbl_view
POSTHOOK: query: -- drop the database with cascade
DROP DATABASE db5 CASCADE
@@ -387,5 +425,7 @@ POSTHOOK: Output: db5@part_tab3
POSTHOOK: Output: db5@temp_tbl
POSTHOOK: Output: db5@temp_tbl2
POSTHOOK: Output: db5@temp_tbl2_view
+POSTHOOK: Output: db5@temp_tbl3
+POSTHOOK: Output: db5@temp_tbl3_idx_tbl
POSTHOOK: Output: db5@temp_tbl_view
#### A masked pattern was here ####
Modified: hive/branches/spark/ql/src/test/results/clientpositive/decimal_2.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/decimal_2.q.out?rev=1640263&r1=1640262&r2=1640263&view=diff
==============================================================================
--- hive/branches/spark/ql/src/test/results/clientpositive/decimal_2.q.out (original)
+++ hive/branches/spark/ql/src/test/results/clientpositive/decimal_2.q.out Tue Nov 18 00:48:40 2014
@@ -264,7 +264,7 @@ POSTHOOK: query: select cast(0.999999999
POSTHOOK: type: QUERY
POSTHOOK: Input: default@decimal_2
#### A masked pattern was here ####
-1.0
+1
PREHOOK: query: select cast('0.99999999999999999999' as decimal(20,20)) from decimal_2
PREHOOK: type: QUERY
PREHOOK: Input: default@decimal_2
Modified: hive/branches/spark/ql/src/test/results/clientpositive/decimal_3.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/decimal_3.q.out?rev=1640263&r1=1640262&r2=1640263&view=diff
==============================================================================
--- hive/branches/spark/ql/src/test/results/clientpositive/decimal_3.q.out (original)
+++ hive/branches/spark/ql/src/test/results/clientpositive/decimal_3.q.out Tue Nov 18 00:48:40 2014
@@ -33,7 +33,7 @@ POSTHOOK: type: QUERY
POSTHOOK: Input: default@decimal_3
#### A masked pattern was here ####
NULL 0
--1234567890.1234567890 -1234567890
+-1234567890.123456789 -1234567890
-4400 4400
-1255.49 -1255
-1.122 -11
@@ -42,7 +42,7 @@ NULL 0
-0.333 0
-0.33 0
-0.3 0
-0.000000000000000000 0
+0 0
0 0
0 0
0.01 0
@@ -53,8 +53,8 @@ NULL 0
0.33 0
0.333 0
1 1
-1.0 1
-1.000000000000000000 1
+1 1
+1 1
1.12 1
1.122 1
2 2
@@ -62,14 +62,14 @@ NULL 0
3.14 3
3.14 3
3.14 3
-3.140 4
+3.14 4
10 10
20 20
100 100
-124.00 124
+124 124
125.2 125
200 200
-1234567890.1234567800 1234567890
+1234567890.12345678 1234567890
PREHOOK: query: SELECT * FROM DECIMAL_3 ORDER BY key DESC, value DESC
PREHOOK: type: QUERY
PREHOOK: Input: default@decimal_3
@@ -78,14 +78,14 @@ POSTHOOK: query: SELECT * FROM DECIMAL_3
POSTHOOK: type: QUERY
POSTHOOK: Input: default@decimal_3
#### A masked pattern was here ####
-1234567890.1234567800 1234567890
+1234567890.12345678 1234567890
200 200
125.2 125
-124.00 124
+124 124
100 100
20 20
10 10
-3.140 4
+3.14 4
3.14 3
3.14 3
3.14 3
@@ -93,8 +93,8 @@ POSTHOOK: Input: default@decimal_3
2 2
1.122 1
1.12 1
-1.000000000000000000 1
-1.0 1
+1 1
+1 1
1 1
0.333 0
0.33 0
@@ -105,7 +105,7 @@ POSTHOOK: Input: default@decimal_3
0.01 0
0 0
0 0
-0.000000000000000000 0
+0 0
-0.3 0
-0.33 0
-0.333 0
@@ -114,7 +114,7 @@ POSTHOOK: Input: default@decimal_3
-1.122 -11
-1255.49 -1255
-4400 4400
--1234567890.1234567890 -1234567890
+-1234567890.123456789 -1234567890
NULL 0
PREHOOK: query: SELECT * FROM DECIMAL_3 ORDER BY key, value
PREHOOK: type: QUERY
@@ -125,7 +125,7 @@ POSTHOOK: type: QUERY
POSTHOOK: Input: default@decimal_3
#### A masked pattern was here ####
NULL 0
--1234567890.1234567890 -1234567890
+-1234567890.123456789 -1234567890
-4400 4400
-1255.49 -1255
-1.122 -11
@@ -134,7 +134,7 @@ NULL 0
-0.333 0
-0.33 0
-0.3 0
-0.000000000000000000 0
+0 0
0 0
0 0
0.01 0
@@ -145,8 +145,8 @@ NULL 0
0.33 0
0.333 0
1 1
-1.0 1
-1.000000000000000000 1
+1 1
+1 1
1.12 1
1.122 1
2 2
@@ -154,14 +154,14 @@ NULL 0
3.14 3
3.14 3
3.14 3
-3.140 4
+3.14 4
10 10
20 20
100 100
-124.00 124
+124 124
125.2 125
200 200
-1234567890.1234567800 1234567890
+1234567890.12345678 1234567890
PREHOOK: query: SELECT DISTINCT key FROM DECIMAL_3 ORDER BY key
PREHOOK: type: QUERY
PREHOOK: Input: default@decimal_3
@@ -171,7 +171,7 @@ POSTHOOK: type: QUERY
POSTHOOK: Input: default@decimal_3
#### A masked pattern was here ####
NULL
--1234567890.1234567890
+-1234567890.123456789
-4400
-1255.49
-1.122
@@ -179,7 +179,7 @@ NULL
-0.333
-0.33
-0.3
-0.000000000000000000
+0
0.01
0.02
0.1
@@ -195,10 +195,10 @@ NULL
10
20
100
-124.00
+124
125.2
200
-1234567890.1234567800
+1234567890.12345678
PREHOOK: query: SELECT key, sum(value) FROM DECIMAL_3 GROUP BY key ORDER BY key
PREHOOK: type: QUERY
PREHOOK: Input: default@decimal_3
@@ -208,7 +208,7 @@ POSTHOOK: type: QUERY
POSTHOOK: Input: default@decimal_3
#### A masked pattern was here ####
NULL 0
--1234567890.1234567890 -1234567890
+-1234567890.123456789 -1234567890
-4400 4400
-1255.49 -1255
-1.122 -11
@@ -216,7 +216,7 @@ NULL 0
-0.333 0
-0.33 0
-0.3 0
-0.000000000000000000 0
+0 0
0.01 0
0.02 0
0.1 0
@@ -232,10 +232,10 @@ NULL 0
10 10
20 20
100 100
-124.00 124
+124 124
125.2 125
200 200
-1234567890.1234567800 1234567890
+1234567890.12345678 1234567890
PREHOOK: query: SELECT value, sum(key) FROM DECIMAL_3 GROUP BY value ORDER BY value
PREHOOK: type: QUERY
PREHOOK: Input: default@decimal_3
@@ -244,23 +244,23 @@ POSTHOOK: query: SELECT value, sum(key)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@decimal_3
#### A masked pattern was here ####
--1234567890 -1234567890.1234567890
+-1234567890 -1234567890.123456789
-1255 -1255.49
-11 -1.122
-1 -2.24
-0 0.330000000000000000
-1 5.242000000000000000
+0 0.33
+1 5.242
2 4
3 9.42
-4 3.140
+4 3.14
10 10
20 20
100 100
-124 124.00
+124 124
125 125.2
200 200
4400 -4400
-1234567890 1234567890.1234567800
+1234567890 1234567890.12345678
PREHOOK: query: SELECT * FROM DECIMAL_3 a JOIN DECIMAL_3 b ON (a.key = b.key) ORDER BY a.key, a.value, b.value
PREHOOK: type: QUERY
PREHOOK: Input: default@decimal_3
@@ -269,7 +269,7 @@ POSTHOOK: query: SELECT * FROM DECIMAL_3
POSTHOOK: type: QUERY
POSTHOOK: Input: default@decimal_3
#### A masked pattern was here ####
--1234567890.1234567890 -1234567890 -1234567890.1234567890 -1234567890
+-1234567890.123456789 -1234567890 -1234567890.123456789 -1234567890
-4400 4400 -4400 4400
-1255.49 -1255 -1255.49 -1255
-1.122 -11 -1.122 -11
@@ -280,7 +280,11 @@ POSTHOOK: Input: default@decimal_3
-0.333 0 -0.333 0
-0.33 0 -0.33 0
-0.3 0 -0.3 0
-0.000000000000000000 0 0.000000000000000000 0
+0 0 0 0
+0 0 0 0
+0 0 0 0
+0 0 0 0
+0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
@@ -293,8 +297,14 @@ POSTHOOK: Input: default@decimal_3
0.33 0 0.33 0
0.333 0 0.333 0
1 1 1 1
-1.0 1 1.0 1
-1.000000000000000000 1 1.000000000000000000 1
+1 1 1 1
+1 1 1 1
+1 1 1 1
+1 1 1 1
+1 1 1 1
+1 1 1 1
+1 1 1 1
+1 1 1 1
1.12 1 1.12 1
1.122 1 1.122 1
2 2 2 2
@@ -310,14 +320,20 @@ POSTHOOK: Input: default@decimal_3
3.14 3 3.14 3
3.14 3 3.14 3
3.14 3 3.14 3
-3.140 4 3.140 4
+3.14 3 3.14 4
+3.14 3 3.14 4
+3.14 3 3.14 4
+3.14 4 3.14 3
+3.14 4 3.14 3
+3.14 4 3.14 3
+3.14 4 3.14 4
10 10 10 10
20 20 20 20
100 100 100 100
-124.00 124 124.00 124
+124 124 124 124
125.2 125 125.2 125
200 200 200 200
-1234567890.1234567800 1234567890 1234567890.1234567800 1234567890
+1234567890.12345678 1234567890 1234567890.12345678 1234567890
PREHOOK: query: SELECT * FROM DECIMAL_3 WHERE key=3.14 ORDER BY key, value
PREHOOK: type: QUERY
PREHOOK: Input: default@decimal_3
@@ -329,7 +345,7 @@ POSTHOOK: Input: default@decimal_3
3.14 3
3.14 3
3.14 3
-3.140 4
+3.14 4
PREHOOK: query: SELECT * FROM DECIMAL_3 WHERE key=3.140 ORDER BY key, value
PREHOOK: type: QUERY
PREHOOK: Input: default@decimal_3
@@ -341,7 +357,7 @@ POSTHOOK: Input: default@decimal_3
3.14 3
3.14 3
3.14 3
-3.140 4
+3.14 4
PREHOOK: query: DROP TABLE DECIMAL_3
PREHOOK: type: DROPTABLE
PREHOOK: Input: default@decimal_3
Modified: hive/branches/spark/ql/src/test/results/clientpositive/decimal_4.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/decimal_4.q.out?rev=1640263&r1=1640262&r2=1640263&view=diff
==============================================================================
--- hive/branches/spark/ql/src/test/results/clientpositive/decimal_4.q.out (original)
+++ hive/branches/spark/ql/src/test/results/clientpositive/decimal_4.q.out Tue Nov 18 00:48:40 2014
@@ -57,7 +57,7 @@ POSTHOOK: type: QUERY
POSTHOOK: Input: default@decimal_4_1
#### A masked pattern was here ####
NULL 0
--1234567890.1234567890 -1234567890
+-1234567890.123456789 -1234567890
-4400 4400
-1255.49 -1255
-1.122 -11
@@ -66,7 +66,7 @@ NULL 0
-0.333 0
-0.33 0
-0.3 0
-0.0000000000000000000000000 0
+0 0
0 0
0 0
0.01 0
@@ -78,7 +78,7 @@ NULL 0
0.333 0
0.9999999999999999999999999 1
1 1
-1.0 1
+1 1
1.12 1
1.122 1
2 2
@@ -86,14 +86,14 @@ NULL 0
3.14 3
3.14 3
3.14 3
-3.140 4
+3.14 4
10 10
20 20
100 100
-124.00 124
+124 124
125.2 125
200 200
-1234567890.1234567800 1234567890
+1234567890.12345678 1234567890
PREHOOK: query: SELECT * FROM DECIMAL_4_2 ORDER BY key
PREHOOK: type: QUERY
PREHOOK: Input: default@decimal_4_2
@@ -103,7 +103,7 @@ POSTHOOK: type: QUERY
POSTHOOK: Input: default@decimal_4_2
#### A masked pattern was here ####
NULL NULL
--1234567890.1234567890 -3703703670.3703703670
+-1234567890.123456789 -3703703670.370370367
-4400 -13200
-1255.49 -3766.47
-1.122 -3.366
@@ -112,7 +112,7 @@ NULL NULL
-0.333 -0.999
-0.33 -0.99
-0.3 -0.9
-0.0000000000000000000000000 0.0000000000000000000000000
+0 0
0 0
0 0
0.01 0.03
@@ -124,7 +124,7 @@ NULL NULL
0.333 0.999
0.9999999999999999999999999 2.9999999999999999999999997
1 3
-1.0 3.0
+1 3
1.12 3.36
1.122 3.366
2 6
@@ -132,14 +132,14 @@ NULL NULL
3.14 9.42
3.14 9.42
3.14 9.42
-3.140 9.420
+3.14 9.42
10 30
20 60
100 300
-124.00 372.00
+124 372
125.2 375.6
200 600
-1234567890.1234567800 3703703670.3703703400
+1234567890.12345678 3703703670.37037034
PREHOOK: query: DROP TABLE DECIMAL_4_1
PREHOOK: type: DROPTABLE
PREHOOK: Input: default@decimal_4_1
Modified: hive/branches/spark/ql/src/test/results/clientpositive/decimal_5.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/decimal_5.q.out?rev=1640263&r1=1640262&r2=1640263&view=diff
==============================================================================
--- hive/branches/spark/ql/src/test/results/clientpositive/decimal_5.q.out (original)
+++ hive/branches/spark/ql/src/test/results/clientpositive/decimal_5.q.out Tue Nov 18 00:48:40 2014
@@ -43,7 +43,7 @@ NULL
-0.333
-0.33
-0.3
-0.00000
+0
0
0
0.01
@@ -54,8 +54,8 @@ NULL
0.33
0.333
1
-1.0
-1.00000
+1
+1
1.12
1.122
2
@@ -63,11 +63,11 @@ NULL
3.14
3.14
3.14
-3.140
+3.14
10
20
100
-124.00
+124
125.2
200
PREHOOK: query: SELECT DISTINCT key FROM DECIMAL_5 ORDER BY key
@@ -86,7 +86,7 @@ NULL
-0.333
-0.33
-0.3
-0.00000
+0
0.01
0.02
0.1
@@ -102,7 +102,7 @@ NULL
10
20
100
-124.00
+124
125.2
200
PREHOOK: query: SELECT cast(key as decimal) FROM DECIMAL_5
@@ -161,7 +161,7 @@ POSTHOOK: Input: default@decimal_5
#### A masked pattern was here ####
NULL
NULL
-0.000
+0
0
100
10
@@ -180,7 +180,7 @@ NULL
-0.3
-0.33
-0.333
-1.0
+1
2
3.14
-1.12
@@ -188,13 +188,13 @@ NULL
-1.122
1.12
1.122
-124.00
+124
125.2
NULL
3.14
3.14
-3.140
-1.000
+3.14
+1
NULL
NULL
PREHOOK: query: DROP TABLE DECIMAL_5
Modified: hive/branches/spark/ql/src/test/results/clientpositive/decimal_6.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/decimal_6.q.out?rev=1640263&r1=1640262&r2=1640263&view=diff
==============================================================================
--- hive/branches/spark/ql/src/test/results/clientpositive/decimal_6.q.out (original)
+++ hive/branches/spark/ql/src/test/results/clientpositive/decimal_6.q.out Tue Nov 18 00:48:40 2014
@@ -91,16 +91,16 @@ NULL
-0.333
-0.3
-0.3
-0.00000
-0.0000
+0
+0
0
0
0.333
0.333
-1.0
-1.0
-1.0000
-1.00000
+1
+1
+1
+1
1.12
1.12
1.122
@@ -111,14 +111,14 @@ NULL
3.14
3.14
3.14
-3.140
-3.140
+3.14
+3.14
10
10
10.7343
10.73433
-124.00
-124.00
+124
+124
125.2
125.2
23232.23435
Modified: hive/branches/spark/ql/src/test/results/clientpositive/decimal_precision.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/decimal_precision.q.out?rev=1640263&r1=1640262&r2=1640263&view=diff
==============================================================================
--- hive/branches/spark/ql/src/test/results/clientpositive/decimal_precision.q.out (original)
+++ hive/branches/spark/ql/src/test/results/clientpositive/decimal_precision.q.out Tue Nov 18 00:48:40 2014
@@ -76,13 +76,13 @@ NULL
NULL
NULL
NULL
-0.0000000000
-0.0000000000
-0.0000000000
-0.0000000000
0
-0.1234567890
-0.1234567890
+0
+0
+0
+0
+0.123456789
+0.123456789
1.2345678901
1.2345678901
1.2345678901
@@ -106,7 +106,7 @@ NULL
123456789.0123456
123456789.0123456789
1234567890.123456
-1234567890.1234567890
+1234567890.123456789
PREHOOK: query: SELECT dec, dec + 1, dec - 1 FROM DECIMAL_PRECISION ORDER BY dec
PREHOOK: type: QUERY
PREHOOK: Input: default@decimal_precision
@@ -159,13 +159,13 @@ NULL NULL NULL
NULL NULL NULL
NULL NULL NULL
NULL NULL NULL
-0.0000000000 1.0000000000 -1.0000000000
-0.0000000000 1.0000000000 -1.0000000000
-0.0000000000 1.0000000000 -1.0000000000
-0.0000000000 1.0000000000 -1.0000000000
0 1 -1
-0.1234567890 1.1234567890 -0.8765432110
-0.1234567890 1.1234567890 -0.8765432110
+0 1 -1
+0 1 -1
+0 1 -1
+0 1 -1
+0.123456789 1.123456789 -0.876543211
+0.123456789 1.123456789 -0.876543211
1.2345678901 2.2345678901 0.2345678901
1.2345678901 2.2345678901 0.2345678901
1.2345678901 2.2345678901 0.2345678901
@@ -189,7 +189,7 @@ NULL NULL NULL
123456789.0123456 123456790.0123456 123456788.0123456
123456789.0123456789 123456790.0123456789 123456788.0123456789
1234567890.123456 1234567891.123456 1234567889.123456
-1234567890.1234567890 1234567891.1234567890 1234567889.1234567890
+1234567890.123456789 1234567891.123456789 1234567889.123456789
PREHOOK: query: SELECT dec, dec * 2, dec / 3 FROM DECIMAL_PRECISION ORDER BY dec
PREHOOK: type: QUERY
PREHOOK: Input: default@decimal_precision
@@ -242,13 +242,13 @@ NULL NULL NULL
NULL NULL NULL
NULL NULL NULL
NULL NULL NULL
-0.0000000000 0.0000000000 0
-0.0000000000 0.0000000000 0
-0.0000000000 0.0000000000 0
-0.0000000000 0.0000000000 0
0 0 0
-0.1234567890 0.2469135780 0.041152263
-0.1234567890 0.2469135780 0.041152263
+0 0 0
+0 0 0
+0 0 0
+0 0 0
+0.123456789 0.246913578 0.041152263
+0.123456789 0.246913578 0.041152263
1.2345678901 2.4691357802 0.411522630033
1.2345678901 2.4691357802 0.411522630033
1.2345678901 2.4691357802 0.411522630033
@@ -258,9 +258,9 @@ NULL NULL NULL
123.4567890123 246.9135780246 41.1522630041
123.4567890123 246.9135780246 41.1522630041
123.4567890123 246.9135780246 41.1522630041
-1234.5678901235 2469.1357802470 411.522630041167
-1234.5678901235 2469.1357802470 411.522630041167
-1234.5678901235 2469.1357802470 411.522630041167
+1234.5678901235 2469.135780247 411.522630041167
+1234.5678901235 2469.135780247 411.522630041167
+1234.5678901235 2469.135780247 411.522630041167
12345.6789012346 24691.3578024692 4115.226300411533
12345.6789012346 24691.3578024692 4115.226300411533
123456.7890123456 246913.5780246912 41152.2630041152
@@ -272,7 +272,7 @@ NULL NULL NULL
123456789.0123456 246913578.0246912 41152263.0041152
123456789.0123456789 246913578.0246913578 41152263.0041152263
1234567890.123456 2469135780.246912 411522630.041152
-1234567890.1234567890 2469135780.2469135780 411522630.041152263
+1234567890.123456789 2469135780.246913578 411522630.041152263
PREHOOK: query: SELECT dec, dec / 9 FROM DECIMAL_PRECISION ORDER BY dec
PREHOOK: type: QUERY
PREHOOK: Input: default@decimal_precision
@@ -325,13 +325,13 @@ NULL NULL
NULL NULL
NULL NULL
NULL NULL
-0.0000000000 0
-0.0000000000 0
-0.0000000000 0
-0.0000000000 0
0 0
-0.1234567890 0.013717421
-0.1234567890 0.013717421
+0 0
+0 0
+0 0
+0 0
+0.123456789 0.013717421
+0.123456789 0.013717421
1.2345678901 0.137174210011
1.2345678901 0.137174210011
1.2345678901 0.137174210011
@@ -355,7 +355,7 @@ NULL NULL
123456789.0123456 13717421.001371733333
123456789.0123456789 13717421.0013717421
1234567890.123456 137174210.013717333333
-1234567890.1234567890 137174210.013717421
+1234567890.123456789 137174210.013717421
PREHOOK: query: SELECT dec, dec / 27 FROM DECIMAL_PRECISION ORDER BY dec
PREHOOK: type: QUERY
PREHOOK: Input: default@decimal_precision
@@ -408,13 +408,13 @@ NULL NULL
NULL NULL
NULL NULL
NULL NULL
-0.0000000000 0
-0.0000000000 0
-0.0000000000 0
-0.0000000000 0
0 0
-0.1234567890 0.0045724736667
-0.1234567890 0.0045724736667
+0 0
+0 0
+0 0
+0 0
+0.123456789 0.0045724736667
+0.123456789 0.0045724736667
1.2345678901 0.0457247366704
1.2345678901 0.0457247366704
1.2345678901 0.0457247366704
@@ -438,7 +438,7 @@ NULL NULL
123456789.0123456 4572473.6671239111111
123456789.0123456789 4572473.6671239140333
1234567890.123456 45724736.6712391111111
-1234567890.1234567890 45724736.6712391403333
+1234567890.123456789 45724736.6712391403333
PREHOOK: query: SELECT dec, dec * dec FROM DECIMAL_PRECISION ORDER BY dec
PREHOOK: type: QUERY
PREHOOK: Input: default@decimal_precision
@@ -491,13 +491,13 @@ NULL NULL
NULL NULL
NULL NULL
NULL NULL
-0.0000000000 0.00000000000000000000
-0.0000000000 0.00000000000000000000
-0.0000000000 0.00000000000000000000
-0.0000000000 0.00000000000000000000
0 0
-0.1234567890 0.01524157875019052100
-0.1234567890 0.01524157875019052100
+0 0
+0 0
+0 0
+0 0
+0.123456789 0.015241578750190521
+0.123456789 0.015241578750190521
1.2345678901 1.52415787526596567801
1.2345678901 1.52415787526596567801
1.2345678901 1.52415787526596567801
@@ -521,7 +521,7 @@ NULL NULL
123456789.0123456 15241578753238817.26870921383936
123456789.0123456789 15241578753238836.75019051998750190521
1234567890.123456 NULL
-1234567890.1234567890 NULL
+1234567890.123456789 NULL
PREHOOK: query: EXPLAIN SELECT avg(dec), sum(dec) FROM DECIMAL_PRECISION
PREHOOK: type: QUERY
POSTHOOK: query: EXPLAIN SELECT avg(dec), sum(dec) FROM DECIMAL_PRECISION
Modified: hive/branches/spark/ql/src/test/results/clientpositive/decimal_trailing.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/decimal_trailing.q.out?rev=1640263&r1=1640262&r2=1640263&view=diff
==============================================================================
--- hive/branches/spark/ql/src/test/results/clientpositive/decimal_trailing.q.out (original)
+++ hive/branches/spark/ql/src/test/results/clientpositive/decimal_trailing.q.out Tue Nov 18 00:48:40 2014
@@ -43,13 +43,13 @@ POSTHOOK: Input: default@decimal_trailin
0 0 0
1 0 0
2 NULL NULL
-3 1.0000 1.00000000
-4 10.0000 10.00000000
-5 100.0000 100.00000000
-6 1000.0000 1000.00000000
-7 10000.0000 10000.00000000
-8 100000.0000 100000.00000000
-9 NULL 1000000.00000000
+3 1 1
+4 10 10
+5 100 100
+6 1000 1000
+7 10000 10000
+8 100000 100000
+9 NULL 1000000
10 NULL NULL
11 NULL NULL
12 NULL NULL
@@ -58,18 +58,18 @@ POSTHOOK: Input: default@decimal_trailin
15 NULL NULL
16 NULL NULL
17 NULL NULL
-18 1.0000 1.00000000
-19 10.000 10.0000000
-20 100.00 100.000000
-21 1000.0 1000.00000
-22 100000 10000.0000
-23 0.0000 0.00000000
-24 0.000 0.0000000
-25 0.00 0.000000
-26 0.0 0.00000
-27 0 0.00000
-28 12313.2000 134134.31252500
-29 99999.9990 134134.31242553
+18 1 1
+19 10 10
+20 100 100
+21 1000 1000
+22 100000 10000
+23 0 0
+24 0 0
+25 0 0
+26 0 0
+27 0 0
+28 12313.2 134134.312525
+29 99999.999 134134.31242553
PREHOOK: query: DROP TABLE DECIMAL_TRAILING
PREHOOK: type: DROPTABLE
PREHOOK: Input: default@decimal_trailing
Modified: hive/branches/spark/ql/src/test/results/clientpositive/decimal_udf.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/decimal_udf.q.out?rev=1640263&r1=1640262&r2=1640263&view=diff
==============================================================================
--- hive/branches/spark/ql/src/test/results/clientpositive/decimal_udf.q.out (original)
+++ hive/branches/spark/ql/src/test/results/clientpositive/decimal_udf.q.out Tue Nov 18 00:48:40 2014
@@ -57,7 +57,7 @@ POSTHOOK: Input: default@decimal_udf
#### A masked pattern was here ####
-8800
NULL
-0.0000000000
+0
0
200
20
@@ -76,7 +76,7 @@ NULL
-0.6
-0.66
-0.666
-2.0
+2
4
6.28
-2.24
@@ -84,15 +84,15 @@ NULL
-2.244
2.24
2.244
-248.00
+248
250.4
-2510.98
6.28
6.28
-6.280
-2.0000000000
--2469135780.2469135780
-2469135780.2469135600
+6.28
+2
+-2469135780.246913578
+2469135780.24691356
PREHOOK: query: EXPLAIN SELECT key + value FROM DECIMAL_UDF
PREHOOK: type: QUERY
POSTHOOK: query: EXPLAIN SELECT key + value FROM DECIMAL_UDF
@@ -124,7 +124,7 @@ POSTHOOK: Input: default@decimal_udf
#### A masked pattern was here ####
0
NULL
-0.0000000000
+0
0
200
20
@@ -143,7 +143,7 @@ NULL
-0.3
-0.33
-0.333
-2.0
+2
4
6.14
-2.12
@@ -151,15 +151,15 @@ NULL
-12.122
2.12
2.122
-248.00
+248
250.2
-2510.49
6.14
6.14
-7.140
-2.0000000000
--2469135780.1234567890
-2469135780.1234567800
+7.14
+2
+-2469135780.123456789
+2469135780.12345678
PREHOOK: query: EXPLAIN SELECT key + (value/2) FROM DECIMAL_UDF
PREHOOK: type: QUERY
POSTHOOK: query: EXPLAIN SELECT key + (value/2) FROM DECIMAL_UDF
@@ -327,42 +327,42 @@ POSTHOOK: Input: default@decimal_udf
#### A masked pattern was here ####
0
NULL
-0.0000000000
0
0
0
0
-0.0
-0.00
0
0
0
0
-0.0
-0.00
-0.0
-0.00
-0.000
-0.0
-0.00
-0.000
-0.0
0
-0.00
-0.00
-0.00
-0.000
-0.00
-0.000
-0.00
-0.0
-0.00
-0.00
-0.00
-0.000
-0.0000000000
-0.0000000000
-0.0000000000
+0
+0
+0
+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: EXPLAIN SELECT key - value FROM DECIMAL_UDF
PREHOOK: type: QUERY
POSTHOOK: query: EXPLAIN SELECT key - value FROM DECIMAL_UDF
@@ -394,7 +394,7 @@ POSTHOOK: Input: default@decimal_udf
#### A masked pattern was here ####
-8800
NULL
-0.0000000000
+0
0
0
0
@@ -413,7 +413,7 @@ NULL
-0.3
-0.33
-0.333
-0.0
+0
0
0.14
-0.12
@@ -421,15 +421,15 @@ NULL
9.878
0.12
0.122
-0.00
+0
0.2
-0.49
0.14
0.14
--0.860
-0.0000000000
--0.1234567890
-0.1234567800
+-0.86
+0
+-0.123456789
+0.12345678
PREHOOK: query: EXPLAIN SELECT key - (value/2) FROM DECIMAL_UDF
PREHOOK: type: QUERY
POSTHOOK: query: EXPLAIN SELECT key - (value/2) FROM DECIMAL_UDF
@@ -597,7 +597,7 @@ POSTHOOK: Input: default@decimal_udf
#### A masked pattern was here ####
19360000
NULL
-0.00000000000000000000
+0
0
10000
100
@@ -616,7 +616,7 @@ NULL
0.09
0.1089
0.110889
-1.00
+1
4
9.8596
1.2544
@@ -624,13 +624,13 @@ NULL
1.258884
1.2544
1.258884
-15376.0000
+15376
15675.04
1576255.1401
9.8596
9.8596
-9.859600
-1.00000000000000000000
+9.8596
+1
NULL
NULL
PREHOOK: query: EXPLAIN SELECT key, value FROM DECIMAL_UDF where key * value > 0
@@ -671,7 +671,7 @@ POSTHOOK: Input: default@decimal_udf
200 200
20 20
2 2
-1.0 1
+1 1
2 2
3.14 3
-1.12 -1
@@ -679,15 +679,15 @@ POSTHOOK: Input: default@decimal_udf
-1.122 -11
1.12 1
1.122 1
-124.00 124
+124 124
125.2 125
-1255.49 -1255
3.14 3
3.14 3
-3.140 4
-1.0000000000 1
--1234567890.1234567890 -1234567890
-1234567890.1234567800 1234567890
+3.14 4
+1 1
+-1234567890.123456789 -1234567890
+1234567890.12345678 1234567890
PREHOOK: query: EXPLAIN SELECT key * value FROM DECIMAL_UDF
PREHOOK: type: QUERY
POSTHOOK: query: EXPLAIN SELECT key * value FROM DECIMAL_UDF
@@ -719,26 +719,26 @@ POSTHOOK: Input: default@decimal_udf
#### A masked pattern was here ####
-19360000
NULL
-0.0000000000
+0
0
10000
100
1
-0.0
-0.00
+0
+0
40000
400
4
0
-0.0
-0.00
-0.0
-0.00
-0.000
-0.0
-0.00
-0.000
-1.0
+0
+0
+0
+0
+0
+0
+0
+0
+1
4
9.42
1.12
@@ -746,15 +746,15 @@ NULL
12.342
1.12
1.122
-15376.00
-15650.0
+15376
+15650
1575639.95
9.42
9.42
-12.560
-1.0000000000
-1524157875171467887.5019052100
-1524157875171467876.3907942000
+12.56
+1
+1524157875171467887.50190521
+1524157875171467876.3907942
PREHOOK: query: EXPLAIN SELECT key * (value/2) FROM DECIMAL_UDF
PREHOOK: type: QUERY
POSTHOOK: query: EXPLAIN SELECT key * (value/2) FROM DECIMAL_UDF
@@ -1078,7 +1078,7 @@ POSTHOOK: Input: default@decimal_udf
0.785
1
1.0000000001
-1.000000000099999992710
+1.00000000009999999271
PREHOOK: query: EXPLAIN SELECT key / (value/2) FROM DECIMAL_UDF WHERE value is not null and value <> 0
PREHOOK: type: QUERY
POSTHOOK: query: EXPLAIN SELECT key / (value/2) FROM DECIMAL_UDF WHERE value is not null and value <> 0
@@ -1235,7 +1235,7 @@ POSTHOOK: Input: default@decimal_udf
#### A masked pattern was here ####
4400
NULL
-0.0000000000
+0
0
100
10
@@ -1254,7 +1254,7 @@ NULL
0.3
0.33
0.333
-1.0
+1
2
3.14
1.12
@@ -1262,15 +1262,15 @@ NULL
1.122
1.12
1.122
-124.00
+124
125.2
1255.49
3.14
3.14
-3.140
-1.0000000000
-1234567890.1234567890
-1234567890.1234567800
+3.14
+1
+1234567890.123456789
+1234567890.12345678
PREHOOK: query: -- avg
EXPLAIN SELECT value, sum(key) / count(key), avg(key), sum(key) FROM DECIMAL_UDF GROUP BY value ORDER BY value
PREHOOK: type: QUERY
@@ -1359,23 +1359,23 @@ POSTHOOK: query: SELECT value, sum(key)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@decimal_udf
#### A masked pattern was here ####
--1234567890 -1234567890.123456789 -1234567890.123456789 -1234567890.1234567890
+-1234567890 -1234567890.123456789 -1234567890.123456789 -1234567890.123456789
-1255 -1255.49 -1255.49 -1255.49
-11 -1.122 -1.122 -1.122
-1 -1.12 -1.12 -2.24
-0 0.02538461538461538461538 0.02538461538462 0.3300000000
-1 1.0484 1.0484 5.2420000000
+0 0.02538461538461538461538 0.02538461538462 0.33
+1 1.0484 1.0484 5.242
2 2 2 4
3 3.14 3.14 9.42
-4 3.14 3.14 3.140
+4 3.14 3.14 3.14
10 10 10 10
20 20 20 20
100 100 100 100
-124 124 124 124.00
+124 124 124 124
125 125.2 125.2 125.2
200 200 200 200
4400 -4400 -4400 -4400
-1234567890 1234567890.12345678 1234567890.12345678 1234567890.1234567800
+1234567890 1234567890.12345678 1234567890.12345678 1234567890.12345678
PREHOOK: query: -- negative
EXPLAIN SELECT -key FROM DECIMAL_UDF
PREHOOK: type: QUERY
@@ -1409,7 +1409,7 @@ POSTHOOK: Input: default@decimal_udf
#### A masked pattern was here ####
4400
NULL
-0.0000000000
+0
0
-100
-10
@@ -1428,7 +1428,7 @@ NULL
0.3
0.33
0.333
--1.0
+-1
-2
-3.14
1.12
@@ -1436,15 +1436,15 @@ NULL
1.122
-1.12
-1.122
--124.00
+-124
-125.2
1255.49
-3.14
-3.14
--3.140
--1.0000000000
-1234567890.1234567890
--1234567890.1234567800
+-3.14
+-1
+1234567890.123456789
+-1234567890.12345678
PREHOOK: query: -- positive
EXPLAIN SELECT +key FROM DECIMAL_UDF
PREHOOK: type: QUERY
@@ -1478,7 +1478,7 @@ POSTHOOK: Input: default@decimal_udf
#### A masked pattern was here ####
-4400
NULL
-0.0000000000
+0
0
100
10
@@ -1497,7 +1497,7 @@ NULL
-0.3
-0.33
-0.333
-1.0
+1
2
3.14
-1.12
@@ -1505,15 +1505,15 @@ NULL
-1.122
1.12
1.122
-124.00
+124
125.2
-1255.49
3.14
3.14
-3.140
-1.0000000000
--1234567890.1234567890
-1234567890.1234567800
+3.14
+1
+-1234567890.123456789
+1234567890.12345678
PREHOOK: query: -- ceiling
EXPlAIN SELECT CEIL(key) FROM DECIMAL_UDF
PREHOOK: type: QUERY
@@ -1683,42 +1683,42 @@ POSTHOOK: query: SELECT ROUND(key, 2) FR
POSTHOOK: type: QUERY
POSTHOOK: Input: default@decimal_udf
#### A masked pattern was here ####
--4400.00
+-4400
NULL
-0.00
-0.00
-100.00
-10.00
-1.00
-0.10
+0
+0
+100
+10
+1
+0.1
0.01
-200.00
-20.00
-2.00
-0.00
-0.20
+200
+20
+2
+0
+0.2
0.02
-0.30
+0.3
0.33
0.33
--0.30
+-0.3
-0.33
-0.33
-1.00
-2.00
+1
+2
3.14
-1.12
-1.12
-1.12
1.12
1.12
-124.00
-125.20
+124
+125.2
-1255.49
3.14
3.14
3.14
-1.00
+1
-1234567890.12
1234567890.12
PREHOOK: query: -- power
@@ -1827,38 +1827,38 @@ NULL
NULL
1
1
-0.0
-0.00
-0.000
+0
+0
+0
1
1
0
NULL
-0.0
-0.00
-0.10
-0.010
-0.0010
-0.10
-0.010
-0.0010
-0.0
0
-1.00
+0
+0.1
+0.01
+0.001
+0.1
+0.01
+0.001
+0
+0
+1
-0.12
-0.12
-0.122
0.44
0.439
-1.00
-1.0
+1
+1
-626.745
-1.00
-1.00
-1.000
-0.0000000000
+1
+1
+1
+0
-617283944.0617283945
-1.0000000000
+1
PREHOOK: query: -- stddev, var
EXPLAIN SELECT value, stddev(key), variance(key) FROM DECIMAL_UDF GROUP BY value
PREHOOK: type: QUERY
@@ -2150,7 +2150,7 @@ POSTHOOK: query: SELECT MIN(key) FROM DE
POSTHOOK: type: QUERY
POSTHOOK: Input: default@decimal_udf
#### A masked pattern was here ####
--1234567890.1234567890
+-1234567890.123456789
PREHOOK: query: -- max
EXPLAIN SELECT MAX(key) FROM DECIMAL_UDF
PREHOOK: type: QUERY
@@ -2213,7 +2213,7 @@ POSTHOOK: query: SELECT MAX(key) FROM DE
POSTHOOK: type: QUERY
POSTHOOK: Input: default@decimal_udf
#### A masked pattern was here ####
-1234567890.1234567800
+1234567890.12345678
PREHOOK: query: -- count
EXPLAIN SELECT COUNT(key) FROM DECIMAL_UDF
PREHOOK: type: QUERY
Modified: hive/branches/spark/ql/src/test/results/clientpositive/dynpart_sort_opt_vectorization.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/dynpart_sort_opt_vectorization.q.out?rev=1640263&r1=1640262&r2=1640263&view=diff
==============================================================================
--- hive/branches/spark/ql/src/test/results/clientpositive/dynpart_sort_opt_vectorization.q.out (original)
+++ hive/branches/spark/ql/src/test/results/clientpositive/dynpart_sort_opt_vectorization.q.out Tue Nov 18 00:48:40 2014
@@ -880,7 +880,7 @@ Partition Parameters:
numFiles 2
numRows 32
rawDataSize 640
- totalSize 1348
+ totalSize 1352
#### A masked pattern was here ####
# Storage Information
@@ -924,7 +924,7 @@ Partition Parameters:
numFiles 2
numRows 6
rawDataSize 120
- totalSize 1050
+ totalSize 1054
#### A masked pattern was here ####
# Storage Information
@@ -968,7 +968,7 @@ Partition Parameters:
numFiles 2
numRows 14
rawDataSize 280
- totalSize 1166
+ totalSize 1170
#### A masked pattern was here ####
# Storage Information
@@ -1012,7 +1012,7 @@ Partition Parameters:
numFiles 2
numRows 6
rawDataSize 120
- totalSize 1050
+ totalSize 1054
#### A masked pattern was here ####
# Storage Information
@@ -1055,7 +1055,7 @@ Partition Parameters:
numFiles 8
numRows 32
rawDataSize 640
- totalSize 4340
+ totalSize 4356
#### A masked pattern was here ####
# Storage Information
@@ -1098,7 +1098,7 @@ Partition Parameters:
numFiles 8
numRows 6
rawDataSize 120
- totalSize 2094
+ totalSize 2110
#### A masked pattern was here ####
# Storage Information
@@ -1141,7 +1141,7 @@ Partition Parameters:
numFiles 8
numRows 32
rawDataSize 640
- totalSize 4326
+ totalSize 4342
#### A masked pattern was here ####
# Storage Information
@@ -1184,7 +1184,7 @@ Partition Parameters:
numFiles 8
numRows 6
rawDataSize 120
- totalSize 2094
+ totalSize 2110
#### A masked pattern was here ####
# Storage Information
Modified: hive/branches/spark/ql/src/test/results/clientpositive/dynpart_sort_optimization2.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/dynpart_sort_optimization2.q.out?rev=1640263&r1=1640262&r2=1640263&view=diff
==============================================================================
--- hive/branches/spark/ql/src/test/results/clientpositive/dynpart_sort_optimization2.q.out (original)
+++ hive/branches/spark/ql/src/test/results/clientpositive/dynpart_sort_optimization2.q.out Tue Nov 18 00:48:40 2014
@@ -1183,7 +1183,7 @@ Partition Parameters:
numFiles 1
numRows 11
rawDataSize 88
- totalSize 417
+ totalSize 419
#### A masked pattern was here ####
# Storage Information
@@ -1245,7 +1245,7 @@ Partition Parameters:
numFiles 1
numRows 13
rawDataSize 104
- totalSize 440
+ totalSize 442
#### A masked pattern was here ####
# Storage Information
@@ -1404,7 +1404,7 @@ Partition Parameters:
numFiles 1
numRows 11
rawDataSize 88
- totalSize 417
+ totalSize 419
#### A masked pattern was here ####
# Storage Information
@@ -1466,7 +1466,7 @@ Partition Parameters:
numFiles 1
numRows 13
rawDataSize 104
- totalSize 440
+ totalSize 442
#### A masked pattern was here ####
# Storage Information
Modified: hive/branches/spark/ql/src/test/results/clientpositive/extrapolate_part_stats_full.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/extrapolate_part_stats_full.q.out?rev=1640263&r1=1640262&r2=1640263&view=diff
==============================================================================
Files hive/branches/spark/ql/src/test/results/clientpositive/extrapolate_part_stats_full.q.out (original) and hive/branches/spark/ql/src/test/results/clientpositive/extrapolate_part_stats_full.q.out Tue Nov 18 00:48:40 2014 differ
Modified: hive/branches/spark/ql/src/test/results/clientpositive/extrapolate_part_stats_partial.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/extrapolate_part_stats_partial.q.out?rev=1640263&r1=1640262&r2=1640263&view=diff
==============================================================================
Files hive/branches/spark/ql/src/test/results/clientpositive/extrapolate_part_stats_partial.q.out (original) and hive/branches/spark/ql/src/test/results/clientpositive/extrapolate_part_stats_partial.q.out Tue Nov 18 00:48:40 2014 differ
Modified: hive/branches/spark/ql/src/test/results/clientpositive/groupby_ppd.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/groupby_ppd.q.out?rev=1640263&r1=1640262&r2=1640263&view=diff
==============================================================================
--- hive/branches/spark/ql/src/test/results/clientpositive/groupby_ppd.q.out (original)
+++ hive/branches/spark/ql/src/test/results/clientpositive/groupby_ppd.q.out Tue Nov 18 00:48:40 2014
@@ -79,7 +79,7 @@ STAGE PLANS:
outputColumnNames: _col0, _col1
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
Select Operator
- expressions: 1 (type: int), _col1 (type: int)
+ expressions: _col1 (type: int), 1 (type: int)
outputColumnNames: _col0, _col1
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
File Output Operator
Copied: hive/branches/spark/ql/src/test/results/clientpositive/insert_nonacid_from_acid.q.out (from r1637419, hive/trunk/ql/src/test/results/clientpositive/insert_nonacid_from_acid.q.out)
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/insert_nonacid_from_acid.q.out?p2=hive/branches/spark/ql/src/test/results/clientpositive/insert_nonacid_from_acid.q.out&p1=hive/trunk/ql/src/test/results/clientpositive/insert_nonacid_from_acid.q.out&r1=1637419&r2=1640263&rev=1640263&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/insert_nonacid_from_acid.q.out (original)
+++ hive/branches/spark/ql/src/test/results/clientpositive/insert_nonacid_from_acid.q.out Tue Nov 18 00:48:40 2014
@@ -27,11 +27,11 @@ POSTHOOK: query: select * from sample_06
POSTHOOK: type: QUERY
POSTHOOK: Input: default@sample_06
#### A masked pattern was here ####
-eee 32 3.00
-ccc 32 3.00
-bbb 32 3.00
-ddd 35 3.00
-aaa 35 3.00
+eee 32 3
+ccc 32 3
+bbb 32 3
+ddd 35 3
+aaa 35 3
PREHOOK: query: create table tab1 (name varchar(50), age int, gpa decimal(3, 2))
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
@@ -59,8 +59,8 @@ POSTHOOK: query: select * from tab1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@tab1
#### A masked pattern was here ####
-eee 32 3.00
-ccc 32 3.00
-bbb 32 3.00
-ddd 35 3.00
-aaa 35 3.00
+eee 32 3
+ccc 32 3
+bbb 32 3
+ddd 35 3
+aaa 35 3
Modified: hive/branches/spark/ql/src/test/results/clientpositive/orc_analyze.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/orc_analyze.q.out?rev=1640263&r1=1640262&r2=1640263&view=diff
==============================================================================
--- hive/branches/spark/ql/src/test/results/clientpositive/orc_analyze.q.out (original)
+++ hive/branches/spark/ql/src/test/results/clientpositive/orc_analyze.q.out Tue Nov 18 00:48:40 2014
@@ -107,7 +107,7 @@ Table Parameters:
numFiles 1
numRows 100
rawDataSize 52600
- totalSize 3121
+ totalSize 3123
#### A masked pattern was here ####
# Storage Information
@@ -197,7 +197,7 @@ Table Parameters:
numFiles 1
numRows 100
rawDataSize 52600
- totalSize 3121
+ totalSize 3123
#### A masked pattern was here ####
# Storage Information
@@ -313,7 +313,7 @@ Partition Parameters:
numFiles 1
numRows 50
rawDataSize 21950
- totalSize 2024
+ totalSize 2026
#### A masked pattern was here ####
# Storage Information
@@ -358,7 +358,7 @@ Partition Parameters:
numFiles 1
numRows 50
rawDataSize 22050
- totalSize 2043
+ totalSize 2045
#### A masked pattern was here ####
# Storage Information
@@ -460,7 +460,7 @@ Partition Parameters:
numFiles 1
numRows 50
rawDataSize 21950
- totalSize 2024
+ totalSize 2026
#### A masked pattern was here ####
# Storage Information
@@ -505,7 +505,7 @@ Partition Parameters:
numFiles 1
numRows 50
rawDataSize 22050
- totalSize 2043
+ totalSize 2045
#### A masked pattern was here ####
# Storage Information
@@ -627,7 +627,7 @@ Partition Parameters:
numFiles 1
numRows 50
rawDataSize 21950
- totalSize 2024
+ totalSize 2026
#### A masked pattern was here ####
# Storage Information
@@ -672,7 +672,7 @@ Partition Parameters:
numFiles 1
numRows 50
rawDataSize 22050
- totalSize 2043
+ totalSize 2045
#### A masked pattern was here ####
# Storage Information
@@ -780,7 +780,7 @@ Partition Parameters:
numFiles 1
numRows 50
rawDataSize 21950
- totalSize 2024
+ totalSize 2026
#### A masked pattern was here ####
# Storage Information
@@ -825,7 +825,7 @@ Partition Parameters:
numFiles 1
numRows 50
rawDataSize 22050
- totalSize 2043
+ totalSize 2045
#### A masked pattern was here ####
# Storage Information
@@ -992,7 +992,7 @@ Partition Parameters:
numFiles 1
numRows 50
rawDataSize 21950
- totalSize 2024
+ totalSize 2026
#### A masked pattern was here ####
# Storage Information
Modified: hive/branches/spark/ql/src/test/results/clientpositive/orc_merge_incompat1.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/orc_merge_incompat1.q.out?rev=1640263&r1=1640262&r2=1640263&view=diff
==============================================================================
--- hive/branches/spark/ql/src/test/results/clientpositive/orc_merge_incompat1.q.out (original)
+++ hive/branches/spark/ql/src/test/results/clientpositive/orc_merge_incompat1.q.out Tue Nov 18 00:48:40 2014
@@ -138,6 +138,19 @@ POSTHOOK: Lineage: orc_merge5b.string1 S
POSTHOOK: Lineage: orc_merge5b.subtype SIMPLE [(orc_merge5)orc_merge5.FieldSchema(name:subtype, type:double, comment:null), ]
POSTHOOK: Lineage: orc_merge5b.ts SIMPLE [(orc_merge5)orc_merge5.FieldSchema(name:ts, type:timestamp, comment:null), ]
POSTHOOK: Lineage: orc_merge5b.userid SIMPLE [(orc_merge5)orc_merge5.FieldSchema(name:userid, type:bigint, comment:null), ]
+PREHOOK: query: insert into table orc_merge5b select userid,string1,subtype,decimal1,ts from orc_merge5 where userid<=13
+PREHOOK: type: QUERY
+PREHOOK: Input: default@orc_merge5
+PREHOOK: Output: default@orc_merge5b
+POSTHOOK: query: insert into table orc_merge5b select userid,string1,subtype,decimal1,ts from orc_merge5 where userid<=13
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@orc_merge5
+POSTHOOK: Output: default@orc_merge5b
+POSTHOOK: Lineage: orc_merge5b.decimal1 SIMPLE [(orc_merge5)orc_merge5.FieldSchema(name:decimal1, type:decimal(10,0), comment:null), ]
+POSTHOOK: Lineage: orc_merge5b.string1 SIMPLE [(orc_merge5)orc_merge5.FieldSchema(name:string1, type:string, comment:null), ]
+POSTHOOK: Lineage: orc_merge5b.subtype SIMPLE [(orc_merge5)orc_merge5.FieldSchema(name:subtype, type:double, comment:null), ]
+POSTHOOK: Lineage: orc_merge5b.ts SIMPLE [(orc_merge5)orc_merge5.FieldSchema(name:ts, type:timestamp, comment:null), ]
+POSTHOOK: Lineage: orc_merge5b.userid SIMPLE [(orc_merge5)orc_merge5.FieldSchema(name:userid, type:bigint, comment:null), ]
PREHOOK: query: -- 5 files total
analyze table orc_merge5b compute statistics noscan
PREHOOK: type: QUERY
@@ -148,7 +161,7 @@ analyze table orc_merge5b compute statis
POSTHOOK: type: QUERY
POSTHOOK: Input: default@orc_merge5b
POSTHOOK: Output: default@orc_merge5b
-Found 5 items
+Found 6 items
#### A masked pattern was here ####
PREHOOK: query: select * from orc_merge5b
PREHOOK: type: QUERY
@@ -163,6 +176,8 @@ POSTHOOK: Input: default@orc_merge5b
13 bar 80.0 2 1969-12-31 16:00:05
13 bar 80.0 2 1969-12-31 16:00:05
13 bar 80.0 2 1969-12-31 16:00:05
+13 bar 80.0 2 1969-12-31 16:00:05
+2 foo 0.8 1 1969-12-31 16:00:00
2 foo 0.8 1 1969-12-31 16:00:00
2 foo 0.8 1 1969-12-31 16:00:00
2 foo 0.8 1 1969-12-31 16:00:00
@@ -173,6 +188,7 @@ POSTHOOK: Input: default@orc_merge5b
5 eat 0.8 6 1969-12-31 16:00:20
5 eat 0.8 6 1969-12-31 16:00:20
5 eat 0.8 6 1969-12-31 16:00:20
+5 eat 0.8 6 1969-12-31 16:00:20
PREHOOK: query: alter table orc_merge5b concatenate
PREHOOK: type: ALTER_TABLE_MERGE
PREHOOK: Input: default@orc_merge5b
@@ -191,7 +207,7 @@ analyze table orc_merge5b compute statis
POSTHOOK: type: QUERY
POSTHOOK: Input: default@orc_merge5b
POSTHOOK: Output: default@orc_merge5b
-Found 3 items
+Found 4 items
#### A masked pattern was here ####
PREHOOK: query: select * from orc_merge5b
PREHOOK: type: QUERY
@@ -206,6 +222,8 @@ POSTHOOK: Input: default@orc_merge5b
13 bar 80.0 2 1969-12-31 16:00:05
13 bar 80.0 2 1969-12-31 16:00:05
13 bar 80.0 2 1969-12-31 16:00:05
+13 bar 80.0 2 1969-12-31 16:00:05
+2 foo 0.8 1 1969-12-31 16:00:00
2 foo 0.8 1 1969-12-31 16:00:00
2 foo 0.8 1 1969-12-31 16:00:00
2 foo 0.8 1 1969-12-31 16:00:00
@@ -216,3 +234,4 @@ POSTHOOK: Input: default@orc_merge5b
5 eat 0.8 6 1969-12-31 16:00:20
5 eat 0.8 6 1969-12-31 16:00:20
5 eat 0.8 6 1969-12-31 16:00:20
+5 eat 0.8 6 1969-12-31 16:00:20
Modified: hive/branches/spark/ql/src/test/results/clientpositive/orc_predicate_pushdown.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/orc_predicate_pushdown.q.out?rev=1640263&r1=1640262&r2=1640263&view=diff
==============================================================================
--- hive/branches/spark/ql/src/test/results/clientpositive/orc_predicate_pushdown.q.out (original)
+++ hive/branches/spark/ql/src/test/results/clientpositive/orc_predicate_pushdown.q.out Tue Nov 18 00:48:40 2014
@@ -259,7 +259,7 @@ POSTHOOK: query: SELECT * FROM orc_pred
POSTHOOK: type: QUERY
POSTHOOK: Input: default@orc_pred
#### A masked pattern was here ####
-124 336 65664 4294967435 74.72 42.47 true bob davidson 2013-03-01 09:11:58.703302 45.40 yard duty
+124 336 65664 4294967435 74.72 42.47 true bob davidson 2013-03-01 09:11:58.703302 45.4 yard duty
PREHOOK: query: SELECT * FROM orc_pred WHERE t>2 limit 1
PREHOOK: type: QUERY
PREHOOK: Input: default@orc_pred
@@ -268,7 +268,7 @@ POSTHOOK: query: SELECT * FROM orc_pred
POSTHOOK: type: QUERY
POSTHOOK: Input: default@orc_pred
#### A masked pattern was here ####
-124 336 65664 4294967435 74.72 42.47 true bob davidson 2013-03-01 09:11:58.703302 45.40 yard duty
+124 336 65664 4294967435 74.72 42.47 true bob davidson 2013-03-01 09:11:58.703302 45.4 yard duty
PREHOOK: query: SELECT SUM(HASH(t)) FROM orc_pred
WHERE t IS NOT NULL
AND t < 0
Modified: hive/branches/spark/ql/src/test/results/clientpositive/parquet_create.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/parquet_create.q.out?rev=1640263&r1=1640262&r2=1640263&view=diff
==============================================================================
--- hive/branches/spark/ql/src/test/results/clientpositive/parquet_create.q.out (original)
+++ hive/branches/spark/ql/src/test/results/clientpositive/parquet_create.q.out Tue Nov 18 00:48:40 2014
@@ -118,17 +118,6 @@ POSTHOOK: Lineage: parquet_create.lst SI
POSTHOOK: Lineage: parquet_create.mp SIMPLE [(parquet_create_staging)parquet_create_staging.FieldSchema(name:mp, type:map<string,string>, comment:null), ]
POSTHOOK: Lineage: parquet_create.str SIMPLE [(parquet_create_staging)parquet_create_staging.FieldSchema(name:str, type:string, comment:null), ]
POSTHOOK: Lineage: parquet_create.strct SIMPLE [(parquet_create_staging)parquet_create_staging.FieldSchema(name:strct, type:struct<A:string,B:string>, comment:null), ]
-PREHOOK: query: SELECT * FROM parquet_create group by id
-PREHOOK: type: QUERY
-PREHOOK: Input: default@parquet_create
-#### A masked pattern was here ####
-POSTHOOK: query: SELECT * FROM parquet_create group by id
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@parquet_create
-#### A masked pattern was here ####
-1
-2
-3
PREHOOK: query: SELECT id, count(0) FROM parquet_create group by id
PREHOOK: type: QUERY
PREHOOK: Input: default@parquet_create
Modified: hive/branches/spark/ql/src/test/results/clientpositive/parquet_decimal.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/parquet_decimal.q.out?rev=1640263&r1=1640262&r2=1640263&view=diff
==============================================================================
--- hive/branches/spark/ql/src/test/results/clientpositive/parquet_decimal.q.out (original)
+++ hive/branches/spark/ql/src/test/results/clientpositive/parquet_decimal.q.out Tue Nov 18 00:48:40 2014
@@ -63,9 +63,9 @@ Mary 4.33
Cluck 5.96
Tom -12.25
Mary 33.33
-Tom 19.00
-Beck 0.00
-Beck 79.90
+Tom 19
+Beck 0
+Beck 79.9
PREHOOK: query: TRUNCATE TABLE parq_dec
PREHOOK: type: TRUNCATETABLE
PREHOOK: Output: default@parq_dec
@@ -140,12 +140,12 @@ POSTHOOK: Input: default@parq_dec1
77.3
55.7
4.3
-6.0
+6
12.3
33.3
0.2
3.2
-8.0
+8
PREHOOK: query: DROP TABLE dec
PREHOOK: type: DROPTABLE
PREHOOK: Input: default@dec
Modified: hive/branches/spark/ql/src/test/results/clientpositive/parquet_decimal1.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/parquet_decimal1.q.out?rev=1640263&r1=1640262&r2=1640263&view=diff
==============================================================================
--- hive/branches/spark/ql/src/test/results/clientpositive/parquet_decimal1.q.out (original)
+++ hive/branches/spark/ql/src/test/results/clientpositive/parquet_decimal1.q.out Tue Nov 18 00:48:40 2014
@@ -28,7 +28,7 @@ POSTHOOK: query: SELECT * FROM dec_comp
POSTHOOK: type: QUERY
POSTHOOK: Input: default@dec_comp
#### A masked pattern was here ####
-[3.14,6.28,7.30] {"k1":92.77,"k2":29.39} {"i":5,"d":9.03}
+[3.14,6.28,7.3] {"k1":92.77,"k2":29.39} {"i":5,"d":9.03}
[12.4,1.33,0.34] {"k2":2.79,"k4":29.09} {"i":11,"d":0.03}
PREHOOK: query: DROP TABLE IF EXISTS parq_dec_comp
PREHOOK: type: DROPTABLE
@@ -72,8 +72,8 @@ POSTHOOK: query: SELECT * FROM parq_dec_
POSTHOOK: type: QUERY
POSTHOOK: Input: default@parq_dec_comp
#### A masked pattern was here ####
-[3.14,6.28,7.30] {"k2":29.39,"k1":92.77} {"i":5,"d":9.03}
-[12.40,1.33,0.34] {"k4":29.09,"k2":2.79} {"i":11,"d":0.03}
+[3.14,6.28,7.3] {"k2":29.39,"k1":92.77} {"i":5,"d":9.03}
+[12.4,1.33,0.34] {"k4":29.09,"k2":2.79} {"i":11,"d":0.03}
PREHOOK: query: DROP TABLE dec_comp
PREHOOK: type: DROPTABLE
PREHOOK: Input: default@dec_comp
Modified: hive/branches/spark/ql/src/test/results/clientpositive/serde_regex.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/serde_regex.q.out?rev=1640263&r1=1640262&r2=1640263&view=diff
==============================================================================
--- hive/branches/spark/ql/src/test/results/clientpositive/serde_regex.q.out (original)
+++ hive/branches/spark/ql/src/test/results/clientpositive/serde_regex.q.out Tue Nov 18 00:48:40 2014
@@ -201,7 +201,7 @@ POSTHOOK: type: QUERY
POSTHOOK: Input: default@serde_regex1
#### A masked pattern was here ####
NULL 0
--1234567890.1234567890 -1234567890
+-1234567890.123456789 -1234567890
-4400 4400
-1255.49 -1255
-1.122 -11
@@ -210,7 +210,7 @@ NULL 0
-0.333 0
-0.33 0
-0.3 0
-0.000000000000000000 0
+0 0
0 0
0 0
0.01 0
@@ -221,8 +221,8 @@ NULL 0
0.33 0
0.333 0
1 1
-1.0 1
-1.000000000000000000 1
+1 1
+1 1
1.12 1
1.122 1
2 2
@@ -230,14 +230,14 @@ NULL 0
3.14 3
3.14 3
3.14 3
-3.140 4
+3.14 4
10 10
20 20
100 100
-124.00 124
+124 124
125.2 125
200 200
-1234567890.1234567800 1234567890
+1234567890.12345678 1234567890
PREHOOK: query: DROP TABLE serde_regex1
PREHOOK: type: DROPTABLE
PREHOOK: Input: default@serde_regex1
Modified: hive/branches/spark/ql/src/test/results/clientpositive/show_roles.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/show_roles.q.out?rev=1640263&r1=1640262&r2=1640263&view=diff
==============================================================================
--- hive/branches/spark/ql/src/test/results/clientpositive/show_roles.q.out (original)
+++ hive/branches/spark/ql/src/test/results/clientpositive/show_roles.q.out Tue Nov 18 00:48:40 2014
@@ -14,4 +14,3 @@ admin
public
role1
role2
-
Modified: hive/branches/spark/ql/src/test/results/clientpositive/tez/alter_merge_orc.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/tez/alter_merge_orc.q.out?rev=1640263&r1=1640262&r2=1640263&view=diff
==============================================================================
--- hive/branches/spark/ql/src/test/results/clientpositive/tez/alter_merge_orc.q.out (original)
+++ hive/branches/spark/ql/src/test/results/clientpositive/tez/alter_merge_orc.q.out Tue Nov 18 00:48:40 2014
@@ -48,9 +48,9 @@ columns:struct columns { i32 key, string
partitioned:false
partitionColumns:
totalNumberFiles:3
-totalFileSize:7488
-maxFileSize:2496
-minFileSize:2496
+totalFileSize:7494
+maxFileSize:2498
+minFileSize:2498
#### A masked pattern was here ####
PREHOOK: query: select count(1) from src_orc_merge_test
@@ -91,9 +91,9 @@ columns:struct columns { i32 key, string
partitioned:false
partitionColumns:
totalNumberFiles:1
-totalFileSize:7167
-maxFileSize:7167
-minFileSize:7167
+totalFileSize:7169
+maxFileSize:7169
+minFileSize:7169
#### A masked pattern was here ####
PREHOOK: query: select count(1) from src_orc_merge_test
@@ -171,9 +171,9 @@ columns:struct columns { i32 key, string
partitioned:true
partitionColumns:struct partition_columns { string ds}
totalNumberFiles:3
-totalFileSize:7488
-maxFileSize:2496
-minFileSize:2496
+totalFileSize:7494
+maxFileSize:2498
+minFileSize:2498
#### A masked pattern was here ####
PREHOOK: query: select count(1) from src_orc_merge_test_part
@@ -218,9 +218,9 @@ columns:struct columns { i32 key, string
partitioned:true
partitionColumns:struct partition_columns { string ds}
totalNumberFiles:1
-totalFileSize:7167
-maxFileSize:7167
-minFileSize:7167
+totalFileSize:7169
+maxFileSize:7169
+minFileSize:7169
#### A masked pattern was here ####
PREHOOK: query: select count(1) from src_orc_merge_test_part
Modified: hive/branches/spark/ql/src/test/results/clientpositive/tez/alter_merge_stats_orc.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/tez/alter_merge_stats_orc.q.out?rev=1640263&r1=1640262&r2=1640263&view=diff
==============================================================================
--- hive/branches/spark/ql/src/test/results/clientpositive/tez/alter_merge_stats_orc.q.out (original)
+++ hive/branches/spark/ql/src/test/results/clientpositive/tez/alter_merge_stats_orc.q.out Tue Nov 18 00:48:40 2014
@@ -48,9 +48,9 @@ columns:struct columns { i32 key, string
partitioned:false
partitionColumns:
totalNumberFiles:3
-totalFileSize:7488
-maxFileSize:2496
-minFileSize:2496
+totalFileSize:7494
+maxFileSize:2498
+minFileSize:2498
#### A masked pattern was here ####
PREHOOK: query: desc extended src_orc_merge_test_stat
@@ -94,7 +94,7 @@ Table Parameters:
numFiles 3
numRows 1500
rawDataSize 141000
- totalSize 7488
+ totalSize 7494
#### A masked pattern was here ####
# Storage Information
@@ -146,7 +146,7 @@ Table Parameters:
numFiles 1
numRows 1500
rawDataSize 141000
- totalSize 7167
+ totalSize 7169
#### A masked pattern was here ####
# Storage Information
@@ -216,9 +216,9 @@ columns:struct columns { i32 key, string
partitioned:true
partitionColumns:struct partition_columns { string ds}
totalNumberFiles:3
-totalFileSize:7488
-maxFileSize:2496
-minFileSize:2496
+totalFileSize:7494
+maxFileSize:2498
+minFileSize:2498
#### A masked pattern was here ####
PREHOOK: query: desc formatted src_orc_merge_test_part_stat partition (ds='2011')
@@ -249,7 +249,7 @@ Partition Parameters:
numFiles 3
numRows 1500
rawDataSize 141000
- totalSize 7488
+ totalSize 7494
#### A masked pattern was here ####
# Storage Information
@@ -300,7 +300,7 @@ Partition Parameters:
numFiles 3
numRows 1500
rawDataSize 141000
- totalSize 7488
+ totalSize 7494
#### A masked pattern was here ####
# Storage Information
@@ -359,7 +359,7 @@ Partition Parameters:
numFiles 1
numRows 1500
rawDataSize 141000
- totalSize 7167
+ totalSize 7169
#### A masked pattern was here ####
# Storage Information