hive-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From hashut...@apache.org
Subject svn commit: r1579334 [2/2] - in /hive/branches/branch-0.13/ql/src/test: queries/clientpositive/ results/clientpositive/
Date Wed, 19 Mar 2014 18:22:33 GMT
Modified: hive/branches/branch-0.13/ql/src/test/results/clientpositive/groupby7_map_skew.q.out
URL: http://svn.apache.org/viewvc/hive/branches/branch-0.13/ql/src/test/results/clientpositive/groupby7_map_skew.q.out?rev=1579334&r1=1579333&r2=1579334&view=diff
==============================================================================
--- hive/branches/branch-0.13/ql/src/test/results/clientpositive/groupby7_map_skew.q.out (original)
+++ hive/branches/branch-0.13/ql/src/test/results/clientpositive/groupby7_map_skew.q.out Wed
Mar 19 18:22:31 2014
@@ -213,11 +213,11 @@ POSTHOOK: Lineage: dest1.key EXPRESSION 
 POSTHOOK: Lineage: dest1.value EXPRESSION [(src)src.FieldSchema(name:value, type:string,
comment:default), ]
 POSTHOOK: Lineage: dest2.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default),
]
 POSTHOOK: Lineage: dest2.value EXPRESSION [(src)src.FieldSchema(name:value, type:string,
comment:default), ]
-PREHOOK: query: SELECT DEST1.* FROM DEST1
+PREHOOK: query: SELECT DEST1.* FROM DEST1 ORDER BY key
 PREHOOK: type: QUERY
 PREHOOK: Input: default@dest1
 #### A masked pattern was here ####
-POSTHOOK: query: SELECT DEST1.* FROM DEST1
+POSTHOOK: query: SELECT DEST1.* FROM DEST1 ORDER BY key
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@dest1
 #### A masked pattern was here ####
@@ -226,19 +226,72 @@ POSTHOOK: Lineage: dest1.value EXPRESSIO
 POSTHOOK: Lineage: dest2.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default),
]
 POSTHOOK: Lineage: dest2.value EXPRESSION [(src)src.FieldSchema(name:value, type:string,
comment:default), ]
 0	0.0
+2	2.0
+4	4.0
+5	15.0
+8	8.0
+9	9.0
 10	10.0
+11	11.0
+12	24.0
+15	30.0
+17	17.0
+18	36.0
+19	19.0
+20	20.0
+24	48.0
+26	52.0
+27	27.0
+28	28.0
+30	30.0
+33	33.0
+34	34.0
+35	105.0
+37	74.0
+41	41.0
+42	84.0
+43	43.0
+44	44.0
+47	47.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
+80	80.0
+82	82.0
+83	166.0
+84	168.0
+85	85.0
+86	86.0
+87	87.0
+90	270.0
+92	92.0
+95	190.0
+96	96.0
+97	194.0
+98	196.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
@@ -254,7 +307,6 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
 145	145.0
 146	292.0
 149	298.0
-15	30.0
 150	150.0
 152	304.0
 153	153.0
@@ -271,7 +323,6 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
 167	501.0
 168	168.0
 169	676.0
-17	17.0
 170	170.0
 172	344.0
 174	348.0
@@ -280,14 +331,12 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
 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
@@ -297,8 +346,6 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
 196	196.0
 197	394.0
 199	597.0
-2	2.0
-20	20.0
 200	400.0
 201	201.0
 202	202.0
@@ -326,7 +373,6 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
 237	474.0
 238	476.0
 239	478.0
-24	48.0
 241	241.0
 242	484.0
 244	244.0
@@ -338,20 +384,17 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
 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
@@ -366,7 +409,6 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
 292	292.0
 296	296.0
 298	894.0
-30	30.0
 302	302.0
 305	305.0
 306	306.0
@@ -384,7 +426,6 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
 323	323.0
 325	650.0
 327	981.0
-33	33.0
 331	662.0
 332	332.0
 333	666.0
@@ -392,13 +433,11 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
 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
@@ -410,7 +449,6 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
 367	734.0
 368	368.0
 369	1107.0
-37	74.0
 373	373.0
 374	374.0
 375	375.0
@@ -428,7 +466,6 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
 396	1188.0
 397	794.0
 399	798.0
-4	4.0
 400	400.0
 401	2005.0
 402	402.0
@@ -437,19 +474,16 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
 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
@@ -458,7 +492,6 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
 437	437.0
 438	1314.0
 439	878.0
-44	44.0
 443	443.0
 444	444.0
 446	446.0
@@ -478,7 +511,6 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
 467	467.0
 468	1872.0
 469	2345.0
-47	47.0
 470	470.0
 472	472.0
 475	475.0
@@ -502,7 +534,46 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
 496	496.0
 497	497.0
 498	1494.0
+PREHOOK: query: SELECT DEST2.* FROM DEST2 ORDER BY key
+PREHOOK: type: QUERY
+PREHOOK: Input: default@dest2
+#### A masked pattern was here ####
+POSTHOOK: query: SELECT DEST2.* FROM DEST2 ORDER BY key
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@dest2
+#### A masked pattern was here ####
+POSTHOOK: Lineage: dest1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default),
]
+POSTHOOK: Lineage: dest1.value EXPRESSION [(src)src.FieldSchema(name:value, type:string,
comment:default), ]
+POSTHOOK: Lineage: dest2.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default),
]
+POSTHOOK: Lineage: dest2.value EXPRESSION [(src)src.FieldSchema(name:value, type:string,
comment:default), ]
+0	0.0
+2	2.0
+4	4.0
 5	15.0
+8	8.0
+9	9.0
+10	10.0
+11	11.0
+12	24.0
+15	30.0
+17	17.0
+18	36.0
+19	19.0
+20	20.0
+24	48.0
+26	52.0
+27	27.0
+28	28.0
+30	30.0
+33	33.0
+34	34.0
+35	105.0
+37	74.0
+41	41.0
+42	84.0
+43	43.0
+44	44.0
+47	47.0
 51	102.0
 53	53.0
 54	54.0
