hadoop-common-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From dhr...@apache.org
Subject svn commit: r696736 [3/7] - in /hadoop/core/trunk: ./ src/contrib/hive/ src/contrib/hive/ql/ src/contrib/hive/ql/src/java/org/apache/hadoop/hive/ql/ src/contrib/hive/ql/src/java/org/apache/hadoop/hive/ql/exec/ src/contrib/hive/ql/src/java/org/apache/ha...
Date Thu, 18 Sep 2008 17:38:04 GMT
Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/udf1.q
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/udf1.q?rev=696736&r1=696735&r2=696736&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/udf1.q (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/udf1.q Thu Sep 18 10:37:59 2008
@@ -2,9 +2,18 @@
   c5 STRING, c6 STRING, c7 STRING, c8 STRING,
   c9 STRING, c10 STRING, c11 STRING, c12 STRING, c13 STRING,
   c14 STRING, c15 STRING, c16 STRING, c17 STRING);
+
+EXPLAIN
 FROM src INSERT OVERWRITE TABLE dest1 SELECT 'a' LIKE '%a%', 'b' LIKE '%a%', 'ab' LIKE '%a%', 'ab' LIKE '%a_',
   '%_' LIKE '\%\_', 'ab' LIKE '\%\_', 'ab' LIKE '_a%', 'ab' LIKE 'a',
   '' RLIKE '.*', 'a' RLIKE '[ab]', '' RLIKE '[ab]', 'hadoop' RLIKE '[a-z]*', 'hadoop' RLIKE 'o*',
   REGEXP_REPLACE('abc', 'b', 'c'), REGEXP_REPLACE('abc', 'z', 'a'), REGEXP_REPLACE('abbbb', 'bb', 'b'), REGEXP_REPLACE('hadoop', '(.)[a-z]*', '$1ive')
   WHERE src.key = 86;
