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:30:34 UTC
svn commit: r706708 [7/13] - in /hadoop/core/branches/branch-0.19: ./
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/...
Modified: hadoop/core/branches/branch-0.19/src/contrib/hive/ql/src/test/results/clientpositive/join8.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/branches/branch-0.19/src/contrib/hive/ql/src/test/results/clientpositive/join8.q.out?rev=706708&r1=706707&r2=706708&view=diff
==============================================================================
--- hadoop/core/branches/branch-0.19/src/contrib/hive/ql/src/test/results/clientpositive/join8.q.out (original)
+++ hadoop/core/branches/branch-0.19/src/contrib/hive/ql/src/test/results/clientpositive/join8.q.out Tue Oct 21 11:29:18 2008
@@ -8,43 +8,6 @@
STAGE PLANS:
Stage: Stage-1
Map Reduce
- Reduce Operator Tree:
- Join Operator
- condition expressions:
- 0 {VALUE.0} {VALUE.1}
- 1 {VALUE.0} {VALUE.1}
- condition map:
- Left Outer Join0 to 1
- Select Operator
- expressions:
- expr: 0
- type: string
- expr: 1
- type: string
- expr: 2
- type: string
- expr: 3
- type: string
- Filter Operator
- predicate:
- expr: (2 is null and 0 is not null)
- type: Boolean
- Select Operator
- expressions:
- expr: 0
- type: string
- expr: 1
- type: string
- expr: 2
- type: string
- expr: 3
- 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:
c:b:src2
Filter Operator
@@ -58,16 +21,16 @@
expr: value
type: string
Reduce Output Operator
- tag: 1
key expressions:
expr: 0
type: string
+ # partition fields: 1
+ tag: 1
value expressions:
expr: 0
type: string
expr: 1
type: string
- # partition fields: 1
c:a:src1
Filter Operator
predicate:
@@ -80,26 +43,63 @@
expr: value
type: string
Reduce Output Operator
- tag: 0
key expressions:
expr: 0
type: string
+ # partition fields: 1
+ tag: 0
value expressions:
expr: 0
type: string
expr: 1
type: string
- # partition fields: 1
+ Reduce Operator Tree:
+ Join Operator
+ condition map:
+ Left Outer Join0 to 1
+ condition expressions:
+ 0 {VALUE.0} {VALUE.1}
+ 1 {VALUE.0} {VALUE.1}
+ Select Operator
+ expressions:
+ expr: 0
+ type: string
+ expr: 1
+ type: string
+ expr: 2
+ type: string
+ expr: 3
+ type: string
+ Filter Operator
+ predicate:
+ expr: (2 is null and 0 is not null)
+ type: Boolean
+ Select Operator
+ expressions:
+ expr: 0
+ type: string
+ expr: 1
+ type: string
+ expr: 2
+ type: string
+ expr: 3
+ 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
11 val_11 NULL NULL
@@ -107,4 +107,3 @@
12 val_12 NULL NULL
15 val_15 NULL NULL
15 val_15 NULL NULL
-
Modified: hadoop/core/branches/branch-0.19/src/contrib/hive/ql/src/test/results/clientpositive/sample1.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/branches/branch-0.19/src/contrib/hive/ql/src/test/results/clientpositive/sample1.q.out?rev=706708&r1=706707&r2=706708&view=diff
==============================================================================
--- hadoop/core/branches/branch-0.19/src/contrib/hive/ql/src/test/results/clientpositive/sample1.q.out (original)
+++ hadoop/core/branches/branch-0.19/src/contrib/hive/ql/src/test/results/clientpositive/sample1.q.out Tue Oct 21 11:29:18 2008
@@ -8,31 +8,6 @@
STAGE PLANS:
Stage: Stage-1
Map Reduce
- Path -> Alias:
- file:/data/zshao/trunk/VENDOR/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11
- Path -> Partition:
- file:/data/zshao/trunk/VENDOR/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11
- Partition
-
- properties:
- name srcpart
- bucket_field_name
- serialization.format 1
- columns key,value
- partition_columns ds/hr
- field_to_dimension
- bucket_count -1
- serialization.lib simple_meta
- file.inputformat org.apache.hadoop.mapred.TextInputFormat
- file.outputformat org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
- location file:/data/zshao/trunk/VENDOR/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/srcpart
- name: srcpart
- serde: simple_meta
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
- partition values:
- ds 2008-04-08
- hr 11
Alias -> Map Operator Tree:
s
Filter Operator
@@ -50,48 +25,70 @@
expr: hr
type: string
File Output Operator
+ directory: /tmp/hive-njain/1799446246/1449752317.10000.insclause-0
table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
properties:
name dest1
- bucket_field_name
+ serialization.ddl struct dest1 { i32 key, string value, string dt, string hr}
serialization.format 1
columns key,value,dt,hr
SORTBUCKETCOLSPREFIX TRUE
- field_to_dimension
bucket_count -1
- serialization.lib simple_meta
+ 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:/data/zshao/trunk/VENDOR/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/dest1
+ 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
- serde: simple_meta
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
- directory: /tmp/hive-zshao/640225297.10000.insclause-0
Needs Tagging:
+ Path -> Alias:
+ file:/home/njain/workspace/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11
+ Path -> Partition:
+ file:/home/njain/workspace/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11
+ Partition
+ partition values:
+ ds 2008-04-08
+ hr 11
+
+ 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/1799446246/1449752317.10000.insclause-0
table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
properties:
name dest1
- bucket_field_name
+ serialization.ddl struct dest1 { i32 key, string value, string dt, string hr}
serialization.format 1
columns key,value,dt,hr
SORTBUCKETCOLSPREFIX TRUE
- field_to_dimension
bucket_count -1
- serialization.lib simple_meta
+ 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:/data/zshao/trunk/VENDOR/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/dest1
+ 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
- serde: simple_meta
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
- replace:
- source: /tmp/hive-zshao/640225297.10000.insclause-0
238 val_238 2008-04-08 11
@@ -594,4 +591,3 @@
400 val_400 2008-04-08 11
200 val_200 2008-04-08 11
97 val_97 2008-04-08 11
-
Modified: hadoop/core/branches/branch-0.19/src/contrib/hive/ql/src/test/results/clientpositive/sample2.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/branches/branch-0.19/src/contrib/hive/ql/src/test/results/clientpositive/sample2.q.out?rev=706708&r1=706707&r2=706708&view=diff
==============================================================================
--- hadoop/core/branches/branch-0.19/src/contrib/hive/ql/src/test/results/clientpositive/sample2.q.out (original)
+++ hadoop/core/branches/branch-0.19/src/contrib/hive/ql/src/test/results/clientpositive/sample2.q.out Tue Oct 21 11:29:18 2008
@@ -8,27 +8,6 @@
STAGE PLANS:
Stage: Stage-1
Map Reduce
- Path -> Alias:
- file:/data/zshao/trunk/VENDOR/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/srcbucket/kv1.txt
- Path -> Partition:
- file:/data/zshao/trunk/VENDOR/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/srcbucket/kv1.txt
- Partition
-
- properties:
- name srcbucket
- bucket_field_name
- serialization.format 1
- columns key,value
- field_to_dimension
- bucket_count 2
- serialization.lib simple_meta
- file.inputformat org.apache.hadoop.mapred.TextInputFormat
- file.outputformat org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
- location file:/data/zshao/trunk/VENDOR/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/srcbucket
- name: srcbucket
- serde: simple_meta
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
Alias -> Map Operator Tree:
s
Select Operator
@@ -38,48 +17,66 @@
expr: value
type: string
File Output Operator
+ directory: /tmp/hive-njain/1178661057/1120939755.10000.insclause-0
table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
properties:
name dest1
- bucket_field_name
+ serialization.ddl struct dest1 { i32 key, string value}
serialization.format 1
columns key,value
SORTBUCKETCOLSPREFIX TRUE
- field_to_dimension
bucket_count -1
- serialization.lib simple_meta
+ 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:/data/zshao/trunk/VENDOR/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/dest1
+ 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
- serde: simple_meta
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
- directory: /tmp/hive-zshao/83464218.10000.insclause-0
Needs Tagging:
+ Path -> Alias:
+ file:/home/njain/workspace/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/srcbucket/kv1.txt
+ Path -> Partition:
+ file:/home/njain/workspace/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/srcbucket/kv1.txt
+ Partition
+
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ properties:
+ name srcbucket
+ serialization.ddl struct srcbucket { string key, string value}
+ serialization.format 1
+ columns key,value
+ bucket_count 2
+ 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/srcbucket
+ serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+ name: srcbucket
Stage: Stage-0
Move Operator
tables:
+ replace:
+ source: /tmp/hive-njain/1178661057/1120939755.10000.insclause-0
table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
properties:
name dest1
- bucket_field_name
+ serialization.ddl struct dest1 { i32 key, string value}
serialization.format 1
columns key,value
SORTBUCKETCOLSPREFIX TRUE
- field_to_dimension
bucket_count -1
- serialization.lib simple_meta
+ 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:/data/zshao/trunk/VENDOR/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/dest1
+ 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
- serde: simple_meta
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
- replace:
- source: /tmp/hive-zshao/83464218.10000.insclause-0
238 val_238
@@ -582,4 +579,3 @@
400 val_400
200 val_200
97 val_97
-
Modified: hadoop/core/branches/branch-0.19/src/contrib/hive/ql/src/test/results/clientpositive/sample4.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/branches/branch-0.19/src/contrib/hive/ql/src/test/results/clientpositive/sample4.q.out?rev=706708&r1=706707&r2=706708&view=diff
==============================================================================
--- hadoop/core/branches/branch-0.19/src/contrib/hive/ql/src/test/results/clientpositive/sample4.q.out (original)
+++ hadoop/core/branches/branch-0.19/src/contrib/hive/ql/src/test/results/clientpositive/sample4.q.out Tue Oct 21 11:29:18 2008
@@ -8,32 +8,11 @@
STAGE PLANS:
Stage: Stage-1
Map Reduce
- Path -> Alias:
- file:/data/zshao/trunk/VENDOR/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/srcbucket
- Path -> Partition:
- file:/data/zshao/trunk/VENDOR/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/srcbucket
- Partition
-
- properties:
- name srcbucket
- bucket_field_name
- serialization.format 1
- columns key,value
- field_to_dimension
- bucket_count 2
- serialization.lib simple_meta
- file.inputformat org.apache.hadoop.mapred.TextInputFormat
- file.outputformat org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
- location file:/data/zshao/trunk/VENDOR/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/srcbucket
- name: srcbucket
- serde: simple_meta
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
Alias -> Map Operator Tree:
s
Filter Operator
predicate:
- expr: (((default_sample_hashfn(key) & 2147483647) % 2) = 1)
+ expr: (((default_sample_hashfn(key) & 2147483647) % 2) = 0)
type: Boolean
Select Operator
expressions:
@@ -42,551 +21,563 @@
expr: value
type: string
File Output Operator
+ directory: /tmp/hive-njain/594156852/317367185.10000.insclause-0
table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
properties:
name dest1
- bucket_field_name
+ serialization.ddl struct dest1 { i32 key, string value}
serialization.format 1
columns key,value
SORTBUCKETCOLSPREFIX TRUE
- field_to_dimension
bucket_count -1
- serialization.lib simple_meta
+ 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:/data/zshao/trunk/VENDOR/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/dest1
+ 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
- serde: simple_meta
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
- directory: /tmp/hive-zshao/4031240.10000.insclause-0
Needs Tagging:
+ Path -> Alias:
+ file:/home/njain/workspace/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/srcbucket
+ Path -> Partition:
+ file:/home/njain/workspace/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/srcbucket
+ Partition
+
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ properties:
+ name srcbucket
+ serialization.ddl struct srcbucket { string key, string value}
+ serialization.format 1
+ columns key,value
+ bucket_count 2
+ 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/srcbucket
+ serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+ name: srcbucket
Stage: Stage-0
Move Operator
tables:
+ replace:
+ source: /tmp/hive-njain/594156852/317367185.10000.insclause-0
table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
properties:
name dest1
- bucket_field_name
+ serialization.ddl struct dest1 { i32 key, string value}
serialization.format 1
columns key,value
SORTBUCKETCOLSPREFIX TRUE
- field_to_dimension
bucket_count -1
- serialization.lib simple_meta
+ 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:/data/zshao/trunk/VENDOR/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/dest1
+ 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
- serde: simple_meta
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
- replace:
- source: /tmp/hive-zshao/4031240.10000.insclause-0
-
-
-238 val_238
-311 val_311
-27 val_27
-409 val_409
-278 val_278
-98 val_98
-265 val_265
-193 val_193
-401 val_401
-128 val_128
-146 val_146
-429 val_429
-469 val_469
-281 val_281
-209 val_209
-403 val_403
-166 val_166
-430 val_430
-252 val_252
-292 val_292
-287 val_287
-153 val_153
-193 val_193
-494 val_494
-207 val_207
-199 val_199
-399 val_399
-247 val_247
-489 val_489
-162 val_162
-377 val_377
-397 val_397
-342 val_342
-195 val_195
-113 val_113
-155 val_155
-203 val_203
-339 val_339
-128 val_128
-311 val_311
-302 val_302
-205 val_205
-438 val_438
-489 val_489
-157 val_157
-221 val_221
-92 val_92
-111 val_111
-47 val_47
-72 val_72
-427 val_427
-399 val_399
-382 val_382
-498 val_498
-386 val_386
-469 val_469
-54 val_54
-216 val_216
-430 val_430
-278 val_278
-289 val_289
-221 val_221
-65 val_65
-311 val_311
-137 val_137
-241 val_241
-83 val_83
-333 val_333
-180 val_180
-12 val_12
-230 val_230
-67 val_67
-384 val_384
-489 val_489
-353 val_353
-373 val_373
-272 val_272
-348 val_348
-58 val_58
-230 val_230
-348 val_348
-463 val_463
-179 val_179
-119 val_119
-496 val_496
-322 val_322
-197 val_197
-393 val_393
-454 val_454
-100 val_100
-298 val_298
-199 val_199
-191 val_191
-418 val_418
-96 val_96
-230 val_230
-205 val_205
-120 val_120
-131 val_131
-43 val_43
-436 val_436
-469 val_469
-308 val_308
-481 val_481
-98 val_98
-197 val_197
-409 val_409
-470 val_470
-137 val_137
-85 val_85
-490 val_490
-87 val_87
-364 val_364
-179 val_179
-395 val_395
-238 val_238
-72 val_72
-90 val_90
-10 val_10
-306 val_306
-272 val_272
-331 val_331
-401 val_401
-452 val_452
-177 val_177
-5 val_5
-317 val_317
-395 val_395
-58 val_58
-168 val_168
-34 val_34
-229 val_229
-472 val_472
-322 val_322
-498 val_498
-160 val_160
-195 val_195
-430 val_430
-119 val_119
-489 val_489
-458 val_458
-78 val_78
-76 val_76
-41 val_41
-223 val_223
-492 val_492
-449 val_449
-218 val_218
-30 val_30
-209 val_209
-76 val_76
-74 val_74
-342 val_342
-69 val_69
-230 val_230
-368 val_368
-296 val_296
-113 val_113
-216 val_216
-344 val_344
-274 val_274
-485 val_485
-223 val_223
-256 val_256
-263 val_263
-70 val_70
-487 val_487
-401 val_401
-191 val_191
-5 val_5
-438 val_438
-128 val_128
-467 val_467
-432 val_432
-229 val_229
-469 val_469
-463 val_463
-283 val_283
-331 val_331
-193 val_193
-335 val_335
-104 val_104
-366 val_366
-175 val_175
-403 val_403
-483 val_483
-409 val_409
-401 val_401
-258 val_258
-90 val_90
-203 val_203
-348 val_348
-12 val_12
-201 val_201
-164 val_164
-454 val_454
-478 val_478
-298 val_298
-164 val_164
-382 val_382
-5 val_5
-70 val_70
-397 val_397
-351 val_351
-104 val_104
-70 val_70
-438 val_438
-119 val_119
-414 val_414
-360 val_360
-199 val_199
-120 val_120
-429 val_429
-443 val_443
-230 val_230
-478 val_478
-317 val_317
-333 val_333
-207 val_207
-249 val_249
-265 val_265
-83 val_83
-353 val_353
-214 val_214
-133 val_133
-175 val_175
-454 val_454
-375 val_375
-401 val_401
-421 val_421
-407 val_407
-384 val_384
-256 val_256
-67 val_67
-384 val_384
-379 val_379
-18 val_18
-492 val_492
-100 val_100
-298 val_298
-9 val_9
-498 val_498
-146 val_146
-458 val_458
-362 val_362
-186 val_186
-285 val_285
-348 val_348
-18 val_18
-281 val_281
-344 val_344
-469 val_469
-315 val_315
-348 val_348
-414 val_414
-126 val_126
-90 val_90
-403 val_403
-474 val_475
-281 val_282
-179 val_180
-135 val_136
-423 val_424
-245 val_246
-425 val_426
-241 val_242
-177 val_178
-272 val_273
-287 val_288
-373 val_374
-447 val_448
-443 val_444
-175 val_176
-278 val_279
-296 val_297
-126 val_127
-249 val_250
-21 val_22
-441 val_442
-106 val_107
-371 val_372
-153 val_154
-490 val_491
-421 val_422
-243 val_244
-128 val_129
-10 val_11
-133 val_134
-333 val_334
-391 val_392
-485 val_486
-241 val_242
-85 val_86
-335 val_336
-476 val_477
-494 val_495
-94 val_95
-485 val_486
-393 val_394
-409 val_410
-50 val_51
-265 val_266
-128 val_129
-63 val_64
-344 val_345
-135 val_136
-3 val_4
-331 val_332
-209 val_210
-281 val_282
-56 val_57
-254 val_255
-304 val_305
-238 val_239
-492 val_493
-289 val_290
-421 val_422
-58 val_59
-5 val_6
-249 val_250
-438 val_439
-360 val_361
-467 val_468
-175 val_176
-429 val_430
-281 val_282
-16 val_17
-119 val_120
-492 val_493
-120 val_121
-306 val_307
-393 val_394
-427 val_428
-386 val_387
-65 val_66
-388 val_389
-184 val_185
-375 val_376
-191 val_192
-197 val_198
-122 val_123
-438 val_439
-351 val_352
-23 val_24
-328 val_329
-382 val_383
-342 val_343
-102 val_103
-487 val_488
-331 val_332
-409 val_410
-463 val_464
-177 val_178
-399 val_400
-476 val_477
-258 val_259
-252 val_253
-87 val_88
-340 val_341
-443 val_444
-407 val_408
-355 val_356
-164 val_165
-104 val_105
-117 val_118
-326 val_327
-47 val_48
-241 val_242
-450 val_451
-140 val_141
-212 val_213
-308 val_309
-30 val_31
-405 val_406
-119 val_120
-49 val_50
-153 val_154
-21 val_22
-157 val_158
-416 val_417
-199 val_200
-375 val_376
-89 val_90
-395 val_396
-386 val_387
-454 val_455
-364 val_365
-89 val_90
-461 val_462
-52 val_53
-168 val_169
-384 val_385
-313 val_314
-324 val_325
-69 val_70
-245 val_246
-328 val_329
-322 val_323
-122 val_123
-241 val_242
-469 val_470
-384 val_385
-76 val_77
-104 val_105
-481 val_482
-32 val_33
-58 val_59
-351 val_352
-70 val_71
-443 val_444
-399 val_400
-205 val_206
-52 val_53
-21 val_22
-317 val_318
-209 val_210
-429 val_430
-160 val_161
-267 val_268
-454 val_455
-76 val_77
-412 val_413
-16 val_17
-375 val_376
-489 val_490
-126 val_127
-274 val_275
-494 val_495
-216 val_217
-470 val_471
-302 val_303
-119 val_120
-375 val_376
-391 val_392
-287 val_288
-450 val_451
-375 val_376
-12 val_13
-384 val_385
-29 val_30
-151 val_152
-52 val_53
-300 val_301
-21 val_22
-104 val_105
-436 val_437
-61 val_62
-407 val_408
-335 val_336
-164 val_165
-371 val_372
-432 val_433
-496 val_497
-355 val_356
-144 val_145
-87 val_88
-382 val_383
-348 val_349
-122 val_123
-427 val_428
-292 val_293
-182 val_183
-474 val_475
-353 val_354
-52 val_53
-414 val_415
-261 val_262
-65 val_66
-371 val_372
-256 val_257
-292 val_293
-412 val_413
-49 val_50
-478 val_479
-243 val_244
-151 val_152
-100 val_101
-401 val_402
-117 val_118
-137 val_138
-162 val_163
-276 val_277
-78 val_79
-379 val_380
-410 val_411
-157 val_158
-100 val_101
-407 val_408
-371 val_372
-308 val_309
-430 val_431
-135 val_136
-76 val_77
-300 val_301
-337 val_338
-478 val_479
-1 val_2
-89 val_90
-29 val_30
-285 val_286
-227 val_228
-395 val_396
+86 val_86
+165 val_165
+255 val_255
+484 val_484
+150 val_150
+273 val_273
+224 val_224
+369 val_369
+66 val_66
+213 val_213
+406 val_406
+374 val_374
+152 val_152
+145 val_145
+495 val_495
+37 val_37
+327 val_327
+277 val_277
+15 val_15
+82 val_82
+417 val_417
+219 val_219
+338 val_338
+446 val_446
+459 val_459
+394 val_394
+237 val_237
+482 val_482
+174 val_174
+413 val_413
+466 val_466
+208 val_208
+174 val_174
+396 val_396
+417 val_417
+309 val_309
+365 val_365
+266 val_266
+439 val_439
+367 val_367
+325 val_325
+167 val_167
+475 val_475
+17 val_17
+0 val_0
+455 val_455
+316 val_316
+57 val_57
+149 val_149
+345 val_345
+129 val_129
+170 val_170
+20 val_20
+378 val_378
+4 val_4
+280 val_280
+35 val_35
+277 val_277
+208 val_208
+356 val_356
+169 val_169
+125 val_125
+437 val_437
+192 val_192
+286 val_286
+187 val_187
+176 val_176
+459 val_459
+51 val_51
+138 val_138
+103 val_103
+239 val_239
+213 val_213
+176 val_176
+318 val_318
+332 val_332
+275 val_275
+284 val_284
+181 val_181
+260 val_260
+404 val_404
+138 val_138
+217 val_217
+84 val_84
+466 val_466
+8 val_8
+411 val_411
+208 val_208
+24 val_24
+431 val_431
+172 val_172
+42 val_42
+129 val_129
+158 val_158
+0 val_0
+468 val_468
+26 val_26
+165 val_165
+327 val_327
+51 val_51
+404 val_404
+156 val_156
+468 val_468
+95 val_95
+196 val_196
+288 val_288
+457 val_457
+282 val_282
+187 val_187
+318 val_318
+318 val_318
+369 val_369
+316 val_316
+169 val_169
+413 val_413
+77 val_77
+0 val_0
+118 val_118
+134 val_134
+282 val_282
+138 val_138
+419 val_419
+15 val_15
+118 val_118
+307 val_307
+19 val_19
+435 val_435
+277 val_277
+273 val_273
+224 val_224
+309 val_309
+389 val_389
+327 val_327
+242 val_242
+369 val_369
+392 val_392
+242 val_242
+226 val_226
+497 val_497
+402 val_402
+396 val_396
+35 val_35
+336 val_336
+95 val_95
+11 val_11
+233 val_233
+143 val_143
+42 val_42
+321 val_321
+149 val_149
+228 val_228
+138 val_138
+453 val_453
+64 val_64
+468 val_468
+33 val_33
+103 val_103
+367 val_367
+167 val_167
+219 val_219
+239 val_239
+116 val_116
+480 val_480
+288 val_288
+244 val_244
+202 val_202
+316 val_316
+280 val_280
+2 val_2
+35 val_35
+235 val_235
+80 val_80
+44 val_44
+321 val_321
+466 val_466
+53 val_53
+105 val_105
+257 val_257
+406 val_406
+190 val_190
+406 val_406
+114 val_114
+262 val_262
+424 val_424
+396 val_396
+217 val_217
+431 val_431
+125 val_125
+431 val_431
+424 val_424
+187 val_187
+480 val_480
+291 val_291
+24 val_24
+255 val_255
+163 val_163
+200 val_200
+491 val_491
+237 val_237
+439 val_439
+248 val_248
+479 val_479
+305 val_305
+417 val_417
+444 val_444
+169 val_169
+323 val_323
+325 val_325
+277 val_277
+178 val_178
+468 val_468
+310 val_310
+493 val_493
+460 val_460
+480 val_480
+136 val_136
+172 val_172
+462 val_462
+233 val_233
+406 val_406
+189 val_189
+26 val_26
+134 val_134
+462 val_462
+341 val_341
+167 val_167
+273 val_273
+183 val_183
+97 val_97
+84 val_84
+28 val_28
+37 val_37
+448 val_448
+152 val_152
+307 val_307
+194 val_194
+477 val_477
+222 val_222
+169 val_169
+400 val_400
+200 val_200
+97 val_97
+291 val_292
+62 val_63
+271 val_272
+217 val_218
+167 val_168
+468 val_469
+413 val_414
+455 val_456
+231 val_232
+448 val_449
+246 val_247
+440 val_441
+31 val_32
+147 val_148
+428 val_429
+273 val_274
+356 val_357
+217 val_218
+33 val_34
+35 val_36
+402 val_403
+226 val_227
+15 val_16
+110 val_111
+343 val_344
+275 val_276
+0 val_1
+293 val_294
+240 val_241
+286 val_287
+408 val_409
+477 val_478
+455 val_456
+99 val_100
+482 val_483
+367 val_368
+59 val_60
+48 val_49
+424 val_425
+226 val_227
+488 val_489
+349 val_350
+11 val_12
+161 val_162
+123 val_124
+402 val_403
+468 val_469
+314 val_315
+497 val_498
+224 val_225
+4 val_5
+277 val_278
+206 val_207
+101 val_102
+114 val_115
+239 val_240
+389 val_390
+114 val_115
+235 val_236
+390 val_391
+165 val_166
+264 val_265
+196 val_197
+20 val_21
+11 val_12
+129 val_130
+257 val_258
+71 val_72
+453 val_454
+82 val_83
+86 val_87
+323 val_324
+222 val_223
+42 val_43
+411 val_412
+338 val_339
+68 val_69
+185 val_186
+147 val_148
+473 val_474
+376 val_377
+347 val_348
+213 val_214
+291 val_292
+426 val_427
+132 val_133
+446 val_447
+121 val_122
+284 val_285
+129 val_130
+246 val_247
+491 val_492
+369 val_370
+262 val_263
+390 val_391
+352 val_353
+226 val_227
+349 val_350
+480 val_481
+497 val_498
+480 val_481
+475 val_476
+183 val_184
+15 val_16
+318 val_319
+149 val_150
+392 val_393
+77 val_78
+275 val_276
+174 val_175
+114 val_115
+161 val_162
+75 val_76
+264 val_265
+48 val_49
+336 val_337
+390 val_391
+484 val_485
+189 val_190
+305 val_306
+367 val_368
+6 val_7
+260 val_261
+2 val_3
+349 val_350
+170 val_171
+51 val_52
+363 val_364
+118 val_119
+310 val_311
+19 val_20
+80 val_81
+121 val_122
+239 val_240
+358 val_359
+11 val_12
+143 val_144
+341 val_342
+105 val_106
+42 val_43
+363 val_364
+347 val_348
+77 val_78
+293 val_294
+20 val_21
+40 val_41
+8 val_9
+310 val_311
+206 val_207
+381 val_382
+404 val_405
+206 val_207
+385 val_386
+259 val_260
+226 val_227
+262 val_263
+303 val_304
+260 val_261
+404 val_405
+116 val_117
+42 val_43
+303 val_304
+93 val_94
+277 val_278
+406 val_407
+451 val_452
+53 val_54
+132 val_133
+192 val_193
+356 val_357
+352 val_353
+330 val_331
+138 val_139
+257 val_258
+174 val_175
+295 val_296
+105 val_106
+204 val_205
+439 val_440
+374 val_375
+457 val_458
+93 val_94
+196 val_197
+437 val_438
+398 val_399
+35 val_36
+334 val_335
+435 val_436
+60 val_61
+442 val_443
+404 val_405
+446 val_447
+0 val_1
+268 val_269
+491 val_492
+392 val_393
+295 val_296
+93 val_94
+439 val_440
+156 val_157
+341 val_342
+118 val_119
+172 val_173
+244 val_245
+6 val_7
+284 val_285
+136 val_137
+349 val_350
+462 val_463
+123 val_124
+408 val_409
+152 val_153
+310 val_311
+486 val_487
+152 val_153
+378 val_379
+97 val_98
+495 val_496
+385 val_386
+40 val_41
+389 val_390
+259 val_260
+97 val_98
+125 val_126
+178 val_179
+415 val_416
+156 val_157
+228 val_229
+363 val_364
+22 val_23
+248 val_249
+459 val_460
+402 val_403
+62 val_63
+244 val_245
+46 val_47
+341 val_342
+215 val_216
+134 val_135
+196 val_197
+431 val_432
+82 val_83
+440 val_441
+309 val_310
+161 val_162
+468 val_469
+152 val_153
+138 val_139
+161 val_162
+91 val_92
+118 val_119
+178 val_179
+457 val_458
+242 val_243
+35 val_36
+244 val_245
Modified: hadoop/core/branches/branch-0.19/src/contrib/hive/ql/src/test/results/clientpositive/sample5.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/branches/branch-0.19/src/contrib/hive/ql/src/test/results/clientpositive/sample5.q.out?rev=706708&r1=706707&r2=706708&view=diff
==============================================================================
--- hadoop/core/branches/branch-0.19/src/contrib/hive/ql/src/test/results/clientpositive/sample5.q.out (original)
+++ hadoop/core/branches/branch-0.19/src/contrib/hive/ql/src/test/results/clientpositive/sample5.q.out Tue Oct 21 11:29:18 2008
@@ -8,32 +8,11 @@
STAGE PLANS:
Stage: Stage-1
Map Reduce
- Path -> Alias:
- file:/data/zshao/trunk/VENDOR/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/srcbucket
- Path -> Partition:
- file:/data/zshao/trunk/VENDOR/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/srcbucket
- Partition
-
- properties:
- name srcbucket
- bucket_field_name
- serialization.format 1
- columns key,value
- field_to_dimension
- bucket_count 2
- serialization.lib simple_meta
- file.inputformat org.apache.hadoop.mapred.TextInputFormat
- file.outputformat org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
- location file:/data/zshao/trunk/VENDOR/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/srcbucket
- name: srcbucket
- serde: simple_meta
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
Alias -> Map Operator Tree:
s
Filter Operator
predicate:
- expr: (((default_sample_hashfn(key) & 2147483647) % 5) = 1)
+ expr: (((default_sample_hashfn(key) & 2147483647) % 5) = 0)
type: Boolean
Select Operator
expressions:
@@ -42,241 +21,272 @@
expr: value
type: string
File Output Operator
+ directory: /tmp/hive-njain/535229973/587370170.10000.insclause-0
table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
properties:
name dest1
- bucket_field_name
+ serialization.ddl struct dest1 { i32 key, string value}
serialization.format 1
columns key,value
SORTBUCKETCOLSPREFIX TRUE
- field_to_dimension
bucket_count -1
- serialization.lib simple_meta
+ 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:/data/zshao/trunk/VENDOR/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/dest1
+ 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
- serde: simple_meta
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
- directory: /tmp/hive-zshao/824052972.10000.insclause-0
Needs Tagging:
+ Path -> Alias:
+ file:/home/njain/workspace/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/srcbucket
+ Path -> Partition:
+ file:/home/njain/workspace/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/srcbucket
+ Partition
+
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ properties:
+ name srcbucket
+ serialization.ddl struct srcbucket { string key, string value}
+ serialization.format 1
+ columns key,value
+ bucket_count 2
+ 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/srcbucket
+ serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+ name: srcbucket
Stage: Stage-0
Move Operator
tables:
+ replace:
+ source: /tmp/hive-njain/535229973/587370170.10000.insclause-0
table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
properties:
name dest1
- bucket_field_name
+ serialization.ddl struct dest1 { i32 key, string value}
serialization.format 1
columns key,value
SORTBUCKETCOLSPREFIX TRUE
- field_to_dimension
bucket_count -1
- serialization.lib simple_meta
+ 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:/data/zshao/trunk/VENDOR/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/dest1
+ 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
- serde: simple_meta
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
- replace:
- source: /tmp/hive-zshao/824052972.10000.insclause-0
-
-
-165 val_165
-255 val_255
-278 val_278
-273 val_273
-37 val_37
-327 val_327
-82 val_82
-403 val_403
-417 val_417
-430 val_430
-219 val_219
-287 val_287
-237 val_237
-174 val_174
-494 val_494
-174 val_174
-417 val_417
-377 val_377
-309 val_309
-205 val_205
-345 val_345
-129 val_129
-386 val_386
-192 val_192
-138 val_138
-430 val_430
-278 val_278
-318 val_318
-241 val_241
-138 val_138
-8 val_8
-179 val_179
-129 val_129
-322 val_322
-197 val_197
-96 val_96
-165 val_165
-327 val_327
-205 val_205
-156 val_156
-282 val_282
-197 val_197
-318 val_318
-318 val_318
-87 val_87
-179 val_179
-395 val_395
-282 val_282
-138 val_138
-19 val_19
-435 val_435
-273 val_273
-309 val_309
-327 val_327
-331 val_331
-395 val_395
-336 val_336
-322 val_322
-160 val_160
-430 val_430
-458 val_458
-78 val_78
-41 val_41
-223 val_223
-449 val_449
-228 val_228
-138 val_138
-453 val_453
-64 val_64
-69 val_69
-368 val_368
-296 val_296
-219 val_219
-485 val_485
-223 val_223
-480 val_480
-467 val_467
-331 val_331
-403 val_403
-480 val_480
-291 val_291
-255 val_255
-200 val_200
-237 val_237
-417 val_417
-444 val_444
-480 val_480
-214 val_214
-462 val_462
-133 val_133
-421 val_421
-462 val_462
-458 val_458
-273 val_273
-183 val_183
-28 val_28
-37 val_37
-403 val_403
-200 val_200
-179 val_180
-291 val_292
-241 val_242
-287 val_288
-246 val_247
-278 val_279
-296 val_297
-147 val_148
-273 val_274
-106 val_107
-421 val_422
-133 val_134
-110 val_111
-485 val_486
-241 val_242
-408 val_409
-476 val_477
-494 val_495
-485 val_486
-50 val_51
-3 val_4
-101 val_102
-331 val_332
-390 val_391
-165 val_166
-304 val_305
-264 val_265
-129 val_130
-453 val_454
-421 val_422
-82 val_83
-467 val_468
-147 val_148
-291 val_292
-426 val_427
-386 val_387
-129 val_130
-246 val_247
-197 val_198
-390 val_391
-23 val_24
-480 val_481
-480 val_481
-331 val_332
-183 val_184
-318 val_319
-476 val_477
-174 val_175
-87 val_88
-264 val_265
-336 val_337
-340 val_341
-390 val_391
-363 val_364
-19 val_20
-241 val_242
-363 val_364
-395 val_396
-386 val_387
-8 val_9
-313 val_314
-381 val_382
-69 val_70
-322 val_323
-241 val_242
-32 val_33
-192 val_193
-205 val_206
-138 val_139
-160 val_161
-174 val_175
-412 val_413
-494 val_495
-287 val_288
-435 val_436
-151 val_152
-156 val_157
-462 val_463
-87 val_88
-408 val_409
-412 val_413
-151 val_152
-156 val_157
-228 val_229
-363 val_364
-46 val_47
-78 val_79
-82 val_83
-430 val_431
-309 val_310
-138 val_139
-91 val_92
-395 val_396
+86 val_86
+27 val_27
+484 val_484
+150 val_150
+128 val_128
+213 val_213
+146 val_146
+281 val_281
+277 val_277
+209 val_209
+394 val_394
+466 val_466
+399 val_399
+489 val_489
+439 val_439
+367 val_367
+475 val_475
+155 val_155
+128 val_128
+489 val_489
+72 val_72
+277 val_277
+399 val_399
+169 val_169
+498 val_498
+286 val_286
+187 val_187
+54 val_54
+213 val_213
+137 val_137
+489 val_489
+353 val_353
+272 val_272
+466 val_466
+411 val_411
+119 val_119
+100 val_100
+191 val_191
+308 val_308
+95 val_95
+196 val_196
+457 val_457
+187 val_187
+470 val_470
+137 val_137
+169 val_169
+77 val_77
+72 val_72
+90 val_90
+277 val_277
+272 val_272
+452 val_452
+402 val_402
+317 val_317
+95 val_95
+498 val_498
+321 val_321
+119 val_119
+489 val_489
+218 val_218
+209 val_209
+367 val_367
+344 val_344
+263 val_263
+191 val_191
+128 val_128
+2 val_2
+321 val_321
+335 val_335
+466 val_466
+105 val_105
+114 val_114
+90 val_90
+164 val_164
+164 val_164
+187 val_187
+119 val_119
+439 val_439
+169 val_169
+443 val_443
+277 val_277
+178 val_178
+317 val_317
+493 val_493
+353 val_353
+407 val_407
+18 val_18
+100 val_100
+498 val_498
+146 val_146
+362 val_362
+18 val_18
+281 val_281
+344 val_344
+448 val_448
+222 val_222
+90 val_90
+169 val_169
+281 val_282
+245 val_246
+425 val_426
+272 val_273
+231 val_232
+448 val_449
+31 val_32
+443 val_444
+371 val_372
+402 val_403
+128 val_129
+240 val_241
+286 val_287
+335 val_336
+367 val_368
+59 val_60
+349 val_350
+123 val_124
+402 val_403
+128 val_129
+63 val_64
+344 val_345
+277 val_278
+114 val_115
+209 val_210
+281 val_282
+114 val_115
+254 val_255
+196 val_197
+86 val_87
+222 val_223
+411 val_412
+281 val_282
+68 val_69
+119 val_120
+376 val_377
+213 val_214
+132 val_133
+191 val_192
+349 val_350
+475 val_476
+399 val_400
+77 val_78
+114 val_115
+443 val_444
+484 val_485
+407 val_408
+367 val_368
+2 val_3
+349 val_350
+164 val_165
+326 val_327
+308 val_309
+119 val_120
+358 val_359
+105 val_106
+416 val_417
+77 val_78
+461 val_462
+40 val_41
+385 val_386
+259 val_260
+303 val_304
+245 val_246
+303 val_304
+277 val_278
+132 val_133
+443 val_444
+399 val_400
+317 val_318
+330 val_331
+209 val_210
+489 val_490
+295 val_296
+105 val_106
+204 val_205
+439 val_440
+457 val_458
+470 val_471
+196 val_197
+119 val_120
+268 val_269
+295 val_296
+407 val_408
+439 val_440
+335 val_336
+164 val_165
+349 val_350
+371 val_372
+123 val_124
+182 val_183
+353 val_354
+371 val_372
+385 val_386
+40 val_41
+259 val_260
+178 val_179
+100 val_101
+22 val_23
+402 val_403
+137 val_138
+196 val_197
+100 val_101
+407 val_408
+371 val_372
+308 val_309
+178 val_179
+457 val_458
+227 val_228
Modified: hadoop/core/branches/branch-0.19/src/contrib/hive/ql/src/test/results/clientpositive/sample6.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/branches/branch-0.19/src/contrib/hive/ql/src/test/results/clientpositive/sample6.q.out?rev=706708&r1=706707&r2=706708&view=diff
==============================================================================
--- hadoop/core/branches/branch-0.19/src/contrib/hive/ql/src/test/results/clientpositive/sample6.q.out (original)
+++ hadoop/core/branches/branch-0.19/src/contrib/hive/ql/src/test/results/clientpositive/sample6.q.out Tue Oct 21 11:29:18 2008
@@ -8,32 +8,11 @@
STAGE PLANS:
Stage: Stage-1
Map Reduce
- Path -> Alias:
- file:/data/zshao/trunk/VENDOR/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/srcbucket
- Path -> Partition:
- file:/data/zshao/trunk/VENDOR/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/srcbucket
- Partition
-
- properties:
- name srcbucket
- bucket_field_name
- serialization.format 1
- columns key,value
- field_to_dimension
- bucket_count 2
- serialization.lib simple_meta
- file.inputformat org.apache.hadoop.mapred.TextInputFormat
- file.outputformat org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
- location file:/data/zshao/trunk/VENDOR/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/srcbucket
- name: srcbucket
- serde: simple_meta
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
Alias -> Map Operator Tree:
s
Filter Operator
predicate:
- expr: (((default_sample_hashfn(key) & 2147483647) % 4) = 1)
+ expr: (((default_sample_hashfn(key) & 2147483647) % 4) = 0)
type: Boolean
Select Operator
expressions:
@@ -42,284 +21,318 @@
expr: value
type: string
File Output Operator
+ directory: /tmp/hive-njain/391691394/413823912.10000.insclause-0
table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
properties:
name dest1
- bucket_field_name
+ serialization.ddl struct dest1 { i32 key, string value}
serialization.format 1
columns key,value
SORTBUCKETCOLSPREFIX TRUE
- field_to_dimension
bucket_count -1
- serialization.lib simple_meta
+ 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:/data/zshao/trunk/VENDOR/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/dest1
+ 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
- serde: simple_meta
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
- directory: /tmp/hive-zshao/6950986.10000.insclause-0
Needs Tagging:
+ Path -> Alias:
+ file:/home/njain/workspace/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/srcbucket
+ Path -> Partition:
+ file:/home/njain/workspace/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/srcbucket
+ Partition
+
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ properties:
+ name srcbucket
+ serialization.ddl struct srcbucket { string key, string value}
+ serialization.format 1
+ columns key,value
+ bucket_count 2
+ 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/srcbucket
+ serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+ name: srcbucket
Stage: Stage-0
Move Operator
tables:
+ replace:
+ source: /tmp/hive-njain/391691394/413823912.10000.insclause-0
table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
properties:
name dest1
- bucket_field_name
+ serialization.ddl struct dest1 { i32 key, string value}
serialization.format 1
columns key,value
SORTBUCKETCOLSPREFIX TRUE
- field_to_dimension
bucket_count -1
- serialization.lib simple_meta
+ 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:/data/zshao/trunk/VENDOR/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/dest1
+ 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
- serde: simple_meta
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
- replace:
- source: /tmp/hive-zshao/6950986.10000.insclause-0
-
-
-27 val_27
-409 val_409
-265 val_265
-401 val_401
-166 val_166
-430 val_430
-287 val_287
-207 val_207
-199 val_199
-247 val_247
-489 val_489
-162 val_162
-397 val_397
-342 val_342
-195 val_195
-155 val_155
-203 val_203
-339 val_339
-302 val_302
-438 val_438
-489 val_489
-221 val_221
-92 val_92
-111 val_111
-427 val_427
-382 val_382
-386 val_386
-430 val_430
-221 val_221
-137 val_137
-180 val_180
-12 val_12
-67 val_67
-489 val_489
-353 val_353
-272 val_272
-463 val_463
-119 val_119
-496 val_496
-393 val_393
-100 val_100
-298 val_298
-199 val_199
-191 val_191
-96 val_96
-481 val_481
-409 val_409
-470 val_470
-137 val_137
-85 val_85
-364 val_364
-306 val_306
-272 val_272
-331 val_331
-401 val_401
-452 val_452
-177 val_177
-5 val_5
-317 val_317
-34 val_34
-229 val_229
-195 val_195
-430 val_430
-119 val_119
-489 val_489
-78 val_78
-41 val_41
-492 val_492
-449 val_449
-218 val_218
-30 val_30
-74 val_74
-342 val_342
-368 val_368
-485 val_485
-70 val_70
-401 val_401
-191 val_191
-5 val_5
-438 val_438
-467 val_467
-229 val_229
-463 val_463
-283 val_283
-331 val_331
-335 val_335
-104 val_104
-409 val_409
-401 val_401
-258 val_258
-203 val_203
-12 val_12
-478 val_478
-298 val_298
-382 val_382
-5 val_5
-70 val_70
-397 val_397
-104 val_104
-70 val_70
-438 val_438
-119 val_119
-360 val_360
-199 val_199
-478 val_478
-317 val_317
-207 val_207
-265 val_265
-353 val_353
-214 val_214
-133 val_133
-375 val_375
-401 val_401
-67 val_67
-379 val_379
-492 val_492
-100 val_100
-298 val_298
-9 val_9
-126 val_126
-474 val_475
-423 val_424
-177 val_178
-272 val_273
-287 val_288
-126 val_127
-441 val_442
-371 val_372
-243 val_244
-133 val_134
-485 val_486
-85 val_86
-335 val_336
-485 val_486
-393 val_394
-409 val_410
-265 val_266
-63 val_64
-331 val_332
-56 val_57
-254 val_255
-492 val_493
-5 val_6
-438 val_439
-360 val_361
-467 val_468
-16 val_17
-119 val_120
-492 val_493
-306 val_307
-393 val_394
-427 val_428
-386 val_387
-184 val_185
-375 val_376
-191 val_192
-122 val_123
-438 val_439
-23 val_24
-328 val_329
-382 val_383
-342 val_343
-331 val_332
-409 val_410
-463 val_464
-177 val_178
-258 val_259
-104 val_105
-140 val_141
-30 val_31
-405 val_406
-119 val_120
-49 val_50
-416 val_417
-199 val_200
-375 val_376
-89 val_90
-386 val_387
-364 val_365
-89 val_90
-52 val_53
-313 val_314
-324 val_325
-328 val_329
-122 val_123
-104 val_105
-481 val_482
-70 val_71
-52 val_53
-317 val_318
-412 val_413
-16 val_17
-375 val_376
-489 val_490
-126 val_127
-470 val_471
-302 val_303
-119 val_120
-375 val_376
-287 val_288
-375 val_376
-12 val_13
-151 val_152
-52 val_53
-104 val_105
-335 val_336
-371 val_372
-496 val_497
-144 val_145
-382 val_383
-122 val_123
-427 val_428
-474 val_475
-353 val_354
-52 val_53
-261 val_262
-371 val_372
-412 val_413
-49 val_50
-478 val_479
-243 val_244
-151 val_152
-100 val_101
-401 val_402
-137 val_138
-162 val_163
-276 val_277
-78 val_79
-379 val_380
-100 val_101
-371 val_372
-430 val_431
-478 val_479
-1 val_2
-89 val_90
+165 val_165
+484 val_484
+150 val_150
+224 val_224
+66 val_66
+213 val_213
+374 val_374
+495 val_495
+37 val_37
+327 val_327
+15 val_15
+338 val_338
+459 val_459
+466 val_466
+396 val_396
+309 val_309
+367 val_367
+0 val_0
+455 val_455
+316 val_316
+345 val_345
+129 val_129
+378 val_378
+4 val_4
+356 val_356
+169 val_169
+125 val_125
+437 val_437
+286 val_286
+187 val_187
+176 val_176
+459 val_459
+51 val_51
+103 val_103
+239 val_239
+213 val_213
+176 val_176
+275 val_275
+260 val_260
+404 val_404
+217 val_217
+84 val_84
+466 val_466
+8 val_8
+411 val_411
+172 val_172
+129 val_129
+158 val_158
+0 val_0
+26 val_26
+165 val_165
+327 val_327
+51 val_51
+404 val_404
+95 val_95
+282 val_282
+187 val_187
+316 val_316
+169 val_169
+77 val_77
+0 val_0
+118 val_118
+282 val_282
+419 val_419
+15 val_15
+118 val_118
+19 val_19
+224 val_224
+309 val_309
+389 val_389
+327 val_327
+242 val_242
+392 val_392
+242 val_242
+396 val_396
+95 val_95
+11 val_11
+143 val_143
+228 val_228
+33 val_33
+103 val_103
+367 val_367
+239 val_239
+480 val_480
+202 val_202
+316 val_316
+235 val_235
+80 val_80
+44 val_44
+466 val_466
+257 val_257
+190 val_190
+114 val_114
+396 val_396
+217 val_217
+125 val_125
+187 val_187
+480 val_480
+491 val_491
+305 val_305
+444 val_444
+169 val_169
+323 val_323
+480 val_480
+136 val_136
+172 val_172
+462 val_462
+26 val_26
+462 val_462
+341 val_341
+183 val_183
+84 val_84
+37 val_37
+448 val_448
+194 val_194
+477 val_477
+169 val_169
+400 val_400
+62 val_63
+271 val_272
+217 val_218
+455 val_456
+231 val_232
+448 val_449
+246 val_247
+440 val_441
+147 val_148
+356 val_357
+217 val_218
+33 val_34
+15 val_16
+110 val_111
+275 val_276
+0 val_1
+293 val_294
+286 val_287
+408 val_409
+477 val_478
+455 val_456
+99 val_100
+367 val_368
+59 val_60
+48 val_49
+488 val_489
+349 val_350
+11 val_12
+161 val_162
+224 val_225
+4 val_5
+206 val_207
+114 val_115
+239 val_240
+389 val_390
+114 val_115
+235 val_236
+165 val_166
+264 val_265
+11 val_12
+129 val_130
+257 val_258
+323 val_324
+411 val_412
+338 val_339
+147 val_148
+473 val_474
+213 val_214
+426 val_427
+132 val_133
+121 val_122
+129 val_130
+246 val_247
+491 val_492
+352 val_353
+349 val_350
+480 val_481
+480 val_481
+183 val_184
+15 val_16
+392 val_393
+77 val_78
+275 val_276
+114 val_115
+161 val_162
+264 val_265
+48 val_49
+484 val_485
+305 val_306
+367 val_368
+260 val_261
+349 val_350
+51 val_52
+363 val_364
+118 val_119
+19 val_20
+80 val_81
+121 val_122
+239 val_240
+11 val_12
+143 val_144
+341 val_342
+363 val_364
+77 val_78
+293 val_294
+40 val_41
+8 val_9
+206 val_207
+381 val_382
+404 val_405
+206 val_207
+385 val_386
+260 val_261
+404 val_405
+451 val_452
+132 val_133
+356 val_357
+352 val_353
+330 val_331
+257 val_258
+374 val_375
+437 val_438
+334 val_335
+404 val_405
+0 val_1
+268 val_269
+491 val_492
+392 val_393
+341 val_342
+118 val_119
+172 val_173
+136 val_137
+349 val_350
+462 val_463
+408 val_409
+378 val_379
+495 val_496
+385 val_386
+40 val_41
+389 val_390
+125 val_126
+415 val_416
+228 val_229
+363 val_364
+22 val_23
+459 val_460
+62 val_63
+341 val_342
+440 val_441
+309 val_310
+161 val_162
+161 val_162
+91 val_92
+118 val_119
+242 val_243
Modified: hadoop/core/branches/branch-0.19/src/contrib/hive/ql/src/test/results/clientpositive/sample7.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/branches/branch-0.19/src/contrib/hive/ql/src/test/results/clientpositive/sample7.q.out?rev=706708&r1=706707&r2=706708&view=diff
==============================================================================
--- hadoop/core/branches/branch-0.19/src/contrib/hive/ql/src/test/results/clientpositive/sample7.q.out (original)
+++ hadoop/core/branches/branch-0.19/src/contrib/hive/ql/src/test/results/clientpositive/sample7.q.out Tue Oct 21 11:29:18 2008
@@ -8,32 +8,11 @@
STAGE PLANS:
Stage: Stage-1
Map Reduce
- Path -> Alias:
- file:/data/zshao/trunk/VENDOR/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/srcbucket
- Path -> Partition:
- file:/data/zshao/trunk/VENDOR/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/srcbucket
- Partition
-
- properties:
- name srcbucket
- bucket_field_name
- serialization.format 1
- columns key,value
- field_to_dimension
- bucket_count 2
- serialization.lib simple_meta
- file.inputformat org.apache.hadoop.mapred.TextInputFormat
- file.outputformat org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
- location file:/data/zshao/trunk/VENDOR/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/srcbucket
- name: srcbucket
- serde: simple_meta
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
Alias -> Map Operator Tree:
s
Filter Operator
predicate:
- expr: (((default_sample_hashfn(key) & 2147483647) % 4) = 1)
+ expr: (((default_sample_hashfn(key) & 2147483647) % 4) = 0)
type: Boolean
Filter Operator
predicate:
@@ -46,239 +25,269 @@
expr: value
type: string
File Output Operator
+ directory: /tmp/hive-njain/1265167991/144531187.10000.insclause-0
table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
properties:
name dest1
- bucket_field_name
+ serialization.ddl struct dest1 { i32 key, string value}
serialization.format 1
columns key,value
SORTBUCKETCOLSPREFIX TRUE
- field_to_dimension
bucket_count -1
- serialization.lib simple_meta
+ 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:/data/zshao/trunk/VENDOR/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/dest1
+ 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
- serde: simple_meta
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
- directory: /tmp/hive-zshao/484898228.10000.insclause-0
Needs Tagging:
+ Path -> Alias:
+ file:/home/njain/workspace/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/srcbucket
+ Path -> Partition:
+ file:/home/njain/workspace/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/srcbucket
+ Partition
+
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ properties:
+ name srcbucket
+ serialization.ddl struct srcbucket { string key, string value}
+ serialization.format 1
+ columns key,value
+ bucket_count 2
+ 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/srcbucket
+ serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+ name: srcbucket
Stage: Stage-0
Move Operator
tables:
+ replace:
+ source: /tmp/hive-njain/1265167991/144531187.10000.insclause-0
table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
properties:
name dest1
- bucket_field_name
+ serialization.ddl struct dest1 { i32 key, string value}
serialization.format 1
columns key,value
SORTBUCKETCOLSPREFIX TRUE
- field_to_dimension
bucket_count -1
- serialization.lib simple_meta
+ 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:/data/zshao/trunk/VENDOR/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/dest1
+ 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
- serde: simple_meta
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
- replace:
- source: /tmp/hive-zshao/484898228.10000.insclause-0
-
-
-409 val_409
-265 val_265
-401 val_401
-166 val_166
-430 val_430
-287 val_287
-207 val_207
-199 val_199
-247 val_247
-489 val_489
-162 val_162
-397 val_397
-342 val_342
-195 val_195
-155 val_155
-203 val_203
-339 val_339
-302 val_302
-438 val_438
-489 val_489
-221 val_221
-111 val_111
-427 val_427
-382 val_382
-386 val_386
-430 val_430
-221 val_221
-137 val_137
-180 val_180
-489 val_489
-353 val_353
-272 val_272
-463 val_463
-119 val_119
-496 val_496
-393 val_393
-298 val_298
-199 val_199
-191 val_191
-481 val_481
-409 val_409
-470 val_470
-137 val_137
-364 val_364
-306 val_306
-272 val_272
-331 val_331
-401 val_401
-452 val_452
-177 val_177
-317 val_317
-229 val_229
-195 val_195
-430 val_430
-119 val_119
-489 val_489
-492 val_492
-449 val_449
-218 val_218
-342 val_342
-368 val_368
-485 val_485
-401 val_401
-191 val_191
-438 val_438
-467 val_467
-229 val_229
-463 val_463
-283 val_283
-331 val_331
-335 val_335
-104 val_104
-409 val_409
-401 val_401
-258 val_258
-203 val_203
-478 val_478
-298 val_298
-382 val_382
-397 val_397
-104 val_104
-438 val_438
-119 val_119
-360 val_360
-199 val_199
-478 val_478
-317 val_317
-207 val_207
-265 val_265
-353 val_353
-214 val_214
-133 val_133
-375 val_375
-401 val_401
-379 val_379
-492 val_492
-298 val_298
-126 val_126
-474 val_475
-423 val_424
-177 val_178
-272 val_273
-287 val_288
-126 val_127
-441 val_442
-371 val_372
-243 val_244
-133 val_134
-485 val_486
-335 val_336
-485 val_486
-393 val_394
-409 val_410
-265 val_266
-331 val_332
-254 val_255
-492 val_493
-438 val_439
-360 val_361
-467 val_468
-119 val_120
-492 val_493
-306 val_307
-393 val_394
-427 val_428
-386 val_387
-184 val_185
-375 val_376
-191 val_192
-122 val_123
-438 val_439
-328 val_329
-382 val_383
-342 val_343
-331 val_332
-409 val_410
-463 val_464
-177 val_178
-258 val_259
-104 val_105
-140 val_141
-405 val_406
-119 val_120
-416 val_417
-199 val_200
-375 val_376
-386 val_387
-364 val_365
-313 val_314
-324 val_325
-328 val_329
-122 val_123
-104 val_105
-481 val_482
-317 val_318
-412 val_413
-375 val_376
-489 val_490
-126 val_127
-470 val_471
-302 val_303
-119 val_120
-375 val_376
-287 val_288
-375 val_376
-151 val_152
-104 val_105
-335 val_336
-371 val_372
-496 val_497
-144 val_145
-382 val_383
-122 val_123
-427 val_428
-474 val_475
-353 val_354
-261 val_262
-371 val_372
-412 val_413
-478 val_479
-243 val_244
-151 val_152
-401 val_402
-137 val_138
-162 val_163
-276 val_277
-379 val_380
-371 val_372
-430 val_431
-478 val_479
+165 val_165
+484 val_484
+150 val_150
+224 val_224
+213 val_213
+374 val_374
+495 val_495
+327 val_327
+338 val_338
+459 val_459
+466 val_466
+396 val_396
+309 val_309
+367 val_367
+455 val_455
+316 val_316
+345 val_345
+129 val_129
+378 val_378
+356 val_356
+169 val_169
+125 val_125
+437 val_437
+286 val_286
+187 val_187
+176 val_176
+459 val_459
+103 val_103
+239 val_239
+213 val_213
+176 val_176
+275 val_275
+260 val_260
+404 val_404
+217 val_217
+466 val_466
+411 val_411
+172 val_172
+129 val_129
+158 val_158
+165 val_165
+327 val_327
+404 val_404
+282 val_282
+187 val_187
+316 val_316
+169 val_169
+118 val_118
+282 val_282
+419 val_419
+118 val_118
+224 val_224
+309 val_309
+389 val_389
+327 val_327
+242 val_242
+392 val_392
+242 val_242
+396 val_396
+143 val_143
+228 val_228
+103 val_103
+367 val_367
+239 val_239
+480 val_480
+202 val_202
+316 val_316
+235 val_235
+466 val_466
+257 val_257
+190 val_190
+114 val_114
+396 val_396
+217 val_217
+125 val_125
+187 val_187
+480 val_480
+491 val_491
+305 val_305
+444 val_444
+169 val_169
+323 val_323
+480 val_480
+136 val_136
+172 val_172
+462 val_462
+462 val_462
+341 val_341
+183 val_183
+448 val_448
+194 val_194
+477 val_477
+169 val_169
+400 val_400
+271 val_272
+217 val_218
+455 val_456
+231 val_232
+448 val_449
+246 val_247
+440 val_441
+147 val_148
+356 val_357
+217 val_218
+110 val_111
+275 val_276
+293 val_294
+286 val_287
+408 val_409
+477 val_478
+455 val_456
+367 val_368
+488 val_489
+349 val_350
+161 val_162
+224 val_225
+206 val_207
+114 val_115
+239 val_240
+389 val_390
+114 val_115
+235 val_236
+165 val_166
+264 val_265
+129 val_130
+257 val_258
+323 val_324
+411 val_412
+338 val_339
+147 val_148
+473 val_474
+213 val_214
+426 val_427
+132 val_133
+121 val_122
+129 val_130
+246 val_247
+491 val_492
+352 val_353
+349 val_350
+480 val_481
+480 val_481
+183 val_184
+392 val_393
+275 val_276
+114 val_115
+161 val_162
+264 val_265
+484 val_485
+305 val_306
+367 val_368
+260 val_261
+349 val_350
+363 val_364
+118 val_119
+121 val_122
+239 val_240
+143 val_144
+341 val_342
+363 val_364
+293 val_294
+206 val_207
+381 val_382
+404 val_405
+206 val_207
+385 val_386
+260 val_261
+404 val_405
+451 val_452
+132 val_133
+356 val_357
+352 val_353
+330 val_331
+257 val_258
+374 val_375
+437 val_438
+334 val_335
+404 val_405
+268 val_269
+491 val_492
+392 val_393
+341 val_342
+118 val_119
+172 val_173
+136 val_137
+349 val_350
+462 val_463
+408 val_409
+378 val_379
+495 val_496
+385 val_386
+389 val_390
+125 val_126
+415 val_416
+228 val_229
+363 val_364
+459 val_460
+341 val_342
+440 val_441
+309 val_310
+161 val_162
+161 val_162
+118 val_119
+242 val_243
Modified: hadoop/core/branches/branch-0.19/src/contrib/hive/ql/src/test/results/clientpositive/subq.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/branches/branch-0.19/src/contrib/hive/ql/src/test/results/clientpositive/subq.q.out?rev=706708&r1=706707&r2=706708&view=diff
==============================================================================
--- hadoop/core/branches/branch-0.19/src/contrib/hive/ql/src/test/results/clientpositive/subq.q.out (original)
+++ hadoop/core/branches/branch-0.19/src/contrib/hive/ql/src/test/results/clientpositive/subq.q.out Tue Oct 21 11:29:18 2008
@@ -34,8 +34,8 @@
Stage: Stage-0
Move Operator
files:
- destination: ../../../../build/contrib/hive/ql/test/data/warehouse/union.out
hdfs directory:
+ destination: ../../../../build/contrib/hive/ql/test/data/warehouse/union.out
86val_86
Modified: hadoop/core/branches/branch-0.19/src/contrib/hive/ql/src/test/results/clientpositive/udf1.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/branches/branch-0.19/src/contrib/hive/ql/src/test/results/clientpositive/udf1.q.out?rev=706708&r1=706707&r2=706708&view=diff
==============================================================================
--- hadoop/core/branches/branch-0.19/src/contrib/hive/ql/src/test/results/clientpositive/udf1.q.out (original)
+++ hadoop/core/branches/branch-0.19/src/contrib/hive/ql/src/test/results/clientpositive/udf1.q.out Tue Oct 21 11:29:18 2008
@@ -52,21 +52,20 @@
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
true false true true true false false false true true false true false acc abc abb hive
-
Modified: hadoop/core/branches/branch-0.19/src/contrib/hive/ql/src/test/results/clientpositive/udf2.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/branches/branch-0.19/src/contrib/hive/ql/src/test/results/clientpositive/udf2.q.out?rev=706708&r1=706707&r2=706708&view=diff
==============================================================================
--- hadoop/core/branches/branch-0.19/src/contrib/hive/ql/src/test/results/clientpositive/udf2.q.out (original)
+++ hadoop/core/branches/branch-0.19/src/contrib/hive/ql/src/test/results/clientpositive/udf2.q.out Tue Oct 21 11:29:18 2008
@@ -1,509 +1,39 @@
-ABSTRACT SYNTAX TREE:
- (TOK_CREATEFUNCTION testlength 'org.apache.hadoop.hive.ql.udf.UDFTestLength')
-
-STAGE DEPENDENCIES:
- Stage-0 is a root stage
-
-STAGE PLANS:
- Stage: Stage-0
-
-7
-6
-7
-6
-7
-7
-7
-7
-6
-7
-7
-7
-7
-7
-7
-7
-7
-6
-7
-7
-7
-7
-7
-7
-7
-7
-7
-7
-6
-7
-7
-7
-7
-6
-6
-7
-7
-7
-7
-7
-7
-7
-7
-7
-7
-7
-7
-7
-7
-7
-7
-7
-7
-7
-7
-7
-7
-7
-7
-7
-7
-7
-7
-7
-7
-7
-7
-7
-7
-7
-7
-7
-7
-7
-7
-7
-7
-6
-7
-7
-7
-7
-5
-7
-7
-7
-7
-6
-7
-7
-7
-7
-7
-7
-7
-6
-7
-7
-7
-7
-6
-7
-6
-6
-5
-7
-6
-7
-7
-7
-7
-7
-7
-7
-7
-7
-7
-7
-7
-7
-7
-7
-7
-6
-7
-6
-7
-7
-7
-7
-7
-7
-7
-7
-7
-7
-6
-7
-7
-7
-7
-7
-7
-6
-7
-7
-7
-6
-7
-7
-6
-7
-7
-7
-7
-7
-7
-7
-7
-7
-6
-7
-7
-6
-5
-7
-7
-7
-7
-6
-7
-7
-7
-7
-6
-7
-7
-7
-7
-5
-7
-7
-7
-7
-7
-7
-7
-7
-7
-7
-6
-6
-7
-7
-7
-7
-7
-7
-6
-7
-6
-7
-7
-7
-7
-7
-6
-7
-7
-7
-7
-6
-7
-7
-7
-7
-7
-7
-7
-7
-7
-7
-7
-7
-6
-6
-5
-7
-6
-7
-7
-7
-7
-7
-7
-7
-7
-7
-6
-7
-6
-6
-7
-6
-7
-6
-7
-7
-7
-7
-7
-7
-7
-7
-7
-7
-7
-7
-7
-7
-7
-7
-7
-5
-7
-7
-7
-7
-7
-6
-6
-7
-6
-6
-7
-6
-7
-7
-7
-7
-7
-7
-7
-7
-6
-7
-7
-7
-7
-7
-6
-6
-6
-7
-7
-7
-7
-7
-7
-7
-7
-6
-7
-6
-7
-6
-6
-7
-6
-7
-6
-7
-7
-7
-7
-7
-7
-7
-7
-7
-7
-7
-7
-7
-7
-7
-7
-6
-7
-7
-7
-7
-7
-5
-7
-7
-7
-7
-7
-7
-7
-7
-7
-7
-7
-5
-6
-7
-7
-7
-6
-6
-7
-7
-7
-7
-7
-7
-7
-7
-7
-6
-7
-7
-7
-7
-7
-7
-7
-7
-7
-6
-7
-7
-7
-7
-6
-7
-7
-7
-7
-7
-7
-7
-7
-7
-7
-7
-7
-7
-7
-5
-6
-7
-7
-7
-6
-7
-7
-7
-6
-7
-7
-7
-7
-7
-7
-7
-7
-7
-7
-7
-7
-7
-7
-7
-7
-7
-7
-7
-7
-7
-7
-7
-7
-7
-7
-7
-7
-7
-7
-7
-7
-7
-7
-7
-6
-7
-7
-7
-7
-7
-7
-7
-7
-7
-7
-7
-7
-7
-7
-7
-7
-7
-6
-7
-6
-7
-7
-6
-7
-7
-7
-7
-5
-7
-7
-7
-7
-7
-7
-7
-7
-7
-6
-7
-7
-7
-7
-6
-7
-7
-6
-6
-6
-7
-7
-7
-7
-7
-7
-7
-7
-7
-6
-7
-7
-7
-7
-6
+ABSTRACT SYNTAX TREE:
+ (TOK_QUERY (TOK_FROM (TOK_TABREF dest1)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR '|') (TOK_SELEXPR (TOK_FUNCTION trim (TOK_COLREF dest1 c1))) (TOK_SELEXPR '|') (TOK_SELEXPR (TOK_FUNCTION rtrim (TOK_COLREF dest1 c1))) (TOK_SELEXPR '|') (TOK_SELEXPR (TOK_FUNCTION ltrim (TOK_COLREF dest1 c1))) (TOK_SELEXPR '|'))))
+
+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:
+ dest1
+ Select Operator
+ expressions:
+ expr: '|'
+ type: string
+ expr: trim(c1)
+ type: string
+ expr: '|'
+ type: string
+ expr: rtrim(c1)
+ type: string
+ expr: '|'
+ type: string
+ expr: ltrim(c1)
+ type: string
+ expr: '|'
+ type: string
+ 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: -1
+
+
+| abc | abc | abc |
Modified: hadoop/core/branches/branch-0.19/src/contrib/hive/ql/src/test/results/clientpositive/union.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/branches/branch-0.19/src/contrib/hive/ql/src/test/results/clientpositive/union.q.out?rev=706708&r1=706707&r2=706708&view=diff
==============================================================================
--- hadoop/core/branches/branch-0.19/src/contrib/hive/ql/src/test/results/clientpositive/union.q.out (original)
+++ hadoop/core/branches/branch-0.19/src/contrib/hive/ql/src/test/results/clientpositive/union.q.out Tue Oct 21 11:29:18 2008
@@ -55,8 +55,8 @@
Stage: Stage-0
Move Operator
files:
- destination: ../../../../build/contrib/hive/ql/test/data/warehouse/union.out
hdfs directory:
+ destination: ../../../../build/contrib/hive/ql/test/data/warehouse/union.out
238val_238
Modified: hadoop/core/branches/branch-0.19/src/contrib/hive/ql/src/test/results/compiler/parse/input_testxpath.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/branches/branch-0.19/src/contrib/hive/ql/src/test/results/compiler/parse/input_testxpath.q.out?rev=706708&r1=706707&r2=706708&view=diff
==============================================================================
--- hadoop/core/branches/branch-0.19/src/contrib/hive/ql/src/test/results/compiler/parse/input_testxpath.q.out (original)
+++ hadoop/core/branches/branch-0.19/src/contrib/hive/ql/src/test/results/compiler/parse/input_testxpath.q.out Tue Oct 21 11:29:18 2008
@@ -1 +1 @@
-(TOK_QUERY (TOK_FROM (TOK_TABREF src_thrift)) (TOK_INSERT (TOK_DESTINATION (TOK_TAB dest1)) (TOK_SELECT (TOK_SELEXPR ([ (TOK_COLREF src_thrift lint) 1)) (TOK_SELEXPR (. ([ (TOK_COLREF src_thrift lintstring) 0) mystring))))) null
\ No newline at end of file
+(TOK_QUERY (TOK_FROM (TOK_TABREF src_thrift)) (TOK_INSERT (TOK_DESTINATION (TOK_TAB dest1)) (TOK_SELECT (TOK_SELEXPR ([ (TOK_COLREF src_thrift lint) 1)) (TOK_SELEXPR (. ([ (TOK_COLREF src_thrift lintstring) 0) mystring)) (TOK_SELEXPR ([ (TOK_COLREF src_thrift mstringstring) 'key_2'))))) null
\ No newline at end of file