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(*))
