You are viewing a plain text version of this content. The canonical link for it is here.
Posted to common-commits@hadoop.apache.org by dh...@apache.org on 2008/10/21 20:11:18 UTC
svn commit: r706704 [7/23] - in /hadoop/core/trunk: ./ src/contrib/hive/
src/contrib/hive/bin/
src/contrib/hive/cli/src/java/org/apache/hadoop/hive/cli/
src/contrib/hive/common/src/java/org/apache/hadoop/hive/conf/
src/contrib/hive/conf/ src/contrib/hi...
Added: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input11_limit.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input11_limit.q.out?rev=706704&view=auto
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input11_limit.q.out (added)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input11_limit.q.out Tue Oct 21 11:11:05 2008
@@ -0,0 +1,51 @@
+ABSTRACT SYNTAX TREE:
+ (TOK_QUERY (TOK_FROM (TOK_TABREF src)) (TOK_INSERT (TOK_DESTINATION (TOK_TAB dest1)) (TOK_SELECT (TOK_SELEXPR (TOK_COLREF src key)) (TOK_SELEXPR (TOK_COLREF src value))) (TOK_WHERE (< (TOK_COLREF src key) 100)) (TOK_LIMIT 10)))
+
+STAGE DEPENDENCIES:
+ Stage-1 is a root stage
+ Stage-0 depends on stages: Stage-1
+
+STAGE PLANS:
+ Stage: Stage-1
+ Map Reduce
+ Alias -> Map Operator Tree:
+ src
+ Filter Operator
+ predicate:
+ expr: (key < 100)
+ type: Boolean
+ Select Operator
+ expressions:
+ expr: key
+ type: string
+ expr: value
+ type: string
+ Limit
+ File Output Operator
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+ name: dest1
+
+ Stage: Stage-0
+ Move Operator
+ tables:
+ replace:
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+ name: dest1
+
+
+86 val_86
+27 val_27
+98 val_98
+66 val_66
+37 val_37
+15 val_15
+82 val_82
+17 val_17
+0 val_0
+57 val_57
Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input12.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input12.q.out?rev=706704&r1=706703&r2=706704&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input12.q.out (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input12.q.out Tue Oct 21 11:11:05 2008
@@ -22,10 +22,10 @@
type: string
File Output Operator
table:
- name: dest1
- serde: simple_meta
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+ name: dest1
Filter Operator
predicate:
expr: ((key >= 100) and (key < 200))
@@ -38,10 +38,10 @@
type: string
File Output Operator
table:
- name: dest2
- serde: simple_meta
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+ name: dest2
Filter Operator
predicate:
expr: (key >= 200)
@@ -52,35 +52,35 @@
type: string
File Output Operator
table:
- name: dest3
- serde: simple_meta
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+ name: dest3
Stage: Stage-0
Move Operator
tables:
- table:
- name: dest1
- serde: simple_meta
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
replace:
table:
- name: dest2
- serde: simple_meta
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+ name: dest1
replace:
table:
- name: dest3
- serde: simple_meta
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+ name: dest2
partition:
ds 2008-04-08
hr 12
replace:
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+ name: dest3
86 val_86
@@ -167,7 +167,6 @@
37 val_37
90 val_90
97 val_97
-
165 val_165
193 val_193
150 val_150
@@ -273,7 +272,6 @@
194 val_194
126 val_126
169 val_169
-
238 NULL 2008-04-08 12
311 NULL 2008-04-08 12
409 NULL 2008-04-08 12
@@ -585,4 +583,3 @@
403 NULL 2008-04-08 12
400 NULL 2008-04-08 12
200 NULL 2008-04-08 12
-
Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input13.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input13.q.out?rev=706704&r1=706703&r2=706704&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input13.q.out (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input13.q.out Tue Oct 21 11:11:05 2008
@@ -22,10 +22,10 @@
type: string
File Output Operator
table:
- name: dest1
- serde: simple_meta
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+ name: dest1
Filter Operator
predicate:
expr: ((key >= 100) and (key < 200))
@@ -38,10 +38,10 @@
type: string
File Output Operator
table:
- name: dest2
- serde: simple_meta
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+ name: dest2
Filter Operator
predicate:
expr: ((key >= 200) and (key < 300))
@@ -52,10 +52,10 @@
type: string
File Output Operator
table:
- name: dest3
- serde: simple_meta
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+ name: dest3
Filter Operator
predicate:
expr: (key >= 300)
@@ -71,31 +71,31 @@
Stage: Stage-0
Move Operator
+ files:
+ hdfs directory:
+ destination: ../../../../build/contrib/hive/ql/test/data/warehouse/dest4.out
tables:
- table:
- name: dest1
- serde: simple_meta
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
replace:
table:
- name: dest2
- serde: simple_meta
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+ name: dest1
replace:
table:
- name: dest3
- serde: simple_meta
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+ name: dest2
partition:
ds 2008-04-08
hr 12
replace:
- files:
- destination: ../../../../build/contrib/hive/ql/test/data/warehouse/dest4.out
- hdfs directory:
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+ name: dest3
86 val_86
@@ -182,7 +182,6 @@
37 val_37
90 val_90
97 val_97
-
165 val_165
193 val_193
150 val_150
@@ -288,7 +287,6 @@
194 val_194
126 val_126
169 val_169
-
238 NULL 2008-04-08 12
255 NULL 2008-04-08 12
278 NULL 2008-04-08 12
@@ -392,7 +390,6 @@
281 NULL 2008-04-08 12
222 NULL 2008-04-08 12
200 NULL 2008-04-08 12
-
val_311
val_409
val_484
Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input14.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input14.q.out?rev=706704&r1=706703&r2=706704&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input14.q.out (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input14.q.out Tue Oct 21 11:11:05 2008
@@ -8,24 +8,6 @@
STAGE PLANS:
Stage: Stage-1
Map Reduce
- Reduce Operator Tree:
- Extract
- Filter Operator
- predicate:
- expr: (0 < 100)
- type: Boolean
- Select Operator
- expressions:
- expr: 0
- type: string
- expr: 1
- type: string
- File Output Operator
- table:
- name: dest1
- serde: simple_meta
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
Alias -> Map Operator Tree:
tmap:src
Select Operator
@@ -40,26 +22,44 @@
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
Reduce Output Operator
- tag: -1
key expressions:
expr: tkey
type: string
+ # partition fields: 1
+ tag: -1
value expressions:
expr: tkey
type: string
expr: tvalue
type: string
- # partition fields: 1
+ Reduce Operator Tree:
+ Extract
+ Filter Operator
+ predicate:
+ expr: (0 < 100)
+ type: Boolean
+ Select Operator
+ expressions:
+ expr: 0
+ type: string
+ expr: 1
+ type: string
+ File Output Operator
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+ name: dest1
Stage: Stage-0
Move Operator
tables:
+ replace:
table:
- name: dest1
- serde: simple_meta
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
- replace:
+ serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+ name: dest1
0 val_0
@@ -146,4 +146,3 @@
97 val_97
98 val_98
98 val_98
-
Added: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input14_limit.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input14_limit.q.out?rev=706704&view=auto
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input14_limit.q.out (added)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input14_limit.q.out Tue Oct 21 11:11:05 2008
@@ -0,0 +1,95 @@
+ABSTRACT SYNTAX TREE:
+ (TOK_QUERY (TOK_FROM (TOK_SUBQUERY (TOK_QUERY (TOK_FROM (TOK_TABREF src)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_TRANSFORM (TOK_COLLIST (TOK_COLREF src key) (TOK_COLREF src value)) (TOK_ALIASLIST tkey tvalue) '/bin/cat'))) (TOK_CLUSTERBY tkey) (TOK_LIMIT 20))) tmap)) (TOK_INSERT (TOK_DESTINATION (TOK_TAB dest1)) (TOK_SELECT (TOK_SELEXPR (TOK_COLREF tmap tkey)) (TOK_SELEXPR (TOK_COLREF tmap tvalue))) (TOK_WHERE (< (TOK_COLREF tmap tkey) 100))))
+
+STAGE DEPENDENCIES:
+ Stage-1 is a root stage
+ Stage-2 depends on stages: Stage-1
+ Stage-0 depends on stages: Stage-2
+
+STAGE PLANS:
+ Stage: Stage-1
+ Map Reduce
+ Alias -> Map Operator Tree:
+ tmap:src
+ Select Operator
+ expressions:
+ expr: key
+ type: string
+ expr: value
+ type: string
+ Transform Operator
+ command: /bin/cat
+ output info:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ Reduce Output Operator
+ key expressions:
+ expr: tkey
+ type: string
+ # partition fields: 1
+ tag: -1
+ value expressions:
+ expr: tkey
+ type: string
+ expr: tvalue
+ type: string
+ Reduce Operator Tree:
+ Extract
+ Limit
+ File Output Operator
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+
+ Stage: Stage-2
+ Map Reduce
+ Alias -> Map Operator Tree:
+ /tmp/hive-njain/945772770/1814909502.10001
+ Reduce Output Operator
+ key expressions:
+ expr: 0
+ type: string
+ # partition fields: 1
+ tag: -1
+ value expressions:
+ expr: 0
+ type: string
+ expr: 1
+ type: string
+ # Reducers: 1
+ Reduce Operator Tree:
+ Extract
+ Limit
+ Filter Operator
+ predicate:
+ expr: (0 < 100)
+ type: Boolean
+ Select Operator
+ expressions:
+ expr: 0
+ type: string
+ expr: 1
+ type: string
+ File Output Operator
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+ name: dest1
+
+ Stage: Stage-0
+ Move Operator
+ tables:
+ replace:
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+ name: dest1
+
+
+0 val_0
+0 val_0
+0 val_0
+10 val_10
+11 val_11
Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input15.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input15.q.out?rev=706704&r1=706703&r2=706704&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input15.q.out (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input15.q.out Tue Oct 21 11:11:05 2008
@@ -8,12 +8,12 @@
Stage: Stage-0
Create Table Operator:
Create Table
- isExternal:
- name: TEST15
- # buckets: -1
+ columns: key int, value string
field delimiter:
+ # buckets: -1
+ name: TEST15
+ isExternal:
isSequenceFile:
- columns: key int, value string
key int
Added: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input16.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input16.q.out?rev=706704&view=auto
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input16.q.out (added)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input16.q.out Tue Oct 21 11:11:05 2008
@@ -0,0 +1,500 @@
+val_238 238
+val_86 86
+val_311 311
+val_27 27
+val_165 165
+val_409 409
+val_255 255
+val_278 278
+val_98 98
+val_484 484
+val_265 265
+val_193 193
+val_401 401
+val_150 150
+val_273 273
+val_224 224
+val_369 369
+val_66 66
+val_128 128
+val_213 213
+val_146 146
+val_406 406
+val_429 429
+val_374 374
+val_152 152
+val_469 469
+val_145 145
+val_495 495
+val_37 37
+val_327 327
+val_281 281
+val_277 277
+val_209 209
+val_15 15
+val_82 82
+val_403 403
+val_166 166
+val_417 417
+val_430 430
+val_252 252
+val_292 292
+val_219 219
+val_287 287
+val_153 153
+val_193 193
+val_338 338
+val_446 446
+val_459 459
+val_394 394
+val_237 237
+val_482 482
+val_174 174
+val_413 413
+val_494 494
+val_207 207
+val_199 199
+val_466 466
+val_208 208
+val_174 174
+val_399 399
+val_396 396
+val_247 247
+val_417 417
+val_489 489
+val_162 162
+val_377 377
+val_397 397
+val_309 309
+val_365 365
+val_266 266
+val_439 439
+val_342 342
+val_367 367
+val_325 325
+val_167 167
+val_195 195
+val_475 475
+val_17 17
+val_113 113
+val_155 155
+val_203 203
+val_339 339
+val_0 0
+val_455 455
+val_128 128
+val_311 311
+val_316 316
+val_57 57
+val_302 302
+val_205 205
+val_149 149
+val_438 438
+val_345 345
+val_129 129
+val_170 170
+val_20 20
+val_489 489
+val_157 157
+val_378 378
+val_221 221
+val_92 92
+val_111 111
+val_47 47
+val_72 72
+val_4 4
+val_280 280
+val_35 35
+val_427 427
+val_277 277
+val_208 208
+val_356 356
+val_399 399
+val_169 169
+val_382 382
+val_498 498
+val_125 125
+val_386 386
+val_437 437
+val_469 469
+val_192 192
+val_286 286
+val_187 187
+val_176 176
+val_54 54
+val_459 459
+val_51 51
+val_138 138
+val_103 103
+val_239 239
+val_213 213
+val_216 216
+val_430 430
+val_278 278
+val_176 176
+val_289 289
+val_221 221
+val_65 65
+val_318 318
+val_332 332
+val_311 311
+val_275 275
+val_137 137
+val_241 241
+val_83 83
+val_333 333
+val_180 180
+val_284 284
+val_12 12
+val_230 230
+val_181 181
+val_67 67
+val_260 260
+val_404 404
+val_384 384
+val_489 489
+val_353 353
+val_373 373
+val_272 272
+val_138 138
+val_217 217
+val_84 84
+val_348 348
+val_466 466
+val_58 58
+val_8 8
+val_411 411
+val_230 230
+val_208 208
+val_348 348
+val_24 24
+val_463 463
+val_431 431
+val_179 179
+val_172 172
+val_42 42
+val_129 129
+val_158 158
+val_119 119
+val_496 496
+val_0 0
+val_322 322
+val_197 197
+val_468 468
+val_393 393
+val_454 454
+val_100 100
+val_298 298
+val_199 199
+val_191 191
+val_418 418
+val_96 96
+val_26 26
+val_165 165
+val_327 327
+val_230 230
+val_205 205
+val_120 120
+val_131 131
+val_51 51
+val_404 404
+val_43 43
+val_436 436
+val_156 156
+val_469 469
+val_468 468
+val_308 308
+val_95 95
+val_196 196
+val_288 288
+val_481 481
+val_457 457
+val_98 98
+val_282 282
+val_197 197
+val_187 187
+val_318 318
+val_318 318
+val_409 409
+val_470 470
+val_137 137
+val_369 369
+val_316 316
+val_169 169
+val_413 413
+val_85 85
+val_77 77
+val_0 0
+val_490 490
+val_87 87
+val_364 364
+val_179 179
+val_118 118
+val_134 134
+val_395 395
+val_282 282
+val_138 138
+val_238 238
+val_419 419
+val_15 15
+val_118 118
+val_72 72
+val_90 90
+val_307 307
+val_19 19
+val_435 435
+val_10 10
+val_277 277
+val_273 273
+val_306 306
+val_224 224
+val_309 309
+val_389 389
+val_327 327
+val_242 242
+val_369 369
+val_392 392
+val_272 272
+val_331 331
+val_401 401
+val_242 242
+val_452 452
+val_177 177
+val_226 226
+val_5 5
+val_497 497
+val_402 402
+val_396 396
+val_317 317
+val_395 395
+val_58 58
+val_35 35
+val_336 336
+val_95 95
+val_11 11
+val_168 168
+val_34 34
+val_229 229
+val_233 233
+val_143 143
+val_472 472
+val_322 322
+val_498 498
+val_160 160
+val_195 195
+val_42 42
+val_321 321
+val_430 430
+val_119 119
+val_489 489
+val_458 458
+val_78 78
+val_76 76
+val_41 41
+val_223 223
+val_492 492
+val_149 149
+val_449 449
+val_218 218
+val_228 228
+val_138 138
+val_453 453
+val_30 30
+val_209 209
+val_64 64
+val_468 468
+val_76 76
+val_74 74
+val_342 342
+val_69 69
+val_230 230
+val_33 33
+val_368 368
+val_103 103
+val_296 296
+val_113 113
+val_216 216
+val_367 367
+val_344 344
+val_167 167
+val_274 274
+val_219 219
+val_239 239
+val_485 485
+val_116 116
+val_223 223
+val_256 256
+val_263 263
+val_70 70
+val_487 487
+val_480 480
+val_401 401
+val_288 288
+val_191 191
+val_5 5
+val_244 244
+val_438 438
+val_128 128
+val_467 467
+val_432 432
+val_202 202
+val_316 316
+val_229 229
+val_469 469
+val_463 463
+val_280 280
+val_2 2
+val_35 35
+val_283 283
+val_331 331
+val_235 235
+val_80 80
+val_44 44
+val_193 193
+val_321 321
+val_335 335
+val_104 104
+val_466 466
+val_366 366
+val_175 175
+val_403 403
+val_483 483
+val_53 53
+val_105 105
+val_257 257
+val_406 406
+val_409 409
+val_190 190
+val_406 406
+val_401 401
+val_114 114
+val_258 258
+val_90 90
+val_203 203
+val_262 262
+val_348 348
+val_424 424
+val_12 12
+val_396 396
+val_201 201
+val_217 217
+val_164 164
+val_431 431
+val_454 454
+val_478 478
+val_298 298
+val_125 125
+val_431 431
+val_164 164
+val_424 424
+val_187 187
+val_382 382
+val_5 5
+val_70 70
+val_397 397
+val_480 480
+val_291 291
+val_24 24
+val_351 351
+val_255 255
+val_104 104
+val_70 70
+val_163 163
+val_438 438
+val_119 119
+val_414 414
+val_200 200
+val_491 491
+val_237 237
+val_439 439
+val_360 360
+val_248 248
+val_479 479
+val_305 305
+val_417 417
+val_199 199
+val_444 444
+val_120 120
+val_429 429
+val_169 169
+val_443 443
+val_323 323
+val_325 325
+val_277 277
+val_230 230
+val_478 478
+val_178 178
+val_468 468
+val_310 310
+val_317 317
+val_333 333
+val_493 493
+val_460 460
+val_207 207
+val_249 249
+val_265 265
+val_480 480
+val_83 83
+val_136 136
+val_353 353
+val_172 172
+val_214 214
+val_462 462
+val_233 233
+val_406 406
+val_133 133
+val_175 175
+val_189 189
+val_454 454
+val_375 375
+val_401 401
+val_421 421
+val_407 407
+val_384 384
+val_256 256
+val_26 26
+val_134 134
+val_67 67
+val_384 384
+val_379 379
+val_18 18
+val_462 462
+val_492 492
+val_100 100
+val_298 298
+val_9 9
+val_341 341
+val_498 498
+val_146 146
+val_458 458
+val_362 362
+val_186 186
+val_285 285
+val_348 348
+val_167 167
+val_18 18
+val_273 273
+val_183 183
+val_281 281
+val_344 344
+val_97 97
+val_469 469
+val_315 315
+val_84 84
+val_28 28
+val_37 37
+val_448 448
+val_152 152
+val_348 348
+val_307 307
+val_194 194
+val_414 414
+val_477 477
+val_222 222
+val_126 126
+val_90 90
+val_169 169
+val_403 403
+val_400 400
+val_200 200
+val_97 97
Added: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input16_cc.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input16_cc.q.out?rev=706704&view=auto
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input16_cc.q.out (added)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input16_cc.q.out Tue Oct 21 11:11:05 2008
@@ -0,0 +1,500 @@
+val_238 238
+val_86 86
+val_311 311
+val_27 27
+val_165 165
+val_409 409
+val_255 255
+val_278 278
+val_98 98
+val_484 484
+val_265 265
+val_193 193
+val_401 401
+val_150 150
+val_273 273
+val_224 224
+val_369 369
+val_66 66
+val_128 128
+val_213 213
+val_146 146
+val_406 406
+val_429 429
+val_374 374
+val_152 152
+val_469 469
+val_145 145
+val_495 495
+val_37 37
+val_327 327
+val_281 281
+val_277 277
+val_209 209
+val_15 15
+val_82 82
+val_403 403
+val_166 166
+val_417 417
+val_430 430
+val_252 252
+val_292 292
+val_219 219
+val_287 287
+val_153 153
+val_193 193
+val_338 338
+val_446 446
+val_459 459
+val_394 394
+val_237 237
+val_482 482
+val_174 174
+val_413 413
+val_494 494
+val_207 207
+val_199 199
+val_466 466
+val_208 208
+val_174 174
+val_399 399
+val_396 396
+val_247 247
+val_417 417
+val_489 489
+val_162 162
+val_377 377
+val_397 397
+val_309 309
+val_365 365
+val_266 266
+val_439 439
+val_342 342
+val_367 367
+val_325 325
+val_167 167
+val_195 195
+val_475 475
+val_17 17
+val_113 113
+val_155 155
+val_203 203
+val_339 339
+val_0 0
+val_455 455
+val_128 128
+val_311 311
+val_316 316
+val_57 57
+val_302 302
+val_205 205
+val_149 149
+val_438 438
+val_345 345
+val_129 129
+val_170 170
+val_20 20
+val_489 489
+val_157 157
+val_378 378
+val_221 221
+val_92 92
+val_111 111
+val_47 47
+val_72 72
+val_4 4
+val_280 280
+val_35 35
+val_427 427
+val_277 277
+val_208 208
+val_356 356
+val_399 399
+val_169 169
+val_382 382
+val_498 498
+val_125 125
+val_386 386
+val_437 437
+val_469 469
+val_192 192
+val_286 286
+val_187 187
+val_176 176
+val_54 54
+val_459 459
+val_51 51
+val_138 138
+val_103 103
+val_239 239
+val_213 213
+val_216 216
+val_430 430
+val_278 278
+val_176 176
+val_289 289
+val_221 221
+val_65 65
+val_318 318
+val_332 332
+val_311 311
+val_275 275
+val_137 137
+val_241 241
+val_83 83
+val_333 333
+val_180 180
+val_284 284
+val_12 12
+val_230 230
+val_181 181
+val_67 67
+val_260 260
+val_404 404
+val_384 384
+val_489 489
+val_353 353
+val_373 373
+val_272 272
+val_138 138
+val_217 217
+val_84 84
+val_348 348
+val_466 466
+val_58 58
+val_8 8
+val_411 411
+val_230 230
+val_208 208
+val_348 348
+val_24 24
+val_463 463
+val_431 431
+val_179 179
+val_172 172
+val_42 42
+val_129 129
+val_158 158
+val_119 119
+val_496 496
+val_0 0
+val_322 322
+val_197 197
+val_468 468
+val_393 393
+val_454 454
+val_100 100
+val_298 298
+val_199 199
+val_191 191
+val_418 418
+val_96 96
+val_26 26
+val_165 165
+val_327 327
+val_230 230
+val_205 205
+val_120 120
+val_131 131
+val_51 51
+val_404 404
+val_43 43
+val_436 436
+val_156 156
+val_469 469
+val_468 468
+val_308 308
+val_95 95
+val_196 196
+val_288 288
+val_481 481
+val_457 457
+val_98 98
+val_282 282
+val_197 197
+val_187 187
+val_318 318
+val_318 318
+val_409 409
+val_470 470
+val_137 137
+val_369 369
+val_316 316
+val_169 169
+val_413 413
+val_85 85
+val_77 77
+val_0 0
+val_490 490
+val_87 87
+val_364 364
+val_179 179
+val_118 118
+val_134 134
+val_395 395
+val_282 282
+val_138 138
+val_238 238
+val_419 419
+val_15 15
+val_118 118
+val_72 72
+val_90 90
+val_307 307
+val_19 19
+val_435 435
+val_10 10
+val_277 277
+val_273 273
+val_306 306
+val_224 224
+val_309 309
+val_389 389
+val_327 327
+val_242 242
+val_369 369
+val_392 392
+val_272 272
+val_331 331
+val_401 401
+val_242 242
+val_452 452
+val_177 177
+val_226 226
+val_5 5
+val_497 497
+val_402 402
+val_396 396
+val_317 317
+val_395 395
+val_58 58
+val_35 35
+val_336 336
+val_95 95
+val_11 11
+val_168 168
+val_34 34
+val_229 229
+val_233 233
+val_143 143
+val_472 472
+val_322 322
+val_498 498
+val_160 160
+val_195 195
+val_42 42
+val_321 321
+val_430 430
+val_119 119
+val_489 489
+val_458 458
+val_78 78
+val_76 76
+val_41 41
+val_223 223
+val_492 492
+val_149 149
+val_449 449
+val_218 218
+val_228 228
+val_138 138
+val_453 453
+val_30 30
+val_209 209
+val_64 64
+val_468 468
+val_76 76
+val_74 74
+val_342 342
+val_69 69
+val_230 230
+val_33 33
+val_368 368
+val_103 103
+val_296 296
+val_113 113
+val_216 216
+val_367 367
+val_344 344
+val_167 167
+val_274 274
+val_219 219
+val_239 239
+val_485 485
+val_116 116
+val_223 223
+val_256 256
+val_263 263
+val_70 70
+val_487 487
+val_480 480
+val_401 401
+val_288 288
+val_191 191
+val_5 5
+val_244 244
+val_438 438
+val_128 128
+val_467 467
+val_432 432
+val_202 202
+val_316 316
+val_229 229
+val_469 469
+val_463 463
+val_280 280
+val_2 2
+val_35 35
+val_283 283
+val_331 331
+val_235 235
+val_80 80
+val_44 44
+val_193 193
+val_321 321
+val_335 335
+val_104 104
+val_466 466
+val_366 366
+val_175 175
+val_403 403
+val_483 483
+val_53 53
+val_105 105
+val_257 257
+val_406 406
+val_409 409
+val_190 190
+val_406 406
+val_401 401
+val_114 114
+val_258 258
+val_90 90
+val_203 203
+val_262 262
+val_348 348
+val_424 424
+val_12 12
+val_396 396
+val_201 201
+val_217 217
+val_164 164
+val_431 431
+val_454 454
+val_478 478
+val_298 298
+val_125 125
+val_431 431
+val_164 164
+val_424 424
+val_187 187
+val_382 382
+val_5 5
+val_70 70
+val_397 397
+val_480 480
+val_291 291
+val_24 24
+val_351 351
+val_255 255
+val_104 104
+val_70 70
+val_163 163
+val_438 438
+val_119 119
+val_414 414
+val_200 200
+val_491 491
+val_237 237
+val_439 439
+val_360 360
+val_248 248
+val_479 479
+val_305 305
+val_417 417
+val_199 199
+val_444 444
+val_120 120
+val_429 429
+val_169 169
+val_443 443
+val_323 323
+val_325 325
+val_277 277
+val_230 230
+val_478 478
+val_178 178
+val_468 468
+val_310 310
+val_317 317
+val_333 333
+val_493 493
+val_460 460
+val_207 207
+val_249 249
+val_265 265
+val_480 480
+val_83 83
+val_136 136
+val_353 353
+val_172 172
+val_214 214
+val_462 462
+val_233 233
+val_406 406
+val_133 133
+val_175 175
+val_189 189
+val_454 454
+val_375 375
+val_401 401
+val_421 421
+val_407 407
+val_384 384
+val_256 256
+val_26 26
+val_134 134
+val_67 67
+val_384 384
+val_379 379
+val_18 18
+val_462 462
+val_492 492
+val_100 100
+val_298 298
+val_9 9
+val_341 341
+val_498 498
+val_146 146
+val_458 458
+val_362 362
+val_186 186
+val_285 285
+val_348 348
+val_167 167
+val_18 18
+val_273 273
+val_183 183
+val_281 281
+val_344 344
+val_97 97
+val_469 469
+val_315 315
+val_84 84
+val_28 28
+val_37 37
+val_448 448
+val_152 152
+val_348 348
+val_307 307
+val_194 194
+val_414 414
+val_477 477
+val_222 222
+val_126 126
+val_90 90
+val_169 169
+val_403 403
+val_400 400
+val_200 200
+val_97 97
Added: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input1_limit.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input1_limit.q.out?rev=706704&view=auto
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input1_limit.q.out (added)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input1_limit.q.out Tue Oct 21 11:11:05 2008
@@ -0,0 +1,79 @@
+ABSTRACT SYNTAX TREE:
+ (TOK_QUERY (TOK_FROM (TOK_TABREF src)) (TOK_INSERT (TOK_DESTINATION (TOK_TAB dest1)) (TOK_SELECT (TOK_SELEXPR (TOK_COLREF src key)) (TOK_SELEXPR (TOK_COLREF src value))) (TOK_WHERE (< (TOK_COLREF src key) 100)) (TOK_LIMIT 10)) (TOK_INSERT (TOK_DESTINATION (TOK_TAB dest2)) (TOK_SELECT (TOK_SELEXPR (TOK_COLREF src key)) (TOK_SELEXPR (TOK_COLREF src value))) (TOK_WHERE (< (TOK_COLREF src key) 100)) (TOK_LIMIT 5)))
+
+STAGE DEPENDENCIES:
+ Stage-1 is a root stage
+ Stage-0 depends on stages: Stage-1
+
+STAGE PLANS:
+ Stage: Stage-1
+ Map Reduce
+ Alias -> Map Operator Tree:
+ src
+ Filter Operator
+ predicate:
+ expr: (key < 100)
+ type: Boolean
+ Select Operator
+ expressions:
+ expr: key
+ type: string
+ expr: value
+ type: string
+ Limit
+ File Output Operator
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+ name: dest1
+ Filter Operator
+ predicate:
+ expr: (key < 100)
+ type: Boolean
+ Select Operator
+ expressions:
+ expr: key
+ type: string
+ expr: value
+ type: string
+ Limit
+ File Output Operator
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+ name: dest2
+
+ Stage: Stage-0
+ Move Operator
+ tables:
+ replace:
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+ name: dest1
+ replace:
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+ name: dest2
+
+
+86 val_86
+27 val_27
+98 val_98
+66 val_66
+37 val_37
+15 val_15
+82 val_82
+17 val_17
+0 val_0
+57 val_57
+86 val_86
+27 val_27
+98 val_98
+66 val_66
+37 val_37
Added: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input2_limit.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input2_limit.q.out?rev=706704&view=auto
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input2_limit.q.out (added)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input2_limit.q.out Tue Oct 21 11:11:05 2008
@@ -0,0 +1,38 @@
+ABSTRACT SYNTAX TREE:
+ (TOK_QUERY (TOK_FROM (TOK_TABREF SRC x)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_ALLCOLREF x))) (TOK_WHERE (< (TOK_COLREF x key) 300)) (TOK_LIMIT 5)))
+
+STAGE DEPENDENCIES:
+ Stage-1 is a root stage
+ Stage-0 is a root stage
+
+STAGE PLANS:
+ Stage: Stage-1
+ Map Reduce
+ Alias -> Map Operator Tree:
+ x
+ Filter Operator
+ predicate:
+ expr: (key < 300)
+ type: Boolean
+ Select Operator
+ expressions:
+ expr: key
+ type: string
+ expr: value
+ type: string
+ Limit
+ File Output Operator
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+
+ Stage: Stage-0
+ Fetch Operator
+ limit: 5
+
+
+238 val_238
+86 val_86
+27 val_27
+165 val_165
+255 val_255
Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input3.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input3.q.out?rev=706704&r1=706703&r2=706704&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input3.q.out (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input3.q.out Tue Oct 21 11:11:05 2008
@@ -14,9 +14,9 @@
Stage: Stage-0
Alter Table Operator:
Alter Table
- old name: TEST3b
type: add columns
- new columns: a array<int>, b float, c map<float,int>, X float
+ new columns: X float
+ old name: TEST3b
a array<int>
@@ -33,9 +33,9 @@
Stage: Stage-0
Alter Table Operator:
Alter Table
- old name: TEST3b
- new name: TEST3c
type: rename
+ new name: TEST3c
+ old name: TEST3b
a array<int>
@@ -43,3 +43,22 @@
c map<float,int>
x float
src src1 src_sequencefile src_thrift srcbucket srcpart test3a test3c
+ABSTRACT SYNTAX TREE:
+ (TOK_ALTERTABLE_REPLACECOLS TEST3c (TOK_TABCOLLIST (TOK_TABCOL R1 TOK_INT) (TOK_TABCOL R2 TOK_FLOAT)))
+
+STAGE DEPENDENCIES:
+ Stage-0 is a root stage
+
+STAGE PLANS:
+ Stage: Stage-0
+ Alter Table Operator:
+ Alter Table
+ type: replace columns
+ new columns: R1 int, R2 float
+ old name: TEST3c
+
+
+r1 int
+r2 float
+Detailed Table Information:
+Table(tableName:test3c,dbName:default,owner:njain,createTime:1224285029,lastAccessTime:0,retention:0,sd:StorageDescriptor(cols:[FieldSchema(name:r1,type:int,comment:null), FieldSchema(name:r2,type:float,comment:null)],location:file:/home/njain/workspace/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/test3b,inputFormat:org.apache.hadoop.mapred.TextInputFormat,outputFormat:org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat,compressed:false,numBuckets:-1,serdeInfo:SerDeInfo(name:null,serializationLib:org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe,parameters:{serialization.format=1}),bucketCols:[],sortCols:[],parameters:{}),partitionKeys:[],parameters:{last_modified_by=njain,last_modified_time=1224285029,SORTBUCKETCOLSPREFIX=TRUE})
Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input4.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input4.q.out?rev=706704&r1=706703&r2=706704&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input4.q.out (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input4.q.out Tue Oct 21 11:11:05 2008
@@ -8,18 +8,18 @@
STAGE PLANS:
Stage: Stage-0
Copy
- source: file:/data/zshao/trunk/VENDOR/hadoop-0.17/src/contrib/hive/data/files/kv1.txt
- destination: file:/tmp/hive-zshao/-1658380790
+ source: file:/home/njain/workspace/hadoop-0.17/src/contrib/hive/data/files/kv1.txt
+ destination: file:/tmp/hive-njain/-478939701
Stage: Stage-1
Move Operator
tables:
+ replace:
table:
- name: input4
- serde: simple_meta
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
- replace:
+ serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+ name: input4
val_238 238
@@ -522,4 +522,3 @@
val_400 400
val_200 200
val_97 97
-
Added: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input4_cb_delim.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input4_cb_delim.q.out?rev=706704&view=auto
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input4_cb_delim.q.out (added)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input4_cb_delim.q.out Tue Oct 21 11:11:05 2008
@@ -0,0 +1,500 @@
+val_238 238
+val_86 86
+val_311 311
+val_27 27
+val_165 165
+val_409 409
+val_255 255
+val_278 278
+val_98 98
+val_484 484
+val_265 265
+val_193 193
+val_401 401
+val_150 150
+val_273 273
+val_224 224
+val_369 369
+val_66 66
+val_128 128
+val_213 213
+val_146 146
+val_406 406
+val_429 429
+val_374 374
+val_152 152
+val_469 469
+val_145 145
+val_495 495
+val_37 37
+val_327 327
+val_281 281
+val_277 277
+val_209 209
+val_15 15
+val_82 82
+val_403 403
+val_166 166
+val_417 417
+val_430 430
+val_252 252
+val_292 292
+val_219 219
+val_287 287
+val_153 153
+val_193 193
+val_338 338
+val_446 446
+val_459 459
+val_394 394
+val_237 237
+val_482 482
+val_174 174
+val_413 413
+val_494 494
+val_207 207
+val_199 199
+val_466 466
+val_208 208
+val_174 174
+val_399 399
+val_396 396
+val_247 247
+val_417 417
+val_489 489
+val_162 162
+val_377 377
+val_397 397
+val_309 309
+val_365 365
+val_266 266
+val_439 439
+val_342 342
+val_367 367
+val_325 325
+val_167 167
+val_195 195
+val_475 475
+val_17 17
+val_113 113
+val_155 155
+val_203 203
+val_339 339
+val_0 0
+val_455 455
+val_128 128
+val_311 311
+val_316 316
+val_57 57
+val_302 302
+val_205 205
+val_149 149
+val_438 438
+val_345 345
+val_129 129
+val_170 170
+val_20 20
+val_489 489
+val_157 157
+val_378 378
+val_221 221
+val_92 92
+val_111 111
+val_47 47
+val_72 72
+val_4 4
+val_280 280
+val_35 35
+val_427 427
+val_277 277
+val_208 208
+val_356 356
+val_399 399
+val_169 169
+val_382 382
+val_498 498
+val_125 125
+val_386 386
+val_437 437
+val_469 469
+val_192 192
+val_286 286
+val_187 187
+val_176 176
+val_54 54
+val_459 459
+val_51 51
+val_138 138
+val_103 103
+val_239 239
+val_213 213
+val_216 216
+val_430 430
+val_278 278
+val_176 176
+val_289 289
+val_221 221
+val_65 65
+val_318 318
+val_332 332
+val_311 311
+val_275 275
+val_137 137
+val_241 241
+val_83 83
+val_333 333
+val_180 180
+val_284 284
+val_12 12
+val_230 230
+val_181 181
+val_67 67
+val_260 260
+val_404 404
+val_384 384
+val_489 489
+val_353 353
+val_373 373
+val_272 272
+val_138 138
+val_217 217
+val_84 84
+val_348 348
+val_466 466
+val_58 58
+val_8 8
+val_411 411
+val_230 230
+val_208 208
+val_348 348
+val_24 24
+val_463 463
+val_431 431
+val_179 179
+val_172 172
+val_42 42
+val_129 129
+val_158 158
+val_119 119
+val_496 496
+val_0 0
+val_322 322
+val_197 197
+val_468 468
+val_393 393
+val_454 454
+val_100 100
+val_298 298
+val_199 199
+val_191 191
+val_418 418
+val_96 96
+val_26 26
+val_165 165
+val_327 327
+val_230 230
+val_205 205
+val_120 120
+val_131 131
+val_51 51
+val_404 404
+val_43 43
+val_436 436
+val_156 156
+val_469 469
+val_468 468
+val_308 308
+val_95 95
+val_196 196
+val_288 288
+val_481 481
+val_457 457
+val_98 98
+val_282 282
+val_197 197
+val_187 187
+val_318 318
+val_318 318
+val_409 409
+val_470 470
+val_137 137
+val_369 369
+val_316 316
+val_169 169
+val_413 413
+val_85 85
+val_77 77
+val_0 0
+val_490 490
+val_87 87
+val_364 364
+val_179 179
+val_118 118
+val_134 134
+val_395 395
+val_282 282
+val_138 138
+val_238 238
+val_419 419
+val_15 15
+val_118 118
+val_72 72
+val_90 90
+val_307 307
+val_19 19
+val_435 435
+val_10 10
+val_277 277
+val_273 273
+val_306 306
+val_224 224
+val_309 309
+val_389 389
+val_327 327
+val_242 242
+val_369 369
+val_392 392
+val_272 272
+val_331 331
+val_401 401
+val_242 242
+val_452 452
+val_177 177
+val_226 226
+val_5 5
+val_497 497
+val_402 402
+val_396 396
+val_317 317
+val_395 395
+val_58 58
+val_35 35
+val_336 336
+val_95 95
+val_11 11
+val_168 168
+val_34 34
+val_229 229
+val_233 233
+val_143 143
+val_472 472
+val_322 322
+val_498 498
+val_160 160
+val_195 195
+val_42 42
+val_321 321
+val_430 430
+val_119 119
+val_489 489
+val_458 458
+val_78 78
+val_76 76
+val_41 41
+val_223 223
+val_492 492
+val_149 149
+val_449 449
+val_218 218
+val_228 228
+val_138 138
+val_453 453
+val_30 30
+val_209 209
+val_64 64
+val_468 468
+val_76 76
+val_74 74
+val_342 342
+val_69 69
+val_230 230
+val_33 33
+val_368 368
+val_103 103
+val_296 296
+val_113 113
+val_216 216
+val_367 367
+val_344 344
+val_167 167
+val_274 274
+val_219 219
+val_239 239
+val_485 485
+val_116 116
+val_223 223
+val_256 256
+val_263 263
+val_70 70
+val_487 487
+val_480 480
+val_401 401
+val_288 288
+val_191 191
+val_5 5
+val_244 244
+val_438 438
+val_128 128
+val_467 467
+val_432 432
+val_202 202
+val_316 316
+val_229 229
+val_469 469
+val_463 463
+val_280 280
+val_2 2
+val_35 35
+val_283 283
+val_331 331
+val_235 235
+val_80 80
+val_44 44
+val_193 193
+val_321 321
+val_335 335
+val_104 104
+val_466 466
+val_366 366
+val_175 175
+val_403 403
+val_483 483
+val_53 53
+val_105 105
+val_257 257
+val_406 406
+val_409 409
+val_190 190
+val_406 406
+val_401 401
+val_114 114
+val_258 258
+val_90 90
+val_203 203
+val_262 262
+val_348 348
+val_424 424
+val_12 12
+val_396 396
+val_201 201
+val_217 217
+val_164 164
+val_431 431
+val_454 454
+val_478 478
+val_298 298
+val_125 125
+val_431 431
+val_164 164
+val_424 424
+val_187 187
+val_382 382
+val_5 5
+val_70 70
+val_397 397
+val_480 480
+val_291 291
+val_24 24
+val_351 351
+val_255 255
+val_104 104
+val_70 70
+val_163 163
+val_438 438
+val_119 119
+val_414 414
+val_200 200
+val_491 491
+val_237 237
+val_439 439
+val_360 360
+val_248 248
+val_479 479
+val_305 305
+val_417 417
+val_199 199
+val_444 444
+val_120 120
+val_429 429
+val_169 169
+val_443 443
+val_323 323
+val_325 325
+val_277 277
+val_230 230
+val_478 478
+val_178 178
+val_468 468
+val_310 310
+val_317 317
+val_333 333
+val_493 493
+val_460 460
+val_207 207
+val_249 249
+val_265 265
+val_480 480
+val_83 83
+val_136 136
+val_353 353
+val_172 172
+val_214 214
+val_462 462
+val_233 233
+val_406 406
+val_133 133
+val_175 175
+val_189 189
+val_454 454
+val_375 375
+val_401 401
+val_421 421
+val_407 407
+val_384 384
+val_256 256
+val_26 26
+val_134 134
+val_67 67
+val_384 384
+val_379 379
+val_18 18
+val_462 462
+val_492 492
+val_100 100
+val_298 298
+val_9 9
+val_341 341
+val_498 498
+val_146 146
+val_458 458
+val_362 362
+val_186 186
+val_285 285
+val_348 348
+val_167 167
+val_18 18
+val_273 273
+val_183 183
+val_281 281
+val_344 344
+val_97 97
+val_469 469
+val_315 315
+val_84 84
+val_28 28
+val_37 37
+val_448 448
+val_152 152
+val_348 348
+val_307 307
+val_194 194
+val_414 414
+val_477 477
+val_222 222
+val_126 126
+val_90 90
+val_169 169
+val_403 403
+val_400 400
+val_200 200
+val_97 97
Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input5.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input5.q.out?rev=706704&r1=706703&r2=706704&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input5.q.out (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input5.q.out Tue Oct 21 11:11:05 2008
@@ -8,20 +8,6 @@
STAGE PLANS:
Stage: Stage-1
Map Reduce
- Reduce Operator Tree:
- Extract
- Select Operator
- expressions:
- expr: 0
- type: string
- expr: 1
- type: string
- File Output Operator
- table:
- name: dest1
- serde: simple_meta
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
Alias -> Map Operator Tree:
tmap:src_thrift
Select Operator
@@ -36,26 +22,40 @@
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
Reduce Output Operator
- tag: -1
key expressions:
expr: tkey
type: string
+ # partition fields: 1
+ tag: -1
value expressions:
expr: tkey
type: string
expr: tvalue
type: string
- # partition fields: 1
+ Reduce Operator Tree:
+ Extract
+ Select Operator
+ expressions:
+ expr: 0
+ type: string
+ expr: 1
+ type: string
+ File Output Operator
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+ name: dest1
Stage: Stage-0
Move Operator
tables:
+ replace:
table:
- name: dest1
- serde: simple_meta
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
- replace:
+ serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+ name: dest1
[0,0,0] [{"myint":0,"mystring":"0"}]
@@ -68,4 +68,3 @@
[7,14,21] [{"myint":49,"mystring":"343"}]
[8,16,24] [{"myint":64,"mystring":"512"}]
[9,18,27] [{"myint":81,"mystring":"729"}]
-
Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input6.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input6.q.out?rev=706704&r1=706703&r2=706704&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input6.q.out (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input6.q.out Tue Oct 21 11:11:05 2008
@@ -22,19 +22,19 @@
type: string
File Output Operator
table:
- name: dest1
- serde: simple_meta
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+ name: dest1
Stage: Stage-0
Move Operator
tables:
+ replace:
table:
- name: dest1
- serde: simple_meta
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
- replace:
+ serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+ name: dest1
Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input7.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input7.q.out?rev=706704&r1=706703&r2=706704&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input7.q.out (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input7.q.out Tue Oct 21 11:11:05 2008
@@ -18,34 +18,34 @@
type: string
File Output Operator
table:
- name: dest1
- serde: simple_meta
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+ name: dest1
Stage: Stage-0
Move Operator
tables:
+ replace:
table:
- name: dest1
- serde: simple_meta
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
- replace:
+ serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+ name: dest1
NULL 238
-NULL NULL
+NULL
NULL 311
-NULL NULL
-NULL NULL
-NULL NULL
+NULL
+NULL
+NULL
NULL 255
NULL 278
NULL 98
-NULL NULL
-NULL NULL
-NULL NULL
+NULL
+NULL
+NULL
NULL 401
NULL 150
NULL 273
@@ -56,7 +56,6 @@
NULL 213
NULL 146
NULL 406
-NULL NULL
-NULL NULL
-NULL NULL
-
+NULL
+NULL
+NULL
Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input8.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input8.q.out?rev=706704&r1=706703&r2=706704&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input8.q.out (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input8.q.out Tue Oct 21 11:11:05 2008
@@ -20,20 +20,20 @@
type: Byte
File Output Operator
table:
- name: dest1
- serde: simple_meta
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+ name: dest1
Stage: Stage-0
Move Operator
tables:
+ replace:
table:
- name: dest1
- serde: simple_meta
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
- replace:
+ serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+ name: dest1
NULL NULL NULL
@@ -61,4 +61,3 @@
NULL NULL NULL
NULL NULL NULL
NULL NULL NULL
-
Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input9.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input9.q.out?rev=706704&r1=706703&r2=706704&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input9.q.out (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input9.q.out Tue Oct 21 11:11:05 2008
@@ -22,19 +22,19 @@
type: string
File Output Operator
table:
- name: dest1
- serde: simple_meta
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+ name: dest1
Stage: Stage-0
Move Operator
tables:
+ replace:
table:
- name: dest1
- serde: simple_meta
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
- replace:
+ serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+ name: dest1
Added: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input_dfs.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input_dfs.q.out?rev=706704&view=auto
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input_dfs.q.out (added)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input_dfs.q.out Tue Oct 21 11:11:05 2008
@@ -0,0 +1,500 @@
+238val_238
+86val_86
+311val_311
+27val_27
+165val_165
+409val_409
+255val_255
+278val_278
+98val_98
+484val_484
+265val_265
+193val_193
+401val_401
+150val_150
+273val_273
+224val_224
+369val_369
+66val_66
+128val_128
+213val_213
+146val_146
+406val_406
+429val_429
+374val_374
+152val_152
+469val_469
+145val_145
+495val_495
+37val_37
+327val_327
+281val_281
+277val_277
+209val_209
+15val_15
+82val_82
+403val_403
+166val_166
+417val_417
+430val_430
+252val_252
+292val_292
+219val_219
+287val_287
+153val_153
+193val_193
+338val_338
+446val_446
+459val_459
+394val_394
+237val_237
+482val_482
+174val_174
+413val_413
+494val_494
+207val_207
+199val_199
+466val_466
+208val_208
+174val_174
+399val_399
+396val_396
+247val_247
+417val_417
+489val_489
+162val_162
+377val_377
+397val_397
+309val_309
+365val_365
+266val_266
+439val_439
+342val_342
+367val_367
+325val_325
+167val_167
+195val_195
+475val_475
+17val_17
+113val_113
+155val_155
+203val_203
+339val_339
+0val_0
+455val_455
+128val_128
+311val_311
+316val_316
+57val_57
+302val_302
+205val_205
+149val_149
+438val_438
+345val_345
+129val_129
+170val_170
+20val_20
+489val_489
+157val_157
+378val_378
+221val_221
+92val_92
+111val_111
+47val_47
+72val_72
+4val_4
+280val_280
+35val_35
+427val_427
+277val_277
+208val_208
+356val_356
+399val_399
+169val_169
+382val_382
+498val_498
+125val_125
+386val_386
+437val_437
+469val_469
+192val_192
+286val_286
+187val_187
+176val_176
+54val_54
+459val_459
+51val_51
+138val_138
+103val_103
+239val_239
+213val_213
+216val_216
+430val_430
+278val_278
+176val_176
+289val_289
+221val_221
+65val_65
+318val_318
+332val_332
+311val_311
+275val_275
+137val_137
+241val_241
+83val_83
+333val_333
+180val_180
+284val_284
+12val_12
+230val_230
+181val_181
+67val_67
+260val_260
+404val_404
+384val_384
+489val_489
+353val_353
+373val_373
+272val_272
+138val_138
+217val_217
+84val_84
+348val_348
+466val_466
+58val_58
+8val_8
+411val_411
+230val_230
+208val_208
+348val_348
+24val_24
+463val_463
+431val_431
+179val_179
+172val_172
+42val_42
+129val_129
+158val_158
+119val_119
+496val_496
+0val_0
+322val_322
+197val_197
+468val_468
+393val_393
+454val_454
+100val_100
+298val_298
+199val_199
+191val_191
+418val_418
+96val_96
+26val_26
+165val_165
+327val_327
+230val_230
+205val_205
+120val_120
+131val_131
+51val_51
+404val_404
+43val_43
+436val_436
+156val_156
+469val_469
+468val_468
+308val_308
+95val_95
+196val_196
+288val_288
+481val_481
+457val_457
+98val_98
+282val_282
+197val_197
+187val_187
+318val_318
+318val_318
+409val_409
+470val_470
+137val_137
+369val_369
+316val_316
+169val_169
+413val_413
+85val_85
+77val_77
+0val_0
+490val_490
+87val_87
+364val_364
+179val_179
+118val_118
+134val_134
+395val_395
+282val_282
+138val_138
+238val_238
+419val_419
+15val_15
+118val_118
+72val_72
+90val_90
+307val_307
+19val_19
+435val_435
+10val_10
+277val_277
+273val_273
+306val_306
+224val_224
+309val_309
+389val_389
+327val_327
+242val_242
+369val_369
+392val_392
+272val_272
+331val_331
+401val_401
+242val_242
+452val_452
+177val_177
+226val_226
+5val_5
+497val_497
+402val_402
+396val_396
+317val_317
+395val_395
+58val_58
+35val_35
+336val_336
+95val_95
+11val_11
+168val_168
+34val_34
+229val_229
+233val_233
+143val_143
+472val_472
+322val_322
+498val_498
+160val_160
+195val_195
+42val_42
+321val_321
+430val_430
+119val_119
+489val_489
+458val_458
+78val_78
+76val_76
+41val_41
+223val_223
+492val_492
+149val_149
+449val_449
+218val_218
+228val_228
+138val_138
+453val_453
+30val_30
+209val_209
+64val_64
+468val_468
+76val_76
+74val_74
+342val_342
+69val_69
+230val_230
+33val_33
+368val_368
+103val_103
+296val_296
+113val_113
+216val_216
+367val_367
+344val_344
+167val_167
+274val_274
+219val_219
+239val_239
+485val_485
+116val_116
+223val_223
+256val_256
+263val_263
+70val_70
+487val_487
+480val_480
+401val_401
+288val_288
+191val_191
+5val_5
+244val_244
+438val_438
+128val_128
+467val_467
+432val_432
+202val_202
+316val_316
+229val_229
+469val_469
+463val_463
+280val_280
+2val_2
+35val_35
+283val_283
+331val_331
+235val_235
+80val_80
+44val_44
+193val_193
+321val_321
+335val_335
+104val_104
+466val_466
+366val_366
+175val_175
+403val_403
+483val_483
+53val_53
+105val_105
+257val_257
+406val_406
+409val_409
+190val_190
+406val_406
+401val_401
+114val_114
+258val_258
+90val_90
+203val_203
+262val_262
+348val_348
+424val_424
+12val_12
+396val_396
+201val_201
+217val_217
+164val_164
+431val_431
+454val_454
+478val_478
+298val_298
+125val_125
+431val_431
+164val_164
+424val_424
+187val_187
+382val_382
+5val_5
+70val_70
+397val_397
+480val_480
+291val_291
+24val_24
+351val_351
+255val_255
+104val_104
+70val_70
+163val_163
+438val_438
+119val_119
+414val_414
+200val_200
+491val_491
+237val_237
+439val_439
+360val_360
+248val_248
+479val_479
+305val_305
+417val_417
+199val_199
+444val_444
+120val_120
+429val_429
+169val_169
+443val_443
+323val_323
+325val_325
+277val_277
+230val_230
+478val_478
+178val_178
+468val_468
+310val_310
+317val_317
+333val_333
+493val_493
+460val_460
+207val_207
+249val_249
+265val_265
+480val_480
+83val_83
+136val_136
+353val_353
+172val_172
+214val_214
+462val_462
+233val_233
+406val_406
+133val_133
+175val_175
+189val_189
+454val_454
+375val_375
+401val_401
+421val_421
+407val_407
+384val_384
+256val_256
+26val_26
+134val_134
+67val_67
+384val_384
+379val_379
+18val_18
+462val_462
+492val_492
+100val_100
+298val_298
+9val_9
+341val_341
+498val_498
+146val_146
+458val_458
+362val_362
+186val_186
+285val_285
+348val_348
+167val_167
+18val_18
+273val_273
+183val_183
+281val_281
+344val_344
+97val_97
+469val_469
+315val_315
+84val_84
+28val_28
+37val_37
+448val_448
+152val_152
+348val_348
+307val_307
+194val_194
+414val_414
+477val_477
+222val_222
+126val_126
+90val_90
+169val_169
+403val_403
+400val_400
+200val_200
+97val_97
Added: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input_dynamicserde.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input_dynamicserde.q.out?rev=706704&view=auto
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input_dynamicserde.q.out (added)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input_dynamicserde.q.out Tue Oct 21 11:11:05 2008
@@ -0,0 +1,52 @@
+ABSTRACT SYNTAX TREE:
+ (TOK_QUERY (TOK_FROM (TOK_TABREF src_thrift)) (TOK_INSERT (TOK_DESTINATION (TOK_TAB dest1)) (TOK_SELECT (TOK_SELEXPR (TOK_COLREF src_thrift lint)) (TOK_SELEXPR (TOK_COLREF src_thrift lstring)) (TOK_SELEXPR (TOK_COLREF src_thrift mstringstring)) (TOK_SELEXPR (TOK_COLREF src_thrift aint)) (TOK_SELEXPR (TOK_COLREF src_thrift astring)))))
+
+STAGE DEPENDENCIES:
+ Stage-1 is a root stage
+ Stage-0 depends on stages: Stage-1
+
+STAGE PLANS:
+ Stage: Stage-1
+ Map Reduce
+ Alias -> Map Operator Tree:
+ src_thrift
+ Select Operator
+ expressions:
+ expr: lint
+ type: array<int>
+ expr: lstring
+ type: array<string>
+ expr: mstringstring
+ type: map<string,string>
+ expr: aint
+ type: int
+ expr: astring
+ type: string
+ File Output Operator
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ serde: org.apache.hadoop.hive.serde2.dynamic_type.DynamicSerDe
+ name: dest1
+
+ Stage: Stage-0
+ Move Operator
+ tables:
+ replace:
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ serde: org.apache.hadoop.hive.serde2.dynamic_type.DynamicSerDe
+ name: dest1
+
+
+[0,0,0] ["0","0","0"] {"key_0":"value_0"} -1220068486 record_0
+[1,2,3] ["10","100","1000"] {"key_1":"value_1"} -1147582750 record_1
+[2,4,6] ["20","200","2000"] {"key_2":"value_2"} -2091002570 record_2
+[3,6,9] ["30","300","3000"] {"key_3":"value_3"} -1587372273 record_3
+[4,8,12] ["40","400","4000"] {"key_4":"value_4"} -240543265 record_4
+[5,10,15] ["50","500","5000"] {"key_5":"value_5"} 1914724537 record_5
+[6,12,18] ["60","600","6000"] {"key_6":"value_6"} -1281615210 record_6
+[7,14,21] ["70","700","7000"] {"key_7":"value_7"} 1539139264 record_7
+[8,16,24] ["80","800","8000"] {"key_8":"value_8"} -1103622763 record_8
+[9,18,27] ["90","900","9000"] {"key_9":"value_9"} -1883609167 record_9
Added: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input_limit.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input_limit.q.out?rev=706704&view=auto
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input_limit.q.out (added)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input_limit.q.out Tue Oct 21 11:11:05 2008
@@ -0,0 +1,32 @@
+ABSTRACT SYNTAX TREE:
+ (TOK_QUERY (TOK_FROM (TOK_TABREF SRC x)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_ALLCOLREF x))) (TOK_LIMIT 20)))
+
+STAGE DEPENDENCIES:
+ Stage-0 is a root stage
+
+STAGE PLANS:
+ Stage: Stage-0
+ Fetch Operator
+ limit: 20
+
+
+238 val_238
+86 val_86
+311 val_311
+27 val_27
+165 val_165
+409 val_409
+255 val_255
+278 val_278
+98 val_98
+484 val_484
+265 val_265
+193 val_193
+401 val_401
+150 val_150
+273 val_273
+224 val_224
+369 val_369
+66 val_66
+128 val_128
+213 val_213
Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input_part1.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input_part1.q.out?rev=706704&r1=706703&r2=706704&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input_part1.q.out (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input_part1.q.out Tue Oct 21 11:11:05 2008
@@ -25,21 +25,70 @@
expr: ds
type: string
File Output Operator
+ directory: /tmp/hive-njain/13222008/293248514.10000.insclause-0
table:
- name: dest1
- serde: simple_meta
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ properties:
+ name dest1
+ serialization.ddl struct dest1 { i32 key, string value, string hr, string ds}
+ serialization.format 1
+ columns key,value,hr,ds
+ SORTBUCKETCOLSPREFIX TRUE
+ bucket_count -1
+ serialization.lib org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+ file.inputformat org.apache.hadoop.mapred.TextInputFormat
+ file.outputformat org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ location file:/home/njain/workspace/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/dest1
+ serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+ name: dest1
+ Needs Tagging:
+ Path -> Alias:
+ file:/home/njain/workspace/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12
+ Path -> Partition:
+ file:/home/njain/workspace/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12
+ Partition
+ partition values:
+ ds 2008-04-08
+ hr 12
+
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ properties:
+ name srcpart
+ serialization.ddl struct srcpart { string key, string value}
+ serialization.format 1
+ columns key,value
+ partition_columns ds/hr
+ bucket_count -1
+ serialization.lib org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+ file.inputformat org.apache.hadoop.mapred.TextInputFormat
+ file.outputformat org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ location file:/home/njain/workspace/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/srcpart
+ serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+ name: srcpart
Stage: Stage-0
Move Operator
tables:
+ replace:
+ source: /tmp/hive-njain/13222008/293248514.10000.insclause-0
table:
- name: dest1
- serde: simple_meta
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
- replace:
+ properties:
+ name dest1
+ serialization.ddl struct dest1 { i32 key, string value, string hr, string ds}
+ serialization.format 1
+ columns key,value,hr,ds
+ SORTBUCKETCOLSPREFIX TRUE
+ bucket_count -1
+ serialization.lib org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+ file.inputformat org.apache.hadoop.mapred.TextInputFormat
+ file.outputformat org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ location file:/home/njain/workspace/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/dest1
+ serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+ name: dest1
86 val_86 12 2008-04-08
@@ -126,4 +175,3 @@
37 val_37 12 2008-04-08
90 val_90 12 2008-04-08
97 val_97 12 2008-04-08
-
Added: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input_part2.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input_part2.q.out?rev=706704&view=auto
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input_part2.q.out (added)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input_part2.q.out Tue Oct 21 11:11:05 2008
@@ -0,0 +1,333 @@
+ABSTRACT SYNTAX TREE:
+ (TOK_QUERY (TOK_FROM (TOK_TABREF srcpart)) (TOK_INSERT (TOK_DESTINATION (TOK_TAB dest1)) (TOK_SELECT (TOK_SELEXPR (TOK_COLREF srcpart key)) (TOK_SELEXPR (TOK_COLREF srcpart value)) (TOK_SELEXPR (TOK_COLREF srcpart hr)) (TOK_SELEXPR (TOK_COLREF srcpart ds))) (TOK_WHERE (and (and (< (TOK_COLREF srcpart key) 100) (= (TOK_COLREF srcpart ds) '2008-04-08')) (= (TOK_COLREF srcpart hr) '12')))) (TOK_INSERT (TOK_DESTINATION (TOK_TAB dest2)) (TOK_SELECT (TOK_SELEXPR (TOK_COLREF srcpart key)) (TOK_SELEXPR (TOK_COLREF srcpart value)) (TOK_SELEXPR (TOK_COLREF srcpart hr)) (TOK_SELEXPR (TOK_COLREF srcpart ds))) (TOK_WHERE (and (and (< (TOK_COLREF srcpart key) 100) (= (TOK_COLREF srcpart ds) '2008-04-09')) (= (TOK_COLREF srcpart hr) '12')))))
+
+STAGE DEPENDENCIES:
+ Stage-1 is a root stage
+ Stage-0 depends on stages: Stage-1
+
+STAGE PLANS:
+ Stage: Stage-1
+ Map Reduce
+ Alias -> Map Operator Tree:
+ srcpart
+ Filter Operator
+ predicate:
+ expr: (((key < 100) and (ds = '2008-04-08')) and (hr = '12'))
+ type: Boolean
+ Select Operator
+ expressions:
+ expr: key
+ type: string
+ expr: value
+ type: string
+ expr: hr
+ type: string
+ expr: ds
+ type: string
+ File Output Operator
+ directory: /tmp/hive-njain/925269835/11972654.10000.insclause-0
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ properties:
+ name dest1
+ serialization.ddl struct dest1 { i32 key, string value, string hr, string ds}
+ serialization.format 1
+ columns key,value,hr,ds
+ SORTBUCKETCOLSPREFIX TRUE
+ bucket_count -1
+ serialization.lib org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+ file.inputformat org.apache.hadoop.mapred.TextInputFormat
+ file.outputformat org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ location file:/home/njain/workspace/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/dest1
+ serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+ name: dest1
+ Filter Operator
+ predicate:
+ expr: (((key < 100) and (ds = '2008-04-09')) and (hr = '12'))
+ type: Boolean
+ Select Operator
+ expressions:
+ expr: key
+ type: string
+ expr: value
+ type: string
+ expr: hr
+ type: string
+ expr: ds
+ type: string
+ File Output Operator
+ directory: /tmp/hive-njain/925269835/11972654.10001.insclause-1
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ properties:
+ name dest2
+ serialization.ddl struct dest2 { i32 key, string value, string hr, string ds}
+ serialization.format 1
+ columns key,value,hr,ds
+ SORTBUCKETCOLSPREFIX TRUE
+ bucket_count -1
+ serialization.lib org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+ file.inputformat org.apache.hadoop.mapred.TextInputFormat
+ file.outputformat org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ location file:/home/njain/workspace/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/dest2
+ serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+ name: dest2
+ Needs Tagging:
+ Path -> Alias:
+ file:/home/njain/workspace/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12
+ file:/home/njain/workspace/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/srcpart/ds=2008-04-09/hr=12
+ Path -> Partition:
+ file:/home/njain/workspace/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12
+ Partition
+ partition values:
+ ds 2008-04-08
+ hr 12
+
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ properties:
+ name srcpart
+ serialization.ddl struct srcpart { string key, string value}
+ serialization.format 1
+ columns key,value
+ partition_columns ds/hr
+ bucket_count -1
+ serialization.lib org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+ file.inputformat org.apache.hadoop.mapred.TextInputFormat
+ file.outputformat org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ location file:/home/njain/workspace/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/srcpart
+ serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+ name: srcpart
+ file:/home/njain/workspace/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/srcpart/ds=2008-04-09/hr=12
+ Partition
+ partition values:
+ ds 2008-04-09
+ hr 12
+
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ properties:
+ name srcpart
+ serialization.ddl struct srcpart { string key, string value}
+ serialization.format 1
+ columns key,value
+ partition_columns ds/hr
+ bucket_count -1
+ serialization.lib org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+ file.inputformat org.apache.hadoop.mapred.TextInputFormat
+ file.outputformat org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ location file:/home/njain/workspace/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/srcpart
+ serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+ name: srcpart
+
+ Stage: Stage-0
+ Move Operator
+ tables:
+ replace:
+ source: /tmp/hive-njain/925269835/11972654.10000.insclause-0
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ properties:
+ name dest1
+ serialization.ddl struct dest1 { i32 key, string value, string hr, string ds}
+ serialization.format 1
+ columns key,value,hr,ds
+ SORTBUCKETCOLSPREFIX TRUE
+ bucket_count -1
+ serialization.lib org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+ file.inputformat org.apache.hadoop.mapred.TextInputFormat
+ file.outputformat org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ location file:/home/njain/workspace/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/dest1
+ serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+ name: dest1
+ replace:
+ source: /tmp/hive-njain/925269835/11972654.10001.insclause-1
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ properties:
+ name dest2
+ serialization.ddl struct dest2 { i32 key, string value, string hr, string ds}
+ serialization.format 1
+ columns key,value,hr,ds
+ SORTBUCKETCOLSPREFIX TRUE
+ bucket_count -1
+ serialization.lib org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+ file.inputformat org.apache.hadoop.mapred.TextInputFormat
+ file.outputformat org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ location file:/home/njain/workspace/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/dest2
+ serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+ name: dest2
+
+
+86 val_86 12 2008-04-08
+27 val_27 12 2008-04-08
+98 val_98 12 2008-04-08
+66 val_66 12 2008-04-08
+37 val_37 12 2008-04-08
+15 val_15 12 2008-04-08
+82 val_82 12 2008-04-08
+17 val_17 12 2008-04-08
+0 val_0 12 2008-04-08
+57 val_57 12 2008-04-08
+20 val_20 12 2008-04-08
+92 val_92 12 2008-04-08
+47 val_47 12 2008-04-08
+72 val_72 12 2008-04-08
+4 val_4 12 2008-04-08
+35 val_35 12 2008-04-08
+54 val_54 12 2008-04-08
+51 val_51 12 2008-04-08
+65 val_65 12 2008-04-08
+83 val_83 12 2008-04-08
+12 val_12 12 2008-04-08
+67 val_67 12 2008-04-08
+84 val_84 12 2008-04-08
+58 val_58 12 2008-04-08
+8 val_8 12 2008-04-08
+24 val_24 12 2008-04-08
+42 val_42 12 2008-04-08
+0 val_0 12 2008-04-08
+96 val_96 12 2008-04-08
+26 val_26 12 2008-04-08
+51 val_51 12 2008-04-08
+43 val_43 12 2008-04-08
+95 val_95 12 2008-04-08
+98 val_98 12 2008-04-08
+85 val_85 12 2008-04-08
+77 val_77 12 2008-04-08
+0 val_0 12 2008-04-08
+87 val_87 12 2008-04-08
+15 val_15 12 2008-04-08
+72 val_72 12 2008-04-08
+90 val_90 12 2008-04-08
+19 val_19 12 2008-04-08
+10 val_10 12 2008-04-08
+5 val_5 12 2008-04-08
+58 val_58 12 2008-04-08
+35 val_35 12 2008-04-08
+95 val_95 12 2008-04-08
+11 val_11 12 2008-04-08
+34 val_34 12 2008-04-08
+42 val_42 12 2008-04-08
+78 val_78 12 2008-04-08
+76 val_76 12 2008-04-08
+41 val_41 12 2008-04-08
+30 val_30 12 2008-04-08
+64 val_64 12 2008-04-08
+76 val_76 12 2008-04-08
+74 val_74 12 2008-04-08
+69 val_69 12 2008-04-08
+33 val_33 12 2008-04-08
+70 val_70 12 2008-04-08
+5 val_5 12 2008-04-08
+2 val_2 12 2008-04-08
+35 val_35 12 2008-04-08
+80 val_80 12 2008-04-08
+44 val_44 12 2008-04-08
+53 val_53 12 2008-04-08
+90 val_90 12 2008-04-08
+12 val_12 12 2008-04-08
+5 val_5 12 2008-04-08
+70 val_70 12 2008-04-08
+24 val_24 12 2008-04-08
+70 val_70 12 2008-04-08
+83 val_83 12 2008-04-08
+26 val_26 12 2008-04-08
+67 val_67 12 2008-04-08
+18 val_18 12 2008-04-08
+9 val_9 12 2008-04-08
+18 val_18 12 2008-04-08
+97 val_97 12 2008-04-08
+84 val_84 12 2008-04-08
+28 val_28 12 2008-04-08
+37 val_37 12 2008-04-08
+90 val_90 12 2008-04-08
+97 val_97 12 2008-04-08
+86 val_86 12 2008-04-09
+27 val_27 12 2008-04-09
+98 val_98 12 2008-04-09
+66 val_66 12 2008-04-09
+37 val_37 12 2008-04-09
+15 val_15 12 2008-04-09
+82 val_82 12 2008-04-09
+17 val_17 12 2008-04-09
+0 val_0 12 2008-04-09
+57 val_57 12 2008-04-09
+20 val_20 12 2008-04-09
+92 val_92 12 2008-04-09
+47 val_47 12 2008-04-09
+72 val_72 12 2008-04-09
+4 val_4 12 2008-04-09
+35 val_35 12 2008-04-09
+54 val_54 12 2008-04-09
+51 val_51 12 2008-04-09
+65 val_65 12 2008-04-09
+83 val_83 12 2008-04-09
+12 val_12 12 2008-04-09
+67 val_67 12 2008-04-09
+84 val_84 12 2008-04-09
+58 val_58 12 2008-04-09
+8 val_8 12 2008-04-09
+24 val_24 12 2008-04-09
+42 val_42 12 2008-04-09
+0 val_0 12 2008-04-09
+96 val_96 12 2008-04-09
+26 val_26 12 2008-04-09
+51 val_51 12 2008-04-09
+43 val_43 12 2008-04-09
+95 val_95 12 2008-04-09
+98 val_98 12 2008-04-09
+85 val_85 12 2008-04-09
+77 val_77 12 2008-04-09
+0 val_0 12 2008-04-09
+87 val_87 12 2008-04-09
+15 val_15 12 2008-04-09
+72 val_72 12 2008-04-09
+90 val_90 12 2008-04-09
+19 val_19 12 2008-04-09
+10 val_10 12 2008-04-09
+5 val_5 12 2008-04-09
+58 val_58 12 2008-04-09
+35 val_35 12 2008-04-09
+95 val_95 12 2008-04-09
+11 val_11 12 2008-04-09
+34 val_34 12 2008-04-09
+42 val_42 12 2008-04-09
+78 val_78 12 2008-04-09
+76 val_76 12 2008-04-09
+41 val_41 12 2008-04-09
+30 val_30 12 2008-04-09
+64 val_64 12 2008-04-09
+76 val_76 12 2008-04-09
+74 val_74 12 2008-04-09
+69 val_69 12 2008-04-09
+33 val_33 12 2008-04-09
+70 val_70 12 2008-04-09
+5 val_5 12 2008-04-09
+2 val_2 12 2008-04-09
+35 val_35 12 2008-04-09
+80 val_80 12 2008-04-09
+44 val_44 12 2008-04-09
+53 val_53 12 2008-04-09
+90 val_90 12 2008-04-09
+12 val_12 12 2008-04-09
+5 val_5 12 2008-04-09
+70 val_70 12 2008-04-09
+24 val_24 12 2008-04-09
+70 val_70 12 2008-04-09
+83 val_83 12 2008-04-09
+26 val_26 12 2008-04-09
+67 val_67 12 2008-04-09
+18 val_18 12 2008-04-09
+9 val_9 12 2008-04-09
+18 val_18 12 2008-04-09
+97 val_97 12 2008-04-09
+84 val_84 12 2008-04-09
+28 val_28 12 2008-04-09
+37 val_37 12 2008-04-09
+90 val_90 12 2008-04-09
+97 val_97 12 2008-04-09
Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input_testsequencefile.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input_testsequencefile.q.out?rev=706704&r1=706703&r2=706704&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input_testsequencefile.q.out (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input_testsequencefile.q.out Tue Oct 21 11:11:05 2008
@@ -18,20 +18,20 @@
type: string
File Output Operator
table:
- name: dest4_sequencefile
- serde: simple_meta
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.mapred.SequenceFileOutputFormat
+ serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+ name: dest4_sequencefile
Stage: Stage-0
Move Operator
tables:
+ replace:
table:
- name: dest4_sequencefile
- serde: simple_meta
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.mapred.SequenceFileOutputFormat
- replace:
+ serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+ name: dest4_sequencefile
238 val_238
@@ -534,4 +534,3 @@
400 val_400
200 val_200
97 val_97
-