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 2010/11/05 18:29:30 UTC
svn commit: r1031676 [10/15] - in /hive/trunk: ./
ql/src/java/org/apache/hadoop/hive/ql/exec/
ql/src/java/org/apache/hadoop/hive/ql/optimizer/
ql/src/java/org/apache/hadoop/hive/ql/optimizer/pcr/
ql/src/java/org/apache/hadoop/hive/ql/optimizer/ppr/ ql/...
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=1031676&r1=1031675&r2=1031676&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/merge3.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/merge3.q.out Fri Nov 5 17:29:28 2010
@@ -77,9 +77,9 @@ STAGE PLANS:
File Output Operator
compressed: false
GlobalTableId: 1
- directory: pfile:/data/users/nzhang/work/870/apache-hive/build/ql/scratchdir/hive_2010-10-15_22-19-22_303_6951055031740945056/-ext-10002
+ directory: pfile:/data/users/sdong/www/hive-trunk/build/ql/scratchdir/hive_2010-10-29_16-09-48_857_8226805934470604516/-ext-10002
NumFilesPerFileSink: 1
- Stats Publishing Key Prefix: pfile:/data/users/nzhang/work/870/apache-hive/build/ql/scratchdir/hive_2010-10-15_22-19-22_303_6951055031740945056/-ext-10001/
+ Stats Publishing Key Prefix: pfile:/data/users/sdong/www/hive-trunk/build/ql/scratchdir/hive_2010-10-29_16-09-48_857_8226805934470604516/-ext-10001/
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -92,9 +92,9 @@ STAGE PLANS:
MultiFileSpray: false
Needs Tagging: false
Path -> Alias:
- pfile:/data/users/nzhang/work/870/apache-hive/build/ql/test/data/warehouse/merge_src [merge_src]
+ pfile:/data/users/sdong/www/hive-trunk/build/ql/test/data/warehouse/merge_src [merge_src]
Path -> Partition:
- pfile:/data/users/nzhang/work/870/apache-hive/build/ql/test/data/warehouse/merge_src
+ pfile:/data/users/sdong/www/hive-trunk/build/ql/test/data/warehouse/merge_src
Partition
base file name: merge_src
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -105,12 +105,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/nzhang/work/870/apache-hive/build/ql/test/data/warehouse/merge_src
+ location pfile:/data/users/sdong/www/hive-trunk/build/ql/test/data/warehouse/merge_src
name 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 1287206353
+ transient_lastDdlTime 1288393780
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -121,12 +121,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/nzhang/work/870/apache-hive/build/ql/test/data/warehouse/merge_src
+ location pfile:/data/users/sdong/www/hive-trunk/build/ql/test/data/warehouse/merge_src
name 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 1287206353
+ transient_lastDdlTime 1288393780
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: merge_src
name: merge_src
@@ -138,15 +138,15 @@ STAGE PLANS:
Move Operator
files:
hdfs directory: true
- source: pfile:/data/users/nzhang/work/870/apache-hive/build/ql/scratchdir/hive_2010-10-15_22-19-22_303_6951055031740945056/-ext-10002
- destination: pfile:/data/users/nzhang/work/870/apache-hive/build/ql/scratchdir/hive_2010-10-15_22-19-22_303_6951055031740945056/-ext-10001
+ source: pfile:/data/users/sdong/www/hive-trunk/build/ql/scratchdir/hive_2010-10-29_16-09-48_857_8226805934470604516/-ext-10002
+ destination: pfile:/data/users/sdong/www/hive-trunk/build/ql/scratchdir/hive_2010-10-29_16-09-48_857_8226805934470604516/-ext-10001
Stage: Stage-0
Move Operator
files:
hdfs directory: true
- source: pfile:/data/users/nzhang/work/870/apache-hive/build/ql/scratchdir/hive_2010-10-15_22-19-22_303_6951055031740945056/-ext-10001
- destination: pfile:///data/users/nzhang/work/870/apache-hive/build/ql/test/data/warehouse/merge_src2
+ source: pfile:/data/users/sdong/www/hive-trunk/build/ql/scratchdir/hive_2010-10-29_16-09-48_857_8226805934470604516/-ext-10001
+ destination: pfile:///data/users/sdong/www/hive-trunk/build/ql/test/data/warehouse/merge_src2
Stage: Stage-5
Create Table Operator:
@@ -162,11 +162,11 @@ STAGE PLANS:
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- pfile:/data/users/nzhang/work/870/apache-hive/build/ql/scratchdir/hive_2010-10-15_22-19-22_303_6951055031740945056/-ext-10002
+ pfile:/data/users/sdong/www/hive-trunk/build/ql/scratchdir/hive_2010-10-29_16-09-48_857_8226805934470604516/-ext-10002
File Output Operator
compressed: false
GlobalTableId: 0
- directory: pfile:/data/users/nzhang/work/870/apache-hive/build/ql/scratchdir/hive_2010-10-15_22-19-22_303_6951055031740945056/-ext-10001
+ directory: pfile:/data/users/sdong/www/hive-trunk/build/ql/scratchdir/hive_2010-10-29_16-09-48_857_8226805934470604516/-ext-10001
NumFilesPerFileSink: 1
table:
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -180,9 +180,9 @@ STAGE PLANS:
MultiFileSpray: false
Needs Tagging: false
Path -> Alias:
- pfile:/data/users/nzhang/work/870/apache-hive/build/ql/scratchdir/hive_2010-10-15_22-19-22_303_6951055031740945056/-ext-10002 [pfile:/data/users/nzhang/work/870/apache-hive/build/ql/scratchdir/hive_2010-10-15_22-19-22_303_6951055031740945056/-ext-10002]
+ pfile:/data/users/sdong/www/hive-trunk/build/ql/scratchdir/hive_2010-10-29_16-09-48_857_8226805934470604516/-ext-10002 [pfile:/data/users/sdong/www/hive-trunk/build/ql/scratchdir/hive_2010-10-29_16-09-48_857_8226805934470604516/-ext-10002]
Path -> Partition:
- pfile:/data/users/nzhang/work/870/apache-hive/build/ql/scratchdir/hive_2010-10-15_22-19-22_303_6951055031740945056/-ext-10002
+ pfile:/data/users/sdong/www/hive-trunk/build/ql/scratchdir/hive_2010-10-29_16-09-48_857_8226805934470604516/-ext-10002
Partition
base file name: -ext-10002
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -216,11 +216,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/nzhang/hive_2010-10-15_22-19-30_116_4238517620064424661/-mr-10000
+PREHOOK: Output: file:/tmp/sdong/hive_2010-10-29_16-09-56_418_6812893088145650163/-mr-10000
POSTHOOK: query: select * from merge_src2
POSTHOOK: type: QUERY
POSTHOOK: Input: default@merge_src2
-POSTHOOK: Output: file:/tmp/nzhang/hive_2010-10-15_22-19-30_116_4238517620064424661/-mr-10000
+POSTHOOK: Output: file:/tmp/sdong/hive_2010-10-29_16-09-56_418_6812893088145650163/-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), ]
@@ -2272,53 +2272,48 @@ STAGE PLANS:
predicate:
expr: ds is not null
type: boolean
- Filter Operator
- isSamplingPred: false
- predicate:
- expr: ds is not null
- type: boolean
- Select Operator
- expressions:
- expr: key
- type: string
- expr: value
- type: string
- expr: ds
- type: string
- outputColumnNames: _col0, _col1, _col2
- File Output Operator
- compressed: false
- GlobalTableId: 1
- directory: pfile:/data/users/nzhang/work/870/apache-hive/build/ql/scratchdir/hive_2010-10-15_22-19-30_551_7077121181128651844/-ext-10002
- NumFilesPerFileSink: 1
- Stats Publishing Key Prefix: pfile:/data/users/nzhang/work/870/apache-hive/build/ql/scratchdir/hive_2010-10-15_22-19-30_551_7077121181128651844/-ext-10000/
- table:
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- properties:
- bucket_count -1
- columns key,value
- columns.types string:string
- file.inputformat org.apache.hadoop.mapred.TextInputFormat
- file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location pfile:/data/users/nzhang/work/870/apache-hive/build/ql/test/data/warehouse/merge_src_part2
- name 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 1287206370
- serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- name: merge_src_part2
- TotalFiles: 1
- GatherStats: true
- MultiFileSpray: false
+ Select Operator
+ expressions:
+ expr: key
+ type: string
+ expr: value
+ type: string
+ expr: ds
+ type: string
+ outputColumnNames: _col0, _col1, _col2
+ File Output Operator
+ compressed: false
+ GlobalTableId: 1
+ directory: pfile:/data/users/sdong/www/hive-trunk/build/ql/scratchdir/hive_2010-10-29_16-09-56_894_7061888284179345199/-ext-10002
+ NumFilesPerFileSink: 1
+ Stats Publishing Key Prefix: pfile:/data/users/sdong/www/hive-trunk/build/ql/scratchdir/hive_2010-10-29_16-09-56_894_7061888284179345199/-ext-10000/
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ properties:
+ bucket_count -1
+ columns key,value
+ 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/hive-trunk/build/ql/test/data/warehouse/merge_src_part2
+ name 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 1288393796
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ name: merge_src_part2
+ TotalFiles: 1
+ GatherStats: true
+ MultiFileSpray: false
Needs Tagging: false
Path -> Alias:
- pfile:/data/users/nzhang/work/870/apache-hive/build/ql/test/data/warehouse/merge_src_part/ds=2008-04-08 [merge_src_part]
- pfile:/data/users/nzhang/work/870/apache-hive/build/ql/test/data/warehouse/merge_src_part/ds=2008-04-09 [merge_src_part]
+ pfile:/data/users/sdong/www/hive-trunk/build/ql/test/data/warehouse/merge_src_part/ds=2008-04-08 [merge_src_part]
+ pfile:/data/users/sdong/www/hive-trunk/build/ql/test/data/warehouse/merge_src_part/ds=2008-04-09 [merge_src_part]
Path -> Partition:
- pfile:/data/users/nzhang/work/870/apache-hive/build/ql/test/data/warehouse/merge_src_part/ds=2008-04-08
+ pfile:/data/users/sdong/www/hive-trunk/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
@@ -2331,7 +2326,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/nzhang/work/870/apache-hive/build/ql/test/data/warehouse/merge_src_part
+ location pfile:/data/users/sdong/www/hive-trunk/build/ql/test/data/warehouse/merge_src_part
name merge_src_part
numFiles 4
numPartitions 2
@@ -2341,7 +2336,7 @@ STAGE PLANS:
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
totalSize 23248
- transient_lastDdlTime 1287206362
+ transient_lastDdlTime 1288393788
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -2352,7 +2347,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/nzhang/work/870/apache-hive/build/ql/test/data/warehouse/merge_src_part
+ location pfile:/data/users/sdong/www/hive-trunk/build/ql/test/data/warehouse/merge_src_part
name merge_src_part
numFiles 4
numPartitions 2
@@ -2362,11 +2357,11 @@ STAGE PLANS:
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
totalSize 23248
- transient_lastDdlTime 1287206362
+ transient_lastDdlTime 1288393788
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: merge_src_part
name: merge_src_part
- pfile:/data/users/nzhang/work/870/apache-hive/build/ql/test/data/warehouse/merge_src_part/ds=2008-04-09
+ pfile:/data/users/sdong/www/hive-trunk/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
@@ -2379,7 +2374,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/nzhang/work/870/apache-hive/build/ql/test/data/warehouse/merge_src_part
+ location pfile:/data/users/sdong/www/hive-trunk/build/ql/test/data/warehouse/merge_src_part
name merge_src_part
numFiles 4
numPartitions 2
@@ -2389,7 +2384,7 @@ STAGE PLANS:
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
totalSize 23248
- transient_lastDdlTime 1287206362
+ transient_lastDdlTime 1288393788
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -2400,7 +2395,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/nzhang/work/870/apache-hive/build/ql/test/data/warehouse/merge_src_part
+ location pfile:/data/users/sdong/www/hive-trunk/build/ql/test/data/warehouse/merge_src_part
name merge_src_part
numFiles 4
numPartitions 2
@@ -2410,7 +2405,7 @@ STAGE PLANS:
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
totalSize 23248
- transient_lastDdlTime 1287206362
+ transient_lastDdlTime 1288393788
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: merge_src_part
name: merge_src_part
@@ -2422,8 +2417,8 @@ STAGE PLANS:
Move Operator
files:
hdfs directory: true
- source: pfile:/data/users/nzhang/work/870/apache-hive/build/ql/scratchdir/hive_2010-10-15_22-19-30_551_7077121181128651844/-ext-10002
- destination: pfile:/data/users/nzhang/work/870/apache-hive/build/ql/scratchdir/hive_2010-10-15_22-19-30_551_7077121181128651844/-ext-10000
+ source: pfile:/data/users/sdong/www/hive-trunk/build/ql/scratchdir/hive_2010-10-29_16-09-56_894_7061888284179345199/-ext-10002
+ destination: pfile:/data/users/sdong/www/hive-trunk/build/ql/scratchdir/hive_2010-10-29_16-09-56_894_7061888284179345199/-ext-10000
Stage: Stage-0
Move Operator
@@ -2431,7 +2426,7 @@ STAGE PLANS:
partition:
ds
replace: true
- source: pfile:/data/users/nzhang/work/870/apache-hive/build/ql/scratchdir/hive_2010-10-15_22-19-30_551_7077121181128651844/-ext-10000
+ source: pfile:/data/users/sdong/www/hive-trunk/build/ql/scratchdir/hive_2010-10-29_16-09-56_894_7061888284179345199/-ext-10000
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -2441,29 +2436,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/nzhang/work/870/apache-hive/build/ql/test/data/warehouse/merge_src_part2
+ location pfile:/data/users/sdong/www/hive-trunk/build/ql/test/data/warehouse/merge_src_part2
name 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 1287206370
+ transient_lastDdlTime 1288393796
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: merge_src_part2
- tmp directory: pfile:/data/users/nzhang/work/870/apache-hive/build/ql/scratchdir/hive_2010-10-15_22-19-30_551_7077121181128651844/-ext-10001
+ tmp directory: pfile:/data/users/sdong/www/hive-trunk/build/ql/scratchdir/hive_2010-10-29_16-09-56_894_7061888284179345199/-ext-10001
Stage: Stage-2
Stats-Aggr Operator
- Stats Aggregation Key Prefix: pfile:/data/users/nzhang/work/870/apache-hive/build/ql/scratchdir/hive_2010-10-15_22-19-30_551_7077121181128651844/-ext-10000/
+ Stats Aggregation Key Prefix: pfile:/data/users/sdong/www/hive-trunk/build/ql/scratchdir/hive_2010-10-29_16-09-56_894_7061888284179345199/-ext-10000/
Stage: Stage-3
Map Reduce
Alias -> Map Operator Tree:
- pfile:/data/users/nzhang/work/870/apache-hive/build/ql/scratchdir/hive_2010-10-15_22-19-30_551_7077121181128651844/-ext-10002
+ pfile:/data/users/sdong/www/hive-trunk/build/ql/scratchdir/hive_2010-10-29_16-09-56_894_7061888284179345199/-ext-10002
File Output Operator
compressed: false
GlobalTableId: 0
- directory: pfile:/data/users/nzhang/work/870/apache-hive/build/ql/scratchdir/hive_2010-10-15_22-19-30_551_7077121181128651844/-ext-10000
+ directory: pfile:/data/users/sdong/www/hive-trunk/build/ql/scratchdir/hive_2010-10-29_16-09-56_894_7061888284179345199/-ext-10000
NumFilesPerFileSink: 1
table:
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -2474,13 +2469,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/nzhang/work/870/apache-hive/build/ql/test/data/warehouse/merge_src_part2
+ location pfile:/data/users/sdong/www/hive-trunk/build/ql/test/data/warehouse/merge_src_part2
name 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 1287206370
+ transient_lastDdlTime 1288393796
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: merge_src_part2
TotalFiles: 1
@@ -2488,9 +2483,9 @@ STAGE PLANS:
MultiFileSpray: false
Needs Tagging: false
Path -> Alias:
- pfile:/data/users/nzhang/work/870/apache-hive/build/ql/scratchdir/hive_2010-10-15_22-19-30_551_7077121181128651844/-ext-10002 [pfile:/data/users/nzhang/work/870/apache-hive/build/ql/scratchdir/hive_2010-10-15_22-19-30_551_7077121181128651844/-ext-10002]
+ pfile:/data/users/sdong/www/hive-trunk/build/ql/scratchdir/hive_2010-10-29_16-09-56_894_7061888284179345199/-ext-10002 [pfile:/data/users/sdong/www/hive-trunk/build/ql/scratchdir/hive_2010-10-29_16-09-56_894_7061888284179345199/-ext-10002]
Path -> Partition:
- pfile:/data/users/nzhang/work/870/apache-hive/build/ql/scratchdir/hive_2010-10-15_22-19-30_551_7077121181128651844/-ext-10002
+ pfile:/data/users/sdong/www/hive-trunk/build/ql/scratchdir/hive_2010-10-29_16-09-56_894_7061888284179345199/-ext-10002
Partition
base file name: -ext-10002
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -2501,13 +2496,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/nzhang/work/870/apache-hive/build/ql/test/data/warehouse/merge_src_part2
+ location pfile:/data/users/sdong/www/hive-trunk/build/ql/test/data/warehouse/merge_src_part2
name 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 1287206370
+ transient_lastDdlTime 1288393796
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -2518,13 +2513,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/nzhang/work/870/apache-hive/build/ql/test/data/warehouse/merge_src_part2
+ location pfile:/data/users/sdong/www/hive-trunk/build/ql/test/data/warehouse/merge_src_part2
name 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 1287206370
+ transient_lastDdlTime 1288393796
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: merge_src_part2
name: merge_src_part2
@@ -2570,12 +2565,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/nzhang/hive_2010-10-15_22-19-42_452_7793079200177405408/-mr-10000
+PREHOOK: Output: file:/tmp/sdong/hive_2010-10-29_16-10-09_585_5952318912198434145/-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/nzhang/hive_2010-10-15_22-19-42_452_7793079200177405408/-mr-10000
+POSTHOOK: Output: file:/tmp/sdong/hive_2010-10-29_16-10-09_585_5952318912198434145/-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), ]
@@ -4655,39 +4650,34 @@ STAGE PLANS:
predicate:
expr: ds is not null
type: boolean
- Filter Operator
- isSamplingPred: false
- predicate:
- expr: ds is not null
- type: boolean
- Select Operator
- expressions:
- expr: key
+ Select Operator
+ expressions:
+ expr: key
+ type: string
+ expr: value
+ type: string
+ expr: ds
+ type: string
+ outputColumnNames: _col0, _col1, _col2
+ Reduce Output Operator
+ sort order:
+ Map-reduce partition columns:
+ expr: _col2
type: string
- expr: value
+ tag: -1
+ value expressions:
+ expr: _col0
type: string
- expr: ds
+ expr: _col1
+ type: string
+ expr: _col2
type: string
- outputColumnNames: _col0, _col1, _col2
- Reduce Output Operator
- sort order:
- Map-reduce partition columns:
- expr: _col2
- type: string
- tag: -1
- value expressions:
- expr: _col0
- type: string
- expr: _col1
- type: string
- expr: _col2
- type: string
Needs Tagging: false
Path -> Alias:
- pfile:/data/users/nzhang/work/870/apache-hive/build/ql/test/data/warehouse/merge_src_part/ds=2008-04-08 [s:merge_src_part]
- pfile:/data/users/nzhang/work/870/apache-hive/build/ql/test/data/warehouse/merge_src_part/ds=2008-04-09 [s:merge_src_part]
+ pfile:/data/users/sdong/www/hive-trunk/build/ql/test/data/warehouse/merge_src_part/ds=2008-04-08 [s:merge_src_part]
+ pfile:/data/users/sdong/www/hive-trunk/build/ql/test/data/warehouse/merge_src_part/ds=2008-04-09 [s:merge_src_part]
Path -> Partition:
- pfile:/data/users/nzhang/work/870/apache-hive/build/ql/test/data/warehouse/merge_src_part/ds=2008-04-08
+ pfile:/data/users/sdong/www/hive-trunk/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
@@ -4700,7 +4690,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/nzhang/work/870/apache-hive/build/ql/test/data/warehouse/merge_src_part
+ location pfile:/data/users/sdong/www/hive-trunk/build/ql/test/data/warehouse/merge_src_part
name merge_src_part
numFiles 4
numPartitions 2
@@ -4710,7 +4700,7 @@ STAGE PLANS:
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
totalSize 23248
- transient_lastDdlTime 1287206362
+ transient_lastDdlTime 1288393788
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -4721,7 +4711,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/nzhang/work/870/apache-hive/build/ql/test/data/warehouse/merge_src_part
+ location pfile:/data/users/sdong/www/hive-trunk/build/ql/test/data/warehouse/merge_src_part
name merge_src_part
numFiles 4
numPartitions 2
@@ -4731,11 +4721,11 @@ STAGE PLANS:
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
totalSize 23248
- transient_lastDdlTime 1287206362
+ transient_lastDdlTime 1288393788
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: merge_src_part
name: merge_src_part
- pfile:/data/users/nzhang/work/870/apache-hive/build/ql/test/data/warehouse/merge_src_part/ds=2008-04-09
+ pfile:/data/users/sdong/www/hive-trunk/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
@@ -4748,7 +4738,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/nzhang/work/870/apache-hive/build/ql/test/data/warehouse/merge_src_part
+ location pfile:/data/users/sdong/www/hive-trunk/build/ql/test/data/warehouse/merge_src_part
name merge_src_part
numFiles 4
numPartitions 2
@@ -4758,7 +4748,7 @@ STAGE PLANS:
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
totalSize 23248
- transient_lastDdlTime 1287206362
+ transient_lastDdlTime 1288393788
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -4769,7 +4759,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/nzhang/work/870/apache-hive/build/ql/test/data/warehouse/merge_src_part
+ location pfile:/data/users/sdong/www/hive-trunk/build/ql/test/data/warehouse/merge_src_part
name merge_src_part
numFiles 4
numPartitions 2
@@ -4779,7 +4769,7 @@ STAGE PLANS:
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
totalSize 23248
- transient_lastDdlTime 1287206362
+ transient_lastDdlTime 1288393788
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: merge_src_part
name: merge_src_part
@@ -4797,9 +4787,9 @@ STAGE PLANS:
File Output Operator
compressed: false
GlobalTableId: 1
- directory: pfile:/data/users/nzhang/work/870/apache-hive/build/ql/scratchdir/hive_2010-10-15_22-19-43_478_5162011743005075818/-ext-10002
+ directory: pfile:/data/users/sdong/www/hive-trunk/build/ql/scratchdir/hive_2010-10-29_16-10-10_626_1744796538862904462/-ext-10002
NumFilesPerFileSink: 1
- Stats Publishing Key Prefix: pfile:/data/users/nzhang/work/870/apache-hive/build/ql/scratchdir/hive_2010-10-15_22-19-43_478_5162011743005075818/-ext-10000/
+ Stats Publishing Key Prefix: pfile:/data/users/sdong/www/hive-trunk/build/ql/scratchdir/hive_2010-10-29_16-10-10_626_1744796538862904462/-ext-10000/
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -4809,13 +4799,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/nzhang/work/870/apache-hive/build/ql/test/data/warehouse/merge_src_part2
+ location pfile:/data/users/sdong/www/hive-trunk/build/ql/test/data/warehouse/merge_src_part2
name 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 1287206383
+ transient_lastDdlTime 1288393810
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: merge_src_part2
TotalFiles: 1
@@ -4829,8 +4819,8 @@ STAGE PLANS:
Move Operator
files:
hdfs directory: true
- source: pfile:/data/users/nzhang/work/870/apache-hive/build/ql/scratchdir/hive_2010-10-15_22-19-43_478_5162011743005075818/-ext-10002
- destination: pfile:/data/users/nzhang/work/870/apache-hive/build/ql/scratchdir/hive_2010-10-15_22-19-43_478_5162011743005075818/-ext-10000
+ source: pfile:/data/users/sdong/www/hive-trunk/build/ql/scratchdir/hive_2010-10-29_16-10-10_626_1744796538862904462/-ext-10002
+ destination: pfile:/data/users/sdong/www/hive-trunk/build/ql/scratchdir/hive_2010-10-29_16-10-10_626_1744796538862904462/-ext-10000
Stage: Stage-0
Move Operator
@@ -4838,7 +4828,7 @@ STAGE PLANS:
partition:
ds
replace: true
- source: pfile:/data/users/nzhang/work/870/apache-hive/build/ql/scratchdir/hive_2010-10-15_22-19-43_478_5162011743005075818/-ext-10000
+ source: pfile:/data/users/sdong/www/hive-trunk/build/ql/scratchdir/hive_2010-10-29_16-10-10_626_1744796538862904462/-ext-10000
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -4848,29 +4838,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/nzhang/work/870/apache-hive/build/ql/test/data/warehouse/merge_src_part2
+ location pfile:/data/users/sdong/www/hive-trunk/build/ql/test/data/warehouse/merge_src_part2
name 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 1287206383
+ transient_lastDdlTime 1288393810
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: merge_src_part2
- tmp directory: pfile:/data/users/nzhang/work/870/apache-hive/build/ql/scratchdir/hive_2010-10-15_22-19-43_478_5162011743005075818/-ext-10001
+ tmp directory: pfile:/data/users/sdong/www/hive-trunk/build/ql/scratchdir/hive_2010-10-29_16-10-10_626_1744796538862904462/-ext-10001
Stage: Stage-2
Stats-Aggr Operator
- Stats Aggregation Key Prefix: pfile:/data/users/nzhang/work/870/apache-hive/build/ql/scratchdir/hive_2010-10-15_22-19-43_478_5162011743005075818/-ext-10000/
+ Stats Aggregation Key Prefix: pfile:/data/users/sdong/www/hive-trunk/build/ql/scratchdir/hive_2010-10-29_16-10-10_626_1744796538862904462/-ext-10000/
Stage: Stage-3
Map Reduce
Alias -> Map Operator Tree:
- pfile:/data/users/nzhang/work/870/apache-hive/build/ql/scratchdir/hive_2010-10-15_22-19-43_478_5162011743005075818/-ext-10002
+ pfile:/data/users/sdong/www/hive-trunk/build/ql/scratchdir/hive_2010-10-29_16-10-10_626_1744796538862904462/-ext-10002
File Output Operator
compressed: false
GlobalTableId: 0
- directory: pfile:/data/users/nzhang/work/870/apache-hive/build/ql/scratchdir/hive_2010-10-15_22-19-43_478_5162011743005075818/-ext-10000
+ directory: pfile:/data/users/sdong/www/hive-trunk/build/ql/scratchdir/hive_2010-10-29_16-10-10_626_1744796538862904462/-ext-10000
NumFilesPerFileSink: 1
table:
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -4881,13 +4871,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/nzhang/work/870/apache-hive/build/ql/test/data/warehouse/merge_src_part2
+ location pfile:/data/users/sdong/www/hive-trunk/build/ql/test/data/warehouse/merge_src_part2
name 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 1287206383
+ transient_lastDdlTime 1288393810
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: merge_src_part2
TotalFiles: 1
@@ -4895,9 +4885,9 @@ STAGE PLANS:
MultiFileSpray: false
Needs Tagging: false
Path -> Alias:
- pfile:/data/users/nzhang/work/870/apache-hive/build/ql/scratchdir/hive_2010-10-15_22-19-43_478_5162011743005075818/-ext-10002 [pfile:/data/users/nzhang/work/870/apache-hive/build/ql/scratchdir/hive_2010-10-15_22-19-43_478_5162011743005075818/-ext-10002]
+ pfile:/data/users/sdong/www/hive-trunk/build/ql/scratchdir/hive_2010-10-29_16-10-10_626_1744796538862904462/-ext-10002 [pfile:/data/users/sdong/www/hive-trunk/build/ql/scratchdir/hive_2010-10-29_16-10-10_626_1744796538862904462/-ext-10002]
Path -> Partition:
- pfile:/data/users/nzhang/work/870/apache-hive/build/ql/scratchdir/hive_2010-10-15_22-19-43_478_5162011743005075818/-ext-10002
+ pfile:/data/users/sdong/www/hive-trunk/build/ql/scratchdir/hive_2010-10-29_16-10-10_626_1744796538862904462/-ext-10002
Partition
base file name: -ext-10002
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -4908,13 +4898,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/nzhang/work/870/apache-hive/build/ql/test/data/warehouse/merge_src_part2
+ location pfile:/data/users/sdong/www/hive-trunk/build/ql/test/data/warehouse/merge_src_part2
name 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 1287206383
+ transient_lastDdlTime 1288393810
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -4925,18 +4915,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/nzhang/work/870/apache-hive/build/ql/test/data/warehouse/merge_src_part2
+ location pfile:/data/users/sdong/www/hive-trunk/build/ql/test/data/warehouse/merge_src_part2
name 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 1287206383
+ transient_lastDdlTime 1288393810
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: merge_src_part2
name: merge_src_part2
-
PREHOOK: query: from (select * from merge_src_part where ds is not null distribute by ds) s
insert overwrite table merge_src_part2 partition(ds)
select key, value, ds
@@ -4985,12 +4974,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/nzhang/hive_2010-10-15_22-19-57_065_3435022740672814575/-mr-10000
+PREHOOK: Output: file:/tmp/sdong/hive_2010-10-29_16-10-22_845_6936272381319043085/-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/nzhang/hive_2010-10-15_22-19-57_065_3435022740672814575/-mr-10000
+POSTHOOK: Output: file:/tmp/sdong/hive_2010-10-29_16-10-22_845_6936272381319043085/-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), ]
Modified: hive/trunk/ql/src/test/results/clientpositive/merge4.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/merge4.q.out?rev=1031676&r1=1031675&r2=1031676&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/merge4.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/merge4.q.out Fri Nov 5 17:29:28 2010
@@ -31,27 +31,23 @@ STAGE PLANS:
predicate:
expr: (ds = '2008-04-08')
type: boolean
- Filter Operator
- predicate:
- expr: (ds = '2008-04-08')
- type: boolean
- Select Operator
- expressions:
- expr: key
- type: string
- expr: value
- type: string
- expr: hr
- type: string
- outputColumnNames: _col0, _col1, _col2
- File Output Operator
- compressed: false
- GlobalTableId: 1
- table:
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- name: nzhang_part
+ Select Operator
+ expressions:
+ expr: key
+ type: string
+ expr: value
+ type: string
+ expr: hr
+ type: string
+ outputColumnNames: _col0, _col1, _col2
+ File Output Operator
+ compressed: false
+ GlobalTableId: 1
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ name: nzhang_part
Stage: Stage-5
Conditional Operator
@@ -60,7 +56,7 @@ STAGE PLANS:
Move Operator
files:
hdfs directory: true
- destination: pfile:/data/users/nzhang/work/784/apache-hive/build/ql/scratchdir/hive_2010-09-21_00-27-33_418_8321844712406551860/-ext-10000
+ destination: pfile:/data/users/sdong/www/hive-trunk/build/ql/scratchdir/hive_2010-10-29_16-10-24_826_9060381908424669122/-ext-10000
Stage: Stage-0
Move Operator
@@ -81,7 +77,7 @@ STAGE PLANS:
Stage: Stage-3
Map Reduce
Alias -> Map Operator Tree:
- pfile:/data/users/nzhang/work/784/apache-hive/build/ql/scratchdir/hive_2010-09-21_00-27-33_418_8321844712406551860/-ext-10002
+ pfile:/data/users/sdong/www/hive-trunk/build/ql/scratchdir/hive_2010-10-29_16-10-24_826_9060381908424669122/-ext-10002
File Output Operator
compressed: false
GlobalTableId: 0
@@ -110,12 +106,12 @@ PREHOOK: query: select * from nzhang_par
PREHOOK: type: QUERY
PREHOOK: Input: default@nzhang_part@ds=2010-08-15/hr=11
PREHOOK: Input: default@nzhang_part@ds=2010-08-15/hr=12
-PREHOOK: Output: file:/tmp/nzhang/hive_2010-09-21_00-27-45_749_6761468726494270601/-mr-10000
+PREHOOK: Output: file:/tmp/sdong/hive_2010-10-29_16-10-35_018_1318380414009166085/-mr-10000
POSTHOOK: query: select * from nzhang_part
POSTHOOK: type: QUERY
POSTHOOK: Input: default@nzhang_part@ds=2010-08-15/hr=11
POSTHOOK: Input: default@nzhang_part@ds=2010-08-15/hr=12
-POSTHOOK: Output: file:/tmp/nzhang/hive_2010-09-21_00-27-45_749_6761468726494270601/-mr-10000
+POSTHOOK: Output: file:/tmp/sdong/hive_2010-10-29_16-10-35_018_1318380414009166085/-mr-10000
POSTHOOK: Lineage: nzhang_part PARTITION(ds=2010-08-15,hr=11).key SIMPLE [(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: nzhang_part PARTITION(ds=2010-08-15,hr=11).value SIMPLE [(srcpart)srcpart.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: nzhang_part PARTITION(ds=2010-08-15,hr=12).key SIMPLE [(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ]
@@ -1152,25 +1148,21 @@ STAGE PLANS:
predicate:
expr: (ds = '2008-04-08')
type: boolean
- Filter Operator
- predicate:
- expr: (ds = '2008-04-08')
- type: boolean
- Select Operator
- expressions:
- expr: key
- type: string
- expr: value
- type: string
- outputColumnNames: _col0, _col1
- File Output Operator
- compressed: false
- GlobalTableId: 1
- table:
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- name: nzhang_part
+ Select Operator
+ expressions:
+ expr: key
+ type: string
+ expr: value
+ type: string
+ outputColumnNames: _col0, _col1
+ File Output Operator
+ compressed: false
+ GlobalTableId: 1
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ name: nzhang_part
Stage: Stage-5
Conditional Operator
@@ -1179,7 +1171,7 @@ STAGE PLANS:
Move Operator
files:
hdfs directory: true
- destination: pfile:/data/users/nzhang/work/784/apache-hive/build/ql/scratchdir/hive_2010-09-21_00-27-46_548_4926136843884722397/-ext-10000
+ destination: pfile:/data/users/sdong/www/hive-trunk/build/ql/scratchdir/hive_2010-10-29_16-10-35_790_5693124847092356313/-ext-10000
Stage: Stage-0
Move Operator
@@ -1200,7 +1192,7 @@ STAGE PLANS:
Stage: Stage-3
Map Reduce
Alias -> Map Operator Tree:
- pfile:/data/users/nzhang/work/784/apache-hive/build/ql/scratchdir/hive_2010-09-21_00-27-46_548_4926136843884722397/-ext-10002
+ pfile:/data/users/sdong/www/hive-trunk/build/ql/scratchdir/hive_2010-10-29_16-10-35_790_5693124847092356313/-ext-10002
File Output Operator
compressed: false
GlobalTableId: 0
@@ -1231,12 +1223,12 @@ PREHOOK: query: select * from nzhang_par
PREHOOK: type: QUERY
PREHOOK: Input: default@nzhang_part@ds=2010-08-15/hr=11
PREHOOK: Input: default@nzhang_part@ds=2010-08-15/hr=12
-PREHOOK: Output: file:/tmp/nzhang/hive_2010-09-21_00-27-57_876_3323265609012860875/-mr-10000
+PREHOOK: Output: file:/tmp/sdong/hive_2010-10-29_16-10-44_292_3708871835977595256/-mr-10000
POSTHOOK: query: select * from nzhang_part
POSTHOOK: type: QUERY
POSTHOOK: Input: default@nzhang_part@ds=2010-08-15/hr=11
POSTHOOK: Input: default@nzhang_part@ds=2010-08-15/hr=12
-POSTHOOK: Output: file:/tmp/nzhang/hive_2010-09-21_00-27-57_876_3323265609012860875/-mr-10000
+POSTHOOK: Output: file:/tmp/sdong/hive_2010-10-29_16-10-44_292_3708871835977595256/-mr-10000
POSTHOOK: Lineage: nzhang_part PARTITION(ds=2010-08-15,hr=11).key SIMPLE [(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: nzhang_part PARTITION(ds=2010-08-15,hr=11).value SIMPLE [(srcpart)srcpart.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: nzhang_part PARTITION(ds=2010-08-15,hr=11).key SIMPLE [(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ]
@@ -2787,30 +2779,26 @@ STAGE PLANS:
predicate:
expr: (ds = '2008-04-08')
type: boolean
- Filter Operator
- predicate:
- expr: (ds = '2008-04-08')
- type: boolean
- Select Operator
- expressions:
- expr: key
- type: string
- expr: value
- type: string
- expr: hr
- type: string
- outputColumnNames: _col0, _col1, _col2
- File Output Operator
- compressed: false
- GlobalTableId: 0
- table:
- input format: org.apache.hadoop.mapred.SequenceFileInputFormat
- output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
+ Select Operator
+ expressions:
+ expr: key
+ type: string
+ expr: value
+ type: string
+ expr: hr
+ type: string
+ outputColumnNames: _col0, _col1, _col2
+ File Output Operator
+ compressed: false
+ GlobalTableId: 0
+ table:
+ input format: org.apache.hadoop.mapred.SequenceFileInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/tmp/nzhang/hive_2010-09-21_00-27-58_682_6033422304556905840/-mr-10002
+ file:/tmp/sdong/hive_2010-10-29_16-10-45_065_691354792932908947/-mr-10002
Union
Select Operator
expressions:
@@ -2829,7 +2817,7 @@ STAGE PLANS:
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: nzhang_part
- file:/tmp/nzhang/hive_2010-09-21_00-27-58_682_6033422304556905840/-mr-10004
+ file:/tmp/sdong/hive_2010-10-29_16-10-45_065_691354792932908947/-mr-10004
Union
Select Operator
expressions:
@@ -2856,7 +2844,7 @@ STAGE PLANS:
Move Operator
files:
hdfs directory: true
- destination: pfile:/data/users/nzhang/work/784/apache-hive/build/ql/scratchdir/hive_2010-09-21_00-27-58_682_6033422304556905840/-ext-10000
+ destination: pfile:/data/users/sdong/www/hive-trunk/build/ql/scratchdir/hive_2010-10-29_16-10-45_065_691354792932908947/-ext-10000
Stage: Stage-0
Move Operator
@@ -2877,7 +2865,7 @@ STAGE PLANS:
Stage: Stage-4
Map Reduce
Alias -> Map Operator Tree:
- pfile:/data/users/nzhang/work/784/apache-hive/build/ql/scratchdir/hive_2010-09-21_00-27-58_682_6033422304556905840/-ext-10003
+ pfile:/data/users/sdong/www/hive-trunk/build/ql/scratchdir/hive_2010-10-29_16-10-45_065_691354792932908947/-ext-10003
File Output Operator
compressed: false
GlobalTableId: 0
@@ -2979,11 +2967,11 @@ ds=2010-08-15/hr=file,
PREHOOK: query: select * from nzhang_part where hr = 'file,'
PREHOOK: type: QUERY
PREHOOK: Input: default@nzhang_part@ds=2010-08-15/hr=file,
-PREHOOK: Output: file:/tmp/nzhang/hive_2010-09-21_00-28-20_480_4738957703179155628/-mr-10000
+PREHOOK: Output: file:/tmp/sdong/hive_2010-10-29_16-11-03_825_5284968767554728986/-mr-10000
POSTHOOK: query: select * from nzhang_part where hr = 'file,'
POSTHOOK: type: QUERY
POSTHOOK: Input: default@nzhang_part@ds=2010-08-15/hr=file,
-POSTHOOK: Output: file:/tmp/nzhang/hive_2010-09-21_00-28-20_480_4738957703179155628/-mr-10000
+POSTHOOK: Output: file:/tmp/sdong/hive_2010-10-29_16-11-03_825_5284968767554728986/-mr-10000
POSTHOOK: Lineage: nzhang_part PARTITION(ds=2010-08-15,hr=11).key SIMPLE [(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: nzhang_part PARTITION(ds=2010-08-15,hr=11).value SIMPLE [(srcpart)srcpart.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: nzhang_part PARTITION(ds=2010-08-15,hr=11).key EXPRESSION [(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ]
Modified: hive/trunk/ql/src/test/results/clientpositive/merge_dynamic_partition.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/merge_dynamic_partition.q.out?rev=1031676&r1=1031675&r2=1031676&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/merge_dynamic_partition.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/merge_dynamic_partition.q.out Fri Nov 5 17:29:28 2010
@@ -53,27 +53,23 @@ STAGE PLANS:
predicate:
expr: (ds = '2008-04-08')
type: boolean
- Filter Operator
- predicate:
- expr: (ds = '2008-04-08')
- type: boolean
- Select Operator
- expressions:
- expr: key
- type: string
- expr: value
- type: string
- expr: hr
- type: string
- outputColumnNames: _col0, _col1, _col2
- File Output Operator
- compressed: false
- GlobalTableId: 1
- table:
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- name: merge_dynamic_part
+ Select Operator
+ expressions:
+ expr: key
+ type: string
+ expr: value
+ type: string
+ expr: hr
+ type: string
+ outputColumnNames: _col0, _col1, _col2
+ File Output Operator
+ compressed: false
+ GlobalTableId: 1
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ name: merge_dynamic_part
Stage: Stage-0
Move Operator
@@ -104,11 +100,11 @@ POSTHOOK: Lineage: merge_dynamic_part PA
PREHOOK: query: select * from merge_dynamic_part
PREHOOK: type: QUERY
PREHOOK: Input: default@merge_dynamic_part@ds=2008-04-08/hr=11
-PREHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-11-04_14-42-21_142_3343014229979092724/-mr-10000
+PREHOOK: Output: file:/tmp/njain/hive_2010-11-05_10-12-08_833_8175139864246386399/-mr-10000
POSTHOOK: query: select * from merge_dynamic_part
POSTHOOK: type: QUERY
POSTHOOK: Input: default@merge_dynamic_part@ds=2008-04-08/hr=11
-POSTHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-11-04_14-42-21_142_3343014229979092724/-mr-10000
+POSTHOOK: Output: file:/tmp/njain/hive_2010-11-05_10-12-08_833_8175139864246386399/-mr-10000
POSTHOOK: Lineage: merge_dynamic_part PARTITION(ds=2008-04-08,hr=11).key SIMPLE [(srcpart_merge_dp)srcpart_merge_dp.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: merge_dynamic_part PARTITION(ds=2008-04-08,hr=11).value SIMPLE [(srcpart_merge_dp)srcpart_merge_dp.FieldSchema(name:value, type:string, comment:default), ]
165 val_165 2008-04-08 11
@@ -619,7 +615,7 @@ POSTHOOK: Lineage: merge_dynamic_part PA
POSTHOOK: Lineage: merge_dynamic_part PARTITION(ds=2008-04-08,hr=11).value SIMPLE [(srcpart_merge_dp)srcpart_merge_dp.FieldSchema(name:value, type:string, comment:default), ]
tableName:merge_dynamic_part
owner:null
-location:pfile:/Users/heyongqiang/Documents/workspace/Hive-Index/build/ql/test/data/warehouse/merge_dynamic_part
+location:pfile:/data/users/njain/hive_commit2/hive_commit2/build/ql/test/data/warehouse/merge_dynamic_part
inputformat:org.apache.hadoop.mapred.TextInputFormat
outputformat:org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
columns:struct columns { string key, string value}
@@ -630,7 +626,7 @@ totalFileSize:5812
maxFileSize:1612
minFileSize:1358
lastAccessTime:0
-lastUpdateTime:1288906940000
+lastUpdateTime:1288977128000
PREHOOK: query: explain
insert overwrite table merge_dynamic_part partition (ds='2008-04-08', hr=11) select key, value from srcpart_merge_dp where ds='2008-04-08'
@@ -662,25 +658,21 @@ STAGE PLANS:
predicate:
expr: (ds = '2008-04-08')
type: boolean
- Filter Operator
- predicate:
- expr: (ds = '2008-04-08')
- type: boolean
- Select Operator
- expressions:
- expr: key
- type: string
- expr: value
- type: string
- outputColumnNames: _col0, _col1
- File Output Operator
- compressed: false
- GlobalTableId: 1
- table:
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- name: merge_dynamic_part
+ Select Operator
+ expressions:
+ expr: key
+ type: string
+ expr: value
+ type: string
+ outputColumnNames: _col0, _col1
+ File Output Operator
+ compressed: false
+ GlobalTableId: 1
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ name: merge_dynamic_part
Stage: Stage-5
Conditional Operator
@@ -689,7 +681,7 @@ STAGE PLANS:
Move Operator
files:
hdfs directory: true
- destination: pfile:/Users/heyongqiang/Documents/workspace/Hive-Index/build/ql/scratchdir/hive_2010-11-04_14-42-21_984_8503758598119979822/-ext-10000
+ destination: pfile:/data/users/njain/hive_commit2/hive_commit2/build/ql/scratchdir/hive_2010-11-05_10-12-10_246_1197559924631752211/-ext-10000
Stage: Stage-0
Move Operator
@@ -710,7 +702,7 @@ STAGE PLANS:
Stage: Stage-3
Map Reduce
Alias -> Map Operator Tree:
- pfile:/Users/heyongqiang/Documents/workspace/Hive-Index/build/ql/scratchdir/hive_2010-11-04_14-42-21_984_8503758598119979822/-ext-10002
+ pfile:/data/users/njain/hive_commit2/hive_commit2/build/ql/scratchdir/hive_2010-11-05_10-12-10_246_1197559924631752211/-ext-10002
File Output Operator
compressed: false
GlobalTableId: 0
@@ -736,11 +728,11 @@ POSTHOOK: Lineage: merge_dynamic_part PA
PREHOOK: query: select * from merge_dynamic_part
PREHOOK: type: QUERY
PREHOOK: Input: default@merge_dynamic_part@ds=2008-04-08/hr=11
-PREHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-11-04_14-42-30_074_2740374018431476503/-mr-10000
+PREHOOK: Output: file:/tmp/njain/hive_2010-11-05_10-12-19_495_7619100589316718014/-mr-10000
POSTHOOK: query: select * from merge_dynamic_part
POSTHOOK: type: QUERY
POSTHOOK: Input: default@merge_dynamic_part@ds=2008-04-08/hr=11
-POSTHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-11-04_14-42-30_074_2740374018431476503/-mr-10000
+POSTHOOK: Output: file:/tmp/njain/hive_2010-11-05_10-12-19_495_7619100589316718014/-mr-10000
POSTHOOK: Lineage: merge_dynamic_part PARTITION(ds=2008-04-08,hr=11).key SIMPLE [(srcpart_merge_dp)srcpart_merge_dp.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: merge_dynamic_part PARTITION(ds=2008-04-08,hr=11).value SIMPLE [(srcpart_merge_dp)srcpart_merge_dp.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: merge_dynamic_part PARTITION(ds=2008-04-08,hr=11).key SIMPLE [(srcpart_merge_dp)srcpart_merge_dp.FieldSchema(name:key, type:string, comment:default), ]
@@ -1255,7 +1247,7 @@ POSTHOOK: Lineage: merge_dynamic_part PA
POSTHOOK: Lineage: merge_dynamic_part PARTITION(ds=2008-04-08,hr=11).value SIMPLE [(srcpart_merge_dp)srcpart_merge_dp.FieldSchema(name:value, type:string, comment:default), ]
tableName:merge_dynamic_part
owner:null
-location:pfile:/Users/heyongqiang/Documents/workspace/Hive-Index/build/ql/test/data/warehouse/merge_dynamic_part
+location:pfile:/data/users/njain/hive_commit2/hive_commit2/build/ql/test/data/warehouse/merge_dynamic_part
inputformat:org.apache.hadoop.mapred.TextInputFormat
outputformat:org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
columns:struct columns { string key, string value}
@@ -1266,7 +1258,7 @@ totalFileSize:5812
maxFileSize:5812
minFileSize:5812
lastAccessTime:0
-lastUpdateTime:1288906947000
+lastUpdateTime:1288977137000
PREHOOK: query: explain
insert overwrite table merge_dynamic_part partition (ds, hr) select key, value, ds, hr from srcpart_merge_dp where ds='2008-04-08' and hr=11
@@ -1300,29 +1292,25 @@ STAGE PLANS:
predicate:
expr: ((ds = '2008-04-08') and (hr = 11))
type: boolean
- Filter Operator
- predicate:
- expr: ((ds = '2008-04-08') and (hr = 11))
- type: boolean
- Select Operator
- expressions:
- expr: key
- type: string
- expr: value
- type: string
- expr: ds
- type: string
- expr: hr
- type: string
- outputColumnNames: _col0, _col1, _col2, _col3
- File Output Operator
- compressed: false
- GlobalTableId: 1
- table:
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- name: merge_dynamic_part
+ Select Operator
+ expressions:
+ expr: key
+ type: string
+ expr: value
+ type: string
+ expr: ds
+ type: string
+ expr: hr
+ type: string
+ outputColumnNames: _col0, _col1, _col2, _col3
+ File Output Operator
+ compressed: false
+ GlobalTableId: 1
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ name: merge_dynamic_part
Stage: Stage-5
Conditional Operator
@@ -1331,7 +1319,7 @@ STAGE PLANS:
Move Operator
files:
hdfs directory: true
- destination: pfile:/Users/heyongqiang/Documents/workspace/Hive-Index/build/ql/scratchdir/hive_2010-11-04_14-42-30_525_7636455345541234720/-ext-10000
+ destination: pfile:/data/users/njain/hive_commit2/hive_commit2/build/ql/scratchdir/hive_2010-11-05_10-12-20_273_1499950761036696704/-ext-10000
Stage: Stage-0
Move Operator
@@ -1352,7 +1340,7 @@ STAGE PLANS:
Stage: Stage-3
Map Reduce
Alias -> Map Operator Tree:
- pfile:/Users/heyongqiang/Documents/workspace/Hive-Index/build/ql/scratchdir/hive_2010-11-04_14-42-30_525_7636455345541234720/-ext-10002
+ pfile:/data/users/njain/hive_commit2/hive_commit2/build/ql/scratchdir/hive_2010-11-05_10-12-20_273_1499950761036696704/-ext-10002
File Output Operator
compressed: false
GlobalTableId: 0
@@ -1379,11 +1367,11 @@ POSTHOOK: Lineage: merge_dynamic_part PA
PREHOOK: query: select * from merge_dynamic_part
PREHOOK: type: QUERY
PREHOOK: Input: default@merge_dynamic_part@ds=2008-04-08/hr=11
-PREHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-11-04_14-42-38_970_4649719742356299109/-mr-10000
+PREHOOK: Output: file:/tmp/njain/hive_2010-11-05_10-12-30_233_7107649746810289539/-mr-10000
POSTHOOK: query: select * from merge_dynamic_part
POSTHOOK: type: QUERY
POSTHOOK: Input: default@merge_dynamic_part@ds=2008-04-08/hr=11
-POSTHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-11-04_14-42-38_970_4649719742356299109/-mr-10000
+POSTHOOK: Output: file:/tmp/njain/hive_2010-11-05_10-12-30_233_7107649746810289539/-mr-10000
POSTHOOK: Lineage: merge_dynamic_part PARTITION(ds=2008-04-08,hr=11).key SIMPLE [(srcpart_merge_dp)srcpart_merge_dp.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: merge_dynamic_part PARTITION(ds=2008-04-08,hr=11).value SIMPLE [(srcpart_merge_dp)srcpart_merge_dp.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: merge_dynamic_part PARTITION(ds=2008-04-08,hr=11).key SIMPLE [(srcpart_merge_dp)srcpart_merge_dp.FieldSchema(name:key, type:string, comment:default), ]
@@ -1902,7 +1890,7 @@ POSTHOOK: Lineage: merge_dynamic_part PA
POSTHOOK: Lineage: merge_dynamic_part PARTITION(ds=2008-04-08,hr=11).value SIMPLE [(srcpart_merge_dp)srcpart_merge_dp.FieldSchema(name:value, type:string, comment:default), ]
tableName:merge_dynamic_part
owner:null
-location:pfile:/Users/heyongqiang/Documents/workspace/Hive-Index/build/ql/test/data/warehouse/merge_dynamic_part
+location:pfile:/data/users/njain/hive_commit2/hive_commit2/build/ql/test/data/warehouse/merge_dynamic_part
inputformat:org.apache.hadoop.mapred.TextInputFormat
outputformat:org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
columns:struct columns { string key, string value}
@@ -1913,5 +1901,5 @@ totalFileSize:5812
maxFileSize:5812
minFileSize:5812
lastAccessTime:0
-lastUpdateTime:1288906956000
+lastUpdateTime:1288977147000
Modified: hive/trunk/ql/src/test/results/clientpositive/nullgroup5.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/nullgroup5.q.out?rev=1031676&r1=1031675&r2=1031676&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/nullgroup5.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/nullgroup5.q.out Fri Nov 5 17:29:28 2010
@@ -84,31 +84,27 @@ STAGE PLANS:
predicate:
expr: (ds = '2009-04-09')
type: boolean
- Filter Operator
- predicate:
- expr: (ds = '2009-04-09')
- type: boolean
- Select Operator
- expressions:
- expr: key
- type: string
- expr: value
- type: string
- outputColumnNames: _col0, _col1
- Union
- Select Operator
- expressions:
- expr: _col0
- type: string
- expr: _col1
- type: string
- outputColumnNames: _col0, _col1
- File Output Operator
- compressed: false
- GlobalTableId: 0
- table:
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ Select Operator
+ expressions:
+ expr: key
+ type: string
+ expr: value
+ type: string
+ outputColumnNames: _col0, _col1
+ Union
+ Select Operator
+ expressions:
+ expr: _col0
+ type: string
+ expr: _col1
+ type: string
+ outputColumnNames: _col0, _col1
+ File Output Operator
+ compressed: false
+ GlobalTableId: 0
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
Stage: Stage-0
Fetch Operator
@@ -123,7 +119,7 @@ PREHOOK: query: select u.* from
)u
PREHOOK: type: QUERY
PREHOOK: Input: default@tstparttbl2@ds=2009-04-09
-PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-44-39_608_1509511246265009929/10000
+PREHOOK: Output: file:/tmp/sdong/hive_2010-10-29_16-16-14_586_7548431571135694845/-mr-10000
POSTHOOK: query: select u.* from
(
select key, value from tstparttbl x where x.ds='2009-04-05'
@@ -132,7 +128,7 @@ POSTHOOK: query: select u.* from
)u
POSTHOOK: type: QUERY
POSTHOOK: Input: default@tstparttbl2@ds=2009-04-09
-POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-44-39_608_1509511246265009929/10000
+POSTHOOK: Output: file:/tmp/sdong/hive_2010-10-29_16-16-14_586_7548431571135694845/-mr-10000
238 val_238
86 val_86
311 val_311