hadoop-common-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From zs...@apache.org
Subject svn commit: r697291 [20/31] - in /hadoop/core/trunk: ./ src/contrib/hive/cli/src/java/org/apache/hadoop/hive/cli/ src/contrib/hive/metastore/if/ src/contrib/hive/metastore/src/gen-javabean/org/apache/hadoop/hive/metastore/api/ src/contrib/hive/metastor...
Date Fri, 19 Sep 2008 23:56:35 GMT
Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/join5.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/join5.q.out?rev=697291&r1=697290&r2=697291&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/join5.q.out (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/join5.q.out Fri Sep 19 16:56:30 2008
@@ -1,108 +1,110 @@
-ABSTRACT SYNTAX TREE:	
-  (TOK_QUERY (TOK_FROM (TOK_SUBQUERY (TOK_QUERY (TOK_FROM (TOK_RIGHTOUTERJOIN (TOK_SUBQUERY (TOK_QUERY (TOK_FROM (TOK_TABREF src src1)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_COLREF src1 key) c1) (TOK_SELEXPR (TOK_COLREF src1 value) c2)) (TOK_WHERE (and (> (TOK_COLREF src1 key) 10) (< (TOK_COLREF src1 key) 20))))) a) (TOK_SUBQUERY (TOK_QUERY (TOK_FROM (TOK_TABREF src src2)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_COLREF src2 key) c3) (TOK_SELEXPR (TOK_COLREF src2 value) c4)) (TOK_WHERE (and (> (TOK_COLREF src2 key) 15) (< (TOK_COLREF src2 key) 25))))) b) (= (TOK_COLREF a c1) (TOK_COLREF b c3)))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_COLREF a c1) c1) (TOK_SELEXPR (TOK_COLREF a c2) c2) (TOK_SELEXPR (TOK_COLREF b c3) c3) (TOK_SELEXPR (TOK_COLREF b c4) c4)))) c)) (TOK_INSERT (TOK_DESTINATION (TOK_TAB dest1)) (TOK_SELECT (TOK_SELEXPR (TOK_COLREF c c1
 )) (TOK_SELEXPR (TOK_COLREF c c2)) (TOK_SELEXPR (TOK_COLREF c c3)) (TOK_SELEXPR (TOK_COLREF c c4)))))	
-	
-STAGE DEPENDENCIES:	
-  Stage-1 is a root stage	
-  Stage-0 depends on stages: Stage-1	
-	
-STAGE PLANS:	
-  Stage: Stage-1	
-    Map Reduce	
-      Reduce Operator Tree:	
-        Join Operator	
-          condition expressions:	
-            0 {VALUE.0} {VALUE.1}	
-            1 {VALUE.0} {VALUE.1}	
-          condition map:	
-               Right Outer Join0 to 1	
-          Select Operator	
-            expressions:	
-                  expr: 0	
-                  type: class java.lang.String	
-                  expr: 1	
-                  type: class java.lang.String	
-                  expr: 2	
-                  type: class java.lang.String	
-                  expr: 3	
-                  type: class java.lang.String	
-            Select Operator	
-              expressions:	
-                    expr: 0	
-                    type: class java.lang.String	
-                    expr: 1	
-                    type: class java.lang.String	
-                    expr: 2	
-                    type: class java.lang.String	
-                    expr: 3	
-                    type: class java.lang.String	
-              File Output Operator	
-                table:	
-                    name: dest1	
-                    serde: org.apache.hadoop.hive.serde.simple_meta.MetadataTypedColumnsetSerDe	
-                    input format: org.apache.hadoop.mapred.TextInputFormat	
-                    output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat	
-      Alias -> Map Operator Tree:	
-        c:b:src2 	
-            Filter Operator	
-              predicate:	
-                  expr: ((key > 15) and (key < 25))	
-                  type: class java.lang.Boolean	
-              Select Operator	
-                expressions:	
-                      expr: key	
-                      type: class java.lang.String	
-                      expr: value	
-                      type: class java.lang.String	
-                Reduce Output Operator	
-                  tag: 1	
-                  key expressions:	
-                        expr: 0	
-                        type: class java.lang.String	
-                  value expressions:	
-                        expr: 0	
-                        type: class java.lang.String	
-                        expr: 1	
-                        type: class java.lang.String	
-                  # partition fields: 1	
-        c:a:src1 	
-            Filter Operator	
-              predicate:	
-                  expr: ((key > 10) and (key < 20))	
-                  type: class java.lang.Boolean	
-              Select Operator	
-                expressions:	
-                      expr: key	
-                      type: class java.lang.String	
-                      expr: value	
-                      type: class java.lang.String	
-                Reduce Output Operator	
-                  tag: 0	
-                  key expressions:	
-                        expr: 0	
-                        type: class java.lang.String	
-                  value expressions:	
-                        expr: 0	
-                        type: class java.lang.String	
-                        expr: 1	
-                        type: class java.lang.String	
-                  # partition fields: 1	
-	
-  Stage: Stage-0	
-    Move Operator	
-      tables:	
-            table:	
-                name: dest1	
-                serde: org.apache.hadoop.hive.serde.simple_meta.MetadataTypedColumnsetSerDe	
-                input format: org.apache.hadoop.mapred.TextInputFormat	
-                output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat	
-            replace:	
-	
-17	val_17	17	val_17	
-18	val_18	18	val_18	
-18	val_18	18	val_18	
-18	val_18	18	val_18	
-18	val_18	18	val_18	
-19	val_19	19	val_19	
-NULL	NULL	20	val_20	
-NULL	NULL	24	val_24	
-NULL	NULL	24	val_24	
+ABSTRACT SYNTAX TREE:
+  (TOK_QUERY (TOK_FROM (TOK_SUBQUERY (TOK_QUERY (TOK_FROM (TOK_RIGHTOUTERJOIN (TOK_SUBQUERY (TOK_QUERY (TOK_FROM (TOK_TABREF src src1)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_COLREF src1 key) c1) (TOK_SELEXPR (TOK_COLREF src1 value) c2)) (TOK_WHERE (and (> (TOK_COLREF src1 key) 10) (< (TOK_COLREF src1 key) 20))))) a) (TOK_SUBQUERY (TOK_QUERY (TOK_FROM (TOK_TABREF src src2)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_COLREF src2 key) c3) (TOK_SELEXPR (TOK_COLREF src2 value) c4)) (TOK_WHERE (and (> (TOK_COLREF src2 key) 15) (< (TOK_COLREF src2 key) 25))))) b) (= (TOK_COLREF a c1) (TOK_COLREF b c3)))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_COLREF a c1) c1) (TOK_SELEXPR (TOK_COLREF a c2) c2) (TOK_SELEXPR (TOK_COLREF b c3) c3) (TOK_SELEXPR (TOK_COLREF b c4) c4)))) c)) (TOK_INSERT (TOK_DESTINATION (TOK_TAB dest1)) (TOK_SELECT (TOK_SELEXPR (TOK_COLREF c c1
 )) (TOK_SELEXPR (TOK_COLREF c c2)) (TOK_SELEXPR (TOK_COLREF c c3)) (TOK_SELEXPR (TOK_COLREF c c4)))))
+
+STAGE DEPENDENCIES:
+  Stage-1 is a root stage
+  Stage-0 depends on stages: Stage-1
+
+STAGE PLANS:
+  Stage: Stage-1
+    Map Reduce
+      Reduce Operator Tree:
+        Join Operator
+          condition expressions:
+            0 {VALUE.0} {VALUE.1}
+            1 {VALUE.0} {VALUE.1}
+          condition map:
+               Right Outer Join0 to 1
+          Select Operator
+            expressions:
+                  expr: 0
+                  type: string
+                  expr: 1
+                  type: string
+                  expr: 2
+                  type: string
+                  expr: 3
+                  type: string
+            Select Operator
+              expressions:
+                    expr: 0
+                    type: string
+                    expr: 1
+                    type: string
+                    expr: 2
+                    type: string
+                    expr: 3
+                    type: string
+              File Output Operator
+                table:
+                    name: dest1
+                    serde: simple_meta
+                    input format: org.apache.hadoop.mapred.TextInputFormat
+                    output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+      Alias -> Map Operator Tree:
+        c:b:src2 
+            Filter Operator
+              predicate:
+                  expr: ((key > 15) and (key < 25))
+                  type: Boolean
+              Select Operator
+                expressions:
+                      expr: key
+                      type: string
+                      expr: value
+                      type: string
+                Reduce Output Operator
+                  tag: 1
+                  key expressions:
+                        expr: 0
+                        type: string
+                  value expressions:
+                        expr: 0
+                        type: string
+                        expr: 1
+                        type: string
+                  # partition fields: 1
+        c:a:src1 
+            Filter Operator
+              predicate:
+                  expr: ((key > 10) and (key < 20))
+                  type: Boolean
+              Select Operator
+                expressions:
+                      expr: key
+                      type: string
+                      expr: value
+                      type: string
+                Reduce Output Operator
+                  tag: 0
+                  key expressions:
+                        expr: 0
+                        type: string
+                  value expressions:
+                        expr: 0
+                        type: string
+                        expr: 1
+                        type: string
+                  # partition fields: 1
+
+  Stage: Stage-0
+    Move Operator
+      tables:
+            table:
+                name: dest1
+                serde: simple_meta
+                input format: org.apache.hadoop.mapred.TextInputFormat
+                output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+            replace:
+
+
+17	val_17	17	val_17
+18	val_18	18	val_18
+18	val_18	18	val_18
+18	val_18	18	val_18
+18	val_18	18	val_18
+19	val_19	19	val_19
+NULL	NULL	20	val_20
+NULL	NULL	24	val_24
+NULL	NULL	24	val_24
+

Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/join6.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/join6.q.out?rev=697291&r1=697290&r2=697291&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/join6.q.out (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/join6.q.out Fri Sep 19 16:56:30 2008
@@ -1,113 +1,115 @@
-ABSTRACT SYNTAX TREE:	
-  (TOK_QUERY (TOK_FROM (TOK_SUBQUERY (TOK_QUERY (TOK_FROM (TOK_FULLOUTERJOIN (TOK_SUBQUERY (TOK_QUERY (TOK_FROM (TOK_TABREF src src1)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_COLREF src1 key) c1) (TOK_SELEXPR (TOK_COLREF src1 value) c2)) (TOK_WHERE (and (> (TOK_COLREF src1 key) 10) (< (TOK_COLREF src1 key) 20))))) a) (TOK_SUBQUERY (TOK_QUERY (TOK_FROM (TOK_TABREF src src2)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_COLREF src2 key) c3) (TOK_SELEXPR (TOK_COLREF src2 value) c4)) (TOK_WHERE (and (> (TOK_COLREF src2 key) 15) (< (TOK_COLREF src2 key) 25))))) b) (= (TOK_COLREF a c1) (TOK_COLREF b c3)))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_COLREF a c1) c1) (TOK_SELEXPR (TOK_COLREF a c2) c2) (TOK_SELEXPR (TOK_COLREF b c3) c3) (TOK_SELEXPR (TOK_COLREF b c4) c4)))) c)) (TOK_INSERT (TOK_DESTINATION (TOK_TAB dest1)) (TOK_SELECT (TOK_SELEXPR (TOK_COLREF c c1)
 ) (TOK_SELEXPR (TOK_COLREF c c2)) (TOK_SELEXPR (TOK_COLREF c c3)) (TOK_SELEXPR (TOK_COLREF c c4)))))	
