You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by ha...@apache.org on 2014/03/19 19:21:55 UTC
svn commit: r1579333 [2/2] - in /hive/trunk/ql/src/test:
queries/clientpositive/ results/clientpositive/
Modified: hive/trunk/ql/src/test/results/clientpositive/groupby7_noskew.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/groupby7_noskew.q.out?rev=1579333&r1=1579332&r2=1579333&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/groupby7_noskew.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/groupby7_noskew.q.out Wed Mar 19 18:21:53 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/trunk/ql/src/test/results/clientpositive/groupby7_noskew_multi_single_reducer.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/groupby7_noskew_multi_single_reducer.q.out?rev=1579333&r1=1579332&r2=1579333&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/groupby7_noskew_multi_single_reducer.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/groupby7_noskew_multi_single_reducer.q.out Wed Mar 19 18:21:53 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/trunk/ql/src/test/results/clientpositive/groupby8_map.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/groupby8_map.q.out?rev=1579333&r1=1579332&r2=1579333&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/groupby8_map.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/groupby8_map.q.out Wed Mar 19 18:21:53 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/trunk/ql/src/test/results/clientpositive/groupby8_map_skew.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/groupby8_map_skew.q.out?rev=1579333&r1=1579332&r2=1579333&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/groupby8_map_skew.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/groupby8_map_skew.q.out Wed Mar 19 18:21:53 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/trunk/ql/src/test/results/clientpositive/groupby8_noskew.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/groupby8_noskew.q.out?rev=1579333&r1=1579332&r2=1579333&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/groupby8_noskew.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/groupby8_noskew.q.out Wed Mar 19 18:21:53 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/trunk/ql/src/test/results/clientpositive/groupby_map_ppr.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/groupby_map_ppr.q.out?rev=1579333&r1=1579332&r2=1579333&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/groupby_map_ppr.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/groupby_map_ppr.q.out Wed Mar 19 18:21:53 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/trunk/ql/src/test/results/clientpositive/groupby_map_ppr_multi_distinct.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/groupby_map_ppr_multi_distinct.q.out?rev=1579333&r1=1579332&r2=1579333&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/groupby_map_ppr_multi_distinct.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/groupby_map_ppr_multi_distinct.q.out Wed Mar 19 18:21:53 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/trunk/ql/src/test/results/clientpositive/groupby_resolution.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/groupby_resolution.q.out?rev=1579333&r1=1579332&r2=1579333&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/groupby_resolution.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/groupby_resolution.q.out Wed Mar 19 18:21:53 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(*))