+
+FROM src INSERT OVERWRITE TABLE dest1 SELECT 'a' LIKE '%a%', 'b' LIKE '%a%', 'ab' LIKE '%a%', 'ab' LIKE '%a_',
+  '%_' LIKE '\%\_', 'ab' LIKE '\%\_', 'ab' LIKE '_a%', 'ab' LIKE 'a',
+  '' RLIKE '.*', 'a' RLIKE '[ab]', '' RLIKE '[ab]', 'hadoop' RLIKE '[a-z]*', 'hadoop' RLIKE 'o*',
+  REGEXP_REPLACE('abc', 'b', 'c'), REGEXP_REPLACE('abc', 'z', 'a'), REGEXP_REPLACE('abbbb', 'bb', 'b'), REGEXP_REPLACE('hadoop', '(.)[a-z]*', '$1ive')
+  WHERE src.key = 86;
+
 SELECT dest1.* FROM dest1;

Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/union.q
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/union.q?rev=696736&r1=696735&r2=696736&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/union.q (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/queries/clientpositive/union.q Thu Sep 18 10:37:59 2008
@@ -1,3 +1,11 @@
+EXPLAIN
+FROM (
+  FROM src select src.key, src.value WHERE src.key < 100
+  UNION ALL
+  FROM src SELECT src.* WHERE src.key > 100
+) unioninput
+INSERT OVERWRITE DIRECTORY '../../../../build/contrib/hive/ql/test/data/warehouse/union.out' SELECT unioninput.*;
+
 FROM (
   FROM src select src.key, src.value WHERE src.key < 100
   UNION ALL

Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/cast1.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/cast1.q.out?rev=696736&r1=696735&r2=696736&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/cast1.q.out (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/cast1.q.out Thu Sep 18 10:37:59 2008
@@ -1 +1,50 @@
+ABSTRACT SYNTAX TREE:	
+  (TOK_QUERY (TOK_FROM (TOK_TABREF src)) (TOK_INSERT (TOK_DESTINATION (TOK_TAB dest1)) (TOK_SELECT (TOK_SELEXPR (+ 3 2)) (TOK_SELEXPR (+ 3.0 2)) (TOK_SELEXPR (+ 3 2.0)) (TOK_SELEXPR (+ 3.0 2.0)) (TOK_SELEXPR (+ 3 (TOK_FUNCTION TOK_INT 2.0))) (TOK_SELEXPR (TOK_FUNCTION TOK_BOOLEAN 1)) (TOK_SELEXPR (TOK_FUNCTION TOK_INT TRUE))) (TOK_WHERE (= (TOK_COLREF src key) 86))))	
+	
+STAGE DEPENDENCIES:	
+  Stage-1 is a root stage	
+  Stage-0 depends on stages: Stage-1	
+	
+STAGE PLANS:	
+  Stage: Stage-1	
+    Map Reduce	
+      Alias -> Map Operator Tree:	
+        src 	
+            Filter Operator	
+              predicate:	
+                  expr: (key = 86)	
+                  type: class java.lang.Boolean	
+              Select Operator	
+                expressions:	
+                      expr: (3 + 2)	
+                      type: class java.lang.Integer	
+                      expr: (3.0 + UDFToDouble(2))	
+                      type: class java.lang.Double	
+                      expr: (UDFToDouble(3) + 2.0)	
+                      type: class java.lang.Double	
+                      expr: (3.0 + 2.0)	
+                      type: class java.lang.Double	
+                      expr: (3 + UDFToInteger(2.0))	
+                      type: class java.lang.Integer	
+                      expr: UDFToBoolean(1)	
+                      type: class java.lang.Boolean	
+                      expr: UDFToInteger(true)	
+                      type: class java.lang.Integer	
+                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	
+	
+  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:	
+	
 5	5.0	5.0	5.0	5	false	1	

Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/groupby1.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/groupby1.q.out?rev=696736&r1=696735&r2=696736&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/groupby1.q.out (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/groupby1.q.out Thu Sep 18 10:37:59 2008
@@ -1,3 +1,82 @@
+ABSTRACT SYNTAX TREE:	
+  (TOK_QUERY (TOK_FROM (TOK_TABREF src)) (TOK_INSERT (TOK_DESTINATION (TOK_TAB dest1)) (TOK_SELECT (TOK_SELEXPR (TOK_COLREF src key)) (TOK_SELEXPR (TOK_FUNCTION sum (TOK_FUNCTION substr (TOK_COLREF src value) 4)))) (TOK_GROUPBY (TOK_COLREF src key))))	
+	
+STAGE DEPENDENCIES:	
+  Stage-1 is a root stage	
+  Stage-2 depends on stages: Stage-1	
+  Stage-0 depends on stages: Stage-2	
+	
+STAGE PLANS:	
+  Stage: Stage-1	
+    Map Reduce	
+      Reduce Operator Tree:	
+        Group By Operator	
+          keys:	
+                expr: KEY.0	
+                type: class java.lang.String	
+          mode: partial1	
+        	
+              expr: sum(VALUE.0)	
+          File Output Operator	
+            table:	
+                input format: org.apache.hadoop.mapred.TextInputFormat	
+                output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat	
+      Alias -> Map Operator Tree:	
+        src 	
+            Reduce Output Operator	
+              tag: -1	
+              key expressions:	
+                    expr: key	
+                    type: class java.lang.String	
+              value expressions:	
+                    expr: substr(value, 4)	
+                    type: class java.lang.String	
+              # partition fields: -1	
+	
+  Stage: Stage-2	
+    Map Reduce	
+      Reduce Operator Tree:	
+        Group By Operator	
+          keys:	
+                expr: KEY.0	
+                type: class java.lang.String	
+          mode: partial2	
+        	
+              expr: sum(VALUE.0)	
+          Select Operator	
+            expressions:	
+                  expr: 0	
+                  type: class java.lang.String	
+                  expr: 1	
+                  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:	
+        /tmp/hive-athusoo/51044615.10001 	
+          Reduce Output Operator	
+            tag: -1	
+            key expressions:	
+                  expr: 0	
+                  type: class java.lang.String	
+            value expressions:	
+                  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:	
+	
 0	0.0	
 10	10.0	
 100	200.0	

Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/groupby2.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/groupby2.q.out?rev=696736&r1=696735&r2=696736&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/groupby2.q.out (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/groupby2.q.out Thu Sep 18 10:37:59 2008
@@ -1,3 +1,87 @@
+ABSTRACT SYNTAX TREE:	
+  (TOK_QUERY (TOK_FROM (TOK_TABREF src)) (TOK_INSERT (TOK_DESTINATION (TOK_TAB dest1)) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTION substr (TOK_COLREF src key) 0 1)) (TOK_SELEXPR (TOK_FUNCTIONDI count (TOK_FUNCTION substr (TOK_COLREF src value) 4))) (TOK_SELEXPR (TOK_FUNCTION concat (TOK_FUNCTION substr (TOK_COLREF src key) 0 1) (TOK_FUNCTION sum (TOK_FUNCTION substr (TOK_COLREF src value) 4))))) (TOK_GROUPBY (TOK_FUNCTION substr (TOK_COLREF src key) 0 1))))	
+	
+STAGE DEPENDENCIES:	
+  Stage-1 is a root stage	
+  Stage-2 depends on stages: Stage-1	
+  Stage-0 depends on stages: Stage-2	
+	
+STAGE PLANS:	
+  Stage: Stage-1	
+    Map Reduce	
+      Reduce Operator Tree:	
+        Group By Operator	
+          keys:	
+                expr: KEY.0	
+                type: class java.lang.String	
+          mode: partial1	
+        	
+              expr: count(DISTINCT KEY.1)	
+              expr: sum(KEY.1)	
+          File Output Operator	
+            table:	
+                input format: org.apache.hadoop.mapred.TextInputFormat	
+                output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat	
+      Alias -> Map Operator Tree:	
+        src 	
+            Reduce Output Operator	
+              tag: -1	
+              key expressions:	
+                    expr: substr(key, 0, 1)	
+                    type: class java.lang.String	
+                    expr: substr(value, 4)	
+                    type: class java.lang.String	
+              # partition fields: 2147483647	
+	
+  Stage: Stage-2	
+    Map Reduce	
+      Reduce Operator Tree:	
+        Group By Operator	
+          keys:	
+                expr: KEY.0	
+                type: class java.lang.String	
+          mode: partial2	
+        	
+              expr: count(VALUE.0)	
+              expr: sum(VALUE.1)	
+          Select Operator	
+            expressions:	
+                  expr: 0	
+                  type: class java.lang.String	
+                  expr: 1	
+                  type: class java.lang.String	
+                  expr: concat(0, 2)	
+                  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:	
+        /tmp/hive-athusoo/69737081.10001 	
+          Reduce Output Operator	
+            tag: -1	
+            key expressions:	
+                  expr: 0	
+                  type: class java.lang.String	
+            value expressions:	
+                  expr: 1	
+                  type: class java.lang.String	
+                  expr: 2	
+                  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:	
+	
 0	1	00.0	
 1	71	116414.0	
 2	69	225571.0	

Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/groupby3.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/groupby3.q.out?rev=696736&r1=696735&r2=696736&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/groupby3.q.out (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/groupby3.q.out Thu Sep 18 10:37:59 2008
@@ -1 +1,90 @@
+ABSTRACT SYNTAX TREE:	
+  (TOK_QUERY (TOK_FROM (TOK_TABREF src)) (TOK_INSERT (TOK_DESTINATION (TOK_TAB dest1)) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTION sum (TOK_FUNCTION substr (TOK_COLREF src value) 4))) (TOK_SELEXPR (TOK_FUNCTION avg (TOK_FUNCTION substr (TOK_COLREF src value) 4))) (TOK_SELEXPR (TOK_FUNCTIONDI avg (TOK_FUNCTION substr (TOK_COLREF src value) 4))) (TOK_SELEXPR (TOK_FUNCTION max (TOK_FUNCTION substr (TOK_COLREF src value) 4))) (TOK_SELEXPR (TOK_FUNCTION min (TOK_FUNCTION substr (TOK_COLREF src value) 4))))))	
+	
+STAGE DEPENDENCIES:	
+  Stage-1 is a root stage	
+  Stage-2 depends on stages: Stage-1	
+  Stage-0 depends on stages: Stage-2	
+	
+STAGE PLANS:	
+  Stage: Stage-1	
+    Map Reduce	
+      Reduce Operator Tree:	
+        Group By Operator	
+          mode: partial1	
+        	
+              expr: avg(DISTINCT KEY.0)	
+              expr: sum(KEY.0)	
+              expr: avg(KEY.0)	
+              expr: min(KEY.0)	
+              expr: max(KEY.0)	
+          File Output Operator	
+            table:	
+                input format: org.apache.hadoop.mapred.TextInputFormat	
+                output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat	
+      Alias -> Map Operator Tree:	
+        src 	
+            Reduce Output Operator	
+              tag: -1	
+              key expressions:	
+                    expr: substr(value, 4)	
+                    type: class java.lang.String	
+              # partition fields: 2147483647	
+	
+  Stage: Stage-2	
+    Map Reduce	
+      Reduce Operator Tree:	
+        Group By Operator	
+          mode: partial2	
+        	
+              expr: avg(VALUE.0)	
+              expr: sum(VALUE.1)	
+              expr: avg(VALUE.2)	
+              expr: min(VALUE.3)	
+              expr: max(VALUE.4)	
+          Select Operator	
+            expressions:	
+                  expr: 1	
+                  type: class java.lang.String	
+                  expr: 2	
+                  type: class java.lang.String	
+                  expr: 0	
+                  type: class java.lang.String	
+                  expr: 4	
+                  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:	
+        /tmp/hive-athusoo/1466908404.10001 	
+          Reduce Output Operator	
+            tag: -1	
+            value 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	
+            # partition fields: 0	
+	
+  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:	
+	
 130091.0	260.182	256.10355987055016	498.0	0.0	

Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/groupby4.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/groupby4.q.out?rev=696736&r1=696735&r2=696736&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/groupby4.q.out (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/groupby4.q.out Thu Sep 18 10:37:59 2008
@@ -1,3 +1,70 @@
+ABSTRACT SYNTAX TREE:	
+  (TOK_QUERY (TOK_FROM (TOK_TABREF src)) (TOK_INSERT (TOK_DESTINATION (TOK_TAB dest1)) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTION substr (TOK_COLREF src key) 0 1))) (TOK_GROUPBY (TOK_FUNCTION substr (TOK_COLREF src key) 0 1))))	
+	
+STAGE DEPENDENCIES:	
+  Stage-1 is a root stage	
+  Stage-2 depends on stages: Stage-1	
+  Stage-0 depends on stages: Stage-2	
+	
+STAGE PLANS:	
+  Stage: Stage-1	
+    Map Reduce	
+      Reduce Operator Tree:	
+        Group By Operator	
+          keys:	
+                expr: KEY.0	
+                type: class java.lang.String	
+          mode: partial1	
+          File Output Operator	
+            table:	
+                input format: org.apache.hadoop.mapred.TextInputFormat	
+                output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat	
+      Alias -> Map Operator Tree:	
+        src 	
+            Reduce Output Operator	
+              tag: -1	
+              key expressions:	
+                    expr: substr(key, 0, 1)	
+                    type: class java.lang.String	
+              # partition fields: -1	
+	
+  Stage: Stage-2	
+    Map Reduce	
+      Reduce Operator Tree:	
+        Group By Operator	
+          keys:	
+                expr: KEY.0	
+                type: class java.lang.String	
+          mode: partial2	
+          Select Operator	
+            expressions:	
+                  expr: 0	
+                  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:	
+        /tmp/hive-athusoo/432066033.10001 	
+          Reduce Output Operator	
+            tag: -1	
+            key expressions:	
+                  expr: 0	
+                  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:	
+	
 0	
 1	
 2	

Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/groupby5.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/groupby5.q.out?rev=696736&r1=696735&r2=696736&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/groupby5.q.out (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/groupby5.q.out Thu Sep 18 10:37:59 2008
@@ -1,3 +1,82 @@
+ABSTRACT SYNTAX TREE:	
+  (TOK_QUERY (TOK_FROM (TOK_TABREF src)) (TOK_INSERT (TOK_DESTINATION (TOK_TAB dest1)) (TOK_SELECT (TOK_SELEXPR (TOK_COLREF src key)) (TOK_SELEXPR (TOK_FUNCTION sum (TOK_FUNCTION substr (TOK_COLREF src value) 4)))) (TOK_GROUPBY (TOK_COLREF src key))))	
+	
+STAGE DEPENDENCIES:	
+  Stage-1 is a root stage	
+  Stage-2 depends on stages: Stage-1	
+  Stage-0 depends on stages: Stage-2	
+	
+STAGE PLANS:	
+  Stage: Stage-1	
+    Map Reduce	
+      Reduce Operator Tree:	
+        Group By Operator	
+          keys:	
+                expr: KEY.0	
+                type: class java.lang.String	
+          mode: partial1	
+        	
+              expr: sum(VALUE.0)	
+          File Output Operator	
+            table:	
+                input format: org.apache.hadoop.mapred.TextInputFormat	
+                output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat	
+      Alias -> Map Operator Tree:	
+        src 	
+            Reduce Output Operator	
+              tag: -1	
+              key expressions:	
+                    expr: key	
+                    type: class java.lang.String	
+              value expressions:	
+                    expr: substr(value, 4)	
+                    type: class java.lang.String	
+              # partition fields: -1	
+	
+  Stage: Stage-2	
+    Map Reduce	
+      Reduce Operator Tree:	
+        Group By Operator	
+          keys:	
+                expr: KEY.0	
+                type: class java.lang.String	
+          mode: partial2	
+        	
+              expr: sum(VALUE.0)	
+          Select Operator	
+            expressions:	
+                  expr: 0	
+                  type: class java.lang.String	
+                  expr: 1	
+                  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:	
+        /tmp/hive-athusoo/423676467.10001 	
+          Reduce Output Operator	
+            tag: -1	
+            key expressions:	
+                  expr: 0	
+                  type: class java.lang.String	
+            value expressions:	
+                  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:	
+	
 0	0.0	
 10	10.0	
 100	200.0	

Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/groupby6.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/groupby6.q.out?rev=696736&r1=696735&r2=696736&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/groupby6.q.out (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/groupby6.q.out Thu Sep 18 10:37:59 2008
@@ -1,3 +1,70 @@
+ABSTRACT SYNTAX TREE:	
+  (TOK_QUERY (TOK_FROM (TOK_TABREF src)) (TOK_INSERT (TOK_DESTINATION (TOK_TAB dest1)) (TOK_SELECTDI (TOK_SELEXPR (TOK_FUNCTION substr (TOK_COLREF src value) 4 1)))))	
+	
+STAGE DEPENDENCIES:	
+  Stage-1 is a root stage	
+  Stage-2 depends on stages: Stage-1	
+  Stage-0 depends on stages: Stage-2	
+	
+STAGE PLANS:	
+  Stage: Stage-1	
+    Map Reduce	
+      Reduce Operator Tree:	
+        Group By Operator	
+          keys:	
+                expr: KEY.0	
+                type: class java.lang.String	
+          mode: partial1	
+          File Output Operator	
+            table:	
+                input format: org.apache.hadoop.mapred.TextInputFormat	
+                output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat	
+      Alias -> Map Operator Tree:	
+        src 	
+            Reduce Output Operator	
+              tag: -1	
+              key expressions:	
+                    expr: substr(value, 4, 1)	
+                    type: class java.lang.String	
+              # partition fields: -1	
+	
+  Stage: Stage-2	
+    Map Reduce	
+      Reduce Operator Tree:	
+        Group By Operator	
+          keys:	
+                expr: KEY.0	
+                type: class java.lang.String	
+          mode: partial2	
+          Select Operator	
+            expressions:	
+                  expr: 0	
+                  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:	
+        /tmp/hive-athusoo/76679435.10001 	
+          Reduce Output Operator	
+            tag: -1	
+            key expressions:	
+                  expr: 0	
+                  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:	
+	
 0	
 1	
 2	

Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input1.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input1.q.out?rev=696736&r1=696735&r2=696736&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input1.q.out (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input1.q.out Thu Sep 18 10:37:59 2008
@@ -1,2 +1,14 @@
+ABSTRACT SYNTAX TREE:	
+  (TOK_DESCTABLE TEST1)	
+	
+STAGE DEPENDENCIES:	
+  Stage-0 is a root stage	
+	
+STAGE PLANS:	
+  Stage: Stage-0	
+    	
+      Describe Table	
+        table: TEST1	
+	
 a	int	
 b	float	

Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input10.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input10.q.out?rev=696736&r1=696735&r2=696736&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input10.q.out (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input10.q.out Thu Sep 18 10:37:59 2008
@@ -1,3 +1,15 @@
+ABSTRACT SYNTAX TREE:	
+  (TOK_DESCTABLE TEST10)	
+	
+STAGE DEPENDENCIES:	
+  Stage-0 is a root stage	
+	
+STAGE PLANS:	
+  Stage: Stage-0	
+    	
+      Describe Table	
+        table: TEST10	
+	
 key	int	
 value	string	
 ds	string	

Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input11.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input11.q.out?rev=696736&r1=696735&r2=696736&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input11.q.out (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input11.q.out Thu Sep 18 10:37:59 2008
@@ -1,3 +1,42 @@
+ABSTRACT SYNTAX TREE:	
+  (TOK_QUERY (TOK_FROM (TOK_TABREF src)) (TOK_INSERT (TOK_DESTINATION (TOK_TAB dest1)) (TOK_SELECT (TOK_SELEXPR (TOK_COLREF src key)) (TOK_SELEXPR (TOK_COLREF src value))) (TOK_WHERE (< (TOK_COLREF src key) 100))))	
+	
+STAGE DEPENDENCIES:	
+  Stage-1 is a root stage	
+  Stage-0 depends on stages: Stage-1	
+	
+STAGE PLANS:	
+  Stage: Stage-1	
+    Map Reduce	
+      Alias -> Map Operator Tree:	
+        src 	
+            Filter Operator	
+              predicate:	
+                  expr: (key < 100)	
+                  type: class java.lang.Boolean	
+              Select Operator	
+                expressions:	
+                      expr: key	
+                      type: class java.lang.String	
+                      expr: value	
+                      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	
+	
+  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:	
+	
 86	val_86	
 27	val_27	
 98	val_98	

Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input12.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input12.q.out?rev=696736&r1=696735&r2=696736&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input12.q.out (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input12.q.out Thu Sep 18 10:37:59 2008
@@ -1,3 +1,87 @@
+ABSTRACT SYNTAX TREE:	
+  (TOK_QUERY (TOK_FROM (TOK_TABREF src)) (TOK_INSERT (TOK_DESTINATION (TOK_TAB dest1)) (TOK_SELECT (TOK_SELEXPR (TOK_ALLCOLREF src))) (TOK_WHERE (< (TOK_COLREF src key) 100))) (TOK_INSERT (TOK_DESTINATION (TOK_TAB dest2)) (TOK_SELECT (TOK_SELEXPR (TOK_COLREF src key)) (TOK_SELEXPR (TOK_COLREF src value))) (TOK_WHERE (and (>= (TOK_COLREF src key) 100) (< (TOK_COLREF src key) 200)))) (TOK_INSERT (TOK_DESTINATION (TOK_TAB dest3 (TOK_PARTSPEC (TOK_PARTVAL ds '2008-04-08') (TOK_PARTVAL hr '12')))) (TOK_SELECT (TOK_SELEXPR (TOK_COLREF src key))) (TOK_WHERE (>= (TOK_COLREF src key) 200))))	
+	
+STAGE DEPENDENCIES:	
+  Stage-1 is a root stage	
+  Stage-0 depends on stages: Stage-1	
+	
+STAGE PLANS:	
+  Stage: Stage-1	
+    Map Reduce	
+      Alias -> Map Operator Tree:	
+        src 	
+            Filter Operator	
+              predicate:	
+                  expr: (key < 100)	
+                  type: class java.lang.Boolean	
+              Select Operator	
+                expressions:	
+                      expr: key	
+                      type: class java.lang.String	
+                      expr: value	
+                      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	
+            Filter Operator	
+              predicate:	
+                  expr: ((key >= 100) and (key < 200))	
+                  type: class java.lang.Boolean	
+              Select Operator	
+                expressions:	
+                      expr: key	
+                      type: class java.lang.String	
+                      expr: value	
+                      type: class java.lang.String	
+                File Output Operator	
+                  table:	
+                      name: dest2	
+                      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	
+            Filter Operator	
+              predicate:	
+                  expr: (key >= 200)	
+                  type: class java.lang.Boolean	
+              Select Operator	
+                expressions:	
+                      expr: key	
+                      type: class java.lang.String	
+                File Output Operator	
+                  table:	
+                      name: dest3	
+                      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	
+	
+  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:	
+            table:	
+                name: dest2	
+                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:	
+            table:	
+                name: dest3	
+                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	
+            partition:	
+              ds 2008-04-08	
+              hr 12	
+            replace:	
+	
 86	val_86	
 27	val_27	
 98	val_98	

Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input13.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input13.q.out?rev=696736&r1=696735&r2=696736&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input13.q.out (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input13.q.out Thu Sep 18 10:37:59 2008
@@ -1,3 +1,102 @@
+ABSTRACT SYNTAX TREE:	
+  (TOK_QUERY (TOK_FROM (TOK_TABREF src)) (TOK_INSERT (TOK_DESTINATION (TOK_TAB dest1)) (TOK_SELECT (TOK_SELEXPR (TOK_ALLCOLREF src))) (TOK_WHERE (< (TOK_COLREF src key) 100))) (TOK_INSERT (TOK_DESTINATION (TOK_TAB dest2)) (TOK_SELECT (TOK_SELEXPR (TOK_COLREF src key)) (TOK_SELEXPR (TOK_COLREF src value))) (TOK_WHERE (and (>= (TOK_COLREF src key) 100) (< (TOK_COLREF src key) 200)))) (TOK_INSERT (TOK_DESTINATION (TOK_TAB dest3 (TOK_PARTSPEC (TOK_PARTVAL ds '2008-04-08') (TOK_PARTVAL hr '12')))) (TOK_SELECT (TOK_SELEXPR (TOK_COLREF src key))) (TOK_WHERE (and (>= (TOK_COLREF src key) 200) (< (TOK_COLREF src key) 300)))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR '../../../../build/contrib/hive/ql/test/data/warehouse/dest4.out')) (TOK_SELECT (TOK_SELEXPR (TOK_COLREF src value))) (TOK_WHERE (>= (TOK_COLREF src key) 300))))	
+	
+STAGE DEPENDENCIES:	
+  Stage-1 is a root stage	
+  Stage-0 depends on stages: Stage-1	
+	
+STAGE PLANS:	
+  Stage: Stage-1	
+    Map Reduce	
+      Alias -> Map Operator Tree:	
+        src 	
+            Filter Operator	
+              predicate:	
+                  expr: (key < 100)	
+                  type: class java.lang.Boolean	
+              Select Operator	
+                expressions:	
+                      expr: key	
+                      type: class java.lang.String	
+                      expr: value	
+                      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	
+            Filter Operator	
+              predicate:	
+                  expr: ((key >= 100) and (key < 200))	
+                  type: class java.lang.Boolean	
+              Select Operator	
+                expressions:	
+                      expr: key	
+                      type: class java.lang.String	
+                      expr: value	
+                      type: class java.lang.String	
+                File Output Operator	
+                  table:	
+                      name: dest2	
+                      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	
+            Filter Operator	
+              predicate:	
+                  expr: ((key >= 200) and (key < 300))	
+                  type: class java.lang.Boolean	
+              Select Operator	
+                expressions:	
+                      expr: key	
+                      type: class java.lang.String	
+                File Output Operator	
+                  table:	
+                      name: dest3	
+                      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	
+            Filter Operator	
+              predicate:	
+                  expr: (key >= 300)	
+                  type: class java.lang.Boolean	
+              Select Operator	
+                expressions:	
+                      expr: value	
+                      type: class java.lang.String	
+                File Output Operator	
+                  table:	
+                      input format: org.apache.hadoop.mapred.TextInputFormat	
+                      output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat	
+	
+  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:	
+            table:	
+                name: dest2	
+                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:	
+            table:	
+                name: dest3	
+                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	
+            partition:	
+              ds 2008-04-08	
+              hr 12	
+            replace:	
+      files:	
+            destination: ../../../../build/contrib/hive/ql/test/data/warehouse/dest4.out	
+            hdfs directory:	
+	
 86	val_86	
 27	val_27	
 98	val_98	

Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input14.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input14.q.out?rev=696736&r1=696735&r2=696736&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input14.q.out (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input14.q.out Thu Sep 18 10:37:59 2008
@@ -1,3 +1,66 @@
+ABSTRACT SYNTAX TREE:	
+  (TOK_QUERY (TOK_FROM (TOK_SUBQUERY (TOK_QUERY (TOK_FROM (TOK_TABREF src)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_TRANSFORM (TOK_COLLIST (TOK_COLREF src key) (TOK_COLREF src value)) (TOK_ALIASLIST tkey tvalue) '/bin/cat'))) (TOK_CLUSTERBY tkey))) tmap)) (TOK_INSERT (TOK_DESTINATION (TOK_TAB dest1)) (TOK_SELECT (TOK_SELEXPR (TOK_COLREF tmap tkey)) (TOK_SELEXPR (TOK_COLREF tmap tvalue))) (TOK_WHERE (< (TOK_COLREF tmap tkey) 100))))	
+	
+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:	
+        Extract	
+          Filter Operator	
+            predicate:	
+                expr: (0 < 100)	
+                type: class java.lang.Boolean	
+            Select Operator	
+              expressions:	
+                    expr: 0	
+                    type: class java.lang.String	
+                    expr: 1	
+                    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:	
+        tmap:src 	
+            Select Operator	
+              expressions:	
+                    expr: key	
+                    type: class java.lang.String	
+                    expr: value	
+                    type: class java.lang.String	
+              Transform Operator	
+                command: /bin/cat	
+                output info:	
+                    input format: org.apache.hadoop.mapred.TextInputFormat	
+                    output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat	
+                Reduce Output Operator	
+                  tag: -1	
+                  key expressions:	
+                        expr: tkey	
+                        type: class java.lang.String	
+                  value expressions:	
+                        expr: tkey	
+                        type: class java.lang.String	
+                        expr: tvalue	
+                        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:	
+	
 0	val_0	
 0	val_0	
 0	val_0	

Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input15.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input15.q.out?rev=696736&r1=696735&r2=696736&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input15.q.out (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input15.q.out Thu Sep 18 10:37:59 2008
@@ -1,2 +1,18 @@
-key	int	
-value	string	
+ABSTRACT SYNTAX TREE:	
+  (TOK_CREATETABLE TEST15 (TOK_TABCOLLIST (TOK_TABCOL key TOK_INT) (TOK_TABCOL value TOK_STRING)) (TOK_TABLEROWFORMAT (TOK_TABLEROWFORMATFIELD '\t')))	
+	
+STAGE DEPENDENCIES:	
+  Stage-0 is a root stage	
+	
+STAGE PLANS:	
+  Stage: Stage-0	
+      Create Table Operator:	
+        Create Table	
+          isExternal:	
+          name: TEST15	
+          field delimiter: 		
+          isCompressed:	
+          # buckets: -1	
+          columns: key int, value string	
+	
+Table TEST15 does not exist	

Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input2.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input2.q.out?rev=696736&r1=696735&r2=696736&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input2.q.out (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input2.q.out Thu Sep 18 10:37:59 2008
@@ -5,3 +5,14 @@
 c	map<float,int>	
 src	src1	src_sequencefile	src_thrift	srcbucket	srcpart	test2a	test2b	
 src	src1	src_sequencefile	src_thrift	srcbucket	srcpart	test2b	
+ABSTRACT SYNTAX TREE:	
+  TOK_SHOWTABLES	
+	
+STAGE DEPENDENCIES:	
+  Stage-0 is a root stage	
+	
+STAGE PLANS:	
+  Stage: Stage-0	
+    	
+      Show Tables	
+	

Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input3.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input3.q.out?rev=696736&r1=696735&r2=696736&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input3.q.out (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input3.q.out Thu Sep 18 10:37:59 2008
@@ -4,10 +4,38 @@
 b	float	
 c	map<float,int>	
 src	src1	src_sequencefile	src_thrift	srcbucket	srcpart	test3a	test3b	
+ABSTRACT SYNTAX TREE:	
+  (TOK_ALTERTABLE_ADDCOLS TEST3b (TOK_TABCOLLIST (TOK_TABCOL X TOK_FLOAT)))	
+	
+STAGE DEPENDENCIES:	
+  Stage-0 is a root stage	
+	
+STAGE PLANS:	
+  Stage: Stage-0	
+    	
+      Alter Table	
+        old name: TEST3b	
+        type: add columns	
+        new columns: a array<int>, b float, c map<float,int>, X float	
+	
 a	array<int>	
 b	float	
 c	map<float,int>	
 x	float	
+ABSTRACT SYNTAX TREE:	
+  (TOK_ALTERTABLE_RENAME TEST3b TEST3c)	
+	
+STAGE DEPENDENCIES:	
+  Stage-0 is a root stage	
+	
+STAGE PLANS:	
+  Stage: Stage-0	
+    	
+      Alter Table	
+        old name: TEST3b	
+        new name: TEST3c	
+        type: rename	
+	
 a	array<int>	
 b	float	
 c	map<float,int>	

Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input4.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input4.q.out?rev=696736&r1=696735&r2=696736&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input4.q.out (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input4.q.out Thu Sep 18 10:37:59 2008
@@ -1,3 +1,26 @@
+ABSTRACT SYNTAX TREE:	
+  (TOK_LOAD '../data/files/kv1.txt' (TOK_TAB INPUT4) LOCAL)	
+	
+STAGE DEPENDENCIES:	
+  Stage-0 is a root stage	
+  Stage-1 depends on stages: Stage-0	
+	
+STAGE PLANS:	
+  Stage: Stage-0	
+    Copy	
+      source: file:/home/athusoo/projects/hadoop/trunk/VENDOR/hadoop-0.17/src/contrib/hive/data/files/kv1.txt	
+      destination: file:/tmp/hive-athusoo/-494206631	
+	
+  Stage: Stage-1	
+    Move Operator	
+      tables:	
+            table:	
+                name: input4	
+                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:	
+	
 val_238	238	
 val_86	86	
 val_311	311	

Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input5.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input5.q.out?rev=696736&r1=696735&r2=696736&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input5.q.out (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input5.q.out Thu Sep 18 10:37:59 2008
@@ -1,3 +1,62 @@
+ABSTRACT SYNTAX TREE:	
+  (TOK_QUERY (TOK_FROM (TOK_SUBQUERY (TOK_QUERY (TOK_FROM (TOK_TABREF src_thrift)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_TRANSFORM (TOK_COLLIST (TOK_COLREF src_thrift lint) (TOK_COLREF src_thrift lintstring)) (TOK_ALIASLIST tkey tvalue) '/bin/cat'))) (TOK_CLUSTERBY tkey))) tmap)) (TOK_INSERT (TOK_DESTINATION (TOK_TAB dest1)) (TOK_SELECT (TOK_SELEXPR (TOK_COLREF tmap tkey)) (TOK_SELEXPR (TOK_COLREF tmap tvalue)))))	
+	
+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:	
+        Extract	
+          Select Operator	
+            expressions:	
+                  expr: 0	
+                  type: class java.lang.String	
+                  expr: 1	
+                  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:	
+        tmap:src_thrift 	
+            Select Operator	
+              expressions:	
+                    expr: lint	
+                    type: List<class java.lang.Integer>	
+                    expr: lintstring	
+                    type: List<Struct([class java.lang.Integer, class java.lang.String])>	
+              Transform Operator	
+                command: /bin/cat	
+                output info:	
+                    input format: org.apache.hadoop.mapred.TextInputFormat	
+                    output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat	
+                Reduce Output Operator	
+                  tag: -1	
+                  key expressions:	
+                        expr: tkey	
+                        type: class java.lang.String	
+                  value expressions:	
+                        expr: tkey	
+                        type: class java.lang.String	
+                        expr: tvalue	
+                        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:	
+	
 [0,0,0]	[{"1":{"i32":0},"2":{"str":"0"}}]	
 [1,2,3]	[{"1":{"i32":1},"2":{"str":"1"}}]	
 [2,4,6]	[{"1":{"i32":4},"2":{"str":"8"}}]	

Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input6.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input6.q.out?rev=696736&r1=696735&r2=696736&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input6.q.out (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input6.q.out Thu Sep 18 10:37:59 2008
@@ -0,0 +1,39 @@
+ABSTRACT SYNTAX TREE:	
+  (TOK_QUERY (TOK_FROM (TOK_TABREF src1)) (TOK_INSERT (TOK_DESTINATION (TOK_TAB dest1)) (TOK_SELECT (TOK_SELEXPR (TOK_COLREF src1 key)) (TOK_SELEXPR (TOK_COLREF src1 value))) (TOK_WHERE (TOK_FUNCTION TOK_ISNULL (TOK_COLREF src1 key)))))	
+	
+STAGE DEPENDENCIES:	
+  Stage-1 is a root stage	
+  Stage-0 depends on stages: Stage-1	
+	
+STAGE PLANS:	
+  Stage: Stage-1	
+    Map Reduce	
+      Alias -> Map Operator Tree:	
+        src1 	
+            Filter Operator	
+              predicate:	
+                  expr: key is null	
+                  type: class java.lang.Boolean	
+              Select Operator	
+                expressions:	
+                      expr: key	
+                      type: class java.lang.String	
+                      expr: value	
+                      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	
+	
+  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:	
+	

Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input7.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input7.q.out?rev=696736&r1=696735&r2=696736&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input7.q.out (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input7.q.out Thu Sep 18 10:37:59 2008
@@ -1,3 +1,38 @@
+ABSTRACT SYNTAX TREE:	
+  (TOK_QUERY (TOK_FROM (TOK_TABREF src1)) (TOK_INSERT (TOK_DESTINATION (TOK_TAB dest1)) (TOK_SELECT (TOK_SELEXPR TOK_NULL) (TOK_SELEXPR (TOK_COLREF src1 key)))))	
+	
+STAGE DEPENDENCIES:	
+  Stage-1 is a root stage	
+  Stage-0 depends on stages: Stage-1	
+	
+STAGE PLANS:	
+  Stage: Stage-1	
+    Map Reduce	
+      Alias -> Map Operator Tree:	
+        src1 	
+            Select Operator	
+              expressions:	
+                    expr: null	
+                    type: class java.lang.Void	
+                    expr: key	
+                    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	
+	
+  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:	
+	
 NULL	238	
 NULL		
 NULL	311	

Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input8.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input8.q.out?rev=696736&r1=696735&r2=696736&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input8.q.out (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input8.q.out Thu Sep 18 10:37:59 2008
@@ -1,3 +1,40 @@
+ABSTRACT SYNTAX TREE:	
+  (TOK_QUERY (TOK_FROM (TOK_TABREF src1)) (TOK_INSERT (TOK_DESTINATION (TOK_TAB dest1)) (TOK_SELECT (TOK_SELEXPR (+ 4 TOK_NULL)) (TOK_SELEXPR (- (TOK_COLREF src1 key) TOK_NULL)) (TOK_SELEXPR (+ TOK_NULL TOK_NULL)))))	
+	
+STAGE DEPENDENCIES:	
+  Stage-1 is a root stage	
+  Stage-0 depends on stages: Stage-1	
+	
+STAGE PLANS:	
+  Stage: Stage-1	
+    Map Reduce	
+      Alias -> Map Operator Tree:	
+        src1 	
+            Select Operator	
+              expressions:	
+                    expr: (4 + null)	
+                    type: class java.lang.Integer	
+                    expr: (UDFToDouble(key) - null)	
+                    type: class java.lang.Double	
+                    expr: (null + null)	
+                    type: class java.lang.Byte	
+              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	
+	
+  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:	
+	
 NULL	NULL	NULL	
 NULL	NULL	NULL	
 NULL	NULL	NULL	

Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input9.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input9.q.out?rev=696736&r1=696735&r2=696736&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input9.q.out (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input9.q.out Thu Sep 18 10:37:59 2008
@@ -0,0 +1,39 @@
+ABSTRACT SYNTAX TREE:	
+  (TOK_QUERY (TOK_FROM (TOK_TABREF src1)) (TOK_INSERT (TOK_DESTINATION (TOK_TAB dest1)) (TOK_SELECT (TOK_SELEXPR TOK_NULL) (TOK_SELEXPR (TOK_COLREF src1 key))) (TOK_WHERE (= TOK_NULL TOK_NULL))))	
+	
+STAGE DEPENDENCIES:	
+  Stage-1 is a root stage	
+  Stage-0 depends on stages: Stage-1	
+	
+STAGE PLANS:	
+  Stage: Stage-1	
+    Map Reduce	
+      Alias -> Map Operator Tree:	
+        src1 	
+            Filter Operator	
+              predicate:	
+                  expr: (null = null)	
+                  type: class java.lang.Boolean	
+              Select Operator	
+                expressions:	
+                      expr: null	
+                      type: class java.lang.Void	
+                      expr: key	
+                      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	
+	
+  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:	
+	

Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input_part1.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input_part1.q.out?rev=696736&r1=696735&r2=696736&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input_part1.q.out (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input_part1.q.out Thu Sep 18 10:37:59 2008
@@ -1,3 +1,46 @@
+ABSTRACT SYNTAX TREE:	
+  (TOK_QUERY (TOK_FROM (TOK_TABREF srcpart)) (TOK_INSERT (TOK_DESTINATION (TOK_TAB dest1)) (TOK_SELECT (TOK_SELEXPR (TOK_COLREF srcpart key)) (TOK_SELEXPR (TOK_COLREF srcpart value)) (TOK_SELEXPR (TOK_COLREF srcpart hr)) (TOK_SELEXPR (TOK_COLREF srcpart ds))) (TOK_WHERE (and (and (< (TOK_COLREF srcpart key) 100) (= (TOK_COLREF srcpart ds) '2008-04-08')) (= (TOK_COLREF srcpart hr) '12')))))	
+	
+STAGE DEPENDENCIES:	
+  Stage-1 is a root stage	
+  Stage-0 depends on stages: Stage-1	
+	
+STAGE PLANS:	
+  Stage: Stage-1	
+    Map Reduce	
+      Alias -> Map Operator Tree:	
+        srcpart 	
+            Filter Operator	
+              predicate:	
+                  expr: (((key < 100) and (ds = '2008-04-08')) and (hr = '12'))	
+                  type: class java.lang.Boolean	
+              Select Operator	
+                expressions:	
+                      expr: key	
+                      type: class java.lang.String	
+                      expr: value	
+                      type: class java.lang.String	
+                      expr: hr	
+                      type: class java.lang.String	
+                      expr: ds	
+                      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	
+	
+  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:	
+	
 86	val_86	12	2008-04-08	
 27	val_27	12	2008-04-08	
 98	val_98	12	2008-04-08	

Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input_testsequencefile.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input_testsequencefile.q.out?rev=696736&r1=696735&r2=696736&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input_testsequencefile.q.out (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input_testsequencefile.q.out Thu Sep 18 10:37:59 2008
@@ -1,3 +1,38 @@
+ABSTRACT SYNTAX TREE:	
+  (TOK_QUERY (TOK_FROM (TOK_TABREF src)) (TOK_INSERT (TOK_DESTINATION (TOK_TAB dest4_sequencefile)) (TOK_SELECT (TOK_SELEXPR (TOK_COLREF src key)) (TOK_SELEXPR (TOK_COLREF src value)))))	
+	
+STAGE DEPENDENCIES:	
+  Stage-1 is a root stage	
+  Stage-0 depends on stages: Stage-1	
+	
+STAGE PLANS:	
+  Stage: Stage-1	
+    Map Reduce	
+      Alias -> Map Operator Tree:	
+        src 	
+            Select Operator	
+              expressions:	
+                    expr: key	
+                    type: class java.lang.String	
+                    expr: value	
+                    type: class java.lang.String	
+              File Output Operator	
+                table:	
+                    name: dest4_sequencefile	
+                    serde: org.apache.hadoop.hive.serde.simple_meta.MetadataTypedColumnsetSerDe	
+                    input format: org.apache.hadoop.mapred.SequenceFileInputFormat	
+                    output format: org.apache.hadoop.mapred.SequenceFileOutputFormat	
+	
+  Stage: Stage-0	
+    Move Operator	
+      tables:	
+            table:	
+                name: dest4_sequencefile	
+                serde: org.apache.hadoop.hive.serde.simple_meta.MetadataTypedColumnsetSerDe	
+                input format: org.apache.hadoop.mapred.SequenceFileInputFormat	
+                output format: org.apache.hadoop.mapred.SequenceFileOutputFormat	
+            replace:	
+	
 238	val_238	
 86	val_86	
 311	val_311	

Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input_testxpath.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input_testxpath.q.out?rev=696736&r1=696735&r2=696736&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input_testxpath.q.out (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input_testxpath.q.out Thu Sep 18 10:37:59 2008
@@ -1,3 +1,38 @@
+ABSTRACT SYNTAX TREE:	
+  (TOK_QUERY (TOK_FROM (TOK_TABREF src_thrift)) (TOK_INSERT (TOK_DESTINATION (TOK_TAB dest1)) (TOK_SELECT (TOK_SELEXPR ([ (TOK_COLREF src_thrift lint) 1)) (TOK_SELEXPR (. ([ (TOK_COLREF src_thrift lintstring) 0) mystring)))))	
+	
+STAGE DEPENDENCIES:	
+  Stage-1 is a root stage	
+  Stage-0 depends on stages: Stage-1	
+	
+STAGE PLANS:	
+  Stage: Stage-1	
+    Map Reduce	
+      Alias -> Map Operator Tree:	
+        src_thrift 	
+            Select Operator	
+              expressions:	
+                    expr: lint[1]	
+                    type: class java.lang.Integer	
+                    expr: lintstring[0].mystring	
+                    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	
+	
+  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:	
+	
 0	0	
 2	1	
 4	8	

Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/inputddl1.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/inputddl1.q.out?rev=696736&r1=696735&r2=696736&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/inputddl1.q.out (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/inputddl1.q.out Thu Sep 18 10:37:59 2008
@@ -0,0 +1,16 @@
+ABSTRACT SYNTAX TREE:	
+  (TOK_CREATETABLE INPUTDDL1 (TOK_TABCOLLIST (TOK_TABCOL key TOK_INT) (TOK_TABCOL value TOK_STRING)))	
+	
+STAGE DEPENDENCIES:	
+  Stage-0 is a root stage	
+	
+STAGE PLANS:	
+  Stage: Stage-0	
+      Create Table Operator:	
+        Create Table	
+          isExternal:	
+          name: INPUTDDL1	
+          isCompressed:	
+          # buckets: -1	
+          columns: key int, value string	
+	

Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/inputddl2.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/inputddl2.q.out?rev=696736&r1=696735&r2=696736&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/inputddl2.q.out (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/inputddl2.q.out Thu Sep 18 10:37:59 2008
@@ -1,3 +1,20 @@
+ABSTRACT SYNTAX TREE:	
+  (TOK_CREATETABLE INPUTDDL2 (TOK_TABCOLLIST (TOK_TABCOL key TOK_INT) (TOK_TABCOL value TOK_STRING)) (TOK_TABLEPARTCOLS (TOK_TABCOLLIST (TOK_TABCOL ds TOK_DATETIME) (TOK_TABCOL country TOK_STRING))))	
+	
+STAGE DEPENDENCIES:	
+  Stage-0 is a root stage	
+	
+STAGE PLANS:	
+  Stage: Stage-0	
+      Create Table Operator:	
+        Create Table	
+          isExternal:	
+          name: INPUTDDL2	
+          isCompressed:	
+          # buckets: -1	
+          columns: key int, value string	
+          partition columns: ds datetime, country string	
+	
 key	int	
 value	string	
 ds	datetime	

Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/inputddl3.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/inputddl3.q.out?rev=696736&r1=696735&r2=696736&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/inputddl3.q.out (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/inputddl3.q.out Thu Sep 18 10:37:59 2008
@@ -1,2 +1,19 @@
+ABSTRACT SYNTAX TREE:	
+  (TOK_CREATETABLE INPUTDDL3 (TOK_TABCOLLIST (TOK_TABCOL key TOK_INT) (TOK_TABCOL value TOK_STRING)) (TOK_TABLEROWFORMAT (TOK_TABLEROWFORMATFIELD '\t')))	
+	
+STAGE DEPENDENCIES:	
+  Stage-0 is a root stage	
+	
+STAGE PLANS:	
+  Stage: Stage-0	
+      Create Table Operator:	
+        Create Table	
+          isExternal:	
+          name: INPUTDDL3	
+          field delimiter: 		
+          isCompressed:	
+          # buckets: -1	
+          columns: key int, value string	
+	
 key	int	
 value	string	

Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/join1.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/join1.q.out?rev=696736&r1=696735&r2=696736&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/join1.q.out (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/join1.q.out Thu Sep 18 10:37:59 2008
@@ -1,3 +1,68 @@
+ABSTRACT SYNTAX TREE:	
+  (TOK_QUERY (TOK_FROM (TOK_JOIN (TOK_TABREF src src1) (TOK_TABREF src src2) (= (TOK_COLREF src1 key) (TOK_COLREF src2 key)))) (TOK_INSERT (TOK_DESTINATION (TOK_TAB dest1)) (TOK_SELECT (TOK_SELEXPR (TOK_COLREF src1 key)) (TOK_SELEXPR (TOK_COLREF src2 value)))))	
+	
+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:	
+               Inner Join 0 to 1	
+          Select Operator	
+            expressions:	
+                  expr: 0	
+                  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:	
+        src2 	
+            Reduce Output Operator	
+              tag: 1	
+              key expressions:	
+                    expr: key	
+                    type: class java.lang.String	
+              value expressions:	
+                    expr: key	
+                    type: class java.lang.String	
+                    expr: value	
+                    type: class java.lang.String	
+              # partition fields: 1	
+        src1 	
+            Reduce Output Operator	
+              tag: 0	
+              key expressions:	
+                    expr: key	
+                    type: class java.lang.String	
+              value expressions:	
+                    expr: key	
+                    type: class java.lang.String	
+                    expr: value	
+                    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:	
+	
 0	val_0	
 0	val_0	
 0	val_0	

Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/join2.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/join2.q.out?rev=696736&r1=696735&r2=696736&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/join2.q.out (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/join2.q.out Thu Sep 18 10:37:59 2008
@@ -1,3 +1,113 @@
+ABSTRACT SYNTAX TREE:	
+  (TOK_QUERY (TOK_FROM (TOK_JOIN (TOK_JOIN (TOK_TABREF src src1) (TOK_TABREF src src2) (= (TOK_COLREF src1 key) (TOK_COLREF src2 key))) (TOK_TABREF src src3) (= (+ (TOK_COLREF src1 key) (TOK_COLREF src2 key)) (TOK_COLREF src3 key)))) (TOK_INSERT (TOK_DESTINATION (TOK_TAB dest1)) (TOK_SELECT (TOK_SELEXPR (TOK_COLREF src1 key)) (TOK_SELEXPR (TOK_COLREF src3 value)))))	
+	
+STAGE DEPENDENCIES:	
+  Stage-1 is a root stage	
+  Stage-2 depends on stages: Stage-1	
+  Stage-0 depends on stages: Stage-2, Stage-1	
+  Stage-0 depends on stages: Stage-2, 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:	
+               Inner Join 0 to 1	
+          File Output Operator	
+            table:	
+                input format: org.apache.hadoop.mapred.TextInputFormat	
+                output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat	
+      Alias -> Map Operator Tree:	
+        src2 	
+            Reduce Output Operator	
+              tag: 1	
+              key expressions:	
+                    expr: key	
+                    type: class java.lang.String	
+              value expressions:	
+                    expr: key	
+                    type: class java.lang.String	
+                    expr: value	
+                    type: class java.lang.String	
+              # partition fields: 1	
+        src1 	
+            Reduce Output Operator	
+              tag: 0	
+              key expressions:	
+                    expr: key	
+                    type: class java.lang.String	
+              value expressions:	
+                    expr: key	
+                    type: class java.lang.String	
+                    expr: value	
+                    type: class java.lang.String	
+              # partition fields: 1	
+	
+  Stage: Stage-2	
+    Map Reduce	
+      Reduce Operator Tree:	
+        Join Operator	
+          condition expressions:	
+            0 {VALUE.0} {VALUE.1} {VALUE.2} {VALUE.3}	
+            1 {VALUE.0} {VALUE.1}	
+          condition map:	
+               Inner Join 0 to 1	
+          Select Operator	
+            expressions:	
+                  expr: 2	
+                  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:	
+        src3 	
+            Reduce Output Operator	
+              tag: 1	
+              key expressions:	
+                    expr: UDFToDouble(key)	
+                    type: class java.lang.Double	
+              value expressions:	
+                    expr: key	
+                    type: class java.lang.String	
+                    expr: value	
+                    type: class java.lang.String	
+              # partition fields: 1	
+        $INTNAME 	
+          Reduce Output Operator	
+            tag: 0	
+            key expressions:	
+                  expr: (UDFToDouble(0) + UDFToDouble(2))	
+                  type: class java.lang.Double	
+            value expressions:	
+                  expr: 2	
+                  type: class java.lang.String	
+                  expr: 3	
+                  type: class java.lang.String	
+                  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:	
+	
 0	val_0	
 0	val_0	
 0	val_0	

Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/join3.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/join3.q.out?rev=696736&r1=696735&r2=696736&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/join3.q.out (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/join3.q.out Thu Sep 18 10:37:59 2008
@@ -1,3 +1,82 @@
+ABSTRACT SYNTAX TREE:	
+  (TOK_QUERY (TOK_FROM (TOK_JOIN (TOK_JOIN (TOK_TABREF src src1) (TOK_TABREF src src2) (= (TOK_COLREF src1 key) (TOK_COLREF src2 key))) (TOK_TABREF src src3) (= (TOK_COLREF src1 key) (TOK_COLREF src3 key)))) (TOK_INSERT (TOK_DESTINATION (TOK_TAB dest1)) (TOK_SELECT (TOK_SELEXPR (TOK_COLREF src1 key)) (TOK_SELEXPR (TOK_COLREF src3 value)))))	
+	
+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:	
+               Inner Join 0 to 1	
+               Inner Join 0 to 1	
+          Select Operator	
+            expressions:	
+                  expr: 0	
+                  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:	
+        src2 	
+            Reduce Output Operator	
+              tag: 1	
+              key expressions:	
+                    expr: key	
+                    type: class java.lang.String	
+              value expressions:	
+                    expr: key	
+                    type: class java.lang.String	
+                    expr: value	
+                    type: class java.lang.String	
+              # partition fields: 1	
+        src3 	
+            Reduce Output Operator	
+              tag: 2	
+              key expressions:	
+                    expr: key	
+                    type: class java.lang.String	
+              value expressions:	
+                    expr: key	
+                    type: class java.lang.String	
+                    expr: value	
+                    type: class java.lang.String	
+              # partition fields: 1	
+        src1 	
+            Reduce Output Operator	
+              tag: 0	
+              key expressions:	
+                    expr: key	
+                    type: class java.lang.String	
+              value expressions:	
+                    expr: key	
+                    type: class java.lang.String	
+                    expr: value	
+                    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:	
+	
 0	val_0	
 0	val_0	
 0	val_0	

Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/join4.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/join4.q.out?rev=696736&r1=696735&r2=696736&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/join4.q.out (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/join4.q.out Thu Sep 18 10:37:59 2008
@@ -1,3 +1,102 @@
+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)))))	
+	
+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	
+            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	



Mime
View raw message