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/08/11 04:06:32 UTC
svn commit: r802976 [6/17] - 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/lib/
ql/src/java/org/apache/hadoop/hive/ql/optimizer/ ql/src/java/org/...
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=802976&r1=802975&r2=802976&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 Tue Aug 11 02:06:23 2009
@@ -27,11 +27,15 @@
Map Reduce
Alias -> Map Operator Tree:
null-subquery1:subq1-subquery1:x
+ TableScan
+ alias: x
Filter Operator
+ isSamplingPred: false
predicate:
expr: (UDFToDouble(key) < UDFToDouble(20))
type: boolean
Filter Operator
+ isSamplingPred: false
predicate:
expr: (UDFToDouble(key) < UDFToDouble(20))
type: boolean
@@ -62,9 +66,9 @@
type: bigint
Needs Tagging: false
Path -> Alias:
- file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/test/data/warehouse/src
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/src
Path -> Partition:
- file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/test/data/warehouse/src
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/src
Partition
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -79,7 +83,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/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/test/data/warehouse/src
+ location file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/src
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: src
Reduce Operator Tree:
@@ -101,7 +105,7 @@
File Output Operator
compressed: false
GlobalTableId: 0
- directory: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/tmp/1365573442/10002
+ directory: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1727048194/10002
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -113,7 +117,7 @@
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/tmp/1365573442/10002
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1727048194/10002
Union
Common Join Operator
condition map:
@@ -156,7 +160,7 @@
File Output Operator
compressed: false
GlobalTableId: 1
- directory: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/tmp/1365573442/10003
+ directory: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1727048194/10003
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -170,10 +174,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/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/test/data/warehouse/dest_j1
+ location file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/dest_j1
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: dest_j1
- file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/tmp/1365573442/10004
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1727048194/10004
Union
Common Join Operator
condition map:
@@ -216,7 +220,7 @@
File Output Operator
compressed: false
GlobalTableId: 1
- directory: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/tmp/1365573442/10003
+ directory: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1727048194/10003
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -230,7 +234,7 @@
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/test/data/warehouse/dest_j1
+ location file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/dest_j1
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: dest_j1
Local Work:
@@ -241,6 +245,8 @@
limit: -1
Alias -> Map Local Operator Tree:
x
+ TableScan
+ alias: x
Common Join Operator
condition map:
Inner Join 0 to 1
@@ -282,7 +288,7 @@
File Output Operator
compressed: false
GlobalTableId: 1
- directory: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/tmp/1365573442/10003
+ directory: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1727048194/10003
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -296,15 +302,15 @@
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/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/test/data/warehouse/dest_j1
+ location file:/data/users/athusoo/commits/hive_trunk_ws1/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/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/tmp/1365573442/10002
- file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/tmp/1365573442/10004
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1727048194/10002
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1727048194/10004
Path -> Partition:
- file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/tmp/1365573442/10002
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1727048194/10002
Partition
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
@@ -313,7 +319,7 @@
columns _col0,_col1
columns.types string,bigint
escape.delim \
- file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/tmp/1365573442/10004
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1727048194/10004
Partition
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
@@ -329,11 +335,11 @@
Move Operator
files:
hdfs directory: true
- source: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/tmp/1365573442/10003
- destination: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/tmp/1741920959/10000
+ source: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1727048194/10003
+ destination: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1251033308/10000
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/tmp/1365573442/10003
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1727048194/10003
Reduce Output Operator
sort order:
Map-reduce partition columns:
@@ -349,9 +355,9 @@
type: int
Needs Tagging: false
Path -> Alias:
- file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/tmp/1365573442/10003
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1727048194/10003
Path -> Partition:
- file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/tmp/1365573442/10003
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1727048194/10003
Partition
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -366,7 +372,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/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/test/data/warehouse/dest_j1
+ location file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/dest_j1
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: dest_j1
Reduce Operator Tree:
@@ -374,7 +380,7 @@
File Output Operator
compressed: false
GlobalTableId: 0
- directory: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/tmp/1741920959/10000
+ directory: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1251033308/10000
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -387,7 +393,7 @@
bucket_count -1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
file.inputformat org.apache.hadoop.mapred.TextInputFormat
- location file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/test/data/warehouse/dest_j1
+ location file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/dest_j1
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: dest_j1
@@ -396,7 +402,7 @@
Move Operator
tables:
replace: true
- source: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/tmp/1741920959/10000
+ source: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1251033308/10000
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -410,20 +416,24 @@
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/test/data/warehouse/dest_j1
+ location file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/dest_j1
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: dest_j1
- tmp directory: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/tmp/1741920959/10001
+ tmp directory: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1251033308/10001
Stage: Stage-6
Map Reduce
Alias -> Map Operator Tree:
null-subquery2:subq1-subquery2:x1
+ TableScan
+ alias: x1
Filter Operator
+ isSamplingPred: false
predicate:
expr: (UDFToDouble(key) > UDFToDouble(100))
type: boolean
Filter Operator
+ isSamplingPred: false
predicate:
expr: (UDFToDouble(key) > UDFToDouble(100))
type: boolean
@@ -454,9 +464,9 @@
type: bigint
Needs Tagging: false
Path -> Alias:
- file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/test/data/warehouse/src
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/src
Path -> Partition:
- file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/test/data/warehouse/src
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/src
Partition
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -471,7 +481,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/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/test/data/warehouse/src
+ location file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/src
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: src
Reduce Operator Tree:
@@ -493,7 +503,7 @@
File Output Operator
compressed: false
GlobalTableId: 0
- directory: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/tmp/1365573442/10004
+ directory: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1727048194/10004
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -516,7 +526,7 @@
Output: default/dest_j1
query: select * from dest_j1 x order by x.key
Input: default/dest_j1
-Output: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/tmp/675600267/10000
+Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1156663841/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=802976&r1=802975&r2=802976&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 Tue Aug 11 02:06:23 2009
@@ -29,6 +29,8 @@
Map Reduce
Alias -> Map Operator Tree:
y
+ TableScan
+ alias: y
Common Join Operator
condition map:
Inner Join 0 to 1
@@ -74,6 +76,8 @@
limit: -1
Alias -> Map Local Operator Tree:
x
+ TableScan
+ alias: x
Common Join Operator
condition map:
Inner Join 0 to 1
@@ -118,10 +122,10 @@
Move Operator
files:
hdfs directory: true
- destination: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_1/build/ql/tmp/33280677/10000
+ destination: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/576445655/10000
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_1/build/ql/tmp/1096000115/10002
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1356744320/10002
Reduce Output Operator
sort order:
Map-reduce partition columns:
@@ -165,7 +169,7 @@
Output: default/dest_j1
query: select * from dest_j1 x order by x.key
Input: default/dest_j1
-Output: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_1/build/ql/tmp/1259857604/10000
+Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/631598409/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=802976&r1=802975&r2=802976&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 Tue Aug 11 02:06:23 2009
@@ -25,6 +25,8 @@
Map Reduce
Alias -> Map Operator Tree:
c:a:src1
+ TableScan
+ alias: src1
Filter Operator
predicate:
expr: ((UDFToDouble(key) > UDFToDouble(10)) and (UDFToDouble(key) < UDFToDouble(20)))
@@ -55,6 +57,8 @@
expr: _col1
type: string
c:b:src2
+ TableScan
+ alias: src2
Filter Operator
predicate:
expr: ((UDFToDouble(key) > UDFToDouble(15)) and (UDFToDouble(key) < UDFToDouble(25)))
@@ -162,7 +166,7 @@
Output: default/dest1
query: SELECT dest1.* FROM dest1
Input: default/dest1
-Output: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_2/build/ql/tmp/2073874945/10000
+Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1353187421/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=802976&r1=802975&r2=802976&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 Tue Aug 11 02:06:23 2009
@@ -25,6 +25,8 @@
Map Reduce
Alias -> Map Operator Tree:
c:a:src1
+ TableScan
+ alias: src1
Filter Operator
predicate:
expr: ((UDFToDouble(key) > UDFToDouble(10)) and (UDFToDouble(key) < UDFToDouble(20)))
@@ -55,6 +57,8 @@
expr: _col1
type: string
c:b:src2
+ TableScan
+ alias: src2
Filter Operator
predicate:
expr: ((UDFToDouble(key) > UDFToDouble(15)) and (UDFToDouble(key) < UDFToDouble(25)))
@@ -162,7 +166,7 @@
Output: default/dest1
query: SELECT dest1.* FROM dest1
Input: default/dest1
-Output: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/tmp/156874986/10000
+Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/771875621/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=802976&r1=802975&r2=802976&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 Tue Aug 11 02:06:23 2009
@@ -25,6 +25,8 @@
Map Reduce
Alias -> Map Operator Tree:
c:a:src1
+ TableScan
+ alias: src1
Filter Operator
predicate:
expr: ((UDFToDouble(key) > UDFToDouble(10)) and (UDFToDouble(key) < UDFToDouble(20)))
@@ -55,6 +57,8 @@
expr: _col1
type: string
c:b:src2
+ TableScan
+ alias: src2
Filter Operator
predicate:
expr: ((UDFToDouble(key) > UDFToDouble(15)) and (UDFToDouble(key) < UDFToDouble(25)))
@@ -162,7 +166,7 @@
Output: default/dest1
query: SELECT dest1.* FROM dest1
Input: default/dest1
-Output: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_1/build/ql/tmp/2039611986/10000
+Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1349249596/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=802976&r1=802975&r2=802976&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 Tue Aug 11 02:06:23 2009
@@ -30,6 +30,8 @@
Map Reduce
Alias -> Map Operator Tree:
c:a:src1
+ TableScan
+ alias: src1
Filter Operator
predicate:
expr: ((UDFToDouble(key) > UDFToDouble(10)) and (UDFToDouble(key) < UDFToDouble(20)))
@@ -60,6 +62,8 @@
expr: _col1
type: string
c:b:src2
+ TableScan
+ alias: src2
Filter Operator
predicate:
expr: ((UDFToDouble(key) > UDFToDouble(15)) and (UDFToDouble(key) < UDFToDouble(25)))
@@ -90,6 +94,8 @@
expr: _col1
type: string
c:c:src3
+ TableScan
+ alias: src3
Filter Operator
predicate:
expr: ((UDFToDouble(key) > UDFToDouble(20)) and (UDFToDouble(key) < UDFToDouble(25)))
@@ -216,7 +222,7 @@
Output: default/dest1
query: SELECT dest1.* FROM dest1
Input: default/dest1
-Output: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_2/build/ql/tmp/1493295879/10000
+Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1132812808/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=802976&r1=802975&r2=802976&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 Tue Aug 11 02:06:23 2009
@@ -25,6 +25,8 @@
Map Reduce
Alias -> Map Operator Tree:
c:a:src1
+ TableScan
+ alias: src1
Filter Operator
predicate:
expr: ((UDFToDouble(key) > UDFToDouble(10)) and (UDFToDouble(key) < UDFToDouble(20)))
@@ -55,6 +57,8 @@
expr: _col1
type: string
c:b:src2
+ TableScan
+ alias: src2
Filter Operator
predicate:
expr: ((UDFToDouble(key) > UDFToDouble(15)) and (UDFToDouble(key) < UDFToDouble(25)))
@@ -166,7 +170,7 @@
Output: default/dest1
query: SELECT dest1.* FROM dest1
Input: default/dest1
-Output: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/tmp/2108029015/10000
+Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/214964657/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=802976&r1=802975&r2=802976&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 Tue Aug 11 02:06:23 2009
@@ -14,6 +14,8 @@
Map Reduce
Alias -> Map Operator Tree:
src2
+ TableScan
+ alias: src2
Reduce Output Operator
key expressions:
expr: key
@@ -27,7 +29,10 @@
expr: value
type: string
src1
+ TableScan
+ alias: src1
Filter Operator
+ isSamplingPred: false
predicate:
expr: ((ds = '2008-04-08') and (hr = '12'))
type: boolean
@@ -49,10 +54,10 @@
type: string
Needs Tagging: true
Path -> Alias:
- file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_1/build/ql/test/data/warehouse/src
- file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_1/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/src
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12
Path -> Partition:
- file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_1/build/ql/test/data/warehouse/src
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/src
Partition
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -67,10 +72,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/zshao/tools/670-trunk-apache-hive/.ptest_1/build/ql/test/data/warehouse/src
+ location file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/src
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: src
- file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_1/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12
Partition
partition values:
ds 2008-04-08
@@ -89,7 +94,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/zshao/tools/670-trunk-apache-hive/.ptest_1/build/ql/test/data/warehouse/srcpart
+ location file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/srcpart
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: srcpart
Reduce Operator Tree:
@@ -101,6 +106,7 @@
1 {VALUE._col1}
outputColumnNames: _col0, _col2, _col3, _col5
Filter Operator
+ isSamplingPred: false
predicate:
expr: ((_col2 = '2008-04-08') and (_col3 = '12'))
type: boolean
@@ -121,7 +127,7 @@
File Output Operator
compressed: false
GlobalTableId: 1
- directory: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_1/build/ql/tmp/1105796087/10000
+ directory: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/863266158/10000
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -135,7 +141,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/zshao/tools/670-trunk-apache-hive/.ptest_1/build/ql/test/data/warehouse/dest1
+ location file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/dest1
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: dest1
@@ -143,7 +149,7 @@
Move Operator
tables:
replace: true
- source: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_1/build/ql/tmp/1105796087/10000
+ source: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/863266158/10000
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -157,10 +163,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/zshao/tools/670-trunk-apache-hive/.ptest_1/build/ql/test/data/warehouse/dest1
+ location file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/dest1
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: dest1
- tmp directory: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_1/build/ql/tmp/1105796087/10001
+ tmp directory: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/863266158/10001
query: FROM srcpart src1 JOIN src src2 ON (src1.key = src2.key)
@@ -170,7 +176,7 @@
Output: default/dest1
query: SELECT dest1.* FROM dest1
Input: default/dest1
-Output: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_1/build/ql/tmp/231667513/10000
+Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/367697399/10000
0 val_0
0 val_0
0 val_0
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/join_hive_626.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/join_hive_626.q.out?rev=802976&r1=802975&r2=802976&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/join_hive_626.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/join_hive_626.q.out Tue Aug 11 02:06:23 2009
@@ -28,6 +28,8 @@
Map Reduce
Alias -> Map Operator Tree:
hive_foo
+ TableScan
+ alias: hive_foo
Reduce Output Operator
key expressions:
expr: foo_id
@@ -41,6 +43,8 @@
expr: foo_name
type: string
hive_bar
+ TableScan
+ alias: hive_bar
Reduce Output Operator
key expressions:
expr: foo_id
@@ -89,6 +93,8 @@
expr: _col10
type: string
hive_count
+ TableScan
+ alias: hive_count
Reduce Output Operator
key expressions:
expr: bar_id
@@ -135,7 +141,7 @@
Input: default/hive_foo
Input: default/hive_count
Input: default/hive_bar
-Output: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_2/build/ql/tmp/837595619/10000
+Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/168017101/10000
foo1 bar10 2
query: drop table hive_foo
query: drop table hive_bar
Added: hadoop/hive/trunk/ql/src/test/results/clientpositive/join_map_ppr.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/join_map_ppr.q.out?rev=802976&view=auto
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/join_map_ppr.q.out (added)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/join_map_ppr.q.out Tue Aug 11 02:06:23 2009
@@ -0,0 +1,466 @@
+query: CREATE TABLE dest_j1(key STRING, value STRING, val2 STRING) STORED AS TEXTFILE
+query: EXPLAIN EXTENDED
+INSERT OVERWRITE TABLE dest_j1
+SELECT /*+ MAPJOIN(x,y) */ x.key, z.value, y.value
+FROM src1 x JOIN src y ON (x.key = y.key)
+JOIN srcpart z ON (x.key = z.key)
+WHERE z.ds='2008-04-08' and z.hr=11
+ABSTRACT SYNTAX TREE:
+ (TOK_QUERY (TOK_FROM (TOK_JOIN (TOK_JOIN (TOK_TABREF src1 x) (TOK_TABREF src y) (= (. (TOK_TABLE_OR_COL x) key) (. (TOK_TABLE_OR_COL y) key))) (TOK_TABREF srcpart z) (= (. (TOK_TABLE_OR_COL x) key) (. (TOK_TABLE_OR_COL z) key)))) (TOK_INSERT (TOK_DESTINATION (TOK_TAB dest_j1)) (TOK_SELECT (TOK_HINTLIST (TOK_HINT TOK_MAPJOIN (TOK_HINTARGLIST x y))) (TOK_SELEXPR (. (TOK_TABLE_OR_COL x) key)) (TOK_SELEXPR (. (TOK_TABLE_OR_COL z) value)) (TOK_SELEXPR (. (TOK_TABLE_OR_COL y) value))) (TOK_WHERE (and (= (. (TOK_TABLE_OR_COL z) ds) '2008-04-08') (= (. (TOK_TABLE_OR_COL z) hr) 11)))))
+
+STAGE DEPENDENCIES:
+ Stage-1 is a root stage
+ Stage-4 depends on stages: Stage-1
+ Stage-0 depends on stages: Stage-4
+
+STAGE PLANS:
+ Stage: Stage-1
+ Map Reduce
+ Alias -> Map Operator Tree:
+ z
+ TableScan
+ alias: z
+ Filter Operator
+ isSamplingPred: false
+ predicate:
+ expr: ((ds = '2008-04-08') and (UDFToDouble(hr) = UDFToDouble(11)))
+ type: boolean
+ Common Join Operator
+ condition map:
+ Inner Join 0 to 1
+ Inner Join 0 to 2
+ condition expressions:
+ 0 {key}
+ 1 {value}
+ 2 {value} {ds} {hr}
+ keys:
+ 0
+ 1
+ 2
+ outputColumnNames: _col0, _col3, _col5, _col6, _col7
+ Position of Big Table: 2
+ Select Operator
+ expressions:
+ expr: _col0
+ type: string
+ expr: _col3
+ type: string
+ expr: _col5
+ type: string
+ expr: _col6
+ type: string
+ expr: _col7
+ type: string
+ outputColumnNames: _col0, _col3, _col5, _col6, _col7
+ Filter Operator
+ isSamplingPred: false
+ predicate:
+ expr: ((_col6 = '2008-04-08') and (UDFToDouble(_col7) = UDFToDouble(11)))
+ type: boolean
+ Select Operator
+ expressions:
+ expr: _col0
+ type: string
+ expr: _col5
+ type: string
+ expr: _col3
+ type: string
+ outputColumnNames: _col0, _col1, _col2
+ File Output Operator
+ compressed: false
+ GlobalTableId: 1
+ directory: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1816268167/10002
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ properties:
+ name dest_j1
+ columns.types string:string:string
+ serialization.ddl struct dest_j1 { string key, string value, string val2}
+ serialization.format 1
+ columns key,value,val2
+ bucket_count -1
+ 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_ws1/build/ql/test/data/warehouse/dest_j1
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ name: dest_j1
+ Local Work:
+ Map Reduce Local Work
+ Alias -> Map Local Tables:
+ y
+ Fetch Operator
+ limit: -1
+ x
+ Fetch Operator
+ limit: -1
+ Alias -> Map Local Operator Tree:
+ y
+ TableScan
+ alias: y
+ Common Join Operator
+ condition map:
+ Inner Join 0 to 1
+ Inner Join 0 to 2
+ condition expressions:
+ 0 {key}
+ 1 {value}
+ 2 {value} {ds} {hr}
+ keys:
+ 0
+ 1
+ 2
+ outputColumnNames: _col0, _col3, _col5, _col6, _col7
+ Position of Big Table: 2
+ Select Operator
+ expressions:
+ expr: _col0
+ type: string
+ expr: _col3
+ type: string
+ expr: _col5
+ type: string
+ expr: _col6
+ type: string
+ expr: _col7
+ type: string
+ outputColumnNames: _col0, _col3, _col5, _col6, _col7
+ Filter Operator
+ isSamplingPred: false
+ predicate:
+ expr: ((_col6 = '2008-04-08') and (UDFToDouble(_col7) = UDFToDouble(11)))
+ type: boolean
+ Select Operator
+ expressions:
+ expr: _col0
+ type: string
+ expr: _col5
+ type: string
+ expr: _col3
+ type: string
+ outputColumnNames: _col0, _col1, _col2
+ File Output Operator
+ compressed: false
+ GlobalTableId: 1
+ directory: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1816268167/10002
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ properties:
+ name dest_j1
+ columns.types string:string:string
+ serialization.ddl struct dest_j1 { string key, string value, string val2}
+ serialization.format 1
+ columns key,value,val2
+ bucket_count -1
+ 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_ws1/build/ql/test/data/warehouse/dest_j1
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ name: dest_j1
+ x
+ TableScan
+ alias: x
+ Common Join Operator
+ condition map:
+ Inner Join 0 to 1
+ Inner Join 0 to 2
+ condition expressions:
+ 0 {key}
+ 1 {value}
+ 2 {value} {ds} {hr}
+ keys:
+ 0
+ 1
+ 2
+ outputColumnNames: _col0, _col3, _col5, _col6, _col7
+ Position of Big Table: 2
+ Select Operator
+ expressions:
+ expr: _col0
+ type: string
+ expr: _col3
+ type: string
+ expr: _col5
+ type: string
+ expr: _col6
+ type: string
+ expr: _col7
+ type: string
+ outputColumnNames: _col0, _col3, _col5, _col6, _col7
+ Filter Operator
+ isSamplingPred: false
+ predicate:
+ expr: ((_col6 = '2008-04-08') and (UDFToDouble(_col7) = UDFToDouble(11)))
+ type: boolean
+ Select Operator
+ expressions:
+ expr: _col0
+ type: string
+ expr: _col5
+ type: string
+ expr: _col3
+ type: string
+ outputColumnNames: _col0, _col1, _col2
+ File Output Operator
+ compressed: false
+ GlobalTableId: 1
+ directory: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1816268167/10002
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ properties:
+ name dest_j1
+ columns.types string:string:string
+ serialization.ddl struct dest_j1 { string key, string value, string val2}
+ serialization.format 1
+ columns key,value,val2
+ bucket_count -1
+ 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_ws1/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/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11
+ Path -> Partition:
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11
+ Partition
+ partition values:
+ ds 2008-04-08
+ hr 11
+
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ properties:
+ name srcpart
+ columns.types string:string
+ serialization.ddl struct srcpart { string key, string value}
+ serialization.format 1
+ columns key,value
+ partition_columns ds/hr
+ bucket_count -1
+ 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_ws1/build/ql/test/data/warehouse/srcpart
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ name: srcpart
+
+ Stage: Stage-4
+ Conditional Operator
+ list of dependent Tasks:
+ Move Operator
+ files:
+ hdfs directory: true
+ source: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1816268167/10002
+ destination: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/2009479673/10000
+ Map Reduce
+ Alias -> Map Operator Tree:
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1816268167/10002
+ Reduce Output Operator
+ sort order:
+ Map-reduce partition columns:
+ expr: rand()
+ type: double
+ tag: -1
+ value expressions:
+ expr: key
+ type: string
+ expr: value
+ type: string
+ expr: val2
+ type: string
+ Needs Tagging: false
+ Path -> Alias:
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1816268167/10002
+ Path -> Partition:
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1816268167/10002
+ Partition
+
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ properties:
+ name dest_j1
+ columns.types string:string:string
+ serialization.ddl struct dest_j1 { string key, string value, string val2}
+ serialization.format 1
+ columns key,value,val2
+ bucket_count -1
+ 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_ws1/build/ql/test/data/warehouse/dest_j1
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ name: dest_j1
+ Reduce Operator Tree:
+ Extract
+ File Output Operator
+ compressed: false
+ GlobalTableId: 0
+ directory: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/2009479673/10000
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ properties:
+ name dest_j1
+ columns.types string:string:string
+ serialization.ddl struct dest_j1 { string key, string value, string val2}
+ serialization.format 1
+ columns key,value,val2
+ bucket_count -1
+ serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ file.inputformat org.apache.hadoop.mapred.TextInputFormat
+ location file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/dest_j1
+ file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ name: dest_j1
+
+ Stage: Stage-0
+ Move Operator
+ tables:
+ replace: true
+ source: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/2009479673/10000
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ properties:
+ name dest_j1
+ columns.types string:string:string
+ serialization.ddl struct dest_j1 { string key, string value, string val2}
+ serialization.format 1
+ columns key,value,val2
+ bucket_count -1
+ 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_ws1/build/ql/test/data/warehouse/dest_j1
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ name: dest_j1
+ tmp directory: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/2009479673/10001
+
+
+query: INSERT OVERWRITE TABLE dest_j1
+SELECT /*+ MAPJOIN(x,y) */ x.key, z.value, y.value
+FROM src1 x JOIN src y ON (x.key = y.key)
+JOIN srcpart z ON (x.key = z.key)
+WHERE z.ds='2008-04-08' and z.hr=11
+Input: default/srcpart/ds=2008-04-08/hr=11
+Input: default/src
+Input: default/src1
+Output: default/dest_j1
+query: select * from dest_j1 x order by x.key
+Input: default/dest_j1
+Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/494281575/10000
+128 val_128 val_128
+128 val_128 val_128
+128 val_128 val_128
+128 val_128 val_128
+128 val_128 val_128
+128 val_128 val_128
+128 val_128 val_128
+128 val_128 val_128
+128 val_128 val_128
+146 val_146 val_146
+146 val_146 val_146
+146 val_146 val_146
+146 val_146 val_146
+150 val_150 val_150
+213 val_213 val_213
+213 val_213 val_213
+213 val_213 val_213
+213 val_213 val_213
+224 val_224 val_224
+224 val_224 val_224
+224 val_224 val_224
+224 val_224 val_224
+238 val_238 val_238
+238 val_238 val_238
+238 val_238 val_238
+238 val_238 val_238
+255 val_255 val_255
+255 val_255 val_255
+255 val_255 val_255
+255 val_255 val_255
+273 val_273 val_273
+273 val_273 val_273
+273 val_273 val_273
+273 val_273 val_273
+273 val_273 val_273
+273 val_273 val_273
+273 val_273 val_273
+273 val_273 val_273
+273 val_273 val_273
+278 val_278 val_278
+278 val_278 val_278
+278 val_278 val_278
+278 val_278 val_278
+311 val_311 val_311
+311 val_311 val_311
+311 val_311 val_311
+311 val_311 val_311
+311 val_311 val_311
+311 val_311 val_311
+311 val_311 val_311
+311 val_311 val_311
+311 val_311 val_311
+369 val_369 val_369
+369 val_369 val_369
+369 val_369 val_369
+369 val_369 val_369
+369 val_369 val_369
+369 val_369 val_369
+369 val_369 val_369
+369 val_369 val_369
+369 val_369 val_369
+401 val_401 val_401
+401 val_401 val_401
+401 val_401 val_401
+401 val_401 val_401
+401 val_401 val_401
+401 val_401 val_401
+401 val_401 val_401
+401 val_401 val_401
+401 val_401 val_401
+401 val_401 val_401
+401 val_401 val_401
+401 val_401 val_401
+401 val_401 val_401
+401 val_401 val_401
+401 val_401 val_401
+401 val_401 val_401
+401 val_401 val_401
+401 val_401 val_401
+401 val_401 val_401
+401 val_401 val_401
+401 val_401 val_401
+401 val_401 val_401
+401 val_401 val_401
+401 val_401 val_401
+401 val_401 val_401
+406 val_406 val_406
+406 val_406 val_406
+406 val_406 val_406
+406 val_406 val_406
+406 val_406 val_406
+406 val_406 val_406
+406 val_406 val_406
+406 val_406 val_406
+406 val_406 val_406
+406 val_406 val_406
+406 val_406 val_406
+406 val_406 val_406
+406 val_406 val_406
+406 val_406 val_406
+406 val_406 val_406
+406 val_406 val_406
+66 val_66 val_66
+98 val_98 val_98
+98 val_98 val_98
+98 val_98 val_98
+98 val_98 val_98
+query: drop table dest_j1
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/join_rc.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/join_rc.q.out?rev=802976&r1=802975&r2=802976&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/join_rc.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/join_rc.q.out Tue Aug 11 02:06:23 2009
@@ -23,6 +23,8 @@
Map Reduce
Alias -> Map Operator Tree:
join_rc2
+ TableScan
+ alias: join_rc2
Reduce Output Operator
key expressions:
expr: key
@@ -36,6 +38,8 @@
expr: value
type: string
join_rc1
+ TableScan
+ alias: join_rc1
Reduce Output Operator
key expressions:
expr: key
@@ -79,7 +83,7 @@
FROM join_rc1 JOIN join_rc2 ON join_rc1.key = join_rc2.key
Input: default/join_rc2
Input: default/join_rc1
-Output: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/tmp/1293645641/10000
+Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/206616711/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=802976&r1=802975&r2=802976&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 Tue Aug 11 02:06:23 2009
@@ -22,6 +22,8 @@
Map Reduce
Alias -> Map Operator Tree:
s2
+ TableScan
+ alias: s2
Reduce Output Operator
key expressions:
expr: aint
@@ -35,6 +37,8 @@
expr: lintstring
type: array<struct<myint:int,mystring:string,underscore_int:int>>
s1
+ TableScan
+ alias: s1
Reduce Output Operator
key expressions:
expr: aint
@@ -79,7 +83,7 @@
JOIN src_thrift s2
ON s1.aint = s2.aint
Input: default/src_thrift
-Output: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_1/build/ql/tmp/2021763754/10000
+Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/589957555/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}]