You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by zs...@apache.org on 2009/06/24 06:05:05 UTC
svn commit: r787898 [3/19] - in /hadoop/hive/trunk: ./ conf/
ql/src/java/org/apache/hadoop/hive/ql/ppd/
ql/src/test/results/clientpositive/ ql/src/test/results/compiler/plan/
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/join26.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/join26.q.out?rev=787898&r1=787897&r2=787898&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/join26.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/join26.q.out Wed Jun 24 04:05:02 2009
@@ -20,35 +20,39 @@
z
Filter Operator
predicate:
- expr: (ds = '2008-04-08')
+ expr: ((ds = '2008-04-08') and (UDFToDouble(hr) = UDFToDouble(11)))
type: boolean
Filter Operator
predicate:
- expr: (UDFToDouble(hr) = UDFToDouble(11))
+ expr: (ds = '2008-04-08')
type: boolean
- Common Join Operator
- condition map:
- Inner Join 0 to 1
- Inner Join 0 to 2
- condition expressions:
- 0 {key} {value}
- 1 {key} {value}
- 2 {key} {value} {ds} {hr}
- keys:
- 0
- 1
- 2
- Position of Big Table: 2
- File Output Operator
- compressed: false
- GlobalTableId: 0
- directory: file:/data/users/njain/hive4/hive4/build/ql/tmp/357616883/10002
- table:
- input format: org.apache.hadoop.mapred.SequenceFileInputFormat
- output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
- properties:
- columns _col0,_col1,_col2,_col3,_col4,_col5,_col6,_col7
- columns.types string,string,string,string,string,string,string,string
+ Filter Operator
+ predicate:
+ expr: (UDFToDouble(hr) = UDFToDouble(11))
+ type: boolean
+ Common Join Operator
+ condition map:
+ Inner Join 0 to 1
+ Inner Join 0 to 2
+ condition expressions:
+ 0 {key} {value}
+ 1 {key} {value}
+ 2 {key} {value} {ds} {hr}
+ keys:
+ 0
+ 1
+ 2
+ Position of Big Table: 2
+ File Output Operator
+ compressed: false
+ GlobalTableId: 0
+ directory: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1173758888/10002
+ table:
+ input format: org.apache.hadoop.mapred.SequenceFileInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
+ properties:
+ columns _col0,_col1,_col2,_col3,_col4,_col5,_col6,_col7
+ columns.types string,string,string,string,string,string,string,string
Local Work:
Map Reduce Local Work
Alias -> Map Local Tables:
@@ -76,7 +80,7 @@
File Output Operator
compressed: false
GlobalTableId: 0
- directory: file:/data/users/njain/hive4/hive4/build/ql/tmp/357616883/10002
+ directory: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1173758888/10002
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -100,7 +104,7 @@
File Output Operator
compressed: false
GlobalTableId: 0
- directory: file:/data/users/njain/hive4/hive4/build/ql/tmp/357616883/10002
+ directory: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1173758888/10002
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -109,9 +113,9 @@
columns.types string,string,string,string,string,string,string,string
Needs Tagging: false
Path -> Alias:
- file:/data/users/njain/hive4/hive4/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11
+ file:/data/users/pchakka/workspace/oshive/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11
Path -> Partition:
- file:/data/users/njain/hive4/hive4/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11
+ file:/data/users/pchakka/workspace/oshive/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11
Partition
partition values:
ds 2008-04-08
@@ -130,14 +134,14 @@
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/data/users/njain/hive4/hive4/build/ql/test/data/warehouse/srcpart
+ location file:/data/users/pchakka/workspace/oshive/build/ql/test/data/warehouse/srcpart
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: srcpart
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/njain/hive4/hive4/build/ql/tmp/357616883/10002
+ file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1173758888/10002
Select Operator
Select Operator
expressions:
@@ -150,7 +154,7 @@
File Output Operator
compressed: false
GlobalTableId: 1
- directory: file:/data/users/njain/hive4/hive4/build/ql/tmp/357616883/10003
+ directory: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1173758888/10003
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -164,14 +168,14 @@
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/data/users/njain/hive4/hive4/build/ql/test/data/warehouse/dest_j1
+ location file:/data/users/pchakka/workspace/oshive/build/ql/test/data/warehouse/dest_j1
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: dest_j1
Needs Tagging: false
Path -> Alias:
- file:/data/users/njain/hive4/hive4/build/ql/tmp/357616883/10002
+ file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1173758888/10002
Path -> Partition:
- file:/data/users/njain/hive4/hive4/build/ql/tmp/357616883/10002
+ file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1173758888/10002
Partition
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
@@ -186,11 +190,11 @@
Move Operator
files:
hdfs directory: true
- source: file:/data/users/njain/hive4/hive4/build/ql/tmp/357616883/10003
- destination: file:/data/users/njain/hive4/hive4/build/ql/tmp/1829581969/10000
+ source: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1173758888/10003
+ destination: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1120006262/10000
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/njain/hive4/hive4/build/ql/tmp/357616883/10003
+ file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1173758888/10003
Reduce Output Operator
sort order:
Map-reduce partition columns:
@@ -206,9 +210,9 @@
type: string
Needs Tagging: false
Path -> Alias:
- file:/data/users/njain/hive4/hive4/build/ql/tmp/357616883/10003
+ file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1173758888/10003
Path -> Partition:
- file:/data/users/njain/hive4/hive4/build/ql/tmp/357616883/10003
+ file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1173758888/10003
Partition
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -223,7 +227,7 @@
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/data/users/njain/hive4/hive4/build/ql/test/data/warehouse/dest_j1
+ location file:/data/users/pchakka/workspace/oshive/build/ql/test/data/warehouse/dest_j1
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: dest_j1
Reduce Operator Tree:
@@ -231,7 +235,7 @@
File Output Operator
compressed: false
GlobalTableId: 0
- directory: file:/data/users/njain/hive4/hive4/build/ql/tmp/1829581969/10000
+ directory: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1120006262/10000
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -245,7 +249,7 @@
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/data/users/njain/hive4/hive4/build/ql/test/data/warehouse/dest_j1
+ location file:/data/users/pchakka/workspace/oshive/build/ql/test/data/warehouse/dest_j1
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: dest_j1
@@ -253,7 +257,7 @@
Move Operator
tables:
replace: true
- source: file:/data/users/njain/hive4/hive4/build/ql/tmp/1829581969/10000
+ source: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1120006262/10000
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -267,10 +271,10 @@
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/data/users/njain/hive4/hive4/build/ql/test/data/warehouse/dest_j1
+ location file:/data/users/pchakka/workspace/oshive/build/ql/test/data/warehouse/dest_j1
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: dest_j1
- tmp directory: file:/data/users/njain/hive4/hive4/build/ql/tmp/1829581969/10001
+ tmp directory: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1120006262/10001
query: INSERT OVERWRITE TABLE dest_j1
@@ -283,7 +287,7 @@
Output: default/dest_j1
query: select * from dest_j1 x order by x.key
Input: default/dest_j1
-Output: file:/data/users/njain/hive4/hive4/build/ql/tmp/159887643/10000
+Output: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1885363957/10000
128 val_128 val_128
128 val_128 val_128
128 val_128 val_128
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/join28.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/join28.q.out?rev=787898&r1=787897&r2=787898&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/join28.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/join28.q.out Wed Jun 24 04:05:02 2009
@@ -66,7 +66,7 @@
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/njain/hive4/hive4/build/ql/tmp/2104088223/10002
+ file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1815676421/10002
Select Operator
Select Operator
expressions:
@@ -98,33 +98,37 @@
z
Filter Operator
predicate:
- expr: (ds = '2008-04-08')
+ expr: ((ds = '2008-04-08') and (UDFToDouble(hr) = UDFToDouble(11)))
type: boolean
Filter Operator
predicate:
- expr: (UDFToDouble(hr) = UDFToDouble(11))
+ expr: (ds = '2008-04-08')
type: boolean
- Common Join Operator
- condition map:
- Inner Join 0 to 1
- condition expressions:
- 0 {_col0}
- 1 {key} {value} {ds} {hr}
- keys:
- 0
- 1
- Position of Big Table: 0
- File Output Operator
- compressed: false
- GlobalTableId: 0
- table:
- input format: org.apache.hadoop.mapred.SequenceFileInputFormat
- output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
+ Filter Operator
+ predicate:
+ expr: (UDFToDouble(hr) = UDFToDouble(11))
+ type: boolean
+ Common Join Operator
+ condition map:
+ Inner Join 0 to 1
+ condition expressions:
+ 0 {_col0}
+ 1 {key} {value} {ds} {hr}
+ keys:
+ 0
+ 1
+ Position of Big Table: 0
+ 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-3
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/njain/hive4/hive4/build/ql/tmp/2104088223/10003
+ file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1815676421/10003
Select Operator
Select Operator
expressions:
@@ -147,10 +151,10 @@
Move Operator
files:
hdfs directory: true
- destination: file:/data/users/njain/hive4/hive4/build/ql/tmp/1274578593/10000
+ destination: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1094740336/10000
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/njain/hive4/hive4/build/ql/tmp/2104088223/10004
+ file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1815676421/10004
Reduce Output Operator
sort order:
Map-reduce partition columns:
@@ -196,7 +200,7 @@
Output: default/dest_j1
query: select * from dest_j1 x order by x.key
Input: default/dest_j1
-Output: file:/data/users/njain/hive4/hive4/build/ql/tmp/1105642705/10000
+Output: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1009140217/10000
128 val_128
128 val_128
128 val_128
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/join32.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/join32.q.out?rev=787898&r1=787897&r2=787898&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/join32.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/join32.q.out Wed Jun 24 04:05:02 2009
@@ -32,7 +32,7 @@
File Output Operator
compressed: false
GlobalTableId: 0
- directory: file:/data/users/njain/hive4/hive4/build/ql/tmp/1667896979/10004
+ directory: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1346847963/10004
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -60,7 +60,7 @@
File Output Operator
compressed: false
GlobalTableId: 0
- directory: file:/data/users/njain/hive4/hive4/build/ql/tmp/1667896979/10004
+ directory: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1346847963/10004
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -69,9 +69,9 @@
columns.types string,string,string,string
Needs Tagging: false
Path -> Alias:
- file:/data/users/njain/hive4/hive4/build/ql/test/data/warehouse/src
+ file:/data/users/pchakka/workspace/oshive/build/ql/test/data/warehouse/src
Path -> Partition:
- file:/data/users/njain/hive4/hive4/build/ql/test/data/warehouse/src
+ file:/data/users/pchakka/workspace/oshive/build/ql/test/data/warehouse/src
Partition
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -86,14 +86,14 @@
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/data/users/njain/hive4/hive4/build/ql/test/data/warehouse/src
+ location file:/data/users/pchakka/workspace/oshive/build/ql/test/data/warehouse/src
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: src
Stage: Stage-1
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/njain/hive4/hive4/build/ql/tmp/1667896979/10004
+ file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1346847963/10004
Select Operator
Common Join Operator
condition map:
@@ -108,7 +108,7 @@
File Output Operator
compressed: false
GlobalTableId: 0
- directory: file:/data/users/njain/hive4/hive4/build/ql/tmp/1667896979/10002
+ directory: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1346847963/10002
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -125,37 +125,41 @@
z
Filter Operator
predicate:
- expr: (ds = '2008-04-08')
+ expr: ((ds = '2008-04-08') and (UDFToDouble(hr) = UDFToDouble(11)))
type: boolean
Filter Operator
predicate:
- expr: (UDFToDouble(hr) = UDFToDouble(11))
+ expr: (ds = '2008-04-08')
type: boolean
- Common Join Operator
- condition map:
- Inner Join 0 to 1
- condition expressions:
- 0 {_col2} {_col3} {_col0} {_col1}
- 1 {key} {value} {ds} {hr}
- keys:
- 0
- 1
- Position of Big Table: 0
- File Output Operator
- compressed: false
- GlobalTableId: 0
- directory: file:/data/users/njain/hive4/hive4/build/ql/tmp/1667896979/10002
- table:
- input format: org.apache.hadoop.mapred.SequenceFileInputFormat
- output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
- properties:
- columns _col0,_col1,_col2,_col3,_col4,_col5,_col6,_col7
- columns.types string,string,string,string,string,string,string,string
+ Filter Operator
+ predicate:
+ expr: (UDFToDouble(hr) = UDFToDouble(11))
+ type: boolean
+ Common Join Operator
+ condition map:
+ Inner Join 0 to 1
+ condition expressions:
+ 0 {_col2} {_col3} {_col0} {_col1}
+ 1 {key} {value} {ds} {hr}
+ keys:
+ 0
+ 1
+ Position of Big Table: 0
+ File Output Operator
+ compressed: false
+ GlobalTableId: 0
+ directory: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1346847963/10002
+ table:
+ input format: org.apache.hadoop.mapred.SequenceFileInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
+ properties:
+ columns _col0,_col1,_col2,_col3,_col4,_col5,_col6,_col7
+ columns.types string,string,string,string,string,string,string,string
Needs Tagging: false
Path -> Alias:
- file:/data/users/njain/hive4/hive4/build/ql/tmp/1667896979/10004
+ file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1346847963/10004
Path -> Partition:
- file:/data/users/njain/hive4/hive4/build/ql/tmp/1667896979/10004
+ file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1346847963/10004
Partition
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
@@ -167,7 +171,7 @@
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/njain/hive4/hive4/build/ql/tmp/1667896979/10002
+ file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1346847963/10002
Select Operator
Select Operator
expressions:
@@ -180,7 +184,7 @@
File Output Operator
compressed: false
GlobalTableId: 1
- directory: file:/data/users/njain/hive4/hive4/build/ql/tmp/1667896979/10003
+ directory: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1346847963/10003
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -194,14 +198,14 @@
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/data/users/njain/hive4/hive4/build/ql/test/data/warehouse/dest_j1
+ location file:/data/users/pchakka/workspace/oshive/build/ql/test/data/warehouse/dest_j1
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: dest_j1
Needs Tagging: false
Path -> Alias:
- file:/data/users/njain/hive4/hive4/build/ql/tmp/1667896979/10002
+ file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1346847963/10002
Path -> Partition:
- file:/data/users/njain/hive4/hive4/build/ql/tmp/1667896979/10002
+ file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1346847963/10002
Partition
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
@@ -216,11 +220,11 @@
Move Operator
files:
hdfs directory: true
- source: file:/data/users/njain/hive4/hive4/build/ql/tmp/1667896979/10003
- destination: file:/data/users/njain/hive4/hive4/build/ql/tmp/765743614/10000
+ source: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1346847963/10003
+ destination: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/186721190/10000
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/njain/hive4/hive4/build/ql/tmp/1667896979/10003
+ file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1346847963/10003
Reduce Output Operator
sort order:
Map-reduce partition columns:
@@ -236,9 +240,9 @@
type: string
Needs Tagging: false
Path -> Alias:
- file:/data/users/njain/hive4/hive4/build/ql/tmp/1667896979/10003
+ file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1346847963/10003
Path -> Partition:
- file:/data/users/njain/hive4/hive4/build/ql/tmp/1667896979/10003
+ file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1346847963/10003
Partition
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -253,7 +257,7 @@
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/data/users/njain/hive4/hive4/build/ql/test/data/warehouse/dest_j1
+ location file:/data/users/pchakka/workspace/oshive/build/ql/test/data/warehouse/dest_j1
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: dest_j1
Reduce Operator Tree:
@@ -261,7 +265,7 @@
File Output Operator
compressed: false
GlobalTableId: 0
- directory: file:/data/users/njain/hive4/hive4/build/ql/tmp/765743614/10000
+ directory: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/186721190/10000
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -275,7 +279,7 @@
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/data/users/njain/hive4/hive4/build/ql/test/data/warehouse/dest_j1
+ location file:/data/users/pchakka/workspace/oshive/build/ql/test/data/warehouse/dest_j1
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: dest_j1
@@ -283,7 +287,7 @@
Move Operator
tables:
replace: true
- source: file:/data/users/njain/hive4/hive4/build/ql/tmp/765743614/10000
+ source: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/186721190/10000
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -297,10 +301,10 @@
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/data/users/njain/hive4/hive4/build/ql/test/data/warehouse/dest_j1
+ location file:/data/users/pchakka/workspace/oshive/build/ql/test/data/warehouse/dest_j1
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: dest_j1
- tmp directory: file:/data/users/njain/hive4/hive4/build/ql/tmp/765743614/10001
+ tmp directory: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/186721190/10001
query: INSERT OVERWRITE TABLE dest_j1
@@ -313,7 +317,7 @@
Output: default/dest_j1
query: select * from dest_j1 x order by x.key
Input: default/dest_j1
-Output: file:/data/users/njain/hive4/hive4/build/ql/tmp/1004857562/10000
+Output: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1483693438/10000
146 val_146 val_146
146 val_146 val_146
146 val_146 val_146
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/join33.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/join33.q.out?rev=787898&r1=787897&r2=787898&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/join33.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/join33.q.out Wed Jun 24 04:05:02 2009
@@ -30,7 +30,7 @@
File Output Operator
compressed: false
GlobalTableId: 0
- directory: file:/data/users/njain/hive4/hive4/build/ql/tmp/1264995702/10002
+ directory: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1543545927/10002
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -58,7 +58,7 @@
File Output Operator
compressed: false
GlobalTableId: 0
- directory: file:/data/users/njain/hive4/hive4/build/ql/tmp/1264995702/10002
+ directory: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1543545927/10002
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -67,9 +67,9 @@
columns.types string,string,string,string
Needs Tagging: false
Path -> Alias:
- file:/data/users/njain/hive4/hive4/build/ql/test/data/warehouse/src
+ file:/data/users/pchakka/workspace/oshive/build/ql/test/data/warehouse/src
Path -> Partition:
- file:/data/users/njain/hive4/hive4/build/ql/test/data/warehouse/src
+ file:/data/users/pchakka/workspace/oshive/build/ql/test/data/warehouse/src
Partition
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -84,7 +84,7 @@
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/data/users/njain/hive4/hive4/build/ql/test/data/warehouse/src
+ location file:/data/users/pchakka/workspace/oshive/build/ql/test/data/warehouse/src
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: src
@@ -94,31 +94,35 @@
z
Filter Operator
predicate:
- expr: (ds = '2008-04-08')
+ expr: ((ds = '2008-04-08') and (UDFToDouble(hr) = UDFToDouble(11)))
type: boolean
Filter Operator
predicate:
- expr: (UDFToDouble(hr) = UDFToDouble(11))
+ expr: (ds = '2008-04-08')
type: boolean
- Reduce Output Operator
- key expressions:
- expr: value
- type: string
- sort order: +
- Map-reduce partition columns:
- expr: value
- type: string
- tag: 1
- value expressions:
- expr: key
- type: string
- expr: value
- type: string
- expr: ds
- type: string
- expr: hr
- type: string
- file:/data/users/njain/hive4/hive4/build/ql/tmp/1264995702/10002
+ Filter Operator
+ predicate:
+ expr: (UDFToDouble(hr) = UDFToDouble(11))
+ type: boolean
+ Reduce Output Operator
+ key expressions:
+ expr: value
+ type: string
+ sort order: +
+ Map-reduce partition columns:
+ expr: value
+ type: string
+ tag: 1
+ value expressions:
+ expr: key
+ type: string
+ expr: value
+ type: string
+ expr: ds
+ type: string
+ expr: hr
+ type: string
+ file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1543545927/10002
Select Operator
Reduce Output Operator
key expressions:
@@ -140,10 +144,10 @@
type: string
Needs Tagging: true
Path -> Alias:
- file:/data/users/njain/hive4/hive4/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11
- file:/data/users/njain/hive4/hive4/build/ql/tmp/1264995702/10002
+ file:/data/users/pchakka/workspace/oshive/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11
+ file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1543545927/10002
Path -> Partition:
- file:/data/users/njain/hive4/hive4/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11
+ file:/data/users/pchakka/workspace/oshive/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11
Partition
partition values:
ds 2008-04-08
@@ -162,10 +166,10 @@
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/data/users/njain/hive4/hive4/build/ql/test/data/warehouse/srcpart
+ location file:/data/users/pchakka/workspace/oshive/build/ql/test/data/warehouse/srcpart
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: srcpart
- file:/data/users/njain/hive4/hive4/build/ql/tmp/1264995702/10002
+ file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1543545927/10002
Partition
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
@@ -191,7 +195,7 @@
File Output Operator
compressed: false
GlobalTableId: 1
- directory: file:/data/users/njain/hive4/hive4/build/ql/tmp/140361458/10000
+ directory: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1051890475/10000
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -205,7 +209,7 @@
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/data/users/njain/hive4/hive4/build/ql/test/data/warehouse/dest_j1
+ location file:/data/users/pchakka/workspace/oshive/build/ql/test/data/warehouse/dest_j1
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: dest_j1
@@ -213,7 +217,7 @@
Move Operator
tables:
replace: true
- source: file:/data/users/njain/hive4/hive4/build/ql/tmp/140361458/10000
+ source: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1051890475/10000
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -227,10 +231,10 @@
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/data/users/njain/hive4/hive4/build/ql/test/data/warehouse/dest_j1
+ location file:/data/users/pchakka/workspace/oshive/build/ql/test/data/warehouse/dest_j1
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: dest_j1
- tmp directory: file:/data/users/njain/hive4/hive4/build/ql/tmp/140361458/10001
+ tmp directory: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1051890475/10001
query: INSERT OVERWRITE TABLE dest_j1
@@ -243,7 +247,7 @@
Output: default/dest_j1
query: select * from dest_j1 x order by x.key
Input: default/dest_j1
-Output: file:/data/users/njain/hive4/hive4/build/ql/tmp/2070324498/10000
+Output: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/306446495/10000
146 val_146 val_146
146 val_146 val_146
146 val_146 val_146
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/join34.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/join34.q.out?rev=787898&r1=787897&r2=787898&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/join34.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/join34.q.out Wed Jun 24 04:05:02 2009
@@ -27,65 +27,73 @@
predicate:
expr: (UDFToDouble(key) < UDFToDouble(20))
type: boolean
- Select Operator
- expressions:
- expr: key
- type: string
- expr: value
- type: string
- Union
- Common Join Operator
- condition map:
- Inner Join 0 to 1
- condition expressions:
- 0 {_col0} {_col1}
- 1 {key} {value}
- keys:
- 0
- 1
- Position of Big Table: 0
- File Output Operator
- compressed: false
- GlobalTableId: 0
- directory: file:/data/users/njain/hive4/hive4/build/ql/tmp/1147824776/10002
- table:
- input format: org.apache.hadoop.mapred.SequenceFileInputFormat
- output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
- properties:
- columns _col0,_col1,_col2,_col3
- columns.types string,string,string,string
+ Filter Operator
+ predicate:
+ expr: (UDFToDouble(key) < UDFToDouble(20))
+ type: boolean
+ Select Operator
+ expressions:
+ expr: key
+ type: string
+ expr: value
+ type: string
+ Union
+ Common Join Operator
+ condition map:
+ Inner Join 0 to 1
+ condition expressions:
+ 0 {_col0} {_col1}
+ 1 {key} {value}
+ keys:
+ 0
+ 1
+ Position of Big Table: 0
+ File Output Operator
+ compressed: false
+ GlobalTableId: 0
+ directory: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1917925981/10002
+ table:
+ input format: org.apache.hadoop.mapred.SequenceFileInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
+ properties:
+ columns _col0,_col1,_col2,_col3
+ columns.types string,string,string,string
null-subquery2:subq1-subquery2:x1
Filter Operator
predicate:
expr: (UDFToDouble(key) > UDFToDouble(100))
type: boolean
- Select Operator
- expressions:
- expr: key
- type: string
- expr: value
- type: string
- Union
- Common Join Operator
- condition map:
- Inner Join 0 to 1
- condition expressions:
- 0 {_col0} {_col1}
- 1 {key} {value}
- keys:
- 0
- 1
- Position of Big Table: 0
- File Output Operator
- compressed: false
- GlobalTableId: 0
- directory: file:/data/users/njain/hive4/hive4/build/ql/tmp/1147824776/10002
- table:
- input format: org.apache.hadoop.mapred.SequenceFileInputFormat
- output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
- properties:
- columns _col0,_col1,_col2,_col3
- columns.types string,string,string,string
+ Filter Operator
+ predicate:
+ expr: (UDFToDouble(key) > UDFToDouble(100))
+ type: boolean
+ Select Operator
+ expressions:
+ expr: key
+ type: string
+ expr: value
+ type: string
+ Union
+ Common Join Operator
+ condition map:
+ Inner Join 0 to 1
+ condition expressions:
+ 0 {_col0} {_col1}
+ 1 {key} {value}
+ keys:
+ 0
+ 1
+ Position of Big Table: 0
+ File Output Operator
+ compressed: false
+ GlobalTableId: 0
+ directory: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1917925981/10002
+ table:
+ input format: org.apache.hadoop.mapred.SequenceFileInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
+ properties:
+ columns _col0,_col1,_col2,_col3
+ columns.types string,string,string,string
Local Work:
Map Reduce Local Work
Alias -> Map Local Tables:
@@ -107,7 +115,7 @@
File Output Operator
compressed: false
GlobalTableId: 0
- directory: file:/data/users/njain/hive4/hive4/build/ql/tmp/1147824776/10002
+ directory: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1917925981/10002
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -116,9 +124,9 @@
columns.types string,string,string,string
Needs Tagging: false
Path -> Alias:
- file:/data/users/njain/hive4/hive4/build/ql/test/data/warehouse/src
+ file:/data/users/pchakka/workspace/oshive/build/ql/test/data/warehouse/src
Path -> Partition:
- file:/data/users/njain/hive4/hive4/build/ql/test/data/warehouse/src
+ file:/data/users/pchakka/workspace/oshive/build/ql/test/data/warehouse/src
Partition
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -133,14 +141,14 @@
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/data/users/njain/hive4/hive4/build/ql/test/data/warehouse/src
+ location file:/data/users/pchakka/workspace/oshive/build/ql/test/data/warehouse/src
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: src
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/njain/hive4/hive4/build/ql/tmp/1147824776/10002
+ file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1917925981/10002
Select Operator
Select Operator
expressions:
@@ -153,7 +161,7 @@
File Output Operator
compressed: false
GlobalTableId: 1
- directory: file:/data/users/njain/hive4/hive4/build/ql/tmp/1147824776/10003
+ directory: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1917925981/10003
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -167,14 +175,14 @@
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/data/users/njain/hive4/hive4/build/ql/test/data/warehouse/dest_j1
+ location file:/data/users/pchakka/workspace/oshive/build/ql/test/data/warehouse/dest_j1
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: dest_j1
Needs Tagging: false
Path -> Alias:
- file:/data/users/njain/hive4/hive4/build/ql/tmp/1147824776/10002
+ file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1917925981/10002
Path -> Partition:
- file:/data/users/njain/hive4/hive4/build/ql/tmp/1147824776/10002
+ file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1917925981/10002
Partition
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
@@ -189,11 +197,11 @@
Move Operator
files:
hdfs directory: true
- source: file:/data/users/njain/hive4/hive4/build/ql/tmp/1147824776/10003
- destination: file:/data/users/njain/hive4/hive4/build/ql/tmp/713355228/10000
+ source: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1917925981/10003
+ destination: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/3484851/10000
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/njain/hive4/hive4/build/ql/tmp/1147824776/10003
+ file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1917925981/10003
Reduce Output Operator
sort order:
Map-reduce partition columns:
@@ -209,9 +217,9 @@
type: string
Needs Tagging: false
Path -> Alias:
- file:/data/users/njain/hive4/hive4/build/ql/tmp/1147824776/10003
+ file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1917925981/10003
Path -> Partition:
- file:/data/users/njain/hive4/hive4/build/ql/tmp/1147824776/10003
+ file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1917925981/10003
Partition
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -226,7 +234,7 @@
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/data/users/njain/hive4/hive4/build/ql/test/data/warehouse/dest_j1
+ location file:/data/users/pchakka/workspace/oshive/build/ql/test/data/warehouse/dest_j1
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: dest_j1
Reduce Operator Tree:
@@ -234,7 +242,7 @@
File Output Operator
compressed: false
GlobalTableId: 0
- directory: file:/data/users/njain/hive4/hive4/build/ql/tmp/713355228/10000
+ directory: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/3484851/10000
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -248,7 +256,7 @@
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/data/users/njain/hive4/hive4/build/ql/test/data/warehouse/dest_j1
+ location file:/data/users/pchakka/workspace/oshive/build/ql/test/data/warehouse/dest_j1
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: dest_j1
@@ -256,7 +264,7 @@
Move Operator
tables:
replace: true
- source: file:/data/users/njain/hive4/hive4/build/ql/tmp/713355228/10000
+ source: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/3484851/10000
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -270,10 +278,10 @@
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/data/users/njain/hive4/hive4/build/ql/test/data/warehouse/dest_j1
+ location file:/data/users/pchakka/workspace/oshive/build/ql/test/data/warehouse/dest_j1
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: dest_j1
- tmp directory: file:/data/users/njain/hive4/hive4/build/ql/tmp/713355228/10001
+ tmp directory: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/3484851/10001
query: INSERT OVERWRITE TABLE dest_j1
@@ -289,7 +297,7 @@
Output: default/dest_j1
query: select * from dest_j1 x order by x.key
Input: default/dest_j1
-Output: file:/data/users/njain/hive4/hive4/build/ql/tmp/1207801716/10000
+Output: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/374627927/10000
128 val_128
128 val_128
128 val_128
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/join35.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/join35.q.out?rev=787898&r1=787897&r2=787898&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/join35.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/join35.q.out Wed Jun 24 04:05:02 2009
@@ -33,34 +33,38 @@
predicate:
expr: (UDFToDouble(key) < UDFToDouble(20))
type: boolean
- Select Operator
- expressions:
- expr: key
- type: string
- Group By Operator
- aggregations:
- expr: count(1)
- keys:
+ Filter Operator
+ predicate:
+ expr: (UDFToDouble(key) < UDFToDouble(20))
+ type: boolean
+ Select Operator
+ expressions:
expr: key
type: string
- mode: hash
- Reduce Output Operator
- key expressions:
- expr: _col0
- type: string
- sort order: +
- Map-reduce partition columns:
- expr: _col0
+ Group By Operator
+ aggregations:
+ expr: count(1)
+ keys:
+ expr: key
type: string
- tag: -1
- value expressions:
- expr: _col1
- type: bigint
+ mode: hash
+ Reduce Output Operator
+ key expressions:
+ expr: _col0
+ type: string
+ sort order: +
+ Map-reduce partition columns:
+ expr: _col0
+ type: string
+ tag: -1
+ value expressions:
+ expr: _col1
+ type: bigint
Needs Tagging: false
Path -> Alias:
- file:/data/users/njain/hive4/hive4/build/ql/test/data/warehouse/src
+ file:/data/users/pchakka/workspace/oshive/build/ql/test/data/warehouse/src
Path -> Partition:
- file:/data/users/njain/hive4/hive4/build/ql/test/data/warehouse/src
+ file:/data/users/pchakka/workspace/oshive/build/ql/test/data/warehouse/src
Partition
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -75,7 +79,7 @@
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/data/users/njain/hive4/hive4/build/ql/test/data/warehouse/src
+ location file:/data/users/pchakka/workspace/oshive/build/ql/test/data/warehouse/src
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: src
Reduce Operator Tree:
@@ -95,7 +99,7 @@
File Output Operator
compressed: false
GlobalTableId: 0
- directory: file:/data/users/njain/hive4/hive4/build/ql/tmp/2063520520/10002
+ directory: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1491787652/10002
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -108,7 +112,7 @@
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/njain/hive4/hive4/build/ql/tmp/2063520520/10002
+ file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1491787652/10002
Union
Common Join Operator
condition map:
@@ -123,14 +127,14 @@
File Output Operator
compressed: false
GlobalTableId: 0
- directory: file:/data/users/njain/hive4/hive4/build/ql/tmp/2063520520/10003
+ directory: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1491787652/10003
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
properties:
columns _col0,_col1,_col2,_col3
columns.types string,bigint,string,string
- file:/data/users/njain/hive4/hive4/build/ql/tmp/2063520520/10005
+ file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1491787652/10005
Union
Common Join Operator
condition map:
@@ -145,7 +149,7 @@
File Output Operator
compressed: false
GlobalTableId: 0
- directory: file:/data/users/njain/hive4/hive4/build/ql/tmp/2063520520/10003
+ directory: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1491787652/10003
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -173,7 +177,7 @@
File Output Operator
compressed: false
GlobalTableId: 0
- directory: file:/data/users/njain/hive4/hive4/build/ql/tmp/2063520520/10003
+ directory: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1491787652/10003
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -182,10 +186,10 @@
columns.types string,bigint,string,string
Needs Tagging: false
Path -> Alias:
- file:/data/users/njain/hive4/hive4/build/ql/tmp/2063520520/10002
- file:/data/users/njain/hive4/hive4/build/ql/tmp/2063520520/10005
+ file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1491787652/10002
+ file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1491787652/10005
Path -> Partition:
- file:/data/users/njain/hive4/hive4/build/ql/tmp/2063520520/10002
+ file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1491787652/10002
Partition
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
@@ -195,7 +199,7 @@
serialization.ddl struct binary_table { string _col0, i64 _col1}
serialization.format com.facebook.thrift.protocol.TBinaryProtocol
name: binary_table
- file:/data/users/njain/hive4/hive4/build/ql/tmp/2063520520/10005
+ file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1491787652/10005
Partition
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
@@ -209,7 +213,7 @@
Stage: Stage-3
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/njain/hive4/hive4/build/ql/tmp/2063520520/10003
+ file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1491787652/10003
Select Operator
Select Operator
expressions:
@@ -230,7 +234,7 @@
File Output Operator
compressed: false
GlobalTableId: 1
- directory: file:/data/users/njain/hive4/hive4/build/ql/tmp/2063520520/10004
+ directory: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1491787652/10004
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -244,14 +248,14 @@
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/data/users/njain/hive4/hive4/build/ql/test/data/warehouse/dest_j1
+ location file:/data/users/pchakka/workspace/oshive/build/ql/test/data/warehouse/dest_j1
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: dest_j1
Needs Tagging: false
Path -> Alias:
- file:/data/users/njain/hive4/hive4/build/ql/tmp/2063520520/10003
+ file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1491787652/10003
Path -> Partition:
- file:/data/users/njain/hive4/hive4/build/ql/tmp/2063520520/10003
+ file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1491787652/10003
Partition
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
@@ -266,11 +270,11 @@
Move Operator
files:
hdfs directory: true
- source: file:/data/users/njain/hive4/hive4/build/ql/tmp/2063520520/10004
- destination: file:/data/users/njain/hive4/hive4/build/ql/tmp/387190739/10000
+ source: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1491787652/10004
+ destination: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/100379931/10000
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/njain/hive4/hive4/build/ql/tmp/2063520520/10004
+ file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1491787652/10004
Reduce Output Operator
sort order:
Map-reduce partition columns:
@@ -286,9 +290,9 @@
type: int
Needs Tagging: false
Path -> Alias:
- file:/data/users/njain/hive4/hive4/build/ql/tmp/2063520520/10004
+ file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1491787652/10004
Path -> Partition:
- file:/data/users/njain/hive4/hive4/build/ql/tmp/2063520520/10004
+ file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1491787652/10004
Partition
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -303,7 +307,7 @@
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/data/users/njain/hive4/hive4/build/ql/test/data/warehouse/dest_j1
+ location file:/data/users/pchakka/workspace/oshive/build/ql/test/data/warehouse/dest_j1
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: dest_j1
Reduce Operator Tree:
@@ -311,7 +315,7 @@
File Output Operator
compressed: false
GlobalTableId: 0
- directory: file:/data/users/njain/hive4/hive4/build/ql/tmp/387190739/10000
+ directory: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/100379931/10000
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -325,7 +329,7 @@
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/data/users/njain/hive4/hive4/build/ql/test/data/warehouse/dest_j1
+ location file:/data/users/pchakka/workspace/oshive/build/ql/test/data/warehouse/dest_j1
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: dest_j1
@@ -333,7 +337,7 @@
Move Operator
tables:
replace: true
- source: file:/data/users/njain/hive4/hive4/build/ql/tmp/387190739/10000
+ source: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/100379931/10000
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -347,10 +351,10 @@
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/data/users/njain/hive4/hive4/build/ql/test/data/warehouse/dest_j1
+ location file:/data/users/pchakka/workspace/oshive/build/ql/test/data/warehouse/dest_j1
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: dest_j1
- tmp directory: file:/data/users/njain/hive4/hive4/build/ql/tmp/387190739/10001
+ tmp directory: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/100379931/10001
Stage: Stage-7
Map Reduce
@@ -360,34 +364,38 @@
predicate:
expr: (UDFToDouble(key) > UDFToDouble(100))
type: boolean
- Select Operator
- expressions:
- expr: key
- type: string
- Group By Operator
- aggregations:
- expr: count(1)
- keys:
+ Filter Operator
+ predicate:
+ expr: (UDFToDouble(key) > UDFToDouble(100))
+ type: boolean
+ Select Operator
+ expressions:
expr: key
type: string
- mode: hash
- Reduce Output Operator
- key expressions:
- expr: _col0
- type: string
- sort order: +
- Map-reduce partition columns:
- expr: _col0
+ Group By Operator
+ aggregations:
+ expr: count(1)
+ keys:
+ expr: key
type: string
- tag: -1
- value expressions:
- expr: _col1
- type: bigint
+ mode: hash
+ Reduce Output Operator
+ key expressions:
+ expr: _col0
+ type: string
+ sort order: +
+ Map-reduce partition columns:
+ expr: _col0
+ type: string
+ tag: -1
+ value expressions:
+ expr: _col1
+ type: bigint
Needs Tagging: false
Path -> Alias:
- file:/data/users/njain/hive4/hive4/build/ql/test/data/warehouse/src
+ file:/data/users/pchakka/workspace/oshive/build/ql/test/data/warehouse/src
Path -> Partition:
- file:/data/users/njain/hive4/hive4/build/ql/test/data/warehouse/src
+ file:/data/users/pchakka/workspace/oshive/build/ql/test/data/warehouse/src
Partition
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -402,7 +410,7 @@
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/data/users/njain/hive4/hive4/build/ql/test/data/warehouse/src
+ location file:/data/users/pchakka/workspace/oshive/build/ql/test/data/warehouse/src
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: src
Reduce Operator Tree:
@@ -422,7 +430,7 @@
File Output Operator
compressed: false
GlobalTableId: 0
- directory: file:/data/users/njain/hive4/hive4/build/ql/tmp/2063520520/10005
+ directory: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1491787652/10005
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -446,7 +454,7 @@
Output: default/dest_j1
query: select * from dest_j1 x order by x.key
Input: default/dest_j1
-Output: file:/data/users/njain/hive4/hive4/build/ql/tmp/636059953/10000
+Output: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/2035491366/10000
128 3
146 val_146 2
150 val_150 1
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/join4.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/join4.q.out?rev=787898&r1=787897&r2=787898&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/join4.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/join4.q.out Wed Jun 24 04:05:02 2009
@@ -29,51 +29,59 @@
predicate:
expr: ((UDFToDouble(key) > UDFToDouble(10)) and (UDFToDouble(key) < UDFToDouble(20)))
type: boolean
- Select Operator
- expressions:
- expr: key
- type: string
- expr: value
- type: string
- Reduce Output Operator
- key expressions:
- expr: _col0
- type: string
- sort order: +
- Map-reduce partition columns:
- expr: _col0
- type: string
- tag: 0
- value expressions:
- expr: _col0
- type: string
- expr: _col1
- type: string
+ Filter Operator
+ predicate:
+ expr: ((UDFToDouble(key) > UDFToDouble(10)) and (UDFToDouble(key) < UDFToDouble(20)))
+ type: boolean
+ Select Operator
+ expressions:
+ expr: key
+ type: string
+ expr: value
+ type: string
+ Reduce Output Operator
+ key expressions:
+ expr: _col0
+ type: string
+ sort order: +
+ Map-reduce partition columns:
+ expr: _col0
+ type: string
+ tag: 0
+ value expressions:
+ expr: _col0
+ type: string
+ expr: _col1
+ type: string
c:b:src2
Filter Operator
predicate:
expr: ((UDFToDouble(key) > UDFToDouble(15)) and (UDFToDouble(key) < UDFToDouble(25)))
type: boolean
- Select Operator
- expressions:
- expr: key
- type: string
- expr: value
- type: string
- Reduce Output Operator
- key expressions:
- expr: _col0
- type: string
- sort order: +
- Map-reduce partition columns:
- expr: _col0
- type: string
- tag: 1
- value expressions:
- expr: _col0
- type: string
- expr: _col1
- type: string
+ Filter Operator
+ predicate:
+ expr: ((UDFToDouble(key) > UDFToDouble(15)) and (UDFToDouble(key) < UDFToDouble(25)))
+ type: boolean
+ Select Operator
+ expressions:
+ expr: key
+ type: string
+ expr: value
+ type: string
+ Reduce Output Operator
+ key expressions:
+ expr: _col0
+ type: string
+ sort order: +
+ Map-reduce partition columns:
+ expr: _col0
+ type: string
+ tag: 1
+ value expressions:
+ expr: _col0
+ type: string
+ expr: _col1
+ type: string
Reduce Operator Tree:
Join Operator
condition map:
@@ -148,7 +156,7 @@
Output: default/dest1
query: SELECT dest1.* FROM dest1
Input: default/dest1
-Output: file:/data/users/njain/hive4/hive4/build/ql/tmp/530052399/10000
+Output: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1249751241/10000
11 val_11 NULL NULL
12 val_12 NULL NULL
12 val_12 NULL NULL
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/join5.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/join5.q.out?rev=787898&r1=787897&r2=787898&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/join5.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/join5.q.out Wed Jun 24 04:05:02 2009
@@ -29,51 +29,59 @@
predicate:
expr: ((UDFToDouble(key) > UDFToDouble(10)) and (UDFToDouble(key) < UDFToDouble(20)))
type: boolean
- Select Operator
- expressions:
- expr: key
- type: string
- expr: value
- type: string
- Reduce Output Operator
- key expressions:
- expr: _col0
- type: string
- sort order: +
- Map-reduce partition columns:
- expr: _col0
- type: string
- tag: 0
- value expressions:
- expr: _col0
- type: string
- expr: _col1
- type: string
+ Filter Operator
+ predicate:
+ expr: ((UDFToDouble(key) > UDFToDouble(10)) and (UDFToDouble(key) < UDFToDouble(20)))
+ type: boolean
+ Select Operator
+ expressions:
+ expr: key
+ type: string
+ expr: value
+ type: string
+ Reduce Output Operator
+ key expressions:
+ expr: _col0
+ type: string
+ sort order: +
+ Map-reduce partition columns:
+ expr: _col0
+ type: string
+ tag: 0
+ value expressions:
+ expr: _col0
+ type: string
+ expr: _col1
+ type: string
c:b:src2
Filter Operator
predicate:
expr: ((UDFToDouble(key) > UDFToDouble(15)) and (UDFToDouble(key) < UDFToDouble(25)))
type: boolean
- Select Operator
- expressions:
- expr: key
- type: string
- expr: value
- type: string
- Reduce Output Operator
- key expressions:
- expr: _col0
- type: string
- sort order: +
- Map-reduce partition columns:
- expr: _col0
- type: string
- tag: 1
- value expressions:
- expr: _col0
- type: string
- expr: _col1
- type: string
+ Filter Operator
+ predicate:
+ expr: ((UDFToDouble(key) > UDFToDouble(15)) and (UDFToDouble(key) < UDFToDouble(25)))
+ type: boolean
+ Select Operator
+ expressions:
+ expr: key
+ type: string
+ expr: value
+ type: string
+ Reduce Output Operator
+ key expressions:
+ expr: _col0
+ type: string
+ sort order: +
+ Map-reduce partition columns:
+ expr: _col0
+ type: string
+ tag: 1
+ value expressions:
+ expr: _col0
+ type: string
+ expr: _col1
+ type: string
Reduce Operator Tree:
Join Operator
condition map:
@@ -148,7 +156,7 @@
Output: default/dest1
query: SELECT dest1.* FROM dest1
Input: default/dest1
-Output: file:/data/users/njain/hive4/hive4/build/ql/tmp/1067150280/10000
+Output: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/644095103/10000
17 val_17 17 val_17
18 val_18 18 val_18
18 val_18 18 val_18
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/join6.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/join6.q.out?rev=787898&r1=787897&r2=787898&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/join6.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/join6.q.out Wed Jun 24 04:05:02 2009
@@ -29,51 +29,59 @@
predicate:
expr: ((UDFToDouble(key) > UDFToDouble(10)) and (UDFToDouble(key) < UDFToDouble(20)))
type: boolean
- Select Operator
- expressions:
- expr: key
- type: string
- expr: value
- type: string
- Reduce Output Operator
- key expressions:
- expr: _col0
- type: string
- sort order: +
- Map-reduce partition columns:
- expr: _col0
- type: string
- tag: 0
- value expressions:
- expr: _col0
- type: string
- expr: _col1
- type: string
+ Filter Operator
+ predicate:
+ expr: ((UDFToDouble(key) > UDFToDouble(10)) and (UDFToDouble(key) < UDFToDouble(20)))
+ type: boolean
+ Select Operator
+ expressions:
+ expr: key
+ type: string
+ expr: value
+ type: string
+ Reduce Output Operator
+ key expressions:
+ expr: _col0
+ type: string
+ sort order: +
+ Map-reduce partition columns:
+ expr: _col0
+ type: string
+ tag: 0
+ value expressions:
+ expr: _col0
+ type: string
+ expr: _col1
+ type: string
c:b:src2
Filter Operator
predicate:
expr: ((UDFToDouble(key) > UDFToDouble(15)) and (UDFToDouble(key) < UDFToDouble(25)))
type: boolean
- Select Operator
- expressions:
- expr: key
- type: string
- expr: value
- type: string
- Reduce Output Operator
- key expressions:
- expr: _col0
- type: string
- sort order: +
- Map-reduce partition columns:
- expr: _col0
- type: string
- tag: 1
- value expressions:
- expr: _col0
- type: string
- expr: _col1
- type: string
+ Filter Operator
+ predicate:
+ expr: ((UDFToDouble(key) > UDFToDouble(15)) and (UDFToDouble(key) < UDFToDouble(25)))
+ type: boolean
+ Select Operator
+ expressions:
+ expr: key
+ type: string
+ expr: value
+ type: string
+ Reduce Output Operator
+ key expressions:
+ expr: _col0
+ type: string
+ sort order: +
+ Map-reduce partition columns:
+ expr: _col0
+ type: string
+ tag: 1
+ value expressions:
+ expr: _col0
+ type: string
+ expr: _col1
+ type: string
Reduce Operator Tree:
Join Operator
condition map:
@@ -148,7 +156,7 @@
Output: default/dest1
query: SELECT dest1.* FROM dest1
Input: default/dest1
-Output: file:/data/users/njain/hive4/hive4/build/ql/tmp/432321775/10000
+Output: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1110594034/10000
11 val_11 NULL NULL
12 val_12 NULL NULL
12 val_12 NULL NULL