You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by jv...@apache.org on 2011/09/03 07:36:54 UTC
svn commit: r1164804 [4/6] - in /hive/trunk:
common/src/java/org/apache/hadoop/hive/conf/ conf/
ql/src/java/org/apache/hadoop/hive/ql/optimizer/
ql/src/java/org/apache/hadoop/hive/ql/ppd/
ql/src/test/results/clientpositive/ ql/src/test/results/compiler...
Modified: hive/trunk/ql/src/test/results/clientpositive/router_join_ppr.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/router_join_ppr.q.out?rev=1164804&r1=1164803&r2=1164804&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/router_join_ppr.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/router_join_ppr.q.out Sat Sep 3 05:36:52 2011
@@ -31,20 +31,25 @@ STAGE PLANS:
TableScan
alias: a
GatherStats: false
- Reduce Output Operator
- key expressions:
- expr: key
- type: string
- sort order: +
- Map-reduce partition columns:
- expr: key
- type: string
- tag: 0
- value expressions:
- expr: key
- type: string
- expr: value
- type: string
+ Filter Operator
+ isSamplingPred: false
+ predicate:
+ expr: ((key > 15) and (key < 25))
+ type: boolean
+ Reduce Output Operator
+ key expressions:
+ expr: key
+ type: string
+ sort order: +
+ Map-reduce partition columns:
+ expr: key
+ type: string
+ tag: 0
+ value expressions:
+ expr: key
+ type: string
+ expr: value
+ type: string
b
TableScan
alias: b
@@ -72,13 +77,13 @@ STAGE PLANS:
type: string
Needs Tagging: true
Path -> Alias:
- pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src [a]
- pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11 [b]
- pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12 [b]
- pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/srcpart/ds=2008-04-09/hr=11 [b]
- pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/srcpart/ds=2008-04-09/hr=12 [b]
+ pfile:/data/users/charleschen/hive-trunk/build/ql/test/data/warehouse/src [a]
+ pfile:/data/users/charleschen/hive-trunk/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11 [b]
+ pfile:/data/users/charleschen/hive-trunk/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12 [b]
+ pfile:/data/users/charleschen/hive-trunk/build/ql/test/data/warehouse/srcpart/ds=2008-04-09/hr=11 [b]
+ pfile:/data/users/charleschen/hive-trunk/build/ql/test/data/warehouse/srcpart/ds=2008-04-09/hr=12 [b]
Path -> Partition:
- pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src
+ pfile:/data/users/charleschen/hive-trunk/build/ql/test/data/warehouse/src
Partition
base file name: src
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -89,12 +94,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/src
+ location pfile:/data/users/charleschen/hive-trunk/build/ql/test/data/warehouse/src
name default.src
serialization.ddl struct src { string key, string value}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- transient_lastDdlTime 1297378968
+ transient_lastDdlTime 1312490007
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -105,16 +110,16 @@ 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/src
+ location pfile:/data/users/charleschen/hive-trunk/build/ql/test/data/warehouse/src
name default.src
serialization.ddl struct src { string key, string value}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- transient_lastDdlTime 1297378968
+ transient_lastDdlTime 1312490007
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: default.src
name: default.src
- pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11
+ pfile:/data/users/charleschen/hive-trunk/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11
Partition
base file name: hr=11
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -128,13 +133,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/srcpart/ds=2008-04-08/hr=11
+ location pfile:/data/users/charleschen/hive-trunk/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11
name default.srcpart
partition_columns ds/hr
serialization.ddl struct srcpart { string key, string value}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- transient_lastDdlTime 1297378962
+ transient_lastDdlTime 1312490002
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -145,17 +150,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/srcpart
+ location pfile:/data/users/charleschen/hive-trunk/build/ql/test/data/warehouse/srcpart
name default.srcpart
partition_columns ds/hr
serialization.ddl struct srcpart { string key, string value}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- transient_lastDdlTime 1297378962
+ transient_lastDdlTime 1312490001
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: default.srcpart
name: default.srcpart
- pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12
+ pfile:/data/users/charleschen/hive-trunk/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12
Partition
base file name: hr=12
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -169,13 +174,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/srcpart/ds=2008-04-08/hr=12
+ location pfile:/data/users/charleschen/hive-trunk/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12
name default.srcpart
partition_columns ds/hr
serialization.ddl struct srcpart { string key, string value}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- transient_lastDdlTime 1297378962
+ transient_lastDdlTime 1312490003
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -186,17 +191,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/srcpart
+ location pfile:/data/users/charleschen/hive-trunk/build/ql/test/data/warehouse/srcpart
name default.srcpart
partition_columns ds/hr
serialization.ddl struct srcpart { string key, string value}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- transient_lastDdlTime 1297378962
+ transient_lastDdlTime 1312490001
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: default.srcpart
name: default.srcpart
- pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/srcpart/ds=2008-04-09/hr=11
+ pfile:/data/users/charleschen/hive-trunk/build/ql/test/data/warehouse/srcpart/ds=2008-04-09/hr=11
Partition
base file name: hr=11
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -210,13 +215,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/srcpart/ds=2008-04-09/hr=11
+ location pfile:/data/users/charleschen/hive-trunk/build/ql/test/data/warehouse/srcpart/ds=2008-04-09/hr=11
name default.srcpart
partition_columns ds/hr
serialization.ddl struct srcpart { string key, string value}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- transient_lastDdlTime 1297378962
+ transient_lastDdlTime 1312490003
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -227,17 +232,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/srcpart
+ location pfile:/data/users/charleschen/hive-trunk/build/ql/test/data/warehouse/srcpart
name default.srcpart
partition_columns ds/hr
serialization.ddl struct srcpart { string key, string value}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- transient_lastDdlTime 1297378962
+ transient_lastDdlTime 1312490001
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: default.srcpart
name: default.srcpart
- pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/srcpart/ds=2008-04-09/hr=12
+ pfile:/data/users/charleschen/hive-trunk/build/ql/test/data/warehouse/srcpart/ds=2008-04-09/hr=12
Partition
base file name: hr=12
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -251,13 +256,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/srcpart/ds=2008-04-09/hr=12
+ location pfile:/data/users/charleschen/hive-trunk/build/ql/test/data/warehouse/srcpart/ds=2008-04-09/hr=12
name default.srcpart
partition_columns ds/hr
serialization.ddl struct srcpart { string key, string value}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- transient_lastDdlTime 1297378962
+ transient_lastDdlTime 1312490004
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -268,13 +273,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/srcpart
+ location pfile:/data/users/charleschen/hive-trunk/build/ql/test/data/warehouse/srcpart
name default.srcpart
partition_columns ds/hr
serialization.ddl struct srcpart { string key, string value}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- transient_lastDdlTime 1297378962
+ transient_lastDdlTime 1312490001
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: default.srcpart
name: default.srcpart
@@ -309,9 +314,9 @@ STAGE PLANS:
File Output Operator
compressed: false
GlobalTableId: 0
- directory: file:/tmp/sdong/hive_2011-02-10_17-01-51_944_8007180207485477580/-ext-10001
+ directory: file:/tmp/charleschen/hive_2011-08-04_15-49-45_315_1221990596724204746/-ext-10001
NumFilesPerFileSink: 1
- Stats Publishing Key Prefix: file:/tmp/sdong/hive_2011-02-10_17-01-51_944_8007180207485477580/-ext-10001/
+ Stats Publishing Key Prefix: file:/tmp/charleschen/hive_2011-08-04_15-49-45_315_1221990596724204746/-ext-10001/
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -341,7 +346,7 @@ PREHOOK: Input: default@srcpart@ds=2008-
PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=12
PREHOOK: Input: default@srcpart@ds=2008-04-09/hr=11
PREHOOK: Input: default@srcpart@ds=2008-04-09/hr=12
-PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_17-01-52_113_3892314008195573376/-mr-10000
+PREHOOK: Output: file:/tmp/charleschen/hive_2011-08-04_15-49-45_446_6864227253125426882/-mr-10000
POSTHOOK: query: FROM
src a
RIGHT OUTER JOIN
@@ -355,7 +360,7 @@ POSTHOOK: Input: default@srcpart@ds=2008
POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=12
POSTHOOK: Input: default@srcpart@ds=2008-04-09/hr=11
POSTHOOK: Input: default@srcpart@ds=2008-04-09/hr=12
-POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_17-01-52_113_3892314008195573376/-mr-10000
+POSTHOOK: Output: file:/tmp/charleschen/hive_2011-08-04_15-49-45_446_6864227253125426882/-mr-10000
17 val_17 17 val_17
17 val_17 17 val_17
18 val_18 18 val_18
@@ -401,20 +406,25 @@ STAGE PLANS:
TableScan
alias: a
GatherStats: false
- Reduce Output Operator
- key expressions:
- expr: key
- type: string
- sort order: +
- Map-reduce partition columns:
- expr: key
- type: string
- tag: 0
- value expressions:
- expr: key
- type: string
- expr: value
- type: string
+ Filter Operator
+ isSamplingPred: false
+ predicate:
+ expr: ((key > 15) and (key < 25))
+ type: boolean
+ Reduce Output Operator
+ key expressions:
+ expr: key
+ type: string
+ sort order: +
+ Map-reduce partition columns:
+ expr: key
+ type: string
+ tag: 0
+ value expressions:
+ expr: key
+ type: string
+ expr: value
+ type: string
b
TableScan
alias: b
@@ -440,11 +450,11 @@ STAGE PLANS:
type: string
Needs Tagging: true
Path -> Alias:
- pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src [b]
- pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11 [a]
- pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12 [a]
+ pfile:/data/users/charleschen/hive-trunk/build/ql/test/data/warehouse/src [b]
+ pfile:/data/users/charleschen/hive-trunk/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11 [a]
+ pfile:/data/users/charleschen/hive-trunk/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12 [a]
Path -> Partition:
- pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src
+ pfile:/data/users/charleschen/hive-trunk/build/ql/test/data/warehouse/src
Partition
base file name: src
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -455,12 +465,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/src
+ location pfile:/data/users/charleschen/hive-trunk/build/ql/test/data/warehouse/src
name default.src
serialization.ddl struct src { string key, string value}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- transient_lastDdlTime 1297378968
+ transient_lastDdlTime 1312490007
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -471,16 +481,16 @@ 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/src
+ location pfile:/data/users/charleschen/hive-trunk/build/ql/test/data/warehouse/src
name default.src
serialization.ddl struct src { string key, string value}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- transient_lastDdlTime 1297378968
+ transient_lastDdlTime 1312490007
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: default.src
name: default.src
- pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11
+ pfile:/data/users/charleschen/hive-trunk/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11
Partition
base file name: hr=11
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -494,13 +504,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/srcpart/ds=2008-04-08/hr=11
+ location pfile:/data/users/charleschen/hive-trunk/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11
name default.srcpart
partition_columns ds/hr
serialization.ddl struct srcpart { string key, string value}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- transient_lastDdlTime 1297378962
+ transient_lastDdlTime 1312490002
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -511,17 +521,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/srcpart
+ location pfile:/data/users/charleschen/hive-trunk/build/ql/test/data/warehouse/srcpart
name default.srcpart
partition_columns ds/hr
serialization.ddl struct srcpart { string key, string value}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- transient_lastDdlTime 1297378962
+ transient_lastDdlTime 1312490001
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: default.srcpart
name: default.srcpart
- pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12
+ pfile:/data/users/charleschen/hive-trunk/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12
Partition
base file name: hr=12
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -535,13 +545,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/srcpart/ds=2008-04-08/hr=12
+ location pfile:/data/users/charleschen/hive-trunk/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12
name default.srcpart
partition_columns ds/hr
serialization.ddl struct srcpart { string key, string value}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- transient_lastDdlTime 1297378962
+ transient_lastDdlTime 1312490003
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -552,13 +562,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/srcpart
+ location pfile:/data/users/charleschen/hive-trunk/build/ql/test/data/warehouse/srcpart
name default.srcpart
partition_columns ds/hr
serialization.ddl struct srcpart { string key, string value}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- transient_lastDdlTime 1297378962
+ transient_lastDdlTime 1312490001
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: default.srcpart
name: default.srcpart
@@ -590,9 +600,9 @@ STAGE PLANS:
File Output Operator
compressed: false
GlobalTableId: 0
- directory: file:/tmp/sdong/hive_2011-02-10_17-01-56_698_3650606708384403170/-ext-10001
+ directory: file:/tmp/charleschen/hive_2011-08-04_15-49-49_414_6366150176434092424/-ext-10001
NumFilesPerFileSink: 1
- Stats Publishing Key Prefix: file:/tmp/sdong/hive_2011-02-10_17-01-56_698_3650606708384403170/-ext-10001/
+ Stats Publishing Key Prefix: file:/tmp/charleschen/hive_2011-08-04_15-49-49_414_6366150176434092424/-ext-10001/
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -620,7 +630,7 @@ PREHOOK: type: QUERY
PREHOOK: Input: default@src
PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=12
-PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_17-01-56_851_1955742945505151056/-mr-10000
+PREHOOK: Output: file:/tmp/charleschen/hive_2011-08-04_15-49-49_530_837734850983794566/-mr-10000
POSTHOOK: query: FROM
srcpart a
RIGHT OUTER JOIN
@@ -632,7 +642,7 @@ POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=12
-POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_17-01-56_851_1955742945505151056/-mr-10000
+POSTHOOK: Output: file:/tmp/charleschen/hive_2011-08-04_15-49-49_530_837734850983794566/-mr-10000
17 val_17 17 val_17
17 val_17 17 val_17
18 val_18 18 val_18
@@ -678,20 +688,25 @@ STAGE PLANS:
TableScan
alias: a
GatherStats: false
- Reduce Output Operator
- key expressions:
- expr: key
- type: string
- sort order: +
- Map-reduce partition columns:
- expr: key
- type: string
- tag: 0
- value expressions:
- expr: key
- type: string
- expr: value
- type: string
+ Filter Operator
+ isSamplingPred: false
+ predicate:
+ expr: ((key > 15) and (key < 25))
+ type: boolean
+ Reduce Output Operator
+ key expressions:
+ expr: key
+ type: string
+ sort order: +
+ Map-reduce partition columns:
+ expr: key
+ type: string
+ tag: 0
+ value expressions:
+ expr: key
+ type: string
+ expr: value
+ type: string
b
TableScan
alias: b
@@ -719,11 +734,11 @@ STAGE PLANS:
type: string
Needs Tagging: true
Path -> Alias:
- pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src [a]
- pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11 [b]
- pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12 [b]
+ pfile:/data/users/charleschen/hive-trunk/build/ql/test/data/warehouse/src [a]
+ pfile:/data/users/charleschen/hive-trunk/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11 [b]
+ pfile:/data/users/charleschen/hive-trunk/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12 [b]
Path -> Partition:
- pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src
+ pfile:/data/users/charleschen/hive-trunk/build/ql/test/data/warehouse/src
Partition
base file name: src
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -734,12 +749,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/src
+ location pfile:/data/users/charleschen/hive-trunk/build/ql/test/data/warehouse/src
name default.src
serialization.ddl struct src { string key, string value}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- transient_lastDdlTime 1297378968
+ transient_lastDdlTime 1312490007
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -750,16 +765,16 @@ 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/src
+ location pfile:/data/users/charleschen/hive-trunk/build/ql/test/data/warehouse/src
name default.src
serialization.ddl struct src { string key, string value}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- transient_lastDdlTime 1297378968
+ transient_lastDdlTime 1312490007
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: default.src
name: default.src
- pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11
+ pfile:/data/users/charleschen/hive-trunk/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11
Partition
base file name: hr=11
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -773,13 +788,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/srcpart/ds=2008-04-08/hr=11
+ location pfile:/data/users/charleschen/hive-trunk/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11
name default.srcpart
partition_columns ds/hr
serialization.ddl struct srcpart { string key, string value}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- transient_lastDdlTime 1297378962
+ transient_lastDdlTime 1312490002
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -790,17 +805,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/srcpart
+ location pfile:/data/users/charleschen/hive-trunk/build/ql/test/data/warehouse/srcpart
name default.srcpart
partition_columns ds/hr
serialization.ddl struct srcpart { string key, string value}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- transient_lastDdlTime 1297378962
+ transient_lastDdlTime 1312490001
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: default.srcpart
name: default.srcpart
- pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12
+ pfile:/data/users/charleschen/hive-trunk/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12
Partition
base file name: hr=12
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -814,13 +829,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/srcpart/ds=2008-04-08/hr=12
+ location pfile:/data/users/charleschen/hive-trunk/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12
name default.srcpart
partition_columns ds/hr
serialization.ddl struct srcpart { string key, string value}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- transient_lastDdlTime 1297378962
+ transient_lastDdlTime 1312490003
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -831,13 +846,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/srcpart
+ location pfile:/data/users/charleschen/hive-trunk/build/ql/test/data/warehouse/srcpart
name default.srcpart
partition_columns ds/hr
serialization.ddl struct srcpart { string key, string value}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- transient_lastDdlTime 1297378962
+ transient_lastDdlTime 1312490001
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: default.srcpart
name: default.srcpart
@@ -869,9 +884,9 @@ STAGE PLANS:
File Output Operator
compressed: false
GlobalTableId: 0
- directory: file:/tmp/sdong/hive_2011-02-10_17-02-00_948_2573378846116151448/-ext-10001
+ directory: file:/tmp/charleschen/hive_2011-08-04_15-49-53_225_5814759782076240610/-ext-10001
NumFilesPerFileSink: 1
- Stats Publishing Key Prefix: file:/tmp/sdong/hive_2011-02-10_17-02-00_948_2573378846116151448/-ext-10001/
+ Stats Publishing Key Prefix: file:/tmp/charleschen/hive_2011-08-04_15-49-53_225_5814759782076240610/-ext-10001/
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -899,7 +914,7 @@ PREHOOK: type: QUERY
PREHOOK: Input: default@src
PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=12
-PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_17-02-01_089_7899465838633645287/-mr-10000
+PREHOOK: Output: file:/tmp/charleschen/hive_2011-08-04_15-49-53_356_3808971112123446142/-mr-10000
POSTHOOK: query: FROM
src a
RIGHT OUTER JOIN
@@ -911,7 +926,7 @@ POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=12
-POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_17-02-01_089_7899465838633645287/-mr-10000
+POSTHOOK: Output: file:/tmp/charleschen/hive_2011-08-04_15-49-53_356_3808971112123446142/-mr-10000
17 val_17 17 val_17
17 val_17 17 val_17
18 val_18 18 val_18
@@ -957,22 +972,27 @@ STAGE PLANS:
TableScan
alias: a
GatherStats: false
- Reduce Output Operator
- key expressions:
- expr: key
- type: string
- sort order: +
- Map-reduce partition columns:
- expr: key
- type: string
- tag: 0
- value expressions:
- expr: key
- type: string
- expr: value
- type: string
- expr: ds
- type: string
+ Filter Operator
+ isSamplingPred: false
+ predicate:
+ expr: ((key > 15) and (key < 25))
+ type: boolean
+ Reduce Output Operator
+ key expressions:
+ expr: key
+ type: string
+ sort order: +
+ Map-reduce partition columns:
+ expr: key
+ type: string
+ tag: 0
+ value expressions:
+ expr: key
+ type: string
+ expr: value
+ type: string
+ expr: ds
+ type: string
b
TableScan
alias: b
@@ -998,13 +1018,13 @@ STAGE PLANS:
type: string
Needs Tagging: true
Path -> Alias:
- pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src [b]
- pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11 [a]
- pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12 [a]
- pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/srcpart/ds=2008-04-09/hr=11 [a]
- pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/srcpart/ds=2008-04-09/hr=12 [a]
+ pfile:/data/users/charleschen/hive-trunk/build/ql/test/data/warehouse/src [b]
+ pfile:/data/users/charleschen/hive-trunk/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11 [a]
+ pfile:/data/users/charleschen/hive-trunk/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12 [a]
+ pfile:/data/users/charleschen/hive-trunk/build/ql/test/data/warehouse/srcpart/ds=2008-04-09/hr=11 [a]
+ pfile:/data/users/charleschen/hive-trunk/build/ql/test/data/warehouse/srcpart/ds=2008-04-09/hr=12 [a]
Path -> Partition:
- pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src
+ pfile:/data/users/charleschen/hive-trunk/build/ql/test/data/warehouse/src
Partition
base file name: src
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -1015,12 +1035,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/src
+ location pfile:/data/users/charleschen/hive-trunk/build/ql/test/data/warehouse/src
name default.src
serialization.ddl struct src { string key, string value}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- transient_lastDdlTime 1297378968
+ transient_lastDdlTime 1312490007
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -1031,16 +1051,16 @@ 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/src
+ location pfile:/data/users/charleschen/hive-trunk/build/ql/test/data/warehouse/src
name default.src
serialization.ddl struct src { string key, string value}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- transient_lastDdlTime 1297378968
+ transient_lastDdlTime 1312490007
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: default.src
name: default.src
- pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11
+ pfile:/data/users/charleschen/hive-trunk/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11
Partition
base file name: hr=11
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -1054,13 +1074,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/srcpart/ds=2008-04-08/hr=11
+ location pfile:/data/users/charleschen/hive-trunk/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11
name default.srcpart
partition_columns ds/hr
serialization.ddl struct srcpart { string key, string value}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- transient_lastDdlTime 1297378962
+ transient_lastDdlTime 1312490002
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -1071,17 +1091,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/srcpart
+ location pfile:/data/users/charleschen/hive-trunk/build/ql/test/data/warehouse/srcpart
name default.srcpart
partition_columns ds/hr
serialization.ddl struct srcpart { string key, string value}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- transient_lastDdlTime 1297378962
+ transient_lastDdlTime 1312490001
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: default.srcpart
name: default.srcpart
- pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12
+ pfile:/data/users/charleschen/hive-trunk/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12
Partition
base file name: hr=12
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -1095,13 +1115,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/srcpart/ds=2008-04-08/hr=12
+ location pfile:/data/users/charleschen/hive-trunk/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12
name default.srcpart
partition_columns ds/hr
serialization.ddl struct srcpart { string key, string value}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- transient_lastDdlTime 1297378962
+ transient_lastDdlTime 1312490003
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -1112,17 +1132,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/srcpart
+ location pfile:/data/users/charleschen/hive-trunk/build/ql/test/data/warehouse/srcpart
name default.srcpart
partition_columns ds/hr
serialization.ddl struct srcpart { string key, string value}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- transient_lastDdlTime 1297378962
+ transient_lastDdlTime 1312490001
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: default.srcpart
name: default.srcpart
- pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/srcpart/ds=2008-04-09/hr=11
+ pfile:/data/users/charleschen/hive-trunk/build/ql/test/data/warehouse/srcpart/ds=2008-04-09/hr=11
Partition
base file name: hr=11
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -1136,13 +1156,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/srcpart/ds=2008-04-09/hr=11
+ location pfile:/data/users/charleschen/hive-trunk/build/ql/test/data/warehouse/srcpart/ds=2008-04-09/hr=11
name default.srcpart
partition_columns ds/hr
serialization.ddl struct srcpart { string key, string value}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- transient_lastDdlTime 1297378962
+ transient_lastDdlTime 1312490003
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -1153,17 +1173,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/srcpart
+ location pfile:/data/users/charleschen/hive-trunk/build/ql/test/data/warehouse/srcpart
name default.srcpart
partition_columns ds/hr
serialization.ddl struct srcpart { string key, string value}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- transient_lastDdlTime 1297378962
+ transient_lastDdlTime 1312490001
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: default.srcpart
name: default.srcpart
- pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/srcpart/ds=2008-04-09/hr=12
+ pfile:/data/users/charleschen/hive-trunk/build/ql/test/data/warehouse/srcpart/ds=2008-04-09/hr=12
Partition
base file name: hr=12
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -1177,13 +1197,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/srcpart/ds=2008-04-09/hr=12
+ location pfile:/data/users/charleschen/hive-trunk/build/ql/test/data/warehouse/srcpart/ds=2008-04-09/hr=12
name default.srcpart
partition_columns ds/hr
serialization.ddl struct srcpart { string key, string value}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- transient_lastDdlTime 1297378962
+ transient_lastDdlTime 1312490004
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -1194,13 +1214,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/srcpart
+ location pfile:/data/users/charleschen/hive-trunk/build/ql/test/data/warehouse/srcpart
name default.srcpart
partition_columns ds/hr
serialization.ddl struct srcpart { string key, string value}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- transient_lastDdlTime 1297378962
+ transient_lastDdlTime 1312490001
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: default.srcpart
name: default.srcpart
@@ -1232,9 +1252,9 @@ STAGE PLANS:
File Output Operator
compressed: false
GlobalTableId: 0
- directory: file:/tmp/sdong/hive_2011-02-10_17-02-05_196_2971739775305015185/-ext-10001
+ directory: file:/tmp/charleschen/hive_2011-08-04_15-49-57_047_5178153527613849897/-ext-10001
NumFilesPerFileSink: 1
- Stats Publishing Key Prefix: file:/tmp/sdong/hive_2011-02-10_17-02-05_196_2971739775305015185/-ext-10001/
+ Stats Publishing Key Prefix: file:/tmp/charleschen/hive_2011-08-04_15-49-57_047_5178153527613849897/-ext-10001/
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -1264,7 +1284,7 @@ PREHOOK: Input: default@srcpart@ds=2008-
PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=12
PREHOOK: Input: default@srcpart@ds=2008-04-09/hr=11
PREHOOK: Input: default@srcpart@ds=2008-04-09/hr=12
-PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_17-02-05_351_3959616875574140681/-mr-10000
+PREHOOK: Output: file:/tmp/charleschen/hive_2011-08-04_15-49-57_168_4844713070381327545/-mr-10000
POSTHOOK: query: FROM
srcpart a
RIGHT OUTER JOIN
@@ -1278,7 +1298,7 @@ POSTHOOK: Input: default@srcpart@ds=2008
POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=12
POSTHOOK: Input: default@srcpart@ds=2008-04-09/hr=11
POSTHOOK: Input: default@srcpart@ds=2008-04-09/hr=12
-POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_17-02-05_351_3959616875574140681/-mr-10000
+POSTHOOK: Output: file:/tmp/charleschen/hive_2011-08-04_15-49-57_168_4844713070381327545/-mr-10000
17 val_17 17 val_17
17 val_17 17 val_17
18 val_18 18 val_18
Modified: hive/trunk/ql/src/test/results/clientpositive/smb_mapjoin9.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/smb_mapjoin9.q.out?rev=1164804&r1=1164803&r2=1164804&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/smb_mapjoin9.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/smb_mapjoin9.q.out Sat Sep 3 05:36:52 2011
@@ -63,54 +63,58 @@ STAGE PLANS:
a
TableScan
alias: a
- Sorted Merge Bucket Map Join Operator
- condition map:
- Inner Join 0 to 1
- condition expressions:
- 0 {key} {ds}
- 1 {key} {value} {ds}
- handleSkewJoin: false
- keys:
- 0 [Column[key]]
- 1 [Column[key]]
- outputColumnNames: _col0, _col2, _col5, _col6, _col7
- Position of Big Table: 0
- Select Operator
- expressions:
- expr: _col0
- type: int
- expr: _col2
- type: string
- expr: _col5
- type: int
- expr: _col6
- type: string
- expr: _col7
- type: string
+ Filter Operator
+ predicate:
+ expr: key is not null
+ type: boolean
+ Sorted Merge Bucket Map Join Operator
+ condition map:
+ Inner Join 0 to 1
+ condition expressions:
+ 0 {key} {ds}
+ 1 {key} {value} {ds}
+ handleSkewJoin: false
+ keys:
+ 0 [Column[key]]
+ 1 [Column[key]]
outputColumnNames: _col0, _col2, _col5, _col6, _col7
+ Position of Big Table: 0
Select Operator
expressions:
+ expr: _col0
+ type: int
+ expr: _col2
+ type: string
expr: _col5
type: int
expr: _col6
type: string
expr: _col7
type: string
- expr: _col0
- type: int
- 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
+ outputColumnNames: _col0, _col2, _col5, _col6, _col7
+ Select Operator
+ expressions:
+ expr: _col5
+ type: int
+ expr: _col6
+ type: string
+ expr: _col7
+ type: string
+ expr: _col0
+ type: int
+ 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
Stage: Stage-0
Move Operator
files:
hdfs directory: true
- destination: pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/smb_mapjoin9_results
+ destination: pfile:/data/users/charleschen/hive-trunk/build/ql/test/data/warehouse/smb_mapjoin9_results
Stage: Stage-3
Create Table Operator:
Modified: hive/trunk/ql/src/test/results/clientpositive/smb_mapjoin_6.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/smb_mapjoin_6.q.out?rev=1164804&r1=1164803&r2=1164804&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/smb_mapjoin_6.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/smb_mapjoin_6.q.out Sat Sep 3 05:36:52 2011
@@ -2611,29 +2611,22 @@ STAGE PLANS:
b
TableScan
alias: b
- Sorted Merge Bucket Map Join Operator
- condition map:
- Inner Join 0 to 1
- condition expressions:
- 0 {key} {value}
- 1 {key} {value}
- handleSkewJoin: false
- keys:
- 0 [Column[key]]
- 1 [Column[key]]
- outputColumnNames: _col0, _col1, _col4, _col5
- Position of Big Table: 1
- Select Operator
- expressions:
- expr: _col0
- type: int
- expr: _col1
- type: string
- expr: _col4
- type: int
- expr: _col5
- type: string
+ Filter Operator
+ predicate:
+ expr: (key > 1000)
+ type: boolean
+ Sorted Merge Bucket Map Join Operator
+ condition map:
+ Inner Join 0 to 1
+ condition expressions:
+ 0 {key} {value}
+ 1 {key} {value}
+ handleSkewJoin: false
+ keys:
+ 0 [Column[key]]
+ 1 [Column[key]]
outputColumnNames: _col0, _col1, _col4, _col5
+ Position of Big Table: 1
Select Operator
expressions:
expr: _col0
@@ -2644,15 +2637,26 @@ STAGE PLANS:
type: int
expr: _col5
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: default.smb_join_results
+ outputColumnNames: _col0, _col1, _col4, _col5
+ Select Operator
+ expressions:
+ expr: _col0
+ type: int
+ expr: _col1
+ type: string
+ expr: _col4
+ type: int
+ expr: _col5
+ 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: default.smb_join_results
Stage: Stage-0
Move Operator
Modified: hive/trunk/ql/src/test/results/clientpositive/udf_named_struct.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/udf_named_struct.q.out?rev=1164804&r1=1164803&r2=1164804&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/udf_named_struct.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/udf_named_struct.q.out Sat Sep 3 05:36:52 2011
@@ -54,10 +54,10 @@ PREHOOK: query: SELECT named_struct("foo
named_struct("foo", 1, "bar", 2).foo FROM src LIMIT 1
PREHOOK: type: QUERY
PREHOOK: Input: default@src
-PREHOOK: Output: file:/var/folders/C4/C40caRNsEM4C4yVangruonVUe7Y/-Tmp-/jonchang/hive_2011-08-11_01-02-24_658_503462155153078291/-mr-10000
+PREHOOK: Output: file:/tmp/charleschen/hive_2011-08-17_22-16-07_735_3705561327372616732/-mr-10000
POSTHOOK: query: SELECT named_struct("foo", 1, "bar", 2),
named_struct("foo", 1, "bar", 2).foo FROM src LIMIT 1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
-POSTHOOK: Output: file:/var/folders/C4/C40caRNsEM4C4yVangruonVUe7Y/-Tmp-/jonchang/hive_2011-08-11_01-02-24_658_503462155153078291/-mr-10000
+POSTHOOK: Output: file:/tmp/charleschen/hive_2011-08-17_22-16-07_735_3705561327372616732/-mr-10000
{"foo":1,"bar":2} 1
Modified: hive/trunk/ql/src/test/results/clientpositive/union22.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/union22.q.out?rev=1164804&r1=1164803&r2=1164804&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/union22.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/union22.q.out Sat Sep 3 05:36:52 2011
@@ -103,7 +103,7 @@ STAGE PLANS:
Filter Operator
isSamplingPred: false
predicate:
- expr: (k0 > 50)
+ expr: ((k0 > 50) and (k1 > 20))
type: boolean
Select Operator
expressions:
@@ -157,7 +157,7 @@ STAGE PLANS:
File Output Operator
compressed: false
GlobalTableId: 0
- directory: file:/tmp/tomasz/hive_2011-06-01_21-10-51_082_6975609978266062150/-mr-10002
+ directory: file:/tmp/charleschen/hive_2011-08-04_16-37-43_403_2940585090717921602/-mr-10002
NumFilesPerFileSink: 1
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
@@ -173,9 +173,9 @@ STAGE PLANS:
Map Reduce Local Work
Needs Tagging: false
Path -> Alias:
- pfile:/data/users/tomasz/apache-hive/build/ql/test/data/warehouse/dst_union22/ds=1 [null-subquery2:subq-subquery2:a]
+ pfile:/data/users/charleschen/hive-trunk/build/ql/test/data/warehouse/dst_union22/ds=1 [null-subquery2:subq-subquery2:a]
Path -> Partition:
- pfile:/data/users/tomasz/apache-hive/build/ql/test/data/warehouse/dst_union22/ds=1
+ pfile:/data/users/charleschen/hive-trunk/build/ql/test/data/warehouse/dst_union22/ds=1
Partition
base file name: ds=1
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -188,7 +188,7 @@ STAGE PLANS:
columns.types string:string:string:string
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location pfile:/data/users/tomasz/apache-hive/build/ql/test/data/warehouse/dst_union22/ds=1
+ location pfile:/data/users/charleschen/hive-trunk/build/ql/test/data/warehouse/dst_union22/ds=1
name default.dst_union22
numFiles 1
numPartitions 1
@@ -199,7 +199,7 @@ STAGE PLANS:
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
totalSize 11624
- transient_lastDdlTime 1306987846
+ transient_lastDdlTime 1312501059
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -210,7 +210,7 @@ STAGE PLANS:
columns.types string:string:string:string
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location pfile:/data/users/tomasz/apache-hive/build/ql/test/data/warehouse/dst_union22
+ location pfile:/data/users/charleschen/hive-trunk/build/ql/test/data/warehouse/dst_union22
name default.dst_union22
numFiles 1
numPartitions 1
@@ -221,7 +221,7 @@ STAGE PLANS:
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
totalSize 11624
- transient_lastDdlTime 1306987846
+ transient_lastDdlTime 1312501059
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: default.dst_union22
name: default.dst_union22
@@ -229,7 +229,7 @@ STAGE PLANS:
Stage: Stage-3
Map Reduce
Alias -> Map Operator Tree:
- file:/tmp/tomasz/hive_2011-06-01_21-10-51_082_6975609978266062150/-mr-10002
+ file:/tmp/charleschen/hive_2011-08-04_16-37-43_403_2940585090717921602/-mr-10002
Select Operator
expressions:
expr: _col0
@@ -267,10 +267,10 @@ STAGE PLANS:
File Output Operator
compressed: false
GlobalTableId: 1
- directory: pfile:/home/amarsri/workspace/hive/build/ql/scratchdir/hive_2011-07-11_03-36-05_942_4742399607666706050/-ext-10000
+ directory: pfile:/data/users/charleschen/hive-trunk/build/ql/scratchdir/hive_2011-08-04_16-37-43_403_2940585090717921602/-ext-10000
NumFilesPerFileSink: 1
Static Partition Specification: ds=2/
- Stats Publishing Key Prefix: pfile:/home/amarsri/workspace/hive/build/ql/scratchdir/hive_2011-07-11_03-36-05_942_4742399607666706050/-ext-10000/
+ Stats Publishing Key Prefix: pfile:/data/users/charleschen/hive-trunk/build/ql/scratchdir/hive_2011-08-04_16-37-43_403_2940585090717921602/-ext-10000/
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -280,7 +280,7 @@ STAGE PLANS:
columns.types string:string:string:string
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/dst_union22
+ location pfile:/data/users/charleschen/hive-trunk/build/ql/test/data/warehouse/dst_union22
name default.dst_union22
numFiles 1
numPartitions 1
@@ -291,7 +291,7 @@ STAGE PLANS:
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
totalSize 11624
- transient_lastDdlTime 1310380562
+ transient_lastDdlTime 1312501059
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: default.dst_union22
TotalFiles: 1
@@ -332,10 +332,10 @@ STAGE PLANS:
File Output Operator
compressed: false
GlobalTableId: 1
- directory: pfile:/data/users/tomasz/apache-hive/build/ql/scratchdir/hive_2011-06-01_21-10-51_082_6975609978266062150/-ext-10000
+ directory: pfile:/data/users/charleschen/hive-trunk/build/ql/scratchdir/hive_2011-08-04_16-37-43_403_2940585090717921602/-ext-10000
NumFilesPerFileSink: 1
Static Partition Specification: ds=2/
- Stats Publishing Key Prefix: pfile:/data/users/tomasz/apache-hive/build/ql/scratchdir/hive_2011-06-01_21-10-51_082_6975609978266062150/-ext-10000/
+ Stats Publishing Key Prefix: pfile:/data/users/charleschen/hive-trunk/build/ql/scratchdir/hive_2011-08-04_16-37-43_403_2940585090717921602/-ext-10000/
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -345,7 +345,7 @@ STAGE PLANS:
columns.types string:string:string:string
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location pfile:/data/users/tomasz/apache-hive/build/ql/test/data/warehouse/dst_union22
+ location pfile:/data/users/charleschen/hive-trunk/build/ql/test/data/warehouse/dst_union22
name default.dst_union22
numFiles 1
numPartitions 1
@@ -356,7 +356,7 @@ STAGE PLANS:
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
totalSize 11624
- transient_lastDdlTime 1306987846
+ transient_lastDdlTime 1312501059
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: default.dst_union22
TotalFiles: 1
@@ -364,10 +364,10 @@ STAGE PLANS:
MultiFileSpray: false
Needs Tagging: false
Path -> Alias:
- file:/tmp/tomasz/hive_2011-06-01_21-10-51_082_6975609978266062150/-mr-10002 [file:/tmp/tomasz/hive_2011-06-01_21-10-51_082_6975609978266062150/-mr-10002]
- pfile:/data/users/tomasz/apache-hive/build/ql/test/data/warehouse/dst_union22_delta/ds=1 [null-subquery1:subq-subquery1:dst_union22_delta]
+ file:/tmp/charleschen/hive_2011-08-04_16-37-43_403_2940585090717921602/-mr-10002 [file:/tmp/charleschen/hive_2011-08-04_16-37-43_403_2940585090717921602/-mr-10002]
+ pfile:/data/users/charleschen/hive-trunk/build/ql/test/data/warehouse/dst_union22_delta/ds=1 [null-subquery1:subq-subquery1:dst_union22_delta]
Path -> Partition:
- file:/tmp/tomasz/hive_2011-06-01_21-10-51_082_6975609978266062150/-mr-10002
+ file:/tmp/charleschen/hive_2011-08-04_16-37-43_403_2940585090717921602/-mr-10002
Partition
base file name: -mr-10002
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
@@ -383,7 +383,7 @@ STAGE PLANS:
columns _col0,_col1,_col10,_col11
columns.types string,string,string,string
escape.delim \
- pfile:/data/users/tomasz/apache-hive/build/ql/test/data/warehouse/dst_union22_delta/ds=1
+ pfile:/data/users/charleschen/hive-trunk/build/ql/test/data/warehouse/dst_union22_delta/ds=1
Partition
base file name: ds=1
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -396,7 +396,7 @@ STAGE PLANS:
columns.types string:string:string:string:string:string
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location pfile:/data/users/tomasz/apache-hive/build/ql/test/data/warehouse/dst_union22_delta/ds=1
+ location pfile:/data/users/charleschen/hive-trunk/build/ql/test/data/warehouse/dst_union22_delta/ds=1
name default.dst_union22_delta
numFiles 1
numPartitions 1
@@ -407,7 +407,7 @@ STAGE PLANS:
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
totalSize 17436
- transient_lastDdlTime 1306987850
+ transient_lastDdlTime 1312501063
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -418,7 +418,7 @@ STAGE PLANS:
columns.types string:string:string:string:string:string
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location pfile:/data/users/tomasz/apache-hive/build/ql/test/data/warehouse/dst_union22_delta
+ location pfile:/data/users/charleschen/hive-trunk/build/ql/test/data/warehouse/dst_union22_delta
name default.dst_union22_delta
numFiles 1
numPartitions 1
@@ -429,7 +429,7 @@ STAGE PLANS:
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
totalSize 17436
- transient_lastDdlTime 1306987851
+ transient_lastDdlTime 1312501063
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: default.dst_union22_delta
name: default.dst_union22_delta
@@ -440,7 +440,7 @@ STAGE PLANS:
partition:
ds 2
replace: true
- source: pfile:/data/users/tomasz/apache-hive/build/ql/scratchdir/hive_2011-06-01_21-10-51_082_6975609978266062150/-ext-10000
+ source: pfile:/data/users/charleschen/hive-trunk/build/ql/scratchdir/hive_2011-08-04_16-37-43_403_2940585090717921602/-ext-10000
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -450,7 +450,7 @@ STAGE PLANS:
columns.types string:string:string:string
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location pfile:/data/users/tomasz/apache-hive/build/ql/test/data/warehouse/dst_union22
+ location pfile:/data/users/charleschen/hive-trunk/build/ql/test/data/warehouse/dst_union22
name default.dst_union22
numFiles 1
numPartitions 1
@@ -461,14 +461,14 @@ STAGE PLANS:
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
totalSize 11624
- transient_lastDdlTime 1306987846
+ transient_lastDdlTime 1312501059
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: default.dst_union22
- tmp directory: pfile:/data/users/tomasz/apache-hive/build/ql/scratchdir/hive_2011-06-01_21-10-51_082_6975609978266062150/-ext-10001
+ tmp directory: pfile:/data/users/charleschen/hive-trunk/build/ql/scratchdir/hive_2011-08-04_16-37-43_403_2940585090717921602/-ext-10001
Stage: Stage-4
Stats-Aggr Operator
- Stats Aggregation Key Prefix: pfile:/data/users/tomasz/apache-hive/build/ql/scratchdir/hive_2011-06-01_21-10-51_082_6975609978266062150/-ext-10000/
+ Stats Aggregation Key Prefix: pfile:/data/users/charleschen/hive-trunk/build/ql/scratchdir/hive_2011-08-04_16-37-43_403_2940585090717921602/-ext-10000/
PREHOOK: query: insert overwrite table dst_union22 partition (ds='2')
@@ -518,11 +518,11 @@ POSTHOOK: Lineage: dst_union22_delta PAR
PREHOOK: query: select * from dst_union22 where ds = '2' order by k1, k2, k3, k4
PREHOOK: type: QUERY
PREHOOK: Input: default@dst_union22@ds=2
-PREHOOK: Output: file:/tmp/tomasz/hive_2011-06-01_21-11-00_529_7757406641359320404/-mr-10000
+PREHOOK: Output: file:/tmp/charleschen/hive_2011-08-04_16-37-52_911_2656054527092967946/-mr-10000
POSTHOOK: query: select * from dst_union22 where ds = '2' order by k1, k2, k3, k4
POSTHOOK: type: QUERY
POSTHOOK: Input: default@dst_union22@ds=2
-POSTHOOK: Output: file:/tmp/tomasz/hive_2011-06-01_21-11-00_529_7757406641359320404/-mr-10000
+POSTHOOK: Output: file:/tmp/charleschen/hive_2011-08-04_16-37-52_911_2656054527092967946/-mr-10000
POSTHOOK: Lineage: dst_union22 PARTITION(ds=1).k1 SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: dst_union22 PARTITION(ds=1).k2 SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: dst_union22 PARTITION(ds=1).k3 SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
Modified: hive/trunk/ql/src/test/results/compiler/plan/join1.q.xml
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/compiler/plan/join1.q.xml?rev=1164804&r1=1164803&r2=1164804&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/compiler/plan/join1.q.xml (original)
+++ hive/trunk/ql/src/test/results/compiler/plan/join1.q.xml Sat Sep 3 05:36:52 2011
@@ -1,5 +1,5 @@
<?xml version="1.0" encoding="UTF-8"?>
-<java version="1.6.0_07" class="java.beans.XMLDecoder">
+<java version="1.6.0_22" class="java.beans.XMLDecoder">
<object id="MapRedTask0" class="org.apache.hadoop.hive.ql.exec.MapRedTask">
<void property="childTasks">
<object class="java.util.ArrayList">
@@ -22,7 +22,7 @@
<void property="work">
<object class="org.apache.hadoop.hive.ql.plan.StatsWork">
<void property="aggKey">
- <string>pfile:/data/users/sdong/www/open-source-hive1/build/ql/scratchdir/hive_2011-04-28_23-56-01_985_2735813683400211590/-ext-10000/</string>
+ <string>pfile:/data/users/charleschen/hive-trunk/build/ql/scratchdir/hive_2011-08-04_17-13-31_618_4947074952405203802/-ext-10000/</string>
</void>
</object>
</void>
@@ -58,7 +58,7 @@
<boolean>true</boolean>
</void>
<void property="sourceDir">
- <string>pfile:/data/users/sdong/www/open-source-hive1/build/ql/scratchdir/hive_2011-04-28_23-56-01_985_2735813683400211590/-ext-10000</string>
+ <string>pfile:/data/users/charleschen/hive-trunk/build/ql/scratchdir/hive_2011-08-04_17-13-31_618_4947074952405203802/-ext-10000</string>
</void>
<void property="table">
<object id="TableDesc0" class="org.apache.hadoop.hive.ql.plan.TableDesc">
@@ -111,11 +111,11 @@
</void>
<void method="put">
<string>location</string>
- <string>pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/dest1</string>
+ <string>pfile:/data/users/charleschen/hive-trunk/build/ql/test/data/warehouse/dest1</string>
</void>
<void method="put">
<string>transient_lastDdlTime</string>
- <string>1304060161</string>
+ <string>1312503211</string>
</void>
</object>
</void>
@@ -125,7 +125,7 @@
</object>
</void>
<void property="tmpDir">
- <string>pfile:/data/users/sdong/www/open-source-hive1/build/ql/scratchdir/hive_2011-04-28_23-56-01_985_2735813683400211590/-ext-10001</string>
+ <string>pfile:/data/users/charleschen/hive-trunk/build/ql/scratchdir/hive_2011-08-04_17-13-31_618_4947074952405203802/-ext-10001</string>
</void>
</object>
</void>
@@ -196,11 +196,11 @@
</void>
<void method="put">
<string>location</string>
- <string>pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src</string>
+ <string>pfile:/data/users/charleschen/hive-trunk/build/ql/test/data/warehouse/src</string>
</void>
<void method="put">
<string>transient_lastDdlTime</string>
- <string>1304060159</string>
+ <string>1312503209</string>
</void>
</object>
</void>
@@ -258,11 +258,11 @@
</void>
<void method="put">
<string>location</string>
- <string>pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src</string>
+ <string>pfile:/data/users/charleschen/hive-trunk/build/ql/test/data/warehouse/src</string>
</void>
<void method="put">
<string>transient_lastDdlTime</string>
- <string>1304060159</string>
+ <string>1312503209</string>
</void>
</object>
</void>
@@ -328,11 +328,11 @@
</void>
<void method="put">
<string>location</string>
- <string>pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src</string>
+ <string>pfile:/data/users/charleschen/hive-trunk/build/ql/test/data/warehouse/src</string>
</void>
<void method="put">
<string>transient_lastDdlTime</string>
- <string>1304060159</string>
+ <string>1312503209</string>
</void>
</object>
</void>
@@ -390,11 +390,11 @@
</void>
<void method="put">
<string>location</string>
- <string>pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src</string>
+ <string>pfile:/data/users/charleschen/hive-trunk/build/ql/test/data/warehouse/src</string>
</void>
<void method="put">
<string>transient_lastDdlTime</string>
- <string>1304060159</string>
+ <string>1312503209</string>
</void>
</object>
</void>
@@ -435,6 +435,20 @@
</void>
</object>
</void>
+ <void method="put">
+ <string>VALUE._col0</string>
+ <object class="org.apache.hadoop.hive.ql.plan.ExprNodeColumnDesc">
+ <void property="column">
+ <string>key</string>
+ </void>
+ <void property="tabAlias">
+ <string>src2</string>
+ </void>
+ <void property="typeInfo">
+ <object idref="PrimitiveTypeInfo0"/>
+ </void>
+ </object>
+ </void>
</object>
</void>
<void property="conf">
@@ -1026,7 +1040,7 @@
<void property="pathToAliases">
<object class="java.util.LinkedHashMap">
<void method="put">
- <string>pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src</string>
+ <string>pfile:/data/users/charleschen/hive-trunk/build/ql/test/data/warehouse/src</string>
<object class="java.util.ArrayList">
<void method="add">
<string>src2</string>
@@ -1041,7 +1055,7 @@
<void property="pathToPartitionInfo">
<object class="java.util.LinkedHashMap">
<void method="put">
- <string>pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src</string>
+ <string>pfile:/data/users/charleschen/hive-trunk/build/ql/test/data/warehouse/src</string>
<object class="org.apache.hadoop.hive.ql.plan.PartitionDesc">
<void property="baseFileName">
<string>src</string>
@@ -1098,11 +1112,11 @@
</void>
<void method="put">
<string>location</string>
- <string>pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src</string>
+ <string>pfile:/data/users/charleschen/hive-trunk/build/ql/test/data/warehouse/src</string>
</void>
<void method="put">
<string>transient_lastDdlTime</string>
- <string>1304060159</string>
+ <string>1312503209</string>
</void>
</object>
</void>
@@ -1160,11 +1174,11 @@
</void>
<void method="put">
<string>location</string>
- <string>pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src</string>
+ <string>pfile:/data/users/charleschen/hive-trunk/build/ql/test/data/warehouse/src</string>
</void>
<void method="put">
<string>transient_lastDdlTime</string>
- <string>1304060159</string>
+ <string>1312503209</string>
</void>
</object>
</void>
@@ -1193,7 +1207,7 @@
<int>1</int>
</void>
<void property="dirName">
- <string>pfile:/data/users/sdong/www/open-source-hive1/build/ql/scratchdir/hive_2011-04-28_23-56-01_985_2735813683400211590/-ext-10000</string>
+ <string>pfile:/data/users/charleschen/hive-trunk/build/ql/scratchdir/hive_2011-08-04_17-13-31_618_4947074952405203802/-ext-10000</string>
</void>
<void property="gatherStats">
<boolean>true</boolean>
@@ -1202,7 +1216,7 @@
<int>1</int>
</void>
<void property="statsAggPrefix">
- <string>pfile:/data/users/sdong/www/open-source-hive1/build/ql/scratchdir/hive_2011-04-28_23-56-01_985_2735813683400211590/-ext-10000/</string>
+ <string>pfile:/data/users/charleschen/hive-trunk/build/ql/scratchdir/hive_2011-08-04_17-13-31_618_4947074952405203802/-ext-10000/</string>
</void>
<void property="tableInfo">
<object idref="TableDesc0"/>