-	
-STAGE DEPENDENCIES:	
-  Stage-1 is a root stage	
-  Stage-0 depends on stages: Stage-1	
-	
-STAGE PLANS:	
-  Stage: Stage-1	
-    Map Reduce	
-      Reduce Operator Tree:	
-        Join Operator	
-          condition expressions:	
-            0 {VALUE.0} {VALUE.1}	
-            1 {VALUE.0} {VALUE.1}	
-          condition map:	
-               Outer Join 0 to 1	
-          Select Operator	
-            expressions:	
-                  expr: 0	
-                  type: class java.lang.String	
-                  expr: 1	
-                  type: class java.lang.String	
-                  expr: 2	
-                  type: class java.lang.String	
-                  expr: 3	
-                  type: class java.lang.String	
-            Select Operator	
-              expressions:	
-                    expr: 0	
-                    type: class java.lang.String	
-                    expr: 1	
-                    type: class java.lang.String	
-                    expr: 2	
-                    type: class java.lang.String	
-                    expr: 3	
-                    type: class java.lang.String	
-              File Output Operator	
-                table:	
-                    name: dest1	
-                    serde: org.apache.hadoop.hive.serde.simple_meta.MetadataTypedColumnsetSerDe	
-                    input format: org.apache.hadoop.mapred.TextInputFormat	
-                    output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat	
-      Alias -> Map Operator Tree:	
-        c:b:src2 	
-            Filter Operator	
-              predicate:	
-                  expr: ((key > 15) and (key < 25))	
-                  type: class java.lang.Boolean	
-              Select Operator	
-                expressions:	
-                      expr: key	
-                      type: class java.lang.String	
-                      expr: value	
-                      type: class java.lang.String	
-                Reduce Output Operator	
-                  tag: 1	
-                  key expressions:	
-                        expr: 0	
-                        type: class java.lang.String	
-                  value expressions:	
-                        expr: 0	
-                        type: class java.lang.String	
-                        expr: 1	
-                        type: class java.lang.String	
-                  # partition fields: 1	
-        c:a:src1 	
-            Filter Operator	
-              predicate:	
-                  expr: ((key > 10) and (key < 20))	
-                  type: class java.lang.Boolean	
-              Select Operator	
-                expressions:	
-                      expr: key	
-                      type: class java.lang.String	
-                      expr: value	
-                      type: class java.lang.String	
-                Reduce Output Operator	
-                  tag: 0	
-                  key expressions:	
-                        expr: 0	
-                        type: class java.lang.String	
-                  value expressions:	
-                        expr: 0	
-                        type: class java.lang.String	
-                        expr: 1	
-                        type: class java.lang.String	
-                  # partition fields: 1	
-	
-  Stage: Stage-0	
-    Move Operator	
-      tables:	
-            table:	
-                name: dest1	
-                serde: org.apache.hadoop.hive.serde.simple_meta.MetadataTypedColumnsetSerDe	
-                input format: org.apache.hadoop.mapred.TextInputFormat	
-                output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat	
-            replace:	
-	
-11	val_11	NULL	NULL	
-12	val_12	NULL	NULL	
-12	val_12	NULL	NULL	
-15	val_15	NULL	NULL	
-15	val_15	NULL	NULL	
-17	val_17	17	val_17	
-18	val_18	18	val_18	
-18	val_18	18	val_18	
-18	val_18	18	val_18	
-18	val_18	18	val_18	
-19	val_19	19	val_19	
-NULL	NULL	20	val_20	
-NULL	NULL	24	val_24	
-NULL	NULL	24	val_24	
+ABSTRACT SYNTAX TREE:
+  (TOK_QUERY (TOK_FROM (TOK_SUBQUERY (TOK_QUERY (TOK_FROM (TOK_FULLOUTERJOIN (TOK_SUBQUERY (TOK_QUERY (TOK_FROM (TOK_TABREF src src1)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_COLREF src1 key) c1) (TOK_SELEXPR (TOK_COLREF src1 value) c2)) (TOK_WHERE (and (> (TOK_COLREF src1 key) 10) (< (TOK_COLREF src1 key) 20))))) a) (TOK_SUBQUERY (TOK_QUERY (TOK_FROM (TOK_TABREF src src2)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_COLREF src2 key) c3) (TOK_SELEXPR (TOK_COLREF src2 value) c4)) (TOK_WHERE (and (> (TOK_COLREF src2 key) 15) (< (TOK_COLREF src2 key) 25))))) b) (= (TOK_COLREF a c1) (TOK_COLREF b c3)))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_COLREF a c1) c1) (TOK_SELEXPR (TOK_COLREF a c2) c2) (TOK_SELEXPR (TOK_COLREF b c3) c3) (TOK_SELEXPR (TOK_COLREF b c4) c4)))) c)) (TOK_INSERT (TOK_DESTINATION (TOK_TAB dest1)) (TOK_SELECT (TOK_SELEXPR (TOK_COLREF c c1)
 ) (TOK_SELEXPR (TOK_COLREF c c2)) (TOK_SELEXPR (TOK_COLREF c c3)) (TOK_SELEXPR (TOK_COLREF c c4)))))
+
+STAGE DEPENDENCIES:
+  Stage-1 is a root stage
+  Stage-0 depends on stages: Stage-1
+
+STAGE PLANS:
+  Stage: Stage-1
+    Map Reduce
+      Reduce Operator Tree:
+        Join Operator
+          condition expressions:
+            0 {VALUE.0} {VALUE.1}
+            1 {VALUE.0} {VALUE.1}
+          condition map:
+               Outer Join 0 to 1
+          Select Operator
+            expressions:
+                  expr: 0
+                  type: string
+                  expr: 1
+                  type: string
+                  expr: 2
+                  type: string
+                  expr: 3
+                  type: string
+            Select Operator
+              expressions:
+                    expr: 0
+                    type: string
+                    expr: 1
+                    type: string
+                    expr: 2
+                    type: string
+                    expr: 3
+                    type: string
+              File Output Operator
+                table:
+                    name: dest1
+                    serde: simple_meta
+                    input format: org.apache.hadoop.mapred.TextInputFormat
+                    output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+      Alias -> Map Operator Tree:
+        c:b:src2 
+            Filter Operator
+              predicate:
+                  expr: ((key > 15) and (key < 25))
+                  type: Boolean
+              Select Operator
+                expressions:
+                      expr: key
+                      type: string
+                      expr: value
+                      type: string
+                Reduce Output Operator
+                  tag: 1
+                  key expressions:
+                        expr: 0
+                        type: string
+                  value expressions:
+                        expr: 0
+                        type: string
+                        expr: 1
+                        type: string
+                  # partition fields: 1
+        c:a:src1 
+            Filter Operator
+              predicate:
+                  expr: ((key > 10) and (key < 20))
+                  type: Boolean
+              Select Operator
+                expressions:
+                      expr: key
+                      type: string
+                      expr: value
+                      type: string
+                Reduce Output Operator
+                  tag: 0
+                  key expressions:
+                        expr: 0
+                        type: string
+                  value expressions:
+                        expr: 0
+                        type: string
+                        expr: 1
+                        type: string
+                  # partition fields: 1
+
+  Stage: Stage-0
+    Move Operator
+      tables:
+            table:
+                name: dest1
+                serde: simple_meta
+                input format: org.apache.hadoop.mapred.TextInputFormat
+                output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+            replace:
+
+
+11	val_11	NULL	NULL
+12	val_12	NULL	NULL
+12	val_12	NULL	NULL
+15	val_15	NULL	NULL
+15	val_15	NULL	NULL
+17	val_17	17	val_17
+18	val_18	18	val_18
+18	val_18	18	val_18
+18	val_18	18	val_18
+18	val_18	18	val_18
+19	val_19	19	val_19
+NULL	NULL	20	val_20
+NULL	NULL	24	val_24
+NULL	NULL	24	val_24
+

Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/join7.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/join7.q.out?rev=697291&r1=697290&r2=697291&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/join7.q.out (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/join7.q.out Fri Sep 19 16:56:30 2008
@@ -1,147 +1,149 @@
-ABSTRACT SYNTAX TREE:	
-  (TOK_QUERY (TOK_FROM (TOK_SUBQUERY (TOK_QUERY (TOK_FROM (TOK_LEFTOUTERJOIN (TOK_FULLOUTERJOIN (TOK_SUBQUERY (TOK_QUERY (TOK_FROM (TOK_TABREF src src1)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_COLREF src1 key) c1) (TOK_SELEXPR (TOK_COLREF src1 value) c2)) (TOK_WHERE (and (> (TOK_COLREF src1 key) 10) (< (TOK_COLREF src1 key) 20))))) a) (TOK_SUBQUERY (TOK_QUERY (TOK_FROM (TOK_TABREF src src2)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_COLREF src2 key) c3) (TOK_SELEXPR (TOK_COLREF src2 value) c4)) (TOK_WHERE (and (> (TOK_COLREF src2 key) 15) (< (TOK_COLREF src2 key) 25))))) b) (= (TOK_COLREF a c1) (TOK_COLREF b c3))) (TOK_SUBQUERY (TOK_QUERY (TOK_FROM (TOK_TABREF src src3)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_COLREF src3 key) c5) (TOK_SELEXPR (TOK_COLREF src3 value) c6)) (TOK_WHERE (and (> (TOK_COLREF src3 key) 20) (< (TOK_COLREF src3 key) 25))))) 
 c) (= (TOK_COLREF a c1) (TOK_COLREF c c5)))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_COLREF a c1) c1) (TOK_SELEXPR (TOK_COLREF a c2) c2) (TOK_SELEXPR (TOK_COLREF b c3) c3) (TOK_SELEXPR (TOK_COLREF b c4) c4) (TOK_SELEXPR (TOK_COLREF c c5) c5) (TOK_SELEXPR (TOK_COLREF c c6) c6)))) c)) (TOK_INSERT (TOK_DESTINATION (TOK_TAB dest1)) (TOK_SELECT (TOK_SELEXPR (TOK_COLREF c c1)) (TOK_SELEXPR (TOK_COLREF c c2)) (TOK_SELEXPR (TOK_COLREF c c3)) (TOK_SELEXPR (TOK_COLREF c c4)) (TOK_SELEXPR (TOK_COLREF c c5)) (TOK_SELEXPR (TOK_COLREF c c6)))))	
