hadoop-hive-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From zs...@apache.org
Subject svn commit: r763845 - in /hadoop/hive/branches/branch-0.3/ql/src/test: queries/clientpositive/join22.q results/clientpositive/join22.q.out
Date Fri, 10 Apr 2009 01:05:42 GMT
Author: zshao
Date: Fri Apr 10 01:05:41 2009
New Revision: 763845

URL: http://svn.apache.org/viewvc?rev=763845&view=rev
Log:
HIVE-400. Forgot the new test case.

Added:
    hadoop/hive/branches/branch-0.3/ql/src/test/queries/clientpositive/join22.q
    hadoop/hive/branches/branch-0.3/ql/src/test/results/clientpositive/join22.q.out

Added: hadoop/hive/branches/branch-0.3/ql/src/test/queries/clientpositive/join22.q
URL: http://svn.apache.org/viewvc/hadoop/hive/branches/branch-0.3/ql/src/test/queries/clientpositive/join22.q?rev=763845&view=auto
==============================================================================
--- hadoop/hive/branches/branch-0.3/ql/src/test/queries/clientpositive/join22.q (added)
+++ hadoop/hive/branches/branch-0.3/ql/src/test/queries/clientpositive/join22.q Fri Apr 10
01:05:41 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/branches/branch-0.3/ql/src/test/results/clientpositive/join22.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/branches/branch-0.3/ql/src/test/results/clientpositive/join22.q.out?rev=763845&view=auto
==============================================================================
--- hadoop/hive/branches/branch-0.3/ql/src/test/results/clientpositive/join22.q.out (added)
+++ hadoop/hive/branches/branch-0.3/ql/src/test/results/clientpositive/join22.q.out Fri Apr
10 01:05:41 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
+
+



Mime
View raw message