You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by ha...@apache.org on 2014/12/08 17:21:02 UTC
svn commit: r1643848 [4/5] - in /hive/trunk:
hbase-handler/src/test/results/positive/
ql/src/java/org/apache/hadoop/hive/ql/optimizer/stats/annotation/
ql/src/test/results/clientpositive/ ql/src/test/results/clientpositive/tez/
Modified: hive/trunk/ql/src/test/results/clientpositive/tez/mrr.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/tez/mrr.q.out?rev=1643848&r1=1643847&r2=1643848&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/tez/mrr.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/tez/mrr.q.out Mon Dec 8 16:21:01 2014
@@ -44,21 +44,21 @@ STAGE PLANS:
keys: KEY._col0 (type: string)
mode: mergepartial
outputColumnNames: _col0, _col1
- Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col1 (type: bigint)
sort order: +
- Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
value expressions: _col0 (type: string)
Reducer 3
Reduce Operator Tree:
Select Operator
expressions: VALUE._col0 (type: string), KEY.reducesinkkey0 (type: bigint)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -461,21 +461,21 @@ STAGE PLANS:
keys: KEY._col0 (type: string)
mode: mergepartial
outputColumnNames: _col0, _col1
- Statistics: Num rows: 275 Data size: 2921 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 137 Data size: 1455 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col1 (type: bigint)
sort order: +
- Statistics: Num rows: 275 Data size: 2921 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 137 Data size: 1455 Basic stats: COMPLETE Column stats: NONE
value expressions: _col0 (type: string)
Reducer 4
Reduce Operator Tree:
Select Operator
expressions: VALUE._col0 (type: string), KEY.reducesinkkey0 (type: bigint)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 275 Data size: 2921 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 137 Data size: 1455 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 275 Data size: 2921 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 137 Data size: 1455 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -876,21 +876,21 @@ STAGE PLANS:
keys: KEY._col0 (type: string)
mode: mergepartial
outputColumnNames: _col0, _col1
- Statistics: Num rows: 275 Data size: 2921 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 137 Data size: 1455 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col1 (type: bigint)
sort order: +
- Statistics: Num rows: 275 Data size: 2921 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 137 Data size: 1455 Basic stats: COMPLETE Column stats: NONE
value expressions: _col0 (type: string)
Reducer 3
Reduce Operator Tree:
Select Operator
expressions: VALUE._col0 (type: string), KEY.reducesinkkey0 (type: bigint)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 275 Data size: 2921 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 137 Data size: 1455 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 275 Data size: 2921 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 137 Data size: 1455 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -1338,23 +1338,23 @@ STAGE PLANS:
keys: KEY._col0 (type: string)
mode: mergepartial
outputColumnNames: _col0, _col1
- Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 125 Data size: 1328 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col1 (type: bigint)
sort order: +
- Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 125 Data size: 1328 Basic stats: COMPLETE Column stats: NONE
value expressions: _col0 (type: string)
Reducer 11
Reduce Operator Tree:
Select Operator
expressions: VALUE._col0 (type: string), KEY.reducesinkkey0 (type: bigint)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 125 Data size: 1328 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: string)
sort order: +
Map-reduce partition columns: _col0 (type: string)
- Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 125 Data size: 1328 Basic stats: COMPLETE Column stats: NONE
value expressions: _col1 (type: bigint)
Reducer 2
Reduce Operator Tree:
@@ -1395,21 +1395,21 @@ STAGE PLANS:
1 {KEY.reducesinkkey0} {VALUE._col0}
2 {KEY.reducesinkkey0} {VALUE._col0}
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
- Statistics: Num rows: 550 Data size: 5843 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 275 Data size: 2921 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: string)
sort order: +
- Statistics: Num rows: 550 Data size: 5843 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 275 Data size: 2921 Basic stats: COMPLETE Column stats: NONE
value expressions: _col1 (type: bigint), _col2 (type: string), _col3 (type: bigint), _col4 (type: string), _col5 (type: bigint)
Reducer 5
Reduce Operator Tree:
Select Operator
expressions: KEY.reducesinkkey0 (type: string), VALUE._col0 (type: bigint), VALUE._col1 (type: string), VALUE._col2 (type: bigint), VALUE._col3 (type: string), VALUE._col4 (type: bigint)
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
- Statistics: Num rows: 550 Data size: 5843 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 275 Data size: 2921 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 550 Data size: 5843 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 275 Data size: 2921 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -1421,23 +1421,23 @@ STAGE PLANS:
keys: KEY._col0 (type: string)
mode: mergepartial
outputColumnNames: _col0, _col1
- Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 125 Data size: 1328 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col1 (type: bigint)
sort order: +
- Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 125 Data size: 1328 Basic stats: COMPLETE Column stats: NONE
value expressions: _col0 (type: string)
Reducer 8
Reduce Operator Tree:
Select Operator
expressions: VALUE._col0 (type: string), KEY.reducesinkkey0 (type: bigint)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 125 Data size: 1328 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: string)
sort order: +
Map-reduce partition columns: _col0 (type: string)
- Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 125 Data size: 1328 Basic stats: COMPLETE Column stats: NONE
value expressions: _col1 (type: bigint)
Stage: Stage-0
@@ -1638,7 +1638,8 @@ STAGE PLANS:
Stage: Stage-1
Tez
Edges:
- Reducer 2 <- Map 1 (SIMPLE_EDGE), Map 3 (BROADCAST_EDGE)
+ Map 3 <- Reducer 2 (BROADCAST_EDGE)
+ Reducer 2 <- Map 1 (SIMPLE_EDGE)
#### A masked pattern was here ####
Vertices:
Map 1
@@ -1669,12 +1670,30 @@ STAGE PLANS:
Filter Operator
predicate: key is not null (type: boolean)
Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
- Reduce Output Operator
- key expressions: key (type: string)
- sort order: +
- Map-reduce partition columns: key (type: string)
- Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
- value expressions: value (type: string)
+ Map Join Operator
+ condition map:
+ Inner Join 0 to 1
+ condition expressions:
+ 0 {_col0} {_col1}
+ 1 {key} {value}
+ keys:
+ 0 _col0 (type: string)
+ 1 key (type: string)
+ outputColumnNames: _col0, _col1, _col2, _col3
+ input vertices:
+ 0 Reducer 2
+ Statistics: Num rows: 275 Data size: 2921 Basic stats: COMPLETE Column stats: NONE
+ Select Operator
+ expressions: _col0 (type: string), _col1 (type: bigint), _col2 (type: string), _col3 (type: string)
+ outputColumnNames: _col0, _col1, _col2, _col3
+ Statistics: Num rows: 275 Data size: 2921 Basic stats: COMPLETE Column stats: NONE
+ File Output Operator
+ compressed: false
+ Statistics: Num rows: 275 Data size: 2921 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
Reducer 2
Reduce Operator Tree:
Group By Operator
@@ -1682,31 +1701,13 @@ STAGE PLANS:
keys: KEY._col0 (type: string)
mode: mergepartial
outputColumnNames: _col0, _col1
- Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
- Map Join Operator
- condition map:
- Inner Join 0 to 1
- condition expressions:
- 0 {_col0} {_col1}
- 1 {key} {value}
- keys:
- 0 _col0 (type: string)
- 1 key (type: string)
- outputColumnNames: _col0, _col1, _col2, _col3
- input vertices:
- 1 Map 3
- Statistics: Num rows: 275 Data size: 2921 Basic stats: COMPLETE Column stats: NONE
- Select Operator
- expressions: _col0 (type: string), _col1 (type: bigint), _col2 (type: string), _col3 (type: string)
- outputColumnNames: _col0, _col1, _col2, _col3
- Statistics: Num rows: 275 Data size: 2921 Basic stats: COMPLETE Column stats: NONE
- File Output Operator
- compressed: false
- Statistics: Num rows: 275 Data size: 2921 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
+ Statistics: Num rows: 125 Data size: 1328 Basic stats: COMPLETE Column stats: NONE
+ Reduce Output Operator
+ key expressions: _col0 (type: string)
+ sort order: +
+ Map-reduce partition columns: _col0 (type: string)
+ Statistics: Num rows: 125 Data size: 1328 Basic stats: COMPLETE Column stats: NONE
+ value expressions: _col1 (type: bigint)
Stage: Stage-0
Fetch Operator
@@ -1728,503 +1729,503 @@ FROM
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
-0 3 0 val_0
-0 3 0 val_0
-0 3 0 val_0
-10 1 10 val_10
-100 2 100 val_100
-100 2 100 val_100
-103 2 103 val_103
-103 2 103 val_103
-104 2 104 val_104
-104 2 104 val_104
-105 1 105 val_105
-11 1 11 val_11
-111 1 111 val_111
-113 2 113 val_113
-113 2 113 val_113
-114 1 114 val_114
-116 1 116 val_116
-118 2 118 val_118
-118 2 118 val_118
-119 3 119 val_119
-119 3 119 val_119
-119 3 119 val_119
-12 2 12 val_12
-12 2 12 val_12
-120 2 120 val_120
-120 2 120 val_120
-125 2 125 val_125
-125 2 125 val_125
-126 1 126 val_126
-128 3 128 val_128
-128 3 128 val_128
+238 2 238 val_238
+86 1 86 val_86
+311 3 311 val_311
+27 1 27 val_27
+165 2 165 val_165
+409 3 409 val_409
+255 2 255 val_255
+278 2 278 val_278
+98 2 98 val_98
+484 1 484 val_484
+265 2 265 val_265
+193 3 193 val_193
+401 5 401 val_401
+150 1 150 val_150
+273 3 273 val_273
+224 2 224 val_224
+369 3 369 val_369
+66 1 66 val_66
128 3 128 val_128
-129 2 129 val_129
-129 2 129 val_129
-131 1 131 val_131
-133 1 133 val_133
-134 2 134 val_134
-134 2 134 val_134
-136 1 136 val_136
-137 2 137 val_137
-137 2 137 val_137
-138 4 138 val_138
-138 4 138 val_138
-138 4 138 val_138
-138 4 138 val_138
-143 1 143 val_143
-145 1 145 val_145
-146 2 146 val_146
+213 2 213 val_213
146 2 146 val_146
-149 2 149 val_149
-149 2 149 val_149
-15 2 15 val_15
-15 2 15 val_15
-150 1 150 val_150
-152 2 152 val_152
+406 4 406 val_406
+429 2 429 val_429
+374 1 374 val_374
152 2 152 val_152
+469 5 469 val_469
+145 1 145 val_145
+495 1 495 val_495
+37 2 37 val_37
+327 3 327 val_327
+281 2 281 val_281
+277 4 277 val_277
+209 2 209 val_209
+15 2 15 val_15
+82 1 82 val_82
+403 3 403 val_403
+166 1 166 val_166
+417 3 417 val_417
+430 3 430 val_430
+252 1 252 val_252
+292 1 292 val_292
+219 2 219 val_219
+287 1 287 val_287
153 1 153 val_153
-155 1 155 val_155
-156 1 156 val_156
-157 1 157 val_157
-158 1 158 val_158
-160 1 160 val_160
+193 3 193 val_193
+338 1 338 val_338
+446 1 446 val_446
+459 2 459 val_459
+394 1 394 val_394
+237 2 237 val_237
+482 1 482 val_482
+174 2 174 val_174
+413 2 413 val_413
+494 1 494 val_494
+207 2 207 val_207
+199 3 199 val_199
+466 3 466 val_466
+208 3 208 val_208
+174 2 174 val_174
+399 2 399 val_399
+396 3 396 val_396
+247 1 247 val_247
+417 3 417 val_417
+489 4 489 val_489
162 1 162 val_162
-163 1 163 val_163
-164 2 164 val_164
-164 2 164 val_164
-165 2 165 val_165
-165 2 165 val_165
-166 1 166 val_166
-167 3 167 val_167
-167 3 167 val_167
+377 1 377 val_377
+397 2 397 val_397
+309 2 309 val_309
+365 1 365 val_365
+266 1 266 val_266
+439 2 439 val_439
+342 2 342 val_342
+367 2 367 val_367
+325 2 325 val_325
167 3 167 val_167
-168 1 168 val_168
-169 4 169 val_169
-169 4 169 val_169
-169 4 169 val_169
-169 4 169 val_169
+195 2 195 val_195
+475 1 475 val_475
17 1 17 val_17
+113 2 113 val_113
+155 1 155 val_155
+203 2 203 val_203
+339 1 339 val_339
+0 3 0 val_0
+455 1 455 val_455
+128 3 128 val_128
+311 3 311 val_311
+316 3 316 val_316
+57 1 57 val_57
+302 1 302 val_302
+205 2 205 val_205
+149 2 149 val_149
+438 3 438 val_438
+345 1 345 val_345
+129 2 129 val_129
170 1 170 val_170
-172 2 172 val_172
-172 2 172 val_172
-174 2 174 val_174
-174 2 174 val_174
-175 2 175 val_175
-175 2 175 val_175
-176 2 176 val_176
-176 2 176 val_176
-177 1 177 val_177
-178 1 178 val_178
-179 2 179 val_179
-179 2 179 val_179
-18 2 18 val_18
-18 2 18 val_18
-180 1 180 val_180
-181 1 181 val_181
-183 1 183 val_183
-186 1 186 val_186
-187 3 187 val_187
-187 3 187 val_187
-187 3 187 val_187
-189 1 189 val_189
-19 1 19 val_19
-190 1 190 val_190
-191 2 191 val_191
-191 2 191 val_191
-192 1 192 val_192
-193 3 193 val_193
-193 3 193 val_193
-193 3 193 val_193
-194 1 194 val_194
-195 2 195 val_195
-195 2 195 val_195
-196 1 196 val_196
-197 2 197 val_197
-197 2 197 val_197
-199 3 199 val_199
-199 3 199 val_199
-199 3 199 val_199
-2 1 2 val_2
20 1 20 val_20
-200 2 200 val_200
-200 2 200 val_200
-201 1 201 val_201
-202 1 202 val_202
-203 2 203 val_203
-203 2 203 val_203
-205 2 205 val_205
-205 2 205 val_205
-207 2 207 val_207
-207 2 207 val_207
-208 3 208 val_208
-208 3 208 val_208
+489 4 489 val_489
+157 1 157 val_157
+378 1 378 val_378
+221 2 221 val_221
+92 1 92 val_92
+111 1 111 val_111
+47 1 47 val_47
+72 2 72 val_72
+4 1 4 val_4
+280 2 280 val_280
+35 3 35 val_35
+427 1 427 val_427
+277 4 277 val_277
208 3 208 val_208
-209 2 209 val_209
-209 2 209 val_209
-213 2 213 val_213
+356 1 356 val_356
+399 2 399 val_399
+169 4 169 val_169
+382 2 382 val_382
+498 3 498 val_498
+125 2 125 val_125
+386 1 386 val_386
+437 1 437 val_437
+469 5 469 val_469
+192 1 192 val_192
+286 1 286 val_286
+187 3 187 val_187
+176 2 176 val_176
+54 1 54 val_54
+459 2 459 val_459
+51 2 51 val_51
+138 4 138 val_138
+103 2 103 val_103
+239 2 239 val_239
213 2 213 val_213
-214 1 214 val_214
216 2 216 val_216
-216 2 216 val_216
-217 2 217 val_217
-217 2 217 val_217
-218 1 218 val_218
-219 2 219 val_219
-219 2 219 val_219
-221 2 221 val_221
+430 3 430 val_430
+278 2 278 val_278
+176 2 176 val_176
+289 1 289 val_289
221 2 221 val_221
-222 1 222 val_222
-223 2 223 val_223
-223 2 223 val_223
-224 2 224 val_224
-224 2 224 val_224
-226 1 226 val_226
-228 1 228 val_228
-229 2 229 val_229
-229 2 229 val_229
-230 5 230 val_230
-230 5 230 val_230
-230 5 230 val_230
+65 1 65 val_65
+318 3 318 val_318
+332 1 332 val_332
+311 3 311 val_311
+275 1 275 val_275
+137 2 137 val_137
+241 1 241 val_241
+83 2 83 val_83
+333 2 333 val_333
+180 1 180 val_180
+284 1 284 val_284
+12 2 12 val_12
230 5 230 val_230
+181 1 181 val_181
+67 2 67 val_67
+260 1 260 val_260
+404 2 404 val_404
+384 3 384 val_384
+489 4 489 val_489
+353 2 353 val_353
+373 1 373 val_373
+272 2 272 val_272
+138 4 138 val_138
+217 2 217 val_217
+84 2 84 val_84
+348 5 348 val_348
+466 3 466 val_466
+58 2 58 val_58
+8 1 8 val_8
+411 1 411 val_411
230 5 230 val_230
-233 2 233 val_233
-233 2 233 val_233
-235 1 235 val_235
-237 2 237 val_237
-237 2 237 val_237
-238 2 238 val_238
-238 2 238 val_238
-239 2 239 val_239
-239 2 239 val_239
-24 2 24 val_24
+208 3 208 val_208
+348 5 348 val_348
24 2 24 val_24
-241 1 241 val_241
-242 2 242 val_242
-242 2 242 val_242
-244 1 244 val_244
-247 1 247 val_247
-248 1 248 val_248
-249 1 249 val_249
-252 1 252 val_252
-255 2 255 val_255
-255 2 255 val_255
-256 2 256 val_256
-256 2 256 val_256
-257 1 257 val_257
-258 1 258 val_258
-26 2 26 val_26
+463 2 463 val_463
+431 3 431 val_431
+179 2 179 val_179
+172 2 172 val_172
+42 2 42 val_42
+129 2 129 val_129
+158 1 158 val_158
+119 3 119 val_119
+496 1 496 val_496
+0 3 0 val_0
+322 2 322 val_322
+197 2 197 val_197
+468 4 468 val_468
+393 1 393 val_393
+454 3 454 val_454
+100 2 100 val_100
+298 3 298 val_298
+199 3 199 val_199
+191 2 191 val_191
+418 1 418 val_418
+96 1 96 val_96
26 2 26 val_26
-260 1 260 val_260
-262 1 262 val_262
-263 1 263 val_263
-265 2 265 val_265
-265 2 265 val_265
-266 1 266 val_266
-27 1 27 val_27
-272 2 272 val_272
-272 2 272 val_272
-273 3 273 val_273
-273 3 273 val_273
-273 3 273 val_273
-274 1 274 val_274
-275 1 275 val_275
-277 4 277 val_277
-277 4 277 val_277
-277 4 277 val_277
-277 4 277 val_277
-278 2 278 val_278
-278 2 278 val_278
-28 1 28 val_28
-280 2 280 val_280
-280 2 280 val_280
-281 2 281 val_281
-281 2 281 val_281
+165 2 165 val_165
+327 3 327 val_327
+230 5 230 val_230
+205 2 205 val_205
+120 2 120 val_120
+131 1 131 val_131
+51 2 51 val_51
+404 2 404 val_404
+43 1 43 val_43
+436 1 436 val_436
+156 1 156 val_156
+469 5 469 val_469
+468 4 468 val_468
+308 1 308 val_308
+95 2 95 val_95
+196 1 196 val_196
+288 2 288 val_288
+481 1 481 val_481
+457 1 457 val_457
+98 2 98 val_98
282 2 282 val_282
+197 2 197 val_197
+187 3 187 val_187
+318 3 318 val_318
+318 3 318 val_318
+409 3 409 val_409
+470 1 470 val_470
+137 2 137 val_137
+369 3 369 val_369
+316 3 316 val_316
+169 4 169 val_169
+413 2 413 val_413
+85 1 85 val_85
+77 1 77 val_77
+0 3 0 val_0
+490 1 490 val_490
+87 1 87 val_87
+364 1 364 val_364
+179 2 179 val_179
+118 2 118 val_118
+134 2 134 val_134
+395 2 395 val_395
282 2 282 val_282
-283 1 283 val_283
-284 1 284 val_284
-285 1 285 val_285
-286 1 286 val_286
-287 1 287 val_287
-288 2 288 val_288
-288 2 288 val_288
-289 1 289 val_289
-291 1 291 val_291
-292 1 292 val_292
-296 1 296 val_296
-298 3 298 val_298
-298 3 298 val_298
-298 3 298 val_298
-30 1 30 val_30
-302 1 302 val_302
-305 1 305 val_305
-306 1 306 val_306
-307 2 307 val_307
+138 4 138 val_138
+238 2 238 val_238
+419 1 419 val_419
+15 2 15 val_15
+118 2 118 val_118
+72 2 72 val_72
+90 3 90 val_90
307 2 307 val_307
-308 1 308 val_308
-309 2 309 val_309
+19 1 19 val_19
+435 1 435 val_435
+10 1 10 val_10
+277 4 277 val_277
+273 3 273 val_273
+306 1 306 val_306
+224 2 224 val_224
309 2 309 val_309
-310 1 310 val_310
-311 3 311 val_311
-311 3 311 val_311
-311 3 311 val_311
-315 1 315 val_315
-316 3 316 val_316
-316 3 316 val_316
-316 3 316 val_316
-317 2 317 val_317
-317 2 317 val_317
-318 3 318 val_318
-318 3 318 val_318
-318 3 318 val_318
-321 2 321 val_321
-321 2 321 val_321
-322 2 322 val_322
-322 2 322 val_322
-323 1 323 val_323
-325 2 325 val_325
-325 2 325 val_325
-327 3 327 val_327
-327 3 327 val_327
+389 1 389 val_389
327 3 327 val_327
-33 1 33 val_33
-331 2 331 val_331
+242 2 242 val_242
+369 3 369 val_369
+392 1 392 val_392
+272 2 272 val_272
331 2 331 val_331
-332 1 332 val_332
-333 2 333 val_333
-333 2 333 val_333
-335 1 335 val_335
+401 5 401 val_401
+242 2 242 val_242
+452 1 452 val_452
+177 1 177 val_177
+226 1 226 val_226
+5 3 5 val_5
+497 1 497 val_497
+402 1 402 val_402
+396 3 396 val_396
+317 2 317 val_317
+395 2 395 val_395
+58 2 58 val_58
+35 3 35 val_35
336 1 336 val_336
-338 1 338 val_338
-339 1 339 val_339
+95 2 95 val_95
+11 1 11 val_11
+168 1 168 val_168
34 1 34 val_34
-341 1 341 val_341
-342 2 342 val_342
+229 2 229 val_229
+233 2 233 val_233
+143 1 143 val_143
+472 1 472 val_472
+322 2 322 val_322
+498 3 498 val_498
+160 1 160 val_160
+195 2 195 val_195
+42 2 42 val_42
+321 2 321 val_321
+430 3 430 val_430
+119 3 119 val_119
+489 4 489 val_489
+458 2 458 val_458
+78 1 78 val_78
+76 2 76 val_76
+41 1 41 val_41
+223 2 223 val_223
+492 2 492 val_492
+149 2 149 val_149
+449 1 449 val_449
+218 1 218 val_218
+228 1 228 val_228
+138 4 138 val_138
+453 1 453 val_453
+30 1 30 val_30
+209 2 209 val_209
+64 1 64 val_64
+468 4 468 val_468
+76 2 76 val_76
+74 1 74 val_74
342 2 342 val_342
-344 2 344 val_344
-344 2 344 val_344
-345 1 345 val_345
-348 5 348 val_348
-348 5 348 val_348
-348 5 348 val_348
-348 5 348 val_348
-348 5 348 val_348
-35 3 35 val_35
-35 3 35 val_35
-35 3 35 val_35
-351 1 351 val_351
-353 2 353 val_353
-353 2 353 val_353
-356 1 356 val_356
-360 1 360 val_360
-362 1 362 val_362
-364 1 364 val_364
-365 1 365 val_365
-366 1 366 val_366
-367 2 367 val_367
-367 2 367 val_367
+69 1 69 val_69
+230 5 230 val_230
+33 1 33 val_33
368 1 368 val_368
-369 3 369 val_369
-369 3 369 val_369
-369 3 369 val_369
-37 2 37 val_37
-37 2 37 val_37
-373 1 373 val_373
-374 1 374 val_374
-375 1 375 val_375
-377 1 377 val_377
-378 1 378 val_378
-379 1 379 val_379
-382 2 382 val_382
-382 2 382 val_382
-384 3 384 val_384
-384 3 384 val_384
-384 3 384 val_384
-386 1 386 val_386
-389 1 389 val_389
-392 1 392 val_392
-393 1 393 val_393
-394 1 394 val_394
-395 2 395 val_395
-395 2 395 val_395
-396 3 396 val_396
-396 3 396 val_396
-396 3 396 val_396
-397 2 397 val_397
-397 2 397 val_397
-399 2 399 val_399
-399 2 399 val_399
-4 1 4 val_4
-400 1 400 val_400
-401 5 401 val_401
-401 5 401 val_401
-401 5 401 val_401
-401 5 401 val_401
+103 2 103 val_103
+296 1 296 val_296
+113 2 113 val_113
+216 2 216 val_216
+367 2 367 val_367
+344 2 344 val_344
+167 3 167 val_167
+274 1 274 val_274
+219 2 219 val_219
+239 2 239 val_239
+485 1 485 val_485
+116 1 116 val_116
+223 2 223 val_223
+256 2 256 val_256
+263 1 263 val_263
+70 3 70 val_70
+487 1 487 val_487
+480 3 480 val_480
401 5 401 val_401
-402 1 402 val_402
-403 3 403 val_403
-403 3 403 val_403
-403 3 403 val_403
-404 2 404 val_404
-404 2 404 val_404
-406 4 406 val_406
-406 4 406 val_406
-406 4 406 val_406
-406 4 406 val_406
-407 1 407 val_407
-409 3 409 val_409
-409 3 409 val_409
-409 3 409 val_409
-41 1 41 val_41
-411 1 411 val_411
-413 2 413 val_413
-413 2 413 val_413
-414 2 414 val_414
-414 2 414 val_414
-417 3 417 val_417
-417 3 417 val_417
-417 3 417 val_417
-418 1 418 val_418
-419 1 419 val_419
-42 2 42 val_42
-42 2 42 val_42
-421 1 421 val_421
-424 2 424 val_424
+288 2 288 val_288
+191 2 191 val_191
+5 3 5 val_5
+244 1 244 val_244
+438 3 438 val_438
+128 3 128 val_128
+467 1 467 val_467
+432 1 432 val_432
+202 1 202 val_202
+316 3 316 val_316
+229 2 229 val_229
+469 5 469 val_469
+463 2 463 val_463
+280 2 280 val_280
+2 1 2 val_2
+35 3 35 val_35
+283 1 283 val_283
+331 2 331 val_331
+235 1 235 val_235
+80 1 80 val_80
+44 1 44 val_44
+193 3 193 val_193
+321 2 321 val_321
+335 1 335 val_335
+104 2 104 val_104
+466 3 466 val_466
+366 1 366 val_366
+175 2 175 val_175
+403 3 403 val_403
+483 1 483 val_483
+53 1 53 val_53
+105 1 105 val_105
+257 1 257 val_257
+406 4 406 val_406
+409 3 409 val_409
+190 1 190 val_190
+406 4 406 val_406
+401 5 401 val_401
+114 1 114 val_114
+258 1 258 val_258
+90 3 90 val_90
+203 2 203 val_203
+262 1 262 val_262
+348 5 348 val_348
424 2 424 val_424
-427 1 427 val_427
-429 2 429 val_429
-429 2 429 val_429
-43 1 43 val_43
-430 3 430 val_430
-430 3 430 val_430
-430 3 430 val_430
-431 3 431 val_431
+12 2 12 val_12
+396 3 396 val_396
+201 1 201 val_201
+217 2 217 val_217
+164 2 164 val_164
431 3 431 val_431
+454 3 454 val_454
+478 2 478 val_478
+298 3 298 val_298
+125 2 125 val_125
431 3 431 val_431
-432 1 432 val_432
-435 1 435 val_435
-436 1 436 val_436
-437 1 437 val_437
-438 3 438 val_438
-438 3 438 val_438
+164 2 164 val_164
+424 2 424 val_424
+187 3 187 val_187
+382 2 382 val_382
+5 3 5 val_5
+70 3 70 val_70
+397 2 397 val_397
+480 3 480 val_480
+291 1 291 val_291
+24 2 24 val_24
+351 1 351 val_351
+255 2 255 val_255
+104 2 104 val_104
+70 3 70 val_70
+163 1 163 val_163
438 3 438 val_438
+119 3 119 val_119
+414 2 414 val_414
+200 2 200 val_200
+491 1 491 val_491
+237 2 237 val_237
439 2 439 val_439
-439 2 439 val_439
-44 1 44 val_44
-443 1 443 val_443
+360 1 360 val_360
+248 1 248 val_248
+479 1 479 val_479
+305 1 305 val_305
+417 3 417 val_417
+199 3 199 val_199
444 1 444 val_444
-446 1 446 val_446
-448 1 448 val_448
-449 1 449 val_449
-452 1 452 val_452
-453 1 453 val_453
-454 3 454 val_454
-454 3 454 val_454
-454 3 454 val_454
-455 1 455 val_455
-457 1 457 val_457
-458 2 458 val_458
-458 2 458 val_458
-459 2 459 val_459
-459 2 459 val_459
+120 2 120 val_120
+429 2 429 val_429
+169 4 169 val_169
+443 1 443 val_443
+323 1 323 val_323
+325 2 325 val_325
+277 4 277 val_277
+230 5 230 val_230
+478 2 478 val_478
+178 1 178 val_178
+468 4 468 val_468
+310 1 310 val_310
+317 2 317 val_317
+333 2 333 val_333
+493 1 493 val_493
460 1 460 val_460
+207 2 207 val_207
+249 1 249 val_249
+265 2 265 val_265
+480 3 480 val_480
+83 2 83 val_83
+136 1 136 val_136
+353 2 353 val_353
+172 2 172 val_172
+214 1 214 val_214
462 2 462 val_462
+233 2 233 val_233
+406 4 406 val_406
+133 1 133 val_133
+175 2 175 val_175
+189 1 189 val_189
+454 3 454 val_454
+375 1 375 val_375
+401 5 401 val_401
+421 1 421 val_421
+407 1 407 val_407
+384 3 384 val_384
+256 2 256 val_256
+26 2 26 val_26
+134 2 134 val_134
+67 2 67 val_67
+384 3 384 val_384
+379 1 379 val_379
+18 2 18 val_18
462 2 462 val_462
-463 2 463 val_463
-463 2 463 val_463
-466 3 466 val_466
-466 3 466 val_466
-466 3 466 val_466
-467 1 467 val_467
-468 4 468 val_468
-468 4 468 val_468
-468 4 468 val_468
-468 4 468 val_468
-469 5 469 val_469
-469 5 469 val_469
-469 5 469 val_469
-469 5 469 val_469
-469 5 469 val_469
-47 1 47 val_47
-470 1 470 val_470
-472 1 472 val_472
-475 1 475 val_475
-477 1 477 val_477
-478 2 478 val_478
-478 2 478 val_478
-479 1 479 val_479
-480 3 480 val_480
-480 3 480 val_480
-480 3 480 val_480
-481 1 481 val_481
-482 1 482 val_482
-483 1 483 val_483
-484 1 484 val_484
-485 1 485 val_485
-487 1 487 val_487
-489 4 489 val_489
-489 4 489 val_489
-489 4 489 val_489
-489 4 489 val_489
-490 1 490 val_490
-491 1 491 val_491
-492 2 492 val_492
492 2 492 val_492
-493 1 493 val_493
-494 1 494 val_494
-495 1 495 val_495
-496 1 496 val_496
-497 1 497 val_497
-498 3 498 val_498
-498 3 498 val_498
+100 2 100 val_100
+298 3 298 val_298
+9 1 9 val_9
+341 1 341 val_341
498 3 498 val_498
-5 3 5 val_5
-5 3 5 val_5
-5 3 5 val_5
-51 2 51 val_51
-51 2 51 val_51
-53 1 53 val_53
-54 1 54 val_54
-57 1 57 val_57
-58 2 58 val_58
-58 2 58 val_58
-64 1 64 val_64
-65 1 65 val_65
-66 1 66 val_66
-67 2 67 val_67
-67 2 67 val_67
-69 1 69 val_69
-70 3 70 val_70
-70 3 70 val_70
-70 3 70 val_70
-72 2 72 val_72
-72 2 72 val_72
-74 1 74 val_74
-76 2 76 val_76
-76 2 76 val_76
-77 1 77 val_77
-78 1 78 val_78
-8 1 8 val_8
-80 1 80 val_80
-82 1 82 val_82
-83 2 83 val_83
-83 2 83 val_83
-84 2 84 val_84
+146 2 146 val_146
+458 2 458 val_458
+362 1 362 val_362
+186 1 186 val_186
+285 1 285 val_285
+348 5 348 val_348
+167 3 167 val_167
+18 2 18 val_18
+273 3 273 val_273
+183 1 183 val_183
+281 2 281 val_281
+344 2 344 val_344
+97 2 97 val_97
+469 5 469 val_469
+315 1 315 val_315
84 2 84 val_84
-85 1 85 val_85
-86 1 86 val_86
-87 1 87 val_87
-9 1 9 val_9
-90 3 90 val_90
-90 3 90 val_90
+28 1 28 val_28
+37 2 37 val_37
+448 1 448 val_448
+152 2 152 val_152
+348 5 348 val_348
+307 2 307 val_307
+194 1 194 val_194
+414 2 414 val_414
+477 1 477 val_477
+222 1 222 val_222
+126 1 126 val_126
90 3 90 val_90
-92 1 92 val_92
-95 2 95 val_95
-95 2 95 val_95
-96 1 96 val_96
-97 2 97 val_97
+169 4 169 val_169
+403 3 403 val_403
+400 1 400 val_400
+200 2 200 val_200
97 2 97 val_97
-98 2 98 val_98
-98 2 98 val_98
Modified: hive/trunk/ql/src/test/results/clientpositive/tez/parallel.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/tez/parallel.q.out?rev=1643848&r1=1643847&r2=1643848&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/tez/parallel.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/tez/parallel.q.out Mon Dec 8 16:21:01 2014
@@ -69,24 +69,24 @@ STAGE PLANS:
keys: KEY._col0 (type: string), KEY._col1 (type: string)
mode: mergepartial
outputColumnNames: _col0, _col1
- Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
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
+ Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
Reducer 3
Reduce Operator Tree:
Forward
- Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
Group By Operator
keys: KEY._col0 (type: string), KEY._col1 (type: string)
mode: complete
outputColumnNames: _col0, _col1
- Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 125 Data size: 1328 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 125 Data size: 1328 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -96,10 +96,10 @@ STAGE PLANS:
keys: KEY._col0 (type: string), KEY._col1 (type: string)
mode: complete
outputColumnNames: _col0, _col1
- Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 125 Data size: 1328 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 125 Data size: 1328 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
Modified: hive/trunk/ql/src/test/results/clientpositive/tez/subquery_in.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/tez/subquery_in.q.out?rev=1643848&r1=1643847&r2=1643848&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/tez/subquery_in.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/tez/subquery_in.q.out Mon Dec 8 16:21:01 2014
@@ -793,12 +793,12 @@ STAGE PLANS:
keys: KEY._col0 (type: int)
mode: mergepartial
outputColumnNames: _col0
- Statistics: Num rows: 50 Data size: 5999 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 25 Data size: 2999 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: int)
sort order: +
Map-reduce partition columns: _col0 (type: int)
- Statistics: Num rows: 50 Data size: 5999 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 25 Data size: 2999 Basic stats: COMPLETE Column stats: NONE
Reducer 3
Reduce Operator Tree:
Merge Join Operator
@@ -808,12 +808,12 @@ STAGE PLANS:
0 {KEY.reducesinkkey0}
1 {VALUE._col0} {VALUE._col1}
outputColumnNames: _col0, _col1, _col3
- Statistics: Num rows: 55 Data size: 6598 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 27 Data size: 3298 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col1 (type: int)
sort order: +
Map-reduce partition columns: _col1 (type: int)
- Statistics: Num rows: 55 Data size: 6598 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 27 Data size: 3298 Basic stats: COMPLETE Column stats: NONE
value expressions: _col0 (type: int), _col3 (type: int)
Reducer 4
Reduce Operator Tree:
@@ -824,14 +824,14 @@ STAGE PLANS:
0 {VALUE._col0} {VALUE._col2}
1
outputColumnNames: _col0, _col3
- Statistics: Num rows: 60 Data size: 7257 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 29 Data size: 3627 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col0 (type: int), _col3 (type: int)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 60 Data size: 7257 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 29 Data size: 3627 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 60 Data size: 7257 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 29 Data size: 3627 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
Modified: hive/trunk/ql/src/test/results/clientpositive/tez/tez_dml.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/tez/tez_dml.q.out?rev=1643848&r1=1643847&r2=1643848&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/tez/tez_dml.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/tez/tez_dml.q.out Mon Dec 8 16:21:01 2014
@@ -47,21 +47,21 @@ STAGE PLANS:
keys: KEY._col0 (type: string)
mode: mergepartial
outputColumnNames: _col0, _col1
- Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col1 (type: bigint)
sort order: +
- Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
value expressions: _col0 (type: string)
Reducer 3
Reduce Operator Tree:
Select Operator
expressions: VALUE._col0 (type: string), KEY.reducesinkkey0 (type: bigint)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
Modified: hive/trunk/ql/src/test/results/clientpositive/tez/vector_mapjoin_reduce.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/tez/vector_mapjoin_reduce.q.out?rev=1643848&r1=1643847&r2=1643848&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/tez/vector_mapjoin_reduce.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/tez/vector_mapjoin_reduce.q.out Mon Dec 8 16:21:01 2014
@@ -93,7 +93,7 @@ STAGE PLANS:
keys: KEY._col0 (type: int)
mode: mergepartial
outputColumnNames: _col0
- Statistics: Num rows: 50 Data size: 5999 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 25 Data size: 2999 Basic stats: COMPLETE Column stats: NONE
Map Join Operator
condition map:
Inner Join 0 to 1
@@ -106,7 +106,7 @@ STAGE PLANS:
outputColumnNames: _col0, _col1, _col3
input vertices:
1 Map 3
- Statistics: Num rows: 55 Data size: 6598 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 27 Data size: 3298 Basic stats: COMPLETE Column stats: NONE
Map Join Operator
condition map:
Left Semi Join 0 to 1
@@ -119,14 +119,14 @@ STAGE PLANS:
outputColumnNames: _col0, _col3
input vertices:
1 Map 4
- Statistics: Num rows: 60 Data size: 7257 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 29 Data size: 3627 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col0 (type: int), _col3 (type: int)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 60 Data size: 7257 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 29 Data size: 3627 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 60 Data size: 7257 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 29 Data size: 3627 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -248,7 +248,7 @@ STAGE PLANS:
keys: KEY._col0 (type: int)
mode: mergepartial
outputColumnNames: _col0
- Statistics: Num rows: 50 Data size: 5999 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 25 Data size: 2999 Basic stats: COMPLETE Column stats: NONE
Map Join Operator
condition map:
Inner Join 0 to 1
@@ -261,7 +261,7 @@ STAGE PLANS:
outputColumnNames: _col0, _col1, _col3
input vertices:
1 Map 3
- Statistics: Num rows: 55 Data size: 6598 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 27 Data size: 3298 Basic stats: COMPLETE Column stats: NONE
Map Join Operator
condition map:
Left Semi Join 0 to 1
@@ -274,14 +274,14 @@ STAGE PLANS:
outputColumnNames: _col0, _col3
input vertices:
1 Map 4
- Statistics: Num rows: 60 Data size: 7257 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 29 Data size: 3627 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col0 (type: int), _col3 (type: int)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 60 Data size: 7257 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 29 Data size: 3627 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 60 Data size: 7257 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 29 Data size: 3627 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
Modified: hive/trunk/ql/src/test/results/clientpositive/tez/vector_orderby_5.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/tez/vector_orderby_5.q.out?rev=1643848&r1=1643847&r2=1643848&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/tez/vector_orderby_5.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/tez/vector_orderby_5.q.out Mon Dec 8 16:21:01 2014
@@ -148,11 +148,11 @@ STAGE PLANS:
keys: KEY._col0 (type: boolean)
mode: mergepartial
outputColumnNames: _col0, _col1
- Statistics: Num rows: 2000 Data size: 918712 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1000 Data size: 459356 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: boolean)
sort order: -
- Statistics: Num rows: 2000 Data size: 918712 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1000 Data size: 459356 Basic stats: COMPLETE Column stats: NONE
value expressions: _col1 (type: bigint)
Execution mode: vectorized
Reducer 3
@@ -160,10 +160,10 @@ STAGE PLANS:
Select Operator
expressions: KEY.reducesinkkey0 (type: boolean), VALUE._col0 (type: bigint)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 2000 Data size: 918712 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1000 Data size: 459356 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 2000 Data size: 918712 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1000 Data size: 459356 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
Modified: hive/trunk/ql/src/test/results/clientpositive/tez/vector_reduce_groupby_decimal.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/tez/vector_reduce_groupby_decimal.q.out?rev=1643848&r1=1643847&r2=1643848&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/tez/vector_reduce_groupby_decimal.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/tez/vector_reduce_groupby_decimal.q.out Mon Dec 8 16:21:01 2014
@@ -64,11 +64,11 @@ STAGE PLANS:
keys: KEY._col0 (type: int), KEY._col1 (type: double), KEY._col2 (type: decimal(20,10)), KEY._col3 (type: decimal(23,14))
mode: mergepartial
outputColumnNames: _col0, _col1, _col2, _col3, _col4
- Statistics: Num rows: 1526 Data size: 360136 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 763 Data size: 180068 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: int), _col1 (type: double), _col2 (type: decimal(20,10)), _col3 (type: decimal(23,14))
sort order: ++++
- Statistics: Num rows: 1526 Data size: 360136 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 763 Data size: 180068 Basic stats: COMPLETE Column stats: NONE
value expressions: _col4 (type: decimal(20,10))
Execution mode: vectorized
Reducer 3
@@ -76,7 +76,7 @@ STAGE PLANS:
Select Operator
expressions: KEY.reducesinkkey0 (type: int), KEY.reducesinkkey1 (type: double), KEY.reducesinkkey2 (type: decimal(20,10)), KEY.reducesinkkey3 (type: decimal(23,14)), VALUE._col0 (type: decimal(20,10))
outputColumnNames: _col0, _col1, _col2, _col3, _col4
- Statistics: Num rows: 1526 Data size: 360136 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 763 Data size: 180068 Basic stats: COMPLETE Column stats: NONE
Limit
Number of rows: 50
Statistics: Num rows: 50 Data size: 11800 Basic stats: COMPLETE Column stats: NONE
Modified: hive/trunk/ql/src/test/results/clientpositive/tez/vectorization_limit.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/tez/vectorization_limit.q.out?rev=1643848&r1=1643847&r2=1643848&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/tez/vectorization_limit.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/tez/vectorization_limit.q.out Mon Dec 8 16:21:01 2014
@@ -500,11 +500,11 @@ STAGE PLANS:
keys: KEY._col0 (type: double)
mode: mergepartial
outputColumnNames: _col0, _col1
- Statistics: Num rows: 6144 Data size: 188618 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 3072 Data size: 94309 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col1 (type: bigint), _col0 (type: double)
sort order: ++
- Statistics: Num rows: 6144 Data size: 188618 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 3072 Data size: 94309 Basic stats: COMPLETE Column stats: NONE
TopN Hash Memory Usage: 0.3
Execution mode: vectorized
Reducer 3
@@ -512,7 +512,7 @@ STAGE PLANS:
Select Operator
expressions: KEY.reducesinkkey1 (type: double), KEY.reducesinkkey0 (type: bigint)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 6144 Data size: 188618 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 3072 Data size: 94309 Basic stats: COMPLETE Column stats: NONE
Limit
Number of rows: 20
Statistics: Num rows: 20 Data size: 600 Basic stats: COMPLETE Column stats: NONE
Modified: hive/trunk/ql/src/test/results/clientpositive/tez/vectorized_dynamic_partition_pruning.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/tez/vectorized_dynamic_partition_pruning.q.out?rev=1643848&r1=1643847&r2=1643848&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/tez/vectorized_dynamic_partition_pruning.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/tez/vectorized_dynamic_partition_pruning.q.out Mon Dec 8 16:21:01 2014
@@ -1916,12 +1916,12 @@ STAGE PLANS:
keys: KEY._col0 (type: string)
mode: mergepartial
outputColumnNames: _col0
- Statistics: Num rows: 1000 Data size: 10624 Basic stats: COMPLETE Column stats: NONE
+ 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)
- Statistics: Num rows: 1000 Data size: 10624 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Execution mode: vectorized
Reducer 3
Reduce Operator Tree:
@@ -4318,25 +4318,25 @@ STAGE PLANS:
keys: KEY._col0 (type: string)
mode: mergepartial
outputColumnNames: _col0
- Statistics: Num rows: 1000 Data size: 10624 Basic stats: COMPLETE Column stats: NONE
+ 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)
- Statistics: Num rows: 1000 Data size: 10624 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col0 (type: string)
outputColumnNames: _col0
- Statistics: Num rows: 1000 Data size: 10624 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Group By Operator
keys: _col0 (type: string)
mode: hash
outputColumnNames: _col0
- Statistics: Num rows: 1000 Data size: 10624 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Dynamic Partitioning Event Operator
Target Input: srcpart
Partition key expr: ds
- Statistics: Num rows: 1000 Data size: 10624 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Target column: ds
Target Vertex: Map 3
Reducer 4
Modified: hive/trunk/ql/src/test/results/clientpositive/tez/vectorized_ptf.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/tez/vectorized_ptf.q.out?rev=1643848&r1=1643847&r2=1643848&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/tez/vectorized_ptf.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/tez/vectorized_ptf.q.out Mon Dec 8 16:21:01 2014
@@ -1771,12 +1771,12 @@ STAGE PLANS:
keys: KEY._col0 (type: string), KEY._col1 (type: string), KEY._col2 (type: int)
mode: mergepartial
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 26 Data size: 16042 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 13 Data size: 8021 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: string), _col1 (type: string)
sort order: ++
Map-reduce partition columns: _col0 (type: string)
- Statistics: Num rows: 26 Data size: 16042 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 13 Data size: 8021 Basic stats: COMPLETE Column stats: NONE
tag: -1
value expressions: _col0 (type: string), _col1 (type: string), _col2 (type: int)
auto parallelism: true
@@ -1785,19 +1785,19 @@ STAGE PLANS:
Needs Tagging: false
Reduce Operator Tree:
Extract
- Statistics: Num rows: 26 Data size: 16042 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 13 Data size: 8021 Basic stats: COMPLETE Column stats: NONE
PTF Operator
- Statistics: Num rows: 26 Data size: 16042 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 13 Data size: 8021 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col0 (type: string), _col1 (type: string), _col2 (type: int), _wcol0 (type: int), _wcol1 (type: int), _col2 (type: int), (_col2 - _wcol2) (type: int)
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6
- Statistics: Num rows: 26 Data size: 16042 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 13 Data size: 8021 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
GlobalTableId: 0
#### A masked pattern was here ####
NumFilesPerFileSink: 1
- Statistics: Num rows: 26 Data size: 16042 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 13 Data size: 8021 Basic stats: COMPLETE Column stats: NONE
#### A masked pattern was here ####
table:
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -4819,12 +4819,12 @@ STAGE PLANS:
keys: KEY._col0 (type: string), KEY._col1 (type: string)
mode: mergepartial
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 26 Data size: 16042 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 13 Data size: 8021 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: string), _col0 (type: string)
sort order: ++
Map-reduce partition columns: _col0 (type: string)
- Statistics: Num rows: 26 Data size: 16042 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 13 Data size: 8021 Basic stats: COMPLETE Column stats: NONE
tag: -1
value expressions: _col0 (type: string), _col1 (type: string), _col2 (type: double)
auto parallelism: true
@@ -4833,14 +4833,14 @@ STAGE PLANS:
Needs Tagging: false
Reduce Operator Tree:
Extract
- Statistics: Num rows: 26 Data size: 16042 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 13 Data size: 8021 Basic stats: COMPLETE Column stats: NONE
PTF Operator
- Statistics: Num rows: 26 Data size: 16042 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 13 Data size: 8021 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: string), _col1 (type: string)
sort order: ++
Map-reduce partition columns: _col0 (type: string)
- Statistics: Num rows: 26 Data size: 16042 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 13 Data size: 8021 Basic stats: COMPLETE Column stats: NONE
tag: -1
value expressions: _col0 (type: string), _col1 (type: string), _col2 (type: double)
auto parallelism: true
@@ -4848,19 +4848,19 @@ STAGE PLANS:
Needs Tagging: false
Reduce Operator Tree:
Extract
- Statistics: Num rows: 26 Data size: 16042 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 13 Data size: 8021 Basic stats: COMPLETE Column stats: NONE
PTF Operator
- Statistics: Num rows: 26 Data size: 16042 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 13 Data size: 8021 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col0 (type: string), _col1 (type: string), _col2 (type: double), _wcol0 (type: double)
outputColumnNames: _col0, _col1, _col2, _col3
- Statistics: Num rows: 26 Data size: 16042 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 13 Data size: 8021 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
GlobalTableId: 0
#### A masked pattern was here ####
NumFilesPerFileSink: 1
- Statistics: Num rows: 26 Data size: 16042 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 13 Data size: 8021 Basic stats: COMPLETE Column stats: NONE
#### A masked pattern was here ####
table:
input format: org.apache.hadoop.mapred.TextInputFormat
Modified: hive/trunk/ql/src/test/results/clientpositive/udtf_json_tuple.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/udtf_json_tuple.q.out?rev=1643848&r1=1643847&r2=1643848&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/udtf_json_tuple.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/udtf_json_tuple.q.out Mon Dec 8 16:21:01 2014
@@ -354,7 +354,7 @@ STAGE PLANS:
keys: KEY._col0 (type: string)
mode: mergepartial
outputColumnNames: _col0, _col1
- Statistics: Num rows: 9 Data size: 354 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 4 Data size: 157 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
table:
@@ -369,16 +369,16 @@ STAGE PLANS:
Reduce Output Operator
key expressions: _col0 (type: string)
sort order: +
- Statistics: Num rows: 9 Data size: 354 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 4 Data size: 157 Basic stats: COMPLETE Column stats: NONE
value expressions: _col1 (type: bigint)
Reduce Operator Tree:
Select Operator
expressions: KEY.reducesinkkey0 (type: string), VALUE._col0 (type: bigint)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 9 Data size: 354 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 4 Data size: 157 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 9 Data size: 354 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 4 Data size: 157 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
Modified: hive/trunk/ql/src/test/results/clientpositive/vector_char_2.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/vector_char_2.q.out?rev=1643848&r1=1643847&r2=1643848&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/vector_char_2.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/vector_char_2.q.out Mon Dec 8 16:21:01 2014
@@ -94,7 +94,7 @@ STAGE PLANS:
keys: KEY._col0 (type: char(20))
mode: mergepartial
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 500 Data size: 99000 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 250 Data size: 49500 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
table:
@@ -109,13 +109,13 @@ STAGE PLANS:
Reduce Output Operator
key expressions: _col0 (type: char(20))
sort order: +
- Statistics: Num rows: 500 Data size: 99000 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 250 Data size: 49500 Basic stats: COMPLETE Column stats: NONE
value expressions: _col1 (type: bigint), _col2 (type: bigint)
Reduce Operator Tree:
Select Operator
expressions: KEY.reducesinkkey0 (type: char(20)), VALUE._col0 (type: bigint), VALUE._col1 (type: bigint)
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 500 Data size: 99000 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 250 Data size: 49500 Basic stats: COMPLETE Column stats: NONE
Limit
Number of rows: 5
Statistics: Num rows: 5 Data size: 990 Basic stats: COMPLETE Column stats: NONE
@@ -224,7 +224,7 @@ STAGE PLANS:
keys: KEY._col0 (type: char(20))
mode: mergepartial
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 500 Data size: 99000 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 250 Data size: 49500 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
table:
@@ -239,13 +239,13 @@ STAGE PLANS:
Reduce Output Operator
key expressions: _col0 (type: char(20))
sort order: -
- Statistics: Num rows: 500 Data size: 99000 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 250 Data size: 49500 Basic stats: COMPLETE Column stats: NONE
value expressions: _col1 (type: bigint), _col2 (type: bigint)
Reduce Operator Tree:
Select Operator
expressions: KEY.reducesinkkey0 (type: char(20)), VALUE._col0 (type: bigint), VALUE._col1 (type: bigint)
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 500 Data size: 99000 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 250 Data size: 49500 Basic stats: COMPLETE Column stats: NONE
Limit
Number of rows: 5
Statistics: Num rows: 5 Data size: 990 Basic stats: COMPLETE Column stats: NONE
Modified: hive/trunk/ql/src/test/results/clientpositive/vector_decimal_aggregate.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/vector_decimal_aggregate.q.out?rev=1643848&r1=1643847&r2=1643848&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/vector_decimal_aggregate.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/vector_decimal_aggregate.q.out Mon Dec 8 16:21:01 2014
@@ -46,22 +46,22 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: decimal_vgby
- Statistics: Num rows: 561 Data size: 128041 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 12288 Data size: 2165060 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: cint (type: int), cdecimal1 (type: decimal(20,10)), cdecimal2 (type: decimal(23,14))
outputColumnNames: cint, cdecimal1, cdecimal2
- Statistics: Num rows: 561 Data size: 128041 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 12288 Data size: 2165060 Basic stats: COMPLETE Column stats: NONE
Group By Operator
aggregations: count(cdecimal1), max(cdecimal1), min(cdecimal1), sum(cdecimal1), count(cdecimal2), max(cdecimal2), min(cdecimal2), sum(cdecimal2), count()
keys: cint (type: int)
mode: hash
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9
- Statistics: Num rows: 561 Data size: 128041 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 12288 Data size: 2165060 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: int)
sort order: +
Map-reduce partition columns: _col0 (type: int)
- Statistics: Num rows: 561 Data size: 128041 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 12288 Data size: 2165060 Basic stats: COMPLETE Column stats: NONE
value expressions: _col1 (type: bigint), _col2 (type: decimal(20,10)), _col3 (type: decimal(20,10)), _col4 (type: decimal(30,10)), _col5 (type: bigint), _col6 (type: decimal(23,14)), _col7 (type: decimal(23,14)), _col8 (type: decimal(33,14)), _col9 (type: bigint)
Execution mode: vectorized
Reduce Operator Tree:
@@ -70,17 +70,17 @@ STAGE PLANS:
keys: KEY._col0 (type: int)
mode: mergepartial
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9
- Statistics: Num rows: 280 Data size: 63906 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 6144 Data size: 1082530 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: (_col9 > 1) (type: boolean)
- Statistics: Num rows: 93 Data size: 21225 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 2048 Data size: 360843 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col0 (type: int), _col1 (type: bigint), _col2 (type: decimal(20,10)), _col3 (type: decimal(20,10)), _col4 (type: decimal(30,10)), _col5 (type: bigint), _col6 (type: decimal(23,14)), _col7 (type: decimal(23,14)), _col8 (type: decimal(33,14))
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8
- Statistics: Num rows: 93 Data size: 21225 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 2048 Data size: 360843 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 93 Data size: 21225 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 2048 Data size: 360843 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -144,22 +144,22 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: decimal_vgby
- Statistics: Num rows: 561 Data size: 128041 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 12288 Data size: 2165060 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: cint (type: int), cdecimal1 (type: decimal(20,10)), cdecimal2 (type: decimal(23,14))
outputColumnNames: cint, cdecimal1, cdecimal2
- Statistics: Num rows: 561 Data size: 128041 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 12288 Data size: 2165060 Basic stats: COMPLETE Column stats: NONE
Group By Operator
aggregations: count(cdecimal1), max(cdecimal1), min(cdecimal1), sum(cdecimal1), avg(cdecimal1), stddev_pop(cdecimal1), stddev_samp(cdecimal1), count(cdecimal2), max(cdecimal2), min(cdecimal2), sum(cdecimal2), avg(cdecimal2), stddev_pop(cdecimal2), stddev_samp(cdecimal2), count()
keys: cint (type: int)
mode: hash
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10, _col11, _col12, _col13, _col14, _col15
- Statistics: Num rows: 561 Data size: 128041 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 12288 Data size: 2165060 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: int)
sort order: +
Map-reduce partition columns: _col0 (type: int)
- Statistics: Num rows: 561 Data size: 128041 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 12288 Data size: 2165060 Basic stats: COMPLETE Column stats: NONE
value expressions: _col1 (type: bigint), _col2 (type: decimal(20,10)), _col3 (type: decimal(20,10)), _col4 (type: decimal(30,10)), _col5 (type: struct<count:bigint,sum:decimal(30,10),input:decimal(20,10)>), _col6 (type: struct<count:bigint,sum:double,variance:double>), _col7 (type: struct<count:bigint,sum:double,variance:double>), _col8 (type: bigint), _col9 (type: decimal(23,14)), _col10 (type: decimal(23,14)), _col11 (type: decimal(33,14)), _col12 (type: struct<count:bigint,sum:decimal(33,14),input:decimal(23,14)>), _col13 (type: struct<count:bigint,sum:double,variance:double>), _col14 (type: struct<count:bigint,sum:double,variance:double>), _col15 (type: bigint)
Execution mode: vectorized
Reduce Operator Tree:
@@ -168,17 +168,17 @@ STAGE PLANS:
keys: KEY._col0 (type: int)
mode: mergepartial
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10, _col11, _col12, _col13, _col14, _col15
- Statistics: Num rows: 280 Data size: 63906 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 6144 Data size: 1082530 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: (_col15 > 1) (type: boolean)
- Statistics: Num rows: 93 Data size: 21225 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 2048 Data size: 360843 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col0 (type: int), _col1 (type: bigint), _col2 (type: decimal(20,10)), _col3 (type: decimal(20,10)), _col4 (type: decimal(30,10)), _col5 (type: decimal(24,14)), _col6 (type: double), _col7 (type: double), _col8 (type: bigint), _col9 (type: decimal(23,14)), _col10 (type: decimal(23,14)), _col11 (type: decimal(33,14)), _col12 (type: decimal(27,18)), _col13 (type: double), _col14 (type: double)
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10, _col11, _col12, _col13, _col14
- Statistics: Num rows: 93 Data size: 21225 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 2048 Data size: 360843 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 93 Data size: 21225 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 2048 Data size: 360843 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
Modified: hive/trunk/ql/src/test/results/clientpositive/vector_mapjoin_reduce.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/vector_mapjoin_reduce.q.out?rev=1643848&r1=1643847&r2=1643848&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/vector_mapjoin_reduce.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/vector_mapjoin_reduce.q.out Mon Dec 8 16:21:01 2014
@@ -53,7 +53,7 @@ STAGE PLANS:
keys: KEY._col0 (type: int)
mode: mergepartial
outputColumnNames: _col0
- Statistics: Num rows: 50 Data size: 5999 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 25 Data size: 2999 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
table:
@@ -123,7 +123,7 @@ STAGE PLANS:
0 _col0 (type: int)
1 l_partkey (type: int)
outputColumnNames: _col0, _col1, _col3
- Statistics: Num rows: 55 Data size: 6598 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 27 Data size: 3298 Basic stats: COMPLETE Column stats: NONE
Map Join Operator
condition map:
Left Semi Join 0 to 1
@@ -134,14 +134,14 @@ STAGE PLANS:
0 _col1 (type: int)
1 _col0 (type: int)
outputColumnNames: _col0, _col3
- Statistics: Num rows: 60 Data size: 7257 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 29 Data size: 3627 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col0 (type: int), _col3 (type: int)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 60 Data size: 7257 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 29 Data size: 3627 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 60 Data size: 7257 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 29 Data size: 3627 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -224,7 +224,7 @@ STAGE PLANS:
keys: KEY._col0 (type: int)
mode: mergepartial
outputColumnNames: _col0
- Statistics: Num rows: 50 Data size: 5999 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 25 Data size: 2999 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
table:
@@ -294,7 +294,7 @@ STAGE PLANS:
0 _col0 (type: int)
1 l_partkey (type: int)
outputColumnNames: _col0, _col1, _col3
- Statistics: Num rows: 55 Data size: 6598 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 27 Data size: 3298 Basic stats: COMPLETE Column stats: NONE
Map Join Operator
condition map:
Left Semi Join 0 to 1
@@ -305,14 +305,14 @@ STAGE PLANS:
0 _col1 (type: int), 1 (type: int)
1 _col0 (type: int), _col1 (type: int)
outputColumnNames: _col0, _col3
- Statistics: Num rows: 60 Data size: 7257 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 29 Data size: 3627 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col0 (type: int), _col3 (type: int)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 60 Data size: 7257 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 29 Data size: 3627 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 60 Data size: 7257 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 29 Data size: 3627 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
Modified: hive/trunk/ql/src/test/results/clientpositive/vector_orderby_5.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/vector_orderby_5.q.out?rev=1643848&r1=1643847&r2=1643848&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/vector_orderby_5.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/vector_orderby_5.q.out Mon Dec 8 16:21:01 2014
@@ -142,7 +142,7 @@ STAGE PLANS:
keys: KEY._col0 (type: boolean)
mode: mergepartial
outputColumnNames: _col0, _col1
- Statistics: Num rows: 2000 Data size: 918712 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1000 Data size: 459356 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
table:
@@ -157,16 +157,16 @@ STAGE PLANS:
Reduce Output Operator
key expressions: _col0 (type: boolean)
sort order: -
- Statistics: Num rows: 2000 Data size: 918712 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1000 Data size: 459356 Basic stats: COMPLETE Column stats: NONE
value expressions: _col1 (type: bigint)
Reduce Operator Tree:
Select Operator
expressions: KEY.reducesinkkey0 (type: boolean), VALUE._col0 (type: bigint)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 2000 Data size: 918712 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1000 Data size: 459356 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 2000 Data size: 918712 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1000 Data size: 459356 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
Modified: hive/trunk/ql/src/test/results/clientpositive/vector_reduce_groupby_decimal.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/vector_reduce_groupby_decimal.q.out?rev=1643848&r1=1643847&r2=1643848&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/vector_reduce_groupby_decimal.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/vector_reduce_groupby_decimal.q.out Mon Dec 8 16:21:01 2014
@@ -58,7 +58,7 @@ STAGE PLANS:
keys: KEY._col0 (type: int), KEY._col1 (type: double), KEY._col2 (type: decimal(20,10)), KEY._col3 (type: decimal(23,14))
mode: mergepartial
outputColumnNames: _col0, _col1, _col2, _col3, _col4
- Statistics: Num rows: 1526 Data size: 360136 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 763 Data size: 180068 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
table:
@@ -73,13 +73,13 @@ STAGE PLANS:
Reduce Output Operator
key expressions: _col0 (type: int), _col1 (type: double), _col2 (type: decimal(20,10)), _col3 (type: decimal(23,14))
sort order: ++++
- Statistics: Num rows: 1526 Data size: 360136 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 763 Data size: 180068 Basic stats: COMPLETE Column stats: NONE
value expressions: _col4 (type: decimal(20,10))
Reduce Operator Tree:
Select Operator
expressions: KEY.reducesinkkey0 (type: int), KEY.reducesinkkey1 (type: double), KEY.reducesinkkey2 (type: decimal(20,10)), KEY.reducesinkkey3 (type: decimal(23,14)), VALUE._col0 (type: decimal(20,10))
outputColumnNames: _col0, _col1, _col2, _col3, _col4
- Statistics: Num rows: 1526 Data size: 360136 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 763 Data size: 180068 Basic stats: COMPLETE Column stats: NONE
Limit
Number of rows: 50
Statistics: Num rows: 50 Data size: 11800 Basic stats: COMPLETE Column stats: NONE
Modified: hive/trunk/ql/src/test/results/clientpositive/vectorization_limit.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/vectorization_limit.q.out?rev=1643848&r1=1643847&r2=1643848&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/vectorization_limit.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/vectorization_limit.q.out Mon Dec 8 16:21:01 2014
@@ -485,7 +485,7 @@ STAGE PLANS:
keys: KEY._col0 (type: double)
mode: mergepartial
outputColumnNames: _col0, _col1
- Statistics: Num rows: 6144 Data size: 188618 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 3072 Data size: 94309 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
table:
@@ -500,13 +500,13 @@ STAGE PLANS:
Reduce Output Operator
key expressions: _col1 (type: bigint), _col0 (type: double)
sort order: ++
- Statistics: Num rows: 6144 Data size: 188618 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 3072 Data size: 94309 Basic stats: COMPLETE Column stats: NONE
TopN Hash Memory Usage: 0.3
Reduce Operator Tree:
Select Operator
expressions: KEY.reducesinkkey1 (type: double), KEY.reducesinkkey0 (type: bigint)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 6144 Data size: 188618 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 3072 Data size: 94309 Basic stats: COMPLETE Column stats: NONE
Limit
Number of rows: 20
Statistics: Num rows: 20 Data size: 600 Basic stats: COMPLETE Column stats: NONE