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/10 03:05:14 UTC
svn commit: r763844 - in /hadoop/hive/trunk/ql/src/test:
queries/clientpositive/join22.q results/clientpositive/join22.q.out
Author: zshao
Date: Fri Apr 10 01:05:13 2009
New Revision: 763844
URL: http://svn.apache.org/viewvc?rev=763844&view=rev
Log:
HIVE-400. Forgot the new test case.
Added:
hadoop/hive/trunk/ql/src/test/queries/clientpositive/join22.q
hadoop/hive/trunk/ql/src/test/results/clientpositive/join22.q.out
Added: hadoop/hive/trunk/ql/src/test/queries/clientpositive/join22.q
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/queries/clientpositive/join22.q?rev=763844&view=auto
==============================================================================
--- hadoop/hive/trunk/ql/src/test/queries/clientpositive/join22.q (added)
+++ hadoop/hive/trunk/ql/src/test/queries/clientpositive/join22.q Fri Apr 10 01:05:13 2009
@@ -0,0 +1,2 @@
+explain
+SELECT src5.src1_value FROM (SELECT src3.*, src4.value as src4_value, src4.key as src4_key FROM src src4 JOIN (SELECT src2.*, src1.key as src1_key, src1.value as src1_value FROM src src1 JOIN src src2 ON src1.key = src2.key) src3 ON src3.src1_key = src4.key) src5;
Added: 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=763844&view=auto
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/join22.q.out (added)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/join22.q.out Fri Apr 10 01:05:13 2009
@@ -0,0 +1,141 @@
+ABSTRACT SYNTAX TREE:
+ (TOK_QUERY (TOK_FROM (TOK_SUBQUERY (TOK_QUERY (TOK_FROM (TOK_JOIN (TOK_TABREF src src4) (TOK_SUBQUERY (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 src2)) (TOK_SELEXPR (TOK_COLREF src1 key) src1_key) (TOK_SELEXPR (TOK_COLREF src1 value) src1_value)))) src3) (= (TOK_COLREF src3 src1_key) (TOK_COLREF src4 key)))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_ALLCOLREF src3)) (TOK_SELEXPR (TOK_COLREF src4 value) src4_value) (TOK_SELEXPR (TOK_COLREF src4 key) src4_key)))) src5)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_COLREF src5 src1_value)))))
+
+STAGE DEPENDENCIES:
+ Stage-1 is a root stage
+ Stage-2 depends on stages: Stage-1
+ Stage-0 is a root stage
+
+STAGE PLANS:
+ Stage: Stage-1
+ Map Reduce
+ Alias -> Map Operator Tree:
+ src5:src3:src2
+ 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
+ expr: value
+ type: string
+ src5:src3:src1
+ Reduce Output Operator
+ key expressions:
+ expr: key
+ type: string
+ sort order: +
+ Map-reduce partition columns:
+ expr: key
+ type: string
+ tag: 0
+ value expressions:
+ expr: key
+ type: string
+ expr: value
+ type: string
+ Reduce Operator Tree:
+ Join Operator
+ condition map:
+ Inner Join 0 to 1
+ condition expressions:
+ 0 {VALUE.0} {VALUE.1}
+ 1 {VALUE.0} {VALUE.1}
+ Select Operator
+ expressions:
+ expr: 2
+ type: string
+ expr: 3
+ type: string
+ expr: 0
+ type: string
+ expr: 1
+ type: string
+ File Output Operator
+ compressed: false
+ GlobalTableId: 0
+ table:
+ 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:
+ $INTNAME
+ Reduce Output Operator
+ key expressions:
+ expr: 3
+ type: string
+ sort order: +
+ Map-reduce partition columns:
+ expr: 3
+ type: string
+ tag: 1
+ value expressions:
+ expr: 0
+ type: string
+ expr: 1
+ type: string
+ expr: 3
+ type: string
+ expr: 4
+ type: string
+ src5:src4
+ Reduce Output Operator
+ key expressions:
+ expr: key
+ type: string
+ sort order: +
+ Map-reduce partition columns:
+ expr: key
+ type: string
+ tag: 0
+ value expressions:
+ expr: key
+ type: string
+ expr: value
+ type: string
+ Reduce Operator Tree:
+ Join Operator
+ condition map:
+ Inner Join 0 to 1
+ condition expressions:
+ 0 {VALUE.0} {VALUE.1}
+ 1 {VALUE.0} {VALUE.1} {VALUE.2} {VALUE.3}
+ 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
+ type: string
+ Select Operator
+ expressions:
+ expr: 3
+ type: string
+ 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
+
+