@@ -519,7 +590,6 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
 76	152.0
 77	77.0
 78	78.0
-8	8.0
 80	80.0
 82	82.0
 83	166.0
@@ -527,39 +597,22 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
 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
-PREHOOK: query: SELECT DEST2.* FROM DEST2
-PREHOOK: type: QUERY
-PREHOOK: Input: default@dest2
-#### A masked pattern was here ####
-POSTHOOK: query: SELECT DEST2.* FROM DEST2
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@dest2
-#### A masked pattern was here ####
-POSTHOOK: Lineage: dest1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default),
]
-POSTHOOK: Lineage: dest1.value EXPRESSION [(src)src.FieldSchema(name:value, type:string,
comment:default), ]
-POSTHOOK: Lineage: dest2.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default),
]
-POSTHOOK: Lineage: dest2.value EXPRESSION [(src)src.FieldSchema(name:value, type:string,
comment:default), ]
-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
@@ -575,7 +628,6 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
 145	145.0
 146	292.0
 149	298.0
-15	30.0
 150	150.0
 152	304.0
 153	153.0
@@ -592,7 +644,6 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
 167	501.0
 168	168.0
 169	676.0
-17	17.0
 170	170.0
 172	344.0
 174	348.0
@@ -601,14 +652,12 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
 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
@@ -618,8 +667,6 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
 196	196.0
 197	394.0
 199	597.0
-2	2.0
-20	20.0
 200	400.0
 201	201.0
 202	202.0
@@ -647,7 +694,6 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
 237	474.0
 238	476.0
 239	478.0
-24	48.0
 241	241.0
 242	484.0
 244	244.0
@@ -659,20 +705,17 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
 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
@@ -687,7 +730,6 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
 292	292.0
 296	296.0
 298	894.0
-30	30.0
 302	302.0
 305	305.0
 306	306.0
@@ -705,7 +747,6 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
 323	323.0
 325	650.0
 327	981.0
-33	33.0
 331	662.0
 332	332.0
 333	666.0
@@ -713,13 +754,11 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
 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
@@ -731,7 +770,6 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
 367	734.0
 368	368.0
 369	1107.0
-37	74.0
 373	373.0
 374	374.0
 375	375.0
@@ -749,7 +787,6 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
 396	1188.0
 397	794.0
 399	798.0
-4	4.0
 400	400.0
 401	2005.0
 402	402.0
@@ -758,19 +795,16 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
 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
@@ -779,7 +813,6 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
 437	437.0
 438	1314.0
 439	878.0
-44	44.0
 443	443.0
 444	444.0
 446	446.0
@@ -799,7 +832,6 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
 467	467.0
 468	1872.0
 469	2345.0
-47	47.0
 470	470.0
 472	472.0
 475	475.0
@@ -823,35 +855,3 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
 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: hive/branches/branch-0.13/ql/src/test/results/clientpositive/groupby7_noskew.q.out
URL: http://svn.apache.org/viewvc/hive/branches/branch-0.13/ql/src/test/results/clientpositive/groupby7_noskew.q.out?rev=1579334&r1=1579333&r2=1579334&view=diff
==============================================================================
--- hive/branches/branch-0.13/ql/src/test/results/clientpositive/groupby7_noskew.q.out (original)
+++ hive/branches/branch-0.13/ql/src/test/results/clientpositive/groupby7_noskew.q.out Wed
Mar 19 18:22:31 2014
@@ -151,11 +151,11 @@ POSTHOOK: Lineage: dest1.key EXPRESSION 
 POSTHOOK: Lineage: dest1.value EXPRESSION [(src)src.FieldSchema(name:value, type:string,
comment:default), ]
 POSTHOOK: Lineage: dest2.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default),
]
 POSTHOOK: Lineage: dest2.value EXPRESSION [(src)src.FieldSchema(name:value, type:string,
comment:default), ]
-PREHOOK: query: SELECT DEST1.* FROM DEST1
+PREHOOK: query: SELECT DEST1.* FROM DEST1 ORDER BY key
 PREHOOK: type: QUERY
 PREHOOK: Input: default@dest1
 #### A masked pattern was here ####
-POSTHOOK: query: SELECT DEST1.* FROM DEST1
+POSTHOOK: query: SELECT DEST1.* FROM DEST1 ORDER BY key
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@dest1
 #### A masked pattern was here ####
@@ -164,19 +164,72 @@ POSTHOOK: Lineage: dest1.value EXPRESSIO
 POSTHOOK: Lineage: dest2.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default),
]
 POSTHOOK: Lineage: dest2.value EXPRESSION [(src)src.FieldSchema(name:value, type:string,
comment:default), ]
 0	0.0
+2	2.0
+4	4.0
+5	15.0
+8	8.0
+9	9.0
 10	10.0
+11	11.0
+12	24.0
+15	30.0
+17	17.0
+18	36.0
+19	19.0
+20	20.0
+24	48.0
+26	52.0
+27	27.0
+28	28.0
+30	30.0
+33	33.0
+34	34.0
+35	105.0
+37	74.0
+41	41.0
+42	84.0
+43	43.0
+44	44.0
+47	47.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
+80	80.0
+82	82.0
+83	166.0
+84	168.0
+85	85.0
+86	86.0
+87	87.0
+90	270.0
+92	92.0
+95	190.0
+96	96.0
+97	194.0
+98	196.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
@@ -192,7 +245,6 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
 145	145.0
 146	292.0
 149	298.0
-15	30.0
 150	150.0
 152	304.0
 153	153.0
@@ -209,7 +261,6 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
 167	501.0
 168	168.0
 169	676.0
-17	17.0
 170	170.0
 172	344.0
 174	348.0
@@ -218,14 +269,12 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
 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
@@ -235,8 +284,6 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
 196	196.0
 197	394.0
 199	597.0
-2	2.0
-20	20.0
 200	400.0
 201	201.0
 202	202.0
@@ -264,7 +311,6 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
 237	474.0
 238	476.0
 239	478.0
-24	48.0
 241	241.0
 242	484.0
 244	244.0
