hadoop-common-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From zs...@apache.org
Subject svn commit: r697291 [16/31] - in /hadoop/core/trunk: ./ src/contrib/hive/cli/src/java/org/apache/hadoop/hive/cli/ src/contrib/hive/metastore/if/ src/contrib/hive/metastore/src/gen-javabean/org/apache/hadoop/hive/metastore/api/ src/contrib/hive/metastor...
Date Fri, 19 Sep 2008 23:56:35 GMT
Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input12.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input12.q.out?rev=697291&r1=697290&r2=697291&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 Fri Sep 19 16:56:30 2008
@@ -1,584 +1,588 @@
-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	
-66	val_66	
-37	val_37	
-15	val_15	
-82	val_82	
-17	val_17	
-0	val_0	
-57	val_57	
-20	val_20	
-92	val_92	
-47	val_47	
-72	val_72	
-4	val_4	
-35	val_35	
-54	val_54	
-51	val_51	
-65	val_65	
-83	val_83	
-12	val_12	
-67	val_67	
-84	val_84	
-58	val_58	
-8	val_8	
-24	val_24	
-42	val_42	
-0	val_0	
-96	val_96	
-26	val_26	
-51	val_51	
-43	val_43	
-95	val_95	
-98	val_98	
-85	val_85	
-77	val_77	
-0	val_0	
-87	val_87	
-15	val_15	
-72	val_72	
-90	val_90	
-19	val_19	
-10	val_10	
-5	val_5	
-58	val_58	
-35	val_35	
-95	val_95	
-11	val_11	
-34	val_34	
-42	val_42	
-78	val_78	
-76	val_76	
-41	val_41	
-30	val_30	
-64	val_64	
-76	val_76	
-74	val_74	
-69	val_69	
-33	val_33	
-70	val_70	
-5	val_5	
-2	val_2	
-35	val_35	
-80	val_80	
-44	val_44	
-53	val_53	
-90	val_90	
-12	val_12	
-5	val_5	
-70	val_70	
-24	val_24	
-70	val_70	
-83	val_83	
-26	val_26	
-67	val_67	
-18	val_18	
-9	val_9	
-18	val_18	
-97	val_97	
-84	val_84	
-28	val_28	
-37	val_37	
-90	val_90	
-97	val_97	
-165	val_165	
-193	val_193	
-150	val_150	
-128	val_128	
-146	val_146	
-152	val_152	
-145	val_145	
-166	val_166	
-153	val_153	
-193	val_193	
-174	val_174	
-199	val_199	
-174	val_174	
-162	val_162	
-167	val_167	
-195	val_195	
-113	val_113	
-155	val_155	
-128	val_128	
-149	val_149	
-129	val_129	
-170	val_170	
-157	val_157	
-111	val_111	
-169	val_169	
-125	val_125	
-192	val_192	
-187	val_187	
-176	val_176	
-138	val_138	
-103	val_103	
-176	val_176	
-137	val_137	
-180	val_180	
-181	val_181	
-138	val_138	
-179	val_179	
-172	val_172	
-129	val_129	
-158	val_158	
-119	val_119	
-197	val_197	
-100	val_100	
-199	val_199	
-191	val_191	
-165	val_165	
-120	val_120	
-131	val_131	
-156	val_156	
-196	val_196	
-197	val_197	
-187	val_187	
-137	val_137	
-169	val_169	
-179	val_179	
-118	val_118	
-134	val_134	
-138	val_138	
-118	val_118	
-177	val_177	
-168	val_168	
-143	val_143	
-160	val_160	
-195	val_195	
-119	val_119	
-149	val_149	
-138	val_138	
-103	val_103	
-113	val_113	
-167	val_167	
-116	val_116	
-191	val_191	
-128	val_128	
-193	val_193	
-104	val_104	
-175	val_175	
-105	val_105	
-190	val_190	
-114	val_114	
-164	val_164	
-125	val_125	
-164	val_164	
-187	val_187	
-104	val_104	
-163	val_163	
-119	val_119	
-199	val_199	
-120	val_120	
-169	val_169	
-178	val_178	
-136	val_136	
-172	val_172	
-133	val_133	
-175	val_175	
-189	val_189	
-134	val_134	
-100	val_100	
-146	val_146	
-186	val_186	
-167	val_167	
-183	val_183	
-152	val_152	
-194	val_194	
-126	val_126	
-169	val_169	
-238	NULL	2008-04-08	12	
-311	NULL	2008-04-08	12	
-409	NULL	2008-04-08	12	
-255	NULL	2008-04-08	12	
-278	NULL	2008-04-08	12	
-484	NULL	2008-04-08	12	
-265	NULL	2008-04-08	12	
-401	NULL	2008-04-08	12	
-273	NULL	2008-04-08	12	
-224	NULL	2008-04-08	12	
-369	NULL	2008-04-08	12	
-213	NULL	2008-04-08	12	
-406	NULL	2008-04-08	12	
-429	NULL	2008-04-08	12	
-374	NULL	2008-04-08	12	
-469	NULL	2008-04-08	12	
-495	NULL	2008-04-08	12	
-327	NULL	2008-04-08	12	
-281	NULL	2008-04-08	12	
-277	NULL	2008-04-08	12	
-209	NULL	2008-04-08	12	
-403	NULL	2008-04-08	12	
-417	NULL	2008-04-08	12	
-430	NULL	2008-04-08	12	
-252	NULL	2008-04-08	12	
-292	NULL	2008-04-08	12	
-219	NULL	2008-04-08	12	
-287	NULL	2008-04-08	12	
-338	NULL	2008-04-08	12	
-446	NULL	2008-04-08	12	
-459	NULL	2008-04-08	12	
-394	NULL	2008-04-08	12	
-237	NULL	2008-04-08	12	
-482	NULL	2008-04-08	12	
-413	NULL	2008-04-08	12	
-494	NULL	2008-04-08	12	
-207	NULL	2008-04-08	12	
-466	NULL	2008-04-08	12	
-208	NULL	2008-04-08	12	
-399	NULL	2008-04-08	12	
-396	NULL	2008-04-08	12	
-247	NULL	2008-04-08	12	
-417	NULL	2008-04-08	12	
-489	NULL	2008-04-08	12	
-377	NULL	2008-04-08	12	
-397	NULL	2008-04-08	12	
-309	NULL	2008-04-08	12	
-365	NULL	2008-04-08	12	
-266	NULL	2008-04-08	12	
-439	NULL	2008-04-08	12	
-342	NULL	2008-04-08	12	
-367	NULL	2008-04-08	12	
-325	NULL	2008-04-08	12	
-475	NULL	2008-04-08	12	
-203	NULL	2008-04-08	12	
-339	NULL	2008-04-08	12	
-455	NULL	2008-04-08	12	
-311	NULL	2008-04-08	12	
-316	NULL	2008-04-08	12	
-302	NULL	2008-04-08	12	
-205	NULL	2008-04-08	12	
-438	NULL	2008-04-08	12	
-345	NULL	2008-04-08	12	
-489	NULL	2008-04-08	12	
-378	NULL	2008-04-08	12	
-221	NULL	2008-04-08	12	
-280	NULL	2008-04-08	12	
-427	NULL	2008-04-08	12	
-277	NULL	2008-04-08	12	
-208	NULL	2008-04-08	12	
-356	NULL	2008-04-08	12	
-399	NULL	2008-04-08	12	
-382	NULL	2008-04-08	12	
-498	NULL	2008-04-08	12	
-386	NULL	2008-04-08	12	
-437	NULL	2008-04-08	12	
-469	NULL	2008-04-08	12	
-286	NULL	2008-04-08	12	
-459	NULL	2008-04-08	12	
-239	NULL	2008-04-08	12	
-213	NULL	2008-04-08	12	
-216	NULL	2008-04-08	12	
-430	NULL	2008-04-08	12	
-278	NULL	2008-04-08	12	
-289	NULL	2008-04-08	12	
-221	NULL	2008-04-08	12	
-318	NULL	2008-04-08	12	
-332	NULL	2008-04-08	12	
-311	NULL	2008-04-08	12	
-275	NULL	2008-04-08	12	
-241	NULL	2008-04-08	12	
-333	NULL	2008-04-08	12	
-284	NULL	2008-04-08	12	
-230	NULL	2008-04-08	12	
-260	NULL	2008-04-08	12	
-404	NULL	2008-04-08	12	
-384	NULL	2008-04-08	12	
-489	NULL	2008-04-08	12	
-353	NULL	2008-04-08	12	
-373	NULL	2008-04-08	12	
-272	NULL	2008-04-08	12	
-217	NULL	2008-04-08	12	
-348	NULL	2008-04-08	12	
-466	NULL	2008-04-08	12	
-411	NULL	2008-04-08	12	
-230	NULL	2008-04-08	12	
-208	NULL	2008-04-08	12	
-348	NULL	2008-04-08	12	
-463	NULL	2008-04-08	12	
-431	NULL	2008-04-08	12	
-496	NULL	2008-04-08	12	
-322	NULL	2008-04-08	12	
-468	NULL	2008-04-08	12	
-393	NULL	2008-04-08	12	
-454	NULL	2008-04-08	12	
-298	NULL	2008-04-08	12	
-418	NULL	2008-04-08	12	
-327	NULL	2008-04-08	12	
-230	NULL	2008-04-08	12	
-205	NULL	2008-04-08	12	
-404	NULL	2008-04-08	12	
-436	NULL	2008-04-08	12	
-469	NULL	2008-04-08	12	
-468	NULL	2008-04-08	12	
-308	NULL	2008-04-08	12	
-288	NULL	2008-04-08	12	
-481	NULL	2008-04-08	12	
-457	NULL	2008-04-08	12	
-282	NULL	2008-04-08	12	
-318	NULL	2008-04-08	12	
-318	NULL	2008-04-08	12	
-409	NULL	2008-04-08	12	
-470	NULL	2008-04-08	12	
-369	NULL	2008-04-08	12	
-316	NULL	2008-04-08	12	
-413	NULL	2008-04-08	12	
-490	NULL	2008-04-08	12	
-364	NULL	2008-04-08	12	
-395	NULL	2008-04-08	12	
-282	NULL	2008-04-08	12	
-238	NULL	2008-04-08	12	
-419	NULL	2008-04-08	12	
-307	NULL	2008-04-08	12	
-435	NULL	2008-04-08	12	
-277	NULL	2008-04-08	12	
-273	NULL	2008-04-08	12	
-306	NULL	2008-04-08	12	
-224	NULL	2008-04-08	12	
-309	NULL	2008-04-08	12	
-389	NULL	2008-04-08	12	
-327	NULL	2008-04-08	12	
-242	NULL	2008-04-08	12	
-369	NULL	2008-04-08	12	
-392	NULL	2008-04-08	12	
-272	NULL	2008-04-08	12	
-331	NULL	2008-04-08	12	
-401	NULL	2008-04-08	12	
-242	NULL	2008-04-08	12	
-452	NULL	2008-04-08	12	
-226	NULL	2008-04-08	12	
-497	NULL	2008-04-08	12	
-402	NULL	2008-04-08	12	
-396	NULL	2008-04-08	12	
-317	NULL	2008-04-08	12	
-395	NULL	2008-04-08	12	
-336	NULL	2008-04-08	12	
-229	NULL	2008-04-08	12	
-233	NULL	2008-04-08	12	
-472	NULL	2008-04-08	12	
-322	NULL	2008-04-08	12	
-498	NULL	2008-04-08	12	
-321	NULL	2008-04-08	12	
-430	NULL	2008-04-08	12	
-489	NULL	2008-04-08	12	
-458	NULL	2008-04-08	12	
-223	NULL	2008-04-08	12	
-492	NULL	2008-04-08	12	
-449	NULL	2008-04-08	12	
-218	NULL	2008-04-08	12	
-228	NULL	2008-04-08	12	
-453	NULL	2008-04-08	12	
-209	NULL	2008-04-08	12	
-468	NULL	2008-04-08	12	
-342	NULL	2008-04-08	12	
-230	NULL	2008-04-08	12	
-368	NULL	2008-04-08	12	
-296	NULL	2008-04-08	12	
-216	NULL	2008-04-08	12	
-367	NULL	2008-04-08	12	
-344	NULL	2008-04-08	12	
-274	NULL	2008-04-08	12	
-219	NULL	2008-04-08	12	
-239	NULL	2008-04-08	12	
-485	NULL	2008-04-08	12	
-223	NULL	2008-04-08	12	
-256	NULL	2008-04-08	12	
-263	NULL	2008-04-08	12	
-487	NULL	2008-04-08	12	
-480	NULL	2008-04-08	12	
-401	NULL	2008-04-08	12	
-288	NULL	2008-04-08	12	
-244	NULL	2008-04-08	12	
-438	NULL	2008-04-08	12	
-467	NULL	2008-04-08	12	
-432	NULL	2008-04-08	12	
-202	NULL	2008-04-08	12	
-316	NULL	2008-04-08	12	
-229	NULL	2008-04-08	12	
-469	NULL	2008-04-08	12	
-463	NULL	2008-04-08	12	
-280	NULL	2008-04-08	12	
-283	NULL	2008-04-08	12	
-331	NULL	2008-04-08	12	
-235	NULL	2008-04-08	12	
-321	NULL	2008-04-08	12	
-335	NULL	2008-04-08	12	
-466	NULL	2008-04-08	12	
-366	NULL	2008-04-08	12	
-403	NULL	2008-04-08	12	
-483	NULL	2008-04-08	12	
-257	NULL	2008-04-08	12	
-406	NULL	2008-04-08	12	
-409	NULL	2008-04-08	12	
-406	NULL	2008-04-08	12	
-401	NULL	2008-04-08	12	
-258	NULL	2008-04-08	12	
-203	NULL	2008-04-08	12	
-262	NULL	2008-04-08	12	
-348	NULL	2008-04-08	12	
-424	NULL	2008-04-08	12	
-396	NULL	2008-04-08	12	
-201	NULL	2008-04-08	12	
-217	NULL	2008-04-08	12	
-431	NULL	2008-04-08	12	
-454	NULL	2008-04-08	12	
-478	NULL	2008-04-08	12	
-298	NULL	2008-04-08	12	
-431	NULL	2008-04-08	12	
-424	NULL	2008-04-08	12	
-382	NULL	2008-04-08	12	
-397	NULL	2008-04-08	12	
-480	NULL	2008-04-08	12	
-291	NULL	2008-04-08	12	
-351	NULL	2008-04-08	12	
-255	NULL	2008-04-08	12	
-438	NULL	2008-04-08	12	
-414	NULL	2008-04-08	12	
-200	NULL	2008-04-08	12	
-491	NULL	2008-04-08	12	
-237	NULL	2008-04-08	12	
-439	NULL	2008-04-08	12	
-360	NULL	2008-04-08	12	
-248	NULL	2008-04-08	12	
-479	NULL	2008-04-08	12	
-305	NULL	2008-04-08	12	
-417	NULL	2008-04-08	12	
-444	NULL	2008-04-08	12	
-429	NULL	2008-04-08	12	
-443	NULL	2008-04-08	12	
-323	NULL	2008-04-08	12	
-325	NULL	2008-04-08	12	
-277	NULL	2008-04-08	12	
-230	NULL	2008-04-08	12	
-478	NULL	2008-04-08	12	
-468	NULL	2008-04-08	12	
-310	NULL	2008-04-08	12	
-317	NULL	2008-04-08	12	
-333	NULL	2008-04-08	12	
-493	NULL	2008-04-08	12	
-460	NULL	2008-04-08	12	
-207	NULL	2008-04-08	12	
-249	NULL	2008-04-08	12	
-265	NULL	2008-04-08	12	
-480	NULL	2008-04-08	12	
-353	NULL	2008-04-08	12	
-214	NULL	2008-04-08	12	
-462	NULL	2008-04-08	12	
-233	NULL	2008-04-08	12	
-406	NULL	2008-04-08	12	
-454	NULL	2008-04-08	12	
-375	NULL	2008-04-08	12	
-401	NULL	2008-04-08	12	
-421	NULL	2008-04-08	12	
-407	NULL	2008-04-08	12	
-384	NULL	2008-04-08	12	
-256	NULL	2008-04-08	12	
-384	NULL	2008-04-08	12	
-379	NULL	2008-04-08	12	
-462	NULL	2008-04-08	12	
-492	NULL	2008-04-08	12	
-298	NULL	2008-04-08	12	
-341	NULL	2008-04-08	12	
-498	NULL	2008-04-08	12	
-458	NULL	2008-04-08	12	
-362	NULL	2008-04-08	12	
-285	NULL	2008-04-08	12	
-348	NULL	2008-04-08	12	
-273	NULL	2008-04-08	12	
-281	NULL	2008-04-08	12	
-344	NULL	2008-04-08	12	
-469	NULL	2008-04-08	12	
-315	NULL	2008-04-08	12	
-448	NULL	2008-04-08	12	
-348	NULL	2008-04-08	12	
-307	NULL	2008-04-08	12	
-414	NULL	2008-04-08	12	
-477	NULL	2008-04-08	12	
-222	NULL	2008-04-08	12	
-403	NULL	2008-04-08	12	
-400	NULL	2008-04-08	12	
-200	NULL	2008-04-08	12	
+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: Boolean
+              Select Operator
+                expressions:
+                      expr: key
+                      type: string
+                      expr: value
+                      type: string
+                File Output Operator
+                  table:
+                      name: dest1
+                      serde: simple_meta
+                      input format: org.apache.hadoop.mapred.TextInputFormat
+                      output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+            Filter Operator
+              predicate:
+                  expr: ((key >= 100) and (key < 200))
+                  type: Boolean
+              Select Operator
+                expressions:
+                      expr: key
+                      type: string
+                      expr: value
+                      type: string
+                File Output Operator
+                  table:
+                      name: dest2
+                      serde: simple_meta
+                      input format: org.apache.hadoop.mapred.TextInputFormat
+                      output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+            Filter Operator
+              predicate:
+                  expr: (key >= 200)
+                  type: Boolean
+              Select Operator
+                expressions:
+                      expr: key
+                      type: string
+                File Output Operator
+                  table:
+                      name: dest3
+                      serde: simple_meta
+                      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: simple_meta
+                input format: org.apache.hadoop.mapred.TextInputFormat
+                output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+            replace:
+            table:
+                name: dest2
+                serde: simple_meta
+                input format: org.apache.hadoop.mapred.TextInputFormat
+                output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+            replace:
+            table:
+                name: dest3
+                serde: simple_meta
+                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
+66	val_66
+37	val_37
+15	val_15
+82	val_82
+17	val_17
+0	val_0
+57	val_57
+20	val_20
+92	val_92
+47	val_47
+72	val_72
+4	val_4
+35	val_35
+54	val_54
+51	val_51
+65	val_65
+83	val_83
+12	val_12
+67	val_67
+84	val_84
+58	val_58
+8	val_8
+24	val_24
+42	val_42
+0	val_0
+96	val_96
+26	val_26
+51	val_51
+43	val_43
+95	val_95
+98	val_98
+85	val_85
+77	val_77
+0	val_0
+87	val_87
+15	val_15
+72	val_72
+90	val_90
+19	val_19
+10	val_10
+5	val_5
+58	val_58
+35	val_35
+95	val_95
+11	val_11
+34	val_34
+42	val_42
+78	val_78
+76	val_76
+41	val_41
+30	val_30
+64	val_64
+76	val_76
+74	val_74
+69	val_69
+33	val_33
+70	val_70
+5	val_5
+2	val_2
+35	val_35
+80	val_80
+44	val_44
+53	val_53
+90	val_90
+12	val_12
+5	val_5
+70	val_70
+24	val_24
+70	val_70
+83	val_83
+26	val_26
+67	val_67
+18	val_18
+9	val_9
+18	val_18
+97	val_97
+84	val_84
+28	val_28
+37	val_37
+90	val_90
+97	val_97
+
+165	val_165
+193	val_193
+150	val_150
+128	val_128
+146	val_146
+152	val_152
+145	val_145
+166	val_166
+153	val_153
+193	val_193
+174	val_174
+199	val_199
+174	val_174
+162	val_162
+167	val_167
+195	val_195
+113	val_113
+155	val_155
+128	val_128
+149	val_149
+129	val_129
+170	val_170
+157	val_157
+111	val_111
+169	val_169
+125	val_125
+192	val_192
+187	val_187
+176	val_176
+138	val_138
+103	val_103
+176	val_176
+137	val_137
+180	val_180
+181	val_181
+138	val_138
+179	val_179
+172	val_172
+129	val_129
+158	val_158
+119	val_119
+197	val_197
+100	val_100
+199	val_199
+191	val_191
+165	val_165
+120	val_120
+131	val_131
+156	val_156
+196	val_196
+197	val_197
+187	val_187
+137	val_137
+169	val_169
+179	val_179
+118	val_118
+134	val_134
+138	val_138
+118	val_118
+177	val_177
+168	val_168
+143	val_143
+160	val_160
+195	val_195
+119	val_119
+149	val_149
+138	val_138
+103	val_103
+113	val_113
+167	val_167
+116	val_116
+191	val_191
+128	val_128
+193	val_193
+104	val_104
+175	val_175
+105	val_105
+190	val_190
+114	val_114
+164	val_164
+125	val_125
+164	val_164
+187	val_187
+104	val_104
+163	val_163
+119	val_119
+199	val_199
+120	val_120
+169	val_169
+178	val_178
+136	val_136
+172	val_172
+133	val_133
+175	val_175
+189	val_189
+134	val_134
+100	val_100
+146	val_146
+186	val_186
+167	val_167
+183	val_183
+152	val_152
+194	val_194
+126	val_126
+169	val_169
+
+238	NULL	2008-04-08	12
+311	NULL	2008-04-08	12
+409	NULL	2008-04-08	12
+255	NULL	2008-04-08	12
+278	NULL	2008-04-08	12
+484	NULL	2008-04-08	12
+265	NULL	2008-04-08	12
+401	NULL	2008-04-08	12
+273	NULL	2008-04-08	12
+224	NULL	2008-04-08	12
+369	NULL	2008-04-08	12
+213	NULL	2008-04-08	12
+406	NULL	2008-04-08	12
+429	NULL	2008-04-08	12
+374	NULL	2008-04-08	12
+469	NULL	2008-04-08	12
+495	NULL	2008-04-08	12
+327	NULL	2008-04-08	12
+281	NULL	2008-04-08	12
+277	NULL	2008-04-08	12
+209	NULL	2008-04-08	12
+403	NULL	2008-04-08	12
+417	NULL	2008-04-08	12
+430	NULL	2008-04-08	12
+252	NULL	2008-04-08	12
+292	NULL	2008-04-08	12
+219	NULL	2008-04-08	12
+287	NULL	2008-04-08	12
+338	NULL	2008-04-08	12
+446	NULL	2008-04-08	12
+459	NULL	2008-04-08	12
+394	NULL	2008-04-08	12
+237	NULL	2008-04-08	12
+482	NULL	2008-04-08	12
+413	NULL	2008-04-08	12
+494	NULL	2008-04-08	12
+207	NULL	2008-04-08	12
+466	NULL	2008-04-08	12
+208	NULL	2008-04-08	12
+399	NULL	2008-04-08	12
+396	NULL	2008-04-08	12
+247	NULL	2008-04-08	12
+417	NULL	2008-04-08	12
+489	NULL	2008-04-08	12
+377	NULL	2008-04-08	12
+397	NULL	2008-04-08	12
+309	NULL	2008-04-08	12
+365	NULL	2008-04-08	12
+266	NULL	2008-04-08	12
+439	NULL	2008-04-08	12
+342	NULL	2008-04-08	12
+367	NULL	2008-04-08	12
+325	NULL	2008-04-08	12
+475	NULL	2008-04-08	12
+203	NULL	2008-04-08	12
+339	NULL	2008-04-08	12
+455	NULL	2008-04-08	12
+311	NULL	2008-04-08	12
+316	NULL	2008-04-08	12
+302	NULL	2008-04-08	12
+205	NULL	2008-04-08	12
+438	NULL	2008-04-08	12
+345	NULL	2008-04-08	12
+489	NULL	2008-04-08	12
+378	NULL	2008-04-08	12
+221	NULL	2008-04-08	12
+280	NULL	2008-04-08	12
+427	NULL	2008-04-08	12
+277	NULL	2008-04-08	12
+208	NULL	2008-04-08	12
+356	NULL	2008-04-08	12
+399	NULL	2008-04-08	12
+382	NULL	2008-04-08	12
+498	NULL	2008-04-08	12
+386	NULL	2008-04-08	12
+437	NULL	2008-04-08	12
+469	NULL	2008-04-08	12
+286	NULL	2008-04-08	12
+459	NULL	2008-04-08	12
+239	NULL	2008-04-08	12
+213	NULL	2008-04-08	12
+216	NULL	2008-04-08	12
+430	NULL	2008-04-08	12
+278	NULL	2008-04-08	12
+289	NULL	2008-04-08	12
+221	NULL	2008-04-08	12
+318	NULL	2008-04-08	12
+332	NULL	2008-04-08	12
+311	NULL	2008-04-08	12
+275	NULL	2008-04-08	12
+241	NULL	2008-04-08	12
+333	NULL	2008-04-08	12
+284	NULL	2008-04-08	12
+230	NULL	2008-04-08	12
+260	NULL	2008-04-08	12
+404	NULL	2008-04-08	12
+384	NULL	2008-04-08	12
+489	NULL	2008-04-08	12
+353	NULL	2008-04-08	12
+373	NULL	2008-04-08	12
+272	NULL	2008-04-08	12
+217	NULL	2008-04-08	12
+348	NULL	2008-04-08	12
+466	NULL	2008-04-08	12
+411	NULL	2008-04-08	12
+230	NULL	2008-04-08	12
+208	NULL	2008-04-08	12
+348	NULL	2008-04-08	12
+463	NULL	2008-04-08	12
+431	NULL	2008-04-08	12
+496	NULL	2008-04-08	12
+322	NULL	2008-04-08	12
+468	NULL	2008-04-08	12
+393	NULL	2008-04-08	12
+454	NULL	2008-04-08	12
+298	NULL	2008-04-08	12
+418	NULL	2008-04-08	12
+327	NULL	2008-04-08	12
+230	NULL	2008-04-08	12
+205	NULL	2008-04-08	12
+404	NULL	2008-04-08	12
+436	NULL	2008-04-08	12
+469	NULL	2008-04-08	12
+468	NULL	2008-04-08	12
+308	NULL	2008-04-08	12
+288	NULL	2008-04-08	12
+481	NULL	2008-04-08	12
+457	NULL	2008-04-08	12
+282	NULL	2008-04-08	12
+318	NULL	2008-04-08	12
+318	NULL	2008-04-08	12
+409	NULL	2008-04-08	12
+470	NULL	2008-04-08	12
+369	NULL	2008-04-08	12
+316	NULL	2008-04-08	12
+413	NULL	2008-04-08	12
+490	NULL	2008-04-08	12
+364	NULL	2008-04-08	12
+395	NULL	2008-04-08	12
+282	NULL	2008-04-08	12
+238	NULL	2008-04-08	12
+419	NULL	2008-04-08	12
+307	NULL	2008-04-08	12
+435	NULL	2008-04-08	12
+277	NULL	2008-04-08	12
+273	NULL	2008-04-08	12
+306	NULL	2008-04-08	12
+224	NULL	2008-04-08	12
+309	NULL	2008-04-08	12
+389	NULL	2008-04-08	12
+327	NULL	2008-04-08	12
+242	NULL	2008-04-08	12
+369	NULL	2008-04-08	12
+392	NULL	2008-04-08	12
+272	NULL	2008-04-08	12
+331	NULL	2008-04-08	12
+401	NULL	2008-04-08	12
+242	NULL	2008-04-08	12
+452	NULL	2008-04-08	12
+226	NULL	2008-04-08	12
+497	NULL	2008-04-08	12
+402	NULL	2008-04-08	12
+396	NULL	2008-04-08	12
+317	NULL	2008-04-08	12
+395	NULL	2008-04-08	12
+336	NULL	2008-04-08	12
+229	NULL	2008-04-08	12
+233	NULL	2008-04-08	12
+472	NULL	2008-04-08	12
+322	NULL	2008-04-08	12
+498	NULL	2008-04-08	12
+321	NULL	2008-04-08	12
+430	NULL	2008-04-08	12
+489	NULL	2008-04-08	12
+458	NULL	2008-04-08	12
+223	NULL	2008-04-08	12
+492	NULL	2008-04-08	12
+449	NULL	2008-04-08	12
+218	NULL	2008-04-08	12
+228	NULL	2008-04-08	12
+453	NULL	2008-04-08	12
+209	NULL	2008-04-08	12
+468	NULL	2008-04-08	12
+342	NULL	2008-04-08	12
+230	NULL	2008-04-08	12
+368	NULL	2008-04-08	12
+296	NULL	2008-04-08	12
+216	NULL	2008-04-08	12
+367	NULL	2008-04-08	12
+344	NULL	2008-04-08	12
+274	NULL	2008-04-08	12
+219	NULL	2008-04-08	12
+239	NULL	2008-04-08	12
+485	NULL	2008-04-08	12
+223	NULL	2008-04-08	12
+256	NULL	2008-04-08	12
+263	NULL	2008-04-08	12
+487	NULL	2008-04-08	12
+480	NULL	2008-04-08	12
+401	NULL	2008-04-08	12
+288	NULL	2008-04-08	12
+244	NULL	2008-04-08	12
+438	NULL	2008-04-08	12
+467	NULL	2008-04-08	12
+432	NULL	2008-04-08	12
+202	NULL	2008-04-08	12
+316	NULL	2008-04-08	12
+229	NULL	2008-04-08	12
+469	NULL	2008-04-08	12
+463	NULL	2008-04-08	12
+280	NULL	2008-04-08	12
+283	NULL	2008-04-08	12
+331	NULL	2008-04-08	12
+235	NULL	2008-04-08	12
+321	NULL	2008-04-08	12
+335	NULL	2008-04-08	12
+466	NULL	2008-04-08	12
+366	NULL	2008-04-08	12
+403	NULL	2008-04-08	12
+483	NULL	2008-04-08	12
+257	NULL	2008-04-08	12
+406	NULL	2008-04-08	12
+409	NULL	2008-04-08	12
+406	NULL	2008-04-08	12
+401	NULL	2008-04-08	12
+258	NULL	2008-04-08	12
+203	NULL	2008-04-08	12
+262	NULL	2008-04-08	12
+348	NULL	2008-04-08	12
+424	NULL	2008-04-08	12
+396	NULL	2008-04-08	12
+201	NULL	2008-04-08	12
+217	NULL	2008-04-08	12
+431	NULL	2008-04-08	12
+454	NULL	2008-04-08	12
+478	NULL	2008-04-08	12
+298	NULL	2008-04-08	12
+431	NULL	2008-04-08	12
+424	NULL	2008-04-08	12
+382	NULL	2008-04-08	12
+397	NULL	2008-04-08	12
+480	NULL	2008-04-08	12
+291	NULL	2008-04-08	12
+351	NULL	2008-04-08	12
+255	NULL	2008-04-08	12
+438	NULL	2008-04-08	12
+414	NULL	2008-04-08	12
+200	NULL	2008-04-08	12
+491	NULL	2008-04-08	12
+237	NULL	2008-04-08	12
+439	NULL	2008-04-08	12
+360	NULL	2008-04-08	12
+248	NULL	2008-04-08	12
+479	NULL	2008-04-08	12
+305	NULL	2008-04-08	12
+417	NULL	2008-04-08	12
+444	NULL	2008-04-08	12
+429	NULL	2008-04-08	12
+443	NULL	2008-04-08	12
+323	NULL	2008-04-08	12
+325	NULL	2008-04-08	12
+277	NULL	2008-04-08	12
+230	NULL	2008-04-08	12
+478	NULL	2008-04-08	12
+468	NULL	2008-04-08	12
+310	NULL	2008-04-08	12
+317	NULL	2008-04-08	12
+333	NULL	2008-04-08	12
+493	NULL	2008-04-08	12
+460	NULL	2008-04-08	12
+207	NULL	2008-04-08	12
+249	NULL	2008-04-08	12
+265	NULL	2008-04-08	12
+480	NULL	2008-04-08	12
+353	NULL	2008-04-08	12
+214	NULL	2008-04-08	12
+462	NULL	2008-04-08	12
+233	NULL	2008-04-08	12
+406	NULL	2008-04-08	12
+454	NULL	2008-04-08	12
+375	NULL	2008-04-08	12
+401	NULL	2008-04-08	12
+421	NULL	2008-04-08	12
+407	NULL	2008-04-08	12
+384	NULL	2008-04-08	12
+256	NULL	2008-04-08	12
+384	NULL	2008-04-08	12
+379	NULL	2008-04-08	12
+462	NULL	2008-04-08	12
+492	NULL	2008-04-08	12
+298	NULL	2008-04-08	12
+341	NULL	2008-04-08	12
+498	NULL	2008-04-08	12
+458	NULL	2008-04-08	12
+362	NULL	2008-04-08	12
+285	NULL	2008-04-08	12
+348	NULL	2008-04-08	12
+273	NULL	2008-04-08	12
+281	NULL	2008-04-08	12
+344	NULL	2008-04-08	12
+469	NULL	2008-04-08	12
+315	NULL	2008-04-08	12
+448	NULL	2008-04-08	12
+348	NULL	2008-04-08	12
+307	NULL	2008-04-08	12
+414	NULL	2008-04-08	12
+477	NULL	2008-04-08	12
+222	NULL	2008-04-08	12
+403	NULL	2008-04-08	12
+400	NULL	2008-04-08	12
+200	NULL	2008-04-08	12
+

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=697291&r1=697290&r2=697291&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 Fri Sep 19 16:56:30 2008
@@ -1,394 +1,398 @@
-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	
-66	val_66	
-37	val_37	
-15	val_15	
-82	val_82	
-17	val_17	
-0	val_0	
-57	val_57	
-20	val_20	
-92	val_92	
-47	val_47	
-72	val_72	
-4	val_4	
-35	val_35	
-54	val_54	
-51	val_51	
-65	val_65	
-83	val_83	
-12	val_12	
-67	val_67	
-84	val_84	
-58	val_58	
-8	val_8	
-24	val_24	
-42	val_42	
-0	val_0	
-96	val_96	
-26	val_26	
-51	val_51	
-43	val_43	
-95	val_95	
-98	val_98	
-85	val_85	
-77	val_77	
-0	val_0	
-87	val_87	
-15	val_15	
-72	val_72	
-90	val_90	
-19	val_19	
-10	val_10	
-5	val_5	
-58	val_58	
-35	val_35	
-95	val_95	
-11	val_11	
-34	val_34	
-42	val_42	
-78	val_78	
-76	val_76	
-41	val_41	
-30	val_30	
-64	val_64	
-76	val_76	
-74	val_74	
-69	val_69	
-33	val_33	
-70	val_70	
-5	val_5	
-2	val_2	
-35	val_35	
-80	val_80	
-44	val_44	
-53	val_53	
-90	val_90	
-12	val_12	
-5	val_5	
-70	val_70	
-24	val_24	
-70	val_70	
-83	val_83	
-26	val_26	
-67	val_67	
-18	val_18	
-9	val_9	
-18	val_18	
-97	val_97	
-84	val_84	
-28	val_28	
-37	val_37	
-90	val_90	
-97	val_97	
-165	val_165	
-193	val_193	
-150	val_150	
-128	val_128	
-146	val_146	
-152	val_152	
-145	val_145	
-166	val_166	
-153	val_153	
-193	val_193	
-174	val_174	
-199	val_199	
-174	val_174	
-162	val_162	
-167	val_167	
-195	val_195	
-113	val_113	
-155	val_155	
-128	val_128	
-149	val_149	
-129	val_129	
-170	val_170	
-157	val_157	
-111	val_111	
-169	val_169	
-125	val_125	
-192	val_192	
-187	val_187	
-176	val_176	
-138	val_138	
-103	val_103	
-176	val_176	
-137	val_137	
-180	val_180	
-181	val_181	
-138	val_138	
-179	val_179	
-172	val_172	
-129	val_129	
-158	val_158	
-119	val_119	
-197	val_197	
-100	val_100	
-199	val_199	
-191	val_191	
-165	val_165	
-120	val_120	
-131	val_131	
-156	val_156	
-196	val_196	
-197	val_197	
-187	val_187	
-137	val_137	
-169	val_169	
-179	val_179	
-118	val_118	
-134	val_134	
-138	val_138	
-118	val_118	
-177	val_177	
-168	val_168	
-143	val_143	
-160	val_160	
-195	val_195	
-119	val_119	
-149	val_149	
-138	val_138	
-103	val_103	
-113	val_113	
-167	val_167	
-116	val_116	
-191	val_191	
-128	val_128	
-193	val_193	
-104	val_104	
-175	val_175	
-105	val_105	
-190	val_190	
-114	val_114	
-164	val_164	
-125	val_125	
-164	val_164	
-187	val_187	
-104	val_104	
-163	val_163	
-119	val_119	
-199	val_199	
-120	val_120	
-169	val_169	
-178	val_178	
-136	val_136	
-172	val_172	
-133	val_133	
-175	val_175	
-189	val_189	
-134	val_134	
-100	val_100	
-146	val_146	
-186	val_186	
-167	val_167	
-183	val_183	
-152	val_152	
-194	val_194	
-126	val_126	
-169	val_169	
-238	NULL	2008-04-08	12	
-255	NULL	2008-04-08	12	
-278	NULL	2008-04-08	12	
-265	NULL	2008-04-08	12	
-273	NULL	2008-04-08	12	
-224	NULL	2008-04-08	12	
-213	NULL	2008-04-08	12	
-281	NULL	2008-04-08	12	
-277	NULL	2008-04-08	12	
-209	NULL	2008-04-08	12	
-252	NULL	2008-04-08	12	
-292	NULL	2008-04-08	12	
-219	NULL	2008-04-08	12	
-287	NULL	2008-04-08	12	
-237	NULL	2008-04-08	12	
-207	NULL	2008-04-08	12	
-208	NULL	2008-04-08	12	
-247	NULL	2008-04-08	12	
-266	NULL	2008-04-08	12	
-203	NULL	2008-04-08	12	
-205	NULL	2008-04-08	12	
-221	NULL	2008-04-08	12	
-280	NULL	2008-04-08	12	
-277	NULL	2008-04-08	12	
-208	NULL	2008-04-08	12	
-286	NULL	2008-04-08	12	
-239	NULL	2008-04-08	12	
-213	NULL	2008-04-08	12	
-216	NULL	2008-04-08	12	
-278	NULL	2008-04-08	12	
-289	NULL	2008-04-08	12	
-221	NULL	2008-04-08	12	
-275	NULL	2008-04-08	12	
-241	NULL	2008-04-08	12	
-284	NULL	2008-04-08	12	
-230	NULL	2008-04-08	12	
-260	NULL	2008-04-08	12	
-272	NULL	2008-04-08	12	
-217	NULL	2008-04-08	12	
-230	NULL	2008-04-08	12	
-208	NULL	2008-04-08	12	
-298	NULL	2008-04-08	12	
-230	NULL	2008-04-08	12	
-205	NULL	2008-04-08	12	
-288	NULL	2008-04-08	12	
-282	NULL	2008-04-08	12	
-282	NULL	2008-04-08	12	
-238	NULL	2008-04-08	12	
-277	NULL	2008-04-08	12	
-273	NULL	2008-04-08	12	
-224	NULL	2008-04-08	12	
-242	NULL	2008-04-08	12	
-272	NULL	2008-04-08	12	
-242	NULL	2008-04-08	12	
-226	NULL	2008-04-08	12	
-229	NULL	2008-04-08	12	
-233	NULL	2008-04-08	12	
-223	NULL	2008-04-08	12	
-218	NULL	2008-04-08	12	
-228	NULL	2008-04-08	12	
-209	NULL	2008-04-08	12	
-230	NULL	2008-04-08	12	
-296	NULL	2008-04-08	12	
-216	NULL	2008-04-08	12	
-274	NULL	2008-04-08	12	
-219	NULL	2008-04-08	12	
-239	NULL	2008-04-08	12	
-223	NULL	2008-04-08	12	
-256	NULL	2008-04-08	12	
-263	NULL	2008-04-08	12	
-288	NULL	2008-04-08	12	
-244	NULL	2008-04-08	12	
-202	NULL	2008-04-08	12	
-229	NULL	2008-04-08	12	
-280	NULL	2008-04-08	12	
-283	NULL	2008-04-08	12	
-235	NULL	2008-04-08	12	
-257	NULL	2008-04-08	12	
-258	NULL	2008-04-08	12	
-203	NULL	2008-04-08	12	
-262	NULL	2008-04-08	12	
-201	NULL	2008-04-08	12	
-217	NULL	2008-04-08	12	
-298	NULL	2008-04-08	12	
-291	NULL	2008-04-08	12	
-255	NULL	2008-04-08	12	
-200	NULL	2008-04-08	12	
-237	NULL	2008-04-08	12	
-248	NULL	2008-04-08	12	
-277	NULL	2008-04-08	12	
-230	NULL	2008-04-08	12	
-207	NULL	2008-04-08	12	
-249	NULL	2008-04-08	12	
-265	NULL	2008-04-08	12	
-214	NULL	2008-04-08	12	
-233	NULL	2008-04-08	12	
-256	NULL	2008-04-08	12	
-298	NULL	2008-04-08	12	
-285	NULL	2008-04-08	12	
-273	NULL	2008-04-08	12	
-281	NULL	2008-04-08	12	
-222	NULL	2008-04-08	12	
-200	NULL	2008-04-08	12	
+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: Boolean
+              Select Operator
+                expressions:
+                      expr: key
+                      type: string
+                      expr: value
+                      type: string
+                File Output Operator
+                  table:
+                      name: dest1
+                      serde: simple_meta
+                      input format: org.apache.hadoop.mapred.TextInputFormat
+                      output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+            Filter Operator
+              predicate:
+                  expr: ((key >= 100) and (key < 200))
+                  type: Boolean
+              Select Operator
+                expressions:
+                      expr: key
+                      type: string
+                      expr: value
+                      type: string
+                File Output Operator
+                  table:
+                      name: dest2
+                      serde: simple_meta
+                      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: Boolean
+              Select Operator
+                expressions:
+                      expr: key
+                      type: string
+                File Output Operator
+                  table:
+                      name: dest3
+                      serde: simple_meta
+                      input format: org.apache.hadoop.mapred.TextInputFormat
+                      output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+            Filter Operator
+              predicate:
+                  expr: (key >= 300)
+                  type: Boolean
+              Select Operator
+                expressions:
+                      expr: value
+                      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
+    Move Operator
+      tables:
+            table:
+                name: dest1
+                serde: simple_meta
+                input format: org.apache.hadoop.mapred.TextInputFormat
+                output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+            replace:
+            table:
+                name: dest2
+                serde: simple_meta
+                input format: org.apache.hadoop.mapred.TextInputFormat
+                output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+            replace:
+            table:
+                name: dest3
+                serde: simple_meta
+                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
+66	val_66
+37	val_37
+15	val_15
+82	val_82
+17	val_17
+0	val_0
+57	val_57
+20	val_20
+92	val_92
+47	val_47
+72	val_72
+4	val_4
+35	val_35
+54	val_54
+51	val_51
+65	val_65
+83	val_83
+12	val_12
+67	val_67
+84	val_84
+58	val_58
+8	val_8
+24	val_24
+42	val_42
+0	val_0
+96	val_96
+26	val_26
+51	val_51
+43	val_43
+95	val_95
+98	val_98
+85	val_85
+77	val_77
+0	val_0
+87	val_87
+15	val_15
+72	val_72
+90	val_90
+19	val_19
+10	val_10
+5	val_5
+58	val_58
+35	val_35
+95	val_95
+11	val_11
+34	val_34
+42	val_42
+78	val_78
+76	val_76
+41	val_41
+30	val_30
+64	val_64
+76	val_76
+74	val_74
+69	val_69
+33	val_33
+70	val_70
+5	val_5
+2	val_2
+35	val_35
+80	val_80
+44	val_44
+53	val_53
+90	val_90
+12	val_12
+5	val_5
+70	val_70
+24	val_24
+70	val_70
+83	val_83
+26	val_26
+67	val_67
+18	val_18
+9	val_9
+18	val_18
+97	val_97
+84	val_84
+28	val_28
+37	val_37
+90	val_90
+97	val_97
+
+165	val_165
+193	val_193
+150	val_150
+128	val_128
+146	val_146
+152	val_152
+145	val_145
+166	val_166
+153	val_153
+193	val_193
+174	val_174
+199	val_199
+174	val_174
+162	val_162
+167	val_167
+195	val_195
+113	val_113
+155	val_155
+128	val_128
+149	val_149
+129	val_129
+170	val_170
+157	val_157
+111	val_111
+169	val_169
+125	val_125
+192	val_192
+187	val_187
+176	val_176
+138	val_138
+103	val_103
+176	val_176
+137	val_137
+180	val_180
+181	val_181
+138	val_138
+179	val_179
+172	val_172
+129	val_129
+158	val_158
+119	val_119
+197	val_197
+100	val_100
+199	val_199
+191	val_191
+165	val_165
+120	val_120
+131	val_131
+156	val_156
+196	val_196
+197	val_197
+187	val_187
+137	val_137
+169	val_169
+179	val_179
+118	val_118
+134	val_134
+138	val_138
+118	val_118
+177	val_177
+168	val_168
+143	val_143
+160	val_160
+195	val_195
+119	val_119
+149	val_149
+138	val_138
+103	val_103
+113	val_113
+167	val_167
+116	val_116
+191	val_191
+128	val_128
+193	val_193
+104	val_104
+175	val_175
+105	val_105
+190	val_190
+114	val_114
+164	val_164
+125	val_125
+164	val_164
+187	val_187
+104	val_104
+163	val_163
+119	val_119
+199	val_199
+120	val_120
+169	val_169
+178	val_178
+136	val_136
+172	val_172
+133	val_133
+175	val_175
+189	val_189
+134	val_134
+100	val_100
+146	val_146
+186	val_186
+167	val_167
+183	val_183
+152	val_152
+194	val_194
+126	val_126
+169	val_169
+
+238	NULL	2008-04-08	12
+255	NULL	2008-04-08	12
+278	NULL	2008-04-08	12
+265	NULL	2008-04-08	12
+273	NULL	2008-04-08	12
+224	NULL	2008-04-08	12
+213	NULL	2008-04-08	12
+281	NULL	2008-04-08	12
+277	NULL	2008-04-08	12
+209	NULL	2008-04-08	12
+252	NULL	2008-04-08	12
+292	NULL	2008-04-08	12
+219	NULL	2008-04-08	12
+287	NULL	2008-04-08	12
+237	NULL	2008-04-08	12
+207	NULL	2008-04-08	12
+208	NULL	2008-04-08	12
+247	NULL	2008-04-08	12
+266	NULL	2008-04-08	12
+203	NULL	2008-04-08	12
+205	NULL	2008-04-08	12
+221	NULL	2008-04-08	12
+280	NULL	2008-04-08	12
+277	NULL	2008-04-08	12
+208	NULL	2008-04-08	12
+286	NULL	2008-04-08	12
+239	NULL	2008-04-08	12
+213	NULL	2008-04-08	12
+216	NULL	2008-04-08	12
+278	NULL	2008-04-08	12
+289	NULL	2008-04-08	12
+221	NULL	2008-04-08	12
+275	NULL	2008-04-08	12
+241	NULL	2008-04-08	12
+284	NULL	2008-04-08	12
+230	NULL	2008-04-08	12
+260	NULL	2008-04-08	12
+272	NULL	2008-04-08	12
+217	NULL	2008-04-08	12
+230	NULL	2008-04-08	12
+208	NULL	2008-04-08	12
+298	NULL	2008-04-08	12
+230	NULL	2008-04-08	12
+205	NULL	2008-04-08	12
+288	NULL	2008-04-08	12
+282	NULL	2008-04-08	12
+282	NULL	2008-04-08	12
+238	NULL	2008-04-08	12
+277	NULL	2008-04-08	12
+273	NULL	2008-04-08	12
+224	NULL	2008-04-08	12
+242	NULL	2008-04-08	12
+272	NULL	2008-04-08	12
+242	NULL	2008-04-08	12
+226	NULL	2008-04-08	12
+229	NULL	2008-04-08	12
+233	NULL	2008-04-08	12
+223	NULL	2008-04-08	12
+218	NULL	2008-04-08	12
+228	NULL	2008-04-08	12
+209	NULL	2008-04-08	12
+230	NULL	2008-04-08	12
+296	NULL	2008-04-08	12
+216	NULL	2008-04-08	12
+274	NULL	2008-04-08	12
+219	NULL	2008-04-08	12
+239	NULL	2008-04-08	12
+223	NULL	2008-04-08	12
+256	NULL	2008-04-08	12
+263	NULL	2008-04-08	12
+288	NULL	2008-04-08	12
+244	NULL	2008-04-08	12
+202	NULL	2008-04-08	12
+229	NULL	2008-04-08	12
+280	NULL	2008-04-08	12
+283	NULL	2008-04-08	12
+235	NULL	2008-04-08	12
+257	NULL	2008-04-08	12
+258	NULL	2008-04-08	12
+203	NULL	2008-04-08	12
+262	NULL	2008-04-08	12
+201	NULL	2008-04-08	12
+217	NULL	2008-04-08	12
+298	NULL	2008-04-08	12
+291	NULL	2008-04-08	12
+255	NULL	2008-04-08	12
+200	NULL	2008-04-08	12
+237	NULL	2008-04-08	12
+248	NULL	2008-04-08	12
+277	NULL	2008-04-08	12
+230	NULL	2008-04-08	12
+207	NULL	2008-04-08	12
+249	NULL	2008-04-08	12
+265	NULL	2008-04-08	12
+214	NULL	2008-04-08	12
+233	NULL	2008-04-08	12
+256	NULL	2008-04-08	12
+298	NULL	2008-04-08	12
+285	NULL	2008-04-08	12
+273	NULL	2008-04-08	12
+281	NULL	2008-04-08	12
+222	NULL	2008-04-08	12
+200	NULL	2008-04-08	12
+
 val_311
 val_409
 val_484

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=697291&r1=697290&r2=697291&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 Fri Sep 19 16:56:30 2008
@@ -1,147 +1,149 @@
-ABSTRACT SYNTAX TREE:	
-  (TOK_QUERY (TOK_FROM (TOK_SUBQUERY (TOK_QUERY (TOK_FROM (TOK_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	
-10	val_10	
-11	val_11	
-12	val_12	
-12	val_12	
-15	val_15	
-15	val_15	
-17	val_17	
-18	val_18	
-18	val_18	
-19	val_19	
-2	val_2	
-20	val_20	
-24	val_24	
-24	val_24	
-26	val_26	
-26	val_26	
-27	val_27	
-28	val_28	
-30	val_30	
-33	val_33	
-34	val_34	
-35	val_35	
-35	val_35	
-35	val_35	
-37	val_37	
-37	val_37	
-4	val_4	
-41	val_41	
-42	val_42	
-42	val_42	
-43	val_43	
-44	val_44	
-47	val_47	
-5	val_5	
-5	val_5	
-5	val_5	
-51	val_51	
-51	val_51	
-53	val_53	
-54	val_54	
-57	val_57	
-58	val_58	
-58	val_58	
-64	val_64	
-65	val_65	
-66	val_66	
-67	val_67	
-67	val_67	
-69	val_69	
-70	val_70	
-70	val_70	
-70	val_70	
-72	val_72	
-72	val_72	
-74	val_74	
-76	val_76	
-76	val_76	
-77	val_77	
-78	val_78	
-8	val_8	
-80	val_80	
-82	val_82	
-83	val_83	
-83	val_83	
-84	val_84	
-84	val_84	
-85	val_85	
-86	val_86	
-87	val_87	
-9	val_9	
-90	val_90	
-90	val_90	
-90	val_90	
-92	val_92	
-95	val_95	
-95	val_95	
-96	val_96	
-97	val_97	
-97	val_97	
-98	val_98	
-98	val_98	
+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: Boolean
+            Select Operator
+              expressions:
+                    expr: 0
+                    type: string
+                    expr: 1
+                    type: string
+              File Output Operator
+                table:
+                    name: dest1
+                    serde: simple_meta
+                    input format: org.apache.hadoop.mapred.TextInputFormat
+                    output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+      Alias -> Map Operator Tree:
+        tmap:src 
+            Select Operator
+              expressions:
+                    expr: key
+                    type: string
+                    expr: value
+                    type: 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: string
+                  value expressions:
+                        expr: tkey
+                        type: string
+                        expr: tvalue
+                        type: string
+                  # partition fields: 1
+
+  Stage: Stage-0
+    Move Operator
+      tables:
+            table:
+                name: dest1
+                serde: simple_meta
+                input format: org.apache.hadoop.mapred.TextInputFormat
+                output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+            replace:
+
+
+0	val_0
+0	val_0
+0	val_0
+10	val_10
+11	val_11
+12	val_12
+12	val_12
+15	val_15
+15	val_15
+17	val_17
+18	val_18
+18	val_18
+19	val_19
+2	val_2
+20	val_20
+24	val_24
+24	val_24
+26	val_26
+26	val_26
+27	val_27
+28	val_28
+30	val_30
+33	val_33
+34	val_34
+35	val_35
+35	val_35
+35	val_35
+37	val_37
+37	val_37
+4	val_4
+41	val_41
+42	val_42
+42	val_42
+43	val_43
+44	val_44
+47	val_47
+5	val_5
+5	val_5
+5	val_5
+51	val_51
+51	val_51
+53	val_53
+54	val_54
+57	val_57
+58	val_58
+58	val_58
+64	val_64
+65	val_65
+66	val_66
+67	val_67
+67	val_67
+69	val_69
+70	val_70
+70	val_70
+70	val_70
+72	val_72
+72	val_72
+74	val_74
+76	val_76
+76	val_76
+77	val_77
+78	val_78
+8	val_8
+80	val_80
+82	val_82
+83	val_83
+83	val_83
+84	val_84
+84	val_84
+85	val_85
+86	val_86
+87	val_87
+9	val_9
+90	val_90
+90	val_90
+90	val_90
+92	val_92
+95	val_95
+95	val_95
+96	val_96
+97	val_97
+97	val_97
+98	val_98
+98	val_98
+

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=697291&r1=697290&r2=697291&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 Fri Sep 19 16:56:30 2008
@@ -1,18 +1,20 @@
-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	
+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
+          # buckets: -1
+          field delimiter: 	
+          isSequenceFile:
+          columns: key int, value string
+
+
+key	int
+value	string

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=697291&r1=697290&r2=697291&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 Fri Sep 19 16:56:30 2008
@@ -1,18 +1,19 @@
-a	int	
-b	float	
-a	array<int>	
-b	float	
-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	
-	
+a	int
+b	float
+a	array<int>
+b	float
+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 Table Operator:
+        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=697291&r1=697290&r2=697291&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 Fri Sep 19 16:56:30 2008
@@ -1,43 +1,45 @@
-a	int	
-b	float	
-a	array<int>	
-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>	
-x	float	
-src	src1	src_sequencefile	src_thrift	srcbucket	srcpart	test3a	test3c	
+a	int
+b	float
+a	array<int>
+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 Operator:
+        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 Operator:
+        Alter Table
+          old name: TEST3b
+          new name: TEST3c
+          type: rename
+
+
+a	array<int>
+b	float
+c	map<float,int>
+x	float
+src	src1	src_sequencefile	src_thrift	srcbucket	srcpart	test3a	test3c

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

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=697291&r1=697290&r2=697291&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 Fri Sep 19 16:56:30 2008
@@ -1,69 +1,71 @@
-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"}}]	
-[3,6,9]	[{"1":{"i32":9},"2":{"str":"27"}}]	
-[4,8,12]	[{"1":{"i32":16},"2":{"str":"64"}}]	
-[5,10,15]	[{"1":{"i32":25},"2":{"str":"125"}}]	
-[6,12,18]	[{"1":{"i32":36},"2":{"str":"216"}}]	
-[7,14,21]	[{"1":{"i32":49},"2":{"str":"343"}}]	
-[8,16,24]	[{"1":{"i32":64},"2":{"str":"512"}}]	
-[9,18,27]	[{"1":{"i32":81},"2":{"str":"729"}}]	
+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: string
+                  expr: 1
+                  type: string
+            File Output Operator
+              table:
+                  name: dest1
+                  serde: simple_meta
+                  input format: org.apache.hadoop.mapred.TextInputFormat
+                  output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+      Alias -> Map Operator Tree:
+        tmap:src_thrift 
+            Select Operator
+              expressions:
+                    expr: lint
+                    type: array<int>
+                    expr: lintstring
+                    type: array<struct{myint:int,mystring: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: string
+                  value expressions:
+                        expr: tkey
+                        type: string
+                        expr: tvalue
+                        type: string
+                  # partition fields: 1
+
+  Stage: Stage-0
+    Move Operator
+      tables:
+            table:
+                name: dest1
+                serde: simple_meta
+                input format: org.apache.hadoop.mapred.TextInputFormat
+                output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+            replace:
+
+
+[0,0,0]	[{"myint":0,"mystring":"0"}]
+[1,2,3]	[{"myint":1,"mystring":"1"}]
+[2,4,6]	[{"myint":4,"mystring":"8"}]
+[3,6,9]	[{"myint":9,"mystring":"27"}]
+[4,8,12]	[{"myint":16,"mystring":"64"}]
+[5,10,15]	[{"myint":25,"mystring":"125"}]
+[6,12,18]	[{"myint":36,"mystring":"216"}]
+[7,14,21]	[{"myint":49,"mystring":"343"}]
+[8,16,24]	[{"myint":64,"mystring":"512"}]
+[9,18,27]	[{"myint":81,"mystring":"729"}]
+

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=697291&r1=697290&r2=697291&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 Fri Sep 19 16:56:30 2008
@@ -1,39 +1,40 @@
-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:	
-	
+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: Boolean
+              Select Operator
+                expressions:
+                      expr: key
+                      type: string
+                      expr: value
+                      type: string
+                File Output Operator
+                  table:
+                      name: dest1
+                      serde: simple_meta
+                      input format: org.apache.hadoop.mapred.TextInputFormat
+                      output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+
+  Stage: Stage-0
+    Move Operator
+      tables:
+            table:
+                name: dest1
+                serde: simple_meta
+                input format: org.apache.hadoop.mapred.TextInputFormat
+                output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+            replace:
+
+



Mime
View raw message