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/05/30 19:37:15 UTC
svn commit: r1598678 [12/31] - in /hive/trunk:
cli/src/java/org/apache/hadoop/hive/cli/
common/src/java/org/apache/hadoop/hive/common/io/
itests/util/src/main/java/org/apache/hadoop/hive/ql/
ql/src/java/org/apache/hadoop/hive/ql/ ql/src/java/org/apache...
Modified: hive/trunk/ql/src/test/results/clientpositive/groupby1_limit.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/groupby1_limit.q.out?rev=1598678&r1=1598677&r2=1598678&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/groupby1_limit.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/groupby1_limit.q.out Fri May 30 17:37:05 2014
@@ -1,7 +1,11 @@
-PREHOOK: query: CREATE TABLE dest1(key INT, value DOUBLE) STORED AS TEXTFILE
+PREHOOK: query: -- SORT_QUERY_RESULTS
+
+CREATE TABLE dest1(key INT, value DOUBLE) STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
-POSTHOOK: query: CREATE TABLE dest1(key INT, value DOUBLE) STORED AS TEXTFILE
+POSTHOOK: query: -- SORT_QUERY_RESULTS
+
+CREATE TABLE dest1(key INT, value DOUBLE) STORED AS TEXTFILE
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@dest1
@@ -111,11 +115,11 @@ POSTHOOK: Input: default@src
POSTHOOK: Output: default@dest1
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), ]
-PREHOOK: query: SELECT dest1.* FROM dest1 ORDER BY dest1.key ASC , dest1.value ASC
+PREHOOK: query: SELECT dest1.* FROM dest1
PREHOOK: type: QUERY
PREHOOK: Input: default@dest1
#### A masked pattern was here ####
-POSTHOOK: query: SELECT dest1.* FROM dest1 ORDER BY dest1.key ASC , dest1.value ASC
+POSTHOOK: query: SELECT dest1.* FROM dest1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@dest1
#### A masked pattern was here ####
Modified: hive/trunk/ql/src/test/results/clientpositive/groupby1_map.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/groupby1_map.q.out?rev=1598678&r1=1598677&r2=1598678&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/groupby1_map.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/groupby1_map.q.out Fri May 30 17:37:05 2014
@@ -1,7 +1,11 @@
-PREHOOK: query: CREATE TABLE dest1(key INT, value DOUBLE) STORED AS TEXTFILE
+PREHOOK: query: -- SORT_QUERY_RESULTS
+
+CREATE TABLE dest1(key INT, value DOUBLE) STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
-POSTHOOK: query: CREATE TABLE dest1(key INT, value DOUBLE) STORED AS TEXTFILE
+POSTHOOK: query: -- SORT_QUERY_RESULTS
+
+CREATE TABLE dest1(key INT, value DOUBLE) STORED AS TEXTFILE
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@dest1
@@ -82,81 +86,28 @@ POSTHOOK: Input: default@src
POSTHOOK: Output: default@dest1
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), ]
-PREHOOK: query: SELECT dest1.* FROM dest1 ORDER BY key
+PREHOOK: query: SELECT dest1.* FROM dest1
PREHOOK: type: QUERY
PREHOOK: Input: default@dest1
#### A masked pattern was here ####
-POSTHOOK: query: SELECT dest1.* FROM dest1 ORDER BY key
+POSTHOOK: query: SELECT dest1.* FROM dest1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@dest1
#### A masked pattern was here ####
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
@@ -172,6 +123,7 @@ POSTHOOK: Input: default@dest1
145 145.0
146 292.0
149 298.0
+15 30.0
150 150.0
152 304.0
153 153.0
@@ -188,6 +140,7 @@ POSTHOOK: Input: default@dest1
167 501.0
168 168.0
169 676.0
+17 17.0
170 170.0
172 344.0
174 348.0
@@ -196,12 +149,14 @@ POSTHOOK: Input: default@dest1
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
@@ -211,6 +166,8 @@ POSTHOOK: Input: default@dest1
196 196.0
197 394.0
199 597.0
+2 2.0
+20 20.0
200 400.0
201 201.0
202 202.0
@@ -238,6 +195,7 @@ POSTHOOK: Input: default@dest1
237 474.0
238 476.0
239 478.0
+24 48.0
241 241.0
242 484.0
244 244.0
@@ -249,17 +207,20 @@ POSTHOOK: Input: default@dest1
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
@@ -274,6 +235,7 @@ POSTHOOK: Input: default@dest1
292 292.0
296 296.0
298 894.0
+30 30.0
302 302.0
305 305.0
306 306.0
@@ -291,6 +253,7 @@ POSTHOOK: Input: default@dest1
323 323.0
325 650.0
327 981.0
+33 33.0
331 662.0
332 332.0
333 666.0
@@ -298,11 +261,13 @@ POSTHOOK: Input: default@dest1
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
@@ -314,6 +279,7 @@ POSTHOOK: Input: default@dest1
367 734.0
368 368.0
369 1107.0
+37 74.0
373 373.0
374 374.0
375 375.0
@@ -331,6 +297,7 @@ POSTHOOK: Input: default@dest1
396 1188.0
397 794.0
399 798.0
+4 4.0
400 400.0
401 2005.0
402 402.0
@@ -339,16 +306,19 @@ POSTHOOK: Input: default@dest1
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
@@ -357,6 +327,7 @@ POSTHOOK: Input: default@dest1
437 437.0
438 1314.0
439 878.0
+44 44.0
443 443.0
444 444.0
446 446.0
@@ -376,6 +347,7 @@ POSTHOOK: Input: default@dest1
467 467.0
468 1872.0
469 2345.0
+47 47.0
470 470.0
472 472.0
475 475.0
@@ -399,3 +371,35 @@ POSTHOOK: Input: default@dest1
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/groupby1_map_skew.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/groupby1_map_skew.q.out?rev=1598678&r1=1598677&r2=1598678&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/groupby1_map_skew.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/groupby1_map_skew.q.out Fri May 30 17:37:05 2014
@@ -1,7 +1,11 @@
-PREHOOK: query: CREATE TABLE dest1(key INT, value DOUBLE) STORED AS TEXTFILE
+PREHOOK: query: -- SORT_QUERY_RESULTS
+
+CREATE TABLE dest1(key INT, value DOUBLE) STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
-POSTHOOK: query: CREATE TABLE dest1(key INT, value DOUBLE) STORED AS TEXTFILE
+POSTHOOK: query: -- SORT_QUERY_RESULTS
+
+CREATE TABLE dest1(key INT, value DOUBLE) STORED AS TEXTFILE
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@dest1
@@ -107,81 +111,28 @@ POSTHOOK: Input: default@src
POSTHOOK: Output: default@dest1
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), ]
-PREHOOK: query: SELECT dest1.* FROM dest1 ORDER BY key
+PREHOOK: query: SELECT dest1.* FROM dest1
PREHOOK: type: QUERY
PREHOOK: Input: default@dest1
#### A masked pattern was here ####
-POSTHOOK: query: SELECT dest1.* FROM dest1 ORDER BY key
+POSTHOOK: query: SELECT dest1.* FROM dest1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@dest1
#### A masked pattern was here ####
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
@@ -197,6 +148,7 @@ POSTHOOK: Input: default@dest1
145 145.0
146 292.0
149 298.0
+15 30.0
150 150.0
152 304.0
153 153.0
@@ -213,6 +165,7 @@ POSTHOOK: Input: default@dest1
167 501.0
168 168.0
169 676.0
+17 17.0
170 170.0
172 344.0
174 348.0
@@ -221,12 +174,14 @@ POSTHOOK: Input: default@dest1
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
@@ -236,6 +191,8 @@ POSTHOOK: Input: default@dest1
196 196.0
197 394.0
199 597.0
+2 2.0
+20 20.0
200 400.0
201 201.0
202 202.0
@@ -263,6 +220,7 @@ POSTHOOK: Input: default@dest1
237 474.0
238 476.0
239 478.0
+24 48.0
241 241.0
242 484.0
244 244.0
@@ -274,17 +232,20 @@ POSTHOOK: Input: default@dest1
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
@@ -299,6 +260,7 @@ POSTHOOK: Input: default@dest1
292 292.0
296 296.0
298 894.0
+30 30.0
302 302.0
305 305.0
306 306.0
@@ -316,6 +278,7 @@ POSTHOOK: Input: default@dest1
323 323.0
325 650.0
327 981.0
+33 33.0
331 662.0
332 332.0
333 666.0
@@ -323,11 +286,13 @@ POSTHOOK: Input: default@dest1
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
@@ -339,6 +304,7 @@ POSTHOOK: Input: default@dest1
367 734.0
368 368.0
369 1107.0
+37 74.0
373 373.0
374 374.0
375 375.0
@@ -356,6 +322,7 @@ POSTHOOK: Input: default@dest1
396 1188.0
397 794.0
399 798.0
+4 4.0
400 400.0
401 2005.0
402 402.0
@@ -364,16 +331,19 @@ POSTHOOK: Input: default@dest1
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
@@ -382,6 +352,7 @@ POSTHOOK: Input: default@dest1
437 437.0
438 1314.0
439 878.0
+44 44.0
443 443.0
444 444.0
446 446.0
@@ -401,6 +372,7 @@ POSTHOOK: Input: default@dest1
467 467.0
468 1872.0
469 2345.0
+47 47.0
470 470.0
472 472.0
475 475.0
@@ -424,3 +396,35 @@ POSTHOOK: Input: default@dest1
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/groupby1_noskew.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/groupby1_noskew.q.out?rev=1598678&r1=1598677&r2=1598678&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/groupby1_noskew.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/groupby1_noskew.q.out Fri May 30 17:37:05 2014
@@ -1,7 +1,11 @@
-PREHOOK: query: CREATE TABLE dest_g1(key INT, value DOUBLE) STORED AS TEXTFILE
+PREHOOK: query: -- SORT_QUERY_RESULTS
+
+CREATE TABLE dest_g1(key INT, value DOUBLE) STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
-POSTHOOK: query: CREATE TABLE dest_g1(key INT, value DOUBLE) STORED AS TEXTFILE
+POSTHOOK: query: -- SORT_QUERY_RESULTS
+
+CREATE TABLE dest_g1(key INT, value DOUBLE) STORED AS TEXTFILE
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@dest_g1
@@ -76,81 +80,28 @@ POSTHOOK: Input: default@src
POSTHOOK: Output: default@dest_g1
POSTHOOK: Lineage: dest_g1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: dest_g1.value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-PREHOOK: query: SELECT dest_g1.* FROM dest_g1 ORDER BY key
+PREHOOK: query: SELECT dest_g1.* FROM dest_g1
PREHOOK: type: QUERY
PREHOOK: Input: default@dest_g1
#### A masked pattern was here ####
-POSTHOOK: query: SELECT dest_g1.* FROM dest_g1 ORDER BY key
+POSTHOOK: query: SELECT dest_g1.* FROM dest_g1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@dest_g1
#### A masked pattern was here ####
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
@@ -166,6 +117,7 @@ POSTHOOK: Input: default@dest_g1
145 145.0
146 292.0
149 298.0
+15 30.0
150 150.0
152 304.0
153 153.0
@@ -182,6 +134,7 @@ POSTHOOK: Input: default@dest_g1
167 501.0
168 168.0
169 676.0
+17 17.0
170 170.0
172 344.0
174 348.0
@@ -190,12 +143,14 @@ POSTHOOK: Input: default@dest_g1
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
@@ -205,6 +160,8 @@ POSTHOOK: Input: default@dest_g1
196 196.0
197 394.0
199 597.0
+2 2.0
+20 20.0
200 400.0
201 201.0
202 202.0
@@ -232,6 +189,7 @@ POSTHOOK: Input: default@dest_g1
237 474.0
238 476.0
239 478.0
+24 48.0
241 241.0
242 484.0
244 244.0
@@ -243,17 +201,20 @@ POSTHOOK: Input: default@dest_g1
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
@@ -268,6 +229,7 @@ POSTHOOK: Input: default@dest_g1
292 292.0
296 296.0
298 894.0
+30 30.0
302 302.0
305 305.0
306 306.0
@@ -285,6 +247,7 @@ POSTHOOK: Input: default@dest_g1
323 323.0
325 650.0
327 981.0
+33 33.0
331 662.0
332 332.0
333 666.0
@@ -292,11 +255,13 @@ POSTHOOK: Input: default@dest_g1
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
@@ -308,6 +273,7 @@ POSTHOOK: Input: default@dest_g1
367 734.0
368 368.0
369 1107.0
+37 74.0
373 373.0
374 374.0
375 375.0
@@ -325,6 +291,7 @@ POSTHOOK: Input: default@dest_g1
396 1188.0
397 794.0
399 798.0
+4 4.0
400 400.0
401 2005.0
402 402.0
@@ -333,16 +300,19 @@ POSTHOOK: Input: default@dest_g1
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
@@ -351,6 +321,7 @@ POSTHOOK: Input: default@dest_g1
437 437.0
438 1314.0
439 878.0
+44 44.0
443 443.0
444 444.0
446 446.0
@@ -370,6 +341,7 @@ POSTHOOK: Input: default@dest_g1
467 467.0
468 1872.0
469 2345.0
+47 47.0
470 470.0
472 472.0
475 475.0
@@ -393,3 +365,35 @@ POSTHOOK: Input: default@dest_g1
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/groupby2_map.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/groupby2_map.q.out?rev=1598678&r1=1598677&r2=1598678&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/groupby2_map.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/groupby2_map.q.out Fri May 30 17:37:05 2014
@@ -1,7 +1,11 @@
-PREHOOK: query: CREATE TABLE dest1(key STRING, c1 INT, c2 STRING) STORED AS TEXTFILE
+PREHOOK: query: -- SORT_QUERY_RESULTS
+
+CREATE TABLE dest1(key STRING, c1 INT, c2 STRING) STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
-POSTHOOK: query: CREATE TABLE dest1(key STRING, c1 INT, c2 STRING) STORED AS TEXTFILE
+POSTHOOK: query: -- SORT_QUERY_RESULTS
+
+CREATE TABLE dest1(key STRING, c1 INT, c2 STRING) STORED AS TEXTFILE
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@dest1
@@ -87,11 +91,11 @@ POSTHOOK: Output: default@dest1
POSTHOOK: Lineage: dest1.c1 EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: dest1.c2 EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), (src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: dest1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
-PREHOOK: query: SELECT dest1.* FROM dest1 ORDER BY key
+PREHOOK: query: SELECT dest1.* FROM dest1
PREHOOK: type: QUERY
PREHOOK: Input: default@dest1
#### A masked pattern was here ####
-POSTHOOK: query: SELECT dest1.* FROM dest1 ORDER BY key
+POSTHOOK: query: SELECT dest1.* FROM dest1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@dest1
#### A masked pattern was here ####
Modified: hive/trunk/ql/src/test/results/clientpositive/groupby2_map_multi_distinct.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/groupby2_map_multi_distinct.q.out?rev=1598678&r1=1598677&r2=1598678&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/groupby2_map_multi_distinct.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/groupby2_map_multi_distinct.q.out Fri May 30 17:37:05 2014
@@ -1,7 +1,11 @@
-PREHOOK: query: CREATE TABLE dest1(key STRING, c1 INT, c2 STRING, c3 INT, c4 INT) STORED AS TEXTFILE
+PREHOOK: query: -- SORT_QUERY_RESULTS
+
+CREATE TABLE dest1(key STRING, c1 INT, c2 STRING, c3 INT, c4 INT) STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
-POSTHOOK: query: CREATE TABLE dest1(key STRING, c1 INT, c2 STRING, c3 INT, c4 INT) STORED AS TEXTFILE
+POSTHOOK: query: -- SORT_QUERY_RESULTS
+
+CREATE TABLE dest1(key STRING, c1 INT, c2 STRING, c3 INT, c4 INT) STORED AS TEXTFILE
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@dest1
@@ -89,11 +93,11 @@ POSTHOOK: Lineage: dest1.c2 EXPRESSION [
POSTHOOK: Lineage: dest1.c3 EXPRESSION [(src)src.null, ]
POSTHOOK: Lineage: dest1.c4 EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: dest1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
-PREHOOK: query: SELECT dest1.* FROM dest1 ORDER BY key
+PREHOOK: query: SELECT dest1.* FROM dest1
PREHOOK: type: QUERY
PREHOOK: Input: default@dest1
#### A masked pattern was here ####
-POSTHOOK: query: SELECT dest1.* FROM dest1 ORDER BY key
+POSTHOOK: query: SELECT dest1.* FROM dest1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@dest1
#### A masked pattern was here ####
@@ -195,11 +199,11 @@ POSTHOOK: Lineage: dest1.c2 EXPRESSION [
POSTHOOK: Lineage: dest1.c3 EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: dest1.c4 EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: dest1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
-PREHOOK: query: SELECT dest1.* FROM dest1 ORDER BY key
+PREHOOK: query: SELECT dest1.* FROM dest1
PREHOOK: type: QUERY
PREHOOK: Input: default@dest1
#### A masked pattern was here ####
-POSTHOOK: query: SELECT dest1.* FROM dest1 ORDER BY key
+POSTHOOK: query: SELECT dest1.* FROM dest1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@dest1
#### A masked pattern was here ####
Modified: hive/trunk/ql/src/test/results/clientpositive/groupby2_noskew.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/groupby2_noskew.q.out?rev=1598678&r1=1598677&r2=1598678&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/groupby2_noskew.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/groupby2_noskew.q.out Fri May 30 17:37:05 2014
@@ -1,7 +1,11 @@
-PREHOOK: query: CREATE TABLE dest_g2(key STRING, c1 INT, c2 STRING) STORED AS TEXTFILE
+PREHOOK: query: -- SORT_QUERY_RESULTS
+
+CREATE TABLE dest_g2(key STRING, c1 INT, c2 STRING) STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
-POSTHOOK: query: CREATE TABLE dest_g2(key STRING, c1 INT, c2 STRING) STORED AS TEXTFILE
+POSTHOOK: query: -- SORT_QUERY_RESULTS
+
+CREATE TABLE dest_g2(key STRING, c1 INT, c2 STRING) STORED AS TEXTFILE
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@dest_g2
@@ -80,11 +84,11 @@ POSTHOOK: Output: default@dest_g2
POSTHOOK: Lineage: dest_g2.c1 EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: dest_g2.c2 EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), (src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: dest_g2.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
-PREHOOK: query: SELECT dest_g2.* FROM dest_g2 ORDER BY key
+PREHOOK: query: SELECT dest_g2.* FROM dest_g2
PREHOOK: type: QUERY
PREHOOK: Input: default@dest_g2
#### A masked pattern was here ####
-POSTHOOK: query: SELECT dest_g2.* FROM dest_g2 ORDER BY key
+POSTHOOK: query: SELECT dest_g2.* FROM dest_g2
POSTHOOK: type: QUERY
POSTHOOK: Input: default@dest_g2
#### A masked pattern was here ####
Modified: hive/trunk/ql/src/test/results/clientpositive/groupby2_noskew_multi_distinct.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/groupby2_noskew_multi_distinct.q.out?rev=1598678&r1=1598677&r2=1598678&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/groupby2_noskew_multi_distinct.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/groupby2_noskew_multi_distinct.q.out Fri May 30 17:37:05 2014
@@ -1,7 +1,11 @@
-PREHOOK: query: CREATE TABLE dest_g2(key STRING, c1 INT, c2 STRING, c3 INT, c4 INT) STORED AS TEXTFILE
+PREHOOK: query: -- SORT_QUERY_RESULTS
+
+CREATE TABLE dest_g2(key STRING, c1 INT, c2 STRING, c3 INT, c4 INT) STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
-POSTHOOK: query: CREATE TABLE dest_g2(key STRING, c1 INT, c2 STRING, c3 INT, c4 INT) STORED AS TEXTFILE
+POSTHOOK: query: -- SORT_QUERY_RESULTS
+
+CREATE TABLE dest_g2(key STRING, c1 INT, c2 STRING, c3 INT, c4 INT) STORED AS TEXTFILE
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@dest_g2
@@ -83,11 +87,11 @@ POSTHOOK: Lineage: dest_g2.c2 EXPRESSION
POSTHOOK: Lineage: dest_g2.c3 EXPRESSION [(src)src.null, ]
POSTHOOK: Lineage: dest_g2.c4 EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: dest_g2.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
-PREHOOK: query: SELECT dest_g2.* FROM dest_g2 ORDER BY key
+PREHOOK: query: SELECT dest_g2.* FROM dest_g2
PREHOOK: type: QUERY
PREHOOK: Input: default@dest_g2
#### A masked pattern was here ####
-POSTHOOK: query: SELECT dest_g2.* FROM dest_g2 ORDER BY key
+POSTHOOK: query: SELECT dest_g2.* FROM dest_g2
POSTHOOK: type: QUERY
POSTHOOK: Input: default@dest_g2
#### A masked pattern was here ####
Modified: hive/trunk/ql/src/test/results/clientpositive/groupby4_noskew.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/groupby4_noskew.q.out?rev=1598678&r1=1598677&r2=1598678&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/groupby4_noskew.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/groupby4_noskew.q.out Fri May 30 17:37:05 2014
@@ -1,7 +1,11 @@
-PREHOOK: query: CREATE TABLE dest1(c1 STRING) STORED AS TEXTFILE
+PREHOOK: query: -- SORT_QUERY_RESULTS
+
+CREATE TABLE dest1(c1 STRING) STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
-POSTHOOK: query: CREATE TABLE dest1(c1 STRING) STORED AS TEXTFILE
+POSTHOOK: query: -- SORT_QUERY_RESULTS
+
+CREATE TABLE dest1(c1 STRING) STORED AS TEXTFILE
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@dest1
@@ -77,11 +81,11 @@ POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
POSTHOOK: Output: default@dest1
POSTHOOK: Lineage: dest1.c1 EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
-PREHOOK: query: SELECT dest1.* FROM dest1 ORDER BY c1
+PREHOOK: query: SELECT dest1.* FROM dest1
PREHOOK: type: QUERY
PREHOOK: Input: default@dest1
#### A masked pattern was here ####
-POSTHOOK: query: SELECT dest1.* FROM dest1 ORDER BY c1
+POSTHOOK: query: SELECT dest1.* FROM dest1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@dest1
#### A masked pattern was here ####
Modified: hive/trunk/ql/src/test/results/clientpositive/groupby5_noskew.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/groupby5_noskew.q.out?rev=1598678&r1=1598677&r2=1598678&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/groupby5_noskew.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/groupby5_noskew.q.out Fri May 30 17:37:05 2014
@@ -1,7 +1,11 @@
-PREHOOK: query: CREATE TABLE dest1(key INT, value STRING) STORED AS TEXTFILE
+PREHOOK: query: -- SORT_QUERY_RESULTS
+
+CREATE TABLE dest1(key INT, value STRING) STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
-POSTHOOK: query: CREATE TABLE dest1(key INT, value STRING) STORED AS TEXTFILE
+POSTHOOK: query: -- SORT_QUERY_RESULTS
+
+CREATE TABLE dest1(key INT, value STRING) STORED AS TEXTFILE
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@dest1
@@ -88,81 +92,28 @@ POSTHOOK: Input: default@src
POSTHOOK: Output: default@dest1
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), ]
-PREHOOK: query: SELECT dest1.* FROM dest1 ORDER BY key
+PREHOOK: query: SELECT dest1.* FROM dest1
PREHOOK: type: QUERY
PREHOOK: Input: default@dest1
#### A masked pattern was here ####
-POSTHOOK: query: SELECT dest1.* FROM dest1 ORDER BY key
+POSTHOOK: query: SELECT dest1.* FROM dest1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@dest1
#### A masked pattern was here ####
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
@@ -178,6 +129,7 @@ POSTHOOK: Input: default@dest1
145 145.0
146 292.0
149 298.0
+15 30.0
150 150.0
152 304.0
153 153.0
@@ -194,6 +146,7 @@ POSTHOOK: Input: default@dest1
167 501.0
168 168.0
169 676.0
+17 17.0
170 170.0
172 344.0
174 348.0
@@ -202,12 +155,14 @@ POSTHOOK: Input: default@dest1
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
@@ -217,6 +172,8 @@ POSTHOOK: Input: default@dest1
196 196.0
197 394.0
199 597.0
+2 2.0
+20 20.0
200 400.0
201 201.0
202 202.0
@@ -244,6 +201,7 @@ POSTHOOK: Input: default@dest1
237 474.0
238 476.0
239 478.0
+24 48.0
241 241.0
242 484.0
244 244.0
@@ -255,17 +213,20 @@ POSTHOOK: Input: default@dest1
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
@@ -280,6 +241,7 @@ POSTHOOK: Input: default@dest1
292 292.0
296 296.0
298 894.0
+30 30.0
302 302.0
305 305.0
306 306.0
@@ -297,6 +259,7 @@ POSTHOOK: Input: default@dest1
323 323.0
325 650.0
327 981.0
+33 33.0
331 662.0
332 332.0
333 666.0
@@ -304,11 +267,13 @@ POSTHOOK: Input: default@dest1
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
@@ -320,6 +285,7 @@ POSTHOOK: Input: default@dest1
367 734.0
368 368.0
369 1107.0
+37 74.0
373 373.0
374 374.0
375 375.0
@@ -337,6 +303,7 @@ POSTHOOK: Input: default@dest1
396 1188.0
397 794.0
399 798.0
+4 4.0
400 400.0
401 2005.0
402 402.0
@@ -345,16 +312,19 @@ POSTHOOK: Input: default@dest1
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
@@ -363,6 +333,7 @@ POSTHOOK: Input: default@dest1
437 437.0
438 1314.0
439 878.0
+44 44.0
443 443.0
444 444.0
446 446.0
@@ -382,6 +353,7 @@ POSTHOOK: Input: default@dest1
467 467.0
468 1872.0
469 2345.0
+47 47.0
470 470.0
472 472.0
475 475.0
@@ -405,3 +377,35 @@ POSTHOOK: Input: default@dest1
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/groupby6_map.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/groupby6_map.q.out?rev=1598678&r1=1598677&r2=1598678&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/groupby6_map.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/groupby6_map.q.out Fri May 30 17:37:05 2014
@@ -1,7 +1,11 @@
-PREHOOK: query: CREATE TABLE dest1(c1 STRING) STORED AS TEXTFILE
+PREHOOK: query: -- SORT_QUERY_RESULTS
+
+CREATE TABLE dest1(c1 STRING) STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
-POSTHOOK: query: CREATE TABLE dest1(c1 STRING) STORED AS TEXTFILE
+POSTHOOK: query: -- SORT_QUERY_RESULTS
+
+CREATE TABLE dest1(c1 STRING) STORED AS TEXTFILE
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@dest1
@@ -82,11 +86,11 @@ POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
POSTHOOK: Output: default@dest1
POSTHOOK: Lineage: dest1.c1 EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-PREHOOK: query: SELECT dest1.* FROM dest1 ORDER BY c1
+PREHOOK: query: SELECT dest1.* FROM dest1
PREHOOK: type: QUERY
PREHOOK: Input: default@dest1
#### A masked pattern was here ####
-POSTHOOK: query: SELECT dest1.* FROM dest1 ORDER BY c1
+POSTHOOK: query: SELECT dest1.* FROM dest1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@dest1
#### A masked pattern was here ####
Modified: hive/trunk/ql/src/test/results/clientpositive/groupby6_map_skew.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/groupby6_map_skew.q.out?rev=1598678&r1=1598677&r2=1598678&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/groupby6_map_skew.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/groupby6_map_skew.q.out Fri May 30 17:37:05 2014
@@ -1,7 +1,11 @@
-PREHOOK: query: CREATE TABLE dest1(c1 STRING) STORED AS TEXTFILE
+PREHOOK: query: -- SORT_QUERY_RESULTS
+
+CREATE TABLE dest1(c1 STRING) STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
-POSTHOOK: query: CREATE TABLE dest1(c1 STRING) STORED AS TEXTFILE
+POSTHOOK: query: -- SORT_QUERY_RESULTS
+
+CREATE TABLE dest1(c1 STRING) STORED AS TEXTFILE
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@dest1
@@ -105,11 +109,11 @@ POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
POSTHOOK: Output: default@dest1
POSTHOOK: Lineage: dest1.c1 EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-PREHOOK: query: SELECT dest1.* FROM dest1 ORDER BY c1
+PREHOOK: query: SELECT dest1.* FROM dest1
PREHOOK: type: QUERY
PREHOOK: Input: default@dest1
#### A masked pattern was here ####
-POSTHOOK: query: SELECT dest1.* FROM dest1 ORDER BY c1
+POSTHOOK: query: SELECT dest1.* FROM dest1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@dest1
#### A masked pattern was here ####
Modified: hive/trunk/ql/src/test/results/clientpositive/groupby6_noskew.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/groupby6_noskew.q.out?rev=1598678&r1=1598677&r2=1598678&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/groupby6_noskew.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/groupby6_noskew.q.out Fri May 30 17:37:05 2014
@@ -1,7 +1,11 @@
-PREHOOK: query: CREATE TABLE dest1(c1 STRING) STORED AS TEXTFILE
+PREHOOK: query: -- SORT_QUERY_RESULTS
+
+CREATE TABLE dest1(c1 STRING) STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
-POSTHOOK: query: CREATE TABLE dest1(c1 STRING) STORED AS TEXTFILE
+POSTHOOK: query: -- SORT_QUERY_RESULTS
+
+CREATE TABLE dest1(c1 STRING) STORED AS TEXTFILE
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@dest1
@@ -77,11 +81,11 @@ POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
POSTHOOK: Output: default@dest1
POSTHOOK: Lineage: dest1.c1 EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-PREHOOK: query: SELECT dest1.* FROM dest1 ORDER BY c1
+PREHOOK: query: SELECT dest1.* FROM dest1
PREHOOK: type: QUERY
PREHOOK: Input: default@dest1
#### A masked pattern was here ####
-POSTHOOK: query: SELECT dest1.* FROM dest1 ORDER BY c1
+POSTHOOK: query: SELECT dest1.* FROM dest1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@dest1
#### A masked pattern was here ####
Modified: hive/trunk/ql/src/test/results/clientpositive/groupby7_map.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/groupby7_map.q.out?rev=1598678&r1=1598677&r2=1598678&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/groupby7_map.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/groupby7_map.q.out Fri May 30 17:37:05 2014
@@ -1,7 +1,11 @@
-PREHOOK: query: CREATE TABLE DEST1(key INT, value STRING) STORED AS TEXTFILE
+PREHOOK: query: -- SORT_QUERY_RESULTS
+
+CREATE TABLE DEST1(key INT, value STRING) STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
-POSTHOOK: query: CREATE TABLE DEST1(key INT, value STRING) STORED AS TEXTFILE
+POSTHOOK: query: -- SORT_QUERY_RESULTS
+
+CREATE TABLE DEST1(key INT, value STRING) STORED AS TEXTFILE
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@DEST1
@@ -163,81 +167,28 @@ 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 ORDER BY key
+PREHOOK: query: SELECT DEST1.* FROM DEST1
PREHOOK: type: QUERY
PREHOOK: Input: default@dest1
#### A masked pattern was here ####
-POSTHOOK: query: SELECT DEST1.* FROM DEST1 ORDER BY key
+POSTHOOK: query: SELECT DEST1.* FROM DEST1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@dest1
#### A masked pattern was here ####
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
@@ -253,6 +204,7 @@ POSTHOOK: Input: default@dest1
145 145.0
146 292.0
149 298.0
+15 30.0
150 150.0
152 304.0
153 153.0
@@ -269,6 +221,7 @@ POSTHOOK: Input: default@dest1
167 501.0
168 168.0
169 676.0
+17 17.0
170 170.0
172 344.0
174 348.0
@@ -277,12 +230,14 @@ POSTHOOK: Input: default@dest1
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
@@ -292,6 +247,8 @@ POSTHOOK: Input: default@dest1
196 196.0
197 394.0
199 597.0
+2 2.0
+20 20.0
200 400.0
201 201.0
202 202.0
@@ -319,6 +276,7 @@ POSTHOOK: Input: default@dest1
237 474.0
238 476.0
239 478.0
+24 48.0
241 241.0
242 484.0
244 244.0
@@ -330,17 +288,20 @@ POSTHOOK: Input: default@dest1
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
@@ -355,6 +316,7 @@ POSTHOOK: Input: default@dest1
292 292.0
296 296.0
298 894.0
+30 30.0
302 302.0
305 305.0
306 306.0
@@ -372,6 +334,7 @@ POSTHOOK: Input: default@dest1
323 323.0
325 650.0
327 981.0
+33 33.0
331 662.0
332 332.0
333 666.0
@@ -379,11 +342,13 @@ POSTHOOK: Input: default@dest1
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
@@ -395,6 +360,7 @@ POSTHOOK: Input: default@dest1
367 734.0
368 368.0
369 1107.0
+37 74.0
373 373.0
374 374.0
375 375.0
@@ -412,6 +378,7 @@ POSTHOOK: Input: default@dest1
396 1188.0
397 794.0
399 798.0
+4 4.0
400 400.0
401 2005.0
402 402.0
@@ -420,16 +387,19 @@ POSTHOOK: Input: default@dest1
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
@@ -438,6 +408,7 @@ POSTHOOK: Input: default@dest1
437 437.0
438 1314.0
439 878.0
+44 44.0
443 443.0
444 444.0
446 446.0
@@ -457,6 +428,7 @@ POSTHOOK: Input: default@dest1
467 467.0
468 1872.0
469 2345.0
+47 47.0
470 470.0
472 472.0
475 475.0
@@ -480,42 +452,7 @@ POSTHOOK: Input: default@dest1
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 ####
-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
@@ -532,6 +469,7 @@ POSTHOOK: Input: default@dest2
76 152.0
77 77.0
78 78.0
+8 8.0
80 80.0
82 82.0
83 166.0
@@ -539,22 +477,35 @@ POSTHOOK: Input: default@dest2
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 ####
+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
@@ -570,6 +521,7 @@ POSTHOOK: Input: default@dest2
145 145.0
146 292.0
149 298.0
+15 30.0
150 150.0
152 304.0
153 153.0
@@ -586,6 +538,7 @@ POSTHOOK: Input: default@dest2
167 501.0
168 168.0
169 676.0
+17 17.0
170 170.0
172 344.0
174 348.0
@@ -594,12 +547,14 @@ POSTHOOK: Input: default@dest2
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
@@ -609,6 +564,8 @@ POSTHOOK: Input: default@dest2
196 196.0
197 394.0
199 597.0
+2 2.0
+20 20.0
200 400.0
201 201.0
202 202.0
@@ -636,6 +593,7 @@ POSTHOOK: Input: default@dest2
237 474.0
238 476.0
239 478.0
+24 48.0
241 241.0
242 484.0
244 244.0
@@ -647,17 +605,20 @@ POSTHOOK: Input: default@dest2
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
@@ -672,6 +633,7 @@ POSTHOOK: Input: default@dest2
292 292.0
296 296.0
298 894.0
+30 30.0
302 302.0
305 305.0
306 306.0
@@ -689,6 +651,7 @@ POSTHOOK: Input: default@dest2
323 323.0
325 650.0
327 981.0
+33 33.0
331 662.0
332 332.0
333 666.0
@@ -696,11 +659,13 @@ POSTHOOK: Input: default@dest2
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
@@ -712,6 +677,7 @@ POSTHOOK: Input: default@dest2
367 734.0
368 368.0
369 1107.0
+37 74.0
373 373.0
374 374.0
375 375.0
@@ -729,6 +695,7 @@ POSTHOOK: Input: default@dest2
396 1188.0
397 794.0
399 798.0
+4 4.0
400 400.0
401 2005.0
402 402.0
@@ -737,16 +704,19 @@ POSTHOOK: Input: default@dest2
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
@@ -755,6 +725,7 @@ POSTHOOK: Input: default@dest2
437 437.0
438 1314.0
439 878.0
+44 44.0
443 443.0
444 444.0
446 446.0
@@ -774,6 +745,7 @@ POSTHOOK: Input: default@dest2
467 467.0
468 1872.0
469 2345.0
+47 47.0
470 470.0
472 472.0
475 475.0
@@ -797,3 +769,35 @@ POSTHOOK: Input: default@dest2
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_map_multi_single_reducer.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/groupby7_map_multi_single_reducer.q.out?rev=1598678&r1=1598677&r2=1598678&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/groupby7_map_multi_single_reducer.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/groupby7_map_multi_single_reducer.q.out Fri May 30 17:37:05 2014
@@ -1,7 +1,11 @@
-PREHOOK: query: CREATE TABLE DEST1(key INT, value STRING) STORED AS TEXTFILE
+PREHOOK: query: -- SORT_QUERY_RESULTS
+
+CREATE TABLE DEST1(key INT, value STRING) STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
-POSTHOOK: query: CREATE TABLE DEST1(key INT, value STRING) STORED AS TEXTFILE
+POSTHOOK: query: -- SORT_QUERY_RESULTS
+
+CREATE TABLE DEST1(key INT, value STRING) STORED AS TEXTFILE
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@DEST1
@@ -130,81 +134,28 @@ 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 ORDER BY key
+PREHOOK: query: SELECT DEST1.* FROM DEST1
PREHOOK: type: QUERY
PREHOOK: Input: default@dest1
#### A masked pattern was here ####
-POSTHOOK: query: SELECT DEST1.* FROM DEST1 ORDER BY key
+POSTHOOK: query: SELECT DEST1.* FROM DEST1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@dest1
#### A masked pattern was here ####
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
@@ -220,6 +171,7 @@ POSTHOOK: Input: default@dest1
145 145.0
146 292.0
149 298.0
+15 30.0
150 150.0
152 304.0
153 153.0
@@ -236,6 +188,7 @@ POSTHOOK: Input: default@dest1
167 501.0
168 168.0
169 676.0
+17 17.0
170 170.0
172 344.0
174 348.0
@@ -244,12 +197,14 @@ POSTHOOK: Input: default@dest1
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
@@ -259,6 +214,8 @@ POSTHOOK: Input: default@dest1
196 196.0
197 394.0
199 597.0
+2 2.0
+20 20.0
200 400.0
201 201.0
202 202.0
@@ -286,6 +243,7 @@ POSTHOOK: Input: default@dest1
237 474.0
238 476.0
239 478.0
+24 48.0
241 241.0
242 484.0
244 244.0
@@ -297,17 +255,20 @@ POSTHOOK: Input: default@dest1
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
@@ -322,6 +283,7 @@ POSTHOOK: Input: default@dest1
292 292.0
296 296.0
298 894.0
+30 30.0
302 302.0
305 305.0
306 306.0
@@ -339,6 +301,7 @@ POSTHOOK: Input: default@dest1
323 323.0
325 650.0
327 981.0
+33 33.0
331 662.0
332 332.0
333 666.0
@@ -346,11 +309,13 @@ POSTHOOK: Input: default@dest1
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
@@ -362,6 +327,7 @@ POSTHOOK: Input: default@dest1
367 734.0
368 368.0
369 1107.0
+37 74.0
373 373.0
374 374.0
375 375.0
@@ -379,6 +345,7 @@ POSTHOOK: Input: default@dest1
396 1188.0
397 794.0
399 798.0
+4 4.0
400 400.0
401 2005.0
402 402.0
@@ -387,16 +354,19 @@ POSTHOOK: Input: default@dest1
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
@@ -405,6 +375,7 @@ POSTHOOK: Input: default@dest1
437 437.0
438 1314.0
439 878.0
+44 44.0
443 443.0
444 444.0
446 446.0
@@ -424,6 +395,7 @@ POSTHOOK: Input: default@dest1
467 467.0
468 1872.0
469 2345.0
+47 47.0
470 470.0
472 472.0
475 475.0
@@ -447,42 +419,7 @@ POSTHOOK: Input: default@dest1
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 ####
-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
@@ -499,6 +436,7 @@ POSTHOOK: Input: default@dest2
76 152.0
77 77.0
78 78.0
+8 8.0
80 80.0
82 82.0
83 166.0
@@ -506,22 +444,35 @@ POSTHOOK: Input: default@dest2
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 ####
+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
@@ -537,6 +488,7 @@ POSTHOOK: Input: default@dest2
145 145.0
146 292.0
149 298.0
+15 30.0
150 150.0
152 304.0
153 153.0
@@ -553,6 +505,7 @@ POSTHOOK: Input: default@dest2
167 501.0
168 168.0
169 676.0
+17 17.0
170 170.0
172 344.0
174 348.0
@@ -561,12 +514,14 @@ POSTHOOK: Input: default@dest2
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
@@ -576,6 +531,8 @@ POSTHOOK: Input: default@dest2
196 196.0
197 394.0
199 597.0
+2 2.0
+20 20.0
200 400.0
201 201.0
202 202.0
@@ -603,6 +560,7 @@ POSTHOOK: Input: default@dest2
237 474.0
238 476.0
239 478.0
+24 48.0
241 241.0
242 484.0
244 244.0
@@ -614,17 +572,20 @@ POSTHOOK: Input: default@dest2
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
@@ -639,6 +600,7 @@ POSTHOOK: Input: default@dest2
292 292.0
296 296.0
298 894.0
+30 30.0
302 302.0
305 305.0
306 306.0
@@ -656,6 +618,7 @@ POSTHOOK: Input: default@dest2
323 323.0
325 650.0
327 981.0
+33 33.0
331 662.0
332 332.0
333 666.0
@@ -663,11 +626,13 @@ POSTHOOK: Input: default@dest2
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
@@ -679,6 +644,7 @@ POSTHOOK: Input: default@dest2
367 734.0
368 368.0
369 1107.0
+37 74.0
373 373.0
374 374.0
375 375.0
@@ -696,6 +662,7 @@ POSTHOOK: Input: default@dest2
396 1188.0
397 794.0
399 798.0
+4 4.0
400 400.0
401 2005.0
402 402.0
@@ -704,16 +671,19 @@ POSTHOOK: Input: default@dest2
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
@@ -722,6 +692,7 @@ POSTHOOK: Input: default@dest2
437 437.0
438 1314.0
439 878.0
+44 44.0
443 443.0
444 444.0
446 446.0
@@ -741,6 +712,7 @@ POSTHOOK: Input: default@dest2
467 467.0
468 1872.0
469 2345.0
+47 47.0
470 470.0
472 472.0
475 475.0
@@ -764,3 +736,35 @@ POSTHOOK: Input: default@dest2
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_map_skew.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/groupby7_map_skew.q.out?rev=1598678&r1=1598677&r2=1598678&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/groupby7_map_skew.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/groupby7_map_skew.q.out Fri May 30 17:37:05 2014
@@ -1,7 +1,11 @@
-PREHOOK: query: CREATE TABLE DEST1(key INT, value STRING) STORED AS TEXTFILE
+PREHOOK: query: -- SORT_QUERY_RESULTS
+
+CREATE TABLE DEST1(key INT, value STRING) STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
-POSTHOOK: query: CREATE TABLE DEST1(key INT, value STRING) STORED AS TEXTFILE
+POSTHOOK: query: -- SORT_QUERY_RESULTS
+
+CREATE TABLE DEST1(key INT, value STRING) STORED AS TEXTFILE
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@DEST1
@@ -213,81 +217,28 @@ 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 ORDER BY key
+PREHOOK: query: SELECT DEST1.* FROM DEST1
PREHOOK: type: QUERY
PREHOOK: Input: default@dest1
#### A masked pattern was here ####
-POSTHOOK: query: SELECT DEST1.* FROM DEST1 ORDER BY key
+POSTHOOK: query: SELECT DEST1.* FROM DEST1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@dest1
#### A masked pattern was here ####
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
@@ -303,6 +254,7 @@ POSTHOOK: Input: default@dest1
145 145.0
146 292.0
149 298.0
+15 30.0
150 150.0
152 304.0
153 153.0
@@ -319,6 +271,7 @@ POSTHOOK: Input: default@dest1
167 501.0
168 168.0
169 676.0
+17 17.0
170 170.0
172 344.0
174 348.0
@@ -327,12 +280,14 @@ POSTHOOK: Input: default@dest1
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
@@ -342,6 +297,8 @@ POSTHOOK: Input: default@dest1
196 196.0
197 394.0
199 597.0
+2 2.0
+20 20.0
200 400.0
201 201.0
202 202.0
@@ -369,6 +326,7 @@ POSTHOOK: Input: default@dest1
237 474.0
238 476.0
239 478.0
+24 48.0
241 241.0
242 484.0
244 244.0
@@ -380,17 +338,20 @@ POSTHOOK: Input: default@dest1
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
@@ -405,6 +366,7 @@ POSTHOOK: Input: default@dest1
292 292.0
296 296.0
298 894.0
+30 30.0
302 302.0
305 305.0
306 306.0
@@ -422,6 +384,7 @@ POSTHOOK: Input: default@dest1
323 323.0
325 650.0
327 981.0
+33 33.0
331 662.0
332 332.0
333 666.0
@@ -429,11 +392,13 @@ POSTHOOK: Input: default@dest1
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
@@ -445,6 +410,7 @@ POSTHOOK: Input: default@dest1
367 734.0
368 368.0
369 1107.0
+37 74.0
373 373.0
374 374.0
375 375.0
@@ -462,6 +428,7 @@ POSTHOOK: Input: default@dest1
396 1188.0
397 794.0
399 798.0
+4 4.0
400 400.0
401 2005.0
402 402.0
@@ -470,16 +437,19 @@ POSTHOOK: Input: default@dest1
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
@@ -488,6 +458,7 @@ POSTHOOK: Input: default@dest1
437 437.0
438 1314.0
439 878.0
+44 44.0
443 443.0
444 444.0
446 446.0
@@ -507,6 +478,7 @@ POSTHOOK: Input: default@dest1
467 467.0
468 1872.0
469 2345.0
+47 47.0
470 470.0
472 472.0
475 475.0
@@ -530,42 +502,7 @@ POSTHOOK: Input: default@dest1
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 ####
-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
@@ -582,6 +519,7 @@ POSTHOOK: Input: default@dest2
76 152.0
77 77.0
78 78.0
+8 8.0
80 80.0
82 82.0
83 166.0
@@ -589,22 +527,35 @@ POSTHOOK: Input: default@dest2
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 ####
+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
@@ -620,6 +571,7 @@ POSTHOOK: Input: default@dest2
145 145.0
146 292.0
149 298.0
+15 30.0
150 150.0
152 304.0
153 153.0
@@ -636,6 +588,7 @@ POSTHOOK: Input: default@dest2
167 501.0
168 168.0
169 676.0
+17 17.0
170 170.0
172 344.0
174 348.0
@@ -644,12 +597,14 @@ POSTHOOK: Input: default@dest2
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
@@ -659,6 +614,8 @@ POSTHOOK: Input: default@dest2
196 196.0
197 394.0
199 597.0
+2 2.0
+20 20.0
200 400.0
201 201.0
202 202.0
@@ -686,6 +643,7 @@ POSTHOOK: Input: default@dest2
237 474.0
238 476.0
239 478.0
+24 48.0
241 241.0
242 484.0
244 244.0
@@ -697,17 +655,20 @@ POSTHOOK: Input: default@dest2
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
@@ -722,6 +683,7 @@ POSTHOOK: Input: default@dest2
292 292.0
296 296.0
298 894.0
+30 30.0
302 302.0
305 305.0
306 306.0
@@ -739,6 +701,7 @@ POSTHOOK: Input: default@dest2
323 323.0
325 650.0
327 981.0
+33 33.0
331 662.0
332 332.0
333 666.0
@@ -746,11 +709,13 @@ POSTHOOK: Input: default@dest2
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
@@ -762,6 +727,7 @@ POSTHOOK: Input: default@dest2
367 734.0
368 368.0
369 1107.0
+37 74.0
373 373.0
374 374.0
375 375.0
@@ -779,6 +745,7 @@ POSTHOOK: Input: default@dest2
396 1188.0
397 794.0
399 798.0
+4 4.0
400 400.0
401 2005.0
402 402.0
@@ -787,16 +754,19 @@ POSTHOOK: Input: default@dest2
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
@@ -805,6 +775,7 @@ POSTHOOK: Input: default@dest2
437 437.0
438 1314.0
439 878.0
+44 44.0
443 443.0
444 444.0
446 446.0
@@ -824,6 +795,7 @@ POSTHOOK: Input: default@dest2
467 467.0
468 1872.0
469 2345.0
+47 47.0
470 470.0
472 472.0
475 475.0
@@ -847,3 +819,35 @@ POSTHOOK: Input: default@dest2
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.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/groupby7_noskew.q.out?rev=1598678&r1=1598677&r2=1598678&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 Fri May 30 17:37:05 2014
@@ -1,7 +1,11 @@
-PREHOOK: query: CREATE TABLE DEST1(key INT, value STRING) STORED AS TEXTFILE
+PREHOOK: query: -- SORT_QUERY_RESULTS
+
+CREATE TABLE DEST1(key INT, value STRING) STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
-POSTHOOK: query: CREATE TABLE DEST1(key INT, value STRING) STORED AS TEXTFILE
+POSTHOOK: query: -- SORT_QUERY_RESULTS
+
+CREATE TABLE DEST1(key INT, value STRING) STORED AS TEXTFILE
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@DEST1
@@ -151,81 +155,28 @@ 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 ORDER BY key
+PREHOOK: query: SELECT DEST1.* FROM DEST1
PREHOOK: type: QUERY
PREHOOK: Input: default@dest1
#### A masked pattern was here ####
-POSTHOOK: query: SELECT DEST1.* FROM DEST1 ORDER BY key
+POSTHOOK: query: SELECT DEST1.* FROM DEST1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@dest1
#### A masked pattern was here ####
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
@@ -241,6 +192,7 @@ POSTHOOK: Input: default@dest1
145 145.0
146 292.0
149 298.0
+15 30.0
150 150.0
152 304.0
153 153.0
@@ -257,6 +209,7 @@ POSTHOOK: Input: default@dest1
167 501.0
168 168.0
169 676.0
+17 17.0
170 170.0
172 344.0
174 348.0
@@ -265,12 +218,14 @@ POSTHOOK: Input: default@dest1
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
@@ -280,6 +235,8 @@ POSTHOOK: Input: default@dest1
196 196.0
197 394.0
199 597.0
+2 2.0
+20 20.0
200 400.0
201 201.0
202 202.0
@@ -307,6 +264,7 @@ POSTHOOK: Input: default@dest1
237 474.0
238 476.0
239 478.0
+24 48.0
241 241.0
242 484.0
244 244.0
@@ -318,17 +276,20 @@ POSTHOOK: Input: default@dest1
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
@@ -343,6 +304,7 @@ POSTHOOK: Input: default@dest1
292 292.0
296 296.0
298 894.0
+30 30.0
302 302.0
305 305.0
306 306.0
@@ -360,6 +322,7 @@ POSTHOOK: Input: default@dest1
323 323.0
325 650.0
327 981.0
+33 33.0
331 662.0
332 332.0
333 666.0
@@ -367,11 +330,13 @@ POSTHOOK: Input: default@dest1
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
@@ -383,6 +348,7 @@ POSTHOOK: Input: default@dest1
367 734.0
368 368.0
369 1107.0
+37 74.0
373 373.0
374 374.0
375 375.0
@@ -400,6 +366,7 @@ POSTHOOK: Input: default@dest1
396 1188.0
397 794.0
399 798.0
+4 4.0
400 400.0
401 2005.0
402 402.0
@@ -408,16 +375,19 @@ POSTHOOK: Input: default@dest1
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
@@ -426,6 +396,7 @@ POSTHOOK: Input: default@dest1
437 437.0
438 1314.0
439 878.0
+44 44.0
443 443.0
444 444.0
446 446.0
@@ -445,6 +416,7 @@ POSTHOOK: Input: default@dest1
467 467.0
468 1872.0
469 2345.0
+47 47.0
470 470.0
472 472.0
475 475.0
@@ -468,42 +440,7 @@ POSTHOOK: Input: default@dest1
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 ####
-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
@@ -520,6 +457,7 @@ POSTHOOK: Input: default@dest2
76 152.0
77 77.0
78 78.0
+8 8.0
80 80.0
82 82.0
83 166.0
@@ -527,22 +465,35 @@ POSTHOOK: Input: default@dest2
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 ####
+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
@@ -558,6 +509,7 @@ POSTHOOK: Input: default@dest2
145 145.0
146 292.0
149 298.0
+15 30.0
150 150.0
152 304.0
153 153.0
@@ -574,6 +526,7 @@ POSTHOOK: Input: default@dest2
167 501.0
168 168.0
169 676.0
+17 17.0
170 170.0
172 344.0
174 348.0
@@ -582,12 +535,14 @@ POSTHOOK: Input: default@dest2
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
@@ -597,6 +552,8 @@ POSTHOOK: Input: default@dest2
196 196.0
197 394.0
199 597.0
+2 2.0
+20 20.0
200 400.0
201 201.0
202 202.0
@@ -624,6 +581,7 @@ POSTHOOK: Input: default@dest2
237 474.0
238 476.0
239 478.0
+24 48.0
241 241.0
242 484.0
244 244.0
@@ -635,17 +593,20 @@ POSTHOOK: Input: default@dest2
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
@@ -660,6 +621,7 @@ POSTHOOK: Input: default@dest2
292 292.0
296 296.0
298 894.0
+30 30.0
302 302.0
305 305.0
306 306.0
@@ -677,6 +639,7 @@ POSTHOOK: Input: default@dest2
323 323.0
325 650.0
327 981.0
+33 33.0
331 662.0
332 332.0
333 666.0
@@ -684,11 +647,13 @@ POSTHOOK: Input: default@dest2
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
@@ -700,6 +665,7 @@ POSTHOOK: Input: default@dest2
367 734.0
368 368.0
369 1107.0
+37 74.0
373 373.0
374 374.0
375 375.0
@@ -717,6 +683,7 @@ POSTHOOK: Input: default@dest2
396 1188.0
397 794.0
399 798.0
+4 4.0
400 400.0
401 2005.0
402 402.0
@@ -725,16 +692,19 @@ POSTHOOK: Input: default@dest2
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
@@ -743,6 +713,7 @@ POSTHOOK: Input: default@dest2
437 437.0
438 1314.0
439 878.0
+44 44.0
443 443.0
444 444.0
446 446.0
@@ -762,6 +733,7 @@ POSTHOOK: Input: default@dest2
467 467.0
468 1872.0
469 2345.0
+47 47.0
470 470.0
472 472.0
475 475.0
@@ -785,3 +757,35 @@ POSTHOOK: Input: default@dest2
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=1598678&r1=1598677&r2=1598678&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 Fri May 30 17:37:05 2014
@@ -1,7 +1,11 @@
-PREHOOK: query: CREATE TABLE DEST1(key INT, value STRING) STORED AS TEXTFILE
+PREHOOK: query: -- SORT_QUERY_RESULTS
+
+CREATE TABLE DEST1(key INT, value STRING) STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
-POSTHOOK: query: CREATE TABLE DEST1(key INT, value STRING) STORED AS TEXTFILE
+POSTHOOK: query: -- SORT_QUERY_RESULTS
+
+CREATE TABLE DEST1(key INT, value STRING) STORED AS TEXTFILE
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@DEST1
@@ -188,39 +192,39 @@ 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 ORDER BY key ASC, value ASC
+PREHOOK: query: SELECT DEST1.* FROM DEST1
PREHOOK: type: QUERY
PREHOOK: Input: default@dest1
#### A masked pattern was here ####
-POSTHOOK: query: SELECT DEST1.* FROM DEST1 ORDER BY key ASC, value ASC
+POSTHOOK: query: SELECT DEST1.* FROM DEST1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@dest1
#### A masked pattern was here ####
0 0.0
10 10.0
-11 11.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
-PREHOOK: query: SELECT DEST2.* FROM DEST2 ORDER BY key ASC, value ASC
+PREHOOK: query: SELECT DEST2.* FROM DEST2
PREHOOK: type: QUERY
PREHOOK: Input: default@dest2
#### A masked pattern was here ####
-POSTHOOK: query: SELECT DEST2.* FROM DEST2 ORDER BY key ASC, value ASC
+POSTHOOK: query: SELECT DEST2.* FROM DEST2
POSTHOOK: type: QUERY
POSTHOOK: Input: default@dest2
#### A masked pattern was here ####
0 0.0
10 10.0
-11 11.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
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=1598678&r1=1598677&r2=1598678&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 Fri May 30 17:37:05 2014
@@ -1,7 +1,11 @@
-PREHOOK: query: CREATE TABLE DEST1(key INT, value STRING) STORED AS TEXTFILE
+PREHOOK: query: -- SORT_QUERY_RESULTS
+
+CREATE TABLE DEST1(key INT, value STRING) STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
-POSTHOOK: query: CREATE TABLE DEST1(key INT, value STRING) STORED AS TEXTFILE
+POSTHOOK: query: -- SORT_QUERY_RESULTS
+
+CREATE TABLE DEST1(key INT, value STRING) STORED AS TEXTFILE
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@DEST1
@@ -176,81 +180,28 @@ 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 ORDER BY key
+PREHOOK: query: SELECT DEST1.* FROM DEST1
PREHOOK: type: QUERY
PREHOOK: Input: default@dest1
#### A masked pattern was here ####
-POSTHOOK: query: SELECT DEST1.* FROM DEST1 ORDER BY key
+POSTHOOK: query: SELECT DEST1.* FROM DEST1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@dest1
#### A masked pattern was here ####
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
@@ -266,6 +217,7 @@ POSTHOOK: Input: default@dest1
145 1
146 1
149 1
+15 1
150 1
152 1
153 1
@@ -282,6 +234,7 @@ POSTHOOK: Input: default@dest1
167 1
168 1
169 1
+17 1
170 1
172 1
174 1
@@ -290,12 +243,14 @@ POSTHOOK: Input: default@dest1
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
@@ -305,6 +260,8 @@ POSTHOOK: Input: default@dest1
196 1
197 1
199 1
+2 1
+20 1
200 1
201 1
202 1
@@ -332,6 +289,7 @@ POSTHOOK: Input: default@dest1
237 1
238 1
239 1
+24 1
241 1
242 1
244 1
@@ -343,17 +301,20 @@ POSTHOOK: Input: default@dest1
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
@@ -368,6 +329,7 @@ POSTHOOK: Input: default@dest1
292 1
296 1
298 1
+30 1
302 1
305 1
306 1
@@ -385,6 +347,7 @@ POSTHOOK: Input: default@dest1
323 1
325 1
327 1
+33 1
331 1
332 1
333 1
@@ -392,11 +355,13 @@ POSTHOOK: Input: default@dest1
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
@@ -408,6 +373,7 @@ POSTHOOK: Input: default@dest1
367 1
368 1
369 1
+37 1
373 1
374 1
375 1
@@ -425,6 +391,7 @@ POSTHOOK: Input: default@dest1
396 1
397 1
399 1
+4 1
400 1
401 1
402 1
@@ -433,16 +400,19 @@ POSTHOOK: Input: default@dest1
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
@@ -451,6 +421,7 @@ POSTHOOK: Input: default@dest1
437 1
438 1
439 1
+44 1
443 1
444 1
446 1
@@ -470,6 +441,7 @@ POSTHOOK: Input: default@dest1
467 1
468 1
469 1
+47 1
470 1
472 1
475 1
@@ -493,42 +465,7 @@ POSTHOOK: Input: default@dest1
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 ####
-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
@@ -545,6 +482,7 @@ POSTHOOK: Input: default@dest2
76 1
77 1
78 1
+8 1
80 1
82 1
83 1
@@ -552,22 +490,35 @@ POSTHOOK: Input: default@dest2
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 ####
+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
@@ -583,6 +534,7 @@ POSTHOOK: Input: default@dest2
145 1
146 1
149 1
+15 1
150 1
152 1
153 1
@@ -599,6 +551,7 @@ POSTHOOK: Input: default@dest2
167 1
168 1
169 1
+17 1
170 1
172 1
174 1
@@ -607,12 +560,14 @@ POSTHOOK: Input: default@dest2
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
@@ -622,6 +577,8 @@ POSTHOOK: Input: default@dest2
196 1
197 1
199 1
+2 1
+20 1
200 1
201 1
202 1
@@ -649,6 +606,7 @@ POSTHOOK: Input: default@dest2
237 1
238 1
239 1
+24 1
241 1
242 1
244 1
@@ -660,17 +618,20 @@ POSTHOOK: Input: default@dest2
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
@@ -685,6 +646,7 @@ POSTHOOK: Input: default@dest2
292 1
296 1
298 1
+30 1
302 1
305 1
306 1
@@ -702,6 +664,7 @@ POSTHOOK: Input: default@dest2
323 1
325 1
327 1
+33 1
331 1
332 1
333 1
@@ -709,11 +672,13 @@ POSTHOOK: Input: default@dest2
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
@@ -725,6 +690,7 @@ POSTHOOK: Input: default@dest2
367 1
368 1
369 1
+37 1
373 1
374 1
375 1
@@ -742,6 +708,7 @@ POSTHOOK: Input: default@dest2
396 1
397 1
399 1
+4 1
400 1
401 1
402 1
@@ -750,16 +717,19 @@ POSTHOOK: Input: default@dest2
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
@@ -768,6 +738,7 @@ POSTHOOK: Input: default@dest2
437 1
438 1
439 1
+44 1
443 1
444 1
446 1
@@ -787,6 +758,7 @@ POSTHOOK: Input: default@dest2
467 1
468 1
469 1
+47 1
470 1
472 1
475 1
@@ -810,3 +782,35 @@ POSTHOOK: Input: default@dest2
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=1598678&r1=1598677&r2=1598678&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 Fri May 30 17:37:05 2014
@@ -1,7 +1,11 @@
-PREHOOK: query: CREATE TABLE DEST1(key INT, value STRING) STORED AS TEXTFILE
+PREHOOK: query: -- SORT_QUERY_RESULTS
+
+CREATE TABLE DEST1(key INT, value STRING) STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
-POSTHOOK: query: CREATE TABLE DEST1(key INT, value STRING) STORED AS TEXTFILE
+POSTHOOK: query: -- SORT_QUERY_RESULTS
+
+CREATE TABLE DEST1(key INT, value STRING) STORED AS TEXTFILE
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@DEST1
@@ -176,81 +180,28 @@ 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 ORDER BY key
+PREHOOK: query: SELECT DEST1.* FROM DEST1
PREHOOK: type: QUERY
PREHOOK: Input: default@dest1
#### A masked pattern was here ####
-POSTHOOK: query: SELECT DEST1.* FROM DEST1 ORDER BY key
+POSTHOOK: query: SELECT DEST1.* FROM DEST1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@dest1
#### A masked pattern was here ####
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
@@ -266,6 +217,7 @@ POSTHOOK: Input: default@dest1
145 1
146 1
149 1
+15 1
150 1
152 1
153 1
@@ -282,6 +234,7 @@ POSTHOOK: Input: default@dest1
167 1
168 1
169 1
+17 1
170 1
172 1
174 1
@@ -290,12 +243,14 @@ POSTHOOK: Input: default@dest1
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
@@ -305,6 +260,8 @@ POSTHOOK: Input: default@dest1
196 1
197 1
199 1
+2 1
+20 1
200 1
201 1
202 1
@@ -332,6 +289,7 @@ POSTHOOK: Input: default@dest1
237 1
238 1
239 1
+24 1
241 1
242 1
244 1
@@ -343,17 +301,20 @@ POSTHOOK: Input: default@dest1
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
@@ -368,6 +329,7 @@ POSTHOOK: Input: default@dest1
292 1
296 1
298 1
+30 1
302 1
305 1
306 1
@@ -385,6 +347,7 @@ POSTHOOK: Input: default@dest1
323 1
325 1
327 1
+33 1
331 1
332 1
333 1
@@ -392,11 +355,13 @@ POSTHOOK: Input: default@dest1
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
@@ -408,6 +373,7 @@ POSTHOOK: Input: default@dest1
367 1
368 1
369 1
+37 1
373 1
374 1
375 1
@@ -425,6 +391,7 @@ POSTHOOK: Input: default@dest1
396 1
397 1
399 1
+4 1
400 1
401 1
402 1
@@ -433,16 +400,19 @@ POSTHOOK: Input: default@dest1
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
@@ -451,6 +421,7 @@ POSTHOOK: Input: default@dest1
437 1
438 1
439 1
+44 1
443 1
444 1
446 1
@@ -470,6 +441,7 @@ POSTHOOK: Input: default@dest1
467 1
468 1
469 1
+47 1
470 1
472 1
475 1
@@ -493,42 +465,7 @@ POSTHOOK: Input: default@dest1
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 ####
-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
@@ -545,6 +482,7 @@ POSTHOOK: Input: default@dest2
76 1
77 1
78 1
+8 1
80 1
82 1
83 1
@@ -552,22 +490,35 @@ POSTHOOK: Input: default@dest2
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 ####
+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
@@ -583,6 +534,7 @@ POSTHOOK: Input: default@dest2
145 1
146 1
149 1
+15 1
150 1
152 1
153 1
@@ -599,6 +551,7 @@ POSTHOOK: Input: default@dest2
167 1
168 1
169 1
+17 1
170 1
172 1
174 1
@@ -607,12 +560,14 @@ POSTHOOK: Input: default@dest2
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
@@ -622,6 +577,8 @@ POSTHOOK: Input: default@dest2
196 1
197 1
199 1
+2 1
+20 1
200 1
201 1
202 1
@@ -649,6 +606,7 @@ POSTHOOK: Input: default@dest2
237 1
238 1
239 1
+24 1
241 1
242 1
244 1
@@ -660,17 +618,20 @@ POSTHOOK: Input: default@dest2
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
@@ -685,6 +646,7 @@ POSTHOOK: Input: default@dest2
292 1
296 1
298 1
+30 1
302 1
305 1
306 1
@@ -702,6 +664,7 @@ POSTHOOK: Input: default@dest2
323 1
325 1
327 1
+33 1
331 1
332 1
333 1
@@ -709,11 +672,13 @@ POSTHOOK: Input: default@dest2
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
@@ -725,6 +690,7 @@ POSTHOOK: Input: default@dest2
367 1
368 1
369 1
+37 1
373 1
374 1
375 1
@@ -742,6 +708,7 @@ POSTHOOK: Input: default@dest2
396 1
397 1
399 1
+4 1
400 1
401 1
402 1
@@ -750,16 +717,19 @@ POSTHOOK: Input: default@dest2
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
@@ -768,6 +738,7 @@ POSTHOOK: Input: default@dest2
437 1
438 1
439 1
+44 1
443 1
444 1
446 1
@@ -787,6 +758,7 @@ POSTHOOK: Input: default@dest2
467 1
468 1
469 1
+47 1
470 1
472 1
475 1
@@ -810,3 +782,35 @@ POSTHOOK: Input: default@dest2
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