-	
-STAGE DEPENDENCIES:	
-  Stage-1 is a root stage	
-  Stage-0 depends on stages: Stage-1	
-	
-STAGE PLANS:	
-  Stage: Stage-1	
-    Map Reduce	
-      Reduce Operator Tree:	
-        Join Operator	
-          condition expressions:	
-            0 {VALUE.0} {VALUE.1}	
-            1 {VALUE.0} {VALUE.1}	
-            2 {VALUE.0} {VALUE.1}	
-          condition map:	
-               Outer Join 0 to 1	
-               Left Outer Join0 to 1	
-          Select Operator	
-            expressions:	
-                  expr: 0	
-                  type: class java.lang.String	
-                  expr: 1	
-                  type: class java.lang.String	
-                  expr: 2	
-                  type: class java.lang.String	
-                  expr: 3	
-                  type: class java.lang.String	
-                  expr: 4	
-                  type: class java.lang.String	
-                  expr: 5	
-                  type: class java.lang.String	
-            Select Operator	
-              expressions:	
-                    expr: 0	
-                    type: class java.lang.String	
-                    expr: 1	
-                    type: class java.lang.String	
-                    expr: 2	
-                    type: class java.lang.String	
-                    expr: 3	
-                    type: class java.lang.String	
-                    expr: 4	
-                    type: class java.lang.String	
-                    expr: 5	
-                    type: class java.lang.String	
-              File Output Operator	
-                table:	
-                    name: dest1	
-                    serde: org.apache.hadoop.hive.serde.simple_meta.MetadataTypedColumnsetSerDe	
-                    input format: org.apache.hadoop.mapred.TextInputFormat	
-                    output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat	
-      Alias -> Map Operator Tree:	
-        c:b:src2 	
-            Filter Operator	
-              predicate:	
-                  expr: ((key > 15) and (key < 25))	
-                  type: class java.lang.Boolean	
-              Select Operator	
-                expressions:	
-                      expr: key	
-                      type: class java.lang.String	
-                      expr: value	
-                      type: class java.lang.String	
-                Reduce Output Operator	
-                  tag: 1	
-                  key expressions:	
-                        expr: 0	
-                        type: class java.lang.String	
-                  value expressions:	
-                        expr: 0	
-                        type: class java.lang.String	
-                        expr: 1	
-                        type: class java.lang.String	
-                  # partition fields: 1	
-        c:a:src1 	
-            Filter Operator	
-              predicate:	
-                  expr: ((key > 10) and (key < 20))	
-                  type: class java.lang.Boolean	
-              Select Operator	
-                expressions:	
-                      expr: key	
-                      type: class java.lang.String	
-                      expr: value	
-                      type: class java.lang.String	
-                Reduce Output Operator	
-                  tag: 0	
-                  key expressions:	
-                        expr: 0	
-                        type: class java.lang.String	
-                  value expressions:	
-                        expr: 0	
-                        type: class java.lang.String	
-                        expr: 1	
-                        type: class java.lang.String	
-                  # partition fields: 1	
-        c:c:src3 	
-            Filter Operator	
-              predicate:	
-                  expr: ((key > 20) and (key < 25))	
-                  type: class java.lang.Boolean	
-              Select Operator	
-                expressions:	
-                      expr: key	
-                      type: class java.lang.String	
-                      expr: value	
-                      type: class java.lang.String	
-                Reduce Output Operator	
-                  tag: 2	
-                  key expressions:	
-                        expr: 0	
-                        type: class java.lang.String	
-                  value expressions:	
-                        expr: 0	
-                        type: class java.lang.String	
-                        expr: 1	
-                        type: class java.lang.String	
-                  # partition fields: 1	
-	
-  Stage: Stage-0	
-    Move Operator	
-      tables:	
-            table:	
-                name: dest1	
-                serde: org.apache.hadoop.hive.serde.simple_meta.MetadataTypedColumnsetSerDe	
-                input format: org.apache.hadoop.mapred.TextInputFormat	
-                output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat	
-            replace:	
-	
-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	17	val_17	NULL	NULL	
-18	val_18	18	val_18	NULL	NULL	
-18	val_18	18	val_18	NULL	NULL	
-18	val_18	18	val_18	NULL	NULL	
-18	val_18	18	val_18	NULL	NULL	
-19	val_19	19	val_19	NULL	NULL	
-NULL	NULL	20	val_20	NULL	NULL	
-NULL	NULL	24	val_24	NULL	NULL	
-NULL	NULL	24	val_24	NULL	NULL	
-NULL	NULL	24	val_24	NULL	NULL	
-NULL	NULL	24	val_24	NULL	NULL	
+ABSTRACT SYNTAX TREE:
+  (TOK_QUERY (TOK_FROM (TOK_SUBQUERY (TOK_QUERY (TOK_FROM (TOK_LEFTOUTERJOIN (TOK_FULLOUTERJOIN (TOK_SUBQUERY (TOK_QUERY (TOK_FROM (TOK_TABREF src src1)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_COLREF src1 key) c1) (TOK_SELEXPR (TOK_COLREF src1 value) c2)) (TOK_WHERE (and (> (TOK_COLREF src1 key) 10) (< (TOK_COLREF src1 key) 20))))) a) (TOK_SUBQUERY (TOK_QUERY (TOK_FROM (TOK_TABREF src src2)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_COLREF src2 key) c3) (TOK_SELEXPR (TOK_COLREF src2 value) c4)) (TOK_WHERE (and (> (TOK_COLREF src2 key) 15) (< (TOK_COLREF src2 key) 25))))) b) (= (TOK_COLREF a c1) (TOK_COLREF b c3))) (TOK_SUBQUERY (TOK_QUERY (TOK_FROM (TOK_TABREF src src3)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_COLREF src3 key) c5) (TOK_SELEXPR (TOK_COLREF src3 value) c6)) (TOK_WHERE (and (> (TOK_COLREF src3 key) 20) (< (TOK_COLREF src3 key) 25))))) 
 c) (= (TOK_COLREF a c1) (TOK_COLREF c c5)))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_COLREF a c1) c1) (TOK_SELEXPR (TOK_COLREF a c2) c2) (TOK_SELEXPR (TOK_COLREF b c3) c3) (TOK_SELEXPR (TOK_COLREF b c4) c4) (TOK_SELEXPR (TOK_COLREF c c5) c5) (TOK_SELEXPR (TOK_COLREF c c6) c6)))) c)) (TOK_INSERT (TOK_DESTINATION (TOK_TAB dest1)) (TOK_SELECT (TOK_SELEXPR (TOK_COLREF c c1)) (TOK_SELEXPR (TOK_COLREF c c2)) (TOK_SELEXPR (TOK_COLREF c c3)) (TOK_SELEXPR (TOK_COLREF c c4)) (TOK_SELEXPR (TOK_COLREF c c5)) (TOK_SELEXPR (TOK_COLREF c c6)))))
+
+STAGE DEPENDENCIES:
+  Stage-1 is a root stage
+  Stage-0 depends on stages: Stage-1
+
+STAGE PLANS:
+  Stage: Stage-1
+    Map Reduce
+      Reduce Operator Tree:
+        Join Operator
+          condition expressions:
+            0 {VALUE.0} {VALUE.1}
+            1 {VALUE.0} {VALUE.1}
+            2 {VALUE.0} {VALUE.1}
+          condition map:
+               Outer Join 0 to 1
+               Left Outer Join0 to 1
+          Select Operator
+            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
+            Select Operator
+              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
+              File Output Operator
+                table:
+                    name: dest1
+                    serde: simple_meta
+                    input format: org.apache.hadoop.mapred.TextInputFormat
+                    output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+      Alias -> Map Operator Tree:
+        c:b:src2 
+            Filter Operator
+              predicate:
+                  expr: ((key > 15) and (key < 25))
+                  type: Boolean
+              Select Operator
+                expressions:
+                      expr: key
+                      type: string
+                      expr: value
+                      type: string
+                Reduce Output Operator
+                  tag: 1
+                  key expressions:
+                        expr: 0
+                        type: string
+                  value expressions:
+                        expr: 0
+                        type: string
+                        expr: 1
+                        type: string
+                  # partition fields: 1
+        c:a:src1 
+            Filter Operator
+              predicate:
+                  expr: ((key > 10) and (key < 20))
+                  type: Boolean
+              Select Operator
+                expressions:
+                      expr: key
+                      type: string
+                      expr: value
+                      type: string
+                Reduce Output Operator
+                  tag: 0
+                  key expressions:
+                        expr: 0
+                        type: string
+                  value expressions:
+                        expr: 0
+                        type: string
+                        expr: 1
+                        type: string
+                  # partition fields: 1
+        c:c:src3 
+            Filter Operator
+              predicate:
+                  expr: ((key > 20) and (key < 25))
+                  type: Boolean
+              Select Operator
+                expressions:
+                      expr: key
+                      type: string
+                      expr: value
+                      type: string
+                Reduce Output Operator
+                  tag: 2
+                  key expressions:
+                        expr: 0
+                        type: string
+                  value expressions:
+                        expr: 0
+                        type: string
+                        expr: 1
+                        type: string
+                  # partition fields: 1
+
+  Stage: Stage-0
+    Move Operator
+      tables:
+            table:
+                name: dest1
+                serde: simple_meta
+                input format: org.apache.hadoop.mapred.TextInputFormat
+                output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+            replace:
+
+
+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	17	val_17	NULL	NULL
+18	val_18	18	val_18	NULL	NULL
+18	val_18	18	val_18	NULL	NULL
+18	val_18	18	val_18	NULL	NULL
+18	val_18	18	val_18	NULL	NULL
+19	val_19	19	val_19	NULL	NULL
+NULL	NULL	20	val_20	NULL	NULL
+NULL	NULL	24	val_24	NULL	NULL
+NULL	NULL	24	val_24	NULL	NULL
+NULL	NULL	24	val_24	NULL	NULL
+NULL	NULL	24	val_24	NULL	NULL
+

Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/join8.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/join8.q.out?rev=697291&r1=697290&r2=697291&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/join8.q.out (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/join8.q.out Fri Sep 19 16:56:30 2008
@@ -1,108 +1,110 @@
-ABSTRACT SYNTAX TREE:	
-  (TOK_QUERY (TOK_FROM (TOK_SUBQUERY (TOK_QUERY (TOK_FROM (TOK_LEFTOUTERJOIN (TOK_SUBQUERY (TOK_QUERY (TOK_FROM (TOK_TABREF src src1)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_COLREF src1 key) c1) (TOK_SELEXPR (TOK_COLREF src1 value) c2)) (TOK_WHERE (and (> (TOK_COLREF src1 key) 10) (< (TOK_COLREF src1 key) 20))))) a) (TOK_SUBQUERY (TOK_QUERY (TOK_FROM (TOK_TABREF src src2)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_COLREF src2 key) c3) (TOK_SELEXPR (TOK_COLREF src2 value) c4)) (TOK_WHERE (and (> (TOK_COLREF src2 key) 15) (< (TOK_COLREF src2 key) 25))))) b) (= (TOK_COLREF a c1) (TOK_COLREF b c3)))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_COLREF a c1) c1) (TOK_SELEXPR (TOK_COLREF a c2) c2) (TOK_SELEXPR (TOK_COLREF b c3) c3) (TOK_SELEXPR (TOK_COLREF b c4) c4)))) c)) (TOK_INSERT (TOK_DESTINATION (TOK_TAB dest1)) (TOK_SELECT (TOK_SELEXPR (TOK_COLREF c c1)
 ) (TOK_SELEXPR (TOK_COLREF c c2)) (TOK_SELEXPR (TOK_COLREF c c3)) (TOK_SELEXPR (TOK_COLREF c c4))) (TOK_WHERE (AND (TOK_FUNCTION TOK_ISNULL (TOK_COLREF c c3)) (TOK_FUNCTION TOK_ISNOTNULL (TOK_COLREF c c1))))))	