@@ -276,20 +322,17 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
 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
@@ -304,7 +347,6 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
 292	292.0
 296	296.0
 298	894.0
-30	30.0
 302	302.0
 305	305.0
 306	306.0
@@ -322,7 +364,6 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
 323	323.0
 325	650.0
 327	981.0
-33	33.0
 331	662.0
 332	332.0
 333	666.0
@@ -330,13 +371,11 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
 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
@@ -348,7 +387,6 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
 367	734.0
 368	368.0
 369	1107.0
-37	74.0
 373	373.0
 374	374.0
 375	375.0
@@ -366,7 +404,6 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
 396	1188.0
 397	794.0
 399	798.0
-4	4.0
 400	400.0
 401	2005.0
 402	402.0
@@ -375,19 +412,16 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
 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
@@ -396,7 +430,6 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
 437	437.0
 438	1314.0
 439	878.0
-44	44.0
 443	443.0
 444	444.0
 446	446.0
@@ -416,7 +449,6 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
 467	467.0
 468	1872.0
 469	2345.0
-47	47.0
 470	470.0
 472	472.0
 475	475.0
@@ -440,7 +472,46 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
 496	496.0
 497	497.0
 498	1494.0
+PREHOOK: query: SELECT DEST2.* FROM DEST2 ORDER BY key
+PREHOOK: type: QUERY
+PREHOOK: Input: default@dest2
+#### A masked pattern was here ####
+POSTHOOK: query: SELECT DEST2.* FROM DEST2 ORDER BY key
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@dest2
+#### A masked pattern was here ####
+POSTHOOK: Lineage: dest1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default),
]
+POSTHOOK: Lineage: dest1.value EXPRESSION [(src)src.FieldSchema(name:value, type:string,
comment:default), ]
+POSTHOOK: Lineage: dest2.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default),
]
+POSTHOOK: Lineage: dest2.value EXPRESSION [(src)src.FieldSchema(name:value, type:string,
comment:default), ]
+0	0.0
+2	2.0
+4	4.0
 5	15.0
+8	8.0
+9	9.0
+10	10.0
+11	11.0
+12	24.0
+15	30.0
+17	17.0
+18	36.0
+19	19.0
+20	20.0
+24	48.0
+26	52.0
+27	27.0
+28	28.0
+30	30.0
+33	33.0
+34	34.0
+35	105.0
+37	74.0
+41	41.0
+42	84.0
+43	43.0
+44	44.0
+47	47.0
 51	102.0
 53	53.0
 54	54.0
@@ -457,7 +528,6 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
 76	152.0
 77	77.0
 78	78.0
-8	8.0
 80	80.0
 82	82.0
 83	166.0
@@ -465,39 +535,22 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
 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
-PREHOOK: query: SELECT DEST2.* FROM DEST2
-PREHOOK: type: QUERY
-PREHOOK: Input: default@dest2
-#### A masked pattern was here ####
-POSTHOOK: query: SELECT DEST2.* FROM DEST2
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@dest2
-#### A masked pattern was here ####
-POSTHOOK: Lineage: dest1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default),
]
-POSTHOOK: Lineage: dest1.value EXPRESSION [(src)src.FieldSchema(name:value, type:string,
comment:default), ]
-POSTHOOK: Lineage: dest2.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default),
]
-POSTHOOK: Lineage: dest2.value EXPRESSION [(src)src.FieldSchema(name:value, type:string,
comment:default), ]
-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
@@ -513,7 +566,6 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
 145	145.0
 146	292.0
 149	298.0
-15	30.0
 150	150.0
 152	304.0
 153	153.0
@@ -530,7 +582,6 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
 167	501.0
 168	168.0
 169	676.0
-17	17.0
 170	170.0
 172	344.0
 174	348.0
@@ -539,14 +590,12 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
 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
@@ -556,8 +605,6 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
 196	196.0
 197	394.0
 199	597.0
-2	2.0
-20	20.0
 200	400.0
 201	201.0
 202	202.0
@@ -585,7 +632,6 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
 237	474.0
 238	476.0
 239	478.0
-24	48.0
 241	241.0
 242	484.0
 244	244.0
@@ -597,20 +643,17 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
 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
@@ -625,7 +668,6 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
 292	292.0
 296	296.0
 298	894.0
-30	30.0
 302	302.0
 305	305.0
 306	306.0
@@ -643,7 +685,6 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
 323	323.0
 325	650.0
 327	981.0
-33	33.0
 331	662.0
 332	332.0
 333	666.0
@@ -651,13 +692,11 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
 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
@@ -669,7 +708,6 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
 367	734.0
 368	368.0
 369	1107.0
-37	74.0
 373	373.0
 374	374.0
 375	375.0
@@ -687,7 +725,6 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
 396	1188.0
 397	794.0
 399	798.0
-4	4.0
 400	400.0
 401	2005.0
 402	402.0
@@ -696,19 +733,16 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
 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
@@ -717,7 +751,6 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
 437	437.0
 438	1314.0
 439	878.0
-44	44.0
 443	443.0
 444	444.0
 446	446.0
@@ -737,7 +770,6 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
 467	467.0
 468	1872.0
 469	2345.0
-47	47.0
 470	470.0
 472	472.0
 475	475.0
@@ -761,35 +793,3 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
 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: hive/branches/branch-0.13/ql/src/test/results/clientpositive/groupby7_noskew_multi_single_reducer.q.out
URL: http://svn.apache.org/viewvc/hive/branches/branch-0.13/ql/src/test/results/clientpositive/groupby7_noskew_multi_single_reducer.q.out?rev=1579334&r1=1579333&r2=1579334&view=diff
==============================================================================
--- hive/branches/branch-0.13/ql/src/test/results/clientpositive/groupby7_noskew_multi_single_reducer.q.out
(original)
+++ hive/branches/branch-0.13/ql/src/test/results/clientpositive/groupby7_noskew_multi_single_reducer.q.out
Wed Mar 19 18:22:31 2014
@@ -171,15 +171,15 @@ STAGE PLANS:
     Stats-Aggr Operator
 
 PREHOOK: query: FROM SRC
