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), ]
