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 [6/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/join18.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/join18.q.out?rev=784656&r1=784655&r2=784656&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/join18.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/join18.q.out Mon Jun 15 05:43:22 2009
@@ -25,42 +25,48 @@
Map Reduce
Alias -> Map Operator Tree:
b:src2
- Group By Operator
- aggregations:
- expr: count(DISTINCT value)
- keys:
+ Select Operator
+ expressions:
expr: key
type: string
expr: value
type: string
- mode: hash
- Reduce Output Operator
- key expressions:
- expr: 0
+ Group By Operator
+ aggregations:
+ expr: count(DISTINCT value)
+ keys:
+ expr: key
type: string
- expr: 1
+ expr: value
type: string
- sort order: ++
- Map-reduce partition columns:
- expr: 0
- type: string
- tag: -1
- value expressions:
- expr: 2
- type: bigint
+ mode: hash
+ Reduce Output Operator
+ key expressions:
+ expr: _col0
+ type: string
+ expr: _col1
+ type: string
+ sort order: ++
+ Map-reduce partition columns:
+ expr: _col0
+ type: string
+ tag: -1
+ value expressions:
+ expr: _col2
+ type: bigint
Reduce Operator Tree:
Group By Operator
aggregations:
- expr: count(DISTINCT KEY.1)
+ expr: count(DISTINCT KEY._col1)
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
@@ -76,49 +82,49 @@
$INTNAME
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: bigint
$INTNAME1
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: bigint
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: bigint
- expr: 2
+ expr: _col2
type: string
- expr: 3
+ expr: _col3
type: bigint
File Output Operator
compressed: false
@@ -131,38 +137,44 @@
Map Reduce
Alias -> Map Operator Tree:
a:src1
- Group By Operator
- aggregations:
- expr: count(value)
- keys:
+ Select Operator
+ expressions:
expr: key
type: string
- mode: hash
- Reduce Output Operator
- key expressions:
- expr: 0
- type: string
- sort order: +
- Map-reduce partition columns:
- expr: 0
+ expr: value
+ type: string
+ Group By Operator
+ aggregations:
+ expr: count(value)
+ keys:
+ expr: key
type: string
- tag: -1
- value expressions:
- expr: 1
- type: bigint
+ mode: hash
+ Reduce Output Operator
+ key expressions:
+ expr: _col0
+ type: string
+ sort order: +
+ Map-reduce partition columns:
+ expr: _col0
+ type: string
+ tag: -1
+ value expressions:
+ expr: _col1
+ type: bigint
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
@@ -190,7 +202,7 @@
ON (a.key = b.key)
Input: default/src1
Input: default/src
-Output: /data/users/njain/hive2/hive2/ql/../build/ql/tmp/1189387054/402013918.10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/724709493/10000
NULL NULL 6
0 3 NULL NULL
10 1 NULL NULL
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/join19.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/join19.q.out?rev=784656&r1=784655&r2=784656&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/join19.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/join19.q.out Mon Jun 15 05:43:22 2009
@@ -69,109 +69,85 @@
Map Reduce
Alias -> Map Operator Tree:
t22:t2
- Select Operator
- expressions:
- expr: subject
- type: string
- expr: object
- type: string
- expr: predicate
- type: string
- Filter Operator
- predicate:
- expr: (2 = 'http://sofa.semanticweb.org/sofa/v1.0/system#__LABEL_REL')
- type: boolean
- Select Operator
- expressions:
- expr: 0
- type: string
- expr: 1
- type: string
- 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
+ Filter Operator
+ predicate:
+ expr: (predicate = 'http://sofa.semanticweb.org/sofa/v1.0/system#__LABEL_REL')
+ type: boolean
+ Select Operator
+ expressions:
+ expr: subject
+ type: string
+ expr: object
+ type: string
+ Reduce Output Operator
+ key expressions:
+ expr: _col0
+ type: string
+ sort order: +
+ Map-reduce partition columns:
+ expr: _col0
+ type: string
+ tag: 1
+ value expressions:
+ expr: _col0
+ type: string
+ expr: _col1
+ type: string
t33:t3
- Select Operator
- expressions:
- expr: subject
- type: string
- expr: object
- type: string
- expr: predicate
- type: string
- Filter Operator
- predicate:
- expr: (2 = 'http://www.ontosearch.com/2007/12/ontosofa-ns#_from')
- type: boolean
- Select Operator
- expressions:
- expr: 0
- type: string
- expr: 1
- type: string
- Reduce Output Operator
- key expressions:
- expr: 1
- type: string
- sort order: +
- Map-reduce partition columns:
- expr: 1
- type: string
- tag: 2
- value expressions:
- expr: 0
- type: string
- expr: 1
- type: string
+ Filter Operator
+ predicate:
+ expr: (predicate = 'http://www.ontosearch.com/2007/12/ontosofa-ns#_from')
+ type: boolean
+ Select Operator
+ expressions:
+ expr: subject
+ type: string
+ expr: object
+ type: string
+ Reduce Output Operator
+ key expressions:
+ expr: _col1
+ type: string
+ sort order: +
+ Map-reduce partition columns:
+ expr: _col1
+ type: string
+ tag: 2
+ value expressions:
+ expr: _col0
+ type: string
+ expr: _col1
+ type: string
t11:t1
- Select Operator
- expressions:
- expr: subject
- type: string
- expr: predicate
- type: string
- expr: object
- type: string
- Filter Operator
- predicate:
- expr: ((1 = 'http://sofa.semanticweb.org/sofa/v1.0/system#__INSTANCEOF_REL') and (2 = 'http://ontos/OntosMiner/Common.English/ontology#Citation'))
- type: boolean
- Select Operator
- expressions:
- expr: 0
- 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
+ Filter Operator
+ predicate:
+ expr: ((predicate = 'http://sofa.semanticweb.org/sofa/v1.0/system#__INSTANCEOF_REL') and (object = 'http://ontos/OntosMiner/Common.English/ontology#Citation'))
+ type: boolean
+ Select Operator
+ expressions:
+ expr: subject
+ type: string
+ Reduce Output Operator
+ key expressions:
+ expr: _col0
+ type: string
+ sort order: +
+ Map-reduce partition columns:
+ expr: _col0
+ type: string
+ tag: 0
+ value expressions:
+ expr: _col0
+ type: string
Reduce Operator Tree:
Join Operator
condition map:
Inner Join 0 to 1
Inner Join 0 to 2
condition expressions:
- 0 {VALUE.0}
- 1 {VALUE.0} {VALUE.1}
- 2 {VALUE.0} {VALUE.1}
+ 0 {VALUE._col0}
+ 1 {VALUE._col0} {VALUE._col1}
+ 2 {VALUE._col0} {VALUE._col1}
File Output Operator
compressed: false
GlobalTableId: 0
@@ -186,95 +162,79 @@
$INTNAME
Reduce Output Operator
key expressions:
- expr: 3
+ expr: _col3
type: string
sort order: +
Map-reduce partition columns:
- expr: 3
+ expr: _col3
type: string
tag: 0
value expressions:
- expr: 3
+ expr: _col3
type: string
- expr: 4
+ expr: _col4
type: string
- expr: 0
+ expr: _col0
type: string
- expr: 1
+ expr: _col1
type: string
- expr: 2
+ expr: _col2
type: string
t55:t5
- Select Operator
- expressions:
- expr: subject
- type: string
- expr: object
- type: string
- expr: predicate
- type: string
- Filter Operator
- predicate:
- expr: (2 = 'http://www.ontosearch.com/2007/12/ontosofa-ns#_to')
- type: boolean
- Select Operator
- expressions:
- expr: 0
- type: string
- expr: 1
- type: string
- Reduce Output Operator
- key expressions:
- expr: 0
- type: string
- sort order: +
- Map-reduce partition columns:
- expr: 0
- type: string
- tag: 2
- value expressions:
- expr: 0
- type: string
- expr: 1
- type: string
+ Filter Operator
+ predicate:
+ expr: (predicate = 'http://www.ontosearch.com/2007/12/ontosofa-ns#_to')
+ type: boolean
+ Select Operator
+ expressions:
+ expr: subject
+ type: string
+ expr: object
+ type: string
+ Reduce Output Operator
+ key expressions:
+ expr: _col0
+ type: string
+ sort order: +
+ Map-reduce partition columns:
+ expr: _col0
+ type: string
+ tag: 2
+ value expressions:
+ expr: _col0
+ type: string
+ expr: _col1
+ type: string
t44:t4
- Select Operator
- expressions:
- expr: subject
- type: string
- expr: predicate
- type: string
- expr: object
- type: string
- Filter Operator
- predicate:
- expr: ((1 = 'http://sofa.semanticweb.org/sofa/v1.0/system#__INSTANCEOF_REL') and (2 = 'http://ontos/OntosMiner/Common.English/ontology#Author'))
- type: boolean
- Select Operator
- expressions:
- expr: 0
- type: string
- 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
+ Filter Operator
+ predicate:
+ expr: ((predicate = 'http://sofa.semanticweb.org/sofa/v1.0/system#__INSTANCEOF_REL') and (object = 'http://ontos/OntosMiner/Common.English/ontology#Author'))
+ type: boolean
+ Select Operator
+ expressions:
+ expr: subject
+ type: string
+ Reduce Output Operator
+ key expressions:
+ expr: _col0
+ type: string
+ sort order: +
+ Map-reduce partition columns:
+ expr: _col0
+ type: string
+ tag: 1
+ value expressions:
+ expr: _col0
+ type: string
Reduce Operator Tree:
Join Operator
condition map:
Inner Join 0 to 1
Inner Join 1 to 2
condition expressions:
- 0 {VALUE.0} {VALUE.1} {VALUE.2} {VALUE.3} {VALUE.4}
- 1 {VALUE.0}
- 2 {VALUE.0} {VALUE.1}
+ 0 {VALUE._col0} {VALUE._col1} {VALUE._col2} {VALUE._col3} {VALUE._col4}
+ 1 {VALUE._col0}
+ 2 {VALUE._col0} {VALUE._col1}
File Output Operator
compressed: false
GlobalTableId: 0
@@ -287,83 +247,75 @@
Map Reduce
Alias -> Map Operator Tree:
t66:t6
- Select Operator
- expressions:
- expr: subject
- type: string
- expr: object
- type: string
- expr: predicate
- type: string
- Filter Operator
- predicate:
- expr: (2 = 'http://sofa.semanticweb.org/sofa/v1.0/system#__LABEL_REL')
- type: boolean
- Select Operator
- expressions:
- expr: 0
- type: string
- expr: 1
- type: string
- 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
+ Filter Operator
+ predicate:
+ expr: (predicate = 'http://sofa.semanticweb.org/sofa/v1.0/system#__LABEL_REL')
+ type: boolean
+ Select Operator
+ expressions:
+ expr: subject
+ type: string
+ expr: object
+ type: string
+ Reduce Output Operator
+ key expressions:
+ expr: _col0
+ type: string
+ sort order: +
+ Map-reduce partition columns:
+ expr: _col0
+ type: string
+ tag: 1
+ value expressions:
+ expr: _col0
+ type: string
+ expr: _col1
+ type: string
$INTNAME
Reduce Output Operator
key expressions:
- expr: 7
+ expr: _col7
type: string
sort order: +
Map-reduce partition columns:
- expr: 7
+ expr: _col7
type: string
tag: 0
value expressions:
- expr: 0
+ expr: _col0
type: string
- expr: 1
+ expr: _col1
type: string
- expr: 5
+ expr: _col5
type: string
- expr: 2
+ expr: _col2
type: string
- expr: 3
+ expr: _col3
type: string
- expr: 4
+ expr: _col4
type: string
- expr: 6
+ expr: _col6
type: string
- expr: 7
+ expr: _col7
type: string
Reduce Operator Tree:
Join Operator
condition map:
Inner Join 0 to 1
condition expressions:
- 0 {VALUE.0} {VALUE.1} {VALUE.2} {VALUE.3} {VALUE.4} {VALUE.5} {VALUE.6} {VALUE.7}
- 1 {VALUE.0} {VALUE.1}
+ 0 {VALUE._col0} {VALUE._col1} {VALUE._col2} {VALUE._col3} {VALUE._col4} {VALUE._col5} {VALUE._col6} {VALUE._col7}
+ 1 {VALUE._col0} {VALUE._col1}
Select Operator
expressions:
- expr: 3
+ expr: _col3
type: string
- expr: 5
+ expr: _col5
type: string
- expr: 0
+ expr: _col0
type: string
- expr: 7
+ expr: _col7
type: string
- expr: 9
+ expr: _col9
type: string
File Output Operator
compressed: false
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/join2.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/join2.q.out?rev=784656&r1=784655&r2=784656&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/join2.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/join2.q.out Mon Jun 15 05:43:22 2009
@@ -15,46 +15,42 @@
Map Reduce
Alias -> Map Operator Tree:
src2
- Select Operator
- expressions:
+ Reduce Output Operator
+ key expressions:
+ expr: key
+ type: string
+ sort order: +
+ Map-reduce partition columns:
expr: key
type: string
- 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
+ tag: 1
+ value expressions:
+ expr: key
+ type: string
+ 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
- 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
+ tag: 0
+ value expressions:
+ expr: key
+ type: string
+ expr: value
+ type: string
Reduce Operator Tree:
Join Operator
condition map:
Inner Join 0 to 1
condition expressions:
- 0 {VALUE.0}
- 1 {VALUE.0}
+ 0 {VALUE._col0} {VALUE._col1}
+ 1 {VALUE._col0} {VALUE._col1}
File Output Operator
compressed: false
GlobalTableId: 0
@@ -69,17 +65,21 @@
$INTNAME
Reduce Output Operator
key expressions:
- expr: (UDFToDouble(0) + UDFToDouble(1))
+ expr: (UDFToDouble(_col0) + UDFToDouble(_col2))
type: double
sort order: +
Map-reduce partition columns:
- expr: (UDFToDouble(0) + UDFToDouble(1))
+ expr: (UDFToDouble(_col0) + UDFToDouble(_col2))
type: double
tag: 0
value expressions:
- expr: 1
+ expr: _col2
+ type: string
+ expr: _col3
+ type: string
+ expr: _col0
type: string
- expr: 0
+ expr: _col1
type: string
src3
Reduce Output Operator
@@ -101,19 +101,19 @@
condition map:
Inner Join 0 to 1
condition expressions:
- 0 {VALUE.0} {VALUE.1}
- 1 {VALUE.0} {VALUE.1}
+ 0 {VALUE._col0} {VALUE._col1} {VALUE._col2} {VALUE._col3}
+ 1 {VALUE._col0} {VALUE._col1}
Select Operator
expressions:
- expr: 1
+ expr: _col2
type: string
- expr: 3
+ 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
@@ -141,7 +141,7 @@
Output: default/dest_j2
query: SELECT dest_j2.* FROM dest_j2
Input: default/dest_j2
-Output: /data/users/njain/hive2/hive2/ql/../build/ql/tmp/1422762997/933821001.10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/171725060/10000
0 val_0
0 val_0
0 val_0
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/join20.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/join20.q.out?rev=784656&r1=784655&r2=784656&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/join20.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/join20.q.out Mon Jun 15 05:43:22 2009
@@ -72,22 +72,22 @@
Inner Join 0 to 1
Right 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
File Output Operator
compressed: false
@@ -100,35 +100,35 @@
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- /data/users/njain/hive2/hive2/build/ql/tmp/476463155/205865751.10002
+ file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/692540423/10002
Reduce Output Operator
key 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
sort order: ++++++
tag: -1
value 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
Reduce Operator Tree:
Extract
@@ -147,7 +147,7 @@
query: SELECT * FROM src src1 JOIN src src2 ON (src1.key = src2.key AND src1.key < 10) RIGHT OUTER JOIN src src3 ON (src1.key = src3.key AND src3.key < 20)
SORT BY src1.key, src1.value, src2.key, src2.value, src3.key, src3.value
Input: default/src
-Output: /data/users/njain/hive2/hive2/ql/../build/ql/tmp/1205211471/304438397.10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/354547535/10000
NULL NULL NULL NULL 10 val_10
NULL NULL NULL NULL 11 val_11
NULL NULL NULL NULL 12 val_12
@@ -294,22 +294,22 @@
Inner Join 0 to 1
Right 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
File Output Operator
compressed: false
@@ -322,35 +322,35 @@
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- /data/users/njain/hive2/hive2/build/ql/tmp/112521398/618050553.10002
+ file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1426415485/10002
Reduce Output Operator
key 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
sort order: ++++++
tag: -1
value 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
Reduce Operator Tree:
Extract
@@ -369,7 +369,7 @@
query: SELECT * FROM src src1 JOIN src src2 ON (src1.key = src2.key AND src1.key < 10 AND src2.key < 15) RIGHT OUTER JOIN src src3 ON (src1.key = src3.key AND src3.key < 20)
SORT BY src1.key, src1.value, src2.key, src2.value, src3.key, src3.value
Input: default/src
-Output: /data/users/njain/hive2/hive2/ql/../build/ql/tmp/272950277/29892482.10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/996575325/10000
NULL NULL NULL NULL 10 val_10
NULL NULL NULL NULL 11 val_11
NULL NULL NULL NULL 12 val_12
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/join21.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/join21.q.out?rev=784656&r1=784655&r2=784656&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/join21.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/join21.q.out Mon Jun 15 05:43:22 2009
@@ -75,22 +75,22 @@
Left Outer Join0 to 1
Right Outer Join1 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
File Output Operator
compressed: false
@@ -103,35 +103,35 @@
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- /data/users/njain/hive2/hive2/build/ql/tmp/1056447068/295662046.10002
+ file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1871738284/10002
Reduce Output Operator
key 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
sort order: ++++++
tag: -1
value 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
Reduce Operator Tree:
Extract
@@ -149,7 +149,7 @@
query: SELECT * FROM src src1 LEFT OUTER JOIN src src2 ON (src1.key = src2.key AND src1.key < 10 AND src2.key > 10) RIGHT OUTER JOIN src src3 ON (src2.key = src3.key AND src3.key < 10) SORT BY src1.key, src1.value, src2.key, src2.value, src3.key, src3.value
Input: default/src
-Output: /data/users/njain/hive2/hive2/ql/../build/ql/tmp/18010630/922048822.10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1337202380/10000
NULL NULL NULL NULL 0 val_0
NULL NULL NULL NULL 0 val_0
NULL NULL NULL NULL 0 val_0
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/join22.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/join22.q.out?rev=784656&r1=784655&r2=784656&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/join22.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/join22.q.out Mon Jun 15 05:43:22 2009
@@ -47,17 +47,13 @@
condition map:
Inner 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: 2
+ expr: _col0
type: string
- expr: 3
- type: string
- expr: 0
- type: string
- expr: 1
+ expr: _col1
type: string
File Output Operator
compressed: false
@@ -73,21 +69,17 @@
$INTNAME
Reduce Output Operator
key expressions:
- expr: 2
+ expr: _col2
type: string
sort order: +
Map-reduce partition columns:
- expr: 2
+ expr: _col2
type: string
tag: 1
value expressions:
- expr: 0
- type: string
- expr: 1
+ expr: _col2
type: string
- expr: 2
- type: string
- expr: 3
+ expr: _col3
type: string
src5:src4
Reduce Output Operator
@@ -109,25 +101,15 @@
condition map:
Inner Join 0 to 1
condition expressions:
- 0 {VALUE.0} {VALUE.1}
- 1 {VALUE.0} {VALUE.1} {VALUE.2} {VALUE.3}
+ 0 {VALUE._col0} {VALUE._col1}
+ 1 {VALUE._col0} {VALUE._col1} {VALUE._col2} {VALUE._col3}
Select Operator
expressions:
- expr: 2
- type: string
- expr: 3
- type: string
- expr: 4
- type: string
- expr: 5
- type: string
- expr: 1
- type: string
- expr: 0
+ expr: _col5
type: string
Select Operator
expressions:
- expr: 3
+ expr: _col3
type: string
File Output Operator
compressed: false
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/join23.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/join23.q.out?rev=784656&r1=784655&r2=784656&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/join23.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/join23.q.out Mon Jun 15 05:43:22 2009
@@ -35,21 +35,21 @@
condition map:
Inner 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}
Filter Operator
predicate:
- expr: ((UDFToDouble(0) < UDFToDouble(10)) and (UDFToDouble(2) < UDFToDouble(10)))
+ expr: ((UDFToDouble(_col0) < UDFToDouble(10)) and (UDFToDouble(_col2) < UDFToDouble(10)))
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
File Output Operator
compressed: false
@@ -62,27 +62,27 @@
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- /data/users/njain/hive2/hive2/build/ql/tmp/872589019/322144448.10002
+ file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/30533864/10002
Reduce Output Operator
key 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
sort order: ++++
tag: -1
value 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
Reduce Operator Tree:
Extract
@@ -100,7 +100,7 @@
query: SELECT * FROM src src1 JOIN src src2 WHERE src1.key < 10 and src2.key < 10 SORT BY src1.key, src1.value, src2.key, src2.value
Input: default/src
-Output: /data/users/njain/hive2/hive2/ql/../build/ql/tmp/405919902/905413263.10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/872178280/10000
0 val_0 0 val_0
0 val_0 0 val_0
0 val_0 0 val_0
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/join25.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/join25.q.out?rev=784656&r1=784655&r2=784656&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/join25.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/join25.q.out Mon Jun 15 05:43:22 2009
@@ -61,23 +61,23 @@
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- /data/users/njain/hive2/hive2/build/ql/tmp/102975047/615319521.10002
+ file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1697891251/10002
Select Operator
Select Operator
expressions:
- expr: 0
+ expr: _col0
type: string
- expr: 1
+ expr: _col1
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: 2
+ expr: _col2
type: string
File Output Operator
compressed: false
@@ -107,7 +107,7 @@
Output: default/dest_j1
query: select * from dest_j1 x order by x.key
Input: default/dest_j1
-Output: /data/users/njain/hive2/hive2/ql/../build/ql/tmp/1223859763/34068483.10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/2013071661/10000
66 val_66 val_66
98 val_98 val_98
98 val_98 val_98
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/join26.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/join26.q.out?rev=784656&r1=784655&r2=784656&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/join26.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/join26.q.out Mon Jun 15 05:43:22 2009
@@ -30,7 +30,7 @@
Inner Join 0 to 1
Inner Join 0 to 2
condition expressions:
- 0 {0}
+ 0 {key} {value}
1 {key} {value}
2 {key} {value} {ds} {hr}
keys:
@@ -41,13 +41,13 @@
File Output Operator
compressed: false
GlobalTableId: 0
- directory: /data/users/njain/hive2/hive2/build/ql/tmp/30368463/649654590.10002
+ directory: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1980904017/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:
@@ -64,7 +64,7 @@
Inner Join 0 to 1
Inner Join 0 to 2
condition expressions:
- 0 {0}
+ 0 {key} {value}
1 {key} {value}
2 {key} {value} {ds} {hr}
keys:
@@ -75,46 +75,42 @@
File Output Operator
compressed: false
GlobalTableId: 0
- directory: /data/users/njain/hive2/hive2/build/ql/tmp/30368463/649654590.10002
+ directory: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1980904017/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
x
- Select Operator
- expressions:
- expr: key
- type: string
- Common Join Operator
- condition map:
- Inner Join 0 to 1
- Inner Join 0 to 2
- condition expressions:
- 0 {0}
- 1 {key} {value}
- 2 {key} {value} {ds} {hr}
- keys:
- 0
- 1
- 2
- Position of Big Table: 2
- File Output Operator
- compressed: false
- GlobalTableId: 0
- directory: /data/users/njain/hive2/hive2/build/ql/tmp/30368463/649654590.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
+ Common Join Operator
+ condition map:
+ Inner Join 0 to 1
+ Inner Join 0 to 2
+ condition expressions:
+ 0 {key} {value}
+ 1 {key} {value}
+ 2 {key} {value} {ds} {hr}
+ keys:
+ 0
+ 1
+ 2
+ Position of Big Table: 2
+ File Output Operator
+ compressed: false
+ GlobalTableId: 0
+ directory: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1980904017/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/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
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
@@ -133,27 +129,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/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
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- /data/users/njain/hive2/hive2/build/ql/tmp/30368463/649654590.10002
+ file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1980904017/10002
Select Operator
Select Operator
expressions:
- expr: 0
+ expr: _col0
type: string
- expr: 4
+ expr: _col5
type: string
- expr: 2
+ expr: _col3
type: string
File Output Operator
compressed: false
GlobalTableId: 1
- directory: /data/users/njain/hive2/hive2/ql/../build/ql/tmp/170469534.10000.insclause-0
+ directory: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1462916600/10000
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -167,27 +163,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:
- /data/users/njain/hive2/hive2/build/ql/tmp/30368463/649654590.10002
+ file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1980904017/10002
Path -> Partition:
- /data/users/njain/hive2/hive2/build/ql/tmp/30368463/649654590.10002
+ file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1980904017/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: /data/users/njain/hive2/hive2/ql/../build/ql/tmp/170469534.10000.insclause-0
+ source: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1462916600/10000
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -201,10 +197,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: /data/users/njain/hive2/hive2/ql/../build/ql/tmp/170469534.10001
+ tmp directory: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1462916600/10001
query: INSERT OVERWRITE TABLE dest_j1
@@ -217,7 +213,7 @@
Output: default/dest_j1
query: select * from dest_j1 x order by x.key
Input: default/dest_j1
-Output: /data/users/njain/hive2/hive2/ql/../build/ql/tmp/902813804/539828044.10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/960855194/10000
128 val_128 val_128
128 val_128 val_128
128 val_128 val_128
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/join27.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/join27.q.out?rev=784656&r1=784655&r2=784656&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/join27.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/join27.q.out Mon Jun 15 05:43:22 2009
@@ -17,26 +17,22 @@
Map Reduce
Alias -> Map Operator Tree:
y
- Select Operator
- expressions:
- expr: value
- type: string
- Common Join Operator
- condition map:
- Inner Join 0 to 1
- condition expressions:
- 0 {key} {value}
- 1 {0}
- keys:
- 0
- 1
- Position of Big Table: 1
- File Output Operator
- compressed: false
- GlobalTableId: 0
- table:
- input format: org.apache.hadoop.mapred.SequenceFileInputFormat
- output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
+ Common Join Operator
+ condition map:
+ Inner Join 0 to 1
+ condition expressions:
+ 0 {key} {value}
+ 1 {key} {value}
+ keys:
+ 0
+ 1
+ Position of Big Table: 1
+ File Output Operator
+ compressed: false
+ GlobalTableId: 0
+ table:
+ input format: org.apache.hadoop.mapred.SequenceFileInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
Local Work:
Map Reduce Local Work
Alias -> Map Local Tables:
@@ -50,7 +46,7 @@
Inner Join 0 to 1
condition expressions:
0 {key} {value}
- 1 {0}
+ 1 {key} {value}
keys:
0
1
@@ -65,23 +61,23 @@
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/njain/hive2/hive2/build/ql/tmp/972496484/10004
+ file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1533119508/10002
Select Operator
Select Operator
expressions:
- expr: 0
+ expr: _col0
type: string
- expr: 1
+ expr: _col1
type: string
- expr: 2
+ expr: _col3
type: string
Select Operator
expressions:
- expr: UDFToInteger(0)
+ expr: UDFToInteger(_col0)
type: int
- expr: 1
+ expr: _col1
type: string
- expr: 2
+ expr: _col2
type: string
File Output Operator
compressed: false
@@ -111,7 +107,7 @@
Output: default/dest_j1
query: select * from dest_j1 x order by x.key, x.value
Input: default/dest_j1
-Output: file:/data/users/njain/hive2/hive2/build/ql/tmp/1547052154/10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/2137545463/10000
NULL val_165 val_165
NULL val_165 val_165
NULL val_193 val_193
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=784656&r1=784655&r2=784656&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 Mon Jun 15 05:43:22 2009
@@ -65,23 +65,17 @@
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/njain/hive2/hive2/build/ql/tmp/1070437488/10002
+ file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/808962627/10002
Select Operator
Select Operator
expressions:
- expr: 0
- type: string
- expr: 1
- type: string
- expr: 2
- type: string
- expr: 3
+ expr: _col0
type: string
Common Join Operator
condition map:
Inner Join 0 to 1
condition expressions:
- 0 {0} {1} {2} {3}
+ 0 {_col0}
1 {key} {value} {ds} {hr}
keys:
0
@@ -113,7 +107,7 @@
condition map:
Inner Join 0 to 1
condition expressions:
- 0 {0} {1} {2} {3}
+ 0 {_col0}
1 {key} {value} {ds} {hr}
keys:
0
@@ -129,13 +123,13 @@
Stage: Stage-3
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/njain/hive2/hive2/build/ql/tmp/1070437488/10003
+ file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/808962627/10003
Select Operator
Select Operator
expressions:
- expr: 0
+ expr: _col0
type: string
- expr: 5
+ expr: _col5
type: string
File Output Operator
compressed: false
@@ -169,7 +163,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/1405385308/10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/418632889/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=784656&r1=784655&r2=784656&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 Mon Jun 15 05:43:22 2009
@@ -31,34 +31,34 @@
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
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
@@ -71,13 +71,13 @@
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/njain/hive2/hive2/build/ql/tmp/1697527534/10004
+ file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1433557648/10002
Common Join Operator
condition map:
Inner Join 0 to 1
condition expressions:
- 0 {0} {1}
- 1 {0} {1}
+ 0 {_col0} {_col1}
+ 1 {_col0} {_col1}
keys:
0
1
@@ -91,17 +91,17 @@
Local Work:
Map Reduce Local Work
Alias -> Map Local Tables:
- file:/data/users/njain/hive2/hive2/build/ql/tmp/1697527534/10006
+ file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1433557648/10004
Fetch Operator
limit: -1
Alias -> Map Local Operator Tree:
- file:/data/users/njain/hive2/hive2/build/ql/tmp/1697527534/10006
+ file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1433557648/10004
Common Join Operator
condition map:
Inner Join 0 to 1
condition expressions:
- 0 {0} {1}
- 1 {0} {1}
+ 0 {_col0} {_col1}
+ 1 {_col0} {_col1}
keys:
0
1
@@ -116,23 +116,23 @@
Stage: Stage-3
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/njain/hive2/hive2/build/ql/tmp/1697527534/10005
+ file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1433557648/10003
Select Operator
Select Operator
expressions:
- expr: 0
+ expr: _col0
type: string
- expr: 1
+ expr: _col1
type: bigint
- expr: 3
+ expr: _col3
type: bigint
Select Operator
expressions:
- expr: 0
+ expr: _col0
type: string
- expr: UDFToInteger(1)
+ expr: UDFToInteger(_col1)
type: int
- expr: UDFToInteger(2)
+ expr: UDFToInteger(_col2)
type: int
File Output Operator
compressed: false
@@ -165,34 +165,34 @@
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
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
@@ -212,7 +212,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/1884185174/10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1124342487/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=784656&r1=784655&r2=784656&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 Mon Jun 15 05:43:22 2009
@@ -14,22 +14,20 @@
Map Reduce
Alias -> Map Operator Tree:
src2
- Select Operator
- expressions:
+ Reduce Output Operator
+ key expressions:
+ expr: key
+ type: string
+ sort order: +
+ Map-reduce partition columns:
+ expr: key
+ type: string
+ tag: 1
+ value expressions:
expr: key
type: string
- 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: value
+ type: string
src3
Reduce Output Operator
key expressions:
@@ -46,42 +44,40 @@
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
- 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
+ tag: 0
+ 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.0}
- 1 {VALUE.0}
- 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: 3
+ 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
@@ -102,13 +98,14 @@
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: dest1
+
query: FROM src src1 JOIN src src2 ON (src1.key = src2.key) JOIN src src3 ON (src1.key = src3.key)
INSERT OVERWRITE TABLE dest1 SELECT src1.key, src3.value
Input: default/src
Output: default/dest1
query: SELECT dest1.* FROM dest1
Input: default/dest1
-Output: /data/users/athusoo/commits/hive_trunk_ws8/ql/../build/ql/tmp/436759319/410489049.10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/574651295/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=784656&r1=784655&r2=784656&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 Mon Jun 15 05:43:22 2009
@@ -16,26 +16,22 @@
Map Reduce
Alias -> Map Operator Tree:
y
- Select Operator
- expressions:
- expr: key
- type: string
- Common Join Operator
- condition map:
- Inner Join 0 to 1
- condition expressions:
- 0 {0}
- 1 {0}
- keys:
- 0
- 1
- Position of Big Table: 1
- File Output Operator
- compressed: false
- GlobalTableId: 0
- table:
- input format: org.apache.hadoop.mapred.SequenceFileInputFormat
- output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
+ Common Join Operator
+ condition map:
+ Inner Join 0 to 1
+ condition expressions:
+ 0 {key} {value}
+ 1 {key} {value}
+ keys:
+ 0
+ 1
+ Position of Big Table: 1
+ File Output Operator
+ compressed: false
+ GlobalTableId: 0
+ table:
+ input format: org.apache.hadoop.mapred.SequenceFileInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
Local Work:
Map Reduce Local Work
Alias -> Map Local Tables:
@@ -44,70 +40,70 @@
limit: -1
Alias -> Map Local Operator Tree:
x
- Select Operator
- expressions:
- expr: key
- type: string
- Common Join Operator
- condition map:
- Inner Join 0 to 1
- condition expressions:
- 0 {0}
- 1 {0}
- keys:
- 0
- 1
- Position of Big Table: 1
- File Output Operator
- compressed: false
- GlobalTableId: 0
- table:
- input format: org.apache.hadoop.mapred.SequenceFileInputFormat
- output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
+ Common Join Operator
+ condition map:
+ Inner Join 0 to 1
+ condition expressions:
+ 0 {key} {value}
+ 1 {key} {value}
+ keys:
+ 0
+ 1
+ Position of Big Table: 1
+ File Output Operator
+ compressed: false
+ GlobalTableId: 0
+ table:
+ input format: org.apache.hadoop.mapred.SequenceFileInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- /data/users/njain/hive2/hive2/build/ql/tmp/1525153235/1992677949.10002
+ file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1960448619/10002
Select Operator
- Group By Operator
- aggregations:
- expr: count(1)
- keys:
- expr: 0
+ Select Operator
+ expressions:
+ expr: _col0
type: string
- mode: hash
- Reduce Output Operator
- key expressions:
- expr: 0
- type: string
- sort order: +
- Map-reduce partition columns:
- expr: 0
+ Group By Operator
+ aggregations:
+ expr: count(1)
+ keys:
+ expr: _col0
type: string
- tag: -1
- value expressions:
- expr: 1
- type: bigint
+ mode: hash
+ Reduce Output Operator
+ key expressions:
+ expr: _col0
+ type: string
+ sort order: +
+ Map-reduce partition columns:
+ expr: _col0
+ type: string
+ tag: -1
+ value expressions:
+ expr: _col1
+ type: bigint
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
Select Operator
expressions:
- expr: UDFToInteger(0)
+ expr: UDFToInteger(_col0)
type: int
- expr: UDFToInteger(1)
+ expr: UDFToInteger(_col1)
type: int
File Output Operator
compressed: false
@@ -136,7 +132,7 @@
Output: default/dest_j1
query: select * from dest_j1 x order by x.key
Input: default/dest_j1
-Output: /data/users/njain/hive2/hive2/ql/../build/ql/tmp/205648147/710556160.10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1763096611/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=784656&r1=784655&r2=784656&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 Mon Jun 15 05:43:22 2009
@@ -32,35 +32,33 @@
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
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
- type: bigint
File Output Operator
compressed: false
GlobalTableId: 0
@@ -72,13 +70,13 @@
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/njain/hive2/hive2/build/ql/tmp/392806825/10004
+ file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/287638858/10002
Common Join Operator
condition map:
Inner Join 0 to 1
condition expressions:
- 0 {0} {1}
- 1 {0} {1}
+ 0 {_col0}
+ 1 {_col0}
keys:
0
1
@@ -92,17 +90,17 @@
Local Work:
Map Reduce Local Work
Alias -> Map Local Tables:
- file:/data/users/njain/hive2/hive2/build/ql/tmp/392806825/10006
+ file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/287638858/10004
Fetch Operator
limit: -1
Alias -> Map Local Operator Tree:
- file:/data/users/njain/hive2/hive2/build/ql/tmp/392806825/10006
+ file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/287638858/10004
Common Join Operator
condition map:
Inner Join 0 to 1
condition expressions:
- 0 {0} {1}
- 1 {0} {1}
+ 0 {_col0}
+ 1 {_col0}
keys:
0
1
@@ -117,46 +115,50 @@
Stage: Stage-3
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/njain/hive2/hive2/build/ql/tmp/392806825/10005
+ file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/287638858/10003
Select Operator
- Group By Operator
- aggregations:
- expr: count(1)
- keys:
- expr: 0
+ Select Operator
+ expressions:
+ expr: _col0
type: string
- mode: hash
- Reduce Output Operator
- key expressions:
- expr: 0
- type: string
- sort order: +
- Map-reduce partition columns:
- expr: 0
+ Group By Operator
+ aggregations:
+ expr: count(1)
+ keys:
+ expr: _col0
type: string
- tag: -1
- value expressions:
- expr: 1
- type: bigint
+ mode: hash
+ Reduce Output Operator
+ key expressions:
+ expr: _col0
+ type: string
+ sort order: +
+ Map-reduce partition columns:
+ expr: _col0
+ type: string
+ tag: -1
+ value expressions:
+ expr: _col1
+ type: bigint
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
Select Operator
expressions:
- expr: 0
+ expr: _col0
type: string
- expr: UDFToInteger(1)
+ expr: UDFToInteger(_col1)
type: int
File Output Operator
compressed: false
@@ -189,35 +191,33 @@
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
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
- type: bigint
File Output Operator
compressed: false
GlobalTableId: 0
@@ -237,7 +237,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/654974083/10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1116945545/10000
128 1
146 1
150 1