-INSERT OVERWRITE TABLE DEST1 SELECT SRC.key, sum(SUBSTR(SRC.value,5)) GROUP BY SRC.key limit
10
-INSERT OVERWRITE TABLE DEST2 SELECT SRC.key, sum(SUBSTR(SRC.value,5)) GROUP BY SRC.key limit
10
+INSERT OVERWRITE TABLE DEST1 SELECT SRC.key, sum(SUBSTR(SRC.value,5)) GROUP BY SRC.key ORDER
BY SRC.key limit 10
+INSERT OVERWRITE TABLE DEST2 SELECT SRC.key, sum(SUBSTR(SRC.value,5)) GROUP BY SRC.key ORDER
BY SRC.key limit 10
 PREHOOK: type: QUERY
 PREHOOK: Input: default@src
 PREHOOK: Output: default@dest1
 PREHOOK: Output: default@dest2
 POSTHOOK: query: FROM SRC
-INSERT OVERWRITE TABLE DEST1 SELECT SRC.key, sum(SUBSTR(SRC.value,5)) GROUP BY SRC.key limit
10
-INSERT OVERWRITE TABLE DEST2 SELECT SRC.key, sum(SUBSTR(SRC.value,5)) GROUP BY SRC.key limit
10
+INSERT OVERWRITE TABLE DEST1 SELECT SRC.key, sum(SUBSTR(SRC.value,5)) GROUP BY SRC.key ORDER
BY SRC.key limit 10
+INSERT OVERWRITE TABLE DEST2 SELECT SRC.key, sum(SUBSTR(SRC.value,5)) GROUP BY SRC.key ORDER
BY SRC.key limit 10
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@src
 POSTHOOK: Output: default@dest1

Modified: hive/branches/branch-0.13/ql/src/test/results/clientpositive/groupby8_map.q.out
URL: http://svn.apache.org/viewvc/hive/branches/branch-0.13/ql/src/test/results/clientpositive/groupby8_map.q.out?rev=1579334&r1=1579333&r2=1579334&view=diff
==============================================================================
--- hive/branches/branch-0.13/ql/src/test/results/clientpositive/groupby8_map.q.out (original)
+++ hive/branches/branch-0.13/ql/src/test/results/clientpositive/groupby8_map.q.out Wed Mar
19 18:22:31 2014
@@ -176,11 +176,11 @@ POSTHOOK: Lineage: dest1.key EXPRESSION 
 POSTHOOK: Lineage: dest1.value EXPRESSION [(src)src.FieldSchema(name:value, type:string,
comment:default), ]
 POSTHOOK: Lineage: dest2.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default),
]
 POSTHOOK: Lineage: dest2.value EXPRESSION [(src)src.FieldSchema(name:value, type:string,
comment:default), ]
-PREHOOK: query: SELECT DEST1.* FROM DEST1
+PREHOOK: query: SELECT DEST1.* FROM DEST1 ORDER BY key
 PREHOOK: type: QUERY
 PREHOOK: Input: default@dest1
 #### A masked pattern was here ####
-POSTHOOK: query: SELECT DEST1.* FROM DEST1
+POSTHOOK: query: SELECT DEST1.* FROM DEST1 ORDER BY key
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@dest1
 #### A masked pattern was here ####
@@ -189,19 +189,72 @@ POSTHOOK: Lineage: dest1.value EXPRESSIO
 POSTHOOK: Lineage: dest2.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default),
]
 POSTHOOK: Lineage: dest2.value EXPRESSION [(src)src.FieldSchema(name:value, type:string,
comment:default), ]
 0	1
+2	1
+4	1
+5	1
+8	1
+9	1
 10	1
+11	1
+12	1
+15	1
+17	1
+18	1
+19	1
+20	1
+24	1
+26	1
+27	1
+28	1
+30	1
+33	1
+34	1
+35	1
+37	1
+41	1
+42	1
+43	1
+44	1
+47	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
+80	1
+82	1
+83	1
+84	1
+85	1
+86	1
+87	1
+90	1
+92	1
+95	1
+96	1
+97	1
+98	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
@@ -217,7 +270,6 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
 145	1
 146	1
 149	1
-15	1
 150	1
 152	1
 153	1
@@ -234,7 +286,6 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
 167	1
 168	1
 169	1
-17	1
 170	1
 172	1
 174	1
@@ -243,14 +294,12 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
 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
@@ -260,8 +309,6 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
 196	1
 197	1
 199	1
-2	1
-20	1
 200	1
 201	1
 202	1
@@ -289,7 +336,6 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
 237	1
 238	1
 239	1
-24	1
 241	1
 242	1
 244	1
@@ -301,20 +347,17 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
 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
@@ -329,7 +372,6 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
 292	1
 296	1
 298	1
-30	1
 302	1
 305	1
 306	1
@@ -347,7 +389,6 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
 323	1
 325	1
 327	1
-33	1
 331	1
 332	1
 333	1
@@ -355,13 +396,11 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
 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
@@ -373,7 +412,6 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
 367	1
 368	1
 369	1
-37	1
 373	1
 374	1
 375	1
@@ -391,7 +429,6 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
 396	1
 397	1
 399	1
-4	1
 400	1
 401	1
 402	1
@@ -400,19 +437,16 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
 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
@@ -421,7 +455,6 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
 437	1
 438	1
 439	1
-44	1
 443	1
 444	1
 446	1
@@ -441,7 +474,6 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
 467	1
 468	1
 469	1
-47	1
 470	1
 472	1
 475	1
@@ -465,7 +497,46 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
 496	1
 497	1
 498	1
+PREHOOK: query: SELECT DEST2.* FROM DEST2 ORDER BY key
+PREHOOK: type: QUERY
+PREHOOK: Input: default@dest2
+#### A masked pattern was here ####
+POSTHOOK: query: SELECT DEST2.* FROM DEST2 ORDER BY key
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@dest2
+#### A masked pattern was here ####
+POSTHOOK: Lineage: dest1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default),
]
+POSTHOOK: Lineage: dest1.value EXPRESSION [(src)src.FieldSchema(name:value, type:string,
comment:default), ]
+POSTHOOK: Lineage: dest2.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default),
]
+POSTHOOK: Lineage: dest2.value EXPRESSION [(src)src.FieldSchema(name:value, type:string,
comment:default), ]
+0	1
+2	1
+4	1
 5	1
