You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by zs...@apache.org on 2009/04/27 21:00:10 UTC
svn commit: r769104 - in /hadoop/hive/branches/branch-0.3: ./
ql/src/test/queries/clientpositive/ ql/src/test/results/clientpositive/
Author: zshao
Date: Mon Apr 27 19:00:10 2009
New Revision: 769104
URL: http://svn.apache.org/viewvc?rev=769104&view=rev
Log:
HIVE-447. Fix tests on hudson. (Ashish Thusoo via zshao)
Modified:
hadoop/hive/branches/branch-0.3/CHANGES.txt
hadoop/hive/branches/branch-0.3/ql/src/test/queries/clientpositive/join15.q
hadoop/hive/branches/branch-0.3/ql/src/test/queries/clientpositive/join20.q
hadoop/hive/branches/branch-0.3/ql/src/test/queries/clientpositive/join21.q
hadoop/hive/branches/branch-0.3/ql/src/test/queries/clientpositive/join23.q
hadoop/hive/branches/branch-0.3/ql/src/test/results/clientpositive/join15.q.out
hadoop/hive/branches/branch-0.3/ql/src/test/results/clientpositive/join20.q.out
hadoop/hive/branches/branch-0.3/ql/src/test/results/clientpositive/join21.q.out
hadoop/hive/branches/branch-0.3/ql/src/test/results/clientpositive/join23.q.out
Modified: hadoop/hive/branches/branch-0.3/CHANGES.txt
URL: http://svn.apache.org/viewvc/hadoop/hive/branches/branch-0.3/CHANGES.txt?rev=769104&r1=769103&r2=769104&view=diff
==============================================================================
--- hadoop/hive/branches/branch-0.3/CHANGES.txt (original)
+++ hadoop/hive/branches/branch-0.3/CHANGES.txt Mon Apr 27 19:00:10 2009
@@ -175,6 +175,8 @@
HIVE-442. Move the data before creating the partition.
(Prasad Chakka via zshao)
+ HIVE-447. Fix tests on hudson. (Ashish Thusoo via zshao)
+
Release 0.2.0 - Unreleased
INCOMPATIBLE CHANGES
Modified: hadoop/hive/branches/branch-0.3/ql/src/test/queries/clientpositive/join15.q
URL: http://svn.apache.org/viewvc/hadoop/hive/branches/branch-0.3/ql/src/test/queries/clientpositive/join15.q?rev=769104&r1=769103&r2=769104&view=diff
==============================================================================
--- hadoop/hive/branches/branch-0.3/ql/src/test/queries/clientpositive/join15.q (original)
+++ hadoop/hive/branches/branch-0.3/ql/src/test/queries/clientpositive/join15.q Mon Apr 27 19:00:10 2009
@@ -1,4 +1,4 @@
EXPLAIN
-SELECT * FROM src src1 JOIN src src2 ON (src1.key = src2.key);
+SELECT * FROM src src1 JOIN src src2 ON (src1.key = src2.key) SORT BY src1.key, src1.value, src2.key, src2.value;
-SELECT * FROM src src1 JOIN src src2 ON (src1.key = src2.key);
+SELECT * FROM src src1 JOIN src src2 ON (src1.key = src2.key) SORT BY src1.key, src1.value, src2.key, src2.value;
Modified: hadoop/hive/branches/branch-0.3/ql/src/test/queries/clientpositive/join20.q
URL: http://svn.apache.org/viewvc/hadoop/hive/branches/branch-0.3/ql/src/test/queries/clientpositive/join20.q?rev=769104&r1=769103&r2=769104&view=diff
==============================================================================
--- hadoop/hive/branches/branch-0.3/ql/src/test/queries/clientpositive/join20.q (original)
+++ hadoop/hive/branches/branch-0.3/ql/src/test/queries/clientpositive/join20.q Mon Apr 27 19:00:10 2009
@@ -1,10 +1,14 @@
EXPLAIN
-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);
+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;
-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);
+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;
EXPLAIN
-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);
+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;
-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);
+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;
Modified: hadoop/hive/branches/branch-0.3/ql/src/test/queries/clientpositive/join21.q
URL: http://svn.apache.org/viewvc/hadoop/hive/branches/branch-0.3/ql/src/test/queries/clientpositive/join21.q?rev=769104&r1=769103&r2=769104&view=diff
==============================================================================
--- hadoop/hive/branches/branch-0.3/ql/src/test/queries/clientpositive/join21.q (original)
+++ hadoop/hive/branches/branch-0.3/ql/src/test/queries/clientpositive/join21.q Mon Apr 27 19:00:10 2009
@@ -1,4 +1,4 @@
EXPLAIN
-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);
+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;
-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);
+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;
Modified: hadoop/hive/branches/branch-0.3/ql/src/test/queries/clientpositive/join23.q
URL: http://svn.apache.org/viewvc/hadoop/hive/branches/branch-0.3/ql/src/test/queries/clientpositive/join23.q?rev=769104&r1=769103&r2=769104&view=diff
==============================================================================
--- hadoop/hive/branches/branch-0.3/ql/src/test/queries/clientpositive/join23.q (original)
+++ hadoop/hive/branches/branch-0.3/ql/src/test/queries/clientpositive/join23.q Mon Apr 27 19:00:10 2009
@@ -1,4 +1,4 @@
EXPLAIN
-SELECT * FROM src src1 JOIN src src2 WHERE src1.key < 10 and src2.key < 10;
+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;
-SELECT * FROM src src1 JOIN src src2 WHERE src1.key < 10 and src2.key < 10;
+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;
Modified: hadoop/hive/branches/branch-0.3/ql/src/test/results/clientpositive/join15.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/branches/branch-0.3/ql/src/test/results/clientpositive/join15.q.out?rev=769104&r1=769103&r2=769104&view=diff
==============================================================================
--- hadoop/hive/branches/branch-0.3/ql/src/test/results/clientpositive/join15.q.out (original)
+++ hadoop/hive/branches/branch-0.3/ql/src/test/results/clientpositive/join15.q.out Mon Apr 27 19:00:10 2009
@@ -1,8 +1,9 @@
ABSTRACT SYNTAX TREE:
- (TOK_QUERY (TOK_FROM (TOK_JOIN (TOK_TABREF src src1) (TOK_TABREF src src2) (= (TOK_COLREF src1 key) (TOK_COLREF src2 key)))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR TOK_ALLCOLREF))))
+ (TOK_QUERY (TOK_FROM (TOK_JOIN (TOK_TABREF src src1) (TOK_TABREF src src2) (= (TOK_COLREF src1 key) (TOK_COLREF src2 key)))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR TOK_ALLCOLREF)) (TOK_SORTBY (TOK_TABSORTCOLNAMEASC (TOK_COLREF src1 key)) (TOK_TABSORTCOLNAMEASC (TOK_COLREF src1 value)) (TOK_TABSORTCOLNAMEASC (TOK_COLREF src2 key)) (TOK_TABSORTCOLNAMEASC (TOK_COLREF src2 value)))))
STAGE DEPENDENCIES:
Stage-1 is a root stage
+ Stage-2 depends on stages: Stage-1
Stage-0 is a root stage
STAGE PLANS:
@@ -60,8 +61,43 @@
compressed: false
GlobalTableId: 0
table:
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ input format: org.apache.hadoop.mapred.SequenceFileInputFormat
+ output format: org.apache.hadoop.mapred.SequenceFileOutputFormat
+ name: binary_table
+
+ Stage: Stage-2
+ Map Reduce
+ Alias -> Map Operator Tree:
+ /data/users/zshao/tools/deploy-branch-0.3-apache-hive/build/ql/tmp/1602295505/85846766.10002
+ Reduce Output Operator
+ key expressions:
+ expr: 0
+ type: string
+ expr: 1
+ type: string
+ expr: 2
+ type: string
+ expr: 3
+ type: string
+ sort order: ++++
+ tag: -1
+ value expressions:
+ expr: 0
+ type: string
+ expr: 1
+ type: string
+ expr: 2
+ type: string
+ expr: 3
+ type: string
+ Reduce Operator Tree:
+ Extract
+ File Output Operator
+ compressed: false
+ GlobalTableId: 0
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
Stage: Stage-0
Fetch Operator
Modified: hadoop/hive/branches/branch-0.3/ql/src/test/results/clientpositive/join20.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/branches/branch-0.3/ql/src/test/results/clientpositive/join20.q.out?rev=769104&r1=769103&r2=769104&view=diff
==============================================================================
--- hadoop/hive/branches/branch-0.3/ql/src/test/results/clientpositive/join20.q.out (original)
+++ hadoop/hive/branches/branch-0.3/ql/src/test/results/clientpositive/join20.q.out Mon Apr 27 19:00:10 2009
@@ -1,8 +1,9 @@
ABSTRACT SYNTAX TREE:
- (TOK_QUERY (TOK_FROM (TOK_RIGHTOUTERJOIN (TOK_JOIN (TOK_TABREF src src1) (TOK_TABREF src src2) (AND (= (TOK_COLREF src1 key) (TOK_COLREF src2 key)) (< (TOK_COLREF src1 key) 10))) (TOK_TABREF src src3) (AND (= (TOK_COLREF src1 key) (TOK_COLREF src3 key)) (< (TOK_COLREF src3 key) 20)))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR TOK_ALLCOLREF))))
+ (TOK_QUERY (TOK_FROM (TOK_RIGHTOUTERJOIN (TOK_JOIN (TOK_TABREF src src1) (TOK_TABREF src src2) (AND (= (TOK_COLREF src1 key) (TOK_COLREF src2 key)) (< (TOK_COLREF src1 key) 10))) (TOK_TABREF src src3) (AND (= (TOK_COLREF src1 key) (TOK_COLREF src3 key)) (< (TOK_COLREF src3 key) 20)))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR TOK_ALLCOLREF)) (TOK_SORTBY (TOK_TABSORTCOLNAMEASC (TOK_COLREF src1 key)) (TOK_TABSORTCOLNAMEASC (TOK_COLREF src1 value)) (TOK_TABSORTCOLNAMEASC (TOK_COLREF src2 key)) (TOK_TABSORTCOLNAMEASC (TOK_COLREF src2 value)) (TOK_TABSORTCOLNAMEASC (TOK_COLREF src3 key)) (TOK_TABSORTCOLNAMEASC (TOK_COLREF src3 value)))))
STAGE DEPENDENCIES:
Stage-1 is a root stage
+ Stage-2 depends on stages: Stage-1
Stage-0 is a root stage
STAGE PLANS:
@@ -89,14 +90,67 @@
compressed: false
GlobalTableId: 0
table:
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ input format: org.apache.hadoop.mapred.SequenceFileInputFormat
+ output format: org.apache.hadoop.mapred.SequenceFileOutputFormat
+ name: binary_table
+
+ Stage: Stage-2
+ Map Reduce
+ Alias -> Map Operator Tree:
+ /data/users/zshao/tools/deploy-branch-0.3-apache-hive/build/ql/tmp/1131646699/1229951311.10002
+ Reduce Output Operator
+ key expressions:
+ expr: 0
+ type: string
+ expr: 1
+ type: string
+ expr: 2
+ type: string
+ expr: 3
+ type: string
+ expr: 4
+ type: string
+ expr: 5
+ type: string
+ sort order: ++++++
+ tag: -1
+ value expressions:
+ expr: 0
+ type: string
+ expr: 1
+ type: string
+ expr: 2
+ type: string
+ expr: 3
+ type: string
+ expr: 4
+ type: string
+ expr: 5
+ type: string
+ Reduce Operator Tree:
+ Extract
+ File Output Operator
+ compressed: false
+ GlobalTableId: 0
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
Stage: Stage-0
Fetch Operator
limit: -1
+NULL NULL NULL NULL 10 val_10
+NULL NULL NULL NULL 11 val_11
+NULL NULL NULL NULL 12 val_12
+NULL NULL NULL NULL 12 val_12
+NULL NULL NULL NULL 15 val_15
+NULL NULL NULL NULL 15 val_15
+NULL NULL NULL NULL 17 val_17
+NULL NULL NULL NULL 18 val_18
+NULL NULL NULL NULL 18 val_18
+NULL NULL NULL NULL 19 val_19
0 val_0 0 val_0 0 val_0
0 val_0 0 val_0 0 val_0
0 val_0 0 val_0 0 val_0
@@ -124,16 +178,6 @@
0 val_0 0 val_0 0 val_0
0 val_0 0 val_0 0 val_0
0 val_0 0 val_0 0 val_0
-NULL NULL NULL NULL 10 val_10
-NULL NULL NULL NULL 11 val_11
-NULL NULL NULL NULL 12 val_12
-NULL NULL NULL NULL 12 val_12
-NULL NULL NULL NULL 15 val_15
-NULL NULL NULL NULL 15 val_15
-NULL NULL NULL NULL 17 val_17
-NULL NULL NULL NULL 18 val_18
-NULL NULL NULL NULL 18 val_18
-NULL NULL NULL NULL 19 val_19
2 val_2 2 val_2 2 val_2
4 val_4 4 val_4 4 val_4
5 val_5 5 val_5 5 val_5
@@ -166,10 +210,11 @@
8 val_8 8 val_8 8 val_8
9 val_9 9 val_9 9 val_9
ABSTRACT SYNTAX TREE:
- (TOK_QUERY (TOK_FROM (TOK_RIGHTOUTERJOIN (TOK_JOIN (TOK_TABREF src src1) (TOK_TABREF src src2) (AND (AND (= (TOK_COLREF src1 key) (TOK_COLREF src2 key)) (< (TOK_COLREF src1 key) 10)) (< (TOK_COLREF src2 key) 15))) (TOK_TABREF src src3) (AND (= (TOK_COLREF src1 key) (TOK_COLREF src3 key)) (< (TOK_COLREF src3 key) 20)))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR TOK_ALLCOLREF))))
+ (TOK_QUERY (TOK_FROM (TOK_RIGHTOUTERJOIN (TOK_JOIN (TOK_TABREF src src1) (TOK_TABREF src src2) (AND (AND (= (TOK_COLREF src1 key) (TOK_COLREF src2 key)) (< (TOK_COLREF src1 key) 10)) (< (TOK_COLREF src2 key) 15))) (TOK_TABREF src src3) (AND (= (TOK_COLREF src1 key) (TOK_COLREF src3 key)) (< (TOK_COLREF src3 key) 20)))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR TOK_ALLCOLREF)) (TOK_SORTBY (TOK_TABSORTCOLNAMEASC (TOK_COLREF src1 key)) (TOK_TABSORTCOLNAMEASC (TOK_COLREF src1 value)) (TOK_TABSORTCOLNAMEASC (TOK_COLREF src2 key)) (TOK_TABSORTCOLNAMEASC (TOK_COLREF src2 value)) (TOK_TABSORTCOLNAMEASC (TOK_COLREF src3 key)) (TOK_TABSORTCOLNAMEASC (TOK_COLREF src3 value)))))
STAGE DEPENDENCIES:
Stage-1 is a root stage
+ Stage-2 depends on stages: Stage-1
Stage-0 is a root stage
STAGE PLANS:
@@ -260,14 +305,67 @@
compressed: false
GlobalTableId: 0
table:
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ input format: org.apache.hadoop.mapred.SequenceFileInputFormat
+ output format: org.apache.hadoop.mapred.SequenceFileOutputFormat
+ name: binary_table
+
+ Stage: Stage-2
+ Map Reduce
+ Alias -> Map Operator Tree:
+ /data/users/zshao/tools/deploy-branch-0.3-apache-hive/build/ql/tmp/309845863/532052270.10002
+ Reduce Output Operator
+ key expressions:
+ expr: 0
+ type: string
+ expr: 1
+ type: string
+ expr: 2
+ type: string
+ expr: 3
+ type: string
+ expr: 4
+ type: string
+ expr: 5
+ type: string
+ sort order: ++++++
+ tag: -1
+ value expressions:
+ expr: 0
+ type: string
+ expr: 1
+ type: string
+ expr: 2
+ type: string
+ expr: 3
+ type: string
+ expr: 4
+ type: string
+ expr: 5
+ type: string
+ Reduce Operator Tree:
+ Extract
+ File Output Operator
+ compressed: false
+ GlobalTableId: 0
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
Stage: Stage-0
Fetch Operator
limit: -1
+NULL NULL NULL NULL 10 val_10
+NULL NULL NULL NULL 11 val_11
+NULL NULL NULL NULL 12 val_12
+NULL NULL NULL NULL 12 val_12
+NULL NULL NULL NULL 15 val_15
+NULL NULL NULL NULL 15 val_15
+NULL NULL NULL NULL 17 val_17
+NULL NULL NULL NULL 18 val_18
+NULL NULL NULL NULL 18 val_18
+NULL NULL NULL NULL 19 val_19
0 val_0 0 val_0 0 val_0
0 val_0 0 val_0 0 val_0
0 val_0 0 val_0 0 val_0
@@ -295,16 +393,6 @@
0 val_0 0 val_0 0 val_0
0 val_0 0 val_0 0 val_0
0 val_0 0 val_0 0 val_0
-NULL NULL NULL NULL 10 val_10
-NULL NULL NULL NULL 11 val_11
-NULL NULL NULL NULL 12 val_12
-NULL NULL NULL NULL 12 val_12
-NULL NULL NULL NULL 15 val_15
-NULL NULL NULL NULL 15 val_15
-NULL NULL NULL NULL 17 val_17
-NULL NULL NULL NULL 18 val_18
-NULL NULL NULL NULL 18 val_18
-NULL NULL NULL NULL 19 val_19
2 val_2 2 val_2 2 val_2
4 val_4 4 val_4 4 val_4
5 val_5 5 val_5 5 val_5
Modified: hadoop/hive/branches/branch-0.3/ql/src/test/results/clientpositive/join21.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/branches/branch-0.3/ql/src/test/results/clientpositive/join21.q.out?rev=769104&r1=769103&r2=769104&view=diff
==============================================================================
--- hadoop/hive/branches/branch-0.3/ql/src/test/results/clientpositive/join21.q.out (original)
+++ hadoop/hive/branches/branch-0.3/ql/src/test/results/clientpositive/join21.q.out Mon Apr 27 19:00:10 2009
@@ -1,8 +1,9 @@
ABSTRACT SYNTAX TREE:
- (TOK_QUERY (TOK_FROM (TOK_RIGHTOUTERJOIN (TOK_LEFTOUTERJOIN (TOK_TABREF src src1) (TOK_TABREF src src2) (AND (AND (= (TOK_COLREF src1 key) (TOK_COLREF src2 key)) (< (TOK_COLREF src1 key) 10)) (> (TOK_COLREF src2 key) 10))) (TOK_TABREF src src3) (AND (= (TOK_COLREF src2 key) (TOK_COLREF src3 key)) (< (TOK_COLREF src3 key) 10)))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR TOK_ALLCOLREF))))
+ (TOK_QUERY (TOK_FROM (TOK_RIGHTOUTERJOIN (TOK_LEFTOUTERJOIN (TOK_TABREF src src1) (TOK_TABREF src src2) (AND (AND (= (TOK_COLREF src1 key) (TOK_COLREF src2 key)) (< (TOK_COLREF src1 key) 10)) (> (TOK_COLREF src2 key) 10))) (TOK_TABREF src src3) (AND (= (TOK_COLREF src2 key) (TOK_COLREF src3 key)) (< (TOK_COLREF src3 key) 10)))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR TOK_ALLCOLREF)) (TOK_SORTBY (TOK_TABSORTCOLNAMEASC (TOK_COLREF src1 key)) (TOK_TABSORTCOLNAMEASC (TOK_COLREF src1 value)) (TOK_TABSORTCOLNAMEASC (TOK_COLREF src2 key)) (TOK_TABSORTCOLNAMEASC (TOK_COLREF src2 value)) (TOK_TABSORTCOLNAMEASC (TOK_COLREF src3 key)) (TOK_TABSORTCOLNAMEASC (TOK_COLREF src3 value)))))
STAGE DEPENDENCIES:
Stage-1 is a root stage
+ Stage-2 depends on stages: Stage-1
Stage-0 is a root stage
STAGE PLANS:
@@ -93,8 +94,51 @@
compressed: false
GlobalTableId: 0
table:
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ input format: org.apache.hadoop.mapred.SequenceFileInputFormat
+ output format: org.apache.hadoop.mapred.SequenceFileOutputFormat
+ name: binary_table
+
+ Stage: Stage-2
+ Map Reduce
+ Alias -> Map Operator Tree:
+ /data/users/zshao/tools/deploy-branch-0.3-apache-hive/build/ql/tmp/310189506/331368129.10002
+ Reduce Output Operator
+ key expressions:
+ expr: 0
+ type: string
+ expr: 1
+ type: string
+ expr: 2
+ type: string
+ expr: 3
+ type: string
+ expr: 4
+ type: string
+ expr: 5
+ type: string
+ sort order: ++++++
+ tag: -1
+ value expressions:
+ expr: 0
+ type: string
+ expr: 1
+ type: string
+ expr: 2
+ type: string
+ expr: 3
+ type: string
+ expr: 4
+ type: string
+ expr: 5
+ type: string
+ Reduce Operator Tree:
+ Extract
+ File Output Operator
+ compressed: false
+ GlobalTableId: 0
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
Stage: Stage-0
Fetch Operator
Modified: hadoop/hive/branches/branch-0.3/ql/src/test/results/clientpositive/join23.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/branches/branch-0.3/ql/src/test/results/clientpositive/join23.q.out?rev=769104&r1=769103&r2=769104&view=diff
==============================================================================
--- hadoop/hive/branches/branch-0.3/ql/src/test/results/clientpositive/join23.q.out (original)
+++ hadoop/hive/branches/branch-0.3/ql/src/test/results/clientpositive/join23.q.out Mon Apr 27 19:00:10 2009
@@ -1,8 +1,9 @@
ABSTRACT SYNTAX TREE:
- (TOK_QUERY (TOK_FROM (TOK_JOIN (TOK_TABREF src src1) (TOK_TABREF src src2))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR TOK_ALLCOLREF)) (TOK_WHERE (and (< (TOK_COLREF src1 key) 10) (< (TOK_COLREF src2 key) 10)))))
+ (TOK_QUERY (TOK_FROM (TOK_JOIN (TOK_TABREF src src1) (TOK_TABREF src src2))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR TOK_ALLCOLREF)) (TOK_WHERE (and (< (TOK_COLREF src1 key) 10) (< (TOK_COLREF src2 key) 10))) (TOK_SORTBY (TOK_TABSORTCOLNAMEASC (TOK_COLREF src1 key)) (TOK_TABSORTCOLNAMEASC (TOK_COLREF src1 value)) (TOK_TABSORTCOLNAMEASC (TOK_COLREF src2 key)) (TOK_TABSORTCOLNAMEASC (TOK_COLREF src2 value)))))
STAGE DEPENDENCIES:
Stage-1 is a root stage
+ Stage-2 depends on stages: Stage-1
Stage-0 is a root stage
STAGE PLANS:
@@ -52,111 +53,146 @@
compressed: false
GlobalTableId: 0
table:
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ input format: org.apache.hadoop.mapred.SequenceFileInputFormat
+ output format: org.apache.hadoop.mapred.SequenceFileOutputFormat
+ name: binary_table
+
+ Stage: Stage-2
+ Map Reduce
+ Alias -> Map Operator Tree:
+ /data/users/zshao/tools/deploy-branch-0.3-apache-hive/build/ql/tmp/1182989771/109019465.10002
+ Reduce Output Operator
+ key expressions:
+ expr: 0
+ type: string
+ expr: 1
+ type: string
+ expr: 2
+ type: string
+ expr: 3
+ type: string
+ sort order: ++++
+ tag: -1
+ value expressions:
+ expr: 0
+ type: string
+ expr: 1
+ type: string
+ expr: 2
+ type: string
+ expr: 3
+ type: string
+ Reduce Operator Tree:
+ Extract
+ File Output Operator
+ compressed: false
+ GlobalTableId: 0
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
Stage: Stage-0
Fetch Operator
limit: -1
-5 val_5 2 val_2
-5 val_5 5 val_5
-5 val_5 9 val_9
-5 val_5 4 val_4
-5 val_5 8 val_8
-5 val_5 0 val_0
-5 val_5 5 val_5
-5 val_5 5 val_5
-5 val_5 0 val_0
-5 val_5 0 val_0
-0 val_0 2 val_2
-0 val_0 5 val_5
-0 val_0 9 val_9
-0 val_0 4 val_4
-0 val_0 8 val_8
0 val_0 0 val_0
-0 val_0 5 val_5
-0 val_0 5 val_5
0 val_0 0 val_0
0 val_0 0 val_0
-8 val_8 2 val_2
-8 val_8 5 val_5
-8 val_8 9 val_9
-8 val_8 4 val_4
-8 val_8 8 val_8
-8 val_8 0 val_0
-8 val_8 5 val_5
-8 val_8 5 val_5
-8 val_8 0 val_0
-8 val_8 0 val_0
+0 val_0 0 val_0
+0 val_0 0 val_0
+0 val_0 0 val_0
+0 val_0 0 val_0
+0 val_0 0 val_0
+0 val_0 0 val_0
+0 val_0 2 val_2
+0 val_0 2 val_2
0 val_0 2 val_2
-0 val_0 5 val_5
-0 val_0 9 val_9
0 val_0 4 val_4
-0 val_0 8 val_8
-0 val_0 0 val_0
+0 val_0 4 val_4
+0 val_0 4 val_4
0 val_0 5 val_5
0 val_0 5 val_5
-0 val_0 0 val_0
-0 val_0 0 val_0
+0 val_0 5 val_5
+0 val_0 5 val_5
+0 val_0 5 val_5
+0 val_0 5 val_5
+0 val_0 5 val_5
+0 val_0 5 val_5
+0 val_0 5 val_5
+0 val_0 8 val_8
+0 val_0 8 val_8
+0 val_0 8 val_8
+0 val_0 9 val_9
+0 val_0 9 val_9
+0 val_0 9 val_9
+2 val_2 0 val_0
+2 val_2 0 val_0
+2 val_2 0 val_0
2 val_2 2 val_2
-2 val_2 5 val_5
-2 val_2 9 val_9
2 val_2 4 val_4
-2 val_2 8 val_8
-2 val_2 0 val_0
2 val_2 5 val_5
2 val_2 5 val_5
-2 val_2 0 val_0
-2 val_2 0 val_0
-5 val_5 2 val_2
-5 val_5 5 val_5
-5 val_5 9 val_9
-5 val_5 4 val_4
-5 val_5 8 val_8
+2 val_2 5 val_5
+2 val_2 8 val_8
+2 val_2 9 val_9
+4 val_4 0 val_0
+4 val_4 0 val_0
+4 val_4 0 val_0
+4 val_4 2 val_2
+4 val_4 4 val_4
+4 val_4 5 val_5
+4 val_4 5 val_5
+4 val_4 5 val_5
+4 val_4 8 val_8
+4 val_4 9 val_9
+5 val_5 0 val_0
+5 val_5 0 val_0
+5 val_5 0 val_0
+5 val_5 0 val_0
+5 val_5 0 val_0
+5 val_5 0 val_0
5 val_5 0 val_0
-5 val_5 5 val_5
-5 val_5 5 val_5
5 val_5 0 val_0
5 val_5 0 val_0
5 val_5 2 val_2
-5 val_5 5 val_5
-5 val_5 9 val_9
+5 val_5 2 val_2
+5 val_5 2 val_2
+5 val_5 4 val_4
+5 val_5 4 val_4
5 val_5 4 val_4
-5 val_5 8 val_8
-5 val_5 0 val_0
5 val_5 5 val_5
5 val_5 5 val_5
-5 val_5 0 val_0
-5 val_5 0 val_0
-0 val_0 2 val_2
-0 val_0 5 val_5
-0 val_0 9 val_9
-0 val_0 4 val_4
-0 val_0 8 val_8
-0 val_0 0 val_0
-0 val_0 5 val_5
-0 val_0 5 val_5
-0 val_0 0 val_0
-0 val_0 0 val_0
+5 val_5 5 val_5
+5 val_5 5 val_5
+5 val_5 5 val_5
+5 val_5 5 val_5
+5 val_5 5 val_5
+5 val_5 5 val_5
+5 val_5 5 val_5
+5 val_5 8 val_8
+5 val_5 8 val_8
+5 val_5 8 val_8
+5 val_5 9 val_9
+5 val_5 9 val_9
+5 val_5 9 val_9
+8 val_8 0 val_0
+8 val_8 0 val_0
+8 val_8 0 val_0
+8 val_8 2 val_2
+8 val_8 4 val_4
+8 val_8 5 val_5
+8 val_8 5 val_5
+8 val_8 5 val_5
+8 val_8 8 val_8
+8 val_8 9 val_9
+9 val_9 0 val_0
+9 val_9 0 val_0
+9 val_9 0 val_0
9 val_9 2 val_2
-9 val_9 5 val_5
-9 val_9 9 val_9
9 val_9 4 val_4
-9 val_9 8 val_8
-9 val_9 0 val_0
9 val_9 5 val_5
9 val_9 5 val_5
-9 val_9 0 val_0
-9 val_9 0 val_0
-4 val_4 2 val_2
-4 val_4 5 val_5
-4 val_4 9 val_9
-4 val_4 4 val_4
-4 val_4 8 val_8
-4 val_4 0 val_0
-4 val_4 5 val_5
-4 val_4 5 val_5
-4 val_4 0 val_0
-4 val_4 0 val_0
+9 val_9 5 val_5
+9 val_9 8 val_8
+9 val_9 9 val_9