hadoop-common-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From dhr...@apache.org
Subject svn commit: r712905 [12/38] - in /hadoop/core/trunk: ./ src/contrib/hive/ src/contrib/hive/cli/src/java/org/apache/hadoop/hive/cli/ src/contrib/hive/common/src/java/org/apache/hadoop/hive/conf/ src/contrib/hive/conf/ src/contrib/hive/data/files/ src/co...
Date Tue, 11 Nov 2008 01:50:18 GMT
Added: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/notable_alias2.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/notable_alias2.q.out?rev=712905&view=auto
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/notable_alias2.q.out (added)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/notable_alias2.q.out Mon Nov 10 17:50:06 2008
@@ -0,0 +1,152 @@
+ABSTRACT SYNTAX TREE:
+  (TOK_QUERY (TOK_FROM (TOK_TABREF src)) (TOK_INSERT (TOK_DESTINATION (TOK_TAB dest1)) (TOK_SELECT (TOK_SELEXPR '1234') (TOK_SELEXPR (TOK_COLREF src key)) (TOK_SELEXPR (TOK_FUNCTION count 1))) (TOK_WHERE (< (TOK_COLREF key) 100)) (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
+      Alias -> Map Operator Tree:
+        src 
+            Select Operator
+              expressions:
+                    expr: key
+                    type: string
+              Filter Operator
+                predicate:
+                    expr: (0 < 100)
+                    type: boolean
+                Reduce Output Operator
+                  key expressions:
+                        expr: 0
+                        type: string
+                  Map-reduce partition columns:
+                        expr: rand()
+                        type: double
+                  tag: -1
+                  value expressions:
+                        expr: 1
+                        type: int
+      Reduce Operator Tree:
+        Group By Operator
+        
+              expr: count(VALUE.0)
+          keys:
+                expr: KEY.0
+                type: string
+          mode: partial1
+          File Output Operator
+            table:
+                input format: org.apache.hadoop.mapred.SequenceFileInputFormat
+                output format: org.apache.hadoop.mapred.SequenceFileOutputFormat
+                name: binary_table
+
+  Stage: Stage-2
+    Map Reduce
+      Alias -> Map Operator Tree:
+        /tmp/hive-njain/140889204/772631826.10001 
+          Reduce Output Operator
+            key expressions:
+                  expr: 0
+                  type: string
+            Map-reduce partition columns:
+                  expr: 0
+                  type: string
+            tag: -1
+            value expressions:
+                  expr: 1
+                  type: bigint
+      Reduce Operator Tree:
+        Group By Operator
+        
+              expr: count(VALUE.0)
+          keys:
+                expr: KEY.0
+                type: string
+          mode: unknown
+          Select Operator
+            expressions:
+                  expr: '1234'
+                  type: string
+                  expr: 0
+                  type: string
+                  expr: 1
+                  type: bigint
+            File Output Operator
+              table:
+                  input format: org.apache.hadoop.mapred.TextInputFormat
+                  output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+                  serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+                  name: dest1
+
+  Stage: Stage-0
+    Move Operator
+      tables:
+            replace:
+            table:
+                input format: org.apache.hadoop.mapred.TextInputFormat
+                output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+                serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+                name: dest1
+
+
+1234	0	3
+1234	10	1
+1234	11	1
+1234	12	2
+1234	15	2
+1234	17	1
+1234	18	2
+1234	19	1
+1234	2	1
+1234	20	1
+1234	24	2
+1234	26	2
+1234	27	1
+1234	28	1
+1234	30	1
+1234	33	1
+1234	34	1
+1234	35	3
+1234	37	2
+1234	4	1
+1234	41	1
+1234	42	2
+1234	43	1
+1234	44	1
+1234	47	1
+1234	5	3
+1234	51	2
+1234	53	1
+1234	54	1
+1234	57	1
+1234	58	2
+1234	64	1
+1234	65	1
+1234	66	1
+1234	67	2
+1234	69	1
+1234	70	3
+1234	72	2
+1234	74	1
+1234	76	2
+1234	77	1
+1234	78	1
+1234	8	1
+1234	80	1
+1234	82	1
+1234	83	2
+1234	84	2
+1234	85	1
+1234	86	1
+1234	87	1
+1234	9	1
+1234	90	3
+1234	92	1
+1234	95	2
+1234	96	1
+1234	97	2
+1234	98	2

Added: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/quote1.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/quote1.q.out?rev=712905&view=auto
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/quote1.q.out (added)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/quote1.q.out Mon Nov 10 17:50:06 2008
@@ -0,0 +1,179 @@
+ABSTRACT SYNTAX TREE:
+  (TOK_QUERY (TOK_FROM (TOK_TABREF src)) (TOK_INSERT (TOK_DESTINATION (TOK_TAB dest1 (TOK_PARTSPEC (TOK_PARTVAL `table` '2008-04-08')))) (TOK_SELECT (TOK_SELEXPR (TOK_COLREF src key) `partition`) (TOK_SELEXPR (TOK_COLREF src value) `from`)) (TOK_WHERE (and (>= (TOK_COLREF src key) 200) (< (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 >= 200) and (key < 300))
+                  type: boolean
+              Select Operator
+                expressions:
+                      expr: key
+                      type: string
+                      expr: value
+                      type: string
+                File Output Operator
+                  table:
+                      input format: org.apache.hadoop.mapred.TextInputFormat
+                      output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+                      serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+                      name: dest1
+
+  Stage: Stage-0
+    Move Operator
+      tables:
+            partition:
+              table 2008-04-08
+            replace:
+            table:
+                input format: org.apache.hadoop.mapred.TextInputFormat
+                output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+                serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+                name: dest1
+
+
+ABSTRACT SYNTAX TREE:
+  (TOK_QUERY (TOK_FROM (TOK_TABREF dest1 `table`)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_COLREF `table` `location`)) (TOK_SELEXPR (TOK_COLREF `table` `type`)) (TOK_SELEXPR (TOK_COLREF `table` `table`))) (TOK_WHERE (= (TOK_COLREF `table` `table`) '2008-04-08'))))
+
+STAGE DEPENDENCIES:
+  Stage-1 is a root stage
+  Stage-0 is a root stage
+
+STAGE PLANS:
+  Stage: Stage-1
+    Map Reduce
+      Alias -> Map Operator Tree:
+        table 
+            Filter Operator
+              predicate:
+                  expr: (table = '2008-04-08')
+                  type: boolean
+              Select Operator
+                expressions:
+                      expr: location
+                      type: string
+                      expr: type
+                      type: string
+                      expr: table
+                      type: string
+                File Output Operator
+                  table:
+                      input format: org.apache.hadoop.mapred.TextInputFormat
+                      output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+
+  Stage: Stage-0
+    Fetch Operator
+      limit: -1
+
+
+238	val_238	2008-04-08
+255	val_255	2008-04-08
+278	val_278	2008-04-08
+265	val_265	2008-04-08
+273	val_273	2008-04-08
+224	val_224	2008-04-08
+213	val_213	2008-04-08
+281	val_281	2008-04-08
+277	val_277	2008-04-08
+209	val_209	2008-04-08
+252	val_252	2008-04-08
+292	val_292	2008-04-08
+219	val_219	2008-04-08
+287	val_287	2008-04-08
+237	val_237	2008-04-08
+207	val_207	2008-04-08
+208	val_208	2008-04-08
+247	val_247	2008-04-08
+266	val_266	2008-04-08
+203	val_203	2008-04-08
+205	val_205	2008-04-08
+221	val_221	2008-04-08
+280	val_280	2008-04-08
+277	val_277	2008-04-08
+208	val_208	2008-04-08
+286	val_286	2008-04-08
+239	val_239	2008-04-08
+213	val_213	2008-04-08
+216	val_216	2008-04-08
+278	val_278	2008-04-08
+289	val_289	2008-04-08
+221	val_221	2008-04-08
+275	val_275	2008-04-08
+241	val_241	2008-04-08
+284	val_284	2008-04-08
+230	val_230	2008-04-08
+260	val_260	2008-04-08
+272	val_272	2008-04-08
+217	val_217	2008-04-08
+230	val_230	2008-04-08
+208	val_208	2008-04-08
+298	val_298	2008-04-08
+230	val_230	2008-04-08
+205	val_205	2008-04-08
+288	val_288	2008-04-08
+282	val_282	2008-04-08
+282	val_282	2008-04-08
+238	val_238	2008-04-08
+277	val_277	2008-04-08
+273	val_273	2008-04-08
+224	val_224	2008-04-08
+242	val_242	2008-04-08
+272	val_272	2008-04-08
+242	val_242	2008-04-08
+226	val_226	2008-04-08
+229	val_229	2008-04-08
+233	val_233	2008-04-08
+223	val_223	2008-04-08
+218	val_218	2008-04-08
+228	val_228	2008-04-08
+209	val_209	2008-04-08
+230	val_230	2008-04-08
+296	val_296	2008-04-08
+216	val_216	2008-04-08
+274	val_274	2008-04-08
+219	val_219	2008-04-08
+239	val_239	2008-04-08
+223	val_223	2008-04-08
+256	val_256	2008-04-08
+263	val_263	2008-04-08
+288	val_288	2008-04-08
+244	val_244	2008-04-08
+202	val_202	2008-04-08
+229	val_229	2008-04-08
+280	val_280	2008-04-08
+283	val_283	2008-04-08
+235	val_235	2008-04-08
+257	val_257	2008-04-08
+258	val_258	2008-04-08
+203	val_203	2008-04-08
+262	val_262	2008-04-08
+201	val_201	2008-04-08
+217	val_217	2008-04-08
+298	val_298	2008-04-08
+291	val_291	2008-04-08
+255	val_255	2008-04-08
+200	val_200	2008-04-08
+237	val_237	2008-04-08
+248	val_248	2008-04-08
+277	val_277	2008-04-08
+230	val_230	2008-04-08
+207	val_207	2008-04-08
+249	val_249	2008-04-08
+265	val_265	2008-04-08
+214	val_214	2008-04-08
+233	val_233	2008-04-08
+256	val_256	2008-04-08
+298	val_298	2008-04-08
+285	val_285	2008-04-08
+273	val_273	2008-04-08
+281	val_281	2008-04-08
+222	val_222	2008-04-08
+200	val_200	2008-04-08

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=712905&r1=712904&r2=712905&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 Mon Nov 10 17:50:06 2008
@@ -1,5 +1,5 @@
 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')))))
+  (TOK_QUERY (TOK_FROM (TOK_TABREF srcpart (TOK_TABLESAMPLE 1 1 (TOK_FUNCTION rand)) 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
@@ -12,36 +12,39 @@
         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
-                  directory: /tmp/hive-njain/1799446246/1449752317.10000.insclause-0
-                  table:
-                      input format: org.apache.hadoop.mapred.TextInputFormat
-                      output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
-                      properties:
-                        name dest1
-                        serialization.ddl struct dest1 { i32 key, string value, string dt, string hr}
-                        serialization.format 1
-                        columns key,value,dt,hr
-                        SORTBUCKETCOLSPREFIX TRUE
-                        bucket_count -1
-                        serialization.lib org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
-                        file.inputformat org.apache.hadoop.mapred.TextInputFormat
-                        file.outputformat org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
-                        location file:/home/njain/workspace/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/dest1
-                      serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
-                      name: dest1
+                  expr: (((default_sample_hashfn(rand()) & 2147483647) % 1) = 0)
+                  type: boolean
+              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
+                    directory: /tmp/hive-njain/804625404/371878036.10000.insclause-0
+                    table:
+                        input format: org.apache.hadoop.mapred.TextInputFormat
+                        output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+                        properties:
+                          name dest1
+                          serialization.ddl struct dest1 { i32 key, string value, string dt, string hr}
+                          serialization.format 1
+                          columns key,value,dt,hr
+                          bucket_count -1
+                          serialization.lib org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+                          file.inputformat org.apache.hadoop.mapred.TextInputFormat
+                          file.outputformat org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+                          location file:/home/njain/workspace/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/dest1
+                        serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+                        name: dest1
       Needs Tagging:
       Path -> Alias:
         file:/home/njain/workspace/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11 
@@ -72,7 +75,7 @@
     Move Operator
       tables:
             replace:
-            source: /tmp/hive-njain/1799446246/1449752317.10000.insclause-0
+            source: /tmp/hive-njain/804625404/371878036.10000.insclause-0
             table:
                 input format: org.apache.hadoop.mapred.TextInputFormat
                 output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
@@ -81,7 +84,6 @@
                   serialization.ddl struct dest1 { i32 key, string value, string dt, string hr}
                   serialization.format 1
                   columns key,value,dt,hr
-                  SORTBUCKETCOLSPREFIX TRUE
                   bucket_count -1
                   serialization.lib org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
                   file.inputformat org.apache.hadoop.mapred.TextInputFormat

Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/sample2.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/sample2.q.out?rev=712905&r1=712904&r2=712905&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/sample2.q.out (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/sample2.q.out Mon Nov 10 17:50:06 2008
@@ -17,7 +17,7 @@
                     expr: value
                     type: string
               File Output Operator
-                directory: /tmp/hive-njain/1178661057/1120939755.10000.insclause-0
+                directory: /tmp/hive-njain/74225087/82847953.10000.insclause-0
                 table:
                     input format: org.apache.hadoop.mapred.TextInputFormat
                     output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
@@ -26,7 +26,6 @@
                       serialization.ddl struct dest1 { i32 key, string value}
                       serialization.format 1
                       columns key,value
-                      SORTBUCKETCOLSPREFIX TRUE
                       bucket_count -1
                       serialization.lib org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
                       file.inputformat org.apache.hadoop.mapred.TextInputFormat
@@ -45,9 +44,10 @@
               output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
               properties:
                 name srcbucket
+                bucket_field_name key
                 serialization.ddl struct srcbucket { string key, string value}
-                serialization.format 1
                 columns key,value
+                serialization.format 1
                 bucket_count 2
                 serialization.lib org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
                 file.inputformat org.apache.hadoop.mapred.TextInputFormat
@@ -60,7 +60,7 @@
     Move Operator
       tables:
             replace:
-            source: /tmp/hive-njain/1178661057/1120939755.10000.insclause-0
+            source: /tmp/hive-njain/74225087/82847953.10000.insclause-0
             table:
                 input format: org.apache.hadoop.mapred.TextInputFormat
                 output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
@@ -69,7 +69,6 @@
                   serialization.ddl struct dest1 { i32 key, string value}
                   serialization.format 1
                   columns key,value
-                  SORTBUCKETCOLSPREFIX TRUE
                   bucket_count -1
                   serialization.lib org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
                   file.inputformat org.apache.hadoop.mapred.TextInputFormat

Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/sample4.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/sample4.q.out?rev=712905&r1=712904&r2=712905&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/sample4.q.out (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/sample4.q.out Mon Nov 10 17:50:06 2008
@@ -1,5 +1,5 @@
 ABSTRACT SYNTAX TREE:
-  (TOK_QUERY (TOK_FROM (TOK_TABREF srcbucket (TOK_TABLESAMPLE 1 2 key) s)) (TOK_INSERT (TOK_DESTINATION (TOK_TAB dest1)) (TOK_SELECT (TOK_SELEXPR (TOK_ALLCOLREF s)))))
+  (TOK_QUERY (TOK_FROM (TOK_TABREF srcbucket (TOK_TABLESAMPLE 1 2 (TOK_COLREF key)) s)) (TOK_INSERT (TOK_DESTINATION (TOK_TAB dest1)) (TOK_SELECT (TOK_SELEXPR (TOK_ALLCOLREF s)))))
 
 STAGE DEPENDENCIES:
   Stage-1 is a root stage
@@ -10,48 +10,44 @@
     Map Reduce
       Alias -> Map Operator Tree:
         s 
-            Filter Operator
-              predicate:
-                  expr: (((default_sample_hashfn(key) & 2147483647) % 2) = 0)
-                  type: Boolean
-              Select Operator
-                expressions:
-                      expr: key
-                      type: string
-                      expr: value
-                      type: string
-                File Output Operator
-                  directory: /tmp/hive-njain/594156852/317367185.10000.insclause-0
-                  table:
-                      input format: org.apache.hadoop.mapred.TextInputFormat
-                      output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
-                      properties:
-                        name dest1
-                        serialization.ddl struct dest1 { i32 key, string value}
-                        serialization.format 1
-                        columns key,value
-                        SORTBUCKETCOLSPREFIX TRUE
-                        bucket_count -1
-                        serialization.lib org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
-                        file.inputformat org.apache.hadoop.mapred.TextInputFormat
-                        file.outputformat org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
-                        location file:/home/njain/workspace/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/dest1
-                      serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
-                      name: dest1
+            Select Operator
+              expressions:
+                    expr: key
+                    type: string
+                    expr: value
+                    type: string
+              File Output Operator
+                directory: /tmp/hive-njain/402231827/160820937.10000.insclause-0
+                table:
+                    input format: org.apache.hadoop.mapred.TextInputFormat
+                    output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+                    properties:
+                      name dest1
+                      serialization.ddl struct dest1 { i32 key, string value}
+                      serialization.format 1
+                      columns key,value
+                      bucket_count -1
+                      serialization.lib org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+                      file.inputformat org.apache.hadoop.mapred.TextInputFormat
+                      file.outputformat org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+                      location file:/home/njain/workspace/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/dest1
+                    serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+                    name: dest1
       Needs Tagging:
       Path -> Alias:
-        file:/home/njain/workspace/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/srcbucket 
+        file:/home/njain/workspace/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/srcbucket/kv1.txt 
       Path -> Partition:
-        file:/home/njain/workspace/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/srcbucket 
+        file:/home/njain/workspace/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/srcbucket/kv1.txt 
           Partition
           
               input format: org.apache.hadoop.mapred.TextInputFormat
               output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
               properties:
                 name srcbucket
+                bucket_field_name key
                 serialization.ddl struct srcbucket { string key, string value}
-                serialization.format 1
                 columns key,value
+                serialization.format 1
                 bucket_count 2
                 serialization.lib org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
                 file.inputformat org.apache.hadoop.mapred.TextInputFormat
@@ -64,7 +60,7 @@
     Move Operator
       tables:
             replace:
-            source: /tmp/hive-njain/594156852/317367185.10000.insclause-0
+            source: /tmp/hive-njain/402231827/160820937.10000.insclause-0
             table:
                 input format: org.apache.hadoop.mapred.TextInputFormat
                 output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
@@ -73,7 +69,6 @@
                   serialization.ddl struct dest1 { i32 key, string value}
                   serialization.format 1
                   columns key,value
-                  SORTBUCKETCOLSPREFIX TRUE
                   bucket_count -1
                   serialization.lib org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
                   file.inputformat org.apache.hadoop.mapred.TextInputFormat
@@ -83,28 +78,51 @@
                 name: dest1
 
 
+238	val_238
 86	val_86
+311	val_311
+27	val_27
 165	val_165
+409	val_409
 255	val_255
+278	val_278
+98	val_98
 484	val_484
+265	val_265
+193	val_193
+401	val_401
 150	val_150
 273	val_273
 224	val_224
 369	val_369
 66	val_66
+128	val_128
 213	val_213
+146	val_146
 406	val_406
+429	val_429
 374	val_374
 152	val_152
+469	val_469
 145	val_145
 495	val_495
 37	val_37
 327	val_327
+281	val_281
 277	val_277
+209	val_209
 15	val_15
 82	val_82
+403	val_403
+166	val_166
 417	val_417
+430	val_430
+252	val_252
+292	val_292
 219	val_219
+287	val_287
+153	val_153
+193	val_193
 338	val_338
 446	val_446
 459	val_459
@@ -113,105 +131,202 @@
 482	val_482
 174	val_174
 413	val_413
+494	val_494
+207	val_207
+199	val_199
 466	val_466
 208	val_208
 174	val_174
+399	val_399
 396	val_396
+247	val_247
 417	val_417
+489	val_489
+162	val_162
+377	val_377
+397	val_397
 309	val_309
 365	val_365
 266	val_266
 439	val_439
+342	val_342
 367	val_367
 325	val_325
 167	val_167
+195	val_195
 475	val_475
 17	val_17
+113	val_113
+155	val_155
+203	val_203
+339	val_339
 0	val_0
 455	val_455
+128	val_128
+311	val_311
 316	val_316
 57	val_57
+302	val_302
+205	val_205
 149	val_149
+438	val_438
 345	val_345
 129	val_129
 170	val_170
 20	val_20
+489	val_489
+157	val_157
 378	val_378
+221	val_221
+92	val_92
+111	val_111
+47	val_47
+72	val_72
 4	val_4
 280	val_280
 35	val_35
+427	val_427
 277	val_277
 208	val_208
 356	val_356
+399	val_399
 169	val_169
+382	val_382
+498	val_498
 125	val_125
+386	val_386
 437	val_437
+469	val_469
 192	val_192
 286	val_286
 187	val_187
 176	val_176
+54	val_54
 459	val_459
 51	val_51
 138	val_138
 103	val_103
 239	val_239
 213	val_213
+216	val_216
+430	val_430
+278	val_278
 176	val_176
+289	val_289
+221	val_221
+65	val_65
 318	val_318
 332	val_332
+311	val_311
 275	val_275
+137	val_137
+241	val_241
+83	val_83
+333	val_333
+180	val_180
 284	val_284
+12	val_12
+230	val_230
 181	val_181
+67	val_67
 260	val_260
 404	val_404
+384	val_384
+489	val_489
+353	val_353
+373	val_373
+272	val_272
 138	val_138
 217	val_217
 84	val_84
+348	val_348
 466	val_466
+58	val_58
 8	val_8
 411	val_411
+230	val_230
 208	val_208
+348	val_348
 24	val_24
+463	val_463
 431	val_431
+179	val_179
 172	val_172
 42	val_42
 129	val_129
 158	val_158
+119	val_119
+496	val_496
 0	val_0
+322	val_322
+197	val_197
 468	val_468
+393	val_393
+454	val_454
+100	val_100
+298	val_298
+199	val_199
+191	val_191
+418	val_418
+96	val_96
 26	val_26
 165	val_165
 327	val_327
+230	val_230
+205	val_205
+120	val_120
+131	val_131
 51	val_51
 404	val_404
+43	val_43
+436	val_436
 156	val_156
+469	val_469
 468	val_468
+308	val_308
 95	val_95
 196	val_196
 288	val_288
+481	val_481
 457	val_457
+98	val_98
 282	val_282
+197	val_197
 187	val_187
 318	val_318
 318	val_318
+409	val_409
+470	val_470
+137	val_137
 369	val_369
 316	val_316
 169	val_169
 413	val_413
+85	val_85
 77	val_77
 0	val_0
+490	val_490
+87	val_87
+364	val_364
+179	val_179
 118	val_118
 134	val_134
+395	val_395
 282	val_282
 138	val_138
+238	val_238
 419	val_419
 15	val_15
 118	val_118
+72	val_72
+90	val_90
 307	val_307
 19	val_19
 435	val_435
+10	val_10
 277	val_277
 273	val_273
+306	val_306
 224	val_224
 309	val_309
 389	val_389
@@ -219,365 +334,247 @@
 242	val_242
 369	val_369
 392	val_392
+272	val_272
+331	val_331
+401	val_401
 242	val_242
+452	val_452
+177	val_177
 226	val_226
+5	val_5
 497	val_497
 402	val_402
 396	val_396
+317	val_317
+395	val_395
+58	val_58
 35	val_35
 336	val_336
 95	val_95
 11	val_11
+168	val_168
+34	val_34
+229	val_229
 233	val_233
 143	val_143
+472	val_472
+322	val_322
+498	val_498
+160	val_160
+195	val_195
 42	val_42
 321	val_321
+430	val_430
+119	val_119
+489	val_489
+458	val_458
+78	val_78
+76	val_76
+41	val_41
+223	val_223
+492	val_492
 149	val_149
+449	val_449
+218	val_218
 228	val_228
 138	val_138
 453	val_453
+30	val_30
+209	val_209
 64	val_64
 468	val_468
+76	val_76
+74	val_74
+342	val_342
+69	val_69
+230	val_230
 33	val_33
+368	val_368
 103	val_103
+296	val_296
+113	val_113
+216	val_216
 367	val_367
+344	val_344
 167	val_167
+274	val_274
 219	val_219
 239	val_239
+485	val_485
 116	val_116
+223	val_223
+256	val_256
+263	val_263
+70	val_70
+487	val_487
 480	val_480
+401	val_401
 288	val_288
+191	val_191
+5	val_5
 244	val_244
+438	val_438
+128	val_128
+467	val_467
+432	val_432
 202	val_202
 316	val_316
+229	val_229
+469	val_469
+463	val_463
 280	val_280
 2	val_2
 35	val_35
+283	val_283
+331	val_331
 235	val_235
 80	val_80
 44	val_44
+193	val_193
 321	val_321
+335	val_335
+104	val_104
 466	val_466
+366	val_366
+175	val_175
+403	val_403
+483	val_483
 53	val_53
 105	val_105
 257	val_257
 406	val_406
+409	val_409
 190	val_190
 406	val_406
+401	val_401
 114	val_114
+258	val_258
+90	val_90
+203	val_203
 262	val_262
+348	val_348
 424	val_424
+12	val_12
 396	val_396
+201	val_201
 217	val_217
+164	val_164
 431	val_431
+454	val_454
+478	val_478
+298	val_298
 125	val_125
 431	val_431
+164	val_164
 424	val_424
 187	val_187
+382	val_382
+5	val_5
+70	val_70
+397	val_397
 480	val_480
 291	val_291
 24	val_24
+351	val_351
 255	val_255
+104	val_104
+70	val_70
 163	val_163
+438	val_438
+119	val_119
+414	val_414
 200	val_200
 491	val_491
 237	val_237
 439	val_439
+360	val_360
 248	val_248
 479	val_479
 305	val_305
 417	val_417
+199	val_199
 444	val_444
+120	val_120
+429	val_429
 169	val_169
+443	val_443
 323	val_323
 325	val_325
 277	val_277
+230	val_230
+478	val_478
 178	val_178
 468	val_468
 310	val_310
+317	val_317
+333	val_333
 493	val_493
 460	val_460
+207	val_207
+249	val_249
+265	val_265
 480	val_480
+83	val_83
 136	val_136
+353	val_353
 172	val_172
+214	val_214
 462	val_462
 233	val_233
 406	val_406
+133	val_133
+175	val_175
 189	val_189
+454	val_454
+375	val_375
+401	val_401
+421	val_421
+407	val_407
+384	val_384
+256	val_256
 26	val_26
 134	val_134
+67	val_67
+384	val_384
+379	val_379
+18	val_18
 462	val_462
+492	val_492
+100	val_100
+298	val_298
+9	val_9
 341	val_341
+498	val_498
+146	val_146
+458	val_458
+362	val_362
+186	val_186
+285	val_285
+348	val_348
 167	val_167
+18	val_18
 273	val_273
 183	val_183
+281	val_281
+344	val_344
 97	val_97
+469	val_469
+315	val_315
 84	val_84
 28	val_28
 37	val_37
 448	val_448
 152	val_152
+348	val_348
 307	val_307
 194	val_194
+414	val_414
 477	val_477
 222	val_222
+126	val_126
+90	val_90
 169	val_169
+403	val_403
 400	val_400
 200	val_200
 97	val_97
-291	val_292
-62	val_63
-271	val_272
-217	val_218
-167	val_168
-468	val_469
-413	val_414
-455	val_456
-231	val_232
-448	val_449
-246	val_247
-440	val_441
-31	val_32
-147	val_148
-428	val_429
-273	val_274
-356	val_357
-217	val_218
-33	val_34
-35	val_36
-402	val_403
-226	val_227
-15	val_16
-110	val_111
-343	val_344
-275	val_276
-0	val_1
-293	val_294
-240	val_241
-286	val_287
-408	val_409
-477	val_478
-455	val_456
-99	val_100
-482	val_483
-367	val_368
-59	val_60
-48	val_49
-424	val_425
-226	val_227
-488	val_489
-349	val_350
-11	val_12
-161	val_162
-123	val_124
-402	val_403
-468	val_469
-314	val_315
-497	val_498
-224	val_225
-4	val_5
-277	val_278
-206	val_207
-101	val_102
-114	val_115
-239	val_240
-389	val_390
-114	val_115
-235	val_236
-390	val_391
-165	val_166
-264	val_265
-196	val_197
-20	val_21
-11	val_12
-129	val_130
-257	val_258
-71	val_72
-453	val_454
-82	val_83
-86	val_87
-323	val_324
-222	val_223
-42	val_43
-411	val_412
-338	val_339
-68	val_69
-185	val_186
-147	val_148
-473	val_474
-376	val_377
-347	val_348
-213	val_214
-291	val_292
-426	val_427
-132	val_133
-446	val_447
-121	val_122
-284	val_285
-129	val_130
-246	val_247
-491	val_492
-369	val_370
-262	val_263
-390	val_391
-352	val_353
-226	val_227
-349	val_350
-480	val_481
-497	val_498
-480	val_481
-475	val_476
-183	val_184
-15	val_16
-318	val_319
-149	val_150
-392	val_393
-77	val_78
-275	val_276
-174	val_175
-114	val_115
-161	val_162
-75	val_76
-264	val_265
-48	val_49
-336	val_337
-390	val_391
-484	val_485
-189	val_190
-305	val_306
-367	val_368
-6	val_7
-260	val_261
-2	val_3
-349	val_350
-170	val_171
-51	val_52
-363	val_364
-118	val_119
-310	val_311
-19	val_20
-80	val_81
-121	val_122
-239	val_240
-358	val_359
-11	val_12
-143	val_144
-341	val_342
-105	val_106
-42	val_43
-363	val_364
-347	val_348
-77	val_78
-293	val_294
-20	val_21
-40	val_41
-8	val_9
-310	val_311
-206	val_207
-381	val_382
-404	val_405
-206	val_207
-385	val_386
-259	val_260
-226	val_227
-262	val_263
-303	val_304
-260	val_261
-404	val_405
-116	val_117
-42	val_43
-303	val_304
-93	val_94
-277	val_278
-406	val_407
-451	val_452
-53	val_54
-132	val_133
-192	val_193
-356	val_357
-352	val_353
-330	val_331
-138	val_139
-257	val_258
-174	val_175
-295	val_296
-105	val_106
-204	val_205
-439	val_440
-374	val_375
-457	val_458
-93	val_94
-196	val_197
-437	val_438
-398	val_399
-35	val_36
-334	val_335
-435	val_436
-60	val_61
-442	val_443
-404	val_405
-446	val_447
-0	val_1
-268	val_269
-491	val_492
-392	val_393
-295	val_296
-93	val_94
-439	val_440
-156	val_157
-341	val_342
-118	val_119
-172	val_173
-244	val_245
-6	val_7
-284	val_285
-136	val_137
-349	val_350
-462	val_463
-123	val_124
-408	val_409
-152	val_153
-310	val_311
-486	val_487
-152	val_153
-378	val_379
-97	val_98
-495	val_496
-385	val_386
-40	val_41
-389	val_390
-259	val_260
-97	val_98
-125	val_126
-178	val_179
-415	val_416
-156	val_157
-228	val_229
-363	val_364
-22	val_23
-248	val_249
-459	val_460
-402	val_403
-62	val_63
-244	val_245
-46	val_47
-341	val_342
-215	val_216
-134	val_135
-196	val_197
-431	val_432
-82	val_83
-440	val_441
-309	val_310
-161	val_162
-468	val_469
-152	val_153
-138	val_139
-161	val_162
-91	val_92
-118	val_119
-178	val_179
-457	val_458
-242	val_243
-35	val_36
-244	val_245

Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/sample5.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/sample5.q.out?rev=712905&r1=712904&r2=712905&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/sample5.q.out (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/sample5.q.out Mon Nov 10 17:50:06 2008
@@ -1,5 +1,5 @@
 ABSTRACT SYNTAX TREE:
-  (TOK_QUERY (TOK_FROM (TOK_TABREF srcbucket (TOK_TABLESAMPLE 1 5 key) s)) (TOK_INSERT (TOK_DESTINATION (TOK_TAB dest1)) (TOK_SELECT (TOK_SELEXPR (TOK_ALLCOLREF s)))))
+  (TOK_QUERY (TOK_FROM (TOK_TABREF srcbucket (TOK_TABLESAMPLE 1 5 (TOK_COLREF key)) s)) (TOK_INSERT (TOK_DESTINATION (TOK_TAB dest1)) (TOK_SELECT (TOK_SELEXPR (TOK_ALLCOLREF s)))))
 
 STAGE DEPENDENCIES:
   Stage-1 is a root stage
@@ -13,7 +13,7 @@
             Filter Operator
               predicate:
                   expr: (((default_sample_hashfn(key) & 2147483647) % 5) = 0)
-                  type: Boolean
+                  type: boolean
               Select Operator
                 expressions:
                       expr: key
@@ -21,7 +21,7 @@
                       expr: value
                       type: string
                 File Output Operator
-                  directory: /tmp/hive-njain/535229973/587370170.10000.insclause-0
+                  directory: /tmp/hive-njain/126424010/37680496.10000.insclause-0
                   table:
                       input format: org.apache.hadoop.mapred.TextInputFormat
                       output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
@@ -30,7 +30,6 @@
                         serialization.ddl struct dest1 { i32 key, string value}
                         serialization.format 1
                         columns key,value
-                        SORTBUCKETCOLSPREFIX TRUE
                         bucket_count -1
                         serialization.lib org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
                         file.inputformat org.apache.hadoop.mapred.TextInputFormat
@@ -49,9 +48,10 @@
               output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
               properties:
                 name srcbucket
+                bucket_field_name key
                 serialization.ddl struct srcbucket { string key, string value}
-                serialization.format 1
                 columns key,value
+                serialization.format 1
                 bucket_count 2
                 serialization.lib org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
                 file.inputformat org.apache.hadoop.mapred.TextInputFormat
@@ -64,7 +64,7 @@
     Move Operator
       tables:
             replace:
-            source: /tmp/hive-njain/535229973/587370170.10000.insclause-0
+            source: /tmp/hive-njain/126424010/37680496.10000.insclause-0
             table:
                 input format: org.apache.hadoop.mapred.TextInputFormat
                 output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
@@ -73,7 +73,6 @@
                   serialization.ddl struct dest1 { i32 key, string value}
                   serialization.format 1
                   columns key,value
-                  SORTBUCKETCOLSPREFIX TRUE
                   bucket_count -1
                   serialization.lib org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
                   file.inputformat org.apache.hadoop.mapred.TextInputFormat

Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/sample6.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/sample6.q.out?rev=712905&r1=712904&r2=712905&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/sample6.q.out (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/sample6.q.out Mon Nov 10 17:50:06 2008
@@ -1,5 +1,5 @@
 ABSTRACT SYNTAX TREE:
-  (TOK_QUERY (TOK_FROM (TOK_TABREF srcbucket (TOK_TABLESAMPLE 1 4 key) s)) (TOK_INSERT (TOK_DESTINATION (TOK_TAB dest1)) (TOK_SELECT (TOK_SELEXPR (TOK_ALLCOLREF s)))))
+  (TOK_QUERY (TOK_FROM (TOK_TABREF srcbucket (TOK_TABLESAMPLE 1 4 (TOK_COLREF key)) s)) (TOK_INSERT (TOK_DESTINATION (TOK_TAB dest1)) (TOK_SELECT (TOK_SELEXPR (TOK_ALLCOLREF s)))))
 
 STAGE DEPENDENCIES:
   Stage-1 is a root stage
@@ -13,7 +13,7 @@
             Filter Operator
               predicate:
                   expr: (((default_sample_hashfn(key) & 2147483647) % 4) = 0)
-                  type: Boolean
+                  type: boolean
               Select Operator
                 expressions:
                       expr: key
@@ -21,7 +21,7 @@
                       expr: value
                       type: string
                 File Output Operator
-                  directory: /tmp/hive-njain/391691394/413823912.10000.insclause-0
+                  directory: /tmp/hive-njain/57994069/1680944185.10000.insclause-0
                   table:
                       input format: org.apache.hadoop.mapred.TextInputFormat
                       output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
@@ -30,7 +30,6 @@
                         serialization.ddl struct dest1 { i32 key, string value}
                         serialization.format 1
                         columns key,value
-                        SORTBUCKETCOLSPREFIX TRUE
                         bucket_count -1
                         serialization.lib org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
                         file.inputformat org.apache.hadoop.mapred.TextInputFormat
@@ -40,18 +39,19 @@
                       name: dest1
       Needs Tagging:
       Path -> Alias:
-        file:/home/njain/workspace/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/srcbucket 
+        file:/home/njain/workspace/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/srcbucket/kv1.txt 
       Path -> Partition:
-        file:/home/njain/workspace/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/srcbucket 
+        file:/home/njain/workspace/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/srcbucket/kv1.txt 
           Partition
           
               input format: org.apache.hadoop.mapred.TextInputFormat
               output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
               properties:
                 name srcbucket
+                bucket_field_name key
                 serialization.ddl struct srcbucket { string key, string value}
-                serialization.format 1
                 columns key,value
+                serialization.format 1
                 bucket_count 2
                 serialization.lib org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
                 file.inputformat org.apache.hadoop.mapred.TextInputFormat
@@ -64,7 +64,7 @@
     Move Operator
       tables:
             replace:
-            source: /tmp/hive-njain/391691394/413823912.10000.insclause-0
+            source: /tmp/hive-njain/57994069/1680944185.10000.insclause-0
             table:
                 input format: org.apache.hadoop.mapred.TextInputFormat
                 output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
@@ -73,7 +73,6 @@
                   serialization.ddl struct dest1 { i32 key, string value}
                   serialization.format 1
                   columns key,value
-                  SORTBUCKETCOLSPREFIX TRUE
                   bucket_count -1
                   serialization.lib org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
                   file.inputformat org.apache.hadoop.mapred.TextInputFormat
@@ -201,138 +200,3 @@
 477	val_477
 169	val_169
 400	val_400
-62	val_63
-271	val_272
-217	val_218
-455	val_456
-231	val_232
-448	val_449
-246	val_247
-440	val_441
-147	val_148
-356	val_357
-217	val_218
-33	val_34
-15	val_16
-110	val_111
-275	val_276
-0	val_1
-293	val_294
-286	val_287
-408	val_409
-477	val_478
-455	val_456
-99	val_100
-367	val_368
-59	val_60
-48	val_49
-488	val_489
-349	val_350
-11	val_12
-161	val_162
-224	val_225
-4	val_5
-206	val_207
-114	val_115
-239	val_240
-389	val_390
-114	val_115
-235	val_236
-165	val_166
-264	val_265
-11	val_12
-129	val_130
-257	val_258
-323	val_324
-411	val_412
-338	val_339
-147	val_148
-473	val_474
-213	val_214
-426	val_427
-132	val_133
-121	val_122
-129	val_130
-246	val_247
-491	val_492
-352	val_353
-349	val_350
-480	val_481
-480	val_481
-183	val_184
-15	val_16
-392	val_393
-77	val_78
-275	val_276
-114	val_115
-161	val_162
-264	val_265
-48	val_49
-484	val_485
-305	val_306
-367	val_368
-260	val_261
-349	val_350
-51	val_52
-363	val_364
-118	val_119
-19	val_20
-80	val_81
-121	val_122
-239	val_240
-11	val_12
-143	val_144
-341	val_342
-363	val_364
-77	val_78
-293	val_294
-40	val_41
-8	val_9
-206	val_207
-381	val_382
-404	val_405
-206	val_207
-385	val_386
-260	val_261
-404	val_405
-451	val_452
-132	val_133
-356	val_357
-352	val_353
-330	val_331
-257	val_258
-374	val_375
-437	val_438
-334	val_335
-404	val_405
-0	val_1
-268	val_269
-491	val_492
-392	val_393
-341	val_342
-118	val_119
-172	val_173
-136	val_137
-349	val_350
-462	val_463
-408	val_409
-378	val_379
-495	val_496
-385	val_386
-40	val_41
-389	val_390
-125	val_126
-415	val_416
-228	val_229
-363	val_364
-22	val_23
-459	val_460
-62	val_63
-341	val_342
-440	val_441
-309	val_310
-161	val_162
-161	val_162
-91	val_92
-118	val_119
-242	val_243

Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/sample7.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/sample7.q.out?rev=712905&r1=712904&r2=712905&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/sample7.q.out (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/sample7.q.out Mon Nov 10 17:50:06 2008
@@ -1,5 +1,5 @@
 ABSTRACT SYNTAX TREE:
-  (TOK_QUERY (TOK_FROM (TOK_TABREF srcbucket (TOK_TABLESAMPLE 1 4 key) s)) (TOK_INSERT (TOK_DESTINATION (TOK_TAB dest1)) (TOK_SELECT (TOK_SELEXPR (TOK_ALLCOLREF s))) (TOK_WHERE (> (TOK_COLREF s key) 100))))
+  (TOK_QUERY (TOK_FROM (TOK_TABREF srcbucket (TOK_TABLESAMPLE 1 4 (TOK_COLREF key)) s)) (TOK_INSERT (TOK_DESTINATION (TOK_TAB dest1)) (TOK_SELECT (TOK_SELEXPR (TOK_ALLCOLREF s))) (TOK_WHERE (> (TOK_COLREF s key) 100))))
 
 STAGE DEPENDENCIES:
   Stage-1 is a root stage
@@ -13,11 +13,11 @@
             Filter Operator
               predicate:
                   expr: (((default_sample_hashfn(key) & 2147483647) % 4) = 0)
-                  type: Boolean
+                  type: boolean
               Filter Operator
                 predicate:
                     expr: (key > 100)
-                    type: Boolean
+                    type: boolean
                 Select Operator
                   expressions:
                         expr: key
@@ -25,7 +25,7 @@
                         expr: value
                         type: string
                   File Output Operator
-                    directory: /tmp/hive-njain/1265167991/144531187.10000.insclause-0
+                    directory: /tmp/hive-njain/682589217/559576387.10000.insclause-0
                     table:
                         input format: org.apache.hadoop.mapred.TextInputFormat
                         output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
@@ -34,7 +34,6 @@
                           serialization.ddl struct dest1 { i32 key, string value}
                           serialization.format 1
                           columns key,value
-                          SORTBUCKETCOLSPREFIX TRUE
                           bucket_count -1
                           serialization.lib org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
                           file.inputformat org.apache.hadoop.mapred.TextInputFormat
@@ -44,18 +43,19 @@
                         name: dest1
       Needs Tagging:
       Path -> Alias:
-        file:/home/njain/workspace/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/srcbucket 
+        file:/home/njain/workspace/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/srcbucket/kv1.txt 
       Path -> Partition:
-        file:/home/njain/workspace/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/srcbucket 
+        file:/home/njain/workspace/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/srcbucket/kv1.txt 
           Partition
           
               input format: org.apache.hadoop.mapred.TextInputFormat
               output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
               properties:
                 name srcbucket
+                bucket_field_name key
                 serialization.ddl struct srcbucket { string key, string value}
-                serialization.format 1
                 columns key,value
+                serialization.format 1
                 bucket_count 2
                 serialization.lib org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
                 file.inputformat org.apache.hadoop.mapred.TextInputFormat
@@ -68,7 +68,7 @@
     Move Operator
       tables:
             replace:
-            source: /tmp/hive-njain/1265167991/144531187.10000.insclause-0
+            source: /tmp/hive-njain/682589217/559576387.10000.insclause-0
             table:
                 input format: org.apache.hadoop.mapred.TextInputFormat
                 output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
@@ -77,7 +77,6 @@
                   serialization.ddl struct dest1 { i32 key, string value}
                   serialization.format 1
                   columns key,value
-                  SORTBUCKETCOLSPREFIX TRUE
                   bucket_count -1
                   serialization.lib org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
                   file.inputformat org.apache.hadoop.mapred.TextInputFormat
@@ -181,113 +180,3 @@
 477	val_477
 169	val_169
 400	val_400
-271	val_272
-217	val_218
-455	val_456
-231	val_232
-448	val_449
-246	val_247
-440	val_441
-147	val_148
-356	val_357
-217	val_218
-110	val_111
-275	val_276
-293	val_294
-286	val_287
-408	val_409
-477	val_478
-455	val_456
-367	val_368
-488	val_489
-349	val_350
-161	val_162
-224	val_225
-206	val_207
-114	val_115
-239	val_240
-389	val_390
-114	val_115
-235	val_236
-165	val_166
-264	val_265
-129	val_130
-257	val_258
-323	val_324
-411	val_412
-338	val_339
-147	val_148
-473	val_474
-213	val_214
-426	val_427
-132	val_133
-121	val_122
-129	val_130
-246	val_247
-491	val_492
-352	val_353
-349	val_350
-480	val_481
-480	val_481
-183	val_184
-392	val_393
-275	val_276
-114	val_115
-161	val_162
-264	val_265
-484	val_485
-305	val_306
-367	val_368
-260	val_261
-349	val_350
-363	val_364
-118	val_119
-121	val_122
-239	val_240
-143	val_144
-341	val_342
-363	val_364
-293	val_294
-206	val_207
-381	val_382
-404	val_405
-206	val_207
-385	val_386
-260	val_261
-404	val_405
-451	val_452
-132	val_133
-356	val_357
-352	val_353
-330	val_331
-257	val_258
-374	val_375
-437	val_438
-334	val_335
-404	val_405
-268	val_269
-491	val_492
-392	val_393
-341	val_342
-118	val_119
-172	val_173
-136	val_137
-349	val_350
-462	val_463
-408	val_409
-378	val_379
-495	val_496
-385	val_386
-389	val_390
-125	val_126
-415	val_416
-228	val_229
-363	val_364
-459	val_460
-341	val_342
-440	val_441
-309	val_310
-161	val_162
-161	val_162
-118	val_119
-242	val_243

Added: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/scriptfile1.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/scriptfile1.q.out?rev=712905&view=auto
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/scriptfile1.q.out (added)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/scriptfile1.q.out Mon Nov 10 17:50:06 2008
@@ -0,0 +1,9 @@
+10	val_10
+100	val_100
+100	val_100
+103	val_103
+103	val_103
+104	val_104
+104	val_104
+105	val_105
+310	val_310

Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/subq.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/subq.q.out?rev=712905&r1=712904&r2=712905&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/subq.q.out (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/subq.q.out Mon Nov 10 17:50:06 2008
@@ -13,7 +13,7 @@
             Filter Operator
               predicate:
                   expr: (key < 100)
-                  type: Boolean
+                  type: boolean
               Select Operator
                 expressions:
                       expr: key

Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/subq2.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/subq2.q.out?rev=712905&r1=712904&r2=712905&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/subq2.q.out (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/subq2.q.out Mon Nov 10 17:50:06 2008
@@ -11,15 +11,21 @@
     Map Reduce
       Alias -> Map Operator Tree:
         a:b 
-            Reduce Output Operator
-              key expressions:
+            Select Operator
+              expressions:
                     expr: key
                     type: string
-              # partition fields: -1
-              tag: -1
-              value expressions:
-                    expr: 1
-                    type: int
+              Reduce Output Operator
+                key expressions:
+                      expr: 0
+                      type: string
+                Map-reduce partition columns:
+                      expr: rand()
+                      type: double
+                tag: -1
+                value expressions:
+                      expr: 1
+                      type: int
       Reduce Operator Tree:
         Group By Operator
         
@@ -30,22 +36,25 @@
           mode: partial1
           File Output Operator
             table:
-                input format: org.apache.hadoop.mapred.TextInputFormat
-                output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+                input format: org.apache.hadoop.mapred.SequenceFileInputFormat
+                output format: org.apache.hadoop.mapred.SequenceFileOutputFormat
+                name: binary_table
 
   Stage: Stage-2
     Map Reduce
       Alias -> Map Operator Tree:
-        /tmp/hive-njain/57219117/75379653.10002 
+        /tmp/hive-njain/158235739/1374397779.10002 
           Reduce Output Operator
             key expressions:
                   expr: 0
                   type: string
-            # partition fields: 1
+            Map-reduce partition columns:
+                  expr: 0
+                  type: string
             tag: -1
             value expressions:
                   expr: 1
-                  type: string
+                  type: bigint
       Reduce Operator Tree:
         Group By Operator
         
@@ -53,23 +62,23 @@
           keys:
                 expr: KEY.0
                 type: string
-          mode: partial2
+          mode: unknown
           Select Operator
             expressions:
                   expr: 0
                   type: string
                   expr: 1
-                  type: string
+                  type: bigint
             Filter Operator
               predicate:
                   expr: (0 >= 90)
-                  type: Boolean
+                  type: boolean
               Select Operator
                 expressions:
                       expr: 0
                       type: string
                       expr: 1
-                      type: string
+                      type: bigint
                 File Output Operator
                   table:
                       input format: org.apache.hadoop.mapred.TextInputFormat

Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/udf1.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/udf1.q.out?rev=712905&r1=712904&r2=712905&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/udf1.q.out (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/udf1.q.out Mon Nov 10 17:50:06 2008
@@ -10,52 +10,56 @@
     Map Reduce
       Alias -> Map Operator Tree:
         src 
-            Filter Operator
-              predicate:
-                  expr: (key = 86)
-                  type: Boolean
-              Select Operator
-                expressions:
-                      expr: ('a' like '%a%')
-                      type: Boolean
-                      expr: ('b' like '%a%')
-                      type: Boolean
-                      expr: ('ab' like '%a%')
-                      type: Boolean
-                      expr: ('ab' like '%a_')
-                      type: Boolean
-                      expr: ('%_' like '\%\_')
-                      type: Boolean
-                      expr: ('ab' like '\%\_')
-                      type: Boolean
-                      expr: ('ab' like '_a%')
-                      type: Boolean
-                      expr: ('ab' like 'a')
-                      type: Boolean
-                      expr: ('' regexp '.*')
-                      type: Boolean
-                      expr: ('a' regexp '[ab]')
-                      type: Boolean
-                      expr: ('' regexp '[ab]')
-                      type: Boolean
-                      expr: ('hadoop' regexp '[a-z]*')
-                      type: Boolean
-                      expr: ('hadoop' regexp 'o*')
-                      type: Boolean
-                      expr: regexp_replace('abc', 'b', 'c')
-                      type: string
-                      expr: regexp_replace('abc', 'z', 'a')
-                      type: string
-                      expr: regexp_replace('abbbb', 'bb', 'b')
-                      type: string
-                      expr: regexp_replace('hadoop', '(.)[a-z]*', '$1ive')
-                      type: string
-                File Output Operator
-                  table:
-                      input format: org.apache.hadoop.mapred.TextInputFormat
-                      output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
-                      serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
-                      name: dest1
+            Select Operator
+              expressions:
+                    expr: key
+                    type: string
+              Filter Operator
+                predicate:
+                    expr: (0 = 86)
+                    type: boolean
+                Select Operator
+                  expressions:
+                        expr: ('a' like '%a%')
+                        type: boolean
+                        expr: ('b' like '%a%')
+                        type: boolean
+                        expr: ('ab' like '%a%')
+                        type: boolean
+                        expr: ('ab' like '%a_')
+                        type: boolean
+                        expr: ('%_' like '\%\_')
+                        type: boolean
+                        expr: ('ab' like '\%\_')
+                        type: boolean
+                        expr: ('ab' like '_a%')
+                        type: boolean
+                        expr: ('ab' like 'a')
+                        type: boolean
+                        expr: ('' regexp '.*')
+                        type: boolean
+                        expr: ('a' regexp '[ab]')
+                        type: boolean
+                        expr: ('' regexp '[ab]')
+                        type: boolean
+                        expr: ('hadoop' regexp '[a-z]*')
+                        type: boolean
+                        expr: ('hadoop' regexp 'o*')
+                        type: boolean
+                        expr: regexp_replace('abc', 'b', 'c')
+                        type: string
+                        expr: regexp_replace('abc', 'z', 'a')
+                        type: string
+                        expr: regexp_replace('abbbb', 'bb', 'b')
+                        type: string
+                        expr: regexp_replace('hadoop', '(.)[a-z]*', '$1ive')
+                        type: string
+                  File Output Operator
+                    table:
+                        input format: org.apache.hadoop.mapred.TextInputFormat
+                        output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+                        serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+                        name: dest1
 
   Stage: Stage-0
     Move Operator

Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/udf3.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/udf3.q.out?rev=712905&r1=712904&r2=712905&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/udf3.q.out (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/udf3.q.out Mon Nov 10 17:50:06 2008
@@ -11,44 +11,47 @@
     Map Reduce
       Alias -> Map Operator Tree:
         src 
-            Reduce Output Operator
-              # partition fields: -1
-              tag: -1
-              value expressions:
-                    expr: UDFToInteger('')
-                    type: int
+            Select Operator
+              Reduce Output Operator
+                Map-reduce partition columns:
+                      expr: rand()
+                      type: double
+                tag: -1
+                value expressions:
+                      expr: UDFToInteger('')
+                      type: int
       Reduce Operator Tree:
         Group By Operator
         
-              expr: max(VALUE.0)
-              expr: avg(VALUE.0)
+              expr: max(UDFToDouble(VALUE.0))
+              expr: avg(UDFToDouble(VALUE.0))
               expr: count(VALUE.0)
-              expr: sum(VALUE.0)
-              expr: min(VALUE.0)
+              expr: sum(UDFToDouble(VALUE.0))
+              expr: min(UDFToDouble(VALUE.0))
           mode: partial1
           File Output Operator
             table:
-                input format: org.apache.hadoop.mapred.TextInputFormat
-                output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+                input format: org.apache.hadoop.mapred.SequenceFileInputFormat
+                output format: org.apache.hadoop.mapred.SequenceFileOutputFormat
+                name: binary_table
 
   Stage: Stage-2
     Map Reduce
       Alias -> Map Operator Tree:
-        /tmp/hive-njain/159338588/98912587.10001 
+        /tmp/hive-njain/20731779/1245261687.10001 
           Reduce Output Operator
-            # partition fields: 0
             tag: -1
             value expressions:
                   expr: 0
-                  type: string
+                  type: double
                   expr: 1
                   type: string
                   expr: 2
-                  type: string
+                  type: bigint
                   expr: 3
-                  type: string
+                  type: double
                   expr: 4
-                  type: string
+                  type: double
       Reduce Operator Tree:
         Group By Operator
         
@@ -57,19 +60,19 @@
               expr: count(VALUE.2)
               expr: sum(VALUE.3)
               expr: min(VALUE.4)
-          mode: partial2
+          mode: unknown
           Select Operator
             expressions:
                   expr: 2
-                  type: string
+                  type: bigint
                   expr: 3
-                  type: string
+                  type: double
                   expr: 1
                   type: string
                   expr: 4
-                  type: string
+                  type: double
                   expr: 0
-                  type: string
+                  type: double
             File Output Operator
               table:
                   input format: org.apache.hadoop.mapred.TextInputFormat

Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/udf4.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/udf4.q.out?rev=712905&r1=712904&r2=712905&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/udf4.q.out (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/udf4.q.out Mon Nov 10 17:50:06 2008
@@ -11,43 +11,44 @@
       Alias -> Map Operator Tree:
         dest1 
             Select Operator
-              expressions:
-                    expr: round(1.0)
-                    type: bigint
-                    expr: round(1.5)
-                    type: bigint
-                    expr: round(- 1.5)
-                    type: bigint
-                    expr: floor(1.0)
-                    type: bigint
-                    expr: floor(1.5)
-                    type: bigint
-                    expr: floor(- 1.5)
-                    type: bigint
-                    expr: ceiling(1.0)
-                    type: bigint
-                    expr: ceiling(1.5)
-                    type: bigint
-                    expr: ceiling(- 1.5)
-                    type: bigint
-                    expr: ceiling(1.0)
-                    type: bigint
-                    expr: rand(UDFToLong(3))
-                    type: double
-                    expr: 3
-                    type: int
-                    expr: - 3
-                    type: int
-                    expr: (1 + 2)
-                    type: int
-                    expr: (1 + - 2)
-                    type: int
-                    expr: ~ 1
-                    type: int
-              File Output Operator
-                table:
-                    input format: org.apache.hadoop.mapred.TextInputFormat
-                    output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+              Select Operator
+                expressions:
+                      expr: round(1.0)
+                      type: bigint
+                      expr: round(1.5)
+                      type: bigint
+                      expr: round(- 1.5)
+                      type: bigint
+                      expr: floor(1.0)
+                      type: bigint
+                      expr: floor(1.5)
+                      type: bigint
+                      expr: floor(- 1.5)
+                      type: bigint
+                      expr: ceiling(1.0)
+                      type: bigint
+                      expr: ceiling(1.5)
+                      type: bigint
+                      expr: ceiling(- 1.5)
+                      type: bigint
+                      expr: ceiling(1.0)
+                      type: bigint
+                      expr: rand(UDFToLong(3))
+                      type: double
+                      expr: 3
+                      type: int
+                      expr: - 3
+                      type: int
+                      expr: (1 + 2)
+                      type: int
+                      expr: (1 + - 2)
+                      type: int
+                      expr: ~ 1
+                      type: int
+                File Output Operator
+                  table:
+                      input format: org.apache.hadoop.mapred.TextInputFormat
+                      output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
 
   Stage: Stage-0
     Fetch Operator

Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/union.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/union.q.out?rev=712905&r1=712904&r2=712905&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/union.q.out (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/union.q.out Mon Nov 10 17:50:06 2008
@@ -13,7 +13,7 @@
             Filter Operator
               predicate:
                   expr: (key < 100)
-                  type: Boolean
+                  type: boolean
               Select Operator
                 expressions:
                       expr: key
@@ -34,7 +34,7 @@
             Filter Operator
               predicate:
                   expr: (key > 100)
-                  type: Boolean
+                  type: boolean
               Select Operator
                 expressions:
                       expr: key

Added: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/compiler/errors/insert_wrong_number_columns.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/compiler/errors/insert_wrong_number_columns.q.out?rev=712905&view=auto
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/compiler/errors/insert_wrong_number_columns.q.out (added)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/compiler/errors/insert_wrong_number_columns.q.out Mon Nov 10 17:50:06 2008
@@ -0,0 +1,2 @@
+Semantic Exception: 
+line 2:23 Cannot insert into target table because column number/types are different dest1: Table insclause-0 has 2 columns but query has [0: string, 1: string, 2: int].
\ No newline at end of file

Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/compiler/errors/quoted_string.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/compiler/errors/quoted_string.q.out?rev=712905&r1=712904&r2=712905&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/compiler/errors/quoted_string.q.out (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/compiler/errors/quoted_string.q.out Mon Nov 10 17:50:06 2008
@@ -1,2 +1,2 @@
-Parse Error: line 2:36 character '"' not supported here
-line 2:41 character '"' not supported here
+Parse Error: line 3:0 character '<EOF>' not supported here
+line 3:0 character '<EOF>' not supported here

Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/compiler/parse/cast1.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/compiler/parse/cast1.q.out?rev=712905&r1=712904&r2=712905&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/compiler/parse/cast1.q.out (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/compiler/parse/cast1.q.out Mon Nov 10 17:50:06 2008
@@ -1 +1 @@
-(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)))) null
\ No newline at end of file
+(TOK_QUERY (TOK_FROM (TOK_TABREF src)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (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)))) null
\ No newline at end of file

Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/compiler/parse/groupby2.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/compiler/parse/groupby2.q.out?rev=712905&r1=712904&r2=712905&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/compiler/parse/groupby2.q.out (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/compiler/parse/groupby2.q.out Mon Nov 10 17:50:06 2008
@@ -1 +1 @@
-(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)))) null
\ No newline at end of file
+(TOK_QUERY (TOK_FROM (TOK_TABREF src)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (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)))) null
\ No newline at end of file

Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/compiler/parse/groupby3.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/compiler/parse/groupby3.q.out?rev=712905&r1=712904&r2=712905&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/compiler/parse/groupby3.q.out (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/compiler/parse/groupby3.q.out Mon Nov 10 17:50:06 2008
@@ -1 +1 @@
-(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)))))) null
\ No newline at end of file
+(TOK_QUERY (TOK_FROM (TOK_TABREF src)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (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)))))) null
\ No newline at end of file

Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/compiler/parse/groupby4.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/compiler/parse/groupby4.q.out?rev=712905&r1=712904&r2=712905&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/compiler/parse/groupby4.q.out (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/compiler/parse/groupby4.q.out Mon Nov 10 17:50:06 2008
@@ -1 +1 @@
-(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)))) null
\ No newline at end of file
+(TOK_QUERY (TOK_FROM (TOK_TABREF src)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTION substr (TOK_COLREF src key) 0 1))) (TOK_GROUPBY (TOK_FUNCTION substr (TOK_COLREF src key) 0 1)))) null
\ No newline at end of file

Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/compiler/parse/groupby5.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/compiler/parse/groupby5.q.out?rev=712905&r1=712904&r2=712905&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/compiler/parse/groupby5.q.out (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/compiler/parse/groupby5.q.out Mon Nov 10 17:50:06 2008
@@ -1 +1 @@
-(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)))) null
\ No newline at end of file
+(TOK_QUERY (TOK_FROM (TOK_TABREF src)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (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)))) null
\ No newline at end of file

Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/compiler/parse/groupby6.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/compiler/parse/groupby6.q.out?rev=712905&r1=712904&r2=712905&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/compiler/parse/groupby6.q.out (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/compiler/parse/groupby6.q.out Mon Nov 10 17:50:06 2008
@@ -1 +1 @@
-(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))))) null
\ No newline at end of file
+(TOK_QUERY (TOK_FROM (TOK_TABREF src)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECTDI (TOK_SELEXPR (TOK_FUNCTION substr (TOK_COLREF src value) 4 1))))) null
\ No newline at end of file

Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/compiler/parse/input2.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/compiler/parse/input2.q.out?rev=712905&r1=712904&r2=712905&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/compiler/parse/input2.q.out (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/compiler/parse/input2.q.out Mon Nov 10 17:50:06 2008
@@ -1 +1 @@
-(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)))) null
\ No newline at end of file
+(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_SELEXPR 2)) (TOK_WHERE (>= (TOK_COLREF src key) 200)))) null
\ No newline at end of file

Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/compiler/parse/input3.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/compiler/parse/input3.q.out?rev=712905&r1=712904&r2=712905&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/compiler/parse/input3.q.out (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/compiler/parse/input3.q.out Mon Nov 10 17:50:06 2008
@@ -1 +1 @@
-(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)))) null
\ No newline at end of file
+(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_SELEXPR 2)) (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)))) null
\ No newline at end of file

Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/compiler/parse/input4.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/compiler/parse/input4.q.out?rev=712905&r1=712904&r2=712905&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/compiler/parse/input4.q.out (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/compiler/parse/input4.q.out Mon Nov 10 17:50:06 2008
@@ -1 +1 @@
-(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)))) null
\ No newline at end of file
+(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_EXPLIST (TOK_COLREF src key) (TOK_COLREF src value)) '/bin/cat' (TOK_ALIASLIST tkey tvalue)))) (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)))) null
\ No newline at end of file

Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/compiler/parse/input5.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/compiler/parse/input5.q.out?rev=712905&r1=712904&r2=712905&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/compiler/parse/input5.q.out (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/compiler/parse/input5.q.out Mon Nov 10 17:50:06 2008
@@ -1 +1 @@
-(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))))) null
\ No newline at end of file
+(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_EXPLIST (TOK_COLREF src_thrift lint) (TOK_COLREF src_thrift lintstring)) '/bin/cat' (TOK_ALIASLIST tkey tvalue)))) (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))))) null
\ No newline at end of file

Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/compiler/parse/input8.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/compiler/parse/input8.q.out?rev=712905&r1=712904&r2=712905&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/compiler/parse/input8.q.out (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/compiler/parse/input8.q.out Mon Nov 10 17:50:06 2008
@@ -1 +1 @@
-(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))))) null
\ No newline at end of file
+(TOK_QUERY (TOK_FROM (TOK_TABREF src1)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (+ 4 TOK_NULL)) (TOK_SELEXPR (- (TOK_COLREF src1 key) TOK_NULL)) (TOK_SELEXPR (+ TOK_NULL TOK_NULL))))) null
\ No newline at end of file

Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/compiler/parse/input_part1.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/compiler/parse/input_part1.q.out?rev=712905&r1=712904&r2=712905&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/compiler/parse/input_part1.q.out (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/compiler/parse/input_part1.q.out Mon Nov 10 17:50:06 2008
@@ -1 +1 @@
-(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'))))) null
\ No newline at end of file
+(TOK_QUERY (TOK_FROM (TOK_TABREF srcpart)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (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'))))) null
\ No newline at end of file

Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/compiler/parse/input_testxpath.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/compiler/parse/input_testxpath.q.out?rev=712905&r1=712904&r2=712905&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/compiler/parse/input_testxpath.q.out (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/compiler/parse/input_testxpath.q.out Mon Nov 10 17:50:06 2008
@@ -1 +1 @@
-(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)) (TOK_SELEXPR ([ (TOK_COLREF src_thrift mstringstring) 'key_2'))))) null
\ No newline at end of file
+(TOK_QUERY (TOK_FROM (TOK_TABREF src_thrift)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR ([ (TOK_COLREF src_thrift lint) 1)) (TOK_SELEXPR (. ([ (TOK_COLREF src_thrift lintstring) 0) mystring)) (TOK_SELEXPR ([ (TOK_COLREF src_thrift mstringstring) 'key_2'))))) null
\ No newline at end of file



Mime
View raw message