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/15 07:43:29 UTC
svn commit: r784656 [7/30] - in /hadoop/hive/trunk: ./
common/src/java/org/apache/hadoop/hive/conf/
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/or...
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=784656&r1=784655&r2=784656&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 Mon Jun 15 05:43:22 2009
@@ -31,12 +31,12 @@
File Output Operator
compressed: false
GlobalTableId: 0
- directory: file:/data/users/njain/hive2/hive2/build/ql/tmp/652574121/10005
+ directory: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1684107982/10003
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
properties:
- columns temporarycol0,temporarycol1,temporarycol2,temporarycol3
+ columns _col0,_col1,_col2,_col3
columns.types string,string,string,string
Local Work:
Map Reduce Local Work
@@ -59,18 +59,18 @@
File Output Operator
compressed: false
GlobalTableId: 0
- directory: file:/data/users/njain/hive2/hive2/build/ql/tmp/652574121/10005
+ directory: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1684107982/10003
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
properties:
- columns temporarycol0,temporarycol1,temporarycol2,temporarycol3
+ columns _col0,_col1,_col2,_col3
columns.types string,string,string,string
Needs Tagging: false
Path -> Alias:
- file:/data/users/njain/hive2/hive2/build/ql/test/data/warehouse/src
+ file:/Users/char/Documents/workspace/Hive-460/build/ql/test/data/warehouse/src
Path -> Partition:
- file:/data/users/njain/hive2/hive2/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
@@ -85,21 +85,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/njain/hive2/hive2/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/njain/hive2/hive2/build/ql/tmp/652574121/10005
+ file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1684107982/10003
Select Operator
Common Join Operator
condition map:
Inner Join 0 to 1
condition expressions:
- 0 {2} {3} {0} {1}
- 1 {0} {1} {2}
+ 0 {_col2} {_col3} {_col0} {_col1}
+ 1 {key} {value} {ds} {hr}
keys:
0
1
@@ -107,13 +107,13 @@
File Output Operator
compressed: false
GlobalTableId: 0
- directory: file:/data/users/njain/hive2/hive2/build/ql/tmp/652574121/10004
+ directory: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1684107982/10002
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
properties:
- columns temporarycol0,temporarycol1,temporarycol2,temporarycol3,temporarycol4,temporarycol5,temporarycol6
- columns.types string,string,string,string,string,string,string
+ 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:
@@ -122,72 +122,64 @@
limit: -1
Alias -> Map Local Operator Tree:
z
- Select Operator
- expressions:
- expr: value
- type: string
- expr: hr
- type: string
- expr: ds
- type: string
+ Filter Operator
+ predicate:
+ expr: (ds = '2008-04-08')
+ type: boolean
Filter Operator
predicate:
- expr: (2 = '2008-04-08')
+ expr: (UDFToDouble(hr) = UDFToDouble(11))
type: boolean
- Filter Operator
- predicate:
- expr: (UDFToDouble(1) = UDFToDouble(11))
- type: boolean
- Common Join Operator
- condition map:
- Inner Join 0 to 1
- condition expressions:
- 0 {2} {3} {0} {1}
- 1 {0} {1} {2}
- keys:
- 0
- 1
- Position of Big Table: 0
- File Output Operator
- compressed: false
- GlobalTableId: 0
- directory: file:/data/users/njain/hive2/hive2/build/ql/tmp/652574121/10004
- table:
- input format: org.apache.hadoop.mapred.SequenceFileInputFormat
- output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
- properties:
- columns temporarycol0,temporarycol1,temporarycol2,temporarycol3,temporarycol4,temporarycol5,temporarycol6
- columns.types string,string,string,string,string,string,string
+ 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:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1684107982/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/hive2/hive2/build/ql/tmp/652574121/10005
+ file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1684107982/10003
Path -> Partition:
- file:/data/users/njain/hive2/hive2/build/ql/tmp/652574121/10005
+ file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1684107982/10003
Partition
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
properties:
- columns temporarycol0,temporarycol1,temporarycol2,temporarycol3
+ columns _col0,_col1,_col2,_col3
columns.types string,string,string,string
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/njain/hive2/hive2/build/ql/tmp/652574121/10004
+ file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1684107982/10002
Select Operator
Select Operator
expressions:
- expr: 2
+ expr: _col2
type: string
- expr: 4
+ expr: _col5
type: string
- expr: 1
+ expr: _col1
type: string
File Output Operator
compressed: false
GlobalTableId: 1
- directory: file:/data/users/njain/hive2/hive2/build/ql/tmp/88943465/10002
+ directory: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1448849776/10000
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -201,27 +193,27 @@
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/hive2/hive2/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/njain/hive2/hive2/build/ql/tmp/652574121/10004
+ file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1684107982/10002
Path -> Partition:
- file:/data/users/njain/hive2/hive2/build/ql/tmp/652574121/10004
+ file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1684107982/10002
Partition
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
properties:
- columns temporarycol0,temporarycol1,temporarycol2,temporarycol3,temporarycol4,temporarycol5,temporarycol6
- columns.types string,string,string,string,string,string,string
+ columns _col0,_col1,_col2,_col3,_col4,_col5,_col6,_col7
+ columns.types string,string,string,string,string,string,string,string
Stage: Stage-0
Move Operator
tables:
replace: true
- source: file:/data/users/njain/hive2/hive2/build/ql/tmp/88943465/10002
+ source: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1448849776/10000
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -235,10 +227,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/hive2/hive2/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/njain/hive2/hive2/build/ql/tmp/88943465/10003
+ tmp directory: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1448849776/10001
query: INSERT OVERWRITE TABLE dest_j1
@@ -251,7 +243,7 @@
Output: default/dest_j1
query: select * from dest_j1 x order by x.key
Input: default/dest_j1
-Output: file:/data/users/njain/hive2/hive2/build/ql/tmp/1264508144/10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1210500588/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=784656&r1=784655&r2=784656&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 Mon Jun 15 05:43:22 2009
@@ -30,12 +30,12 @@
File Output Operator
compressed: false
GlobalTableId: 0
- directory: file:/data/users/njain/hive2/hive2/build/ql/tmp/872232858/10004
+ directory: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/409684435/10002
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
properties:
- columns temporarycol0,temporarycol1,temporarycol2,temporarycol3
+ columns _col0,_col1,_col2,_col3
columns.types string,string,string,string
Local Work:
Map Reduce Local Work
@@ -58,18 +58,18 @@
File Output Operator
compressed: false
GlobalTableId: 0
- directory: file:/data/users/njain/hive2/hive2/build/ql/tmp/872232858/10004
+ directory: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/409684435/10002
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
properties:
- columns temporarycol0,temporarycol1,temporarycol2,temporarycol3
+ columns _col0,_col1,_col2,_col3
columns.types string,string,string,string
Needs Tagging: false
Path -> Alias:
- file:/data/users/njain/hive2/hive2/build/ql/test/data/warehouse/src
+ file:/Users/char/Documents/workspace/Hive-460/build/ql/test/data/warehouse/src
Path -> Partition:
- file:/data/users/njain/hive2/hive2/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/njain/hive2/hive2/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
@@ -92,64 +92,58 @@
Map Reduce
Alias -> Map Operator Tree:
z
- Select Operator
- expressions:
- expr: value
- type: string
- expr: hr
- type: string
- expr: ds
- type: string
+ Filter Operator
+ predicate:
+ expr: (ds = '2008-04-08')
+ type: boolean
Filter Operator
predicate:
- expr: (2 = '2008-04-08')
+ expr: (UDFToDouble(hr) = UDFToDouble(11))
type: boolean
- Filter Operator
- predicate:
- expr: (UDFToDouble(1) = UDFToDouble(11))
- type: boolean
- Reduce Output Operator
- key expressions:
- expr: 0
- type: string
- sort order: +
- Map-reduce partition columns:
- expr: 0
- type: string
- tag: 1
- value expressions:
- expr: 0
- type: string
- expr: 1
- type: string
- expr: 2
- type: string
- file:/data/users/njain/hive2/hive2/build/ql/tmp/872232858/10004
+ 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:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/409684435/10002
Select Operator
Reduce Output Operator
key expressions:
- expr: 1
+ expr: _col1
type: string
sort order: +
Map-reduce partition columns:
- expr: 1
+ expr: _col1
type: string
tag: 0
value expressions:
- expr: 2
+ expr: _col2
type: string
- expr: 3
+ expr: _col3
type: string
- expr: 0
+ expr: _col0
type: string
- expr: 1
+ expr: _col1
type: string
Needs Tagging: true
Path -> Alias:
- file:/data/users/njain/hive2/hive2/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11
- file:/data/users/njain/hive2/hive2/build/ql/tmp/872232858/10004
+ 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/409684435/10002
Path -> Partition:
- file:/data/users/njain/hive2/hive2/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
@@ -168,36 +162,36 @@
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/hive2/hive2/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/njain/hive2/hive2/build/ql/tmp/872232858/10004
+ file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/409684435/10002
Partition
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
properties:
- columns temporarycol0,temporarycol1,temporarycol2,temporarycol3
+ columns _col0,_col1,_col2,_col3
columns.types string,string,string,string
Reduce Operator Tree:
Join Operator
condition map:
Inner Join 0 to 1
condition expressions:
- 0 {VALUE.0} {VALUE.1} {VALUE.2} {VALUE.3}
- 1 {VALUE.0} {VALUE.1} {VALUE.2}
+ 0 {VALUE._col0} {VALUE._col1} {VALUE._col2} {VALUE._col3}
+ 1 {VALUE._col0} {VALUE._col1} {VALUE._col2} {VALUE._col3}
Select Operator
expressions:
- expr: 2
+ expr: _col2
type: string
- expr: 4
+ expr: _col5
type: string
- expr: 1
+ expr: _col1
type: string
File Output Operator
compressed: false
GlobalTableId: 1
- directory: file:/data/users/njain/hive2/hive2/build/ql/tmp/181195113/10002
+ directory: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1859464866/10000
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -211,7 +205,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/hive2/hive2/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
@@ -219,7 +213,7 @@
Move Operator
tables:
replace: true
- source: file:/data/users/njain/hive2/hive2/build/ql/tmp/181195113/10002
+ source: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1859464866/10000
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -233,10 +227,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/hive2/hive2/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/njain/hive2/hive2/build/ql/tmp/181195113/10003
+ tmp directory: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1859464866/10001
query: INSERT OVERWRITE TABLE dest_j1
@@ -249,7 +243,7 @@
Output: default/dest_j1
query: select * from dest_j1 x order by x.key
Input: default/dest_j1
-Output: file:/data/users/njain/hive2/hive2/build/ql/tmp/700555840/10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1895295754/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=784656&r1=784655&r2=784656&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 Mon Jun 15 05:43:22 2009
@@ -37,7 +37,7 @@
condition map:
Inner Join 0 to 1
condition expressions:
- 0 {0} {1}
+ 0 {_col0} {_col1}
1 {key} {value}
keys:
0
@@ -46,12 +46,12 @@
File Output Operator
compressed: false
GlobalTableId: 0
- directory: file:/data/users/njain/hive2/hive2/build/ql/tmp/1235944960/10002
+ directory: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/785300879/10002
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
properties:
- columns temporarycol0,temporarycol1,temporarycol2,temporarycol3
+ columns _col0,_col1,_col2,_col3
columns.types string,string,string,string
null-subquery2:subq1-subquery2:x1
Filter Operator
@@ -69,7 +69,7 @@
condition map:
Inner Join 0 to 1
condition expressions:
- 0 {0} {1}
+ 0 {_col0} {_col1}
1 {key} {value}
keys:
0
@@ -78,12 +78,12 @@
File Output Operator
compressed: false
GlobalTableId: 0
- directory: file:/data/users/njain/hive2/hive2/build/ql/tmp/1235944960/10002
+ directory: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/785300879/10002
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
properties:
- columns temporarycol0,temporarycol1,temporarycol2,temporarycol3
+ columns _col0,_col1,_col2,_col3
columns.types string,string,string,string
Local Work:
Map Reduce Local Work
@@ -97,7 +97,7 @@
condition map:
Inner Join 0 to 1
condition expressions:
- 0 {0} {1}
+ 0 {_col0} {_col1}
1 {key} {value}
keys:
0
@@ -106,18 +106,18 @@
File Output Operator
compressed: false
GlobalTableId: 0
- directory: file:/data/users/njain/hive2/hive2/build/ql/tmp/1235944960/10002
+ directory: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/785300879/10002
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
properties:
- columns temporarycol0,temporarycol1,temporarycol2,temporarycol3
+ columns _col0,_col1,_col2,_col3
columns.types string,string,string,string
Needs Tagging: false
Path -> Alias:
- file:/data/users/njain/hive2/hive2/build/ql/test/data/warehouse/src
+ file:/Users/char/Documents/workspace/Hive-460/build/ql/test/data/warehouse/src
Path -> Partition:
- file:/data/users/njain/hive2/hive2/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
@@ -132,27 +132,27 @@
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/hive2/hive2/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/njain/hive2/hive2/build/ql/tmp/1235944960/10002
+ file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/785300879/10002
Select Operator
Select Operator
expressions:
- expr: 2
+ expr: _col2
type: string
- expr: 3
+ expr: _col3
type: string
- expr: 1
+ expr: _col1
type: string
File Output Operator
compressed: false
GlobalTableId: 1
- directory: file:/data/users/njain/hive2/hive2/build/ql/tmp/1664619970/10000
+ directory: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/907897578/10000
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -166,27 +166,27 @@
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/hive2/hive2/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/njain/hive2/hive2/build/ql/tmp/1235944960/10002
+ file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/785300879/10002
Path -> Partition:
- file:/data/users/njain/hive2/hive2/build/ql/tmp/1235944960/10002
+ file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/785300879/10002
Partition
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
properties:
- columns temporarycol0,temporarycol1,temporarycol2,temporarycol3
+ columns _col0,_col1,_col2,_col3
columns.types string,string,string,string
Stage: Stage-0
Move Operator
tables:
replace: true
- source: file:/data/users/njain/hive2/hive2/build/ql/tmp/1664619970/10000
+ source: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/907897578/10000
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -200,10 +200,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/hive2/hive2/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/njain/hive2/hive2/build/ql/tmp/1664619970/10001
+ tmp directory: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/907897578/10001
query: INSERT OVERWRITE TABLE dest_j1
@@ -219,7 +219,7 @@
Output: default/dest_j1
query: select * from dest_j1 x order by x.key
Input: default/dest_j1
-Output: file:/data/users/njain/hive2/hive2/build/ql/tmp/2142624697/10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1160963373/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=784656&r1=784655&r2=784656&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 Mon Jun 15 05:43:22 2009
@@ -27,38 +27,38 @@
Map Reduce
Alias -> Map Operator Tree:
null-subquery1:subq1-subquery1:x
- Select Operator
- expressions:
- expr: key
- type: string
- Filter Operator
- predicate:
- expr: (UDFToDouble(0) < UDFToDouble(20))
- type: boolean
+ Filter Operator
+ predicate:
+ expr: (UDFToDouble(key) < UDFToDouble(20))
+ type: boolean
+ Select Operator
+ expressions:
+ expr: key
+ type: string
Group By Operator
aggregations:
expr: count(1)
keys:
- expr: 0
+ expr: key
type: string
mode: hash
Reduce Output Operator
key expressions:
- expr: 0
+ expr: _col0
type: string
sort order: +
Map-reduce partition columns:
- expr: 0
+ expr: _col0
type: string
tag: -1
value expressions:
- expr: 1
+ expr: _col1
type: bigint
Needs Tagging: false
Path -> Alias:
- file:/data/users/njain/hive2/hive2/build/ql/test/data/warehouse/src
+ file:/Users/char/Documents/workspace/Hive-460/build/ql/test/data/warehouse/src
Path -> Partition:
- file:/data/users/njain/hive2/hive2/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
@@ -73,46 +73,46 @@
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/hive2/hive2/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:
Group By Operator
aggregations:
- expr: count(VALUE.0)
+ expr: count(VALUE._col0)
keys:
- expr: KEY.0
+ expr: KEY._col0
type: string
mode: mergepartial
Select Operator
expressions:
- expr: 0
+ expr: _col0
type: string
- expr: 1
+ expr: _col1
type: bigint
File Output Operator
compressed: false
GlobalTableId: 0
- directory: file:/data/users/njain/hive2/hive2/build/ql/tmp/226015867/10004
+ directory: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/168430726/10002
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
properties:
name binary_table
- serialization.ddl struct binary_table { string temporarycol0, i64 temporarycol1}
+ serialization.ddl struct binary_table { string _col0, i64 _col1}
serialization.format com.facebook.thrift.protocol.TBinaryProtocol
name: binary_table
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/njain/hive2/hive2/build/ql/tmp/226015867/10004
+ file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/168430726/10002
Union
Common Join Operator
condition map:
Inner Join 0 to 1
condition expressions:
- 0 {0} {1}
+ 0 {_col0} {_col1}
1 {key} {value}
keys:
0
@@ -121,20 +121,20 @@
File Output Operator
compressed: false
GlobalTableId: 0
- directory: file:/data/users/njain/hive2/hive2/build/ql/tmp/226015867/10005
+ directory: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/168430726/10003
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
properties:
- columns temporarycol0,temporarycol1,temporarycol2,temporarycol3
+ columns _col0,_col1,_col2,_col3
columns.types string,bigint,string,string
- file:/data/users/njain/hive2/hive2/build/ql/tmp/226015867/10006
+ file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/168430726/10004
Union
Common Join Operator
condition map:
Inner Join 0 to 1
condition expressions:
- 0 {0} {1}
+ 0 {_col0} {_col1}
1 {key} {value}
keys:
0
@@ -143,12 +143,12 @@
File Output Operator
compressed: false
GlobalTableId: 0
- directory: file:/data/users/njain/hive2/hive2/build/ql/tmp/226015867/10005
+ directory: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/168430726/10003
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
properties:
- columns temporarycol0,temporarycol1,temporarycol2,temporarycol3
+ columns _col0,_col1,_col2,_col3
columns.types string,bigint,string,string
Local Work:
Map Reduce Local Work
@@ -162,7 +162,7 @@
condition map:
Inner Join 0 to 1
condition expressions:
- 0 {0} {1}
+ 0 {_col0} {_col1}
1 {key} {value}
keys:
0
@@ -171,64 +171,64 @@
File Output Operator
compressed: false
GlobalTableId: 0
- directory: file:/data/users/njain/hive2/hive2/build/ql/tmp/226015867/10005
+ directory: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/168430726/10003
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
properties:
- columns temporarycol0,temporarycol1,temporarycol2,temporarycol3
+ columns _col0,_col1,_col2,_col3
columns.types string,bigint,string,string
Needs Tagging: false
Path -> Alias:
- file:/data/users/njain/hive2/hive2/build/ql/tmp/226015867/10004
- file:/data/users/njain/hive2/hive2/build/ql/tmp/226015867/10006
+ file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/168430726/10002
+ file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/168430726/10004
Path -> Partition:
- file:/data/users/njain/hive2/hive2/build/ql/tmp/226015867/10004
+ file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/168430726/10002
Partition
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
properties:
name binary_table
- serialization.ddl struct binary_table { string temporarycol0, i64 temporarycol1}
+ serialization.ddl struct binary_table { string _col0, i64 _col1}
serialization.format com.facebook.thrift.protocol.TBinaryProtocol
name: binary_table
- file:/data/users/njain/hive2/hive2/build/ql/tmp/226015867/10006
+ file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/168430726/10004
Partition
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
properties:
name binary_table
- serialization.ddl struct binary_table { string temporarycol0, i64 temporarycol1}
+ serialization.ddl struct binary_table { string _col0, i64 _col1}
serialization.format com.facebook.thrift.protocol.TBinaryProtocol
name: binary_table
Stage: Stage-3
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/njain/hive2/hive2/build/ql/tmp/226015867/10005
+ file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/168430726/10003
Select Operator
Select Operator
expressions:
- expr: 2
+ expr: _col2
type: string
- expr: 3
+ expr: _col3
type: string
- expr: 1
+ expr: _col1
type: bigint
Select Operator
expressions:
- expr: 0
+ expr: _col0
type: string
- expr: 1
+ expr: _col1
type: string
- expr: UDFToInteger(2)
+ expr: UDFToInteger(_col2)
type: int
File Output Operator
compressed: false
GlobalTableId: 1
- directory: file:/data/users/njain/hive2/hive2/build/ql/tmp/933155217/10002
+ directory: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/366087396/10000
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -242,27 +242,27 @@
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/hive2/hive2/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/njain/hive2/hive2/build/ql/tmp/226015867/10005
+ file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/168430726/10003
Path -> Partition:
- file:/data/users/njain/hive2/hive2/build/ql/tmp/226015867/10005
+ file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/168430726/10003
Partition
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
properties:
- columns temporarycol0,temporarycol1,temporarycol2,temporarycol3
+ columns _col0,_col1,_col2,_col3
columns.types string,bigint,string,string
Stage: Stage-0
Move Operator
tables:
replace: true
- source: file:/data/users/njain/hive2/hive2/build/ql/tmp/933155217/10002
+ source: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/366087396/10000
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -276,47 +276,47 @@
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/hive2/hive2/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/njain/hive2/hive2/build/ql/tmp/933155217/10003
+ tmp directory: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/366087396/10001
Stage: Stage-4
Map Reduce
Alias -> Map Operator Tree:
null-subquery2:subq1-subquery2:x1
- Select Operator
- expressions:
- expr: key
- type: string
- Filter Operator
- predicate:
- expr: (UDFToDouble(0) > UDFToDouble(100))
- type: boolean
+ Filter Operator
+ predicate:
+ expr: (UDFToDouble(key) > UDFToDouble(100))
+ type: boolean
+ Select Operator
+ expressions:
+ expr: key
+ type: string
Group By Operator
aggregations:
expr: count(1)
keys:
- expr: 0
+ expr: key
type: string
mode: hash
Reduce Output Operator
key expressions:
- expr: 0
+ expr: _col0
type: string
sort order: +
Map-reduce partition columns:
- expr: 0
+ expr: _col0
type: string
tag: -1
value expressions:
- expr: 1
+ expr: _col1
type: bigint
Needs Tagging: false
Path -> Alias:
- file:/data/users/njain/hive2/hive2/build/ql/test/data/warehouse/src
+ file:/Users/char/Documents/workspace/Hive-460/build/ql/test/data/warehouse/src
Path -> Partition:
- file:/data/users/njain/hive2/hive2/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
@@ -331,33 +331,33 @@
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/hive2/hive2/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:
Group By Operator
aggregations:
- expr: count(VALUE.0)
+ expr: count(VALUE._col0)
keys:
- expr: KEY.0
+ expr: KEY._col0
type: string
mode: mergepartial
Select Operator
expressions:
- expr: 0
+ expr: _col0
type: string
- expr: 1
+ expr: _col1
type: bigint
File Output Operator
compressed: false
GlobalTableId: 0
- directory: file:/data/users/njain/hive2/hive2/build/ql/tmp/226015867/10006
+ directory: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/168430726/10004
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
properties:
name binary_table
- serialization.ddl struct binary_table { string temporarycol0, i64 temporarycol1}
+ serialization.ddl struct binary_table { string _col0, i64 _col1}
serialization.format com.facebook.thrift.protocol.TBinaryProtocol
name: binary_table
@@ -375,7 +375,7 @@
Output: default/dest_j1
query: select * from dest_j1 x order by x.key
Input: default/dest_j1
-Output: file:/data/users/njain/hive2/hive2/build/ql/tmp/247016879/10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1938414388/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=784656&r1=784655&r2=784656&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 Mon Jun 15 05:43:22 2009
@@ -73,15 +73,15 @@
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/njain/hive1/hive1/build/ql/tmp/1050118775/10002
+ file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/596423728/10002
Select Operator
Select Operator
expressions:
- expr: 0
+ expr: _col0
type: int
- expr: 1
+ expr: _col1
type: int
- expr: 3
+ expr: _col3
type: int
File Output Operator
compressed: false
@@ -111,7 +111,7 @@
Output: default/dest_j1
query: select * from dest_j1 x order by x.key
Input: default/dest_j1
-Output: file:/data/users/njain/hive1/hive1/build/ql/tmp/912828284/10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/976050144/10000
0 3 3
2 1 1
4 1 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=784656&r1=784655&r2=784656&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 Mon Jun 15 05:43:22 2009
@@ -37,17 +37,17 @@
type: string
Reduce Output Operator
key expressions:
- expr: 0
+ expr: _col0
type: string
sort order: +
Map-reduce partition columns:
- expr: 0
+ expr: _col0
type: string
tag: 0
value expressions:
- expr: 0
+ expr: _col0
type: string
- expr: 1
+ expr: _col1
type: string
c:b:src2
Filter Operator
@@ -62,54 +62,54 @@
type: string
Reduce Output Operator
key expressions:
- expr: 0
+ expr: _col0
type: string
sort order: +
Map-reduce partition columns:
- expr: 0
+ expr: _col0
type: string
tag: 1
value expressions:
- expr: 0
+ expr: _col0
type: string
- expr: 1
+ expr: _col1
type: string
Reduce Operator Tree:
Join Operator
condition map:
Left Outer Join0 to 1
condition expressions:
- 0 {VALUE.0} {VALUE.1}
- 1 {VALUE.0} {VALUE.1}
+ 0 {VALUE._col0} {VALUE._col1}
+ 1 {VALUE._col0} {VALUE._col1}
Select Operator
expressions:
- expr: 0
+ expr: _col0
type: string
- expr: 1
+ expr: _col1
type: string
- expr: 2
+ expr: _col2
type: string
- expr: 3
+ expr: _col3
type: string
Select Operator
expressions:
- expr: 0
+ expr: _col0
type: string
- expr: 1
+ expr: _col1
type: string
- expr: 2
+ expr: _col2
type: string
- expr: 3
+ expr: _col3
type: string
Select Operator
expressions:
- expr: UDFToInteger(0)
+ expr: UDFToInteger(_col0)
type: int
- expr: 1
+ expr: _col1
type: string
- expr: UDFToInteger(2)
+ expr: UDFToInteger(_col2)
type: int
- expr: 3
+ expr: _col3
type: string
File Output Operator
compressed: false
@@ -148,7 +148,7 @@
Output: default/dest1
query: SELECT dest1.* FROM dest1
Input: default/dest1
-Output: /data/users/athusoo/commits/hive_trunk_ws8/ql/../build/ql/tmp/897019709/831036263.10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/432444875/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=784656&r1=784655&r2=784656&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 Mon Jun 15 05:43:22 2009
@@ -37,17 +37,17 @@
type: string
Reduce Output Operator
key expressions:
- expr: 0
+ expr: _col0
type: string
sort order: +
Map-reduce partition columns:
- expr: 0
+ expr: _col0
type: string
tag: 0
value expressions:
- expr: 0
+ expr: _col0
type: string
- expr: 1
+ expr: _col1
type: string
c:b:src2
Filter Operator
@@ -62,54 +62,54 @@
type: string
Reduce Output Operator
key expressions:
- expr: 0
+ expr: _col0
type: string
sort order: +
Map-reduce partition columns:
- expr: 0
+ expr: _col0
type: string
tag: 1
value expressions:
- expr: 0
+ expr: _col0
type: string
- expr: 1
+ expr: _col1
type: string
Reduce Operator Tree:
Join Operator
condition map:
Right Outer Join0 to 1
condition expressions:
- 0 {VALUE.0} {VALUE.1}
- 1 {VALUE.0} {VALUE.1}
+ 0 {VALUE._col0} {VALUE._col1}
+ 1 {VALUE._col0} {VALUE._col1}
Select Operator
expressions:
- expr: 0
+ expr: _col0
type: string
- expr: 1
+ expr: _col1
type: string
- expr: 2
+ expr: _col2
type: string
- expr: 3
+ expr: _col3
type: string
Select Operator
expressions:
- expr: 0
+ expr: _col0
type: string
- expr: 1
+ expr: _col1
type: string
- expr: 2
+ expr: _col2
type: string
- expr: 3
+ expr: _col3
type: string
Select Operator
expressions:
- expr: UDFToInteger(0)
+ expr: UDFToInteger(_col0)
type: int
- expr: 1
+ expr: _col1
type: string
- expr: UDFToInteger(2)
+ expr: UDFToInteger(_col2)
type: int
- expr: 3
+ expr: _col3
type: string
File Output Operator
compressed: false
@@ -148,7 +148,7 @@
Output: default/dest1
query: SELECT dest1.* FROM dest1
Input: default/dest1
-Output: /data/users/athusoo/commits/hive_trunk_ws8/ql/../build/ql/tmp/229545052/1184877063.10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/253563009/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=784656&r1=784655&r2=784656&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 Mon Jun 15 05:43:22 2009
@@ -37,17 +37,17 @@
type: string
Reduce Output Operator
key expressions:
- expr: 0
+ expr: _col0
type: string
sort order: +
Map-reduce partition columns:
- expr: 0
+ expr: _col0
type: string
tag: 0
value expressions:
- expr: 0
+ expr: _col0
type: string
- expr: 1
+ expr: _col1
type: string
c:b:src2
Filter Operator
@@ -62,54 +62,54 @@
type: string
Reduce Output Operator
key expressions:
- expr: 0
+ expr: _col0
type: string
sort order: +
Map-reduce partition columns:
- expr: 0
+ expr: _col0
type: string
tag: 1
value expressions:
- expr: 0
+ expr: _col0
type: string
- expr: 1
+ expr: _col1
type: string
Reduce Operator Tree:
Join Operator
condition map:
Outer Join 0 to 1
condition expressions:
- 0 {VALUE.0} {VALUE.1}
- 1 {VALUE.0} {VALUE.1}
+ 0 {VALUE._col0} {VALUE._col1}
+ 1 {VALUE._col0} {VALUE._col1}
Select Operator
expressions:
- expr: 0
+ expr: _col0
type: string
- expr: 1
+ expr: _col1
type: string
- expr: 2
+ expr: _col2
type: string
- expr: 3
+ expr: _col3
type: string
Select Operator
expressions:
- expr: 0
+ expr: _col0
type: string
- expr: 1
+ expr: _col1
type: string
- expr: 2
+ expr: _col2
type: string
- expr: 3
+ expr: _col3
type: string
Select Operator
expressions:
- expr: UDFToInteger(0)
+ expr: UDFToInteger(_col0)
type: int
- expr: 1
+ expr: _col1
type: string
- expr: UDFToInteger(2)
+ expr: UDFToInteger(_col2)
type: int
- expr: 3
+ expr: _col3
type: string
File Output Operator
compressed: false
@@ -148,7 +148,7 @@
Output: default/dest1
query: SELECT dest1.* FROM dest1
Input: default/dest1
-Output: /data/users/athusoo/commits/hive_trunk_ws8/ql/../build/ql/tmp/674683169/66863860.10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1692074558/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/join7.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/join7.q.out?rev=784656&r1=784655&r2=784656&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/join7.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/join7.q.out Mon Jun 15 05:43:22 2009
@@ -42,17 +42,17 @@
type: string
Reduce Output Operator
key expressions:
- expr: 0
+ expr: _col0
type: string
sort order: +
Map-reduce partition columns:
- expr: 0
+ expr: _col0
type: string
tag: 0
value expressions:
- expr: 0
+ expr: _col0
type: string
- expr: 1
+ expr: _col1
type: string
c:b:src2
Filter Operator
@@ -67,17 +67,17 @@
type: string
Reduce Output Operator
key expressions:
- expr: 0
+ expr: _col0
type: string
sort order: +
Map-reduce partition columns:
- expr: 0
+ expr: _col0
type: string
tag: 1
value expressions:
- expr: 0
+ expr: _col0
type: string
- expr: 1
+ expr: _col1
type: string
c:c:src3
Filter Operator
@@ -92,17 +92,17 @@
type: string
Reduce Output Operator
key expressions:
- expr: 0
+ expr: _col0
type: string
sort order: +
Map-reduce partition columns:
- expr: 0
+ expr: _col0
type: string
tag: 2
value expressions:
- expr: 0
+ expr: _col0
type: string
- expr: 1
+ expr: _col1
type: string
Reduce Operator Tree:
Join Operator
@@ -110,50 +110,50 @@
Outer Join 0 to 1
Left Outer Join0 to 2
condition expressions:
- 0 {VALUE.0} {VALUE.1}
- 1 {VALUE.0} {VALUE.1}
- 2 {VALUE.0} {VALUE.1}
+ 0 {VALUE._col0} {VALUE._col1}
+ 1 {VALUE._col0} {VALUE._col1}
+ 2 {VALUE._col0} {VALUE._col1}
Select Operator
expressions:
- expr: 0
+ expr: _col0
type: string
- expr: 1
+ expr: _col1
type: string
- expr: 2
+ expr: _col2
type: string
- expr: 3
+ expr: _col3
type: string
- expr: 4
+ expr: _col4
type: string
- expr: 5
+ expr: _col5
type: string
Select Operator
expressions:
- expr: 0
+ expr: _col0
type: string
- expr: 1
+ expr: _col1
type: string
- expr: 2
+ expr: _col2
type: string
- expr: 3
+ expr: _col3
type: string
- expr: 4
+ expr: _col4
type: string
- expr: 5
+ expr: _col5
type: string
Select Operator
expressions:
- expr: UDFToInteger(0)
+ expr: UDFToInteger(_col0)
type: int
- expr: 1
+ expr: _col1
type: string
- expr: UDFToInteger(2)
+ expr: UDFToInteger(_col2)
type: int
- expr: 3
+ expr: _col3
type: string
- expr: UDFToInteger(4)
+ expr: UDFToInteger(_col4)
type: int
- expr: 5
+ expr: _col5
type: string
File Output Operator
compressed: false
@@ -197,7 +197,7 @@
Output: default/dest1
query: SELECT dest1.* FROM dest1
Input: default/dest1
-Output: /data/users/athusoo/commits/hive_trunk_ws8/ql/../build/ql/tmp/934204295/128575675.10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/2100931525/10000
11 val_11 NULL NULL NULL NULL
12 val_12 NULL NULL NULL NULL
12 val_12 NULL NULL NULL NULL
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/join8.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/join8.q.out?rev=784656&r1=784655&r2=784656&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/join8.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/join8.q.out Mon Jun 15 05:43:22 2009
@@ -37,17 +37,17 @@
type: string
Reduce Output Operator
key expressions:
- expr: 0
+ expr: _col0
type: string
sort order: +
Map-reduce partition columns:
- expr: 0
+ expr: _col0
type: string
tag: 0
value expressions:
- expr: 0
+ expr: _col0
type: string
- expr: 1
+ expr: _col1
type: string
c:b:src2
Filter Operator
@@ -62,58 +62,58 @@
type: string
Reduce Output Operator
key expressions:
- expr: 0
+ expr: _col0
type: string
sort order: +
Map-reduce partition columns:
- expr: 0
+ expr: _col0
type: string
tag: 1
value expressions:
- expr: 0
+ expr: _col0
type: string
- expr: 1
+ expr: _col1
type: string
Reduce Operator Tree:
Join Operator
condition map:
Left Outer Join0 to 1
condition expressions:
- 0 {VALUE.0} {VALUE.1}
- 1 {VALUE.0} {VALUE.1}
+ 0 {VALUE._col0} {VALUE._col1}
+ 1 {VALUE._col0} {VALUE._col1}
Select Operator
expressions:
- expr: 0
+ expr: _col0
type: string
- expr: 1
+ expr: _col1
type: string
- expr: 2
+ expr: _col2
type: string
- expr: 3
+ expr: _col3
type: string
Filter Operator
predicate:
- expr: (2 is null and 0 is not null)
+ expr: (_col2 is null and _col0 is not null)
type: boolean
Select Operator
expressions:
- expr: 0
+ expr: _col0
type: string
- expr: 1
+ expr: _col1
type: string
- expr: 2
+ expr: _col2
type: string
- expr: 3
+ expr: _col3
type: string
Select Operator
expressions:
- expr: UDFToInteger(0)
+ expr: UDFToInteger(_col0)
type: int
- expr: 1
+ expr: _col1
type: string
- expr: UDFToInteger(2)
+ expr: UDFToInteger(_col2)
type: int
- expr: 3
+ expr: _col3
type: string
File Output Operator
compressed: false
@@ -152,7 +152,7 @@
Output: default/dest1
query: SELECT dest1.* FROM dest1
Input: default/dest1
-Output: /data/users/athusoo/commits/hive_trunk_ws8/ql/../build/ql/tmp/106779552/293157937.10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1676684235/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/join9.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/join9.q.out?rev=784656&r1=784655&r2=784656&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 Mon Jun 15 05:43:22 2009
@@ -29,36 +29,30 @@
expr: value
type: string
src1
- Select Operator
- expressions:
+ Reduce Output Operator
+ key expressions:
+ expr: key
+ type: string
+ sort order: +
+ Map-reduce partition columns:
expr: key
type: string
+ tag: 0
+ value expressions:
+ expr: key
+ type: string
+ expr: value
+ type: string
expr: ds
type: string
expr: hr
type: string
- Reduce Output Operator
- key expressions:
- expr: 0
- type: string
- sort order: +
- Map-reduce partition columns:
- expr: 0
- type: string
- tag: 0
- value expressions:
- expr: 0
- type: string
- expr: 1
- type: string
- expr: 2
- type: string
Needs Tagging: true
Path -> Alias:
- file:/data/users/athusoo/commits/hive_trunk_ws8/build/ql/test/data/warehouse/src
- file:/data/users/athusoo/commits/hive_trunk_ws8/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/athusoo/commits/hive_trunk_ws8/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
@@ -73,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/athusoo/commits/hive_trunk_ws8/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/athusoo/commits/hive_trunk_ws8/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
@@ -95,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/athusoo/commits/hive_trunk_ws8/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:
@@ -103,28 +97,28 @@
condition map:
Inner Join 0 to 1
condition expressions:
- 0 {VALUE.0} {VALUE.1} {VALUE.2}
- 1 {VALUE.0} {VALUE.1}
+ 0 {VALUE._col0} {VALUE._col1} {VALUE._col2} {VALUE._col3}
+ 1 {VALUE._col0} {VALUE._col1}
Filter Operator
predicate:
- expr: ((1 = '2008-04-08') and (2 = '12'))
+ expr: ((_col2 = '2008-04-08') and (_col3 = '12'))
type: boolean
Select Operator
expressions:
- expr: 0
+ expr: _col0
type: string
- expr: 4
+ expr: _col5
type: string
Select Operator
expressions:
- expr: UDFToInteger(0)
+ expr: UDFToInteger(_col0)
type: int
- expr: 1
+ expr: _col1
type: string
File Output Operator
compressed: false
GlobalTableId: 1
- directory: /data/users/athusoo/commits/hive_trunk_ws8/ql/../build/ql/tmp/93836917.10000.insclause-0
+ directory: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1807871128/10000
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -138,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/athusoo/commits/hive_trunk_ws8/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
@@ -146,7 +140,7 @@
Move Operator
tables:
replace: true
- source: /data/users/athusoo/commits/hive_trunk_ws8/ql/../build/ql/tmp/93836917.10000.insclause-0
+ source: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1807871128/10000
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -160,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/athusoo/commits/hive_trunk_ws8/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: /data/users/athusoo/commits/hive_trunk_ws8/ql/../build/ql/tmp/93836917.10001
+ tmp directory: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1807871128/10001
query: FROM srcpart src1 JOIN src src2 ON (src1.key = src2.key)
@@ -173,7 +167,7 @@
Output: default/dest1
query: SELECT dest1.* FROM dest1
Input: default/dest1
-Output: /data/users/athusoo/commits/hive_trunk_ws8/ql/../build/ql/tmp/280910510/328815293.10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/2004673341/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=784656&r1=784655&r2=784656&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 Mon Jun 15 05:43:22 2009
@@ -22,55 +22,63 @@
Map Reduce
Alias -> Map Operator Tree:
s2
- Select Operator
- expressions:
+ Reduce Output Operator
+ key expressions:
expr: aint
type: int
+ sort order: +
+ Map-reduce partition columns:
+ expr: aint
+ 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>>
- Reduce Output Operator
- key expressions:
- expr: 0
- type: int
- sort order: +
- Map-reduce partition columns:
- expr: 0
- type: int
- tag: 1
- value expressions:
- expr: 0
- type: int
- expr: 1
- type: array<struct<myint:int,mystring:string,underscore_int:int>>
+ expr: mstringstring
+ type: map<string,string>
s1
- Select Operator
- expressions:
+ Reduce Output Operator
+ key expressions:
+ expr: aint
+ type: int
+ sort order: +
+ Map-reduce partition columns:
+ expr: aint
+ type: int
+ tag: 0
+ value expressions:
expr: aint
type: int
- Reduce Output Operator
- key expressions:
- expr: 0
- type: int
- sort order: +
- Map-reduce partition columns:
- expr: 0
- type: int
- tag: 0
- value expressions:
- expr: 0
- 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.0}
- 1 {VALUE.0} {VALUE.1}
+ 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}
Select Operator
expressions:
- expr: 0
+ expr: _col0
type: int
- expr: 2
+ expr: _col10
type: array<struct<myint:int,mystring:string,underscore_int:int>>
File Output Operator
compressed: false
@@ -89,7 +97,7 @@
JOIN src_thrift s2
ON s1.aint = s2.aint
Input: default/src_thrift
-Output: /data/users/zshao/tools/495-trunk-apache-hive/ql/../build/ql/tmp/1611059524/151199080.10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1473150956/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/mapreduce1.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/mapreduce1.q.out?rev=784656&r1=784655&r2=784656&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/mapreduce1.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/mapreduce1.q.out Mon Jun 15 05:43:22 2009
@@ -59,13 +59,13 @@
Extract
Select Operator
expressions:
- expr: UDFToInteger(0)
+ expr: UDFToInteger(_col0)
type: int
- expr: UDFToInteger(1)
+ expr: UDFToInteger(_col1)
type: int
- expr: UDFToInteger(2)
+ expr: UDFToInteger(_col2)
type: int
- expr: 3
+ expr: _col3
type: string
File Output Operator
compressed: false
@@ -97,7 +97,7 @@
Output: default/dest1
query: SELECT dest1.* FROM dest1
Input: default/dest1
-Output: /data/users/athusoo/commits/hive_trunk_ws8/ql/../build/ql/tmp/215905920/1186087609.10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1089837380/10000
0 0 0 val_0
0 0 0 val_0
0 0 0 val_0