+8	1
+9	1
+10	1
+11	1
+12	1
+15	1
+17	1
+18	1
+19	1
+20	1
+24	1
+26	1
+27	1
+28	1
+30	1
+33	1
+34	1
+35	1
+37	1
+41	1
+42	1
+43	1
+44	1
+47	1
 51	1
 53	1
 54	1
@@ -482,7 +553,6 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
 76	1
 77	1
 78	1
-8	1
 80	1
 82	1
 83	1
@@ -490,39 +560,22 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
 85	1
 86	1
 87	1
-9	1
 90	1
 92	1
 95	1
 96	1
 97	1
 98	1
-PREHOOK: query: SELECT DEST2.* FROM DEST2
-PREHOOK: type: QUERY
-PREHOOK: Input: default@dest2
-#### A masked pattern was here ####
-POSTHOOK: query: SELECT DEST2.* FROM DEST2
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@dest2
-#### A masked pattern was here ####
-POSTHOOK: Lineage: dest1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default),
]
-POSTHOOK: Lineage: dest1.value EXPRESSION [(src)src.FieldSchema(name:value, type:string,
comment:default), ]
-POSTHOOK: Lineage: dest2.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default),
]
-POSTHOOK: Lineage: dest2.value EXPRESSION [(src)src.FieldSchema(name:value, type:string,
comment:default), ]
-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
@@ -538,7 +591,6 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
 145	1
 146	1
 149	1
-15	1
 150	1
 152	1
 153	1
@@ -555,7 +607,6 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
 167	1
 168	1
 169	1
-17	1
 170	1
 172	1
 174	1
@@ -564,14 +615,12 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
 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
@@ -581,8 +630,6 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
 196	1
 197	1
 199	1
-2	1
-20	1
 200	1
 201	1
 202	1
@@ -610,7 +657,6 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
 237	1
 238	1
 239	1
-24	1
 241	1
 242	1
 244	1
@@ -622,20 +668,17 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
 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
@@ -650,7 +693,6 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
 292	1
 296	1
 298	1
-30	1
 302	1
 305	1
 306	1
@@ -668,7 +710,6 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
 323	1
 325	1
 327	1
-33	1
 331	1
 332	1
 333	1
@@ -676,13 +717,11 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
 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
@@ -694,7 +733,6 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
 367	1
 368	1
 369	1
-37	1
 373	1
 374	1
 375	1
@@ -712,7 +750,6 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
 396	1
 397	1
 399	1
-4	1
 400	1
 401	1
 402	1
@@ -721,19 +758,16 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
 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
@@ -742,7 +776,6 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
 437	1
 438	1
 439	1
-44	1
 443	1
 444	1
 446	1
@@ -762,7 +795,6 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
 467	1
 468	1
 469	1
-47	1
 470	1
 472	1
 475	1
@@ -786,35 +818,3 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
 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: hive/branches/branch-0.13/ql/src/test/results/clientpositive/groupby8_map_skew.q.out
URL: http://svn.apache.org/viewvc/hive/branches/branch-0.13/ql/src/test/results/clientpositive/groupby8_map_skew.q.out?rev=1579334&r1=1579333&r2=1579334&view=diff
==============================================================================
--- hive/branches/branch-0.13/ql/src/test/results/clientpositive/groupby8_map_skew.q.out (original)
+++ hive/branches/branch-0.13/ql/src/test/results/clientpositive/groupby8_map_skew.q.out Wed
Mar 19 18:22:31 2014
@@ -176,11 +176,11 @@ POSTHOOK: Lineage: dest1.key EXPRESSION 
 POSTHOOK: Lineage: dest1.value EXPRESSION [(src)src.FieldSchema(name:value, type:string,
comment:default), ]
 POSTHOOK: Lineage: dest2.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default),
]
 POSTHOOK: Lineage: dest2.value EXPRESSION [(src)src.FieldSchema(name:value, type:string,
comment:default), ]
-PREHOOK: query: SELECT DEST1.* FROM DEST1
+PREHOOK: query: SELECT DEST1.* FROM DEST1 ORDER BY key
 PREHOOK: type: QUERY
 PREHOOK: Input: default@dest1
 #### A masked pattern was here ####
-POSTHOOK: query: SELECT DEST1.* FROM DEST1
+POSTHOOK: query: SELECT DEST1.* FROM DEST1 ORDER BY key
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@dest1
 #### A masked pattern was here ####
@@ -189,19 +189,72 @@ POSTHOOK: Lineage: dest1.value EXPRESSIO
 POSTHOOK: Lineage: dest2.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default),
]
 POSTHOOK: Lineage: dest2.value EXPRESSION [(src)src.FieldSchema(name:value, type:string,
comment:default), ]
 0	1
+2	1
+4	1
+5	1
+8	1
+9	1
 10	1
+11	1
+12	1
+15	1
+17	1
+18	1
+19	1
+20	1
+24	1
+26	1
+27	1
+28	1
+30	1
+33	1
+34	1
+35	1
+37	1
+41	1
+42	1
+43	1
+44	1
+47	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
+80	1
+82	1
+83	1
+84	1
+85	1
+86	1
+87	1
+90	1
+92	1
+95	1
+96	1
+97	1
+98	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
@@ -217,7 +270,6 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
 145	1
 146	1
 149	1
-15	1
 150	1
 152	1
 153	1
@@ -234,7 +286,6 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
 167	1
 168	1
 169	1
-17	1
 170	1
 172	1
 174	1
@@ -243,14 +294,12 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
 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
@@ -260,8 +309,6 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
 196	1
 197	1
 199	1
-2	1
-20	1
 200	1
 201	1
 202	1
@@ -289,7 +336,6 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
 237	1
 238	1
 239	1
