You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by na...@apache.org on 2009/06/25 07:50:51 UTC
svn commit: r788269 [2/4] - in /hadoop/hive/trunk: ./
ql/src/java/org/apache/hadoop/hive/ql/exec/
ql/src/java/org/apache/hadoop/hive/ql/optimizer/
ql/src/java/org/apache/hadoop/hive/ql/parse/
ql/src/java/org/apache/hadoop/hive/ql/plan/ ql/src/test/resu...
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=788269&r1=788268&r2=788269&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 Thu Jun 25 05:50:50 2009
@@ -26,8 +26,8 @@
condition map:
Inner Join 0 to 1
condition expressions:
- 0 {key} {value}
- 1 {key} {value}
+ 0 {key}
+ 1
keys:
0
1
@@ -50,8 +50,8 @@
condition map:
Inner Join 0 to 1
condition expressions:
- 0 {key} {value}
- 1 {key} {value}
+ 0 {key}
+ 1
keys:
0
1
@@ -66,8 +66,11 @@
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1815676421/10002
+ file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/2012162302/10002
Select Operator
+ expressions:
+ expr: _col0
+ type: string
Select Operator
expressions:
expr: _col0
@@ -77,7 +80,7 @@
Inner Join 0 to 1
condition expressions:
0 {_col0}
- 1 {key} {value} {ds} {hr}
+ 1 {value}
keys:
0
1
@@ -113,7 +116,7 @@
Inner Join 0 to 1
condition expressions:
0 {_col0}
- 1 {key} {value} {ds} {hr}
+ 1 {value}
keys:
0
1
@@ -128,8 +131,13 @@
Stage: Stage-3
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1815676421/10003
+ file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/2012162302/10003
Select Operator
+ expressions:
+ expr: _col0
+ type: string
+ expr: _col5
+ type: string
Select Operator
expressions:
expr: _col0
@@ -151,10 +159,10 @@
Move Operator
files:
hdfs directory: true
- destination: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1094740336/10000
+ destination: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/16485935/10000
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1815676421/10004
+ file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/2012162302/10004
Reduce Output Operator
sort order:
Map-reduce partition columns:
@@ -200,7 +208,7 @@
Output: default/dest_j1
query: select * from dest_j1 x order by x.key
Input: default/dest_j1
-Output: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1009140217/10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/634729814/10000
128 val_128
128 val_128
128 val_128
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/join29.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/join29.q.out?rev=788269&r1=788268&r2=788269&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/join29.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/join29.q.out Thu Jun 25 05:50:50 2009
@@ -73,13 +73,13 @@
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/njain/hive4/hive4/build/ql/tmp/1531940851/10002
+ file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1590163898/10002
Common Join Operator
condition map:
Inner Join 0 to 1
condition expressions:
0 {_col0} {_col1}
- 1 {_col0} {_col1}
+ 1 {_col1}
keys:
0
1
@@ -93,17 +93,17 @@
Local Work:
Map Reduce Local Work
Alias -> Map Local Tables:
- file:/data/users/njain/hive4/hive4/build/ql/tmp/1531940851/10005
+ file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1590163898/10005
Fetch Operator
limit: -1
Alias -> Map Local Operator Tree:
- file:/data/users/njain/hive4/hive4/build/ql/tmp/1531940851/10005
+ file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1590163898/10005
Common Join Operator
condition map:
Inner Join 0 to 1
condition expressions:
0 {_col0} {_col1}
- 1 {_col0} {_col1}
+ 1 {_col1}
keys:
0
1
@@ -118,8 +118,15 @@
Stage: Stage-3
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/njain/hive4/hive4/build/ql/tmp/1531940851/10003
+ file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1590163898/10003
Select Operator
+ expressions:
+ expr: _col0
+ type: string
+ expr: _col1
+ type: bigint
+ expr: _col3
+ type: bigint
Select Operator
expressions:
expr: _col0
@@ -151,10 +158,10 @@
Move Operator
files:
hdfs directory: true
- destination: file:/data/users/njain/hive4/hive4/build/ql/tmp/512693083/10000
+ destination: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/959537275/10000
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/njain/hive4/hive4/build/ql/tmp/1531940851/10004
+ file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1590163898/10004
Reduce Output Operator
sort order:
Map-reduce partition columns:
@@ -248,7 +255,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/1489048746/10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/948921556/10000
128 1 3
146 1 2
150 1 1
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/join3.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/join3.q.out?rev=788269&r1=788268&r2=788269&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/join3.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/join3.q.out Thu Jun 25 05:50:50 2009
@@ -23,11 +23,6 @@
expr: key
type: string
tag: 1
- value expressions:
- expr: key
- type: string
- expr: value
- type: string
src3
Reduce Output Operator
key expressions:
@@ -39,8 +34,6 @@
type: string
tag: 2
value expressions:
- expr: key
- type: string
expr: value
type: string
src1
@@ -56,17 +49,15 @@
value expressions:
expr: key
type: string
- expr: value
- type: string
Reduce Operator Tree:
Join Operator
condition map:
Inner Join 0 to 1
Inner Join 0 to 2
condition expressions:
- 0 {VALUE._col0} {VALUE._col1}
- 1 {VALUE._col0} {VALUE._col1}
- 2 {VALUE._col0} {VALUE._col1}
+ 0 {VALUE._col0}
+ 1
+ 2 {VALUE._col1}
Select Operator
expressions:
expr: _col0
@@ -105,7 +96,7 @@
Output: default/dest1
query: SELECT dest1.* FROM dest1
Input: default/dest1
-Output: file:/data/users/njain/hive4/hive4/build/ql/tmp/447413355/10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1106403218/10000
0 val_0
0 val_0
0 val_0
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/join30.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/join30.q.out?rev=788269&r1=788268&r2=788269&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/join30.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/join30.q.out Thu Jun 25 05:50:50 2009
@@ -20,8 +20,8 @@
condition map:
Inner Join 0 to 1
condition expressions:
- 0 {key} {value}
- 1 {key} {value}
+ 0 {key}
+ 1
keys:
0
1
@@ -44,8 +44,8 @@
condition map:
Inner Join 0 to 1
condition expressions:
- 0 {key} {value}
- 1 {key} {value}
+ 0 {key}
+ 1
keys:
0
1
@@ -60,8 +60,11 @@
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/njain/hive4/hive4/build/ql/tmp/1868281911/10002
+ file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1483061275/10002
Select Operator
+ expressions:
+ expr: _col0
+ type: string
Select Operator
expressions:
expr: _col0
@@ -132,7 +135,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/1393129158/10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1361140895/10000
66 1
98 2
128 3
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/join31.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/join31.q.out?rev=788269&r1=788268&r2=788269&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/join31.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/join31.q.out Thu Jun 25 05:50:50 2009
@@ -70,13 +70,13 @@
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/njain/hive4/hive4/build/ql/tmp/1913053399/10002
+ file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1203288551/10002
Common Join Operator
condition map:
Inner Join 0 to 1
condition expressions:
0 {_col0}
- 1 {_col0}
+ 1
keys:
0
1
@@ -90,17 +90,17 @@
Local Work:
Map Reduce Local Work
Alias -> Map Local Tables:
- file:/data/users/njain/hive4/hive4/build/ql/tmp/1913053399/10004
+ file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1203288551/10004
Fetch Operator
limit: -1
Alias -> Map Local Operator Tree:
- file:/data/users/njain/hive4/hive4/build/ql/tmp/1913053399/10004
+ file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1203288551/10004
Common Join Operator
condition map:
Inner Join 0 to 1
condition expressions:
0 {_col0}
- 1 {_col0}
+ 1
keys:
0
1
@@ -115,8 +115,11 @@
Stage: Stage-3
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/njain/hive4/hive4/build/ql/tmp/1913053399/10003
+ file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1203288551/10003
Select Operator
+ expressions:
+ expr: _col0
+ type: string
Select Operator
expressions:
expr: _col0
@@ -237,7 +240,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/1094372260/10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1617117942/10000
128 1
146 1
150 1
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=788269&r1=788268&r2=788269&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 Thu Jun 25 05:50:50 2009
@@ -24,7 +24,7 @@
Inner Join 0 to 1
condition expressions:
0 {key} {value}
- 1 {key} {value}
+ 1 {value}
keys:
0
1
@@ -32,13 +32,13 @@
File Output Operator
compressed: false
GlobalTableId: 0
- directory: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1346847963/10004
+ directory: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1927041156/10004
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
+ columns _col0,_col1,_col3
+ columns.types string,string,string
Local Work:
Map Reduce Local Work
Alias -> Map Local Tables:
@@ -52,7 +52,7 @@
Inner Join 0 to 1
condition expressions:
0 {key} {value}
- 1 {key} {value}
+ 1 {value}
keys:
0
1
@@ -60,18 +60,18 @@
File Output Operator
compressed: false
GlobalTableId: 0
- directory: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1346847963/10004
+ directory: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1927041156/10004
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
+ columns _col0,_col1,_col3
+ columns.types string,string,string
Needs Tagging: false
Path -> Alias:
- file:/data/users/pchakka/workspace/oshive/build/ql/test/data/warehouse/src
+ file:/Users/char/Documents/workspace/Hive-460/build/ql/test/data/warehouse/src
Path -> Partition:
- file:/data/users/pchakka/workspace/oshive/build/ql/test/data/warehouse/src
+ file:/Users/char/Documents/workspace/Hive-460/build/ql/test/data/warehouse/src
Partition
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -86,21 +86,28 @@
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/pchakka/workspace/oshive/build/ql/test/data/warehouse/src
+ location file:/Users/char/Documents/workspace/Hive-460/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/pchakka/workspace/oshive/build/ql/tmp/1346847963/10004
+ file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1927041156/10004
Select Operator
+ expressions:
+ expr: _col0
+ type: string
+ expr: _col1
+ type: string
+ expr: _col3
+ type: string
Common Join Operator
condition map:
Inner Join 0 to 1
condition expressions:
- 0 {_col2} {_col3} {_col0} {_col1}
- 1 {key} {value} {ds} {hr}
+ 0 {_col3} {_col0}
+ 1 {value}
keys:
0
1
@@ -108,13 +115,13 @@
File Output Operator
compressed: false
GlobalTableId: 0
- directory: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1346847963/10002
+ directory: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1927041156/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
+ columns _col1,_col2,_col5
+ columns.types string,string,string
Local Work:
Map Reduce Local Work
Alias -> Map Local Tables:
@@ -139,8 +146,8 @@
condition map:
Inner Join 0 to 1
condition expressions:
- 0 {_col2} {_col3} {_col0} {_col1}
- 1 {key} {value} {ds} {hr}
+ 0 {_col3} {_col0}
+ 1 {value}
keys:
0
1
@@ -148,31 +155,38 @@
File Output Operator
compressed: false
GlobalTableId: 0
- directory: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1346847963/10002
+ directory: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1927041156/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
+ columns _col1,_col2,_col5
+ columns.types string,string,string
Needs Tagging: false
Path -> Alias:
- file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1346847963/10004
+ file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1927041156/10004
Path -> Partition:
- file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1346847963/10004
+ file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1927041156/10004
Partition
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
+ columns _col0,_col1,_col3
+ columns.types string,string,string
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1346847963/10002
+ file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1927041156/10002
Select Operator
+ expressions:
+ expr: _col1
+ type: string
+ expr: _col2
+ type: string
+ expr: _col5
+ type: string
Select Operator
expressions:
expr: _col2
@@ -184,7 +198,7 @@
File Output Operator
compressed: false
GlobalTableId: 1
- directory: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1346847963/10003
+ directory: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1927041156/10003
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -198,21 +212,21 @@
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/pchakka/workspace/oshive/build/ql/test/data/warehouse/dest_j1
+ location file:/Users/char/Documents/workspace/Hive-460/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/pchakka/workspace/oshive/build/ql/tmp/1346847963/10002
+ file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1927041156/10002
Path -> Partition:
- file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1346847963/10002
+ file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1927041156/10002
Partition
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
+ columns _col1,_col2,_col5
+ columns.types string,string,string
Stage: Stage-5
Conditional Operator
@@ -220,11 +234,11 @@
Move Operator
files:
hdfs directory: true
- source: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1346847963/10003
- destination: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/186721190/10000
+ source: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1927041156/10003
+ destination: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/236043717/10000
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1346847963/10003
+ file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1927041156/10003
Reduce Output Operator
sort order:
Map-reduce partition columns:
@@ -240,9 +254,9 @@
type: string
Needs Tagging: false
Path -> Alias:
- file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1346847963/10003
+ file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1927041156/10003
Path -> Partition:
- file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1346847963/10003
+ file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1927041156/10003
Partition
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -257,7 +271,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/pchakka/workspace/oshive/build/ql/test/data/warehouse/dest_j1
+ location file:/Users/char/Documents/workspace/Hive-460/build/ql/test/data/warehouse/dest_j1
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: dest_j1
Reduce Operator Tree:
@@ -265,7 +279,7 @@
File Output Operator
compressed: false
GlobalTableId: 0
- directory: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/186721190/10000
+ directory: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/236043717/10000
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -279,7 +293,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/pchakka/workspace/oshive/build/ql/test/data/warehouse/dest_j1
+ location file:/Users/char/Documents/workspace/Hive-460/build/ql/test/data/warehouse/dest_j1
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: dest_j1
@@ -287,7 +301,7 @@
Move Operator
tables:
replace: true
- source: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/186721190/10000
+ source: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/236043717/10000
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -301,10 +315,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/pchakka/workspace/oshive/build/ql/test/data/warehouse/dest_j1
+ location file:/Users/char/Documents/workspace/Hive-460/build/ql/test/data/warehouse/dest_j1
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: dest_j1
- tmp directory: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/186721190/10001
+ tmp directory: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/236043717/10001
query: INSERT OVERWRITE TABLE dest_j1
@@ -317,7 +331,7 @@
Output: default/dest_j1
query: select * from dest_j1 x order by x.key
Input: default/dest_j1
-Output: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1483693438/10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/38655143/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=788269&r1=788268&r2=788269&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 Thu Jun 25 05:50:50 2009
@@ -22,7 +22,7 @@
Inner Join 0 to 1
condition expressions:
0 {key} {value}
- 1 {key} {value}
+ 1 {value}
keys:
0
1
@@ -30,13 +30,13 @@
File Output Operator
compressed: false
GlobalTableId: 0
- directory: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1543545927/10002
+ directory: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1449467605/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
+ columns _col0,_col1,_col3
+ columns.types string,string,string
Local Work:
Map Reduce Local Work
Alias -> Map Local Tables:
@@ -50,7 +50,7 @@
Inner Join 0 to 1
condition expressions:
0 {key} {value}
- 1 {key} {value}
+ 1 {value}
keys:
0
1
@@ -58,18 +58,18 @@
File Output Operator
compressed: false
GlobalTableId: 0
- directory: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1543545927/10002
+ directory: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1449467605/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
+ columns _col0,_col1,_col3
+ columns.types string,string,string
Needs Tagging: false
Path -> Alias:
- file:/data/users/pchakka/workspace/oshive/build/ql/test/data/warehouse/src
+ file:/Users/char/Documents/workspace/Hive-460/build/ql/test/data/warehouse/src
Path -> Partition:
- file:/data/users/pchakka/workspace/oshive/build/ql/test/data/warehouse/src
+ file:/Users/char/Documents/workspace/Hive-460/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/pchakka/workspace/oshive/build/ql/test/data/warehouse/src
+ location file:/Users/char/Documents/workspace/Hive-460/build/ql/test/data/warehouse/src
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: src
@@ -114,16 +114,17 @@
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
+ file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1449467605/10002
Select Operator
+ expressions:
+ expr: _col0
+ type: string
+ expr: _col1
+ type: string
+ expr: _col3
+ type: string
Reduce Output Operator
key expressions:
expr: _col1
@@ -134,20 +135,16 @@
type: string
tag: 0
value expressions:
- expr: _col2
- type: string
expr: _col3
type: string
expr: _col0
type: string
- expr: _col1
- type: string
Needs Tagging: true
Path -> Alias:
- 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
+ file:/Users/char/Documents/workspace/Hive-460/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11
+ file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1449467605/10002
Path -> Partition:
- file:/data/users/pchakka/workspace/oshive/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11
+ file:/Users/char/Documents/workspace/Hive-460/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11
Partition
partition values:
ds 2008-04-08
@@ -166,24 +163,24 @@
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/pchakka/workspace/oshive/build/ql/test/data/warehouse/srcpart
+ location file:/Users/char/Documents/workspace/Hive-460/build/ql/test/data/warehouse/srcpart
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: srcpart
- file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1543545927/10002
+ file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1449467605/10002
Partition
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
+ columns _col0,_col1,_col3
+ columns.types string,string,string
Reduce Operator Tree:
Join Operator
condition map:
Inner Join 0 to 1
condition expressions:
- 0 {VALUE._col0} {VALUE._col1} {VALUE._col2} {VALUE._col3}
- 1 {VALUE._col0} {VALUE._col1} {VALUE._col2} {VALUE._col3}
+ 0 {VALUE._col1} {VALUE._col2}
+ 1 {VALUE._col1}
Select Operator
expressions:
expr: _col2
@@ -195,7 +192,7 @@
File Output Operator
compressed: false
GlobalTableId: 1
- directory: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1051890475/10000
+ directory: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/500697673/10000
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -209,7 +206,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/pchakka/workspace/oshive/build/ql/test/data/warehouse/dest_j1
+ location file:/Users/char/Documents/workspace/Hive-460/build/ql/test/data/warehouse/dest_j1
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: dest_j1
@@ -217,7 +214,7 @@
Move Operator
tables:
replace: true
- source: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1051890475/10000
+ source: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/500697673/10000
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -231,10 +228,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/pchakka/workspace/oshive/build/ql/test/data/warehouse/dest_j1
+ location file:/Users/char/Documents/workspace/Hive-460/build/ql/test/data/warehouse/dest_j1
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: dest_j1
- tmp directory: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1051890475/10001
+ tmp directory: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/500697673/10001
query: INSERT OVERWRITE TABLE dest_j1
@@ -247,7 +244,7 @@
Output: default/dest_j1
query: select * from dest_j1 x order by x.key
Input: default/dest_j1
-Output: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/306446495/10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1659514145/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=788269&r1=788268&r2=788269&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 Thu Jun 25 05:50:50 2009
@@ -42,7 +42,7 @@
condition map:
Inner Join 0 to 1
condition expressions:
- 0 {_col0} {_col1}
+ 0 {_col1}
1 {key} {value}
keys:
0
@@ -51,13 +51,13 @@
File Output Operator
compressed: false
GlobalTableId: 0
- directory: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1917925981/10002
+ directory: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/798138861/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
+ columns _col1,_col2,_col3
+ columns.types string,string,string
null-subquery2:subq1-subquery2:x1
Filter Operator
predicate:
@@ -78,7 +78,7 @@
condition map:
Inner Join 0 to 1
condition expressions:
- 0 {_col0} {_col1}
+ 0 {_col1}
1 {key} {value}
keys:
0
@@ -87,13 +87,13 @@
File Output Operator
compressed: false
GlobalTableId: 0
- directory: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1917925981/10002
+ directory: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/798138861/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
+ columns _col1,_col2,_col3
+ columns.types string,string,string
Local Work:
Map Reduce Local Work
Alias -> Map Local Tables:
@@ -106,7 +106,7 @@
condition map:
Inner Join 0 to 1
condition expressions:
- 0 {_col0} {_col1}
+ 0 {_col1}
1 {key} {value}
keys:
0
@@ -115,18 +115,18 @@
File Output Operator
compressed: false
GlobalTableId: 0
- directory: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1917925981/10002
+ directory: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/798138861/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
+ columns _col1,_col2,_col3
+ columns.types string,string,string
Needs Tagging: false
Path -> Alias:
- file:/data/users/pchakka/workspace/oshive/build/ql/test/data/warehouse/src
+ file:/Users/char/Documents/workspace/Hive-460/build/ql/test/data/warehouse/src
Path -> Partition:
- file:/data/users/pchakka/workspace/oshive/build/ql/test/data/warehouse/src
+ file:/Users/char/Documents/workspace/Hive-460/build/ql/test/data/warehouse/src
Partition
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -141,15 +141,22 @@
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/pchakka/workspace/oshive/build/ql/test/data/warehouse/src
+ location file:/Users/char/Documents/workspace/Hive-460/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/pchakka/workspace/oshive/build/ql/tmp/1917925981/10002
+ file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/798138861/10002
Select Operator
+ expressions:
+ expr: _col1
+ type: string
+ expr: _col2
+ type: string
+ expr: _col3
+ type: string
Select Operator
expressions:
expr: _col2
@@ -161,7 +168,7 @@
File Output Operator
compressed: false
GlobalTableId: 1
- directory: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1917925981/10003
+ directory: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/798138861/10003
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -175,21 +182,21 @@
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/pchakka/workspace/oshive/build/ql/test/data/warehouse/dest_j1
+ location file:/Users/char/Documents/workspace/Hive-460/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/pchakka/workspace/oshive/build/ql/tmp/1917925981/10002
+ file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/798138861/10002
Path -> Partition:
- file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1917925981/10002
+ file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/798138861/10002
Partition
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
+ columns _col1,_col2,_col3
+ columns.types string,string,string
Stage: Stage-5
Conditional Operator
@@ -197,11 +204,11 @@
Move Operator
files:
hdfs directory: true
- source: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1917925981/10003
- destination: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/3484851/10000
+ source: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/798138861/10003
+ destination: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1395275171/10000
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1917925981/10003
+ file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/798138861/10003
Reduce Output Operator
sort order:
Map-reduce partition columns:
@@ -217,9 +224,9 @@
type: string
Needs Tagging: false
Path -> Alias:
- file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1917925981/10003
+ file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/798138861/10003
Path -> Partition:
- file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1917925981/10003
+ file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/798138861/10003
Partition
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -234,7 +241,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/pchakka/workspace/oshive/build/ql/test/data/warehouse/dest_j1
+ location file:/Users/char/Documents/workspace/Hive-460/build/ql/test/data/warehouse/dest_j1
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: dest_j1
Reduce Operator Tree:
@@ -242,7 +249,7 @@
File Output Operator
compressed: false
GlobalTableId: 0
- directory: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/3484851/10000
+ directory: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1395275171/10000
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -256,7 +263,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/pchakka/workspace/oshive/build/ql/test/data/warehouse/dest_j1
+ location file:/Users/char/Documents/workspace/Hive-460/build/ql/test/data/warehouse/dest_j1
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: dest_j1
@@ -264,7 +271,7 @@
Move Operator
tables:
replace: true
- source: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/3484851/10000
+ source: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1395275171/10000
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -278,10 +285,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/pchakka/workspace/oshive/build/ql/test/data/warehouse/dest_j1
+ location file:/Users/char/Documents/workspace/Hive-460/build/ql/test/data/warehouse/dest_j1
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: dest_j1
- tmp directory: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/3484851/10001
+ tmp directory: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1395275171/10001
query: INSERT OVERWRITE TABLE dest_j1
@@ -297,7 +304,7 @@
Output: default/dest_j1
query: select * from dest_j1 x order by x.key
Input: default/dest_j1
-Output: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/374627927/10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/513374112/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=788269&r1=788268&r2=788269&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 Thu Jun 25 05:50:50 2009
@@ -62,9 +62,9 @@
type: bigint
Needs Tagging: false
Path -> Alias:
- file:/data/users/pchakka/workspace/oshive/build/ql/test/data/warehouse/src
+ file:/Users/char/Documents/workspace/Hive-460/build/ql/test/data/warehouse/src
Path -> Partition:
- file:/data/users/pchakka/workspace/oshive/build/ql/test/data/warehouse/src
+ file:/Users/char/Documents/workspace/Hive-460/build/ql/test/data/warehouse/src
Partition
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -79,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/pchakka/workspace/oshive/build/ql/test/data/warehouse/src
+ location file:/Users/char/Documents/workspace/Hive-460/build/ql/test/data/warehouse/src
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: src
Reduce Operator Tree:
@@ -99,7 +99,7 @@
File Output Operator
compressed: false
GlobalTableId: 0
- directory: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1491787652/10002
+ directory: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1960311627/10002
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -112,13 +112,13 @@
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1491787652/10002
+ file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1960311627/10002
Union
Common Join Operator
condition map:
Inner Join 0 to 1
condition expressions:
- 0 {_col0} {_col1}
+ 0 {_col1}
1 {key} {value}
keys:
0
@@ -127,20 +127,20 @@
File Output Operator
compressed: false
GlobalTableId: 0
- directory: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1491787652/10003
+ directory: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1960311627/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/pchakka/workspace/oshive/build/ql/tmp/1491787652/10005
+ columns _col1,_col2,_col3
+ columns.types bigint,string,string
+ file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1960311627/10005
Union
Common Join Operator
condition map:
Inner Join 0 to 1
condition expressions:
- 0 {_col0} {_col1}
+ 0 {_col1}
1 {key} {value}
keys:
0
@@ -149,13 +149,13 @@
File Output Operator
compressed: false
GlobalTableId: 0
- directory: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1491787652/10003
+ directory: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1960311627/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
+ columns _col1,_col2,_col3
+ columns.types bigint,string,string
Local Work:
Map Reduce Local Work
Alias -> Map Local Tables:
@@ -168,7 +168,7 @@
condition map:
Inner Join 0 to 1
condition expressions:
- 0 {_col0} {_col1}
+ 0 {_col1}
1 {key} {value}
keys:
0
@@ -177,19 +177,19 @@
File Output Operator
compressed: false
GlobalTableId: 0
- directory: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1491787652/10003
+ directory: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1960311627/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
+ columns _col1,_col2,_col3
+ columns.types bigint,string,string
Needs Tagging: false
Path -> Alias:
- file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1491787652/10002
- file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1491787652/10005
+ file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1960311627/10002
+ file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1960311627/10005
Path -> Partition:
- file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1491787652/10002
+ file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1960311627/10002
Partition
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
@@ -199,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/pchakka/workspace/oshive/build/ql/tmp/1491787652/10005
+ file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1960311627/10005
Partition
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
@@ -213,8 +213,15 @@
Stage: Stage-3
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1491787652/10003
+ file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1960311627/10003
Select Operator
+ expressions:
+ expr: _col1
+ type: bigint
+ expr: _col2
+ type: string
+ expr: _col3
+ type: string
Select Operator
expressions:
expr: _col2
@@ -234,7 +241,7 @@
File Output Operator
compressed: false
GlobalTableId: 1
- directory: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1491787652/10004
+ directory: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1960311627/10004
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -248,21 +255,21 @@
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/pchakka/workspace/oshive/build/ql/test/data/warehouse/dest_j1
+ location file:/Users/char/Documents/workspace/Hive-460/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/pchakka/workspace/oshive/build/ql/tmp/1491787652/10003
+ file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1960311627/10003
Path -> Partition:
- file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1491787652/10003
+ file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1960311627/10003
Partition
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
+ columns _col1,_col2,_col3
+ columns.types bigint,string,string
Stage: Stage-6
Conditional Operator
@@ -270,11 +277,11 @@
Move Operator
files:
hdfs directory: true
- source: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1491787652/10004
- destination: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/100379931/10000
+ source: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1960311627/10004
+ destination: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/221309053/10000
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1491787652/10004
+ file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1960311627/10004
Reduce Output Operator
sort order:
Map-reduce partition columns:
@@ -290,9 +297,9 @@
type: int
Needs Tagging: false
Path -> Alias:
- file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1491787652/10004
+ file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1960311627/10004
Path -> Partition:
- file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1491787652/10004
+ file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1960311627/10004
Partition
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -307,7 +314,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/pchakka/workspace/oshive/build/ql/test/data/warehouse/dest_j1
+ location file:/Users/char/Documents/workspace/Hive-460/build/ql/test/data/warehouse/dest_j1
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: dest_j1
Reduce Operator Tree:
@@ -315,7 +322,7 @@
File Output Operator
compressed: false
GlobalTableId: 0
- directory: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/100379931/10000
+ directory: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/221309053/10000
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -329,7 +336,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/pchakka/workspace/oshive/build/ql/test/data/warehouse/dest_j1
+ location file:/Users/char/Documents/workspace/Hive-460/build/ql/test/data/warehouse/dest_j1
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: dest_j1
@@ -337,7 +344,7 @@
Move Operator
tables:
replace: true
- source: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/100379931/10000
+ source: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/221309053/10000
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -351,10 +358,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/pchakka/workspace/oshive/build/ql/test/data/warehouse/dest_j1
+ location file:/Users/char/Documents/workspace/Hive-460/build/ql/test/data/warehouse/dest_j1
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: dest_j1
- tmp directory: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/100379931/10001
+ tmp directory: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/221309053/10001
Stage: Stage-7
Map Reduce
@@ -393,9 +400,9 @@
type: bigint
Needs Tagging: false
Path -> Alias:
- file:/data/users/pchakka/workspace/oshive/build/ql/test/data/warehouse/src
+ file:/Users/char/Documents/workspace/Hive-460/build/ql/test/data/warehouse/src
Path -> Partition:
- file:/data/users/pchakka/workspace/oshive/build/ql/test/data/warehouse/src
+ file:/Users/char/Documents/workspace/Hive-460/build/ql/test/data/warehouse/src
Partition
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -410,7 +417,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/pchakka/workspace/oshive/build/ql/test/data/warehouse/src
+ location file:/Users/char/Documents/workspace/Hive-460/build/ql/test/data/warehouse/src
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: src
Reduce Operator Tree:
@@ -430,7 +437,7 @@
File Output Operator
compressed: false
GlobalTableId: 0
- directory: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1491787652/10005
+ directory: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1960311627/10005
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -454,7 +461,7 @@
Output: default/dest_j1
query: select * from dest_j1 x order by x.key
Input: default/dest_j1
-Output: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/2035491366/10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1484717471/10000
128 3
146 val_146 2
150 val_150 1
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/join36.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/join36.q.out?rev=788269&r1=788268&r2=788269&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/join36.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/join36.q.out Thu Jun 25 05:50:50 2009
@@ -35,7 +35,7 @@
Inner Join 0 to 1
condition expressions:
0 {key} {cnt}
- 1 {key} {cnt}
+ 1 {cnt}
keys:
0
1
@@ -59,7 +59,7 @@
Inner Join 0 to 1
condition expressions:
0 {key} {cnt}
- 1 {key} {cnt}
+ 1 {cnt}
keys:
0
1
@@ -74,8 +74,15 @@
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/njain/hive4/hive4/build/ql/tmp/1544683463/10002
+ file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1818872230/10002
Select Operator
+ expressions:
+ expr: _col0
+ type: int
+ expr: _col1
+ type: int
+ expr: _col3
+ type: int
Select Operator
expressions:
expr: _col0
@@ -99,10 +106,10 @@
Move Operator
files:
hdfs directory: true
- destination: file:/data/users/njain/hive4/hive4/build/ql/tmp/1680197079/10000
+ destination: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/989321268/10000
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/njain/hive4/hive4/build/ql/tmp/1544683463/10003
+ file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1818872230/10003
Reduce Output Operator
sort order:
Map-reduce partition columns:
@@ -146,7 +153,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/1167058397/10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/798843783/10000
0 3 3
2 1 1
4 1 1
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/join9.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/join9.q.out?rev=788269&r1=788268&r2=788269&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/join9.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/join9.q.out Thu Jun 25 05:50:50 2009
@@ -24,8 +24,6 @@
type: string
tag: 1
value expressions:
- expr: key
- type: string
expr: value
type: string
src1
@@ -45,18 +43,16 @@
value expressions:
expr: key
type: string
- expr: value
- type: string
expr: ds
type: string
expr: hr
type: string
Needs Tagging: true
Path -> Alias:
- file:/data/users/pchakka/workspace/oshive/build/ql/test/data/warehouse/src
- file:/data/users/pchakka/workspace/oshive/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12
+ file:/Users/char/Documents/workspace/Hive-460/build/ql/test/data/warehouse/src
+ file:/Users/char/Documents/workspace/Hive-460/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12
Path -> Partition:
- file:/data/users/pchakka/workspace/oshive/build/ql/test/data/warehouse/src
+ file:/Users/char/Documents/workspace/Hive-460/build/ql/test/data/warehouse/src
Partition
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -71,10 +67,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/pchakka/workspace/oshive/build/ql/test/data/warehouse/src
+ location file:/Users/char/Documents/workspace/Hive-460/build/ql/test/data/warehouse/src
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: src
- file:/data/users/pchakka/workspace/oshive/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12
+ file:/Users/char/Documents/workspace/Hive-460/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12
Partition
partition values:
ds 2008-04-08
@@ -93,7 +89,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/pchakka/workspace/oshive/build/ql/test/data/warehouse/srcpart
+ location file:/Users/char/Documents/workspace/Hive-460/build/ql/test/data/warehouse/srcpart
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: srcpart
Reduce Operator Tree:
@@ -101,8 +97,8 @@
condition map:
Inner Join 0 to 1
condition expressions:
- 0 {VALUE._col0} {VALUE._col1} {VALUE._col2} {VALUE._col3}
- 1 {VALUE._col0} {VALUE._col1}
+ 0 {VALUE._col0} {VALUE._col2} {VALUE._col3}
+ 1 {VALUE._col1}
Filter Operator
predicate:
expr: ((_col2 = '2008-04-08') and (_col3 = '12'))
@@ -122,7 +118,7 @@
File Output Operator
compressed: false
GlobalTableId: 1
- directory: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1604556353/10000
+ directory: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/856054437/10000
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -136,7 +132,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/pchakka/workspace/oshive/build/ql/test/data/warehouse/dest1
+ location file:/Users/char/Documents/workspace/Hive-460/build/ql/test/data/warehouse/dest1
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: dest1
@@ -144,7 +140,7 @@
Move Operator
tables:
replace: true
- source: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1604556353/10000
+ source: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/856054437/10000
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -158,10 +154,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/pchakka/workspace/oshive/build/ql/test/data/warehouse/dest1
+ location file:/Users/char/Documents/workspace/Hive-460/build/ql/test/data/warehouse/dest1
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: dest1
- tmp directory: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1604556353/10001
+ tmp directory: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/856054437/10001
query: FROM srcpart src1 JOIN src src2 ON (src1.key = src2.key)
@@ -171,7 +167,7 @@
Output: default/dest1
query: SELECT dest1.* FROM dest1
Input: default/dest1
-Output: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/794663470/10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/2105971410/10000
0 val_0
0 val_0
0 val_0
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/join_thrift.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/join_thrift.q.out?rev=788269&r1=788268&r2=788269&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/join_thrift.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/join_thrift.q.out Thu Jun 25 05:50:50 2009
@@ -32,18 +32,8 @@
type: int
tag: 1
value expressions:
- expr: aint
- type: int
- expr: astring
- type: string
- expr: lint
- type: array<int>
- expr: lstring
- type: array<string>
expr: lintstring
type: array<struct<myint:int,mystring:string,underscore_int:int>>
- expr: mstringstring
- type: map<string,string>
s1
Reduce Output Operator
key expressions:
@@ -57,23 +47,13 @@
value expressions:
expr: aint
type: int
- expr: astring
- type: string
- expr: lint
- type: array<int>
- expr: lstring
- type: array<string>
- expr: lintstring
- type: array<struct<myint:int,mystring:string,underscore_int:int>>
- expr: mstringstring
- type: map<string,string>
Reduce Operator Tree:
Join Operator
condition map:
Inner Join 0 to 1
condition expressions:
- 0 {VALUE._col0} {VALUE._col1} {VALUE._col2} {VALUE._col3} {VALUE._col4} {VALUE._col5}
- 1 {VALUE._col0} {VALUE._col1} {VALUE._col2} {VALUE._col3} {VALUE._col4} {VALUE._col5}
+ 0 {VALUE._col0}
+ 1 {VALUE._col4}
Select Operator
expressions:
expr: _col0
@@ -97,7 +77,7 @@
JOIN src_thrift s2
ON s1.aint = s2.aint
Input: default/src_thrift
-Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1473150956/10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1144800345/10000
-1952710710 [{"myint":25,"mystring":"125","underscore_int":5}]
-1461153973 [{"myint":49,"mystring":"343","underscore_int":7}]
-751827638 [{"myint":4,"mystring":"8","underscore_int":2}]
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_clusterby.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_clusterby.q.out?rev=788269&r1=788268&r2=788269&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_clusterby.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_clusterby.q.out Thu Jun 25 05:50:50 2009
@@ -56,7 +56,7 @@
query: SELECT * FROM SRC x where x.key = 10 CLUSTER BY x.key
Input: default/src
-Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/241519225/10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/673778413/10000
10 val_10
query: EXPLAIN
SELECT x.key, x.value as v1, y.key FROM SRC x JOIN SRC y ON (x.key = y.key) where x.key = 20 CLUSTER BY v1
@@ -85,8 +85,6 @@
value expressions:
expr: key
type: string
- expr: value
- type: string
x
Filter Operator
predicate:
@@ -112,7 +110,7 @@
Inner Join 0 to 1
condition expressions:
0 {VALUE._col0} {VALUE._col1}
- 1 {VALUE._col0} {VALUE._col1}
+ 1 {VALUE._col0}
Filter Operator
predicate:
expr: (UDFToDouble(_col0) = UDFToDouble(20))
@@ -136,7 +134,7 @@
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1825740657/10002
+ file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1323731431/10002
Reduce Output Operator
key expressions:
expr: _col1
@@ -169,5 +167,5 @@
query: SELECT x.key, x.value as v1, y.key FROM SRC x JOIN SRC y ON (x.key = y.key) where x.key = 20 CLUSTER BY v1
Input: default/src
-Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1443480977/10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1056466885/10000
20 val_20 20
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_gby_join.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_gby_join.q.out?rev=788269&r1=788268&r2=788269&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_gby_join.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_gby_join.q.out Thu Jun 25 05:50:50 2009
@@ -83,7 +83,7 @@
Inner Join 0 to 1
condition expressions:
0 {VALUE._col0} {VALUE._col1}
- 1 {VALUE._col0} {VALUE._col1}
+ 1 {VALUE._col0}
Filter Operator
predicate:
expr: ((((_col0 > '20') and ((_col1 < 'val_50') or (_col0 > '2'))) and ((_col2 > '50') or (_col0 < '50'))) and (_col2 <> '4'))
@@ -110,7 +110,7 @@
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1901853163/10002
+ file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1497686794/10002
Reduce Output Operator
key expressions:
expr: _col0
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_join2.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_join2.q.out?rev=788269&r1=788268&r2=788269&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_join2.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_join2.q.out Thu Jun 25 05:50:50 2009
@@ -147,15 +147,13 @@
value expressions:
expr: _col0
type: string
- expr: _col1
- type: string
Reduce Operator Tree:
Join Operator
condition map:
Inner Join 0 to 1
condition expressions:
0 {VALUE._col0} {VALUE._col1} {VALUE._col2} {VALUE._col3}
- 1 {VALUE._col0} {VALUE._col1}
+ 1 {VALUE._col0}
Filter Operator
predicate:
expr: (((((_col2 <> '311') and ((_col3 <> 'val_50') or (_col2 > '1'))) and ((_col0 <> '10') or (_col2 <> '10'))) and (_col0 <> '14')) and (sqrt(UDFToDouble(_col4)) <> UDFToDouble(13)))
@@ -189,7 +187,7 @@
ON src1.c2 = src3.c6
WHERE src1.c1 <> '311' and (src1.c2 <> 'val_50' or src1.c1 > '1') and (src2.c3 <> '10' or src1.c1 <> '10') and (src2.c3 <> '14') and (sqrt(src3.c5) <> 13)
Input: default/src
-Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1480187717/10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/976262349/10000
0 val_0
0 val_0
0 val_0
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_join3.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_join3.q.out?rev=788269&r1=788268&r2=788269&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_join3.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_join3.q.out Thu Jun 25 05:50:50 2009
@@ -115,7 +115,7 @@
condition expressions:
0 {VALUE._col0} {VALUE._col1}
1 {VALUE._col0} {VALUE._col1}
- 2 {VALUE._col0} {VALUE._col1}
+ 2 {VALUE._col0}
Filter Operator
predicate:
expr: (((((_col0 > '0') and ((_col1 <> 'val_500') or (_col0 > '1'))) and ((_col2 > '10') or (_col0 <> '10'))) and (_col2 <> '4')) and (_col4 <> '1'))
@@ -149,7 +149,7 @@
ON src1.c1 = src3.c5
WHERE src1.c1 > '0' and (src1.c2 <> 'val_500' or src1.c1 > '1') and (src2.c3 > '10' or src1.c1 <> '10') and (src2.c3 <> '4') and (src3.c5 <> '1')
Input: default/src
-Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1778414382/10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1296260582/10000
100 val_100
100 val_100
100 val_100
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_multi_insert.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_multi_insert.q.out?rev=788269&r1=788268&r2=788269&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_multi_insert.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_multi_insert.q.out Thu Jun 25 05:50:50 2009
@@ -34,11 +34,6 @@
expr: key
type: string
tag: 1
- value expressions:
- expr: key
- type: string
- expr: value
- type: string
a
Reduce Output Operator
key expressions:
@@ -60,7 +55,7 @@
Inner Join 0 to 1
condition expressions:
0 {VALUE._col0} {VALUE._col1}
- 1 {VALUE._col0} {VALUE._col1}
+ 1
Filter Operator
predicate:
expr: (UDFToDouble(_col0) < UDFToDouble(100))
@@ -196,7 +191,7 @@
Output: ../build/ql/test/data/warehouse/mi4.out
query: SELECT mi1.* FROM mi1
Input: default/mi1
-Output: file:/data/users/njain/hive4/hive4/build/ql/tmp/1767221832/10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1556379466/10000
0 val_0
0 val_0
0 val_0
@@ -347,7 +342,7 @@
98 val_98
query: SELECT mi2.* FROM mi2
Input: default/mi2
-Output: file:/data/users/njain/hive4/hive4/build/ql/tmp/255224107/10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1335038556/10000
100 val_100
100 val_100
100 val_100
@@ -561,7 +556,7 @@
199 val_199
query: SELECT mi3.* FROM mi3
Input: default/mi3/ds=2008-04-08/hr=12
-Output: file:/data/users/njain/hive4/hive4/build/ql/tmp/928924656/10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/584372656/10000
200 2008-04-08 12
200 2008-04-08 12
200 2008-04-08 12