-	
-STAGE DEPENDENCIES:	
-  Stage-1 is a root stage	
-  Stage-0 depends on stages: Stage-1	
-	
-STAGE PLANS:	
-  Stage: Stage-1	
-    Map Reduce	
-      Reduce Operator Tree:	
-        Join Operator	
-          condition expressions:	
-            0 {VALUE.0} {VALUE.1}	
-            1 {VALUE.0} {VALUE.1}	
-          condition map:	
-               Left Outer Join0 to 1	
-          Select Operator	
-            expressions:	
-                  expr: 0	
-                  type: class java.lang.String	
-                  expr: 1	
-                  type: class java.lang.String	
-                  expr: 2	
-                  type: class java.lang.String	
-                  expr: 3	
-                  type: class java.lang.String	
-            Filter Operator	
-              predicate:	
-                  expr: (2 is null and 0 is not null)	
-                  type: class java.lang.Boolean	
-              Select Operator	
-                expressions:	
-                      expr: 0	
-                      type: class java.lang.String	
-                      expr: 1	
-                      type: class java.lang.String	
-                      expr: 2	
-                      type: class java.lang.String	
-                      expr: 3	
-                      type: class java.lang.String	
-                File Output Operator	
-                  table:	
-                      name: dest1	
-                      serde: org.apache.hadoop.hive.serde.simple_meta.MetadataTypedColumnsetSerDe	
-                      input format: org.apache.hadoop.mapred.TextInputFormat	
-                      output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat	
-      Alias -> Map Operator Tree:	
-        c:b:src2 	
-            Filter Operator	
-              predicate:	
-                  expr: ((key > 15) and (key < 25))	
-                  type: class java.lang.Boolean	
-              Select Operator	
-                expressions:	
-                      expr: key	
-                      type: class java.lang.String	
-                      expr: value	
-                      type: class java.lang.String	
-                Reduce Output Operator	
-                  tag: 1	
-                  key expressions:	
-                        expr: 0	
-                        type: class java.lang.String	
-                  value expressions:	
-                        expr: 0	
-                        type: class java.lang.String	
-                        expr: 1	
-                        type: class java.lang.String	
-                  # partition fields: 1	
-        c:a:src1 	
-            Filter Operator	
-              predicate:	
-                  expr: ((key > 10) and (key < 20))	
-                  type: class java.lang.Boolean	
-              Select Operator	
-                expressions:	
-                      expr: key	
-                      type: class java.lang.String	
-                      expr: value	
-                      type: class java.lang.String	
-                Reduce Output Operator	
-                  tag: 0	
-                  key expressions:	
-                        expr: 0	
-                        type: class java.lang.String	
-                  value expressions:	
-                        expr: 0	
-                        type: class java.lang.String	
-                        expr: 1	
-                        type: class java.lang.String	
-                  # partition fields: 1	
-	
-  Stage: Stage-0	
-    Move Operator	
-      tables:	
-            table:	
-                name: dest1	
-                serde: org.apache.hadoop.hive.serde.simple_meta.MetadataTypedColumnsetSerDe	
-                input format: org.apache.hadoop.mapred.TextInputFormat	
-                output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat	
-            replace:	
-	
-11	val_11	NULL	NULL	
-12	val_12	NULL	NULL	
-12	val_12	NULL	NULL	
-15	val_15	NULL	NULL	
-15	val_15	NULL	NULL	
+ABSTRACT SYNTAX TREE:
+  (TOK_QUERY (TOK_FROM (TOK_SUBQUERY (TOK_QUERY (TOK_FROM (TOK_LEFTOUTERJOIN (TOK_SUBQUERY (TOK_QUERY (TOK_FROM (TOK_TABREF src src1)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_COLREF src1 key) c1) (TOK_SELEXPR (TOK_COLREF src1 value) c2)) (TOK_WHERE (and (> (TOK_COLREF src1 key) 10) (< (TOK_COLREF src1 key) 20))))) a) (TOK_SUBQUERY (TOK_QUERY (TOK_FROM (TOK_TABREF src src2)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_COLREF src2 key) c3) (TOK_SELEXPR (TOK_COLREF src2 value) c4)) (TOK_WHERE (and (> (TOK_COLREF src2 key) 15) (< (TOK_COLREF src2 key) 25))))) b) (= (TOK_COLREF a c1) (TOK_COLREF b c3)))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_COLREF a c1) c1) (TOK_SELEXPR (TOK_COLREF a c2) c2) (TOK_SELEXPR (TOK_COLREF b c3) c3) (TOK_SELEXPR (TOK_COLREF b c4) c4)))) c)) (TOK_INSERT (TOK_DESTINATION (TOK_TAB dest1)) (TOK_SELECT (TOK_SELEXPR (TOK_COLREF c c1)
 ) (TOK_SELEXPR (TOK_COLREF c c2)) (TOK_SELEXPR (TOK_COLREF c c3)) (TOK_SELEXPR (TOK_COLREF c c4))) (TOK_WHERE (AND (TOK_FUNCTION TOK_ISNULL (TOK_COLREF c c3)) (TOK_FUNCTION TOK_ISNOTNULL (TOK_COLREF c c1))))))
+
+STAGE DEPENDENCIES:
+  Stage-1 is a root stage
+  Stage-0 depends on stages: Stage-1
+
+STAGE PLANS:
+  Stage: Stage-1
+    Map Reduce
+      Reduce Operator Tree:
+        Join Operator
+          condition expressions:
+            0 {VALUE.0} {VALUE.1}
+            1 {VALUE.0} {VALUE.1}
+          condition map:
+               Left Outer Join0 to 1
+          Select Operator
+            expressions:
+                  expr: 0
+                  type: string
+                  expr: 1
+                  type: string
+                  expr: 2
+                  type: string
+                  expr: 3
+                  type: string
+            Filter Operator
+              predicate:
+                  expr: (2 is null and 0 is not null)
+                  type: Boolean
+              Select Operator
+                expressions:
+                      expr: 0
+                      type: string
+                      expr: 1
+                      type: string
+                      expr: 2
+                      type: string
+                      expr: 3
+                      type: string
+                File Output Operator
+                  table:
+                      name: dest1
+                      serde: simple_meta
+                      input format: org.apache.hadoop.mapred.TextInputFormat
+                      output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+      Alias -> Map Operator Tree:
+        c:b:src2 
+            Filter Operator
+              predicate:
+                  expr: ((key > 15) and (key < 25))
+                  type: Boolean
+              Select Operator
+                expressions:
+                      expr: key
+                      type: string
+                      expr: value
+                      type: string
+                Reduce Output Operator
+                  tag: 1
+                  key expressions:
+                        expr: 0
+                        type: string
+                  value expressions:
+                        expr: 0
+                        type: string
+                        expr: 1
+                        type: string
+                  # partition fields: 1
+        c:a:src1 
+            Filter Operator
+              predicate:
+                  expr: ((key > 10) and (key < 20))
+                  type: Boolean
+              Select Operator
+                expressions:
+                      expr: key
+                      type: string
+                      expr: value
+                      type: string
+                Reduce Output Operator
+                  tag: 0
+                  key expressions:
+                        expr: 0
+                        type: string
+                  value expressions:
+                        expr: 0
+                        type: string
+                        expr: 1
+                        type: string
+                  # partition fields: 1
+
+  Stage: Stage-0
+    Move Operator
+      tables:
+            table:
+                name: dest1
+                serde: simple_meta
+                input format: org.apache.hadoop.mapred.TextInputFormat
+                output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+            replace:
+
+
+11	val_11	NULL	NULL
+12	val_12	NULL	NULL
+12	val_12	NULL	NULL
+15	val_15	NULL	NULL
+15	val_15	NULL	NULL
+

Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/sample1.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/sample1.q.out?rev=697291&r1=697290&r2=697291&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/sample1.q.out (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/sample1.q.out Fri Sep 19 16:56:30 2008
@@ -1,593 +1,597 @@
-ABSTRACT SYNTAX TREE:	
-  (TOK_QUERY (TOK_FROM (TOK_TABREF srcpart (TOK_TABLESAMPLE 1 1) s)) (TOK_INSERT (TOK_DESTINATION (TOK_TAB dest1)) (TOK_SELECT (TOK_SELEXPR (TOK_ALLCOLREF s))) (TOK_WHERE (and (= (TOK_COLREF s ds) '2008-04-08') (= (TOK_COLREF s hr) '11')))))	
-	
-STAGE DEPENDENCIES:	
-  Stage-1 is a root stage	
-  Stage-0 depends on stages: Stage-1	
-	
-STAGE PLANS:	
-  Stage: Stage-1	
-    Map Reduce	
-      Path -> Alias:	
-        file:/home/athusoo/projects/hadoop/trunk/VENDOR/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11 	
-      Path -> Partition:	
-        file:/home/athusoo/projects/hadoop/trunk/VENDOR/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11 	
-          Partition	
-          	
-              properties:	
-                name srcpart	
-                bucket_field_name 	
-                serialization.format 1	
-                columns key,value	
-                partition_columns ds/hr	
-                field_to_dimension 	
-                bucket_count -1	
-                serialization.lib simple_meta	
-                file.inputformat org.apache.hadoop.mapred.TextInputFormat	
-                file.outputformat org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat	
-                location file:/home/athusoo/projects/hadoop/trunk/VENDOR/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/srcpart	
-              name: srcpart	
-              serde: simple_meta	
-              input format: org.apache.hadoop.mapred.TextInputFormat	
-              output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat	
-            partition values:	
-              ds 2008-04-08	
-              hr 11	
-      Alias -> Map Operator Tree:	
-        s 	
-            Filter Operator	
-              predicate:	
-                  expr: ((ds = '2008-04-08') and (hr = '11'))	
-                  type: class java.lang.Boolean	
-              Select Operator	
-                expressions:	
-                      expr: key	
-                      type: class java.lang.String	
-                      expr: value	
-                      type: class java.lang.String	
-                      expr: ds	
-                      type: class java.lang.String	
-                      expr: hr	
-                      type: class java.lang.String	
-                File Output Operator	
-                  table:	
-                      properties:	
-                        name dest1	
-                        bucket_field_name 	
-                        serialization.format 1	
-                        columns key,value,dt,hr	
-                        field_to_dimension 	
-                        bucket_count -1	
-                        serialization.lib org.apache.hadoop.hive.serde.simple_meta.MetadataTypedColumnsetSerDe	
-                        file.inputformat org.apache.hadoop.mapred.TextInputFormat	
-                        file.outputformat org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat	
-                        location file:/home/athusoo/projects/hadoop/trunk/VENDOR/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/dest1	
-                      name: dest1	
-                      serde: org.apache.hadoop.hive.serde.simple_meta.MetadataTypedColumnsetSerDe	
-                      input format: org.apache.hadoop.mapred.TextInputFormat	
-                      output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat	
-                  directory: /tmp/hive-athusoo/950057386.10000.insclause-0	
-      Needs Tagging:	
-	
-  Stage: Stage-0	
-    Move Operator	
-      tables:	
-            table:	
-                properties:	
-                  name dest1	
-                  bucket_field_name 	
-                  serialization.format 1	
-                  columns key,value,dt,hr	
-                  field_to_dimension 	
-                  bucket_count -1	
-                  serialization.lib org.apache.hadoop.hive.serde.simple_meta.MetadataTypedColumnsetSerDe	
-                  file.inputformat org.apache.hadoop.mapred.TextInputFormat	
-                  file.outputformat org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat	
-                  location file:/home/athusoo/projects/hadoop/trunk/VENDOR/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/dest1	
-                name: dest1	
-                serde: org.apache.hadoop.hive.serde.simple_meta.MetadataTypedColumnsetSerDe	
-                input format: org.apache.hadoop.mapred.TextInputFormat	
-                output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat	
-            replace:	
-            source: /tmp/hive-athusoo/950057386.10000.insclause-0	
-	
-238	val_238	2008-04-08	11	
-86	val_86	2008-04-08	11	
-311	val_311	2008-04-08	11	
-27	val_27	2008-04-08	11	
-165	val_165	2008-04-08	11	
-409	val_409	2008-04-08	11	
-255	val_255	2008-04-08	11	
-278	val_278	2008-04-08	11	
-98	val_98	2008-04-08	11	
-484	val_484	2008-04-08	11	
-265	val_265	2008-04-08	11	
-193	val_193	2008-04-08	11	
-401	val_401	2008-04-08	11	
-150	val_150	2008-04-08	11	
-273	val_273	2008-04-08	11	
-224	val_224	2008-04-08	11	
-369	val_369	2008-04-08	11	
-66	val_66	2008-04-08	11	
-128	val_128	2008-04-08	11	
-213	val_213	2008-04-08	11	
-146	val_146	2008-04-08	11	
-406	val_406	2008-04-08	11	
-429	val_429	2008-04-08	11	
-374	val_374	2008-04-08	11	
-152	val_152	2008-04-08	11	
-469	val_469	2008-04-08	11	
-145	val_145	2008-04-08	11	
-495	val_495	2008-04-08	11	
-37	val_37	2008-04-08	11	
-327	val_327	2008-04-08	11	
-281	val_281	2008-04-08	11	
-277	val_277	2008-04-08	11	
-209	val_209	2008-04-08	11	
-15	val_15	2008-04-08	11	
-82	val_82	2008-04-08	11	
-403	val_403	2008-04-08	11	
-166	val_166	2008-04-08	11	
-417	val_417	2008-04-08	11	
-430	val_430	2008-04-08	11	
-252	val_252	2008-04-08	11	
-292	val_292	2008-04-08	11	
-219	val_219	2008-04-08	11	
-287	val_287	2008-04-08	11	
-153	val_153	2008-04-08	11	
-193	val_193	2008-04-08	11	
-338	val_338	2008-04-08	11	
-446	val_446	2008-04-08	11	
-459	val_459	2008-04-08	11	
-394	val_394	2008-04-08	11	
-237	val_237	2008-04-08	11	
-482	val_482	2008-04-08	11	
-174	val_174	2008-04-08	11	
-413	val_413	2008-04-08	11	
-494	val_494	2008-04-08	11	
-207	val_207	2008-04-08	11	
-199	val_199	2008-04-08	11	
-466	val_466	2008-04-08	11	
-208	val_208	2008-04-08	11	
-174	val_174	2008-04-08	11	
-399	val_399	2008-04-08	11	
-396	val_396	2008-04-08	11	
-247	val_247	2008-04-08	11	
-417	val_417	2008-04-08	11	
-489	val_489	2008-04-08	11	
-162	val_162	2008-04-08	11	
-377	val_377	2008-04-08	11	
-397	val_397	2008-04-08	11	
-309	val_309	2008-04-08	11	
-365	val_365	2008-04-08	11	
-266	val_266	2008-04-08	11	
-439	val_439	2008-04-08	11	
-342	val_342	2008-04-08	11	
-367	val_367	2008-04-08	11	
-325	val_325	2008-04-08	11	
-167	val_167	2008-04-08	11	
-195	val_195	2008-04-08	11	
-475	val_475	2008-04-08	11	
-17	val_17	2008-04-08	11	
-113	val_113	2008-04-08	11	
-155	val_155	2008-04-08	11	
-203	val_203	2008-04-08	11	
-339	val_339	2008-04-08	11	
-0	val_0	2008-04-08	11	
-455	val_455	2008-04-08	11	
-128	val_128	2008-04-08	11	
-311	val_311	2008-04-08	11	
-316	val_316	2008-04-08	11	
-57	val_57	2008-04-08	11	
-302	val_302	2008-04-08	11	
-205	val_205	2008-04-08	11	
-149	val_149	2008-04-08	11	
-438	val_438	2008-04-08	11	
-345	val_345	2008-04-08	11	
-129	val_129	2008-04-08	11	
-170	val_170	2008-04-08	11	
-20	val_20	2008-04-08	11	
-489	val_489	2008-04-08	11	
-157	val_157	2008-04-08	11	
-378	val_378	2008-04-08	11	
-221	val_221	2008-04-08	11	
-92	val_92	2008-04-08	11	
-111	val_111	2008-04-08	11	
-47	val_47	2008-04-08	11	
-72	val_72	2008-04-08	11	
-4	val_4	2008-04-08	11	
-280	val_280	2008-04-08	11	
-35	val_35	2008-04-08	11	
-427	val_427	2008-04-08	11	
-277	val_277	2008-04-08	11	
-208	val_208	2008-04-08	11	
-356	val_356	2008-04-08	11	
-399	val_399	2008-04-08	11	
-169	val_169	2008-04-08	11	
-382	val_382	2008-04-08	11	
-498	val_498	2008-04-08	11	
-125	val_125	2008-04-08	11	
-386	val_386	2008-04-08	11	
-437	val_437	2008-04-08	11	
-469	val_469	2008-04-08	11	
-192	val_192	2008-04-08	11	
-286	val_286	2008-04-08	11	
-187	val_187	2008-04-08	11	
-176	val_176	2008-04-08	11	
-54	val_54	2008-04-08	11	
-459	val_459	2008-04-08	11	
-51	val_51	2008-04-08	11	
-138	val_138	2008-04-08	11	
-103	val_103	2008-04-08	11	
-239	val_239	2008-04-08	11	
-213	val_213	2008-04-08	11	
-216	val_216	2008-04-08	11	
-430	val_430	2008-04-08	11	
-278	val_278	2008-04-08	11	
-176	val_176	2008-04-08	11	
-289	val_289	2008-04-08	11	
-221	val_221	2008-04-08	11	
-65	val_65	2008-04-08	11	
-318	val_318	2008-04-08	11	
-332	val_332	2008-04-08	11	
-311	val_311	2008-04-08	11	
-275	val_275	2008-04-08	11	
-137	val_137	2008-04-08	11	
-241	val_241	2008-04-08	11	
-83	val_83	2008-04-08	11	
-333	val_333	2008-04-08	11	
-180	val_180	2008-04-08	11	
-284	val_284	2008-04-08	11	
-12	val_12	2008-04-08	11	
-230	val_230	2008-04-08	11	
-181	val_181	2008-04-08	11	
-67	val_67	2008-04-08	11	
-260	val_260	2008-04-08	11	
-404	val_404	2008-04-08	11	
-384	val_384	2008-04-08	11	
-489	val_489	2008-04-08	11	
-353	val_353	2008-04-08	11	
-373	val_373	2008-04-08	11	
-272	val_272	2008-04-08	11	
-138	val_138	2008-04-08	11	
-217	val_217	2008-04-08	11	
-84	val_84	2008-04-08	11	
-348	val_348	2008-04-08	11	
-466	val_466	2008-04-08	11	
-58	val_58	2008-04-08	11	
-8	val_8	2008-04-08	11	
-411	val_411	2008-04-08	11	
-230	val_230	2008-04-08	11	
-208	val_208	2008-04-08	11	
-348	val_348	2008-04-08	11	
-24	val_24	2008-04-08	11	
-463	val_463	2008-04-08	11	
-431	val_431	2008-04-08	11	
-179	val_179	2008-04-08	11	
-172	val_172	2008-04-08	11	
-42	val_42	2008-04-08	11	
-129	val_129	2008-04-08	11	
-158	val_158	2008-04-08	11	
-119	val_119	2008-04-08	11	
-496	val_496	2008-04-08	11	
-0	val_0	2008-04-08	11	
-322	val_322	2008-04-08	11	
-197	val_197	2008-04-08	11	
-468	val_468	2008-04-08	11	
-393	val_393	2008-04-08	11	
-454	val_454	2008-04-08	11	
-100	val_100	2008-04-08	11	
-298	val_298	2008-04-08	11	
-199	val_199	2008-04-08	11	
-191	val_191	2008-04-08	11	
-418	val_418	2008-04-08	11	
-96	val_96	2008-04-08	11	
-26	val_26	2008-04-08	11	
-165	val_165	2008-04-08	11	
-327	val_327	2008-04-08	11	
-230	val_230	2008-04-08	11	
-205	val_205	2008-04-08	11	
-120	val_120	2008-04-08	11	
-131	val_131	2008-04-08	11	
-51	val_51	2008-04-08	11	
-404	val_404	2008-04-08	11	
-43	val_43	2008-04-08	11	
-436	val_436	2008-04-08	11	
-156	val_156	2008-04-08	11	
-469	val_469	2008-04-08	11	
-468	val_468	2008-04-08	11	
-308	val_308	2008-04-08	11	
-95	val_95	2008-04-08	11	
-196	val_196	2008-04-08	11	
-288	val_288	2008-04-08	11	
-481	val_481	2008-04-08	11	
-457	val_457	2008-04-08	11	
-98	val_98	2008-04-08	11	
-282	val_282	2008-04-08	11	
-197	val_197	2008-04-08	11	
-187	val_187	2008-04-08	11	
-318	val_318	2008-04-08	11	
-318	val_318	2008-04-08	11	
-409	val_409	2008-04-08	11	
-470	val_470	2008-04-08	11	
-137	val_137	2008-04-08	11	
-369	val_369	2008-04-08	11	
-316	val_316	2008-04-08	11	
-169	val_169	2008-04-08	11	
-413	val_413	2008-04-08	11	
-85	val_85	2008-04-08	11	
-77	val_77	2008-04-08	11	
-0	val_0	2008-04-08	11	
-490	val_490	2008-04-08	11	
-87	val_87	2008-04-08	11	
-364	val_364	2008-04-08	11	
-179	val_179	2008-04-08	11	
-118	val_118	2008-04-08	11	
-134	val_134	2008-04-08	11	
-395	val_395	2008-04-08	11	
-282	val_282	2008-04-08	11	
-138	val_138	2008-04-08	11	
-238	val_238	2008-04-08	11	
-419	val_419	2008-04-08	11	
-15	val_15	2008-04-08	11	
-118	val_118	2008-04-08	11	
-72	val_72	2008-04-08	11	
-90	val_90	2008-04-08	11	
-307	val_307	2008-04-08	11	
-19	val_19	2008-04-08	11	
-435	val_435	2008-04-08	11	
-10	val_10	2008-04-08	11	
-277	val_277	2008-04-08	11	
-273	val_273	2008-04-08	11	
-306	val_306	2008-04-08	11	
-224	val_224	2008-04-08	11	
-309	val_309	2008-04-08	11	
-389	val_389	2008-04-08	11	
-327	val_327	2008-04-08	11	
-242	val_242	2008-04-08	11	
-369	val_369	2008-04-08	11	
-392	val_392	2008-04-08	11	
-272	val_272	2008-04-08	11	
-331	val_331	2008-04-08	11	
-401	val_401	2008-04-08	11	
-242	val_242	2008-04-08	11	
-452	val_452	2008-04-08	11	
-177	val_177	2008-04-08	11	
-226	val_226	2008-04-08	11	
-5	val_5	2008-04-08	11	
-497	val_497	2008-04-08	11	
-402	val_402	2008-04-08	11	
-396	val_396	2008-04-08	11	
-317	val_317	2008-04-08	11	
-395	val_395	2008-04-08	11	
-58	val_58	2008-04-08	11	
-35	val_35	2008-04-08	11	
-336	val_336	2008-04-08	11	
-95	val_95	2008-04-08	11	
-11	val_11	2008-04-08	11	
-168	val_168	2008-04-08	11	
-34	val_34	2008-04-08	11	
-229	val_229	2008-04-08	11	
-233	val_233	2008-04-08	11	
-143	val_143	2008-04-08	11	
-472	val_472	2008-04-08	11	
-322	val_322	2008-04-08	11	
-498	val_498	2008-04-08	11	
-160	val_160	2008-04-08	11	
-195	val_195	2008-04-08	11	
-42	val_42	2008-04-08	11	
-321	val_321	2008-04-08	11	
-430	val_430	2008-04-08	11	
-119	val_119	2008-04-08	11	
-489	val_489	2008-04-08	11	
-458	val_458	2008-04-08	11	
-78	val_78	2008-04-08	11	
-76	val_76	2008-04-08	11	
-41	val_41	2008-04-08	11	
-223	val_223	2008-04-08	11	
-492	val_492	2008-04-08	11	
-149	val_149	2008-04-08	11	
-449	val_449	2008-04-08	11	
-218	val_218	2008-04-08	11	
-228	val_228	2008-04-08	11	
-138	val_138	2008-04-08	11	
-453	val_453	2008-04-08	11	
-30	val_30	2008-04-08	11	
-209	val_209	2008-04-08	11	
-64	val_64	2008-04-08	11	
-468	val_468	2008-04-08	11	
-76	val_76	2008-04-08	11	
-74	val_74	2008-04-08	11	
-342	val_342	2008-04-08	11	
-69	val_69	2008-04-08	11	
-230	val_230	2008-04-08	11	
-33	val_33	2008-04-08	11	
-368	val_368	2008-04-08	11	
-103	val_103	2008-04-08	11	
-296	val_296	2008-04-08	11	
-113	val_113	2008-04-08	11	
-216	val_216	2008-04-08	11	
-367	val_367	2008-04-08	11	
-344	val_344	2008-04-08	11	
-167	val_167	2008-04-08	11	
-274	val_274	2008-04-08	11	
-219	val_219	2008-04-08	11	
-239	val_239	2008-04-08	11	
-485	val_485	2008-04-08	11	
-116	val_116	2008-04-08	11	
-223	val_223	2008-04-08	11	
-256	val_256	2008-04-08	11	
-263	val_263	2008-04-08	11	
-70	val_70	2008-04-08	11	
-487	val_487	2008-04-08	11	
-480	val_480	2008-04-08	11	
-401	val_401	2008-04-08	11	
-288	val_288	2008-04-08	11	
-191	val_191	2008-04-08	11	
-5	val_5	2008-04-08	11	
-244	val_244	2008-04-08	11	
-438	val_438	2008-04-08	11	
-128	val_128	2008-04-08	11	
-467	val_467	2008-04-08	11	
-432	val_432	2008-04-08	11	
-202	val_202	2008-04-08	11	
-316	val_316	2008-04-08	11	
-229	val_229	2008-04-08	11	
-469	val_469	2008-04-08	11	
-463	val_463	2008-04-08	11	
-280	val_280	2008-04-08	11	
-2	val_2	2008-04-08	11	
-35	val_35	2008-04-08	11	
-283	val_283	2008-04-08	11	
-331	val_331	2008-04-08	11	
-235	val_235	2008-04-08	11	
-80	val_80	2008-04-08	11	
-44	val_44	2008-04-08	11	
-193	val_193	2008-04-08	11	
-321	val_321	2008-04-08	11	
-335	val_335	2008-04-08	11	
-104	val_104	2008-04-08	11	
-466	val_466	2008-04-08	11	
-366	val_366	2008-04-08	11	
-175	val_175	2008-04-08	11	
-403	val_403	2008-04-08	11	
-483	val_483	2008-04-08	11	
-53	val_53	2008-04-08	11	
-105	val_105	2008-04-08	11	
-257	val_257	2008-04-08	11	
-406	val_406	2008-04-08	11	
-409	val_409	2008-04-08	11	
-190	val_190	2008-04-08	11	
-406	val_406	2008-04-08	11	
-401	val_401	2008-04-08	11	
-114	val_114	2008-04-08	11	
-258	val_258	2008-04-08	11	
-90	val_90	2008-04-08	11	
-203	val_203	2008-04-08	11	
-262	val_262	2008-04-08	11	
-348	val_348	2008-04-08	11	
-424	val_424	2008-04-08	11	
-12	val_12	2008-04-08	11	
-396	val_396	2008-04-08	11	
-201	val_201	2008-04-08	11	
-217	val_217	2008-04-08	11	
-164	val_164	2008-04-08	11	
-431	val_431	2008-04-08	11	
-454	val_454	2008-04-08	11	
-478	val_478	2008-04-08	11	
-298	val_298	2008-04-08	11	
-125	val_125	2008-04-08	11	
-431	val_431	2008-04-08	11	
-164	val_164	2008-04-08	11	
-424	val_424	2008-04-08	11	
-187	val_187	2008-04-08	11	
-382	val_382	2008-04-08	11	
-5	val_5	2008-04-08	11	
-70	val_70	2008-04-08	11	
-397	val_397	2008-04-08	11	
-480	val_480	2008-04-08	11	
-291	val_291	2008-04-08	11	
-24	val_24	2008-04-08	11	
-351	val_351	2008-04-08	11	
-255	val_255	2008-04-08	11	
-104	val_104	2008-04-08	11	
-70	val_70	2008-04-08	11	
-163	val_163	2008-04-08	11	
-438	val_438	2008-04-08	11	
-119	val_119	2008-04-08	11	
-414	val_414	2008-04-08	11	
-200	val_200	2008-04-08	11	
-491	val_491	2008-04-08	11	
-237	val_237	2008-04-08	11	
-439	val_439	2008-04-08	11	
-360	val_360	2008-04-08	11	
-248	val_248	2008-04-08	11	
-479	val_479	2008-04-08	11	
-305	val_305	2008-04-08	11	
-417	val_417	2008-04-08	11	
-199	val_199	2008-04-08	11	
-444	val_444	2008-04-08	11	
-120	val_120	2008-04-08	11	
-429	val_429	2008-04-08	11	
-169	val_169	2008-04-08	11	
-443	val_443	2008-04-08	11	
-323	val_323	2008-04-08	11	
-325	val_325	2008-04-08	11	
-277	val_277	2008-04-08	11	
-230	val_230	2008-04-08	11	
-478	val_478	2008-04-08	11	
-178	val_178	2008-04-08	11	
-468	val_468	2008-04-08	11	
-310	val_310	2008-04-08	11	
-317	val_317	2008-04-08	11	
-333	val_333	2008-04-08	11	
-493	val_493	2008-04-08	11	
-460	val_460	2008-04-08	11	
-207	val_207	2008-04-08	11	
-249	val_249	2008-04-08	11	
-265	val_265	2008-04-08	11	
-480	val_480	2008-04-08	11	
-83	val_83	2008-04-08	11	
-136	val_136	2008-04-08	11	
-353	val_353	2008-04-08	11	
-172	val_172	2008-04-08	11	
-214	val_214	2008-04-08	11	
-462	val_462	2008-04-08	11	
-233	val_233	2008-04-08	11	
-406	val_406	2008-04-08	11	
-133	val_133	2008-04-08	11	
-175	val_175	2008-04-08	11	
-189	val_189	2008-04-08	11	
-454	val_454	2008-04-08	11	
-375	val_375	2008-04-08	11	
-401	val_401	2008-04-08	11	
-421	val_421	2008-04-08	11	
-407	val_407	2008-04-08	11	
-384	val_384	2008-04-08	11	
-256	val_256	2008-04-08	11	
-26	val_26	2008-04-08	11	
-134	val_134	2008-04-08	11	
-67	val_67	2008-04-08	11	
-384	val_384	2008-04-08	11	
-379	val_379	2008-04-08	11	
-18	val_18	2008-04-08	11	
-462	val_462	2008-04-08	11	
-492	val_492	2008-04-08	11	
-100	val_100	2008-04-08	11	
-298	val_298	2008-04-08	11	
-9	val_9	2008-04-08	11	
-341	val_341	2008-04-08	11	
-498	val_498	2008-04-08	11	
-146	val_146	2008-04-08	11	
-458	val_458	2008-04-08	11	
-362	val_362	2008-04-08	11	
-186	val_186	2008-04-08	11	
-285	val_285	2008-04-08	11	
-348	val_348	2008-04-08	11	
-167	val_167	2008-04-08	11	
-18	val_18	2008-04-08	11	
-273	val_273	2008-04-08	11	
-183	val_183	2008-04-08	11	
-281	val_281	2008-04-08	11	
-344	val_344	2008-04-08	11	
-97	val_97	2008-04-08	11	
-469	val_469	2008-04-08	11	
-315	val_315	2008-04-08	11	
-84	val_84	2008-04-08	11	
-28	val_28	2008-04-08	11	
-37	val_37	2008-04-08	11	
-448	val_448	2008-04-08	11	
-152	val_152	2008-04-08	11	
-348	val_348	2008-04-08	11	
-307	val_307	2008-04-08	11	
-194	val_194	2008-04-08	11	
-414	val_414	2008-04-08	11	
-477	val_477	2008-04-08	11	
-222	val_222	2008-04-08	11	
-126	val_126	2008-04-08	11	
-90	val_90	2008-04-08	11	
-169	val_169	2008-04-08	11	
-403	val_403	2008-04-08	11	
-400	val_400	2008-04-08	11	
-200	val_200	2008-04-08	11	
-97	val_97	2008-04-08	11	
+ABSTRACT SYNTAX TREE:
+  (TOK_QUERY (TOK_FROM (TOK_TABREF srcpart (TOK_TABLESAMPLE 1 1) s)) (TOK_INSERT (TOK_DESTINATION (TOK_TAB dest1)) (TOK_SELECT (TOK_SELEXPR (TOK_ALLCOLREF s))) (TOK_WHERE (and (= (TOK_COLREF s ds) '2008-04-08') (= (TOK_COLREF s hr) '11')))))
+
+STAGE DEPENDENCIES:
+  Stage-1 is a root stage
+  Stage-0 depends on stages: Stage-1
+
+STAGE PLANS:
+  Stage: Stage-1
+    Map Reduce
+      Path -> Alias:
+        file:/data/zshao/trunk/VENDOR/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11 
+      Path -> Partition:
+        file:/data/zshao/trunk/VENDOR/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11 
+          Partition
+          
+              properties:
+                name srcpart
+                bucket_field_name 
+                serialization.format 1
+                columns key,value
+                partition_columns ds/hr
+                field_to_dimension 
+                bucket_count -1
+                serialization.lib simple_meta
+                file.inputformat org.apache.hadoop.mapred.TextInputFormat
+                file.outputformat org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+                location file:/data/zshao/trunk/VENDOR/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/srcpart
+              name: srcpart
+              serde: simple_meta
+              input format: org.apache.hadoop.mapred.TextInputFormat
+              output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+            partition values:
+              ds 2008-04-08
+              hr 11
+      Alias -> Map Operator Tree:
+        s 
+            Filter Operator
+              predicate:
+                  expr: ((ds = '2008-04-08') and (hr = '11'))
+                  type: Boolean
+              Select Operator
+                expressions:
+                      expr: key
+                      type: string
+                      expr: value
+                      type: string
+                      expr: ds
+                      type: string
+                      expr: hr
+                      type: string
+                File Output Operator
+                  table:
+                      properties:
+                        name dest1
+                        bucket_field_name 
+                        serialization.format 1
+                        columns key,value,dt,hr
+                        SORTBUCKETCOLSPREFIX TRUE
+                        field_to_dimension 
+                        bucket_count -1
+                        serialization.lib simple_meta
+                        file.inputformat org.apache.hadoop.mapred.TextInputFormat
+                        file.outputformat org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+                        location file:/data/zshao/trunk/VENDOR/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/dest1
+                      name: dest1
+                      serde: simple_meta
+                      input format: org.apache.hadoop.mapred.TextInputFormat
+                      output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+                  directory: /tmp/hive-zshao/640225297.10000.insclause-0
+      Needs Tagging:
+
+  Stage: Stage-0
+    Move Operator
+      tables:
+            table:
+                properties:
+                  name dest1
+                  bucket_field_name 
+                  serialization.format 1
+                  columns key,value,dt,hr
+                  SORTBUCKETCOLSPREFIX TRUE
+                  field_to_dimension 
+                  bucket_count -1
+                  serialization.lib simple_meta
+                  file.inputformat org.apache.hadoop.mapred.TextInputFormat
+                  file.outputformat org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+                  location file:/data/zshao/trunk/VENDOR/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/dest1
+                name: dest1
+                serde: simple_meta
+                input format: org.apache.hadoop.mapred.TextInputFormat
+                output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+            replace:
+            source: /tmp/hive-zshao/640225297.10000.insclause-0
+
+
+238	val_238	2008-04-08	11
+86	val_86	2008-04-08	11
+311	val_311	2008-04-08	11
+27	val_27	2008-04-08	11
+165	val_165	2008-04-08	11
+409	val_409	2008-04-08	11
+255	val_255	2008-04-08	11
+278	val_278	2008-04-08	11
+98	val_98	2008-04-08	11
+484	val_484	2008-04-08	11
+265	val_265	2008-04-08	11
+193	val_193	2008-04-08	11
+401	val_401	2008-04-08	11
+150	val_150	2008-04-08	11
+273	val_273	2008-04-08	11
+224	val_224	2008-04-08	11
+369	val_369	2008-04-08	11
+66	val_66	2008-04-08	11
+128	val_128	2008-04-08	11
+213	val_213	2008-04-08	11
+146	val_146	2008-04-08	11
+406	val_406	2008-04-08	11
+429	val_429	2008-04-08	11
+374	val_374	2008-04-08	11
+152	val_152	2008-04-08	11
+469	val_469	2008-04-08	11
+145	val_145	2008-04-08	11
+495	val_495	2008-04-08	11
+37	val_37	2008-04-08	11
+327	val_327	2008-04-08	11
+281	val_281	2008-04-08	11
+277	val_277	2008-04-08	11
+209	val_209	2008-04-08	11
+15	val_15	2008-04-08	11
+82	val_82	2008-04-08	11
+403	val_403	2008-04-08	11
+166	val_166	2008-04-08	11
+417	val_417	2008-04-08	11
+430	val_430	2008-04-08	11
+252	val_252	2008-04-08	11
+292	val_292	2008-04-08	11
+219	val_219	2008-04-08	11
+287	val_287	2008-04-08	11
+153	val_153	2008-04-08	11
+193	val_193	2008-04-08	11
+338	val_338	2008-04-08	11
+446	val_446	2008-04-08	11
+459	val_459	2008-04-08	11
+394	val_394	2008-04-08	11
+237	val_237	2008-04-08	11
+482	val_482	2008-04-08	11
+174	val_174	2008-04-08	11
+413	val_413	2008-04-08	11
+494	val_494	2008-04-08	11
+207	val_207	2008-04-08	11
+199	val_199	2008-04-08	11
+466	val_466	2008-04-08	11
+208	val_208	2008-04-08	11
+174	val_174	2008-04-08	11
+399	val_399	2008-04-08	11
+396	val_396	2008-04-08	11
+247	val_247	2008-04-08	11
+417	val_417	2008-04-08	11
+489	val_489	2008-04-08	11
+162	val_162	2008-04-08	11
+377	val_377	2008-04-08	11
+397	val_397	2008-04-08	11
+309	val_309	2008-04-08	11
+365	val_365	2008-04-08	11
+266	val_266	2008-04-08	11
+439	val_439	2008-04-08	11
+342	val_342	2008-04-08	11
+367	val_367	2008-04-08	11
+325	val_325	2008-04-08	11
+167	val_167	2008-04-08	11
+195	val_195	2008-04-08	11
+475	val_475	2008-04-08	11
+17	val_17	2008-04-08	11
+113	val_113	2008-04-08	11
+155	val_155	2008-04-08	11
+203	val_203	2008-04-08	11
+339	val_339	2008-04-08	11
+0	val_0	2008-04-08	11
+455	val_455	2008-04-08	11
+128	val_128	2008-04-08	11
+311	val_311	2008-04-08	11
+316	val_316	2008-04-08	11
+57	val_57	2008-04-08	11
+302	val_302	2008-04-08	11
+205	val_205	2008-04-08	11
+149	val_149	2008-04-08	11
+438	val_438	2008-04-08	11
+345	val_345	2008-04-08	11
+129	val_129	2008-04-08	11
+170	val_170	2008-04-08	11
+20	val_20	2008-04-08	11
+489	val_489	2008-04-08	11
+157	val_157	2008-04-08	11
+378	val_378	2008-04-08	11
+221	val_221	2008-04-08	11
+92	val_92	2008-04-08	11
+111	val_111	2008-04-08	11
+47	val_47	2008-04-08	11
+72	val_72	2008-04-08	11
+4	val_4	2008-04-08	11
+280	val_280	2008-04-08	11
+35	val_35	2008-04-08	11
+427	val_427	2008-04-08	11
+277	val_277	2008-04-08	11
+208	val_208	2008-04-08	11
+356	val_356	2008-04-08	11
+399	val_399	2008-04-08	11
+169	val_169	2008-04-08	11
+382	val_382	2008-04-08	11
+498	val_498	2008-04-08	11
+125	val_125	2008-04-08	11
+386	val_386	2008-04-08	11
+437	val_437	2008-04-08	11
+469	val_469	2008-04-08	11
+192	val_192	2008-04-08	11
+286	val_286	2008-04-08	11
+187	val_187	2008-04-08	11
+176	val_176	2008-04-08	11
+54	val_54	2008-04-08	11
+459	val_459	2008-04-08	11
+51	val_51	2008-04-08	11
+138	val_138	2008-04-08	11
+103	val_103	2008-04-08	11
+239	val_239	2008-04-08	11
+213	val_213	2008-04-08	11
+216	val_216	2008-04-08	11
+430	val_430	2008-04-08	11
+278	val_278	2008-04-08	11
+176	val_176	2008-04-08	11
+289	val_289	2008-04-08	11
+221	val_221	2008-04-08	11
+65	val_65	2008-04-08	11
+318	val_318	2008-04-08	11
+332	val_332	2008-04-08	11
+311	val_311	2008-04-08	11
+275	val_275	2008-04-08	11
+137	val_137	2008-04-08	11
+241	val_241	2008-04-08	11
+83	val_83	2008-04-08	11
+333	val_333	2008-04-08	11
+180	val_180	2008-04-08	11
+284	val_284	2008-04-08	11
+12	val_12	2008-04-08	11
+230	val_230	2008-04-08	11
+181	val_181	2008-04-08	11
+67	val_67	2008-04-08	11
+260	val_260	2008-04-08	11
+404	val_404	2008-04-08	11
+384	val_384	2008-04-08	11
+489	val_489	2008-04-08	11
+353	val_353	2008-04-08	11
+373	val_373	2008-04-08	11
+272	val_272	2008-04-08	11
+138	val_138	2008-04-08	11
+217	val_217	2008-04-08	11
+84	val_84	2008-04-08	11
+348	val_348	2008-04-08	11
+466	val_466	2008-04-08	11
+58	val_58	2008-04-08	11
+8	val_8	2008-04-08	11
+411	val_411	2008-04-08	11
+230	val_230	2008-04-08	11
+208	val_208	2008-04-08	11
+348	val_348	2008-04-08	11
+24	val_24	2008-04-08	11
+463	val_463	2008-04-08	11
+431	val_431	2008-04-08	11
+179	val_179	2008-04-08	11
+172	val_172	2008-04-08	11
+42	val_42	2008-04-08	11
+129	val_129	2008-04-08	11
+158	val_158	2008-04-08	11
+119	val_119	2008-04-08	11
+496	val_496	2008-04-08	11
+0	val_0	2008-04-08	11
+322	val_322	2008-04-08	11
+197	val_197	2008-04-08	11
+468	val_468	2008-04-08	11
+393	val_393	2008-04-08	11
+454	val_454	2008-04-08	11
+100	val_100	2008-04-08	11
+298	val_298	2008-04-08	11
+199	val_199	2008-04-08	11
+191	val_191	2008-04-08	11
+418	val_418	2008-04-08	11
+96	val_96	2008-04-08	11
+26	val_26	2008-04-08	11
+165	val_165	2008-04-08	11
+327	val_327	2008-04-08	11
+230	val_230	2008-04-08	11
+205	val_205	2008-04-08	11
+120	val_120	2008-04-08	11
+131	val_131	2008-04-08	11
+51	val_51	2008-04-08	11
+404	val_404	2008-04-08	11
+43	val_43	2008-04-08	11
+436	val_436	2008-04-08	11
+156	val_156	2008-04-08	11
+469	val_469	2008-04-08	11
+468	val_468	2008-04-08	11
+308	val_308	2008-04-08	11
+95	val_95	2008-04-08	11
+196	val_196	2008-04-08	11
+288	val_288	2008-04-08	11
+481	val_481	2008-04-08	11
+457	val_457	2008-04-08	11
+98	val_98	2008-04-08	11
+282	val_282	2008-04-08	11
+197	val_197	2008-04-08	11
+187	val_187	2008-04-08	11
+318	val_318	2008-04-08	11
+318	val_318	2008-04-08	11
+409	val_409	2008-04-08	11
+470	val_470	2008-04-08	11
+137	val_137	2008-04-08	11
+369	val_369	2008-04-08	11
+316	val_316	2008-04-08	11
+169	val_169	2008-04-08	11
+413	val_413	2008-04-08	11
+85	val_85	2008-04-08	11
+77	val_77	2008-04-08	11
+0	val_0	2008-04-08	11
+490	val_490	2008-04-08	11
+87	val_87	2008-04-08	11
+364	val_364	2008-04-08	11
+179	val_179	2008-04-08	11
+118	val_118	2008-04-08	11
+134	val_134	2008-04-08	11
+395	val_395	2008-04-08	11
+282	val_282	2008-04-08	11
+138	val_138	2008-04-08	11
+238	val_238	2008-04-08	11
+419	val_419	2008-04-08	11
+15	val_15	2008-04-08	11
+118	val_118	2008-04-08	11
+72	val_72	2008-04-08	11
+90	val_90	2008-04-08	11
+307	val_307	2008-04-08	11
+19	val_19	2008-04-08	11
+435	val_435	2008-04-08	11
+10	val_10	2008-04-08	11
+277	val_277	2008-04-08	11
+273	val_273	2008-04-08	11
+306	val_306	2008-04-08	11
+224	val_224	2008-04-08	11
+309	val_309	2008-04-08	11
+389	val_389	2008-04-08	11
+327	val_327	2008-04-08	11
+242	val_242	2008-04-08	11
+369	val_369	2008-04-08	11
+392	val_392	2008-04-08	11
+272	val_272	2008-04-08	11
+331	val_331	2008-04-08	11
+401	val_401	2008-04-08	11
+242	val_242	2008-04-08	11
+452	val_452	2008-04-08	11
+177	val_177	2008-04-08	11
+226	val_226	2008-04-08	11
+5	val_5	2008-04-08	11
+497	val_497	2008-04-08	11
+402	val_402	2008-04-08	11
+396	val_396	2008-04-08	11
+317	val_317	2008-04-08	11
+395	val_395	2008-04-08	11
+58	val_58	2008-04-08	11
+35	val_35	2008-04-08	11
+336	val_336	2008-04-08	11
+95	val_95	2008-04-08	11
+11	val_11	2008-04-08	11
+168	val_168	2008-04-08	11
+34	val_34	2008-04-08	11
+229	val_229	2008-04-08	11
+233	val_233	2008-04-08	11
+143	val_143	2008-04-08	11
+472	val_472	2008-04-08	11
+322	val_322	2008-04-08	11
+498	val_498	2008-04-08	11
+160	val_160	2008-04-08	11
+195	val_195	2008-04-08	11
+42	val_42	2008-04-08	11
+321	val_321	2008-04-08	11
+430	val_430	2008-04-08	11
+119	val_119	2008-04-08	11
+489	val_489	2008-04-08	11
+458	val_458	2008-04-08	11
+78	val_78	2008-04-08	11
+76	val_76	2008-04-08	11
+41	val_41	2008-04-08	11
+223	val_223	2008-04-08	11
+492	val_492	2008-04-08	11
+149	val_149	2008-04-08	11
+449	val_449	2008-04-08	11
+218	val_218	2008-04-08	11
+228	val_228	2008-04-08	11
+138	val_138	2008-04-08	11
+453	val_453	2008-04-08	11
+30	val_30	2008-04-08	11
+209	val_209	2008-04-08	11
+64	val_64	2008-04-08	11
+468	val_468	2008-04-08	11
+76	val_76	2008-04-08	11
+74	val_74	2008-04-08	11
+342	val_342	2008-04-08	11
+69	val_69	2008-04-08	11
+230	val_230	2008-04-08	11
+33	val_33	2008-04-08	11
+368	val_368	2008-04-08	11
+103	val_103	2008-04-08	11
+296	val_296	2008-04-08	11
+113	val_113	2008-04-08	11
+216	val_216	2008-04-08	11
+367	val_367	2008-04-08	11
+344	val_344	2008-04-08	11
+167	val_167	2008-04-08	11
+274	val_274	2008-04-08	11
+219	val_219	2008-04-08	11
+239	val_239	2008-04-08	11
+485	val_485	2008-04-08	11
+116	val_116	2008-04-08	11
+223	val_223	2008-04-08	11
+256	val_256	2008-04-08	11
+263	val_263	2008-04-08	11
+70	val_70	2008-04-08	11
+487	val_487	2008-04-08	11
+480	val_480	2008-04-08	11
+401	val_401	2008-04-08	11
+288	val_288	2008-04-08	11
+191	val_191	2008-04-08	11
+5	val_5	2008-04-08	11
+244	val_244	2008-04-08	11
+438	val_438	2008-04-08	11
+128	val_128	2008-04-08	11
+467	val_467	2008-04-08	11
+432	val_432	2008-04-08	11
+202	val_202	2008-04-08	11
+316	val_316	2008-04-08	11
+229	val_229	2008-04-08	11
+469	val_469	2008-04-08	11
+463	val_463	2008-04-08	11
+280	val_280	2008-04-08	11
+2	val_2	2008-04-08	11
+35	val_35	2008-04-08	11
+283	val_283	2008-04-08	11
+331	val_331	2008-04-08	11
+235	val_235	2008-04-08	11
+80	val_80	2008-04-08	11
+44	val_44	2008-04-08	11
+193	val_193	2008-04-08	11
+321	val_321	2008-04-08	11
+335	val_335	2008-04-08	11
+104	val_104	2008-04-08	11
+466	val_466	2008-04-08	11
+366	val_366	2008-04-08	11
+175	val_175	2008-04-08	11
+403	val_403	2008-04-08	11
+483	val_483	2008-04-08	11
+53	val_53	2008-04-08	11
+105	val_105	2008-04-08	11
+257	val_257	2008-04-08	11
+406	val_406	2008-04-08	11
+409	val_409	2008-04-08	11
+190	val_190	2008-04-08	11
+406	val_406	2008-04-08	11
+401	val_401	2008-04-08	11
+114	val_114	2008-04-08	11
+258	val_258	2008-04-08	11
+90	val_90	2008-04-08	11
+203	val_203	2008-04-08	11
+262	val_262	2008-04-08	11
+348	val_348	2008-04-08	11
+424	val_424	2008-04-08	11
+12	val_12	2008-04-08	11
+396	val_396	2008-04-08	11
+201	val_201	2008-04-08	11
+217	val_217	2008-04-08	11
+164	val_164	2008-04-08	11
+431	val_431	2008-04-08	11
+454	val_454	2008-04-08	11
+478	val_478	2008-04-08	11
+298	val_298	2008-04-08	11
+125	val_125	2008-04-08	11
+431	val_431	2008-04-08	11
+164	val_164	2008-04-08	11
+424	val_424	2008-04-08	11
+187	val_187	2008-04-08	11
+382	val_382	2008-04-08	11
+5	val_5	2008-04-08	11
+70	val_70	2008-04-08	11
+397	val_397	2008-04-08	11
+480	val_480	2008-04-08	11
+291	val_291	2008-04-08	11
+24	val_24	2008-04-08	11
+351	val_351	2008-04-08	11
+255	val_255	2008-04-08	11
+104	val_104	2008-04-08	11
+70	val_70	2008-04-08	11
+163	val_163	2008-04-08	11
+438	val_438	2008-04-08	11
+119	val_119	2008-04-08	11
+414	val_414	2008-04-08	11
+200	val_200	2008-04-08	11
+491	val_491	2008-04-08	11
+237	val_237	2008-04-08	11
+439	val_439	2008-04-08	11
+360	val_360	2008-04-08	11
+248	val_248	2008-04-08	11
+479	val_479	2008-04-08	11
+305	val_305	2008-04-08	11
+417	val_417	2008-04-08	11
+199	val_199	2008-04-08	11
+444	val_444	2008-04-08	11
+120	val_120	2008-04-08	11
+429	val_429	2008-04-08	11
+169	val_169	2008-04-08	11
+443	val_443	2008-04-08	11
+323	val_323	2008-04-08	11
+325	val_325	2008-04-08	11
+277	val_277	2008-04-08	11
+230	val_230	2008-04-08	11
+478	val_478	2008-04-08	11
+178	val_178	2008-04-08	11
+468	val_468	2008-04-08	11
+310	val_310	2008-04-08	11
+317	val_317	2008-04-08	11
+333	val_333	2008-04-08	11
+493	val_493	2008-04-08	11
+460	val_460	2008-04-08	11
+207	val_207	2008-04-08	11
+249	val_249	2008-04-08	11
+265	val_265	2008-04-08	11
+480	val_480	2008-04-08	11
+83	val_83	2008-04-08	11
+136	val_136	2008-04-08	11
+353	val_353	2008-04-08	11
+172	val_172	2008-04-08	11
+214	val_214	2008-04-08	11
+462	val_462	2008-04-08	11
+233	val_233	2008-04-08	11
+406	val_406	2008-04-08	11
+133	val_133	2008-04-08	11
+175	val_175	2008-04-08	11
+189	val_189	2008-04-08	11
+454	val_454	2008-04-08	11
+375	val_375	2008-04-08	11
+401	val_401	2008-04-08	11
+421	val_421	2008-04-08	11
+407	val_407	2008-04-08	11
+384	val_384	2008-04-08	11
+256	val_256	2008-04-08	11
+26	val_26	2008-04-08	11
+134	val_134	2008-04-08	11
+67	val_67	2008-04-08	11
+384	val_384	2008-04-08	11
+379	val_379	2008-04-08	11
+18	val_18	2008-04-08	11
+462	val_462	2008-04-08	11
+492	val_492	2008-04-08	11
+100	val_100	2008-04-08	11
+298	val_298	2008-04-08	11
+9	val_9	2008-04-08	11
+341	val_341	2008-04-08	11
+498	val_498	2008-04-08	11
+146	val_146	2008-04-08	11
+458	val_458	2008-04-08	11
+362	val_362	2008-04-08	11
+186	val_186	2008-04-08	11
+285	val_285	2008-04-08	11
+348	val_348	2008-04-08	11
+167	val_167	2008-04-08	11
+18	val_18	2008-04-08	11
+273	val_273	2008-04-08	11
+183	val_183	2008-04-08	11
+281	val_281	2008-04-08	11
+344	val_344	2008-04-08	11
+97	val_97	2008-04-08	11
+469	val_469	2008-04-08	11
+315	val_315	2008-04-08	11
+84	val_84	2008-04-08	11
+28	val_28	2008-04-08	11
+37	val_37	2008-04-08	11
+448	val_448	2008-04-08	11
+152	val_152	2008-04-08	11
+348	val_348	2008-04-08	11
+307	val_307	2008-04-08	11
+194	val_194	2008-04-08	11
+414	val_414	2008-04-08	11
+477	val_477	2008-04-08	11
+222	val_222	2008-04-08	11
+126	val_126	2008-04-08	11
+90	val_90	2008-04-08	11
+169	val_169	2008-04-08	11
+403	val_403	2008-04-08	11
+400	val_400	2008-04-08	11
+200	val_200	2008-04-08	11
+97	val_97	2008-04-08	11
+



Mime
View raw message