-24	1
 241	1
 242	1
 244	1
@@ -301,20 +347,17 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
 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
@@ -329,7 +372,6 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
 292	1
 296	1
 298	1
-30	1
 302	1
 305	1
 306	1
@@ -347,7 +389,6 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
 323	1
 325	1
 327	1
-33	1
 331	1
 332	1
 333	1
@@ -355,13 +396,11 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
 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
@@ -373,7 +412,6 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
 367	1
 368	1
 369	1
-37	1
 373	1
 374	1
 375	1
@@ -391,7 +429,6 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
 396	1
 397	1
 399	1
-4	1
 400	1
 401	1
 402	1
@@ -400,19 +437,16 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
 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
@@ -421,7 +455,6 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
 437	1
 438	1
 439	1
-44	1
 443	1
 444	1
 446	1
@@ -441,7 +474,6 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
 467	1
 468	1
 469	1
-47	1
 470	1
 472	1
 475	1
@@ -465,7 +497,46 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
 496	1
 497	1
 498	1
+PREHOOK: query: SELECT DEST2.* FROM DEST2 ORDER BY key
+PREHOOK: type: QUERY
+PREHOOK: Input: default@dest2
+#### A masked pattern was here ####
+POSTHOOK: query: SELECT DEST2.* FROM DEST2 ORDER BY key
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@dest2
+#### A masked pattern was here ####
+POSTHOOK: Lineage: dest1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default),
]
+POSTHOOK: Lineage: dest1.value EXPRESSION [(src)src.FieldSchema(name:value, type:string,
comment:default), ]
+POSTHOOK: Lineage: dest2.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default),
]
+POSTHOOK: Lineage: dest2.value EXPRESSION [(src)src.FieldSchema(name:value, type:string,
comment:default), ]
+0	1
+2	1
+4	1
 5	1
+8	1
+9	1
+10	1
+11	1
+12	1
+15	1
+17	1
+18	1
+19	1
+20	1
+24	1
+26	1
+27	1
+28	1
+30	1
+33	1
+34	1
+35	1
+37	1
+41	1
+42	1
+43	1
+44	1
+47	1
 51	1
 53	1
 54	1
@@ -482,7 +553,6 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
 76	1
 77	1
 78	1
-8	1
 80	1
 82	1
 83	1
@@ -490,39 +560,22 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
 85	1
 86	1
 87	1
-9	1
 90	1
 92	1
 95	1
 96	1
 97	1
 98	1
-PREHOOK: query: SELECT DEST2.* FROM DEST2
-PREHOOK: type: QUERY
-PREHOOK: Input: default@dest2
-#### A masked pattern was here ####
-POSTHOOK: query: SELECT DEST2.* FROM DEST2
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@dest2
-#### A masked pattern was here ####
-POSTHOOK: Lineage: dest1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default),
]
-POSTHOOK: Lineage: dest1.value EXPRESSION [(src)src.FieldSchema(name:value, type:string,
comment:default), ]
-POSTHOOK: Lineage: dest2.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default),
]
-POSTHOOK: Lineage: dest2.value EXPRESSION [(src)src.FieldSchema(name:value, type:string,
comment:default), ]
-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
@@ -538,7 +591,6 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
 145	1
 146	1
 149	1
-15	1
 150	1
 152	1
 153	1
@@ -555,7 +607,6 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
 167	1
 168	1
 169	1
-17	1
 170	1
 172	1
 174	1
@@ -564,14 +615,12 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
 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
@@ -581,8 +630,6 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
 196	1
 197	1
 199	1
-2	1
-20	1
 200	1
 201	1
 202	1
@@ -610,7 +657,6 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
 237	1
 238	1
 239	1
-24	1
 241	1
 242	1
 244	1
@@ -622,20 +668,17 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
 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
@@ -650,7 +693,6 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
 292	1
 296	1
 298	1
-30	1
 302	1
 305	1
 306	1
@@ -668,7 +710,6 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
 323	1
 325	1
 327	1
-33	1
 331	1
 332	1
 333	1
@@ -676,13 +717,11 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
 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
@@ -694,7 +733,6 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
 367	1
 368	1
 369	1
-37	1
 373	1
 374	1
 375	1
@@ -712,7 +750,6 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
 396	1
 397	1
 399	1
-4	1
 400	1
 401	1
 402	1
@@ -721,19 +758,16 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
 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
@@ -742,7 +776,6 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
 437	1
 438	1
 439	1
-44	1
 443	1
 444	1
 446	1
@@ -762,7 +795,6 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
 467	1
 468	1
 469	1
-47	1
 470	1
 472	1
 475	1
@@ -786,35 +818,3 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
 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: hive/branches/branch-0.13/ql/src/test/results/clientpositive/groupby8_noskew.q.out
URL: http://svn.apache.org/viewvc/hive/branches/branch-0.13/ql/src/test/results/clientpositive/groupby8_noskew.q.out?rev=1579334&r1=1579333&r2=1579334&view=diff
==============================================================================
--- hive/branches/branch-0.13/ql/src/test/results/clientpositive/groupby8_noskew.q.out (original)
+++ hive/branches/branch-0.13/ql/src/test/results/clientpositive/groupby8_noskew.q.out Wed
Mar 19 18:22:31 2014
@@ -176,11 +176,11 @@ POSTHOOK: Lineage: dest1.key EXPRESSION 
 POSTHOOK: Lineage: dest1.value EXPRESSION [(src)src.FieldSchema(name:value, type:string,
comment:default), ]
 POSTHOOK: Lineage: dest2.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default),
]
 POSTHOOK: Lineage: dest2.value EXPRESSION [(src)src.FieldSchema(name:value, type:string,
comment:default), ]
-PREHOOK: query: SELECT DEST1.* FROM DEST1
+PREHOOK: query: SELECT DEST1.* FROM DEST1 ORDER BY key
 PREHOOK: type: QUERY
 PREHOOK: Input: default@dest1
 #### A masked pattern was here ####
-POSTHOOK: query: SELECT DEST1.* FROM DEST1
+POSTHOOK: query: SELECT DEST1.* FROM DEST1 ORDER BY key
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@dest1
 #### A masked pattern was here ####
@@ -189,19 +189,72 @@ POSTHOOK: Lineage: dest1.value EXPRESSIO
 POSTHOOK: Lineage: dest2.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default),
]
 POSTHOOK: Lineage: dest2.value EXPRESSION [(src)src.FieldSchema(name:value, type:string,
comment:default), ]
 0	1
+2	1
+4	1
+5	1
+8	1
+9	1
 10	1
+11	1
+12	1
+15	1
+17	1
+18	1
+19	1
+20	1
+24	1
+26	1
+27	1
+28	1
+30	1
+33	1
+34	1
+35	1
+37	1
+41	1
+42	1
+43	1
+44	1
+47	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
+80	1
+82	1
+83	1
+84	1
+85	1
+86	1
+87	1
+90	1
+92	1
+95	1
+96	1
+97	1
+98	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
@@ -217,7 +270,6 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
 145	1
 146	1
 149	1
-15	1
 150	1
 152	1
 153	1
@@ -234,7 +286,6 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
 167	1
 168	1
 169	1
-17	1
 170	1
 172	1
 174	1
@@ -243,14 +294,12 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
 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
@@ -260,8 +309,6 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
 196	1
 197	1
 199	1
-2	1
-20	1
 200	1
 201	1
 202	1
@@ -289,7 +336,6 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
 237	1
 238	1
 239	1
-24	1
 241	1
 242	1
 244	1
@@ -301,20 +347,17 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
 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
@@ -329,7 +372,6 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
 292	1
 296	1
 298	1
-30	1
 302	1
 305	1
 306	1
@@ -347,7 +389,6 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
 323	1
 325	1
 327	1
-33	1
 331	1
 332	1
 333	1
@@ -355,13 +396,11 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
 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
@@ -373,7 +412,6 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
 367	1
 368	1
 369	1
-37	1
 373	1
 374	1
 375	1
@@ -391,7 +429,6 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
 396	1
 397	1
 399	1
-4	1
 400	1
 401	1
 402	1
@@ -400,19 +437,16 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
 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
@@ -421,7 +455,6 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
 437	1
 438	1
 439	1
-44	1
 443	1
 444	1
 446	1
@@ -441,7 +474,6 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
 467	1
 468	1
 469	1
-47	1
 470	1
 472	1
 475	1
@@ -465,7 +497,46 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
 496	1
 497	1
 498	1
+PREHOOK: query: SELECT DEST2.* FROM DEST2 ORDER BY key
+PREHOOK: type: QUERY
+PREHOOK: Input: default@dest2
+#### A masked pattern was here ####
+POSTHOOK: query: SELECT DEST2.* FROM DEST2 ORDER BY key
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@dest2
+#### A masked pattern was here ####
+POSTHOOK: Lineage: dest1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default),
]
+POSTHOOK: Lineage: dest1.value EXPRESSION [(src)src.FieldSchema(name:value, type:string,
comment:default), ]
+POSTHOOK: Lineage: dest2.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default),
]
+POSTHOOK: Lineage: dest2.value EXPRESSION [(src)src.FieldSchema(name:value, type:string,
comment:default), ]
+0	1
+2	1
+4	1
 5	1
+8	1
+9	1
+10	1
+11	1
+12	1
+15	1
+17	1
+18	1
+19	1
+20	1
+24	1
+26	1
+27	1
+28	1
+30	1
+33	1
+34	1
+35	1
+37	1
+41	1
+42	1
+43	1
+44	1
+47	1
 51	1
 53	1
 54	1
@@ -482,7 +553,6 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
 76	1
 77	1
 78	1
-8	1
 80	1
 82	1
 83	1
@@ -490,39 +560,22 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
 85	1
 86	1
 87	1
-9	1
 90	1
 92	1
 95	1
 96	1
 97	1
 98	1
-PREHOOK: query: SELECT DEST2.* FROM DEST2
-PREHOOK: type: QUERY
-PREHOOK: Input: default@dest2
-#### A masked pattern was here ####
-POSTHOOK: query: SELECT DEST2.* FROM DEST2
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@dest2
-#### A masked pattern was here ####
-POSTHOOK: Lineage: dest1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default),
]
-POSTHOOK: Lineage: dest1.value EXPRESSION [(src)src.FieldSchema(name:value, type:string,
comment:default), ]
-POSTHOOK: Lineage: dest2.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default),
]
-POSTHOOK: Lineage: dest2.value EXPRESSION [(src)src.FieldSchema(name:value, type:string,
comment:default), ]
-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
@@ -538,7 +591,6 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
 145	1
 146	1
 149	1
-15	1
 150	1
 152	1
 153	1
@@ -555,7 +607,6 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
 167	1
 168	1
 169	1
-17	1
 170	1
 172	1
 174	1
@@ -564,14 +615,12 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
 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
@@ -581,8 +630,6 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
 196	1
 197	1
 199	1
-2	1
-20	1
 200	1
 201	1
 202	1
@@ -610,7 +657,6 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
 237	1
 238	1
 239	1
-24	1
 241	1
 242	1
 244	1
@@ -622,20 +668,17 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
 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
@@ -650,7 +693,6 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
 292	1
 296	1
 298	1
-30	1
 302	1
 305	1
 306	1
@@ -668,7 +710,6 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
 323	1
 325	1
 327	1
-33	1
 331	1
 332	1
 333	1
@@ -676,13 +717,11 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
 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
@@ -694,7 +733,6 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
 367	1
 368	1
 369	1
-37	1
 373	1
 374	1
 375	1
@@ -712,7 +750,6 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
 396	1
 397	1
 399	1
-4	1
 400	1
 401	1
 402	1
@@ -721,19 +758,16 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
 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
@@ -742,7 +776,6 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
 437	1
 438	1
 439	1
-44	1
 443	1
 444	1
 446	1
@@ -762,7 +795,6 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
 467	1
 468	1
 469	1
-47	1
 470	1
 472	1
 475	1
