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 2011/04/07 18:32:18 UTC
svn commit: r1089938 [2/4] - in /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/hooks/
ql/src/java/org/apache/hadoop/hive/ql/metadata/ ql/src/java/org/a...
Modified: hive/trunk/ql/src/test/results/clientpositive/merge3.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/merge3.q.out?rev=1089938&r1=1089937&r2=1089938&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/merge3.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/merge3.q.out Thu Apr 7 16:32:18 2011
@@ -78,9 +78,9 @@ STAGE PLANS:
File Output Operator
compressed: false
GlobalTableId: 1
- directory: pfile:/data/users/sdong/www/open-source-hive1/build/ql/scratchdir/hive_2011-02-10_16-41-42_924_3224768007211959400/-ext-10002
+ directory: pfile:/data/users/nzhang/work/3/apache-hive/build/ql/scratchdir/hive_2011-04-05_21-04-13_019_2056908400463865832/-ext-10002
NumFilesPerFileSink: 1
- Stats Publishing Key Prefix: pfile:/data/users/sdong/www/open-source-hive1/build/ql/scratchdir/hive_2011-02-10_16-41-42_924_3224768007211959400/-ext-10001/
+ Stats Publishing Key Prefix: pfile:/data/users/nzhang/work/3/apache-hive/build/ql/scratchdir/hive_2011-04-05_21-04-13_019_2056908400463865832/-ext-10001/
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -93,9 +93,9 @@ STAGE PLANS:
MultiFileSpray: false
Needs Tagging: false
Path -> Alias:
- pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/merge_src [merge_src]
+ pfile:/data/users/nzhang/work/3/apache-hive/build/ql/test/data/warehouse/merge_src [merge_src]
Path -> Partition:
- pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/merge_src
+ pfile:/data/users/nzhang/work/3/apache-hive/build/ql/test/data/warehouse/merge_src
Partition
base file name: merge_src
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -106,12 +106,12 @@ STAGE PLANS:
columns.types string:string
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/merge_src
+ location pfile:/data/users/nzhang/work/3/apache-hive/build/ql/test/data/warehouse/merge_src
name default.merge_src
serialization.ddl struct merge_src { string key, string value}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- transient_lastDdlTime 1297384895
+ transient_lastDdlTime 1302062646
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -122,12 +122,12 @@ STAGE PLANS:
columns.types string:string
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/merge_src
+ location pfile:/data/users/nzhang/work/3/apache-hive/build/ql/test/data/warehouse/merge_src
name default.merge_src
serialization.ddl struct merge_src { string key, string value}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- transient_lastDdlTime 1297384895
+ transient_lastDdlTime 1302062646
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: default.merge_src
name: default.merge_src
@@ -139,15 +139,15 @@ STAGE PLANS:
Move Operator
files:
hdfs directory: true
- source: pfile:/data/users/sdong/www/open-source-hive1/build/ql/scratchdir/hive_2011-02-10_16-41-42_924_3224768007211959400/-ext-10002
- destination: pfile:/data/users/sdong/www/open-source-hive1/build/ql/scratchdir/hive_2011-02-10_16-41-42_924_3224768007211959400/-ext-10001
+ source: pfile:/data/users/nzhang/work/3/apache-hive/build/ql/scratchdir/hive_2011-04-05_21-04-13_019_2056908400463865832/-ext-10002
+ destination: pfile:/data/users/nzhang/work/3/apache-hive/build/ql/scratchdir/hive_2011-04-05_21-04-13_019_2056908400463865832/-ext-10001
Stage: Stage-0
Move Operator
files:
hdfs directory: true
- source: pfile:/data/users/sdong/www/open-source-hive1/build/ql/scratchdir/hive_2011-02-10_16-41-42_924_3224768007211959400/-ext-10001
- destination: pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/merge_src2
+ source: pfile:/data/users/nzhang/work/3/apache-hive/build/ql/scratchdir/hive_2011-04-05_21-04-13_019_2056908400463865832/-ext-10001
+ destination: pfile:/data/users/nzhang/work/3/apache-hive/build/ql/test/data/warehouse/merge_src2
Stage: Stage-5
Create Table Operator:
@@ -163,11 +163,11 @@ STAGE PLANS:
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- pfile:/data/users/sdong/www/open-source-hive1/build/ql/scratchdir/hive_2011-02-10_16-41-42_924_3224768007211959400/-ext-10002
+ pfile:/data/users/nzhang/work/3/apache-hive/build/ql/scratchdir/hive_2011-04-05_21-04-13_019_2056908400463865832/-ext-10002
File Output Operator
compressed: false
GlobalTableId: 0
- directory: pfile:/data/users/sdong/www/open-source-hive1/build/ql/scratchdir/hive_2011-02-10_16-41-42_924_3224768007211959400/-ext-10001
+ directory: pfile:/data/users/nzhang/work/3/apache-hive/build/ql/scratchdir/hive_2011-04-05_21-04-13_019_2056908400463865832/-ext-10001
NumFilesPerFileSink: 1
table:
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -181,9 +181,9 @@ STAGE PLANS:
MultiFileSpray: false
Needs Tagging: false
Path -> Alias:
- pfile:/data/users/sdong/www/open-source-hive1/build/ql/scratchdir/hive_2011-02-10_16-41-42_924_3224768007211959400/-ext-10002 [pfile:/data/users/sdong/www/open-source-hive1/build/ql/scratchdir/hive_2011-02-10_16-41-42_924_3224768007211959400/-ext-10002]
+ pfile:/data/users/nzhang/work/3/apache-hive/build/ql/scratchdir/hive_2011-04-05_21-04-13_019_2056908400463865832/-ext-10002 [pfile:/data/users/nzhang/work/3/apache-hive/build/ql/scratchdir/hive_2011-04-05_21-04-13_019_2056908400463865832/-ext-10002]
Path -> Partition:
- pfile:/data/users/sdong/www/open-source-hive1/build/ql/scratchdir/hive_2011-02-10_16-41-42_924_3224768007211959400/-ext-10002
+ pfile:/data/users/nzhang/work/3/apache-hive/build/ql/scratchdir/hive_2011-04-05_21-04-13_019_2056908400463865832/-ext-10002
Partition
base file name: -ext-10002
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -217,11 +217,11 @@ POSTHOOK: Lineage: merge_src_part PARTIT
PREHOOK: query: select * from merge_src2
PREHOOK: type: QUERY
PREHOOK: Input: default@merge_src2
-PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_16-41-49_851_6013027925845240870/-mr-10000
+PREHOOK: Output: file:/tmp/nzhang/hive_2011-04-05_21-04-19_101_7096770280282776900/-mr-10000
POSTHOOK: query: select * from merge_src2
POSTHOOK: type: QUERY
POSTHOOK: Input: default@merge_src2
-POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_16-41-49_851_6013027925845240870/-mr-10000
+POSTHOOK: Output: file:/tmp/nzhang/hive_2011-04-05_21-04-19_101_7096770280282776900/-mr-10000
POSTHOOK: Lineage: merge_src_part PARTITION(ds=2008-04-08).key SIMPLE [(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: merge_src_part PARTITION(ds=2008-04-08).value SIMPLE [(srcpart)srcpart.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: merge_src_part PARTITION(ds=2008-04-09).key SIMPLE [(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ]
@@ -2285,9 +2285,9 @@ STAGE PLANS:
File Output Operator
compressed: false
GlobalTableId: 1
- directory: pfile:/data/users/sdong/www/open-source-hive1/build/ql/scratchdir/hive_2011-02-10_16-41-50_240_5312287851356242830/-ext-10002
+ directory: pfile:/data/users/nzhang/work/3/apache-hive/build/ql/scratchdir/hive_2011-04-05_21-04-19_564_1980496208652311851/-ext-10002
NumFilesPerFileSink: 1
- Stats Publishing Key Prefix: pfile:/data/users/sdong/www/open-source-hive1/build/ql/scratchdir/hive_2011-02-10_16-41-50_240_5312287851356242830/-ext-10000/
+ Stats Publishing Key Prefix: pfile:/data/users/nzhang/work/3/apache-hive/build/ql/scratchdir/hive_2011-04-05_21-04-19_564_1980496208652311851/-ext-10000/
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -2297,13 +2297,13 @@ STAGE PLANS:
columns.types string:string
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/merge_src_part2
+ location pfile:/data/users/nzhang/work/3/apache-hive/build/ql/test/data/warehouse/merge_src_part2
name default.merge_src_part2
partition_columns ds
serialization.ddl struct merge_src_part2 { string key, string value}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- transient_lastDdlTime 1297384910
+ transient_lastDdlTime 1302062659
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: default.merge_src_part2
TotalFiles: 1
@@ -2311,10 +2311,10 @@ STAGE PLANS:
MultiFileSpray: false
Needs Tagging: false
Path -> Alias:
- pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/merge_src_part/ds=2008-04-08 [merge_src_part]
- pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/merge_src_part/ds=2008-04-09 [merge_src_part]
+ pfile:/data/users/nzhang/work/3/apache-hive/build/ql/test/data/warehouse/merge_src_part/ds=2008-04-08 [merge_src_part]
+ pfile:/data/users/nzhang/work/3/apache-hive/build/ql/test/data/warehouse/merge_src_part/ds=2008-04-09 [merge_src_part]
Path -> Partition:
- pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/merge_src_part/ds=2008-04-08
+ pfile:/data/users/nzhang/work/3/apache-hive/build/ql/test/data/warehouse/merge_src_part/ds=2008-04-08
Partition
base file name: ds=2008-04-08
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -2327,17 +2327,17 @@ STAGE PLANS:
columns.types string:string
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/merge_src_part/ds=2008-04-08
+ location pfile:/data/users/nzhang/work/3/apache-hive/build/ql/test/data/warehouse/merge_src_part/ds=2008-04-08
name default.merge_src_part
- numFiles 4
+ numFiles 2
numPartitions 2
- numRows 2000
+ numRows 1000
partition_columns ds
serialization.ddl struct merge_src_part { string key, string value}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- totalSize 23248
- transient_lastDdlTime 1297384902
+ totalSize 11624
+ transient_lastDdlTime 1302062652
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -2348,7 +2348,7 @@ STAGE PLANS:
columns.types string:string
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/merge_src_part
+ location pfile:/data/users/nzhang/work/3/apache-hive/build/ql/test/data/warehouse/merge_src_part
name default.merge_src_part
numFiles 4
numPartitions 2
@@ -2358,11 +2358,11 @@ STAGE PLANS:
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
totalSize 23248
- transient_lastDdlTime 1297384902
+ transient_lastDdlTime 1302062652
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: default.merge_src_part
name: default.merge_src_part
- pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/merge_src_part/ds=2008-04-09
+ pfile:/data/users/nzhang/work/3/apache-hive/build/ql/test/data/warehouse/merge_src_part/ds=2008-04-09
Partition
base file name: ds=2008-04-09
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -2375,17 +2375,17 @@ STAGE PLANS:
columns.types string:string
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/merge_src_part/ds=2008-04-09
+ location pfile:/data/users/nzhang/work/3/apache-hive/build/ql/test/data/warehouse/merge_src_part/ds=2008-04-09
name default.merge_src_part
- numFiles 4
+ numFiles 2
numPartitions 2
- numRows 2000
+ numRows 1000
partition_columns ds
serialization.ddl struct merge_src_part { string key, string value}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- totalSize 23248
- transient_lastDdlTime 1297384902
+ totalSize 11624
+ transient_lastDdlTime 1302062652
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -2396,7 +2396,7 @@ STAGE PLANS:
columns.types string:string
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/merge_src_part
+ location pfile:/data/users/nzhang/work/3/apache-hive/build/ql/test/data/warehouse/merge_src_part
name default.merge_src_part
numFiles 4
numPartitions 2
@@ -2406,7 +2406,7 @@ STAGE PLANS:
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
totalSize 23248
- transient_lastDdlTime 1297384902
+ transient_lastDdlTime 1302062652
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: default.merge_src_part
name: default.merge_src_part
@@ -2418,8 +2418,8 @@ STAGE PLANS:
Move Operator
files:
hdfs directory: true
- source: pfile:/data/users/sdong/www/open-source-hive1/build/ql/scratchdir/hive_2011-02-10_16-41-50_240_5312287851356242830/-ext-10002
- destination: pfile:/data/users/sdong/www/open-source-hive1/build/ql/scratchdir/hive_2011-02-10_16-41-50_240_5312287851356242830/-ext-10000
+ source: pfile:/data/users/nzhang/work/3/apache-hive/build/ql/scratchdir/hive_2011-04-05_21-04-19_564_1980496208652311851/-ext-10002
+ destination: pfile:/data/users/nzhang/work/3/apache-hive/build/ql/scratchdir/hive_2011-04-05_21-04-19_564_1980496208652311851/-ext-10000
Stage: Stage-0
Move Operator
@@ -2427,7 +2427,7 @@ STAGE PLANS:
partition:
ds
replace: true
- source: pfile:/data/users/sdong/www/open-source-hive1/build/ql/scratchdir/hive_2011-02-10_16-41-50_240_5312287851356242830/-ext-10000
+ source: pfile:/data/users/nzhang/work/3/apache-hive/build/ql/scratchdir/hive_2011-04-05_21-04-19_564_1980496208652311851/-ext-10000
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -2437,29 +2437,29 @@ STAGE PLANS:
columns.types string:string
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/merge_src_part2
+ location pfile:/data/users/nzhang/work/3/apache-hive/build/ql/test/data/warehouse/merge_src_part2
name default.merge_src_part2
partition_columns ds
serialization.ddl struct merge_src_part2 { string key, string value}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- transient_lastDdlTime 1297384910
+ transient_lastDdlTime 1302062659
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: default.merge_src_part2
- tmp directory: pfile:/data/users/sdong/www/open-source-hive1/build/ql/scratchdir/hive_2011-02-10_16-41-50_240_5312287851356242830/-ext-10001
+ tmp directory: pfile:/data/users/nzhang/work/3/apache-hive/build/ql/scratchdir/hive_2011-04-05_21-04-19_564_1980496208652311851/-ext-10001
Stage: Stage-2
Stats-Aggr Operator
- Stats Aggregation Key Prefix: pfile:/data/users/sdong/www/open-source-hive1/build/ql/scratchdir/hive_2011-02-10_16-41-50_240_5312287851356242830/-ext-10000/
+ Stats Aggregation Key Prefix: pfile:/data/users/nzhang/work/3/apache-hive/build/ql/scratchdir/hive_2011-04-05_21-04-19_564_1980496208652311851/-ext-10000/
Stage: Stage-3
Map Reduce
Alias -> Map Operator Tree:
- pfile:/data/users/sdong/www/open-source-hive1/build/ql/scratchdir/hive_2011-02-10_16-41-50_240_5312287851356242830/-ext-10002
+ pfile:/data/users/nzhang/work/3/apache-hive/build/ql/scratchdir/hive_2011-04-05_21-04-19_564_1980496208652311851/-ext-10002
File Output Operator
compressed: false
GlobalTableId: 0
- directory: pfile:/data/users/sdong/www/open-source-hive1/build/ql/scratchdir/hive_2011-02-10_16-41-50_240_5312287851356242830/-ext-10000
+ directory: pfile:/data/users/nzhang/work/3/apache-hive/build/ql/scratchdir/hive_2011-04-05_21-04-19_564_1980496208652311851/-ext-10000
NumFilesPerFileSink: 1
table:
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -2470,13 +2470,13 @@ STAGE PLANS:
columns.types string:string
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/merge_src_part2
+ location pfile:/data/users/nzhang/work/3/apache-hive/build/ql/test/data/warehouse/merge_src_part2
name default.merge_src_part2
partition_columns ds
serialization.ddl struct merge_src_part2 { string key, string value}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- transient_lastDdlTime 1297384910
+ transient_lastDdlTime 1302062659
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: default.merge_src_part2
TotalFiles: 1
@@ -2484,9 +2484,9 @@ STAGE PLANS:
MultiFileSpray: false
Needs Tagging: false
Path -> Alias:
- pfile:/data/users/sdong/www/open-source-hive1/build/ql/scratchdir/hive_2011-02-10_16-41-50_240_5312287851356242830/-ext-10002 [pfile:/data/users/sdong/www/open-source-hive1/build/ql/scratchdir/hive_2011-02-10_16-41-50_240_5312287851356242830/-ext-10002]
+ pfile:/data/users/nzhang/work/3/apache-hive/build/ql/scratchdir/hive_2011-04-05_21-04-19_564_1980496208652311851/-ext-10002 [pfile:/data/users/nzhang/work/3/apache-hive/build/ql/scratchdir/hive_2011-04-05_21-04-19_564_1980496208652311851/-ext-10002]
Path -> Partition:
- pfile:/data/users/sdong/www/open-source-hive1/build/ql/scratchdir/hive_2011-02-10_16-41-50_240_5312287851356242830/-ext-10002
+ pfile:/data/users/nzhang/work/3/apache-hive/build/ql/scratchdir/hive_2011-04-05_21-04-19_564_1980496208652311851/-ext-10002
Partition
base file name: -ext-10002
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -2497,13 +2497,13 @@ STAGE PLANS:
columns.types string:string
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/merge_src_part2
+ location pfile:/data/users/nzhang/work/3/apache-hive/build/ql/test/data/warehouse/merge_src_part2
name default.merge_src_part2
partition_columns ds
serialization.ddl struct merge_src_part2 { string key, string value}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- transient_lastDdlTime 1297384910
+ transient_lastDdlTime 1302062659
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -2514,13 +2514,13 @@ STAGE PLANS:
columns.types string:string
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/merge_src_part2
+ location pfile:/data/users/nzhang/work/3/apache-hive/build/ql/test/data/warehouse/merge_src_part2
name default.merge_src_part2
partition_columns ds
serialization.ddl struct merge_src_part2 { string key, string value}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- transient_lastDdlTime 1297384910
+ transient_lastDdlTime 1302062659
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: default.merge_src_part2
name: default.merge_src_part2
@@ -2567,12 +2567,12 @@ PREHOOK: query: select * from merge_src_
PREHOOK: type: QUERY
PREHOOK: Input: default@merge_src_part2@ds=2008-04-08
PREHOOK: Input: default@merge_src_part2@ds=2008-04-09
-PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_16-42-00_664_7034904307680305352/-mr-10000
+PREHOOK: Output: file:/tmp/nzhang/hive_2011-04-05_21-04-28_779_5534455273308385359/-mr-10000
POSTHOOK: query: select * from merge_src_part2 where ds is not null
POSTHOOK: type: QUERY
POSTHOOK: Input: default@merge_src_part2@ds=2008-04-08
POSTHOOK: Input: default@merge_src_part2@ds=2008-04-09
-POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_16-42-00_664_7034904307680305352/-mr-10000
+POSTHOOK: Output: file:/tmp/nzhang/hive_2011-04-05_21-04-28_779_5534455273308385359/-mr-10000
POSTHOOK: Lineage: merge_src_part PARTITION(ds=2008-04-08).key SIMPLE [(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: merge_src_part PARTITION(ds=2008-04-08).value SIMPLE [(srcpart)srcpart.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: merge_src_part PARTITION(ds=2008-04-09).key SIMPLE [(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ]
@@ -4676,10 +4676,10 @@ STAGE PLANS:
type: string
Needs Tagging: false
Path -> Alias:
- pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/merge_src_part/ds=2008-04-08 [s:merge_src_part]
- pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/merge_src_part/ds=2008-04-09 [s:merge_src_part]
+ pfile:/data/users/nzhang/work/3/apache-hive/build/ql/test/data/warehouse/merge_src_part/ds=2008-04-08 [s:merge_src_part]
+ pfile:/data/users/nzhang/work/3/apache-hive/build/ql/test/data/warehouse/merge_src_part/ds=2008-04-09 [s:merge_src_part]
Path -> Partition:
- pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/merge_src_part/ds=2008-04-08
+ pfile:/data/users/nzhang/work/3/apache-hive/build/ql/test/data/warehouse/merge_src_part/ds=2008-04-08
Partition
base file name: ds=2008-04-08
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -4692,17 +4692,17 @@ STAGE PLANS:
columns.types string:string
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/merge_src_part/ds=2008-04-08
+ location pfile:/data/users/nzhang/work/3/apache-hive/build/ql/test/data/warehouse/merge_src_part/ds=2008-04-08
name default.merge_src_part
- numFiles 4
+ numFiles 2
numPartitions 2
- numRows 2000
+ numRows 1000
partition_columns ds
serialization.ddl struct merge_src_part { string key, string value}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- totalSize 23248
- transient_lastDdlTime 1297384902
+ totalSize 11624
+ transient_lastDdlTime 1302062652
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -4713,7 +4713,7 @@ STAGE PLANS:
columns.types string:string
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/merge_src_part
+ location pfile:/data/users/nzhang/work/3/apache-hive/build/ql/test/data/warehouse/merge_src_part
name default.merge_src_part
numFiles 4
numPartitions 2
@@ -4723,11 +4723,11 @@ STAGE PLANS:
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
totalSize 23248
- transient_lastDdlTime 1297384902
+ transient_lastDdlTime 1302062652
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: default.merge_src_part
name: default.merge_src_part
- pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/merge_src_part/ds=2008-04-09
+ pfile:/data/users/nzhang/work/3/apache-hive/build/ql/test/data/warehouse/merge_src_part/ds=2008-04-09
Partition
base file name: ds=2008-04-09
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -4740,17 +4740,17 @@ STAGE PLANS:
columns.types string:string
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/merge_src_part/ds=2008-04-09
+ location pfile:/data/users/nzhang/work/3/apache-hive/build/ql/test/data/warehouse/merge_src_part/ds=2008-04-09
name default.merge_src_part
- numFiles 4
+ numFiles 2
numPartitions 2
- numRows 2000
+ numRows 1000
partition_columns ds
serialization.ddl struct merge_src_part { string key, string value}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- totalSize 23248
- transient_lastDdlTime 1297384902
+ totalSize 11624
+ transient_lastDdlTime 1302062652
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -4761,7 +4761,7 @@ STAGE PLANS:
columns.types string:string
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/merge_src_part
+ location pfile:/data/users/nzhang/work/3/apache-hive/build/ql/test/data/warehouse/merge_src_part
name default.merge_src_part
numFiles 4
numPartitions 2
@@ -4771,7 +4771,7 @@ STAGE PLANS:
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
totalSize 23248
- transient_lastDdlTime 1297384902
+ transient_lastDdlTime 1302062652
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: default.merge_src_part
name: default.merge_src_part
@@ -4789,9 +4789,9 @@ STAGE PLANS:
File Output Operator
compressed: false
GlobalTableId: 1
- directory: pfile:/data/users/sdong/www/open-source-hive1/build/ql/scratchdir/hive_2011-02-10_16-42-01_461_6051392658397120660/-ext-10002
+ directory: pfile:/data/users/nzhang/work/3/apache-hive/build/ql/scratchdir/hive_2011-04-05_21-04-29_570_4638027000138125059/-ext-10002
NumFilesPerFileSink: 1
- Stats Publishing Key Prefix: pfile:/data/users/sdong/www/open-source-hive1/build/ql/scratchdir/hive_2011-02-10_16-42-01_461_6051392658397120660/-ext-10000/
+ Stats Publishing Key Prefix: pfile:/data/users/nzhang/work/3/apache-hive/build/ql/scratchdir/hive_2011-04-05_21-04-29_570_4638027000138125059/-ext-10000/
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -4801,13 +4801,13 @@ STAGE PLANS:
columns.types string:string
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/merge_src_part2
+ location pfile:/data/users/nzhang/work/3/apache-hive/build/ql/test/data/warehouse/merge_src_part2
name default.merge_src_part2
partition_columns ds
serialization.ddl struct merge_src_part2 { string key, string value}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- transient_lastDdlTime 1297384921
+ transient_lastDdlTime 1302062669
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: default.merge_src_part2
TotalFiles: 1
@@ -4821,8 +4821,8 @@ STAGE PLANS:
Move Operator
files:
hdfs directory: true
- source: pfile:/data/users/sdong/www/open-source-hive1/build/ql/scratchdir/hive_2011-02-10_16-42-01_461_6051392658397120660/-ext-10002
- destination: pfile:/data/users/sdong/www/open-source-hive1/build/ql/scratchdir/hive_2011-02-10_16-42-01_461_6051392658397120660/-ext-10000
+ source: pfile:/data/users/nzhang/work/3/apache-hive/build/ql/scratchdir/hive_2011-04-05_21-04-29_570_4638027000138125059/-ext-10002
+ destination: pfile:/data/users/nzhang/work/3/apache-hive/build/ql/scratchdir/hive_2011-04-05_21-04-29_570_4638027000138125059/-ext-10000
Stage: Stage-0
Move Operator
@@ -4830,7 +4830,7 @@ STAGE PLANS:
partition:
ds
replace: true
- source: pfile:/data/users/sdong/www/open-source-hive1/build/ql/scratchdir/hive_2011-02-10_16-42-01_461_6051392658397120660/-ext-10000
+ source: pfile:/data/users/nzhang/work/3/apache-hive/build/ql/scratchdir/hive_2011-04-05_21-04-29_570_4638027000138125059/-ext-10000
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -4840,29 +4840,29 @@ STAGE PLANS:
columns.types string:string
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/merge_src_part2
+ location pfile:/data/users/nzhang/work/3/apache-hive/build/ql/test/data/warehouse/merge_src_part2
name default.merge_src_part2
partition_columns ds
serialization.ddl struct merge_src_part2 { string key, string value}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- transient_lastDdlTime 1297384921
+ transient_lastDdlTime 1302062669
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: default.merge_src_part2
- tmp directory: pfile:/data/users/sdong/www/open-source-hive1/build/ql/scratchdir/hive_2011-02-10_16-42-01_461_6051392658397120660/-ext-10001
+ tmp directory: pfile:/data/users/nzhang/work/3/apache-hive/build/ql/scratchdir/hive_2011-04-05_21-04-29_570_4638027000138125059/-ext-10001
Stage: Stage-2
Stats-Aggr Operator
- Stats Aggregation Key Prefix: pfile:/data/users/sdong/www/open-source-hive1/build/ql/scratchdir/hive_2011-02-10_16-42-01_461_6051392658397120660/-ext-10000/
+ Stats Aggregation Key Prefix: pfile:/data/users/nzhang/work/3/apache-hive/build/ql/scratchdir/hive_2011-04-05_21-04-29_570_4638027000138125059/-ext-10000/
Stage: Stage-3
Map Reduce
Alias -> Map Operator Tree:
- pfile:/data/users/sdong/www/open-source-hive1/build/ql/scratchdir/hive_2011-02-10_16-42-01_461_6051392658397120660/-ext-10002
+ pfile:/data/users/nzhang/work/3/apache-hive/build/ql/scratchdir/hive_2011-04-05_21-04-29_570_4638027000138125059/-ext-10002
File Output Operator
compressed: false
GlobalTableId: 0
- directory: pfile:/data/users/sdong/www/open-source-hive1/build/ql/scratchdir/hive_2011-02-10_16-42-01_461_6051392658397120660/-ext-10000
+ directory: pfile:/data/users/nzhang/work/3/apache-hive/build/ql/scratchdir/hive_2011-04-05_21-04-29_570_4638027000138125059/-ext-10000
NumFilesPerFileSink: 1
table:
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -4873,13 +4873,13 @@ STAGE PLANS:
columns.types string:string
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/merge_src_part2
+ location pfile:/data/users/nzhang/work/3/apache-hive/build/ql/test/data/warehouse/merge_src_part2
name default.merge_src_part2
partition_columns ds
serialization.ddl struct merge_src_part2 { string key, string value}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- transient_lastDdlTime 1297384921
+ transient_lastDdlTime 1302062669
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: default.merge_src_part2
TotalFiles: 1
@@ -4887,9 +4887,9 @@ STAGE PLANS:
MultiFileSpray: false
Needs Tagging: false
Path -> Alias:
- pfile:/data/users/sdong/www/open-source-hive1/build/ql/scratchdir/hive_2011-02-10_16-42-01_461_6051392658397120660/-ext-10002 [pfile:/data/users/sdong/www/open-source-hive1/build/ql/scratchdir/hive_2011-02-10_16-42-01_461_6051392658397120660/-ext-10002]
+ pfile:/data/users/nzhang/work/3/apache-hive/build/ql/scratchdir/hive_2011-04-05_21-04-29_570_4638027000138125059/-ext-10002 [pfile:/data/users/nzhang/work/3/apache-hive/build/ql/scratchdir/hive_2011-04-05_21-04-29_570_4638027000138125059/-ext-10002]
Path -> Partition:
- pfile:/data/users/sdong/www/open-source-hive1/build/ql/scratchdir/hive_2011-02-10_16-42-01_461_6051392658397120660/-ext-10002
+ pfile:/data/users/nzhang/work/3/apache-hive/build/ql/scratchdir/hive_2011-04-05_21-04-29_570_4638027000138125059/-ext-10002
Partition
base file name: -ext-10002
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -4900,13 +4900,13 @@ STAGE PLANS:
columns.types string:string
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/merge_src_part2
+ location pfile:/data/users/nzhang/work/3/apache-hive/build/ql/test/data/warehouse/merge_src_part2
name default.merge_src_part2
partition_columns ds
serialization.ddl struct merge_src_part2 { string key, string value}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- transient_lastDdlTime 1297384921
+ transient_lastDdlTime 1302062669
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -4917,13 +4917,13 @@ STAGE PLANS:
columns.types string:string
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/merge_src_part2
+ location pfile:/data/users/nzhang/work/3/apache-hive/build/ql/test/data/warehouse/merge_src_part2
name default.merge_src_part2
partition_columns ds
serialization.ddl struct merge_src_part2 { string key, string value}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- transient_lastDdlTime 1297384921
+ transient_lastDdlTime 1302062669
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: default.merge_src_part2
name: default.merge_src_part2
@@ -4977,12 +4977,12 @@ PREHOOK: query: select * from merge_src_
PREHOOK: type: QUERY
PREHOOK: Input: default@merge_src_part2@ds=2008-04-08
PREHOOK: Input: default@merge_src_part2@ds=2008-04-09
-PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_16-42-09_786_3937827373843806202/-mr-10000
+PREHOOK: Output: file:/tmp/nzhang/hive_2011-04-05_21-04-36_134_2846637884945897320/-mr-10000
POSTHOOK: query: select * from merge_src_part2 where ds is not null
POSTHOOK: type: QUERY
POSTHOOK: Input: default@merge_src_part2@ds=2008-04-08
POSTHOOK: Input: default@merge_src_part2@ds=2008-04-09
-POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_16-42-09_786_3937827373843806202/-mr-10000
+POSTHOOK: Output: file:/tmp/nzhang/hive_2011-04-05_21-04-36_134_2846637884945897320/-mr-10000
POSTHOOK: Lineage: merge_src_part PARTITION(ds=2008-04-08).key SIMPLE [(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: merge_src_part PARTITION(ds=2008-04-08).value SIMPLE [(srcpart)srcpart.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: merge_src_part PARTITION(ds=2008-04-09).key SIMPLE [(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ]