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 [15/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/groupby1.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/groupby1.q.out?rev=697291&r1=697290&r2=697291&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/groupby1.q.out (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/groupby1.q.out Fri Sep 19 16:56:30 2008
@@ -1,388 +1,396 @@
-ABSTRACT SYNTAX TREE:	
-  (TOK_QUERY (TOK_FROM (TOK_TABREF src)) (TOK_INSERT (TOK_DESTINATION (TOK_TAB dest1)) (TOK_SELECT (TOK_SELEXPR (TOK_COLREF src key)) (TOK_SELEXPR (TOK_FUNCTION sum (TOK_FUNCTION substr (TOK_COLREF src value) 4)))) (TOK_GROUPBY (TOK_COLREF src key))))	
-	
-STAGE DEPENDENCIES:	
-  Stage-1 is a root stage	
-  Stage-2 depends on stages: Stage-1	
-  Stage-0 depends on stages: Stage-2	
-	
-STAGE PLANS:	
-  Stage: Stage-1	
-    Map Reduce	
-      Reduce Operator Tree:	
-        Group By Operator	
-          keys:	
-                expr: KEY.0	
-                type: class java.lang.String	
-          mode: partial1	
-        	
-              expr: sum(VALUE.0)	
-          File Output Operator	
-            table:	
-                input format: org.apache.hadoop.mapred.TextInputFormat	
-                output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat	
-      Alias -> Map Operator Tree:	
-        src 	
-            Reduce Output Operator	
-              tag: -1	
-              key expressions:	
-                    expr: key	
-                    type: class java.lang.String	
-              value expressions:	
-                    expr: substr(value, 4)	
-                    type: class java.lang.String	
-              # partition fields: -1	
-	
-  Stage: Stage-2	
-    Map Reduce	
-      Reduce Operator Tree:	
-        Group By Operator	
-          keys:	
-                expr: KEY.0	
-                type: class java.lang.String	
-          mode: partial2	
-        	
-              expr: sum(VALUE.0)	
-          Select Operator	
-            expressions:	
-                  expr: 0	
-                  type: class java.lang.String	
-                  expr: 1	
-                  type: class java.lang.String	
-            File Output Operator	
-              table:	
-                  name: dest1	
-                  serde: org.apache.hadoop.hive.serde.simple_meta.MetadataTypedColumnsetSerDe	
-                  input format: org.apache.hadoop.mapred.TextInputFormat	
-                  output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat	
-      Alias -> Map Operator Tree:	
-        /tmp/hive-athusoo/51044615.10001 	
-          Reduce Output Operator	
-            tag: -1	
-            key expressions:	
-                  expr: 0	
-                  type: class java.lang.String	
-            value expressions:	
-                  expr: 1	
-                  type: class java.lang.String	
-            # partition fields: 1	
-	
-  Stage: Stage-0	
-    Move Operator	
-      tables:	
-            table:	
-                name: dest1	
-                serde: org.apache.hadoop.hive.serde.simple_meta.MetadataTypedColumnsetSerDe	
-                input format: org.apache.hadoop.mapred.TextInputFormat	
-                output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat	
-            replace:	
-	
-0	0.0	
-10	10.0	
-100	200.0	
-103	206.0	
-104	208.0	
-105	105.0	
-11	11.0	
-111	111.0	
-113	226.0	
-114	114.0	
-116	116.0	
-118	236.0	
-119	357.0	
-12	24.0	
-120	240.0	
-125	250.0	
-126	126.0	
-128	384.0	
-129	258.0	
-131	131.0	
-133	133.0	
-134	268.0	
-136	136.0	
-137	274.0	
-138	552.0	
-143	143.0	
-145	145.0	
-146	292.0	
-149	298.0	
-15	30.0	
-150	150.0	
-152	304.0	
-153	153.0	
-155	155.0	
-156	156.0	
-157	157.0	
-158	158.0	
-160	160.0	
-162	162.0	
-163	163.0	
-164	328.0	
-165	330.0	
-166	166.0	
-167	501.0	
-168	168.0	
-169	676.0	
-17	17.0	
-170	170.0	
-172	344.0	
-174	348.0	
-175	350.0	
-176	352.0	
-177	177.0	
-178	178.0	
-179	358.0	
-18	36.0	
-180	180.0	
-181	181.0	
-183	183.0	
-186	186.0	
-187	561.0	
-189	189.0	
-19	19.0	
-190	190.0	
-191	382.0	
-192	192.0	
-193	579.0	
-194	194.0	
-195	390.0	
-196	196.0	
-197	394.0	
-199	597.0	
-2	2.0	
-20	20.0	
-200	400.0	
-201	201.0	
-202	202.0	
-203	406.0	
-205	410.0	
-207	414.0	
-208	624.0	
-209	418.0	
-213	426.0	
-214	214.0	
-216	432.0	
-217	434.0	
-218	218.0	
-219	438.0	
-221	442.0	
-222	222.0	
-223	446.0	
-224	448.0	
-226	226.0	
-228	228.0	
-229	458.0	
-230	1150.0	
-233	466.0	
-235	235.0	
-237	474.0	
-238	476.0	
-239	478.0	
-24	48.0	
-241	241.0	
-242	484.0	
-244	244.0	
-247	247.0	
-248	248.0	
-249	249.0	
-252	252.0	
-255	510.0	
-256	512.0	
-257	257.0	
-258	258.0	
-26	52.0	
-260	260.0	
-262	262.0	
-263	263.0	
-265	530.0	
-266	266.0	
-27	27.0	
-272	544.0	
-273	819.0	
-274	274.0	
-275	275.0	
-277	1108.0	
-278	556.0	
-28	28.0	
-280	560.0	
-281	562.0	
-282	564.0	
-283	283.0	
-284	284.0	
-285	285.0	
-286	286.0	
-287	287.0	
-288	576.0	
-289	289.0	
-291	291.0	
-292	292.0	
-296	296.0	
-298	894.0	
-30	30.0	
-302	302.0	
-305	305.0	
-306	306.0	
-307	614.0	
-308	308.0	
-309	618.0	
-310	310.0	
-311	933.0	
-315	315.0	
-316	948.0	
-317	634.0	
-318	954.0	
-321	642.0	
-322	644.0	
-323	323.0	
-325	650.0	
-327	981.0	
-33	33.0	
-331	662.0	
-332	332.0	
-333	666.0	
-335	335.0	
-336	336.0	
-338	338.0	
-339	339.0	
-34	34.0	
-341	341.0	
-342	684.0	
-344	688.0	
-345	345.0	
-348	1740.0	
-35	105.0	
-351	351.0	
-353	706.0	
-356	356.0	
-360	360.0	
-362	362.0	
-364	364.0	
-365	365.0	
-366	366.0	
-367	734.0	
-368	368.0	
-369	1107.0	
-37	74.0	
-373	373.0	
-374	374.0	
-375	375.0	
-377	377.0	
-378	378.0	
-379	379.0	
-382	764.0	
-384	1152.0	
-386	386.0	
-389	389.0	
-392	392.0	
-393	393.0	
-394	394.0	
-395	790.0	
-396	1188.0	
-397	794.0	
-399	798.0	
-4	4.0	
-400	400.0	
-401	2005.0	
-402	402.0	
-403	1209.0	
-404	808.0	
-406	1624.0	
-407	407.0	
-409	1227.0	
-41	41.0	
-411	411.0	
-413	826.0	
-414	828.0	
-417	1251.0	
-418	418.0	
-419	419.0	
-42	84.0	
-421	421.0	
-424	848.0	
-427	427.0	
-429	858.0	
-43	43.0	
-430	1290.0	
-431	1293.0	
-432	432.0	
-435	435.0	
-436	436.0	
-437	437.0	
-438	1314.0	
-439	878.0	
-44	44.0	
-443	443.0	
-444	444.0	
-446	446.0	
-448	448.0	
-449	449.0	
-452	452.0	
-453	453.0	
-454	1362.0	
-455	455.0	
-457	457.0	
-458	916.0	
-459	918.0	
-460	460.0	
-462	924.0	
-463	926.0	
-466	1398.0	
-467	467.0	
-468	1872.0	
-469	2345.0	
-47	47.0	
-470	470.0	
-472	472.0	
-475	475.0	
-477	477.0	
-478	956.0	
-479	479.0	
-480	1440.0	
-481	481.0	
-482	482.0	
-483	483.0	
-484	484.0	
-485	485.0	
-487	487.0	
-489	1956.0	
-490	490.0	
-491	491.0	
-492	984.0	
-493	493.0	
-494	494.0	
-495	495.0	
-496	496.0	
-497	497.0	
-498	1494.0	
-5	15.0	
-51	102.0	
-53	53.0	
-54	54.0	
-57	57.0	
-58	116.0	
-64	64.0	
-65	65.0	
-66	66.0	
-67	134.0	
-69	69.0	
-70	210.0	
-72	144.0	
-74	74.0	
-76	152.0	
-77	77.0	
-78	78.0	
-8	8.0	
-80	80.0	
-82	82.0	
-83	166.0	
-84	168.0	
-85	85.0	
-86	86.0	
-87	87.0	
-9	9.0	
-90	270.0	
-92	92.0	
-95	190.0	
-96	96.0	
-97	194.0	
-98	196.0	
+ABSTRACT SYNTAX TREE:
+  (TOK_QUERY (TOK_FROM (TOK_TABREF src)) (TOK_INSERT (TOK_DESTINATION (TOK_TAB dest1)) (TOK_SELECT (TOK_SELEXPR (TOK_COLREF src key)) (TOK_SELEXPR (TOK_FUNCTION sum (TOK_FUNCTION substr (TOK_COLREF src value) 4)))) (TOK_GROUPBY (TOK_COLREF src key))))
+
+STAGE DEPENDENCIES:
+  Stage-1 is a root stage
+  Stage-2 depends on stages: Stage-1
+  Stage-0 depends on stages: Stage-2
+
+STAGE PLANS:
+  Stage: Stage-1
+    Map Reduce
+      Reduce Operator Tree:
+          Group By Operator
+            keys:
+                  expr: VALUE.2
+                  type: string
+            mode: partial1
+          
+                expr: sum(VALUE.3)
+            File Output Operator
+              table:
+                  input format: org.apache.hadoop.mapred.TextInputFormat
+                  output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+      Alias -> Map Operator Tree:
+        src 
+            Reduce Output Operator
+              tag: -1
+              key expressions:
+                    expr: 0
+                    type: int
+              value expressions:
+                    expr: key
+                    type: string
+                    expr: value
+                    type: string
+                    expr: key
+                    type: string
+                    expr: substr(value, 4)
+                    type: string
+              # partition fields: -1
+
+  Stage: Stage-2
+    Map Reduce
+      Reduce Operator Tree:
+        Group By Operator
+          keys:
+                expr: KEY.0
+                type: string
+          mode: partial2
+        
+              expr: sum(VALUE.0)
+          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:
+        /tmp/hive-zshao/178504461.10001 
+          Reduce Output Operator
+            tag: -1
+            key expressions:
+                  expr: 0
+                  type: string
+            value expressions:
+                  expr: 1
+                  type: string
+            # partition fields: 1
+
+  Stage: Stage-0
+    Move Operator
+      tables:
+            table:
+                name: dest1
+                serde: simple_meta
+                input format: org.apache.hadoop.mapred.TextInputFormat
+                output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+            replace:
+
+
+0	0.0
+10	10.0
+100	200.0
+103	206.0
+104	208.0
+105	105.0
+11	11.0
+111	111.0
+113	226.0
+114	114.0
+116	116.0
+118	236.0
+119	357.0
+12	24.0
+120	240.0
+125	250.0
+126	126.0
+128	384.0
+129	258.0
+131	131.0
+133	133.0
+134	268.0
+136	136.0
+137	274.0
+138	552.0
+143	143.0
+145	145.0
+146	292.0
+149	298.0
+15	30.0
+150	150.0
+152	304.0
+153	153.0
+155	155.0
+156	156.0
+157	157.0
+158	158.0
+160	160.0
+162	162.0
+163	163.0
+164	328.0
+165	330.0
+166	166.0
+167	501.0
+168	168.0
+169	676.0
+17	17.0
+170	170.0
+172	344.0
+174	348.0
+175	350.0
+176	352.0
+177	177.0
+178	178.0
+179	358.0
+18	36.0
+180	180.0
+181	181.0
+183	183.0
+186	186.0
+187	561.0
+189	189.0
+19	19.0
+190	190.0
+191	382.0
+192	192.0
+193	579.0
+194	194.0
+195	390.0
+196	196.0
+197	394.0
+199	597.0
+2	2.0
+20	20.0
+200	400.0
+201	201.0
+202	202.0
+203	406.0
+205	410.0
+207	414.0
+208	624.0
+209	418.0
+213	426.0
+214	214.0
+216	432.0
+217	434.0
+218	218.0
+219	438.0
+221	442.0
+222	222.0
+223	446.0
+224	448.0
+226	226.0
+228	228.0
+229	458.0
+230	1150.0
+233	466.0
+235	235.0
+237	474.0
+238	476.0
+239	478.0
+24	48.0
+241	241.0
+242	484.0
+244	244.0
+247	247.0
+248	248.0
+249	249.0
+252	252.0
+255	510.0
+256	512.0
+257	257.0
+258	258.0
+26	52.0
+260	260.0
+262	262.0
+263	263.0
+265	530.0
+266	266.0
+27	27.0
+272	544.0
+273	819.0
+274	274.0
+275	275.0
+277	1108.0
+278	556.0
+28	28.0
+280	560.0
+281	562.0
+282	564.0
+283	283.0
+284	284.0
+285	285.0
+286	286.0
+287	287.0
+288	576.0
+289	289.0
+291	291.0
+292	292.0
+296	296.0
+298	894.0
+30	30.0
+302	302.0
+305	305.0
+306	306.0
+307	614.0
+308	308.0
+309	618.0
+310	310.0
+311	933.0
+315	315.0
+316	948.0
+317	634.0
+318	954.0
+321	642.0
+322	644.0
+323	323.0
+325	650.0
+327	981.0
+33	33.0
+331	662.0
+332	332.0
+333	666.0
+335	335.0
+336	336.0
+338	338.0
+339	339.0
+34	34.0
+341	341.0
+342	684.0
+344	688.0
+345	345.0
+348	1740.0
+35	105.0
+351	351.0
+353	706.0
+356	356.0
+360	360.0
+362	362.0
+364	364.0
+365	365.0
+366	366.0
+367	734.0
+368	368.0
+369	1107.0
+37	74.0
+373	373.0
+374	374.0
+375	375.0
+377	377.0
+378	378.0
+379	379.0
+382	764.0
+384	1152.0
+386	386.0
+389	389.0
+392	392.0
+393	393.0
+394	394.0
+395	790.0
+396	1188.0
+397	794.0
+399	798.0
+4	4.0
+400	400.0
+401	2005.0
+402	402.0
+403	1209.0
+404	808.0
+406	1624.0
+407	407.0
+409	1227.0
+41	41.0
+411	411.0
+413	826.0
+414	828.0
+417	1251.0
+418	418.0
+419	419.0
+42	84.0
+421	421.0
+424	848.0
+427	427.0
+429	858.0
+43	43.0
+430	1290.0
+431	1293.0
+432	432.0
+435	435.0
+436	436.0
+437	437.0
+438	1314.0
+439	878.0
+44	44.0
+443	443.0
+444	444.0
+446	446.0
+448	448.0
+449	449.0
+452	452.0
+453	453.0
+454	1362.0
+455	455.0
+457	457.0
+458	916.0
+459	918.0
+460	460.0
+462	924.0
+463	926.0
+466	1398.0
+467	467.0
+468	1872.0
+469	2345.0
+47	47.0
+470	470.0
+472	472.0
+475	475.0
+477	477.0
+478	956.0
+479	479.0
+480	1440.0
+481	481.0
+482	482.0
+483	483.0
+484	484.0
+485	485.0
+487	487.0
+489	1956.0
+490	490.0
+491	491.0
+492	984.0
+493	493.0
+494	494.0
+495	495.0
+496	496.0
+497	497.0
+498	1494.0
+5	15.0
+51	102.0
+53	53.0
+54	54.0
+57	57.0
+58	116.0
+64	64.0
+65	65.0
+66	66.0
+67	134.0
+69	69.0
+70	210.0
+72	144.0
+74	74.0
+76	152.0
+77	77.0
+78	78.0
+8	8.0
+80	80.0
+82	82.0
+83	166.0
+84	168.0
+85	85.0
+86	86.0
+87	87.0
+9	9.0
+90	270.0
+92	92.0
+95	190.0
+96	96.0
+97	194.0
+98	196.0
+

Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/groupby2.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/groupby2.q.out?rev=697291&r1=697290&r2=697291&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/groupby2.q.out (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/groupby2.q.out Fri Sep 19 16:56:30 2008
@@ -1,94 +1,101 @@
-ABSTRACT SYNTAX TREE:	
-  (TOK_QUERY (TOK_FROM (TOK_TABREF src)) (TOK_INSERT (TOK_DESTINATION (TOK_TAB dest1)) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTION substr (TOK_COLREF src key) 0 1)) (TOK_SELEXPR (TOK_FUNCTIONDI count (TOK_FUNCTION substr (TOK_COLREF src value) 4))) (TOK_SELEXPR (TOK_FUNCTION concat (TOK_FUNCTION substr (TOK_COLREF src key) 0 1) (TOK_FUNCTION sum (TOK_FUNCTION substr (TOK_COLREF src value) 4))))) (TOK_GROUPBY (TOK_FUNCTION substr (TOK_COLREF src key) 0 1))))	
-	
-STAGE DEPENDENCIES:	
-  Stage-1 is a root stage	
-  Stage-2 depends on stages: Stage-1	
-  Stage-0 depends on stages: Stage-2	
-	
-STAGE PLANS:	
-  Stage: Stage-1	
-    Map Reduce	
-      Reduce Operator Tree:	
-        Group By Operator	
-          keys:	
-                expr: KEY.0	
-                type: class java.lang.String	
-          mode: partial1	
-        	
-              expr: count(DISTINCT KEY.1)	
-              expr: sum(KEY.1)	
-          File Output Operator	
-            table:	
-                input format: org.apache.hadoop.mapred.TextInputFormat	
-                output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat	
-      Alias -> Map Operator Tree:	
-        src 	
-            Reduce Output Operator	
-              tag: -1	
-              key expressions:	
-                    expr: substr(key, 0, 1)	
-                    type: class java.lang.String	
-                    expr: substr(value, 4)	
-                    type: class java.lang.String	
-              # partition fields: 2147483647	
-	
-  Stage: Stage-2	
-    Map Reduce	
-      Reduce Operator Tree:	
-        Group By Operator	
-          keys:	
-                expr: KEY.0	
-                type: class java.lang.String	
-          mode: partial2	
-        	
-              expr: count(VALUE.0)	
-              expr: sum(VALUE.1)	
-          Select Operator	
-            expressions:	
-                  expr: 0	
-                  type: class java.lang.String	
-                  expr: 1	
-                  type: class java.lang.String	
-                  expr: concat(0, 2)	
-                  type: class java.lang.String	
-            File Output Operator	
-              table:	
-                  name: dest1	
-                  serde: org.apache.hadoop.hive.serde.simple_meta.MetadataTypedColumnsetSerDe	
-                  input format: org.apache.hadoop.mapred.TextInputFormat	
-                  output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat	
-      Alias -> Map Operator Tree:	
-        /tmp/hive-athusoo/69737081.10001 	
-          Reduce Output Operator	
-            tag: -1	
-            key expressions:	
-                  expr: 0	
-                  type: class java.lang.String	
-            value expressions:	
-                  expr: 1	
-                  type: class java.lang.String	
-                  expr: 2	
-                  type: class java.lang.String	
-            # partition fields: 1	
-	
-  Stage: Stage-0	
-    Move Operator	
-      tables:	
-            table:	
-                name: dest1	
-                serde: org.apache.hadoop.hive.serde.simple_meta.MetadataTypedColumnsetSerDe	
-                input format: org.apache.hadoop.mapred.TextInputFormat	
-                output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat	
-            replace:	
-	
-0	1	00.0	
-1	71	116414.0	
-2	69	225571.0	
-3	62	332004.0	
-4	74	452763.0	
-5	6	5397.0	
-6	5	6398.0	
-7	6	7735.0	
-8	8	8762.0	
-9	7	91047.0	
+ABSTRACT SYNTAX TREE:
+  (TOK_QUERY (TOK_FROM (TOK_TABREF src)) (TOK_INSERT (TOK_DESTINATION (TOK_TAB dest1)) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTION substr (TOK_COLREF src key) 0 1)) (TOK_SELEXPR (TOK_FUNCTIONDI count (TOK_FUNCTION substr (TOK_COLREF src value) 4))) (TOK_SELEXPR (TOK_FUNCTION concat (TOK_FUNCTION substr (TOK_COLREF src key) 0 1) (TOK_FUNCTION sum (TOK_FUNCTION substr (TOK_COLREF src value) 4))))) (TOK_GROUPBY (TOK_FUNCTION substr (TOK_COLREF src key) 0 1))))
+
+STAGE DEPENDENCIES:
+  Stage-1 is a root stage
+  Stage-2 depends on stages: Stage-1
+  Stage-0 depends on stages: Stage-2
+
+STAGE PLANS:
+  Stage: Stage-1
+    Map Reduce
+      Reduce Operator Tree:
+          Group By Operator
+            keys:
+                  expr: VALUE.2
+                  type: string
+            mode: partial1
+          
+                expr: count(DISTINCT KEY.0)
+                expr: sum(KEY.0)
+            File Output Operator
+              table:
+                  input format: org.apache.hadoop.mapred.TextInputFormat
+                  output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+      Alias -> Map Operator Tree:
+        src 
+            Reduce Output Operator
+              tag: -1
+              key expressions:
+                    expr: substr(value, 4)
+                    type: string
+              value expressions:
+                    expr: key
+                    type: string
+                    expr: value
+                    type: string
+                    expr: substr(key, 0, 1)
+                    type: string
+              # partition fields: 1
+
+  Stage: Stage-2
+    Map Reduce
+      Reduce Operator Tree:
+        Group By Operator
+          keys:
+                expr: KEY.0
+                type: string
+          mode: partial2
+        
+              expr: count(VALUE.0)
+              expr: sum(VALUE.1)
+          Select Operator
+            expressions:
+                  expr: 0
+                  type: string
+                  expr: 1
+                  type: string
+                  expr: concat(0, 2)
+                  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:
+        /tmp/hive-zshao/29356866.10001 
+          Reduce Output Operator
+            tag: -1
+            key expressions:
+                  expr: 0
+                  type: string
+            value expressions:
+                  expr: 1
+                  type: string
+                  expr: 2
+                  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	1	00.0
+1	71	116414.0
+2	69	225571.0
+3	62	332004.0
+4	74	452763.0
+5	6	5397.0
+6	5	6398.0
+7	6	7735.0
+8	8	8762.0
+9	7	91047.0
+

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

Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/groupby4.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/groupby4.q.out?rev=697291&r1=697290&r2=697291&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/groupby4.q.out (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/groupby4.q.out Fri Sep 19 16:56:30 2008
@@ -1,77 +1,86 @@
-ABSTRACT SYNTAX TREE:	
-  (TOK_QUERY (TOK_FROM (TOK_TABREF src)) (TOK_INSERT (TOK_DESTINATION (TOK_TAB dest1)) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTION substr (TOK_COLREF src key) 0 1))) (TOK_GROUPBY (TOK_FUNCTION substr (TOK_COLREF src key) 0 1))))	
-	
-STAGE DEPENDENCIES:	
-  Stage-1 is a root stage	
-  Stage-2 depends on stages: Stage-1	
-  Stage-0 depends on stages: Stage-2	
-	
-STAGE PLANS:	
-  Stage: Stage-1	
-    Map Reduce	
-      Reduce Operator Tree:	
-        Group By Operator	
-          keys:	
-                expr: KEY.0	
-                type: class java.lang.String	
-          mode: partial1	
-          File Output Operator	
-            table:	
-                input format: org.apache.hadoop.mapred.TextInputFormat	
-                output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat	
-      Alias -> Map Operator Tree:	
-        src 	
-            Reduce Output Operator	
-              tag: -1	
-              key expressions:	
-                    expr: substr(key, 0, 1)	
-                    type: class java.lang.String	
-              # partition fields: -1	
-	
-  Stage: Stage-2	
-    Map Reduce	
-      Reduce Operator Tree:	
-        Group By Operator	
-          keys:	
-                expr: KEY.0	
-                type: class java.lang.String	
-          mode: partial2	
-          Select Operator	
-            expressions:	
-                  expr: 0	
-                  type: class java.lang.String	
-            File Output Operator	
-              table:	
-                  name: dest1	
-                  serde: org.apache.hadoop.hive.serde.simple_meta.MetadataTypedColumnsetSerDe	
-                  input format: org.apache.hadoop.mapred.TextInputFormat	
-                  output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat	
-      Alias -> Map Operator Tree:	
-        /tmp/hive-athusoo/432066033.10001 	
-          Reduce Output Operator	
-            tag: -1	
-            key expressions:	
-                  expr: 0	
-                  type: class java.lang.String	
-            # partition fields: 1	
-	
-  Stage: Stage-0	
-    Move Operator	
-      tables:	
-            table:	
-                name: dest1	
-                serde: org.apache.hadoop.hive.serde.simple_meta.MetadataTypedColumnsetSerDe	
-                input format: org.apache.hadoop.mapred.TextInputFormat	
-                output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat	
-            replace:	
-	
-0	
-1	
-2	
-3	
-4	
-5	
-6	
-7	
-8	
-9	
+ABSTRACT SYNTAX TREE:
+  (TOK_QUERY (TOK_FROM (TOK_TABREF src)) (TOK_INSERT (TOK_DESTINATION (TOK_TAB dest1)) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTION substr (TOK_COLREF src key) 0 1))) (TOK_GROUPBY (TOK_FUNCTION substr (TOK_COLREF src key) 0 1))))
+
+STAGE DEPENDENCIES:
+  Stage-1 is a root stage
+  Stage-2 depends on stages: Stage-1
+  Stage-0 depends on stages: Stage-2
+
+STAGE PLANS:
+  Stage: Stage-1
+    Map Reduce
+      Reduce Operator Tree:
+          Group By Operator
+            keys:
+                  expr: VALUE.2
+                  type: string
+            mode: partial1
+            File Output Operator
+              table:
+                  input format: org.apache.hadoop.mapred.TextInputFormat
+                  output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+      Alias -> Map Operator Tree:
+        src 
+            Reduce Output Operator
+              tag: -1
+              key expressions:
+                    expr: 0
+                    type: int
+              value expressions:
+                    expr: key
+                    type: string
+                    expr: value
+                    type: string
+                    expr: substr(key, 0, 1)
+                    type: string
+              # partition fields: -1
+
+  Stage: Stage-2
+    Map Reduce
+      Reduce Operator Tree:
+        Group By Operator
+          keys:
+                expr: KEY.0
+                type: string
+          mode: partial2
+          Select Operator
+            expressions:
+                  expr: 0
+                  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:
+        /tmp/hive-zshao/64182502.10001 
+          Reduce Output Operator
+            tag: -1
+            key expressions:
+                  expr: 0
+                  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
+1
+2
+3
+4
+5
+6
+7
+8
+9
+

Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/groupby5.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/groupby5.q.out?rev=697291&r1=697290&r2=697291&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/groupby5.q.out (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/groupby5.q.out Fri Sep 19 16:56:30 2008
@@ -1,388 +1,396 @@
-ABSTRACT SYNTAX TREE:	
-  (TOK_QUERY (TOK_FROM (TOK_TABREF src)) (TOK_INSERT (TOK_DESTINATION (TOK_TAB dest1)) (TOK_SELECT (TOK_SELEXPR (TOK_COLREF src key)) (TOK_SELEXPR (TOK_FUNCTION sum (TOK_FUNCTION substr (TOK_COLREF src value) 4)))) (TOK_GROUPBY (TOK_COLREF src key))))	
-	
-STAGE DEPENDENCIES:	
-  Stage-1 is a root stage	
-  Stage-2 depends on stages: Stage-1	
-  Stage-0 depends on stages: Stage-2	
-	
-STAGE PLANS:	
-  Stage: Stage-1	
-    Map Reduce	
-      Reduce Operator Tree:	
-        Group By Operator	
-          keys:	
-                expr: KEY.0	
-                type: class java.lang.String	
-          mode: partial1	
-        	
-              expr: sum(VALUE.0)	
-          File Output Operator	
-            table:	
-                input format: org.apache.hadoop.mapred.TextInputFormat	
-                output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat	
-      Alias -> Map Operator Tree:	
-        src 	
-            Reduce Output Operator	
-              tag: -1	
-              key expressions:	
-                    expr: key	
-                    type: class java.lang.String	
-              value expressions:	
-                    expr: substr(value, 4)	
-                    type: class java.lang.String	
-              # partition fields: -1	
-	
-  Stage: Stage-2	
-    Map Reduce	
-      Reduce Operator Tree:	
-        Group By Operator	
-          keys:	
-                expr: KEY.0	
-                type: class java.lang.String	
-          mode: partial2	
-        	
-              expr: sum(VALUE.0)	
-          Select Operator	
-            expressions:	
-                  expr: 0	
-                  type: class java.lang.String	
-                  expr: 1	
-                  type: class java.lang.String	
-            File Output Operator	
-              table:	
-                  name: dest1	
-                  serde: org.apache.hadoop.hive.serde.simple_meta.MetadataTypedColumnsetSerDe	
-                  input format: org.apache.hadoop.mapred.TextInputFormat	
-                  output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat	
-      Alias -> Map Operator Tree:	
-        /tmp/hive-athusoo/423676467.10001 	
-          Reduce Output Operator	
-            tag: -1	
-            key expressions:	
-                  expr: 0	
-                  type: class java.lang.String	
-            value expressions:	
-                  expr: 1	
-                  type: class java.lang.String	
-            # partition fields: 1	
-	
-  Stage: Stage-0	
-    Move Operator	
-      tables:	
-            table:	
-                name: dest1	
-                serde: org.apache.hadoop.hive.serde.simple_meta.MetadataTypedColumnsetSerDe	
-                input format: org.apache.hadoop.mapred.TextInputFormat	
-                output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat	
-            replace:	
-	
-0	0.0	
-10	10.0	
-100	200.0	
-103	206.0	
-104	208.0	
-105	105.0	
-11	11.0	
-111	111.0	
-113	226.0	
-114	114.0	
-116	116.0	
-118	236.0	
-119	357.0	
-12	24.0	
-120	240.0	
-125	250.0	
-126	126.0	
-128	384.0	
-129	258.0	
-131	131.0	
-133	133.0	
-134	268.0	
-136	136.0	
-137	274.0	
-138	552.0	
-143	143.0	
-145	145.0	
-146	292.0	
-149	298.0	
-15	30.0	
-150	150.0	
-152	304.0	
-153	153.0	
-155	155.0	
-156	156.0	
-157	157.0	
-158	158.0	
-160	160.0	
-162	162.0	
-163	163.0	
-164	328.0	
-165	330.0	
-166	166.0	
-167	501.0	
-168	168.0	
-169	676.0	
-17	17.0	
-170	170.0	
-172	344.0	
-174	348.0	
-175	350.0	
-176	352.0	
-177	177.0	
-178	178.0	
-179	358.0	
-18	36.0	
-180	180.0	
-181	181.0	
-183	183.0	
-186	186.0	
-187	561.0	
-189	189.0	
-19	19.0	
-190	190.0	
-191	382.0	
-192	192.0	
-193	579.0	
-194	194.0	
-195	390.0	
-196	196.0	
-197	394.0	
-199	597.0	
-2	2.0	
-20	20.0	
-200	400.0	
-201	201.0	
-202	202.0	
-203	406.0	
-205	410.0	
-207	414.0	
-208	624.0	
-209	418.0	
-213	426.0	
-214	214.0	
-216	432.0	
-217	434.0	
-218	218.0	
-219	438.0	
-221	442.0	
-222	222.0	
-223	446.0	
-224	448.0	
-226	226.0	
-228	228.0	
-229	458.0	
-230	1150.0	
-233	466.0	
-235	235.0	
-237	474.0	
-238	476.0	
-239	478.0	
-24	48.0	
-241	241.0	
-242	484.0	
-244	244.0	
-247	247.0	
-248	248.0	
-249	249.0	
-252	252.0	
-255	510.0	
-256	512.0	
-257	257.0	
-258	258.0	
-26	52.0	
-260	260.0	
-262	262.0	
-263	263.0	
-265	530.0	
-266	266.0	
-27	27.0	
-272	544.0	
-273	819.0	
-274	274.0	
-275	275.0	
-277	1108.0	
-278	556.0	
-28	28.0	
-280	560.0	
-281	562.0	
-282	564.0	
-283	283.0	
-284	284.0	
-285	285.0	
-286	286.0	
-287	287.0	
-288	576.0	
-289	289.0	
-291	291.0	
-292	292.0	
-296	296.0	
-298	894.0	
-30	30.0	
-302	302.0	
-305	305.0	
-306	306.0	
-307	614.0	
-308	308.0	
-309	618.0	
-310	310.0	
-311	933.0	
-315	315.0	
-316	948.0	
-317	634.0	
-318	954.0	
-321	642.0	
-322	644.0	
-323	323.0	
-325	650.0	
-327	981.0	
-33	33.0	
-331	662.0	
-332	332.0	
-333	666.0	
-335	335.0	
-336	336.0	
-338	338.0	
-339	339.0	
-34	34.0	
-341	341.0	
-342	684.0	
-344	688.0	
-345	345.0	
-348	1740.0	
-35	105.0	
-351	351.0	
-353	706.0	
-356	356.0	
-360	360.0	
-362	362.0	
-364	364.0	
-365	365.0	
-366	366.0	
-367	734.0	
-368	368.0	
-369	1107.0	
-37	74.0	
-373	373.0	
-374	374.0	
-375	375.0	
-377	377.0	
-378	378.0	
-379	379.0	
-382	764.0	
-384	1152.0	
-386	386.0	
-389	389.0	
-392	392.0	
-393	393.0	
-394	394.0	
-395	790.0	
-396	1188.0	
-397	794.0	
-399	798.0	
-4	4.0	
-400	400.0	
-401	2005.0	
-402	402.0	
-403	1209.0	
-404	808.0	
-406	1624.0	
-407	407.0	
-409	1227.0	
-41	41.0	
-411	411.0	
-413	826.0	
-414	828.0	
-417	1251.0	
-418	418.0	
-419	419.0	
-42	84.0	
-421	421.0	
-424	848.0	
-427	427.0	
-429	858.0	
-43	43.0	
-430	1290.0	
-431	1293.0	
-432	432.0	
-435	435.0	
-436	436.0	
-437	437.0	
-438	1314.0	
-439	878.0	
-44	44.0	
-443	443.0	
-444	444.0	
-446	446.0	
-448	448.0	
-449	449.0	
-452	452.0	
-453	453.0	
-454	1362.0	
-455	455.0	
-457	457.0	
-458	916.0	
-459	918.0	
-460	460.0	
-462	924.0	
-463	926.0	
-466	1398.0	
-467	467.0	
-468	1872.0	
-469	2345.0	
-47	47.0	
-470	470.0	
-472	472.0	
-475	475.0	
-477	477.0	
-478	956.0	
-479	479.0	
-480	1440.0	
-481	481.0	
-482	482.0	
-483	483.0	
-484	484.0	
-485	485.0	
-487	487.0	
-489	1956.0	
-490	490.0	
-491	491.0	
-492	984.0	
-493	493.0	
-494	494.0	
-495	495.0	
-496	496.0	
-497	497.0	
-498	1494.0	
-5	15.0	
-51	102.0	
-53	53.0	
-54	54.0	
-57	57.0	
-58	116.0	
-64	64.0	
-65	65.0	
-66	66.0	
-67	134.0	
-69	69.0	
-70	210.0	
-72	144.0	
-74	74.0	
-76	152.0	
-77	77.0	
-78	78.0	
-8	8.0	
-80	80.0	
-82	82.0	
-83	166.0	
-84	168.0	
-85	85.0	
-86	86.0	
-87	87.0	
-9	9.0	
-90	270.0	
-92	92.0	
-95	190.0	
-96	96.0	
-97	194.0	
-98	196.0	
+ABSTRACT SYNTAX TREE:
+  (TOK_QUERY (TOK_FROM (TOK_TABREF src)) (TOK_INSERT (TOK_DESTINATION (TOK_TAB dest1)) (TOK_SELECT (TOK_SELEXPR (TOK_COLREF src key)) (TOK_SELEXPR (TOK_FUNCTION sum (TOK_FUNCTION substr (TOK_COLREF src value) 4)))) (TOK_GROUPBY (TOK_COLREF src key))))
+
+STAGE DEPENDENCIES:
+  Stage-1 is a root stage
+  Stage-2 depends on stages: Stage-1
+  Stage-0 depends on stages: Stage-2
+
+STAGE PLANS:
+  Stage: Stage-1
+    Map Reduce
+      Reduce Operator Tree:
+          Group By Operator
+            keys:
+                  expr: VALUE.2
+                  type: string
+            mode: partial1
+          
+                expr: sum(VALUE.3)
+            File Output Operator
+              table:
+                  input format: org.apache.hadoop.mapred.TextInputFormat
+                  output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+      Alias -> Map Operator Tree:
+        src 
+            Reduce Output Operator
+              tag: -1
+              key expressions:
+                    expr: 0
+                    type: int
+              value expressions:
+                    expr: key
+                    type: string
+                    expr: value
+                    type: string
+                    expr: key
+                    type: string
+                    expr: substr(value, 4)
+                    type: string
+              # partition fields: -1
+
+  Stage: Stage-2
+    Map Reduce
+      Reduce Operator Tree:
+        Group By Operator
+          keys:
+                expr: KEY.0
+                type: string
+          mode: partial2
+        
+              expr: sum(VALUE.0)
+          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:
+        /tmp/hive-zshao/317976905.10001 
+          Reduce Output Operator
+            tag: -1
+            key expressions:
+                  expr: 0
+                  type: string
+            value expressions:
+                  expr: 1
+                  type: string
+            # partition fields: 1
+
+  Stage: Stage-0
+    Move Operator
+      tables:
+            table:
+                name: dest1
+                serde: simple_meta
+                input format: org.apache.hadoop.mapred.TextInputFormat
+                output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+            replace:
+
+
+0	0.0
+10	10.0
+100	200.0
+103	206.0
+104	208.0
+105	105.0
+11	11.0
+111	111.0
+113	226.0
+114	114.0
+116	116.0
+118	236.0
+119	357.0
+12	24.0
+120	240.0
+125	250.0
+126	126.0
+128	384.0
+129	258.0
+131	131.0
+133	133.0
+134	268.0
+136	136.0
+137	274.0
+138	552.0
+143	143.0
+145	145.0
+146	292.0
+149	298.0
+15	30.0
+150	150.0
+152	304.0
+153	153.0
+155	155.0
+156	156.0
+157	157.0
+158	158.0
+160	160.0
+162	162.0
+163	163.0
+164	328.0
+165	330.0
+166	166.0
+167	501.0
+168	168.0
+169	676.0
+17	17.0
+170	170.0
+172	344.0
+174	348.0
+175	350.0
+176	352.0
+177	177.0
+178	178.0
+179	358.0
+18	36.0
+180	180.0
+181	181.0
+183	183.0
+186	186.0
+187	561.0
+189	189.0
+19	19.0
+190	190.0
+191	382.0
+192	192.0
+193	579.0
+194	194.0
+195	390.0
+196	196.0
+197	394.0
+199	597.0
+2	2.0
+20	20.0
+200	400.0
+201	201.0
+202	202.0
+203	406.0
+205	410.0
+207	414.0
+208	624.0
+209	418.0
+213	426.0
+214	214.0
+216	432.0
+217	434.0
+218	218.0
+219	438.0
+221	442.0
+222	222.0
+223	446.0
+224	448.0
+226	226.0
+228	228.0
+229	458.0
+230	1150.0
+233	466.0
+235	235.0
+237	474.0
+238	476.0
+239	478.0
+24	48.0
+241	241.0
+242	484.0
+244	244.0
+247	247.0
+248	248.0
+249	249.0
+252	252.0
+255	510.0
+256	512.0
+257	257.0
+258	258.0
+26	52.0
+260	260.0
+262	262.0
+263	263.0
+265	530.0
+266	266.0
+27	27.0
+272	544.0
+273	819.0
+274	274.0
+275	275.0
+277	1108.0
+278	556.0
+28	28.0
+280	560.0
+281	562.0
+282	564.0
+283	283.0
+284	284.0
+285	285.0
+286	286.0
+287	287.0
+288	576.0
+289	289.0
+291	291.0
+292	292.0
+296	296.0
+298	894.0
+30	30.0
+302	302.0
+305	305.0
+306	306.0
+307	614.0
+308	308.0
+309	618.0
+310	310.0
+311	933.0
+315	315.0
+316	948.0
+317	634.0
+318	954.0
+321	642.0
+322	644.0
+323	323.0
+325	650.0
+327	981.0
+33	33.0
+331	662.0
+332	332.0
+333	666.0
+335	335.0
+336	336.0
+338	338.0
+339	339.0
+34	34.0
+341	341.0
+342	684.0
+344	688.0
+345	345.0
+348	1740.0
+35	105.0
+351	351.0
+353	706.0
+356	356.0
+360	360.0
+362	362.0
+364	364.0
+365	365.0
+366	366.0
+367	734.0
+368	368.0
+369	1107.0
+37	74.0
+373	373.0
+374	374.0
+375	375.0
+377	377.0
+378	378.0
+379	379.0
+382	764.0
+384	1152.0
+386	386.0
+389	389.0
+392	392.0
+393	393.0
+394	394.0
+395	790.0
+396	1188.0
+397	794.0
+399	798.0
+4	4.0
+400	400.0
+401	2005.0
+402	402.0
+403	1209.0
+404	808.0
+406	1624.0
+407	407.0
+409	1227.0
+41	41.0
+411	411.0
+413	826.0
+414	828.0
+417	1251.0
+418	418.0
+419	419.0
+42	84.0
+421	421.0
+424	848.0
+427	427.0
+429	858.0
+43	43.0
+430	1290.0
+431	1293.0
+432	432.0
+435	435.0
+436	436.0
+437	437.0
+438	1314.0
+439	878.0
+44	44.0
+443	443.0
+444	444.0
+446	446.0
+448	448.0
+449	449.0
+452	452.0
+453	453.0
+454	1362.0
+455	455.0
+457	457.0
+458	916.0
+459	918.0
+460	460.0
+462	924.0
+463	926.0
+466	1398.0
+467	467.0
+468	1872.0
+469	2345.0
+47	47.0
+470	470.0
+472	472.0
+475	475.0
+477	477.0
+478	956.0
+479	479.0
+480	1440.0
+481	481.0
+482	482.0
+483	483.0
+484	484.0
+485	485.0
+487	487.0
+489	1956.0
+490	490.0
+491	491.0
+492	984.0
+493	493.0
+494	494.0
+495	495.0
+496	496.0
+497	497.0
+498	1494.0
+5	15.0
+51	102.0
+53	53.0
+54	54.0
+57	57.0
+58	116.0
+64	64.0
+65	65.0
+66	66.0
+67	134.0
+69	69.0
+70	210.0
+72	144.0
+74	74.0
+76	152.0
+77	77.0
+78	78.0
+8	8.0
+80	80.0
+82	82.0
+83	166.0
+84	168.0
+85	85.0
+86	86.0
+87	87.0
+9	9.0
+90	270.0
+92	92.0
+95	190.0
+96	96.0
+97	194.0
+98	196.0
+

Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/groupby6.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/groupby6.q.out?rev=697291&r1=697290&r2=697291&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/groupby6.q.out (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/groupby6.q.out Fri Sep 19 16:56:30 2008
@@ -1,77 +1,86 @@
-ABSTRACT SYNTAX TREE:	
-  (TOK_QUERY (TOK_FROM (TOK_TABREF src)) (TOK_INSERT (TOK_DESTINATION (TOK_TAB dest1)) (TOK_SELECTDI (TOK_SELEXPR (TOK_FUNCTION substr (TOK_COLREF src value) 4 1)))))	
-	
-STAGE DEPENDENCIES:	
-  Stage-1 is a root stage	
-  Stage-2 depends on stages: Stage-1	
-  Stage-0 depends on stages: Stage-2	
-	
-STAGE PLANS:	
-  Stage: Stage-1	
-    Map Reduce	
-      Reduce Operator Tree:	
-        Group By Operator	
-          keys:	
-                expr: KEY.0	
-                type: class java.lang.String	
-          mode: partial1	
-          File Output Operator	
-            table:	
-                input format: org.apache.hadoop.mapred.TextInputFormat	
-                output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat	
-      Alias -> Map Operator Tree:	
-        src 	
-            Reduce Output Operator	
-              tag: -1	
-              key expressions:	
-                    expr: substr(value, 4, 1)	
-                    type: class java.lang.String	
-              # partition fields: -1	
-	
-  Stage: Stage-2	
-    Map Reduce	
-      Reduce Operator Tree:	
-        Group By Operator	
-          keys:	
-                expr: KEY.0	
-                type: class java.lang.String	
-          mode: partial2	
-          Select Operator	
-            expressions:	
-                  expr: 0	
-                  type: class java.lang.String	
-            File Output Operator	
-              table:	
-                  name: dest1	
-                  serde: org.apache.hadoop.hive.serde.simple_meta.MetadataTypedColumnsetSerDe	
-                  input format: org.apache.hadoop.mapred.TextInputFormat	
-                  output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat	
-      Alias -> Map Operator Tree:	
-        /tmp/hive-athusoo/76679435.10001 	
-          Reduce Output Operator	
-            tag: -1	
-            key expressions:	
-                  expr: 0	
-                  type: class java.lang.String	
-            # partition fields: 1	
-	
-  Stage: Stage-0	
-    Move Operator	
-      tables:	
-            table:	
-                name: dest1	
-                serde: org.apache.hadoop.hive.serde.simple_meta.MetadataTypedColumnsetSerDe	
-                input format: org.apache.hadoop.mapred.TextInputFormat	
-                output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat	
-            replace:	
-	
-0	
-1	
-2	
-3	
-4	
-5	
-6	
-7	
-8	
-9	
+ABSTRACT SYNTAX TREE:
+  (TOK_QUERY (TOK_FROM (TOK_TABREF src)) (TOK_INSERT (TOK_DESTINATION (TOK_TAB dest1)) (TOK_SELECTDI (TOK_SELEXPR (TOK_FUNCTION substr (TOK_COLREF src value) 4 1)))))
+
+STAGE DEPENDENCIES:
+  Stage-1 is a root stage
+  Stage-2 depends on stages: Stage-1
+  Stage-0 depends on stages: Stage-2
+
+STAGE PLANS:
+  Stage: Stage-1
+    Map Reduce
+      Reduce Operator Tree:
+          Group By Operator
+            keys:
+                  expr: VALUE.2
+                  type: string
+            mode: partial1
+            File Output Operator
+              table:
+                  input format: org.apache.hadoop.mapred.TextInputFormat
+                  output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+      Alias -> Map Operator Tree:
+        src 
+            Reduce Output Operator
+              tag: -1
+              key expressions:
+                    expr: 0
+                    type: int
+              value expressions:
+                    expr: key
+                    type: string
+                    expr: value
+                    type: string
+                    expr: substr(value, 4, 1)
+                    type: string
+              # partition fields: -1
+
+  Stage: Stage-2
+    Map Reduce
+      Reduce Operator Tree:
+        Group By Operator
+          keys:
+                expr: KEY.0
+                type: string
+          mode: partial2
+          Select Operator
+            expressions:
+                  expr: 0
+                  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:
+        /tmp/hive-zshao/286498248.10001 
+          Reduce Output Operator
+            tag: -1
+            key expressions:
+                  expr: 0
+                  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
+1
+2
+3
+4
+5
+6
+7
+8
+9
+

Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/groupby7.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/groupby7.q.out?rev=697291&r1=697290&r2=697291&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/groupby7.q.out (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/groupby7.q.out Fri Sep 19 16:56:30 2008
@@ -1,618 +1,620 @@
-0	0.0	
-10	10.0	
-100	200.0	
-103	206.0	
-104	208.0	
-105	105.0	
-11	11.0	
-111	111.0	
-113	226.0	
-114	114.0	
-116	116.0	
-118	236.0	
-119	357.0	
-12	24.0	
-120	240.0	
-125	250.0	
-126	126.0	
-128	384.0	
-129	258.0	
-131	131.0	
-133	133.0	
-134	268.0	
-136	136.0	
-137	274.0	
-138	552.0	
-143	143.0	
-145	145.0	
-146	292.0	
-149	298.0	
-15	30.0	
-150	150.0	
-152	304.0	
-153	153.0	
-155	155.0	
-156	156.0	
-157	157.0	
-158	158.0	
-160	160.0	
-162	162.0	
-163	163.0	
-164	328.0	
-165	330.0	
-166	166.0	
-167	501.0	
-168	168.0	
-169	676.0	
-17	17.0	
-170	170.0	
-172	344.0	
-174	348.0	
-175	350.0	
-176	352.0	
-177	177.0	
-178	178.0	
-179	358.0	
-18	36.0	
-180	180.0	
-181	181.0	
-183	183.0	
-186	186.0	
-187	561.0	
-189	189.0	
-19	19.0	
-190	190.0	
-191	382.0	
-192	192.0	
-193	579.0	
-194	194.0	
-195	390.0	
-196	196.0	
-197	394.0	
-199	597.0	
-2	2.0	
-20	20.0	
-200	400.0	
-201	201.0	
-202	202.0	
-203	406.0	
-205	410.0	
-207	414.0	
-208	624.0	
-209	418.0	
-213	426.0	
-214	214.0	
-216	432.0	
-217	434.0	
-218	218.0	
-219	438.0	
-221	442.0	
-222	222.0	
-223	446.0	
-224	448.0	
-226	226.0	
-228	228.0	
-229	458.0	
-230	1150.0	
-233	466.0	
-235	235.0	
-237	474.0	
-238	476.0	
-239	478.0	
-24	48.0	
-241	241.0	
-242	484.0	
-244	244.0	
-247	247.0	
-248	248.0	
-249	249.0	
-252	252.0	
-255	510.0	
-256	512.0	
-257	257.0	
-258	258.0	
-26	52.0	
-260	260.0	
-262	262.0	
-263	263.0	
-265	530.0	
-266	266.0	
-27	27.0	
-272	544.0	
-273	819.0	
-274	274.0	
-275	275.0	
-277	1108.0	
-278	556.0	
-28	28.0	
-280	560.0	
-281	562.0	
-282	564.0	
-283	283.0	
-284	284.0	
-285	285.0	
-286	286.0	
-287	287.0	
-288	576.0	
-289	289.0	
-291	291.0	
-292	292.0	
-296	296.0	
-298	894.0	
-30	30.0	
-302	302.0	
-305	305.0	
-306	306.0	
-307	614.0	
-308	308.0	
-309	618.0	
-310	310.0	
-311	933.0	
-315	315.0	
-316	948.0	
-317	634.0	
-318	954.0	
-321	642.0	
-322	644.0	
-323	323.0	
-325	650.0	
-327	981.0	
-33	33.0	
-331	662.0	
-332	332.0	
-333	666.0	
-335	335.0	
-336	336.0	
-338	338.0	
-339	339.0	
-34	34.0	
-341	341.0	
-342	684.0	
-344	688.0	
-345	345.0	
-348	1740.0	
-35	105.0	
-351	351.0	
-353	706.0	
-356	356.0	
-360	360.0	
-362	362.0	
-364	364.0	
-365	365.0	
-366	366.0	
-367	734.0	
-368	368.0	
-369	1107.0	
-37	74.0	
-373	373.0	
-374	374.0	
-375	375.0	
-377	377.0	
-378	378.0	
-379	379.0	
-382	764.0	
-384	1152.0	
-386	386.0	
-389	389.0	
-392	392.0	
-393	393.0	
-394	394.0	
-395	790.0	
-396	1188.0	
-397	794.0	
-399	798.0	
-4	4.0	
-400	400.0	
-401	2005.0	
-402	402.0	
-403	1209.0	
-404	808.0	
-406	1624.0	
-407	407.0	
-409	1227.0	
-41	41.0	
-411	411.0	
-413	826.0	
-414	828.0	
-417	1251.0	
-418	418.0	
-419	419.0	
-42	84.0	
-421	421.0	
-424	848.0	
-427	427.0	
-429	858.0	
-43	43.0	
-430	1290.0	
-431	1293.0	
-432	432.0	
-435	435.0	
-436	436.0	
-437	437.0	
-438	1314.0	
-439	878.0	
-44	44.0	
-443	443.0	
-444	444.0	
-446	446.0	
-448	448.0	
-449	449.0	
-452	452.0	
-453	453.0	
-454	1362.0	
-455	455.0	
-457	457.0	
-458	916.0	
-459	918.0	
-460	460.0	
-462	924.0	
-463	926.0	
-466	1398.0	
-467	467.0	
-468	1872.0	
-469	2345.0	
-47	47.0	
-470	470.0	
-472	472.0	
-475	475.0	
-477	477.0	
-478	956.0	
-479	479.0	
-480	1440.0	
-481	481.0	
-482	482.0	
-483	483.0	
-484	484.0	
-485	485.0	
-487	487.0	
-489	1956.0	
-490	490.0	
-491	491.0	
-492	984.0	
-493	493.0	
-494	494.0	
-495	495.0	
-496	496.0	
-497	497.0	
-498	1494.0	
-5	15.0	
-51	102.0	
-53	53.0	
-54	54.0	
-57	57.0	
-58	116.0	
-64	64.0	
-65	65.0	
-66	66.0	
-67	134.0	
-69	69.0	
-70	210.0	
-72	144.0	
-74	74.0	
-76	152.0	
-77	77.0	
-78	78.0	
-8	8.0	
-80	80.0	
-82	82.0	
-83	166.0	
-84	168.0	
-85	85.0	
-86	86.0	
-87	87.0	
-9	9.0	
-90	270.0	
-92	92.0	
-95	190.0	
-96	96.0	
-97	194.0	
-98	196.0	
-0	0.0	
-10	10.0	
-100	200.0	
-103	206.0	
-104	208.0	
-105	105.0	
-11	11.0	
-111	111.0	
-113	226.0	
-114	114.0	
-116	116.0	
-118	236.0	
-119	357.0	
-12	24.0	
-120	240.0	
-125	250.0	
-126	126.0	
-128	384.0	
-129	258.0	
-131	131.0	
-133	133.0	
-134	268.0	
-136	136.0	
-137	274.0	
-138	552.0	
-143	143.0	
-145	145.0	
-146	292.0	
-149	298.0	
-15	30.0	
-150	150.0	
-152	304.0	
-153	153.0	
-155	155.0	
-156	156.0	
-157	157.0	
-158	158.0	
-160	160.0	
-162	162.0	
-163	163.0	
-164	328.0	
-165	330.0	
-166	166.0	
-167	501.0	
-168	168.0	
-169	676.0	
-17	17.0	
-170	170.0	
-172	344.0	
-174	348.0	
-175	350.0	
-176	352.0	
-177	177.0	
-178	178.0	
-179	358.0	
-18	36.0	
-180	180.0	
-181	181.0	
-183	183.0	
-186	186.0	
-187	561.0	
-189	189.0	
-19	19.0	
-190	190.0	
-191	382.0	
-192	192.0	
-193	579.0	
-194	194.0	
-195	390.0	
-196	196.0	
-197	394.0	
-199	597.0	
-2	2.0	
-20	20.0	
-200	400.0	
-201	201.0	
-202	202.0	
-203	406.0	
-205	410.0	
-207	414.0	
-208	624.0	
-209	418.0	
-213	426.0	
-214	214.0	
-216	432.0	
-217	434.0	
-218	218.0	
-219	438.0	
-221	442.0	
-222	222.0	
-223	446.0	
-224	448.0	
-226	226.0	
-228	228.0	
-229	458.0	
-230	1150.0	
-233	466.0	
-235	235.0	
-237	474.0	
-238	476.0	
-239	478.0	
-24	48.0	
-241	241.0	
-242	484.0	
-244	244.0	
-247	247.0	
-248	248.0	
-249	249.0	
-252	252.0	
-255	510.0	
-256	512.0	
-257	257.0	
-258	258.0	
-26	52.0	
-260	260.0	
-262	262.0	
-263	263.0	
-265	530.0	
-266	266.0	
-27	27.0	
-272	544.0	
-273	819.0	
-274	274.0	
-275	275.0	
-277	1108.0	
-278	556.0	
-28	28.0	
-280	560.0	
-281	562.0	
-282	564.0	
-283	283.0	
-284	284.0	
-285	285.0	
-286	286.0	
-287	287.0	
-288	576.0	
-289	289.0	
-291	291.0	
-292	292.0	
-296	296.0	
-298	894.0	
-30	30.0	
-302	302.0	
-305	305.0	
-306	306.0	
-307	614.0	
-308	308.0	
-309	618.0	
-310	310.0	
-311	933.0	
-315	315.0	
-316	948.0	
-317	634.0	
-318	954.0	
-321	642.0	
-322	644.0	
-323	323.0	
-325	650.0	
-327	981.0	
-33	33.0	
-331	662.0	
-332	332.0	
-333	666.0	
-335	335.0	
-336	336.0	
-338	338.0	
-339	339.0	
-34	34.0	
-341	341.0	
-342	684.0	
-344	688.0	
-345	345.0	
-348	1740.0	
-35	105.0	
-351	351.0	
-353	706.0	
-356	356.0	
-360	360.0	
-362	362.0	
-364	364.0	
-365	365.0	
-366	366.0	
-367	734.0	
-368	368.0	
-369	1107.0	
-37	74.0	
-373	373.0	
-374	374.0	
-375	375.0	
-377	377.0	
-378	378.0	
-379	379.0	
-382	764.0	
-384	1152.0	
-386	386.0	
-389	389.0	
-392	392.0	
-393	393.0	
-394	394.0	
-395	790.0	
-396	1188.0	
-397	794.0	
-399	798.0	
-4	4.0	
-400	400.0	
-401	2005.0	
-402	402.0	
-403	1209.0	
-404	808.0	
-406	1624.0	
-407	407.0	
-409	1227.0	
-41	41.0	
-411	411.0	
-413	826.0	
-414	828.0	
-417	1251.0	
-418	418.0	
-419	419.0	
-42	84.0	
-421	421.0	
-424	848.0	
-427	427.0	
-429	858.0	
-43	43.0	
-430	1290.0	
-431	1293.0	
-432	432.0	
-435	435.0	
-436	436.0	
-437	437.0	
-438	1314.0	
-439	878.0	
-44	44.0	
-443	443.0	
-444	444.0	
-446	446.0	
-448	448.0	
-449	449.0	
-452	452.0	
-453	453.0	
-454	1362.0	
-455	455.0	
-457	457.0	
-458	916.0	
-459	918.0	
-460	460.0	
-462	924.0	
-463	926.0	
-466	1398.0	
-467	467.0	
-468	1872.0	
-469	2345.0	
-47	47.0	
-470	470.0	
-472	472.0	
-475	475.0	
-477	477.0	
-478	956.0	
-479	479.0	
-480	1440.0	
-481	481.0	
-482	482.0	
-483	483.0	
-484	484.0	
-485	485.0	
-487	487.0	
-489	1956.0	
-490	490.0	
-491	491.0	
-492	984.0	
-493	493.0	
-494	494.0	
-495	495.0	
-496	496.0	
-497	497.0	
-498	1494.0	
-5	15.0	
-51	102.0	
-53	53.0	
-54	54.0	
-57	57.0	
-58	116.0	
-64	64.0	
-65	65.0	
-66	66.0	
-67	134.0	
-69	69.0	
-70	210.0	
-72	144.0	
-74	74.0	
-76	152.0	
-77	77.0	
-78	78.0	
-8	8.0	
-80	80.0	
-82	82.0	
-83	166.0	
-84	168.0	
-85	85.0	
-86	86.0	
-87	87.0	
-9	9.0	
-90	270.0	
-92	92.0	
-95	190.0	
-96	96.0	
-97	194.0	
-98	196.0	
+0	0.0
+10	10.0
+100	200.0
+103	206.0
+104	208.0
+105	105.0
+11	11.0
+111	111.0
+113	226.0
+114	114.0
+116	116.0
+118	236.0
+119	357.0
+12	24.0
+120	240.0
+125	250.0
+126	126.0
+128	384.0
+129	258.0
+131	131.0
+133	133.0
+134	268.0
+136	136.0
+137	274.0
+138	552.0
+143	143.0
+145	145.0
+146	292.0
+149	298.0
+15	30.0
+150	150.0
+152	304.0
+153	153.0
+155	155.0
+156	156.0
+157	157.0
+158	158.0
+160	160.0
+162	162.0
+163	163.0
+164	328.0
+165	330.0
+166	166.0
+167	501.0
+168	168.0
+169	676.0
+17	17.0
+170	170.0
+172	344.0
+174	348.0
+175	350.0
+176	352.0
+177	177.0
+178	178.0
+179	358.0
+18	36.0
+180	180.0
+181	181.0
+183	183.0
+186	186.0
+187	561.0
+189	189.0
+19	19.0
+190	190.0
+191	382.0
+192	192.0
+193	579.0
+194	194.0
+195	390.0
+196	196.0
+197	394.0
+199	597.0
+2	2.0
+20	20.0
+200	400.0
+201	201.0
+202	202.0
+203	406.0
+205	410.0
+207	414.0
+208	624.0
+209	418.0
+213	426.0
+214	214.0
+216	432.0
+217	434.0
+218	218.0
+219	438.0
+221	442.0
+222	222.0
+223	446.0
+224	448.0
+226	226.0
+228	228.0
+229	458.0
+230	1150.0
+233	466.0
+235	235.0
+237	474.0
+238	476.0
+239	478.0
+24	48.0
+241	241.0
+242	484.0
+244	244.0
+247	247.0
+248	248.0
+249	249.0
+252	252.0
+255	510.0
+256	512.0
+257	257.0
+258	258.0
+26	52.0
+260	260.0
+262	262.0
+263	263.0
+265	530.0
+266	266.0
+27	27.0
+272	544.0
+273	819.0
+274	274.0
+275	275.0
+277	1108.0
+278	556.0
+28	28.0
+280	560.0
+281	562.0
+282	564.0
+283	283.0
+284	284.0
+285	285.0
+286	286.0
+287	287.0
+288	576.0
+289	289.0
+291	291.0
+292	292.0
+296	296.0
+298	894.0
+30	30.0
+302	302.0
+305	305.0
+306	306.0
+307	614.0
+308	308.0
+309	618.0
+310	310.0
+311	933.0
+315	315.0
+316	948.0
+317	634.0
+318	954.0
+321	642.0
+322	644.0
+323	323.0
+325	650.0
+327	981.0
+33	33.0
+331	662.0
+332	332.0
+333	666.0
+335	335.0
+336	336.0
+338	338.0
+339	339.0
+34	34.0
+341	341.0
+342	684.0
+344	688.0
+345	345.0
+348	1740.0
+35	105.0
+351	351.0
+353	706.0
+356	356.0
+360	360.0
+362	362.0
+364	364.0
+365	365.0
+366	366.0
+367	734.0
+368	368.0
+369	1107.0
+37	74.0
+373	373.0
+374	374.0
+375	375.0
+377	377.0
+378	378.0
+379	379.0
+382	764.0
+384	1152.0
+386	386.0
+389	389.0
+392	392.0
+393	393.0
+394	394.0
+395	790.0
+396	1188.0
+397	794.0
+399	798.0
+4	4.0
+400	400.0
+401	2005.0
+402	402.0
+403	1209.0
+404	808.0
+406	1624.0
+407	407.0
+409	1227.0
+41	41.0
+411	411.0
+413	826.0
+414	828.0
+417	1251.0
+418	418.0
+419	419.0
+42	84.0
+421	421.0
+424	848.0
+427	427.0
+429	858.0
+43	43.0
+430	1290.0
+431	1293.0
+432	432.0
+435	435.0
+436	436.0
+437	437.0
+438	1314.0
+439	878.0
+44	44.0
+443	443.0
+444	444.0
+446	446.0
+448	448.0
+449	449.0
+452	452.0
+453	453.0
+454	1362.0
+455	455.0
+457	457.0
+458	916.0
+459	918.0
+460	460.0
+462	924.0
+463	926.0
+466	1398.0
+467	467.0
+468	1872.0
+469	2345.0
+47	47.0
+470	470.0
+472	472.0
+475	475.0
+477	477.0
+478	956.0
+479	479.0
+480	1440.0
+481	481.0
+482	482.0
+483	483.0
+484	484.0
+485	485.0
+487	487.0
+489	1956.0
+490	490.0
+491	491.0
+492	984.0
+493	493.0
+494	494.0
+495	495.0
+496	496.0
+497	497.0
+498	1494.0
+5	15.0
+51	102.0
+53	53.0
+54	54.0
+57	57.0
+58	116.0
+64	64.0
+65	65.0
+66	66.0
+67	134.0
+69	69.0
+70	210.0
+72	144.0
+74	74.0
+76	152.0
+77	77.0
+78	78.0
+8	8.0
+80	80.0
+82	82.0
+83	166.0
+84	168.0
+85	85.0
+86	86.0
+87	87.0
+9	9.0
+90	270.0
+92	92.0
+95	190.0
+96	96.0
+97	194.0
+98	196.0
+
+0	0.0
+10	10.0
+100	200.0
+103	206.0
+104	208.0
+105	105.0
+11	11.0
+111	111.0
+113	226.0
+114	114.0
+116	116.0
+118	236.0
+119	357.0
+12	24.0
+120	240.0
+125	250.0
+126	126.0
+128	384.0
+129	258.0
+131	131.0
+133	133.0
+134	268.0
+136	136.0
+137	274.0
+138	552.0
+143	143.0
+145	145.0
+146	292.0
+149	298.0
+15	30.0
+150	150.0
+152	304.0
+153	153.0
+155	155.0
+156	156.0
+157	157.0
+158	158.0
+160	160.0
+162	162.0
+163	163.0
+164	328.0
+165	330.0
+166	166.0
+167	501.0
+168	168.0
+169	676.0
+17	17.0
+170	170.0
+172	344.0
+174	348.0
+175	350.0
+176	352.0
+177	177.0
+178	178.0
+179	358.0
+18	36.0
+180	180.0
+181	181.0
+183	183.0
+186	186.0
+187	561.0
+189	189.0
+19	19.0
+190	190.0
+191	382.0
+192	192.0
+193	579.0
+194	194.0
+195	390.0
+196	196.0
+197	394.0
+199	597.0
+2	2.0
+20	20.0
+200	400.0
+201	201.0
+202	202.0
+203	406.0
+205	410.0
+207	414.0
+208	624.0
+209	418.0
+213	426.0
+214	214.0
+216	432.0
+217	434.0
+218	218.0
+219	438.0
+221	442.0
+222	222.0
+223	446.0
+224	448.0
+226	226.0
+228	228.0
+229	458.0
+230	1150.0
+233	466.0
+235	235.0
+237	474.0
+238	476.0
+239	478.0
+24	48.0
+241	241.0
+242	484.0
+244	244.0
+247	247.0
+248	248.0
+249	249.0
+252	252.0
+255	510.0
+256	512.0
+257	257.0
+258	258.0
+26	52.0
+260	260.0
+262	262.0
+263	263.0
+265	530.0
+266	266.0
+27	27.0
+272	544.0
+273	819.0
+274	274.0
+275	275.0
+277	1108.0
+278	556.0
+28	28.0
+280	560.0
+281	562.0
+282	564.0
+283	283.0
+284	284.0
+285	285.0
+286	286.0
+287	287.0
+288	576.0
+289	289.0
+291	291.0
+292	292.0
+296	296.0
+298	894.0
+30	30.0
+302	302.0
+305	305.0
+306	306.0
+307	614.0
+308	308.0
+309	618.0
+310	310.0
+311	933.0
+315	315.0
+316	948.0
+317	634.0
+318	954.0
+321	642.0
+322	644.0
+323	323.0
+325	650.0
+327	981.0
+33	33.0
+331	662.0
+332	332.0
+333	666.0
+335	335.0
+336	336.0
+338	338.0
+339	339.0
+34	34.0
+341	341.0
+342	684.0
+344	688.0
+345	345.0
+348	1740.0
+35	105.0
+351	351.0
+353	706.0
+356	356.0
+360	360.0
+362	362.0
+364	364.0
+365	365.0
+366	366.0
+367	734.0
+368	368.0
+369	1107.0
+37	74.0
+373	373.0
+374	374.0
+375	375.0
+377	377.0
+378	378.0
+379	379.0
+382	764.0
+384	1152.0
+386	386.0
+389	389.0
+392	392.0
+393	393.0
+394	394.0
+395	790.0
+396	1188.0
+397	794.0
+399	798.0
+4	4.0
+400	400.0
+401	2005.0
+402	402.0
+403	1209.0
+404	808.0
+406	1624.0
+407	407.0
+409	1227.0
+41	41.0
+411	411.0
+413	826.0
+414	828.0
+417	1251.0
+418	418.0
+419	419.0
+42	84.0
+421	421.0
+424	848.0
+427	427.0
+429	858.0
+43	43.0
+430	1290.0
+431	1293.0
+432	432.0
+435	435.0
+436	436.0
+437	437.0
+438	1314.0
+439	878.0
+44	44.0
+443	443.0
+444	444.0
+446	446.0
+448	448.0
+449	449.0
+452	452.0
+453	453.0
+454	1362.0
+455	455.0
+457	457.0
+458	916.0
+459	918.0
+460	460.0
+462	924.0
+463	926.0
+466	1398.0
+467	467.0
+468	1872.0
+469	2345.0
+47	47.0
+470	470.0
+472	472.0
+475	475.0
+477	477.0
+478	956.0
+479	479.0
+480	1440.0
+481	481.0
+482	482.0
+483	483.0
+484	484.0
+485	485.0
+487	487.0
+489	1956.0
+490	490.0
+491	491.0
+492	984.0
+493	493.0
+494	494.0
+495	495.0
+496	496.0
+497	497.0
+498	1494.0
+5	15.0
+51	102.0
+53	53.0
+54	54.0
+57	57.0
+58	116.0
+64	64.0
+65	65.0
+66	66.0
+67	134.0
+69	69.0
+70	210.0
+72	144.0
+74	74.0
+76	152.0
+77	77.0
+78	78.0
+8	8.0
+80	80.0
+82	82.0
+83	166.0
+84	168.0
+85	85.0
+86	86.0
+87	87.0
+9	9.0
+90	270.0
+92	92.0
+95	190.0
+96	96.0
+97	194.0
+98	196.0
+

Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/groupby8.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/groupby8.q.out?rev=697291&r1=697290&r2=697291&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/groupby8.q.out (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/groupby8.q.out Fri Sep 19 16:56:30 2008
@@ -1,618 +1,620 @@
-0	1	
-10	1	
-100	1	
-103	1	
-104	1	
-105	1	
-11	1	
-111	1	
-113	1	
-114	1	
-116	1	
-118	1	
-119	1	
-12	1	
-120	1	
-125	1	
-126	1	
-128	1	
-129	1	
-131	1	
-133	1	
-134	1	
-136	1	
-137	1	
-138	1	
-143	1	
-145	1	
-146	1	
-149	1	
-15	1	
-150	1	
-152	1	
-153	1	
-155	1	
-156	1	
-157	1	
-158	1	
-160	1	
-162	1	
-163	1	
-164	1	
-165	1	
-166	1	
-167	1	
-168	1	
-169	1	
-17	1	
-170	1	
-172	1	
-174	1	
-175	1	
-176	1	
-177	1	
-178	1	
-179	1	
-18	1	
-180	1	
-181	1	
-183	1	
-186	1	
-187	1	
-189	1	
-19	1	
-190	1	
-191	1	
-192	1	
-193	1	
-194	1	
-195	1	
-196	1	
-197	1	
-199	1	
-2	1	
-20	1	
-200	1	
-201	1	
-202	1	
-203	1	
-205	1	
-207	1	
-208	1	
-209	1	
-213	1	
-214	1	
-216	1	
-217	1	
-218	1	
-219	1	
-221	1	
-222	1	
-223	1	
-224	1	
-226	1	
-228	1	
-229	1	
-230	1	
-233	1	
-235	1	
-237	1	
-238	1	
-239	1	
-24	1	
-241	1	
-242	1	
-244	1	
-247	1	
-248	1	
-249	1	
-252	1	
-255	1	
-256	1	
-257	1	
-258	1	
-26	1	
-260	1	
-262	1	
-263	1	
-265	1	
-266	1	
-27	1	
-272	1	
-273	1	
-274	1	
-275	1	
-277	1	
-278	1	
-28	1	
-280	1	
-281	1	
-282	1	
-283	1	
-284	1	
-285	1	
-286	1	
-287	1	
-288	1	
-289	1	
-291	1	
-292	1	
-296	1	
-298	1	
-30	1	
-302	1	
-305	1	
-306	1	
-307	1	
-308	1	
-309	1	
-310	1	
-311	1	
-315	1	
-316	1	
-317	1	
-318	1	
-321	1	
-322	1	
-323	1	
-325	1	
-327	1	
-33	1	
-331	1	
-332	1	
-333	1	
-335	1	
-336	1	
-338	1	
-339	1	
-34	1	
-341	1	
-342	1	
-344	1	
-345	1	
-348	1	
-35	1	
-351	1	
-353	1	
-356	1	
-360	1	
-362	1	
-364	1	
-365	1	
-366	1	
-367	1	
-368	1	
-369	1	
-37	1	
-373	1	
-374	1	
-375	1	
-377	1	
-378	1	
-379	1	
-382	1	
-384	1	
-386	1	
-389	1	
-392	1	
-393	1	
-394	1	
-395	1	
-396	1	
-397	1	
-399	1	
-4	1	
-400	1	
-401	1	
-402	1	
-403	1	
-404	1	
-406	1	
-407	1	
-409	1	
-41	1	
-411	1	
-413	1	
-414	1	
-417	1	
-418	1	
-419	1	
-42	1	
-421	1	
-424	1	
-427	1	
-429	1	
-43	1	
-430	1	
-431	1	
-432	1	
-435	1	
-436	1	
-437	1	
-438	1	
-439	1	
-44	1	
-443	1	
-444	1	
-446	1	
-448	1	
-449	1	
-452	1	
-453	1	
-454	1	
-455	1	
-457	1	
-458	1	
-459	1	
-460	1	
-462	1	
-463	1	
-466	1	
-467	1	
-468	1	
-469	1	
-47	1	
-470	1	
-472	1	
-475	1	
-477	1	
-478	1	
-479	1	
-480	1	
-481	1	
-482	1	
-483	1	
-484	1	
-485	1	
-487	1	
-489	1	
-490	1	
-491	1	
-492	1	
-493	1	
-494	1	
-495	1	
-496	1	
-497	1	
-498	1	
-5	1	
-51	1	
-53	1	
-54	1	
-57	1	
-58	1	
-64	1	
-65	1	
-66	1	
-67	1	
-69	1	
-70	1	
-72	1	
-74	1	
-76	1	
-77	1	
-78	1	
-8	1	
-80	1	
-82	1	
-83	1	
-84	1	
-85	1	
-86	1	
-87	1	
-9	1	
-90	1	
-92	1	
-95	1	
-96	1	
-97	1	
-98	1	
-0	1	
-10	1	
-100	1	
-103	1	
-104	1	
-105	1	
-11	1	
-111	1	
-113	1	
-114	1	
-116	1	
-118	1	
-119	1	
-12	1	
-120	1	
-125	1	
-126	1	
-128	1	
-129	1	
-131	1	
-133	1	
-134	1	
-136	1	
-137	1	
-138	1	
-143	1	
-145	1	
-146	1	
-149	1	
-15	1	
-150	1	
-152	1	
-153	1	
-155	1	
-156	1	
-157	1	
-158	1	
-160	1	
-162	1	
-163	1	
-164	1	
-165	1	
-166	1	
-167	1	
-168	1	
-169	1	
-17	1	
-170	1	
-172	1	
-174	1	
-175	1	
-176	1	
-177	1	
-178	1	
-179	1	
-18	1	
-180	1	
-181	1	
-183	1	
-186	1	
-187	1	
-189	1	
-19	1	
-190	1	
-191	1	
-192	1	
-193	1	
-194	1	
-195	1	
-196	1	
-197	1	
-199	1	
-2	1	
-20	1	
-200	1	
-201	1	
-202	1	
-203	1	
-205	1	
-207	1	
-208	1	
-209	1	
-213	1	
-214	1	
-216	1	
-217	1	
-218	1	
-219	1	
-221	1	
-222	1	
-223	1	
-224	1	
-226	1	
-228	1	
-229	1	
-230	1	
-233	1	
-235	1	
-237	1	
-238	1	
-239	1	
-24	1	
-241	1	
-242	1	
-244	1	
-247	1	
-248	1	
-249	1	
-252	1	
-255	1	
-256	1	
-257	1	
-258	1	
-26	1	
-260	1	
-262	1	
-263	1	
-265	1	
-266	1	
-27	1	
-272	1	
-273	1	
-274	1	
-275	1	
-277	1	
-278	1	
-28	1	
-280	1	
-281	1	
-282	1	
-283	1	
-284	1	
-285	1	
-286	1	
-287	1	
-288	1	
-289	1	
-291	1	
-292	1	
-296	1	
-298	1	
-30	1	
-302	1	
-305	1	
-306	1	
-307	1	
-308	1	
-309	1	
-310	1	
-311	1	
-315	1	
-316	1	
-317	1	
-318	1	
-321	1	
-322	1	
-323	1	
-325	1	
-327	1	
-33	1	
-331	1	
-332	1	
-333	1	
-335	1	
-336	1	
-338	1	
-339	1	
-34	1	
-341	1	
-342	1	
-344	1	
-345	1	
-348	1	
-35	1	
-351	1	
-353	1	
-356	1	
-360	1	
-362	1	
-364	1	
-365	1	
-366	1	
-367	1	
-368	1	
-369	1	
-37	1	
-373	1	
-374	1	
-375	1	
-377	1	
-378	1	
-379	1	
-382	1	
-384	1	
-386	1	
-389	1	
-392	1	
-393	1	
-394	1	
-395	1	
-396	1	
-397	1	
-399	1	
-4	1	
-400	1	
-401	1	
-402	1	
-403	1	
-404	1	
-406	1	
-407	1	
-409	1	
-41	1	
-411	1	
-413	1	
-414	1	
-417	1	
-418	1	
-419	1	
-42	1	
-421	1	
-424	1	
-427	1	
-429	1	
-43	1	
-430	1	
-431	1	
-432	1	
-435	1	
-436	1	
-437	1	
-438	1	
-439	1	
-44	1	
-443	1	
-444	1	
-446	1	
-448	1	
-449	1	
-452	1	
-453	1	
-454	1	
-455	1	
-457	1	
-458	1	
-459	1	
-460	1	
-462	1	
-463	1	
-466	1	
-467	1	
-468	1	
-469	1	
-47	1	
-470	1	
-472	1	
-475	1	
-477	1	
-478	1	
-479	1	
-480	1	
-481	1	
-482	1	
-483	1	
-484	1	
-485	1	
-487	1	
-489	1	
-490	1	
-491	1	
-492	1	
-493	1	
-494	1	
-495	1	
-496	1	
-497	1	
-498	1	
-5	1	
-51	1	
-53	1	
-54	1	
-57	1	
-58	1	
-64	1	
-65	1	
-66	1	
-67	1	
-69	1	
-70	1	
-72	1	
-74	1	
-76	1	
-77	1	
-78	1	
-8	1	
-80	1	
-82	1	
-83	1	
-84	1	
-85	1	
-86	1	
-87	1	
-9	1	
-90	1	
-92	1	
-95	1	
-96	1	
-97	1	
-98	1	
+0	1
+10	1
+100	1
+103	1
+104	1
+105	1
+11	1
+111	1
+113	1
+114	1
+116	1
+118	1
+119	1
+12	1
+120	1
+125	1
+126	1
+128	1
+129	1
+131	1
+133	1
+134	1
+136	1
+137	1
+138	1
+143	1
+145	1
+146	1
+149	1
+15	1
+150	1
+152	1
+153	1
+155	1
+156	1
+157	1
+158	1
+160	1
+162	1
+163	1
+164	1
+165	1
+166	1
+167	1
+168	1
+169	1
+17	1
+170	1
+172	1
+174	1
+175	1
+176	1
+177	1
+178	1
+179	1
+18	1
+180	1
+181	1
+183	1
+186	1
+187	1
+189	1
+19	1
+190	1
+191	1
+192	1
+193	1
+194	1
+195	1
+196	1
+197	1
+199	1
+2	1
+20	1
+200	1
+201	1
+202	1
+203	1
+205	1
+207	1
+208	1
+209	1
+213	1
+214	1
+216	1
+217	1
+218	1
+219	1
+221	1
+222	1
+223	1
+224	1
+226	1
+228	1
+229	1
+230	1
+233	1
+235	1
+237	1
+238	1
+239	1
+24	1
+241	1
+242	1
+244	1
+247	1
+248	1
+249	1
+252	1
+255	1
+256	1
+257	1
+258	1
+26	1
+260	1
+262	1
+263	1
+265	1
+266	1
+27	1
+272	1
+273	1
+274	1
+275	1
+277	1
+278	1
+28	1
+280	1
+281	1
+282	1
+283	1
+284	1
+285	1
+286	1
+287	1
+288	1
+289	1
+291	1
+292	1
+296	1
+298	1
+30	1
+302	1
+305	1
+306	1
+307	1
+308	1
+309	1
+310	1
+311	1
+315	1
+316	1
+317	1
+318	1
+321	1
+322	1
+323	1
+325	1
+327	1
+33	1
+331	1
+332	1
+333	1
+335	1
+336	1
+338	1
+339	1
+34	1
+341	1
+342	1
+344	1
+345	1
+348	1
+35	1
+351	1
+353	1
+356	1
+360	1
+362	1
+364	1
+365	1
+366	1
+367	1
+368	1
+369	1
+37	1
+373	1
+374	1
+375	1
+377	1
+378	1
+379	1
+382	1
+384	1
+386	1
+389	1
+392	1
+393	1
+394	1
+395	1
+396	1
+397	1
+399	1
+4	1
+400	1
+401	1
+402	1
+403	1
+404	1
+406	1
+407	1
+409	1
+41	1
+411	1
+413	1
+414	1
+417	1
+418	1
+419	1
+42	1
+421	1
+424	1
+427	1
+429	1
+43	1
+430	1
+431	1
+432	1
+435	1
+436	1
+437	1
+438	1
+439	1
+44	1
+443	1
+444	1
+446	1
+448	1
+449	1
+452	1
+453	1
+454	1
+455	1
+457	1
+458	1
+459	1
+460	1
+462	1
+463	1
+466	1
+467	1
+468	1
+469	1
+47	1
+470	1
+472	1
+475	1
+477	1
+478	1
+479	1
+480	1
+481	1
+482	1
+483	1
+484	1
+485	1
+487	1
+489	1
+490	1
+491	1
+492	1
+493	1
+494	1
+495	1
+496	1
+497	1
+498	1
+5	1
+51	1
+53	1
+54	1
+57	1
+58	1
+64	1
+65	1
+66	1
+67	1
+69	1
+70	1
+72	1
+74	1
+76	1
+77	1
+78	1
+8	1
+80	1
+82	1
+83	1
+84	1
+85	1
+86	1
+87	1
+9	1
+90	1
+92	1
+95	1
+96	1
+97	1
+98	1
+
+0	1
+10	1
+100	1
+103	1
+104	1
+105	1
+11	1
+111	1
+113	1
+114	1
+116	1
+118	1
+119	1
+12	1
+120	1
+125	1
+126	1
+128	1
+129	1
+131	1
+133	1
+134	1
+136	1
+137	1
+138	1
+143	1
+145	1
+146	1
+149	1
+15	1
+150	1
+152	1
+153	1
+155	1
+156	1
+157	1
+158	1
+160	1
+162	1
+163	1
+164	1
+165	1
+166	1
+167	1
+168	1
+169	1
+17	1
+170	1
+172	1
+174	1
+175	1
+176	1
+177	1
+178	1
+179	1
+18	1
+180	1
+181	1
+183	1
+186	1
+187	1
+189	1
+19	1
+190	1
+191	1
+192	1
+193	1
+194	1
+195	1
+196	1
+197	1
+199	1
+2	1
+20	1
+200	1
+201	1
+202	1
+203	1
+205	1
+207	1
+208	1
+209	1
+213	1
+214	1
+216	1
+217	1
+218	1
+219	1
+221	1
+222	1
+223	1
+224	1
+226	1
+228	1
+229	1
+230	1
+233	1
+235	1
+237	1
+238	1
+239	1
+24	1
+241	1
+242	1
+244	1
+247	1
+248	1
+249	1
+252	1
+255	1
+256	1
+257	1
+258	1
+26	1
+260	1
+262	1
+263	1
+265	1
+266	1
+27	1
+272	1
+273	1
+274	1
+275	1
+277	1
+278	1
+28	1
+280	1
+281	1
+282	1
+283	1
+284	1
+285	1
+286	1
+287	1
+288	1
+289	1
+291	1
+292	1
+296	1
+298	1
+30	1
+302	1
+305	1
+306	1
+307	1
+308	1
+309	1
+310	1
+311	1
+315	1
+316	1
+317	1
+318	1
+321	1
+322	1
+323	1
+325	1
+327	1
+33	1
+331	1
+332	1
+333	1
+335	1
+336	1
+338	1
+339	1
+34	1
+341	1
+342	1
+344	1
+345	1
+348	1
+35	1
+351	1
+353	1
+356	1
+360	1
+362	1
+364	1
+365	1
+366	1
+367	1
+368	1
+369	1
+37	1
+373	1
+374	1
+375	1
+377	1
+378	1
+379	1
+382	1
+384	1
+386	1
+389	1
+392	1
+393	1
+394	1
+395	1
+396	1
+397	1
+399	1
+4	1
+400	1
+401	1
+402	1
+403	1
+404	1
+406	1
+407	1
+409	1
+41	1
+411	1
+413	1
+414	1
+417	1
+418	1
+419	1
+42	1
+421	1
+424	1
+427	1
+429	1
+43	1
+430	1
+431	1
+432	1
+435	1
+436	1
+437	1
+438	1
+439	1
+44	1
+443	1
+444	1
+446	1
+448	1
+449	1
+452	1
+453	1
+454	1
+455	1
+457	1
+458	1
+459	1
+460	1
+462	1
+463	1
+466	1
+467	1
+468	1
+469	1
+47	1
+470	1
+472	1
+475	1
+477	1
+478	1
+479	1
+480	1
+481	1
+482	1
+483	1
+484	1
+485	1
+487	1
+489	1
+490	1
+491	1
+492	1
+493	1
+494	1
+495	1
+496	1
+497	1
+498	1
+5	1
+51	1
+53	1
+54	1
+57	1
+58	1
+64	1
+65	1
+66	1
+67	1
+69	1
+70	1
+72	1
+74	1
+76	1
+77	1
+78	1
+8	1
+80	1
+82	1
+83	1
+84	1
+85	1
+86	1
+87	1
+9	1
+90	1
+92	1
+95	1
+96	1
+97	1
+98	1
+

Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input1.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input1.q.out?rev=697291&r1=697290&r2=697291&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input1.q.out (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input1.q.out Fri Sep 19 16:56:30 2008
@@ -1,14 +1,15 @@
-ABSTRACT SYNTAX TREE:	
-  (TOK_DESCTABLE TEST1)	
-	
-STAGE DEPENDENCIES:	
-  Stage-0 is a root stage	
-	
-STAGE PLANS:	
-  Stage: Stage-0	
-    	
-      Describe Table	
-        table: TEST1	
-	
-a	int	
-b	float	
+ABSTRACT SYNTAX TREE:
+  (TOK_DESCTABLE TEST1)
+
+STAGE DEPENDENCIES:
+  Stage-0 is a root stage
+
+STAGE PLANS:
+  Stage: Stage-0
+      Describe Table Operator:
+        Describe Table
+          table: TEST1
+
+
+a	int
+b	float

Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input10.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input10.q.out?rev=697291&r1=697290&r2=697291&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input10.q.out (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input10.q.out Fri Sep 19 16:56:30 2008
@@ -1,16 +1,17 @@
-ABSTRACT SYNTAX TREE:	
-  (TOK_DESCTABLE TEST10)	
-	
-STAGE DEPENDENCIES:	
-  Stage-0 is a root stage	
-	
-STAGE PLANS:	
-  Stage: Stage-0	
-    	
-      Describe Table	
-        table: TEST10	
-	
-key	int	
-value	string	
-ds	string	
-hr	string	
+ABSTRACT SYNTAX TREE:
+  (TOK_DESCTABLE TEST10)
+
+STAGE DEPENDENCIES:
+  Stage-0 is a root stage
+
+STAGE PLANS:
+  Stage: Stage-0
+      Describe Table Operator:
+        Describe Table
+          table: TEST10
+
+
+key	int
+value	string
+ds	string
+hr	string

Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input11.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input11.q.out?rev=697291&r1=697290&r2=697291&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input11.q.out (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input11.q.out Fri Sep 19 16:56:30 2008
@@ -1,123 +1,125 @@
-ABSTRACT SYNTAX TREE:	
-  (TOK_QUERY (TOK_FROM (TOK_TABREF src)) (TOK_INSERT (TOK_DESTINATION (TOK_TAB dest1)) (TOK_SELECT (TOK_SELEXPR (TOK_COLREF src key)) (TOK_SELEXPR (TOK_COLREF src value))) (TOK_WHERE (< (TOK_COLREF src key) 100))))	
-	
-STAGE DEPENDENCIES:	
-  Stage-1 is a root stage	
-  Stage-0 depends on stages: Stage-1	
-	
-STAGE PLANS:	
-  Stage: Stage-1	
-    Map Reduce	
-      Alias -> Map Operator Tree:	
-        src 	
-            Filter Operator	
-              predicate:	
-                  expr: (key < 100)	
-                  type: class java.lang.Boolean	
-              Select Operator	
-                expressions:	
-                      expr: key	
-                      type: class java.lang.String	
-                      expr: value	
-                      type: class java.lang.String	
-                File Output Operator	
-                  table:	
-                      name: dest1	
-                      serde: org.apache.hadoop.hive.serde.simple_meta.MetadataTypedColumnsetSerDe	
-                      input format: org.apache.hadoop.mapred.TextInputFormat	
-                      output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat	
-	
-  Stage: Stage-0	
-    Move Operator	
-      tables:	
-            table:	
-                name: dest1	
-                serde: org.apache.hadoop.hive.serde.simple_meta.MetadataTypedColumnsetSerDe	
-                input format: org.apache.hadoop.mapred.TextInputFormat	
-                output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat	
-            replace:	
-	
-86	val_86	
-27	val_27	
-98	val_98	
-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	
+ABSTRACT SYNTAX TREE:
+  (TOK_QUERY (TOK_FROM (TOK_TABREF src)) (TOK_INSERT (TOK_DESTINATION (TOK_TAB dest1)) (TOK_SELECT (TOK_SELEXPR (TOK_COLREF src key)) (TOK_SELEXPR (TOK_COLREF src value))) (TOK_WHERE (< (TOK_COLREF src key) 100))))
+
+STAGE DEPENDENCIES:
+  Stage-1 is a root stage
+  Stage-0 depends on stages: Stage-1
+
+STAGE PLANS:
+  Stage: Stage-1
+    Map Reduce
+      Alias -> Map Operator Tree:
+        src 
+            Filter Operator
+              predicate:
+                  expr: (key < 100)
+                  type: 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:
+
+
+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
+



Mime
View raw message