@@ -786,35 +818,3 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
 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: hive/branches/branch-0.13/ql/src/test/results/clientpositive/groupby_map_ppr.q.out
URL: http://svn.apache.org/viewvc/hive/branches/branch-0.13/ql/src/test/results/clientpositive/groupby_map_ppr.q.out?rev=1579334&r1=1579333&r2=1579334&view=diff
==============================================================================
--- hive/branches/branch-0.13/ql/src/test/results/clientpositive/groupby_map_ppr.q.out (original)
+++ hive/branches/branch-0.13/ql/src/test/results/clientpositive/groupby_map_ppr.q.out Wed
Mar 19 18:22:31 2014
@@ -296,11 +296,11 @@ POSTHOOK: Output: default@dest1
 POSTHOOK: Lineage: dest1.c1 EXPRESSION [(srcpart)src.FieldSchema(name:value, type:string,
comment:default), ]
 POSTHOOK: Lineage: dest1.c2 EXPRESSION [(srcpart)src.FieldSchema(name:key, type:string, comment:default),
(srcpart)src.FieldSchema(name:value, type:string, comment:default), ]
 POSTHOOK: Lineage: dest1.key EXPRESSION [(srcpart)src.FieldSchema(name:key, type:string,
comment:default), ]
-PREHOOK: query: SELECT dest1.* FROM dest1
+PREHOOK: query: SELECT dest1.* FROM dest1 ORDER BY key
 PREHOOK: type: QUERY
 PREHOOK: Input: default@dest1
 #### A masked pattern was here ####
-POSTHOOK: query: SELECT dest1.* FROM dest1
+POSTHOOK: query: SELECT dest1.* FROM dest1 ORDER BY key
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@dest1
 #### A masked pattern was here ####

Modified: hive/branches/branch-0.13/ql/src/test/results/clientpositive/groupby_map_ppr_multi_distinct.q.out
URL: http://svn.apache.org/viewvc/hive/branches/branch-0.13/ql/src/test/results/clientpositive/groupby_map_ppr_multi_distinct.q.out?rev=1579334&r1=1579333&r2=1579334&view=diff
==============================================================================
--- hive/branches/branch-0.13/ql/src/test/results/clientpositive/groupby_map_ppr_multi_distinct.q.out
(original)
+++ hive/branches/branch-0.13/ql/src/test/results/clientpositive/groupby_map_ppr_multi_distinct.q.out
Wed Mar 19 18:22:31 2014
@@ -315,11 +315,11 @@ POSTHOOK: Lineage: dest1.c2 EXPRESSION [
 POSTHOOK: Lineage: dest1.c3 EXPRESSION [(srcpart)src.null, ]
 POSTHOOK: Lineage: dest1.c4 EXPRESSION [(srcpart)src.FieldSchema(name:value, type:string,
comment:default), ]
 POSTHOOK: Lineage: dest1.key EXPRESSION [(srcpart)src.FieldSchema(name:key, type:string,
comment:default), ]
-PREHOOK: query: SELECT dest1.* FROM dest1
+PREHOOK: query: SELECT dest1.* FROM dest1 ORDER BY key
 PREHOOK: type: QUERY
 PREHOOK: Input: default@dest1
 #### A masked pattern was here ####
-POSTHOOK: query: SELECT dest1.* FROM dest1
+POSTHOOK: query: SELECT dest1.* FROM dest1 ORDER BY key
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@dest1
 #### A masked pattern was here ####

Modified: hive/branches/branch-0.13/ql/src/test/results/clientpositive/groupby_resolution.q.out
URL: http://svn.apache.org/viewvc/hive/branches/branch-0.13/ql/src/test/results/clientpositive/groupby_resolution.q.out?rev=1579334&r1=1579333&r2=1579334&view=diff
==============================================================================
--- hive/branches/branch-0.13/ql/src/test/results/clientpositive/groupby_resolution.q.out
(original)
+++ hive/branches/branch-0.13/ql/src/test/results/clientpositive/groupby_resolution.q.out
Wed Mar 19 18:22:31 2014
@@ -507,6 +507,7 @@ select key, count(*), rank() over(order 
 from src b
 where key < '12'
 group by b.key
+order by b.key
 PREHOOK: type: QUERY
 PREHOOK: Input: default@src
 #### A masked pattern was here ####
@@ -515,27 +516,29 @@ select key, count(*), rank() over(order 
 from src b
 where key < '12'
 group by b.key
+order by b.key
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@src
 #### A masked pattern was here ####
+0	3	12
 10	1	1
+100	2	7
+103	2	7
+104	2	7
 105	1	1
 11	1	1
 111	1	1
+113	2	7
 114	1	1
 116	1	1
 118	2	7
-100	2	7
-103	2	7
-104	2	7
-113	2	7
-0	3	12
 119	3	12
 PREHOOK: query: -- having after group by
 select key, count(*)
 from src b
 group by b.key
 having key < '12'
+order by b.key
 PREHOOK: type: QUERY
 PREHOOK: Input: default@src
 #### A masked pattern was here ####
@@ -544,6 +547,7 @@ select key, count(*)
 from src b
 group by b.key
 having key < '12'
+order by b.key
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@src
 #### A masked pattern was here ####
@@ -565,6 +569,7 @@ select key, count(*), rank() over(order 
 from src b
 group by b.key
 having key < '12'
+order by b.key
 PREHOOK: type: QUERY
 PREHOOK: Input: default@src
 #### A masked pattern was here ####
@@ -573,21 +578,22 @@ select key, count(*), rank() over(order 
 from src b
 group by b.key
 having key < '12'
+order by b.key
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@src
 #### A masked pattern was here ####
+0	3	12
 10	1	1
+100	2	7
+103	2	7
+104	2	7
 105	1	1
 11	1	1
 111	1	1
+113	2	7
 114	1	1
 116	1	1
 118	2	7
-100	2	7
-103	2	7
-104	2	7
-113	2	7
-0	3	12
 119	3	12
 PREHOOK: query: explain
 select key, count(*), rank() over(order by count(*))



Mime
View raw message