You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by na...@apache.org on 2009/11/12 22:36:59 UTC
svn commit: r835568 [6/13] - in /hadoop/hive/trunk:
metastore/src/java/org/apache/hadoop/hive/metastore/
ql/src/java/org/apache/hadoop/hive/ql/exec/
ql/src/java/org/apache/hadoop/hive/ql/io/
ql/src/java/org/apache/hadoop/hive/ql/metadata/ ql/src/java/o...
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/sample2.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/sample2.q.out?rev=835568&r1=835567&r2=835568&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/sample2.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/sample2.q.out Thu Nov 12 21:36:56 2009
@@ -50,7 +50,7 @@
File Output Operator
compressed: false
GlobalTableId: 1
- directory: file:/data/users/njain/hive3/hive3/build/ql/tmp/897548542/10002
+ directory: file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/tmp/1467814280/10002
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -64,16 +64,31 @@
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/data/users/njain/hive3/hive3/build/ql/test/data/warehouse/dest1
- transient_lastDdlTime 1254944305
+ location file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/dest1
+ transient_lastDdlTime 1258006718
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: dest1
Needs Tagging: false
Path -> Alias:
- file:/data/users/njain/hive3/hive3/build/ql/test/data/warehouse/srcbucket/srcbucket0.txt [s]
+ file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/srcbucket/srcbucket0.txt [s]
Path -> Partition:
- file:/data/users/njain/hive3/hive3/build/ql/test/data/warehouse/srcbucket/srcbucket0.txt
+ file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/srcbucket/srcbucket0.txt
Partition
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ properties:
+ name srcbucket
+ columns.types int:string
+ bucket_field_name key
+ serialization.ddl struct srcbucket { i32 key, string value}
+ columns key,value
+ serialization.format 1
+ bucket_count 2
+ serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ file.inputformat org.apache.hadoop.mapred.TextInputFormat
+ file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ location file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/srcbucket
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -88,10 +103,11 @@
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/data/users/njain/hive3/hive3/build/ql/test/data/warehouse/srcbucket
- transient_lastDdlTime 1254944304
+ location file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/srcbucket
+ transient_lastDdlTime 1258006717
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: srcbucket
+ name: srcbucket
Stage: Stage-4
Conditional Operator
@@ -99,11 +115,11 @@
Move Operator
files:
hdfs directory: true
- source: file:/data/users/njain/hive3/hive3/build/ql/tmp/897548542/10002
- destination: file:/data/users/njain/hive3/hive3/build/ql/tmp/1726881559/10000
+ source: file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/tmp/1467814280/10002
+ destination: file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/tmp/1089152114/10000
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/njain/hive3/hive3/build/ql/tmp/897548542/10002
+ file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/tmp/1467814280/10002
Reduce Output Operator
sort order:
Map-reduce partition columns:
@@ -117,10 +133,25 @@
type: string
Needs Tagging: false
Path -> Alias:
- file:/data/users/njain/hive3/hive3/build/ql/tmp/897548542/10002 [file:/data/users/njain/hive3/hive3/build/ql/tmp/897548542/10002]
+ file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/tmp/1467814280/10002 [file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/tmp/1467814280/10002]
Path -> Partition:
- file:/data/users/njain/hive3/hive3/build/ql/tmp/897548542/10002
+ file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/tmp/1467814280/10002
Partition
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ properties:
+ name dest1
+ columns.types int:string
+ serialization.ddl struct dest1 { i32 key, string value}
+ serialization.format 1
+ columns key,value
+ bucket_count -1
+ serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ file.inputformat org.apache.hadoop.mapred.TextInputFormat
+ file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ location file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/dest1
+ transient_lastDdlTime 1258006718
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -134,16 +165,17 @@
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/data/users/njain/hive3/hive3/build/ql/test/data/warehouse/dest1
- transient_lastDdlTime 1254944305
+ location file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/dest1
+ transient_lastDdlTime 1258006718
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: dest1
+ name: dest1
Reduce Operator Tree:
Extract
File Output Operator
compressed: false
GlobalTableId: 0
- directory: file:/data/users/njain/hive3/hive3/build/ql/tmp/1726881559/10000
+ directory: file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/tmp/1089152114/10000
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -156,9 +188,9 @@
bucket_count -1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
file.inputformat org.apache.hadoop.mapred.TextInputFormat
- location file:/data/users/njain/hive3/hive3/build/ql/test/data/warehouse/dest1
+ location file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/dest1
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- transient_lastDdlTime 1254944305
+ transient_lastDdlTime 1258006718
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: dest1
@@ -166,7 +198,7 @@
Move Operator
tables:
replace: true
- source: file:/data/users/njain/hive3/hive3/build/ql/tmp/1726881559/10000
+ source: file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/tmp/1089152114/10000
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -180,11 +212,11 @@
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/data/users/njain/hive3/hive3/build/ql/test/data/warehouse/dest1
- transient_lastDdlTime 1254944305
+ location file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/dest1
+ transient_lastDdlTime 1258006718
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: dest1
- tmp directory: file:/data/users/njain/hive3/hive3/build/ql/tmp/1726881559/10001
+ tmp directory: file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/tmp/1089152114/10001
PREHOOK: query: INSERT OVERWRITE TABLE dest1 SELECT s.*
@@ -200,11 +232,11 @@
PREHOOK: query: SELECT dest1.* FROM dest1
PREHOOK: type: QUERY
PREHOOK: Input: default@dest1
-PREHOOK: Output: file:/data/users/njain/hive3/hive3/build/ql/tmp/917862347/10000
+PREHOOK: Output: file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/tmp/554645187/10000
POSTHOOK: query: SELECT dest1.* FROM dest1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@dest1
-POSTHOOK: Output: file:/data/users/njain/hive3/hive3/build/ql/tmp/917862347/10000
+POSTHOOK: Output: file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/tmp/554645187/10000
474 val_475
62 val_63
468 val_469
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/sample4.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/sample4.q.out?rev=835568&r1=835567&r2=835568&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/sample4.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/sample4.q.out Thu Nov 12 21:36:56 2009
@@ -50,7 +50,7 @@
File Output Operator
compressed: false
GlobalTableId: 1
- directory: file:/data/users/njain/hive3/hive3/build/ql/tmp/46051233/10002
+ directory: file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/tmp/958581322/10002
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -64,16 +64,31 @@
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/data/users/njain/hive3/hive3/build/ql/test/data/warehouse/dest1
- transient_lastDdlTime 1254944312
+ location file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/dest1
+ transient_lastDdlTime 1258006734
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: dest1
Needs Tagging: false
Path -> Alias:
- file:/data/users/njain/hive3/hive3/build/ql/test/data/warehouse/srcbucket/srcbucket0.txt [s]
+ file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/srcbucket/srcbucket0.txt [s]
Path -> Partition:
- file:/data/users/njain/hive3/hive3/build/ql/test/data/warehouse/srcbucket/srcbucket0.txt
+ file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/srcbucket/srcbucket0.txt
Partition
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ properties:
+ name srcbucket
+ columns.types int:string
+ bucket_field_name key
+ serialization.ddl struct srcbucket { i32 key, string value}
+ columns key,value
+ serialization.format 1
+ bucket_count 2
+ serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ file.inputformat org.apache.hadoop.mapred.TextInputFormat
+ file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ location file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/srcbucket
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -88,10 +103,11 @@
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/data/users/njain/hive3/hive3/build/ql/test/data/warehouse/srcbucket
- transient_lastDdlTime 1254944311
+ location file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/srcbucket
+ transient_lastDdlTime 1258006733
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: srcbucket
+ name: srcbucket
Stage: Stage-4
Conditional Operator
@@ -99,11 +115,11 @@
Move Operator
files:
hdfs directory: true
- source: file:/data/users/njain/hive3/hive3/build/ql/tmp/46051233/10002
- destination: file:/data/users/njain/hive3/hive3/build/ql/tmp/236890045/10000
+ source: file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/tmp/958581322/10002
+ destination: file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/tmp/1576074210/10000
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/njain/hive3/hive3/build/ql/tmp/46051233/10002
+ file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/tmp/958581322/10002
Reduce Output Operator
sort order:
Map-reduce partition columns:
@@ -117,10 +133,25 @@
type: string
Needs Tagging: false
Path -> Alias:
- file:/data/users/njain/hive3/hive3/build/ql/tmp/46051233/10002 [file:/data/users/njain/hive3/hive3/build/ql/tmp/46051233/10002]
+ file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/tmp/958581322/10002 [file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/tmp/958581322/10002]
Path -> Partition:
- file:/data/users/njain/hive3/hive3/build/ql/tmp/46051233/10002
+ file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/tmp/958581322/10002
Partition
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ properties:
+ name dest1
+ columns.types int:string
+ serialization.ddl struct dest1 { i32 key, string value}
+ serialization.format 1
+ columns key,value
+ bucket_count -1
+ serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ file.inputformat org.apache.hadoop.mapred.TextInputFormat
+ file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ location file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/dest1
+ transient_lastDdlTime 1258006734
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -134,16 +165,17 @@
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/data/users/njain/hive3/hive3/build/ql/test/data/warehouse/dest1
- transient_lastDdlTime 1254944312
+ location file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/dest1
+ transient_lastDdlTime 1258006734
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: dest1
+ name: dest1
Reduce Operator Tree:
Extract
File Output Operator
compressed: false
GlobalTableId: 0
- directory: file:/data/users/njain/hive3/hive3/build/ql/tmp/236890045/10000
+ directory: file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/tmp/1576074210/10000
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -156,9 +188,9 @@
bucket_count -1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
file.inputformat org.apache.hadoop.mapred.TextInputFormat
- location file:/data/users/njain/hive3/hive3/build/ql/test/data/warehouse/dest1
+ location file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/dest1
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- transient_lastDdlTime 1254944312
+ transient_lastDdlTime 1258006734
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: dest1
@@ -166,7 +198,7 @@
Move Operator
tables:
replace: true
- source: file:/data/users/njain/hive3/hive3/build/ql/tmp/236890045/10000
+ source: file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/tmp/1576074210/10000
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -180,11 +212,11 @@
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/data/users/njain/hive3/hive3/build/ql/test/data/warehouse/dest1
- transient_lastDdlTime 1254944312
+ location file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/dest1
+ transient_lastDdlTime 1258006734
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: dest1
- tmp directory: file:/data/users/njain/hive3/hive3/build/ql/tmp/236890045/10001
+ tmp directory: file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/tmp/1576074210/10001
PREHOOK: query: INSERT OVERWRITE TABLE dest1 SELECT s.*
@@ -200,11 +232,11 @@
PREHOOK: query: SELECT dest1.* FROM dest1
PREHOOK: type: QUERY
PREHOOK: Input: default@dest1
-PREHOOK: Output: file:/data/users/njain/hive3/hive3/build/ql/tmp/693740466/10000
+PREHOOK: Output: file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/tmp/863480403/10000
POSTHOOK: query: SELECT dest1.* FROM dest1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@dest1
-POSTHOOK: Output: file:/data/users/njain/hive3/hive3/build/ql/tmp/693740466/10000
+POSTHOOK: Output: file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/tmp/863480403/10000
474 val_475
62 val_63
468 val_469
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/sample5.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/sample5.q.out?rev=835568&r1=835567&r2=835568&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/sample5.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/sample5.q.out Thu Nov 12 21:36:56 2009
@@ -48,7 +48,7 @@
File Output Operator
compressed: false
GlobalTableId: 1
- directory: file:/data/users/njain/hive3/hive3/build/ql/tmp/1117961570/10002
+ directory: file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/tmp/1854013204/10002
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -62,16 +62,31 @@
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/data/users/njain/hive3/hive3/build/ql/test/data/warehouse/dest1
- transient_lastDdlTime 1254944317
+ location file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/dest1
+ transient_lastDdlTime 1258006741
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: dest1
Needs Tagging: false
Path -> Alias:
- file:/data/users/njain/hive3/hive3/build/ql/test/data/warehouse/srcbucket [s]
+ file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/srcbucket [s]
Path -> Partition:
- file:/data/users/njain/hive3/hive3/build/ql/test/data/warehouse/srcbucket
+ file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/srcbucket
Partition
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ properties:
+ name srcbucket
+ columns.types int:string
+ bucket_field_name key
+ serialization.ddl struct srcbucket { i32 key, string value}
+ columns key,value
+ serialization.format 1
+ bucket_count 2
+ serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ file.inputformat org.apache.hadoop.mapred.TextInputFormat
+ file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ location file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/srcbucket
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -86,10 +101,11 @@
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/data/users/njain/hive3/hive3/build/ql/test/data/warehouse/srcbucket
- transient_lastDdlTime 1254944317
+ location file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/srcbucket
+ transient_lastDdlTime 1258006740
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: srcbucket
+ name: srcbucket
Stage: Stage-4
Conditional Operator
@@ -97,11 +113,11 @@
Move Operator
files:
hdfs directory: true
- source: file:/data/users/njain/hive3/hive3/build/ql/tmp/1117961570/10002
- destination: file:/data/users/njain/hive3/hive3/build/ql/tmp/593215802/10000
+ source: file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/tmp/1854013204/10002
+ destination: file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/tmp/254012867/10000
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/njain/hive3/hive3/build/ql/tmp/1117961570/10002
+ file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/tmp/1854013204/10002
Reduce Output Operator
sort order:
Map-reduce partition columns:
@@ -115,10 +131,25 @@
type: string
Needs Tagging: false
Path -> Alias:
- file:/data/users/njain/hive3/hive3/build/ql/tmp/1117961570/10002 [file:/data/users/njain/hive3/hive3/build/ql/tmp/1117961570/10002]
+ file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/tmp/1854013204/10002 [file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/tmp/1854013204/10002]
Path -> Partition:
- file:/data/users/njain/hive3/hive3/build/ql/tmp/1117961570/10002
+ file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/tmp/1854013204/10002
Partition
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ properties:
+ name dest1
+ columns.types int:string
+ serialization.ddl struct dest1 { i32 key, string value}
+ serialization.format 1
+ columns key,value
+ bucket_count -1
+ serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ file.inputformat org.apache.hadoop.mapred.TextInputFormat
+ file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ location file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/dest1
+ transient_lastDdlTime 1258006741
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -132,16 +163,17 @@
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/data/users/njain/hive3/hive3/build/ql/test/data/warehouse/dest1
- transient_lastDdlTime 1254944317
+ location file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/dest1
+ transient_lastDdlTime 1258006741
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: dest1
+ name: dest1
Reduce Operator Tree:
Extract
File Output Operator
compressed: false
GlobalTableId: 0
- directory: file:/data/users/njain/hive3/hive3/build/ql/tmp/593215802/10000
+ directory: file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/tmp/254012867/10000
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -154,9 +186,9 @@
bucket_count -1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
file.inputformat org.apache.hadoop.mapred.TextInputFormat
- location file:/data/users/njain/hive3/hive3/build/ql/test/data/warehouse/dest1
+ location file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/dest1
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- transient_lastDdlTime 1254944317
+ transient_lastDdlTime 1258006741
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: dest1
@@ -164,7 +196,7 @@
Move Operator
tables:
replace: true
- source: file:/data/users/njain/hive3/hive3/build/ql/tmp/593215802/10000
+ source: file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/tmp/254012867/10000
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -178,11 +210,11 @@
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/data/users/njain/hive3/hive3/build/ql/test/data/warehouse/dest1
- transient_lastDdlTime 1254944317
+ location file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/dest1
+ transient_lastDdlTime 1258006741
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: dest1
- tmp directory: file:/data/users/njain/hive3/hive3/build/ql/tmp/593215802/10001
+ tmp directory: file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/tmp/254012867/10001
PREHOOK: query: INSERT OVERWRITE TABLE dest1 SELECT s.* -- here's another test
@@ -198,11 +230,11 @@
PREHOOK: query: SELECT dest1.* FROM dest1 SORT BY key, value
PREHOOK: type: QUERY
PREHOOK: Input: default@dest1
-PREHOOK: Output: file:/data/users/njain/hive3/hive3/build/ql/tmp/1381249846/10000
+PREHOOK: Output: file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/tmp/1898107810/10000
POSTHOOK: query: SELECT dest1.* FROM dest1 SORT BY key, value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@dest1
-POSTHOOK: Output: file:/data/users/njain/hive3/hive3/build/ql/tmp/1381249846/10000
+POSTHOOK: Output: file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/tmp/1898107810/10000
0 val_0
0 val_0
0 val_0
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/sample6.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/sample6.q.out?rev=835568&r1=835567&r2=835568&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/sample6.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/sample6.q.out Thu Nov 12 21:36:56 2009
@@ -48,7 +48,7 @@
File Output Operator
compressed: false
GlobalTableId: 1
- directory: file:/data/users/njain/hive3/hive3/build/ql/tmp/966636113/10002
+ directory: file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/tmp/2091516733/10002
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -62,16 +62,31 @@
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/data/users/njain/hive3/hive3/build/ql/test/data/warehouse/dest1
- transient_lastDdlTime 1254944329
+ location file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/dest1
+ transient_lastDdlTime 1258006761
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: dest1
Needs Tagging: false
Path -> Alias:
- file:/data/users/njain/hive3/hive3/build/ql/test/data/warehouse/srcbucket/srcbucket0.txt [s]
+ file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/srcbucket/srcbucket0.txt [s]
Path -> Partition:
- file:/data/users/njain/hive3/hive3/build/ql/test/data/warehouse/srcbucket/srcbucket0.txt
+ file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/srcbucket/srcbucket0.txt
Partition
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ properties:
+ name srcbucket
+ columns.types int:string
+ bucket_field_name key
+ serialization.ddl struct srcbucket { i32 key, string value}
+ columns key,value
+ serialization.format 1
+ bucket_count 2
+ serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ file.inputformat org.apache.hadoop.mapred.TextInputFormat
+ file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ location file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/srcbucket
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -86,10 +101,11 @@
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/data/users/njain/hive3/hive3/build/ql/test/data/warehouse/srcbucket
- transient_lastDdlTime 1254944329
+ location file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/srcbucket
+ transient_lastDdlTime 1258006760
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: srcbucket
+ name: srcbucket
Stage: Stage-4
Conditional Operator
@@ -97,11 +113,11 @@
Move Operator
files:
hdfs directory: true
- source: file:/data/users/njain/hive3/hive3/build/ql/tmp/966636113/10002
- destination: file:/data/users/njain/hive3/hive3/build/ql/tmp/1906830738/10000
+ source: file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/tmp/2091516733/10002
+ destination: file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/tmp/23996439/10000
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/njain/hive3/hive3/build/ql/tmp/966636113/10002
+ file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/tmp/2091516733/10002
Reduce Output Operator
sort order:
Map-reduce partition columns:
@@ -115,10 +131,25 @@
type: string
Needs Tagging: false
Path -> Alias:
- file:/data/users/njain/hive3/hive3/build/ql/tmp/966636113/10002 [file:/data/users/njain/hive3/hive3/build/ql/tmp/966636113/10002]
+ file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/tmp/2091516733/10002 [file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/tmp/2091516733/10002]
Path -> Partition:
- file:/data/users/njain/hive3/hive3/build/ql/tmp/966636113/10002
+ file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/tmp/2091516733/10002
Partition
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ properties:
+ name dest1
+ columns.types int:string
+ serialization.ddl struct dest1 { i32 key, string value}
+ serialization.format 1
+ columns key,value
+ bucket_count -1
+ serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ file.inputformat org.apache.hadoop.mapred.TextInputFormat
+ file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ location file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/dest1
+ transient_lastDdlTime 1258006761
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -132,16 +163,17 @@
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/data/users/njain/hive3/hive3/build/ql/test/data/warehouse/dest1
- transient_lastDdlTime 1254944329
+ location file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/dest1
+ transient_lastDdlTime 1258006761
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: dest1
+ name: dest1
Reduce Operator Tree:
Extract
File Output Operator
compressed: false
GlobalTableId: 0
- directory: file:/data/users/njain/hive3/hive3/build/ql/tmp/1906830738/10000
+ directory: file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/tmp/23996439/10000
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -154,9 +186,9 @@
bucket_count -1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
file.inputformat org.apache.hadoop.mapred.TextInputFormat
- location file:/data/users/njain/hive3/hive3/build/ql/test/data/warehouse/dest1
+ location file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/dest1
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- transient_lastDdlTime 1254944329
+ transient_lastDdlTime 1258006761
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: dest1
@@ -164,7 +196,7 @@
Move Operator
tables:
replace: true
- source: file:/data/users/njain/hive3/hive3/build/ql/tmp/1906830738/10000
+ source: file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/tmp/23996439/10000
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -178,11 +210,11 @@
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/data/users/njain/hive3/hive3/build/ql/test/data/warehouse/dest1
- transient_lastDdlTime 1254944329
+ location file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/dest1
+ transient_lastDdlTime 1258006761
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: dest1
- tmp directory: file:/data/users/njain/hive3/hive3/build/ql/tmp/1906830738/10001
+ tmp directory: file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/tmp/23996439/10001
PREHOOK: query: INSERT OVERWRITE TABLE dest1 SELECT s.*
@@ -198,11 +230,11 @@
PREHOOK: query: SELECT dest1.* FROM dest1
PREHOOK: type: QUERY
PREHOOK: Input: default@dest1
-PREHOOK: Output: file:/data/users/njain/hive3/hive3/build/ql/tmp/1809773778/10000
+PREHOOK: Output: file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/tmp/1335018402/10000
POSTHOOK: query: SELECT dest1.* FROM dest1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@dest1
-POSTHOOK: Output: file:/data/users/njain/hive3/hive3/build/ql/tmp/1809773778/10000
+POSTHOOK: Output: file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/tmp/1335018402/10000
468 val_469
272 val_273
448 val_449
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/sample7.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/sample7.q.out?rev=835568&r1=835567&r2=835568&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/sample7.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/sample7.q.out Thu Nov 12 21:36:56 2009
@@ -55,7 +55,7 @@
File Output Operator
compressed: false
GlobalTableId: 1
- directory: file:/data/users/njain/hive3/hive3/build/ql/tmp/1187608638/10002
+ directory: file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/tmp/383824666/10002
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -69,16 +69,31 @@
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/data/users/njain/hive3/hive3/build/ql/test/data/warehouse/dest1
- transient_lastDdlTime 1254944336
+ location file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/dest1
+ transient_lastDdlTime 1258006768
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: dest1
Needs Tagging: false
Path -> Alias:
- file:/data/users/njain/hive3/hive3/build/ql/test/data/warehouse/srcbucket/srcbucket0.txt [s]
+ file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/srcbucket/srcbucket0.txt [s]
Path -> Partition:
- file:/data/users/njain/hive3/hive3/build/ql/test/data/warehouse/srcbucket/srcbucket0.txt
+ file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/srcbucket/srcbucket0.txt
Partition
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ properties:
+ name srcbucket
+ columns.types int:string
+ bucket_field_name key
+ serialization.ddl struct srcbucket { i32 key, string value}
+ columns key,value
+ serialization.format 1
+ bucket_count 2
+ serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ file.inputformat org.apache.hadoop.mapred.TextInputFormat
+ file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ location file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/srcbucket
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -93,10 +108,11 @@
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/data/users/njain/hive3/hive3/build/ql/test/data/warehouse/srcbucket
- transient_lastDdlTime 1254944335
+ location file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/srcbucket
+ transient_lastDdlTime 1258006767
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: srcbucket
+ name: srcbucket
Stage: Stage-4
Conditional Operator
@@ -104,11 +120,11 @@
Move Operator
files:
hdfs directory: true
- source: file:/data/users/njain/hive3/hive3/build/ql/tmp/1187608638/10002
- destination: file:/data/users/njain/hive3/hive3/build/ql/tmp/452038054/10000
+ source: file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/tmp/383824666/10002
+ destination: file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/tmp/993854033/10000
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/njain/hive3/hive3/build/ql/tmp/1187608638/10002
+ file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/tmp/383824666/10002
Reduce Output Operator
sort order:
Map-reduce partition columns:
@@ -122,10 +138,25 @@
type: string
Needs Tagging: false
Path -> Alias:
- file:/data/users/njain/hive3/hive3/build/ql/tmp/1187608638/10002 [file:/data/users/njain/hive3/hive3/build/ql/tmp/1187608638/10002]
+ file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/tmp/383824666/10002 [file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/tmp/383824666/10002]
Path -> Partition:
- file:/data/users/njain/hive3/hive3/build/ql/tmp/1187608638/10002
+ file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/tmp/383824666/10002
Partition
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ properties:
+ name dest1
+ columns.types int:string
+ serialization.ddl struct dest1 { i32 key, string value}
+ serialization.format 1
+ columns key,value
+ bucket_count -1
+ serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ file.inputformat org.apache.hadoop.mapred.TextInputFormat
+ file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ location file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/dest1
+ transient_lastDdlTime 1258006768
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -139,16 +170,17 @@
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/data/users/njain/hive3/hive3/build/ql/test/data/warehouse/dest1
- transient_lastDdlTime 1254944336
+ location file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/dest1
+ transient_lastDdlTime 1258006768
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: dest1
+ name: dest1
Reduce Operator Tree:
Extract
File Output Operator
compressed: false
GlobalTableId: 0
- directory: file:/data/users/njain/hive3/hive3/build/ql/tmp/452038054/10000
+ directory: file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/tmp/993854033/10000
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -161,9 +193,9 @@
bucket_count -1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
file.inputformat org.apache.hadoop.mapred.TextInputFormat
- location file:/data/users/njain/hive3/hive3/build/ql/test/data/warehouse/dest1
+ location file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/dest1
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- transient_lastDdlTime 1254944336
+ transient_lastDdlTime 1258006768
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: dest1
@@ -171,7 +203,7 @@
Move Operator
tables:
replace: true
- source: file:/data/users/njain/hive3/hive3/build/ql/tmp/452038054/10000
+ source: file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/tmp/993854033/10000
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -185,11 +217,11 @@
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/data/users/njain/hive3/hive3/build/ql/test/data/warehouse/dest1
- transient_lastDdlTime 1254944336
+ location file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/dest1
+ transient_lastDdlTime 1258006768
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: dest1
- tmp directory: file:/data/users/njain/hive3/hive3/build/ql/tmp/452038054/10001
+ tmp directory: file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/tmp/993854033/10001
PREHOOK: query: INSERT OVERWRITE TABLE dest1 SELECT s.*
@@ -207,11 +239,11 @@
PREHOOK: query: SELECT dest1.* FROM dest1
PREHOOK: type: QUERY
PREHOOK: Input: default@dest1
-PREHOOK: Output: file:/data/users/njain/hive3/hive3/build/ql/tmp/808065367/10000
+PREHOOK: Output: file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/tmp/1521289689/10000
POSTHOOK: query: SELECT dest1.* FROM dest1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@dest1
-POSTHOOK: Output: file:/data/users/njain/hive3/hive3/build/ql/tmp/808065367/10000
+POSTHOOK: Output: file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/tmp/1521289689/10000
468 val_469
272 val_273
448 val_449
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/sample8.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/sample8.q.out?rev=835568&r1=835567&r2=835568&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/sample8.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/sample8.q.out Thu Nov 12 21:36:56 2009
@@ -76,16 +76,32 @@
type: string
Needs Tagging: true
Path -> Alias:
- file:/data/users/njain/hive5/hive5/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11 [t, s]
- file:/data/users/njain/hive5/hive5/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12 [t]
- file:/data/users/njain/hive5/hive5/build/ql/test/data/warehouse/srcpart/ds=2008-04-09/hr=11 [t]
- file:/data/users/njain/hive5/hive5/build/ql/test/data/warehouse/srcpart/ds=2008-04-09/hr=12 [t]
+ file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11 [t, s]
+ file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12 [t]
+ file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/srcpart/ds=2008-04-09/hr=11 [t]
+ file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/srcpart/ds=2008-04-09/hr=12 [t]
Path -> Partition:
- file:/data/users/njain/hive5/hive5/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11
+ file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11
Partition
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
partition values:
ds 2008-04-08
hr 11
+ properties:
+ name srcpart
+ columns.types string:string
+ 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.lazy.LazySimpleSerDe
+ file.inputformat org.apache.hadoop.mapred.TextInputFormat
+ file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ location file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11
+ transient_lastDdlTime 1258006774
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -100,14 +116,32 @@
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/data/users/njain/hive5/hive5/build/ql/test/data/warehouse/srcpart
+ location file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/srcpart
+ transient_lastDdlTime 1258006774
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: srcpart
- file:/data/users/njain/hive5/hive5/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12
+ name: srcpart
+ file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12
Partition
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
partition values:
ds 2008-04-08
hr 12
+ properties:
+ name srcpart
+ columns.types string:string
+ 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.lazy.LazySimpleSerDe
+ file.inputformat org.apache.hadoop.mapred.TextInputFormat
+ file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ location file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12
+ transient_lastDdlTime 1258006774
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -122,14 +156,32 @@
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/data/users/njain/hive5/hive5/build/ql/test/data/warehouse/srcpart
+ location file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/srcpart
+ transient_lastDdlTime 1258006774
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: srcpart
- file:/data/users/njain/hive5/hive5/build/ql/test/data/warehouse/srcpart/ds=2008-04-09/hr=11
+ name: srcpart
+ file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/srcpart/ds=2008-04-09/hr=11
Partition
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
partition values:
ds 2008-04-09
hr 11
+ properties:
+ name srcpart
+ columns.types string:string
+ 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.lazy.LazySimpleSerDe
+ file.inputformat org.apache.hadoop.mapred.TextInputFormat
+ file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ location file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/srcpart/ds=2008-04-09/hr=11
+ transient_lastDdlTime 1258006774
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -144,14 +196,32 @@
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/data/users/njain/hive5/hive5/build/ql/test/data/warehouse/srcpart
+ location file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/srcpart
+ transient_lastDdlTime 1258006774
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: srcpart
- file:/data/users/njain/hive5/hive5/build/ql/test/data/warehouse/srcpart/ds=2008-04-09/hr=12
+ name: srcpart
+ file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/srcpart/ds=2008-04-09/hr=12
Partition
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
partition values:
ds 2008-04-09
hr 12
+ properties:
+ name srcpart
+ columns.types string:string
+ 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.lazy.LazySimpleSerDe
+ file.inputformat org.apache.hadoop.mapred.TextInputFormat
+ file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ location file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/srcpart/ds=2008-04-09/hr=12
+ transient_lastDdlTime 1258006774
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -166,9 +236,11 @@
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/data/users/njain/hive5/hive5/build/ql/test/data/warehouse/srcpart
+ location file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/srcpart
+ transient_lastDdlTime 1258006774
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: srcpart
+ name: srcpart
Reduce Operator Tree:
Join Operator
condition map:
@@ -196,7 +268,7 @@
File Output Operator
compressed: false
GlobalTableId: 0
- directory: file:/data/users/njain/hive5/hive5/build/ql/tmp/1017400056/10002
+ directory: file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/tmp/717250972/10002
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -208,7 +280,7 @@
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/njain/hive5/hive5/build/ql/tmp/1017400056/10002
+ file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/tmp/717250972/10002
Reduce Output Operator
key expressions:
expr: _col0
@@ -233,10 +305,16 @@
type: string
Needs Tagging: false
Path -> Alias:
- file:/data/users/njain/hive5/hive5/build/ql/tmp/1017400056/10002 [file:/data/users/njain/hive5/hive5/build/ql/tmp/1017400056/10002]
+ file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/tmp/717250972/10002 [file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/tmp/717250972/10002]
Path -> Partition:
- file:/data/users/njain/hive5/hive5/build/ql/tmp/1017400056/10002
+ file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/tmp/717250972/10002
Partition
+ input format: org.apache.hadoop.mapred.SequenceFileInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
+ properties:
+ columns _col0,_col1,_col2,_col3
+ columns.types string,string,string,string
+ escape.delim \
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -249,7 +327,7 @@
File Output Operator
compressed: false
GlobalTableId: 0
- directory: file:/data/users/njain/hive5/hive5/build/ql/tmp/1017400056/10001
+ directory: file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/tmp/717250972/10001
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -274,7 +352,7 @@
PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=12
PREHOOK: Input: default@srcpart@ds=2008-04-09/hr=11
PREHOOK: Input: default@srcpart@ds=2008-04-09/hr=12
-PREHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/576521216/10000
+PREHOOK: Output: file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/tmp/2060636212/10000
POSTHOOK: query: SELECT s.key, s.value
FROM srcpart TABLESAMPLE (BUCKET 1 OUT OF 1 ON key) s
JOIN srcpart TABLESAMPLE (BUCKET 1 OUT OF 10 ON key) t
@@ -286,7 +364,7 @@
POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=12
POSTHOOK: Input: default@srcpart@ds=2008-04-09/hr=11
POSTHOOK: Input: default@srcpart@ds=2008-04-09/hr=12
-POSTHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/576521216/10000
+POSTHOOK: Output: file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/tmp/2060636212/10000
0 val_0
0 val_0
0 val_0
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/sample9.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/sample9.q.out?rev=835568&r1=835567&r2=835568&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/sample9.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/sample9.q.out Thu Nov 12 21:36:56 2009
@@ -47,7 +47,7 @@
File Output Operator
compressed: false
GlobalTableId: 0
- directory: file:/data/users/njain/hive3/hive3/build/ql/tmp/1900206865/10001
+ directory: file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/tmp/486599627/10001
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -57,10 +57,25 @@
columns.types int:string
Needs Tagging: false
Path -> Alias:
- file:/data/users/njain/hive3/hive3/build/ql/test/data/warehouse/srcbucket [s:a]
+ file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/srcbucket [s:a]
Path -> Partition:
- file:/data/users/njain/hive3/hive3/build/ql/test/data/warehouse/srcbucket
+ file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/srcbucket
Partition
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ properties:
+ name srcbucket
+ columns.types int:string
+ bucket_field_name key
+ serialization.ddl struct srcbucket { i32 key, string value}
+ columns key,value
+ serialization.format 1
+ bucket_count 2
+ serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ file.inputformat org.apache.hadoop.mapred.TextInputFormat
+ file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ location file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/srcbucket
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -75,10 +90,11 @@
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/data/users/njain/hive3/hive3/build/ql/test/data/warehouse/srcbucket
- transient_lastDdlTime 1254944341
+ location file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/srcbucket
+ transient_lastDdlTime 1258006794
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: srcbucket
+ name: srcbucket
Stage: Stage-0
Fetch Operator
@@ -89,12 +105,12 @@
FROM (SELECT a.* FROM srcbucket TABLESAMPLE (BUCKET 1 OUT OF 2 on key) a) s
PREHOOK: type: QUERY
PREHOOK: Input: default@srcbucket
-PREHOOK: Output: file:/data/users/njain/hive3/hive3/build/ql/tmp/556820586/10000
+PREHOOK: Output: file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/tmp/2031403560/10000
POSTHOOK: query: SELECT s.*
FROM (SELECT a.* FROM srcbucket TABLESAMPLE (BUCKET 1 OUT OF 2 on key) a) s
POSTHOOK: type: QUERY
POSTHOOK: Input: default@srcbucket
-POSTHOOK: Output: file:/data/users/njain/hive3/hive3/build/ql/tmp/556820586/10000
+POSTHOOK: Output: file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/tmp/2031403560/10000
474 val_475
62 val_63
468 val_469
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/transform_ppr1.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/transform_ppr1.q.out?rev=835568&r1=835567&r2=835568&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/transform_ppr1.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/transform_ppr1.q.out Thu Nov 12 21:36:56 2009
@@ -67,16 +67,32 @@
type: string
Needs Tagging: false
Path -> Alias:
- file:/data/users/nzhang/work/876/apache-hive/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11 [tmap:src]
- file:/data/users/nzhang/work/876/apache-hive/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12 [tmap:src]
- file:/data/users/nzhang/work/876/apache-hive/build/ql/test/data/warehouse/srcpart/ds=2008-04-09/hr=11 [tmap:src]
- file:/data/users/nzhang/work/876/apache-hive/build/ql/test/data/warehouse/srcpart/ds=2008-04-09/hr=12 [tmap:src]
+ file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11 [tmap:src]
+ file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12 [tmap:src]
+ file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/srcpart/ds=2008-04-09/hr=11 [tmap:src]
+ file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/srcpart/ds=2008-04-09/hr=12 [tmap:src]
Path -> Partition:
- file:/data/users/nzhang/work/876/apache-hive/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11
+ file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11
Partition
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
partition values:
ds 2008-04-08
hr 11
+ properties:
+ name srcpart
+ columns.types string:string
+ 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.lazy.LazySimpleSerDe
+ file.inputformat org.apache.hadoop.mapred.TextInputFormat
+ file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ location file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11
+ transient_lastDdlTime 1258007151
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -91,15 +107,32 @@
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/data/users/nzhang/work/876/apache-hive/build/ql/test/data/warehouse/srcpart
- transient_lastDdlTime 1255673097
+ location file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/srcpart
+ transient_lastDdlTime 1258007151
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: srcpart
- file:/data/users/nzhang/work/876/apache-hive/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12
+ name: srcpart
+ file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12
Partition
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
partition values:
ds 2008-04-08
hr 12
+ properties:
+ name srcpart
+ columns.types string:string
+ 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.lazy.LazySimpleSerDe
+ file.inputformat org.apache.hadoop.mapred.TextInputFormat
+ file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ location file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12
+ transient_lastDdlTime 1258007151
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -114,15 +147,32 @@
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/data/users/nzhang/work/876/apache-hive/build/ql/test/data/warehouse/srcpart
- transient_lastDdlTime 1255673097
+ location file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/srcpart
+ transient_lastDdlTime 1258007151
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: srcpart
- file:/data/users/nzhang/work/876/apache-hive/build/ql/test/data/warehouse/srcpart/ds=2008-04-09/hr=11
+ name: srcpart
+ file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/srcpart/ds=2008-04-09/hr=11
Partition
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
partition values:
ds 2008-04-09
hr 11
+ properties:
+ name srcpart
+ columns.types string:string
+ 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.lazy.LazySimpleSerDe
+ file.inputformat org.apache.hadoop.mapred.TextInputFormat
+ file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ location file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/srcpart/ds=2008-04-09/hr=11
+ transient_lastDdlTime 1258007151
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -137,15 +187,32 @@
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/data/users/nzhang/work/876/apache-hive/build/ql/test/data/warehouse/srcpart
- transient_lastDdlTime 1255673097
+ location file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/srcpart
+ transient_lastDdlTime 1258007151
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: srcpart
- file:/data/users/nzhang/work/876/apache-hive/build/ql/test/data/warehouse/srcpart/ds=2008-04-09/hr=12
+ name: srcpart
+ file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/srcpart/ds=2008-04-09/hr=12
Partition
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
partition values:
ds 2008-04-09
hr 12
+ properties:
+ name srcpart
+ columns.types string:string
+ 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.lazy.LazySimpleSerDe
+ file.inputformat org.apache.hadoop.mapred.TextInputFormat
+ file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ location file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/srcpart/ds=2008-04-09/hr=12
+ transient_lastDdlTime 1258007151
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -160,10 +227,11 @@
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/data/users/nzhang/work/876/apache-hive/build/ql/test/data/warehouse/srcpart
- transient_lastDdlTime 1255673097
+ location file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/srcpart
+ transient_lastDdlTime 1258007151
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: srcpart
+ name: srcpart
Reduce Operator Tree:
Extract
Filter Operator
@@ -181,7 +249,7 @@
File Output Operator
compressed: false
GlobalTableId: 0
- directory: file:/data/users/nzhang/work/876/apache-hive/build/ql/tmp/1989886167/10001
+ directory: file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/tmp/959108310/10001
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -207,7 +275,7 @@
PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=12
PREHOOK: Input: default@srcpart@ds=2008-04-09/hr=11
PREHOOK: Input: default@srcpart@ds=2008-04-09/hr=12
-PREHOOK: Output: file:/data/users/nzhang/work/876/apache-hive/build/ql/tmp/1814497565/10000
+PREHOOK: Output: file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/tmp/1392800649/10000
POSTHOOK: query: FROM (
FROM srcpart src
SELECT TRANSFORM(src.ds, src.key, src.value)
@@ -220,7 +288,7 @@
POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=12
POSTHOOK: Input: default@srcpart@ds=2008-04-09/hr=11
POSTHOOK: Input: default@srcpart@ds=2008-04-09/hr=12
-POSTHOOK: Output: file:/data/users/nzhang/work/876/apache-hive/build/ql/tmp/1814497565/10000
+POSTHOOK: Output: file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/tmp/1392800649/10000
0 val_0
0 val_0
0 val_0