http://git-wip-us.apache.org/repos/asf/hive/blob/e470c7b1/ql/src/test/results/clientpositive/ppd_windowing2.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/ppd_windowing2.q.out b/ql/src/test/results/clientpositive/ppd_windowing2.q.out new file mode 100644 index 0000000..0e2081b --- /dev/null +++ b/ql/src/test/results/clientpositive/ppd_windowing2.q.out @@ -0,0 +1,9841 @@ +PREHOOK: query: -- NOTE: This is a correctness test. If you regen q.out, regen it with optimization turned off + +-- Test simple PPD through Windowing +select * from (SELECT key, sum(key) over(partition by key) as c1 from src)r1 where key > '2' +PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### +POSTHOOK: query: -- NOTE: This is a correctness test. If you regen q.out, regen it with optimization turned off + +-- Test simple PPD through Windowing +select * from (SELECT key, sum(key) over(partition by key) as c1 from src)r1 where key > '2' +POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +#### A masked pattern was here #### +20 20.0 +200 400.0 +200 400.0 +201 201.0 +202 202.0 +203 406.0 +203 406.0 +205 410.0 +205 410.0 +207 414.0 +207 414.0 +208 624.0 +208 624.0 +208 624.0 +209 418.0 +209 418.0 +213 426.0 +213 426.0 +214 214.0 +216 432.0 +216 432.0 +217 434.0 +217 434.0 +218 218.0 +219 438.0 +219 438.0 +221 442.0 +221 442.0 +222 222.0 +223 446.0 +223 446.0 +224 448.0 +224 448.0 +226 226.0 +228 228.0 +229 458.0 +229 458.0 +230 1150.0 +230 1150.0 +230 1150.0 +230 1150.0 +230 1150.0 +233 466.0 +233 466.0 +235 235.0 +237 474.0 +237 474.0 +238 476.0 +238 476.0 +239 478.0 +239 478.0 +24 48.0 +24 48.0 +241 241.0 +242 484.0 +242 484.0 +244 244.0 +247 247.0 +248 248.0 +249 249.0 +252 252.0 +255 510.0 +255 510.0 +256 512.0 +256 512.0 +257 257.0 +258 258.0 +26 52.0 +26 52.0 +260 260.0 +262 262.0 +263 263.0 +265 530.0 +265 530.0 +266 266.0 +27 27.0 +272 544.0 +272 544.0 +273 819.0 +273 819.0 +273 819.0 +274 274.0 +275 275.0 +277 1108.0 +277 1108.0 +277 1108.0 +277 1108.0 +278 556.0 +278 556.0 +28 28.0 +280 560.0 +280 560.0 +281 562.0 +281 562.0 +282 564.0 +282 564.0 +283 283.0 +284 284.0 +285 285.0 +286 286.0 +287 287.0 +288 576.0 +288 576.0 +289 289.0 +291 291.0 +292 292.0 +296 296.0 +298 894.0 +298 894.0 +298 894.0 +30 30.0 +302 302.0 +305 305.0 +306 306.0 +307 614.0 +307 614.0 +308 308.0 +309 618.0 +309 618.0 +310 310.0 +311 933.0 +311 933.0 +311 933.0 +315 315.0 +316 948.0 +316 948.0 +316 948.0 +317 634.0 +317 634.0 +318 954.0 +318 954.0 +318 954.0 +321 642.0 +321 642.0 +322 644.0 +322 644.0 +323 323.0 +325 650.0 +325 650.0 +327 981.0 +327 981.0 +327 981.0 +33 33.0 +331 662.0 +331 662.0 +332 332.0 +333 666.0 +333 666.0 +335 335.0 +336 336.0 +338 338.0 +339 339.0 +34 34.0 +341 341.0 +342 684.0 +342 684.0 +344 688.0 +344 688.0 +345 345.0 +348 1740.0 +348 1740.0 +348 1740.0 +348 1740.0 +348 1740.0 +35 105.0 +35 105.0 +35 105.0 +351 351.0 +353 706.0 +353 706.0 +356 356.0 +360 360.0 +362 362.0 +364 364.0 +365 365.0 +366 366.0 +367 734.0 +367 734.0 +368 368.0 +369 1107.0 +369 1107.0 +369 1107.0 +37 74.0 +37 74.0 +373 373.0 +374 374.0 +375 375.0 +377 377.0 +378 378.0 +379 379.0 +382 764.0 +382 764.0 +384 1152.0 +384 1152.0 +384 1152.0 +386 386.0 +389 389.0 +392 392.0 +393 393.0 +394 394.0 +395 790.0 +395 790.0 +396 1188.0 +396 1188.0 +396 1188.0 +397 794.0 +397 794.0 +399 798.0 +399 798.0 +4 4.0 +400 400.0 +401 2005.0 +401 2005.0 +401 2005.0 +401 2005.0 +401 2005.0 +402 402.0 +403 1209.0 +403 1209.0 +403 1209.0 +404 808.0 +404 808.0 +406 1624.0 +406 1624.0 +406 1624.0 +406 1624.0 +407 407.0 +409 1227.0 +409 1227.0 +409 1227.0 +41 41.0 +411 411.0 +413 826.0 +413 826.0 +414 828.0 +414 828.0 +417 1251.0 +417 1251.0 +417 1251.0 +418 418.0 +419 419.0 +42 84.0 +42 84.0 +421 421.0 +424 848.0 +424 848.0 +427 427.0 +429 858.0 +429 858.0 +43 43.0 +430 1290.0 +430 1290.0 +430 1290.0 +431 1293.0 +431 1293.0 +431 1293.0 +432 432.0 +435 435.0 +436 436.0 +437 437.0 +438 1314.0 +438 1314.0 +438 1314.0 +439 878.0 +439 878.0 +44 44.0 +443 443.0 +444 444.0 +446 446.0 +448 448.0 +449 449.0 +452 452.0 +453 453.0 +454 1362.0 +454 1362.0 +454 1362.0 +455 455.0 +457 457.0 +458 916.0 +458 916.0 +459 918.0 +459 918.0 +460 460.0 +462 924.0 +462 924.0 +463 926.0 +463 926.0 +466 1398.0 +466 1398.0 +466 1398.0 +467 467.0 +468 1872.0 +468 1872.0 +468 1872.0 +468 1872.0 +469 2345.0 +469 2345.0 +469 2345.0 +469 2345.0 +469 2345.0 +47 47.0 +470 470.0 +472 472.0 +475 475.0 +477 477.0 +478 956.0 +478 956.0 +479 479.0 +480 1440.0 +480 1440.0 +480 1440.0 +481 481.0 +482 482.0 +483 483.0 +484 484.0 +485 485.0 +487 487.0 +489 1956.0 +489 1956.0 +489 1956.0 +489 1956.0 +490 490.0 +491 491.0 +492 984.0 +492 984.0 +493 493.0 +494 494.0 +495 495.0 +496 496.0 +497 497.0 +498 1494.0 +498 1494.0 +498 1494.0 +5 15.0 +5 15.0 +5 15.0 +51 102.0 +51 102.0 +53 53.0 +54 54.0 +57 57.0 +58 116.0 +58 116.0 +64 64.0 +65 65.0 +66 66.0 +67 134.0 +67 134.0 +69 69.0 +70 210.0 +70 210.0 +70 210.0 +72 144.0 +72 144.0 +74 74.0 +76 152.0 +76 152.0 +77 77.0 +78 78.0 +8 8.0 +80 80.0 +82 82.0 +83 166.0 +83 166.0 +84 168.0 +84 168.0 +85 85.0 +86 86.0 +87 87.0 +9 9.0 +90 270.0 +90 270.0 +90 270.0 +92 92.0 +95 190.0 +95 190.0 +96 96.0 +97 194.0 +97 194.0 +98 196.0 +98 196.0 +PREHOOK: query: select * from (SELECT key, sum(key) over(partition by key) as c1 from src)r1 where key > 2 +PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### +POSTHOOK: query: select * from (SELECT key, sum(key) over(partition by key) as c1 from src)r1 where key > 2 +POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +#### A masked pattern was here #### +10 10.0 +100 200.0 +100 200.0 +103 206.0 +103 206.0 +104 208.0 +104 208.0 +105 105.0 +11 11.0 +111 111.0 +113 226.0 +113 226.0 +114 114.0 +116 116.0 +118 236.0 +118 236.0 +119 357.0 +119 357.0 +119 357.0 +12 24.0 +12 24.0 +120 240.0 +120 240.0 +125 250.0 +125 250.0 +126 126.0 +128 384.0 +128 384.0 +128 384.0 +129 258.0 +129 258.0 +131 131.0 +133 133.0 +134 268.0 +134 268.0 +136 136.0 +137 274.0 +137 274.0 +138 552.0 +138 552.0 +138 552.0 +138 552.0 +143 143.0 +145 145.0 +146 292.0 +146 292.0 +149 298.0 +149 298.0 +15 30.0 +15 30.0 +150 150.0 +152 304.0 +152 304.0 +153 153.0 +155 155.0 +156 156.0 +157 157.0 +158 158.0 +160 160.0 +162 162.0 +163 163.0 +164 328.0 +164 328.0 +165 330.0 +165 330.0 +166 166.0 +167 501.0 +167 501.0 +167 501.0 +168 168.0 +169 676.0 +169 676.0 +169 676.0 +169 676.0 +17 17.0 +170 170.0 +172 344.0 +172 344.0 +174 348.0 +174 348.0 +175 350.0 +175 350.0 +176 352.0 +176 352.0 +177 177.0 +178 178.0 +179 358.0 +179 358.0 +18 36.0 +18 36.0 +180 180.0 +181 181.0 +183 183.0 +186 186.0 +187 561.0 +187 561.0 +187 561.0 +189 189.0 +19 19.0 +190 190.0 +191 382.0 +191 382.0 +192 192.0 +193 579.0 +193 579.0 +193 579.0 +194 194.0 +195 390.0 +195 390.0 +196 196.0 +197 394.0 +197 394.0 +199 597.0 +199 597.0 +199 597.0 +20 20.0 +200 400.0 +200 400.0 +201 201.0 +202 202.0 +203 406.0 +203 406.0 +205 410.0 +205 410.0 +207 414.0 +207 414.0 +208 624.0 +208 624.0 +208 624.0 +209 418.0 +209 418.0 +213 426.0 +213 426.0 +214 214.0 +216 432.0 +216 432.0 +217 434.0 +217 434.0 +218 218.0 +219 438.0 +219 438.0 +221 442.0 +221 442.0 +222 222.0 +223 446.0 +223 446.0 +224 448.0 +224 448.0 +226 226.0 +228 228.0 +229 458.0 +229 458.0 +230 1150.0 +230 1150.0 +230 1150.0 +230 1150.0 +230 1150.0 +233 466.0 +233 466.0 +235 235.0 +237 474.0 +237 474.0 +238 476.0 +238 476.0 +239 478.0 +239 478.0 +24 48.0 +24 48.0 +241 241.0 +242 484.0 +242 484.0 +244 244.0 +247 247.0 +248 248.0 +249 249.0 +252 252.0 +255 510.0 +255 510.0 +256 512.0 +256 512.0 +257 257.0 +258 258.0 +26 52.0 +26 52.0 +260 260.0 +262 262.0 +263 263.0 +265 530.0 +265 530.0 +266 266.0 +27 27.0 +272 544.0 +272 544.0 +273 819.0 +273 819.0 +273 819.0 +274 274.0 +275 275.0 +277 1108.0 +277 1108.0 +277 1108.0 +277 1108.0 +278 556.0 +278 556.0 +28 28.0 +280 560.0 +280 560.0 +281 562.0 +281 562.0 +282 564.0 +282 564.0 +283 283.0 +284 284.0 +285 285.0 +286 286.0 +287 287.0 +288 576.0 +288 576.0 +289 289.0 +291 291.0 +292 292.0 +296 296.0 +298 894.0 +298 894.0 +298 894.0 +30 30.0 +302 302.0 +305 305.0 +306 306.0 +307 614.0 +307 614.0 +308 308.0 +309 618.0 +309 618.0 +310 310.0 +311 933.0 +311 933.0 +311 933.0 +315 315.0 +316 948.0 +316 948.0 +316 948.0 +317 634.0 +317 634.0 +318 954.0 +318 954.0 +318 954.0 +321 642.0 +321 642.0 +322 644.0 +322 644.0 +323 323.0 +325 650.0 +325 650.0 +327 981.0 +327 981.0 +327 981.0 +33 33.0 +331 662.0 +331 662.0 +332 332.0 +333 666.0 +333 666.0 +335 335.0 +336 336.0 +338 338.0 +339 339.0 +34 34.0 +341 341.0 +342 684.0 +342 684.0 +344 688.0 +344 688.0 +345 345.0 +348 1740.0 +348 1740.0 +348 1740.0 +348 1740.0 +348 1740.0 +35 105.0 +35 105.0 +35 105.0 +351 351.0 +353 706.0 +353 706.0 +356 356.0 +360 360.0 +362 362.0 +364 364.0 +365 365.0 +366 366.0 +367 734.0 +367 734.0 +368 368.0 +369 1107.0 +369 1107.0 +369 1107.0 +37 74.0 +37 74.0 +373 373.0 +374 374.0 +375 375.0 +377 377.0 +378 378.0 +379 379.0 +382 764.0 +382 764.0 +384 1152.0 +384 1152.0 +384 1152.0 +386 386.0 +389 389.0 +392 392.0 +393 393.0 +394 394.0 +395 790.0 +395 790.0 +396 1188.0 +396 1188.0 +396 1188.0 +397 794.0 +397 794.0 +399 798.0 +399 798.0 +4 4.0 +400 400.0 +401 2005.0 +401 2005.0 +401 2005.0 +401 2005.0 +401 2005.0 +402 402.0 +403 1209.0 +403 1209.0 +403 1209.0 +404 808.0 +404 808.0 +406 1624.0 +406 1624.0 +406 1624.0 +406 1624.0 +407 407.0 +409 1227.0 +409 1227.0 +409 1227.0 +41 41.0 +411 411.0 +413 826.0 +413 826.0 +414 828.0 +414 828.0 +417 1251.0 +417 1251.0 +417 1251.0 +418 418.0 +419 419.0 +42 84.0 +42 84.0 +421 421.0 +424 848.0 +424 848.0 +427 427.0 +429 858.0 +429 858.0 +43 43.0 +430 1290.0 +430 1290.0 +430 1290.0 +431 1293.0 +431 1293.0 +431 1293.0 +432 432.0 +435 435.0 +436 436.0 +437 437.0 +438 1314.0 +438 1314.0 +438 1314.0 +439 878.0 +439 878.0 +44 44.0 +443 443.0 +444 444.0 +446 446.0 +448 448.0 +449 449.0 +452 452.0 +453 453.0 +454 1362.0 +454 1362.0 +454 1362.0 +455 455.0 +457 457.0 +458 916.0 +458 916.0 +459 918.0 +459 918.0 +460 460.0 +462 924.0 +462 924.0 +463 926.0 +463 926.0 +466 1398.0 +466 1398.0 +466 1398.0 +467 467.0 +468 1872.0 +468 1872.0 +468 1872.0 +468 1872.0 +469 2345.0 +469 2345.0 +469 2345.0 +469 2345.0 +469 2345.0 +47 47.0 +470 470.0 +472 472.0 +475 475.0 +477 477.0 +478 956.0 +478 956.0 +479 479.0 +480 1440.0 +480 1440.0 +480 1440.0 +481 481.0 +482 482.0 +483 483.0 +484 484.0 +485 485.0 +487 487.0 +489 1956.0 +489 1956.0 +489 1956.0 +489 1956.0 +490 490.0 +491 491.0 +492 984.0 +492 984.0 +493 493.0 +494 494.0 +495 495.0 +496 496.0 +497 497.0 +498 1494.0 +498 1494.0 +498 1494.0 +5 15.0 +5 15.0 +5 15.0 +51 102.0 +51 102.0 +53 53.0 +54 54.0 +57 57.0 +58 116.0 +58 116.0 +64 64.0 +65 65.0 +66 66.0 +67 134.0 +67 134.0 +69 69.0 +70 210.0 +70 210.0 +70 210.0 +72 144.0 +72 144.0 +74 74.0 +76 152.0 +76 152.0 +77 77.0 +78 78.0 +8 8.0 +80 80.0 +82 82.0 +83 166.0 +83 166.0 +84 168.0 +84 168.0 +85 85.0 +86 86.0 +87 87.0 +9 9.0 +90 270.0 +90 270.0 +90 270.0 +92 92.0 +95 190.0 +95 190.0 +96 96.0 +97 194.0 +97 194.0 +98 196.0 +98 196.0 +PREHOOK: query: select * from (SELECT key, sum(key) over(partition by key) as c1 from src)r1 where cast(key as int) > 2 +PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### +POSTHOOK: query: select * from (SELECT key, sum(key) over(partition by key) as c1 from src)r1 where cast(key as int) > 2 +POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +#### A masked pattern was here #### +10 10.0 +100 200.0 +100 200.0 +103 206.0 +103 206.0 +104 208.0 +104 208.0 +105 105.0 +11 11.0 +111 111.0 +113 226.0 +113 226.0 +114 114.0 +116 116.0 +118 236.0 +118 236.0 +119 357.0 +119 357.0 +119 357.0 +12 24.0 +12 24.0 +120 240.0 +120 240.0 +125 250.0 +125 250.0 +126 126.0 +128 384.0 +128 384.0 +128 384.0 +129 258.0 +129 258.0 +131 131.0 +133 133.0 +134 268.0 +134 268.0 +136 136.0 +137 274.0 +137 274.0 +138 552.0 +138 552.0 +138 552.0 +138 552.0 +143 143.0 +145 145.0 +146 292.0 +146 292.0 +149 298.0 +149 298.0 +15 30.0 +15 30.0 +150 150.0 +152 304.0 +152 304.0 +153 153.0 +155 155.0 +156 156.0 +157 157.0 +158 158.0 +160 160.0 +162 162.0 +163 163.0 +164 328.0 +164 328.0 +165 330.0 +165 330.0 +166 166.0 +167 501.0 +167 501.0 +167 501.0 +168 168.0 +169 676.0 +169 676.0 +169 676.0 +169 676.0 +17 17.0 +170 170.0 +172 344.0 +172 344.0 +174 348.0 +174 348.0 +175 350.0 +175 350.0 +176 352.0 +176 352.0 +177 177.0 +178 178.0 +179 358.0 +179 358.0 +18 36.0 +18 36.0 +180 180.0 +181 181.0 +183 183.0 +186 186.0 +187 561.0 +187 561.0 +187 561.0 +189 189.0 +19 19.0 +190 190.0 +191 382.0 +191 382.0 +192 192.0 +193 579.0 +193 579.0 +193 579.0 +194 194.0 +195 390.0 +195 390.0 +196 196.0 +197 394.0 +197 394.0 +199 597.0 +199 597.0 +199 597.0 +20 20.0 +200 400.0 +200 400.0 +201 201.0 +202 202.0 +203 406.0 +203 406.0 +205 410.0 +205 410.0 +207 414.0 +207 414.0 +208 624.0 +208 624.0 +208 624.0 +209 418.0 +209 418.0 +213 426.0 +213 426.0 +214 214.0 +216 432.0 +216 432.0 +217 434.0 +217 434.0 +218 218.0 +219 438.0 +219 438.0 +221 442.0 +221 442.0 +222 222.0 +223 446.0 +223 446.0 +224 448.0 +224 448.0 +226 226.0 +228 228.0 +229 458.0 +229 458.0 +230 1150.0 +230 1150.0 +230 1150.0 +230 1150.0 +230 1150.0 +233 466.0 +233 466.0 +235 235.0 +237 474.0 +237 474.0 +238 476.0 +238 476.0 +239 478.0 +239 478.0 +24 48.0 +24 48.0 +241 241.0 +242 484.0 +242 484.0 +244 244.0 +247 247.0 +248 248.0 +249 249.0 +252 252.0 +255 510.0 +255 510.0 +256 512.0 +256 512.0 +257 257.0 +258 258.0 +26 52.0 +26 52.0 +260 260.0 +262 262.0 +263 263.0 +265 530.0 +265 530.0 +266 266.0 +27 27.0 +272 544.0 +272 544.0 +273 819.0 +273 819.0 +273 819.0 +274 274.0 +275 275.0 +277 1108.0 +277 1108.0 +277 1108.0 +277 1108.0 +278 556.0 +278 556.0 +28 28.0 +280 560.0 +280 560.0 +281 562.0 +281 562.0 +282 564.0 +282 564.0 +283 283.0 +284 284.0 +285 285.0 +286 286.0 +287 287.0 +288 576.0 +288 576.0 +289 289.0 +291 291.0 +292 292.0 +296 296.0 +298 894.0 +298 894.0 +298 894.0 +30 30.0 +302 302.0 +305 305.0 +306 306.0 +307 614.0 +307 614.0 +308 308.0 +309 618.0 +309 618.0 +310 310.0 +311 933.0 +311 933.0 +311 933.0 +315 315.0 +316 948.0 +316 948.0 +316 948.0 +317 634.0 +317 634.0 +318 954.0 +318 954.0 +318 954.0 +321 642.0 +321 642.0 +322 644.0 +322 644.0 +323 323.0 +325 650.0 +325 650.0 +327 981.0 +327 981.0 +327 981.0 +33 33.0 +331 662.0 +331 662.0 +332 332.0 +333 666.0 +333 666.0 +335 335.0 +336 336.0 +338 338.0 +339 339.0 +34 34.0 +341 341.0 +342 684.0 +342 684.0 +344 688.0 +344 688.0 +345 345.0 +348 1740.0 +348 1740.0 +348 1740.0 +348 1740.0 +348 1740.0 +35 105.0 +35 105.0 +35 105.0 +351 351.0 +353 706.0 +353 706.0 +356 356.0 +360 360.0 +362 362.0 +364 364.0 +365 365.0 +366 366.0 +367 734.0 +367 734.0 +368 368.0 +369 1107.0 +369 1107.0 +369 1107.0 +37 74.0 +37 74.0 +373 373.0 +374 374.0 +375 375.0 +377 377.0 +378 378.0 +379 379.0 +382 764.0 +382 764.0 +384 1152.0 +384 1152.0 +384 1152.0 +386 386.0 +389 389.0 +392 392.0 +393 393.0 +394 394.0 +395 790.0 +395 790.0 +396 1188.0 +396 1188.0 +396 1188.0 +397 794.0 +397 794.0 +399 798.0 +399 798.0 +4 4.0 +400 400.0 +401 2005.0 +401 2005.0 +401 2005.0 +401 2005.0 +401 2005.0 +402 402.0 +403 1209.0 +403 1209.0 +403 1209.0 +404 808.0 +404 808.0 +406 1624.0 +406 1624.0 +406 1624.0 +406 1624.0 +407 407.0 +409 1227.0 +409 1227.0 +409 1227.0 +41 41.0 +411 411.0 +413 826.0 +413 826.0 +414 828.0 +414 828.0 +417 1251.0 +417 1251.0 +417 1251.0 +418 418.0 +419 419.0 +42 84.0 +42 84.0 +421 421.0 +424 848.0 +424 848.0 +427 427.0 +429 858.0 +429 858.0 +43 43.0 +430 1290.0 +430 1290.0 +430 1290.0 +431 1293.0 +431 1293.0 +431 1293.0 +432 432.0 +435 435.0 +436 436.0 +437 437.0 +438 1314.0 +438 1314.0 +438 1314.0 +439 878.0 +439 878.0 +44 44.0 +443 443.0 +444 444.0 +446 446.0 +448 448.0 +449 449.0 +452 452.0 +453 453.0 +454 1362.0 +454 1362.0 +454 1362.0 +455 455.0 +457 457.0 +458 916.0 +458 916.0 +459 918.0 +459 918.0 +460 460.0 +462 924.0 +462 924.0 +463 926.0 +463 926.0 +466 1398.0 +466 1398.0 +466 1398.0 +467 467.0 +468 1872.0 +468 1872.0 +468 1872.0 +468 1872.0 +469 2345.0 +469 2345.0 +469 2345.0 +469 2345.0 +469 2345.0 +47 47.0 +470 470.0 +472 472.0 +475 475.0 +477 477.0 +478 956.0 +478 956.0 +479 479.0 +480 1440.0 +480 1440.0 +480 1440.0 +481 481.0 +482 482.0 +483 483.0 +484 484.0 +485 485.0 +487 487.0 +489 1956.0 +489 1956.0 +489 1956.0 +489 1956.0 +490 490.0 +491 491.0 +492 984.0 +492 984.0 +493 493.0 +494 494.0 +495 495.0 +496 496.0 +497 497.0 +498 1494.0 +498 1494.0 +498 1494.0 +5 15.0 +5 15.0 +5 15.0 +51 102.0 +51 102.0 +53 53.0 +54 54.0 +57 57.0 +58 116.0 +58 116.0 +64 64.0 +65 65.0 +66 66.0 +67 134.0 +67 134.0 +69 69.0 +70 210.0 +70 210.0 +70 210.0 +72 144.0 +72 144.0 +74 74.0 +76 152.0 +76 152.0 +77 77.0 +78 78.0 +8 8.0 +80 80.0 +82 82.0 +83 166.0 +83 166.0 +84 168.0 +84 168.0 +85 85.0 +86 86.0 +87 87.0 +9 9.0 +90 270.0 +90 270.0 +90 270.0 +92 92.0 +95 190.0 +95 190.0 +96 96.0 +97 194.0 +97 194.0 +98 196.0 +98 196.0 +PREHOOK: query: select * from (SELECT key, sum(key) over(partition by key) as c1 from src)r1 where (cast(key as int) + 1) > 2 +PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### +POSTHOOK: query: select * from (SELECT key, sum(key) over(partition by key) as c1 from src)r1 where (cast(key as int) + 1) > 2 +POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +#### A masked pattern was here #### +10 10.0 +100 200.0 +100 200.0 +103 206.0 +103 206.0 +104 208.0 +104 208.0 +105 105.0 +11 11.0 +111 111.0 +113 226.0 +113 226.0 +114 114.0 +116 116.0 +118 236.0 +118 236.0 +119 357.0 +119 357.0 +119 357.0 +12 24.0 +12 24.0 +120 240.0 +120 240.0 +125 250.0 +125 250.0 +126 126.0 +128 384.0 +128 384.0 +128 384.0 +129 258.0 +129 258.0 +131 131.0 +133 133.0 +134 268.0 +134 268.0 +136 136.0 +137 274.0 +137 274.0 +138 552.0 +138 552.0 +138 552.0 +138 552.0 +143 143.0 +145 145.0 +146 292.0 +146 292.0 +149 298.0 +149 298.0 +15 30.0 +15 30.0 +150 150.0 +152 304.0 +152 304.0 +153 153.0 +155 155.0 +156 156.0 +157 157.0 +158 158.0 +160 160.0 +162 162.0 +163 163.0 +164 328.0 +164 328.0 +165 330.0 +165 330.0 +166 166.0 +167 501.0 +167 501.0 +167 501.0 +168 168.0 +169 676.0 +169 676.0 +169 676.0 +169 676.0 +17 17.0 +170 170.0 +172 344.0 +172 344.0 +174 348.0 +174 348.0 +175 350.0 +175 350.0 +176 352.0 +176 352.0 +177 177.0 +178 178.0 +179 358.0 +179 358.0 +18 36.0 +18 36.0 +180 180.0 +181 181.0 +183 183.0 +186 186.0 +187 561.0 +187 561.0 +187 561.0 +189 189.0 +19 19.0 +190 190.0 +191 382.0 +191 382.0 +192 192.0 +193 579.0 +193 579.0 +193 579.0 +194 194.0 +195 390.0 +195 390.0 +196 196.0 +197 394.0 +197 394.0 +199 597.0 +199 597.0 +199 597.0 +2 2.0 +20 20.0 +200 400.0 +200 400.0 +201 201.0 +202 202.0 +203 406.0 +203 406.0 +205 410.0 +205 410.0 +207 414.0 +207 414.0 +208 624.0 +208 624.0 +208 624.0 +209 418.0 +209 418.0 +213 426.0 +213 426.0 +214 214.0 +216 432.0 +216 432.0 +217 434.0 +217 434.0 +218 218.0 +219 438.0 +219 438.0 +221 442.0 +221 442.0 +222 222.0 +223 446.0 +223 446.0 +224 448.0 +224 448.0 +226 226.0 +228 228.0 +229 458.0 +229 458.0 +230 1150.0 +230 1150.0 +230 1150.0 +230 1150.0 +230 1150.0 +233 466.0 +233 466.0 +235 235.0 +237 474.0 +237 474.0 +238 476.0 +238 476.0 +239 478.0 +239 478.0 +24 48.0 +24 48.0 +241 241.0 +242 484.0 +242 484.0 +244 244.0 +247 247.0 +248 248.0 +249 249.0 +252 252.0 +255 510.0 +255 510.0 +256 512.0 +256 512.0 +257 257.0 +258 258.0 +26 52.0 +26 52.0 +260 260.0 +262 262.0 +263 263.0 +265 530.0 +265 530.0 +266 266.0 +27 27.0 +272 544.0 +272 544.0 +273 819.0 +273 819.0 +273 819.0 +274 274.0 +275 275.0 +277 1108.0 +277 1108.0 +277 1108.0 +277 1108.0 +278 556.0 +278 556.0 +28 28.0 +280 560.0 +280 560.0 +281 562.0 +281 562.0 +282 564.0 +282 564.0 +283 283.0 +284 284.0 +285 285.0 +286 286.0 +287 287.0 +288 576.0 +288 576.0 +289 289.0 +291 291.0 +292 292.0 +296 296.0 +298 894.0 +298 894.0 +298 894.0 +30 30.0 +302 302.0 +305 305.0 +306 306.0 +307 614.0 +307 614.0 +308 308.0 +309 618.0 +309 618.0 +310 310.0 +311 933.0 +311 933.0 +311 933.0 +315 315.0 +316 948.0 +316 948.0 +316 948.0 +317 634.0 +317 634.0 +318 954.0 +318 954.0 +318 954.0 +321 642.0 +321 642.0 +322 644.0 +322 644.0 +323 323.0 +325 650.0 +325 650.0 +327 981.0 +327 981.0 +327 981.0 +33 33.0 +331 662.0 +331 662.0 +332 332.0 +333 666.0 +333 666.0 +335 335.0 +336 336.0 +338 338.0 +339 339.0 +34 34.0 +341 341.0 +342 684.0 +342 684.0 +344 688.0 +344 688.0 +345 345.0 +348 1740.0 +348 1740.0 +348 1740.0 +348 1740.0 +348 1740.0 +35 105.0 +35 105.0 +35 105.0 +351 351.0 +353 706.0 +353 706.0 +356 356.0 +360 360.0 +362 362.0 +364 364.0 +365 365.0 +366 366.0 +367 734.0 +367 734.0 +368 368.0 +369 1107.0 +369 1107.0 +369 1107.0 +37 74.0 +37 74.0 +373 373.0 +374 374.0 +375 375.0 +377 377.0 +378 378.0 +379 379.0 +382 764.0 +382 764.0 +384 1152.0 +384 1152.0 +384 1152.0 +386 386.0 +389 389.0 +392 392.0 +393 393.0 +394 394.0 +395 790.0 +395 790.0 +396 1188.0 +396 1188.0 +396 1188.0 +397 794.0 +397 794.0 +399 798.0 +399 798.0 +4 4.0 +400 400.0 +401 2005.0 +401 2005.0 +401 2005.0 +401 2005.0 +401 2005.0 +402 402.0 +403 1209.0 +403 1209.0 +403 1209.0 +404 808.0 +404 808.0 +406 1624.0 +406 1624.0 +406 1624.0 +406 1624.0 +407 407.0 +409 1227.0 +409 1227.0 +409 1227.0 +41 41.0 +411 411.0 +413 826.0 +413 826.0 +414 828.0 +414 828.0 +417 1251.0 +417 1251.0 +417 1251.0 +418 418.0 +419 419.0 +42 84.0 +42 84.0 +421 421.0 +424 848.0 +424 848.0 +427 427.0 +429 858.0 +429 858.0 +43 43.0 +430 1290.0 +430 1290.0 +430 1290.0 +431 1293.0 +431 1293.0 +431 1293.0 +432 432.0 +435 435.0 +436 436.0 +437 437.0 +438 1314.0 +438 1314.0 +438 1314.0 +439 878.0 +439 878.0 +44 44.0 +443 443.0 +444 444.0 +446 446.0 +448 448.0 +449 449.0 +452 452.0 +453 453.0 +454 1362.0 +454 1362.0 +454 1362.0 +455 455.0 +457 457.0 +458 916.0 +458 916.0 +459 918.0 +459 918.0 +460 460.0 +462 924.0 +462 924.0 +463 926.0 +463 926.0 +466 1398.0 +466 1398.0 +466 1398.0 +467 467.0 +468 1872.0 +468 1872.0 +468 1872.0 +468 1872.0 +469 2345.0 +469 2345.0 +469 2345.0 +469 2345.0 +469 2345.0 +47 47.0 +470 470.0 +472 472.0 +475 475.0 +477 477.0 +478 956.0 +478 956.0 +479 479.0 +480 1440.0 +480 1440.0 +480 1440.0 +481 481.0 +482 482.0 +483 483.0 +484 484.0 +485 485.0 +487 487.0 +489 1956.0 +489 1956.0 +489 1956.0 +489 1956.0 +490 490.0 +491 491.0 +492 984.0 +492 984.0 +493 493.0 +494 494.0 +495 495.0 +496 496.0 +497 497.0 +498 1494.0 +498 1494.0 +498 1494.0 +5 15.0 +5 15.0 +5 15.0 +51 102.0 +51 102.0 +53 53.0 +54 54.0 +57 57.0 +58 116.0 +58 116.0 +64 64.0 +65 65.0 +66 66.0 +67 134.0 +67 134.0 +69 69.0 +70 210.0 +70 210.0 +70 210.0 +72 144.0 +72 144.0 +74 74.0 +76 152.0 +76 152.0 +77 77.0 +78 78.0 +8 8.0 +80 80.0 +82 82.0 +83 166.0 +83 166.0 +84 168.0 +84 168.0 +85 85.0 +86 86.0 +87 87.0 +9 9.0 +90 270.0 +90 270.0 +90 270.0 +92 92.0 +95 190.0 +95 190.0 +96 96.0 +97 194.0 +97 194.0 +98 196.0 +98 196.0 +PREHOOK: query: select * from (SELECT (cast(key as int))+2 as key, sum(key) over(partition by key) as c1 from src)r1 where (cast(key as int) + 1) > 2 +PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### +POSTHOOK: query: select * from (SELECT (cast(key as int))+2 as key, sum(key) over(partition by key) as c1 from src)r1 where (cast(key as int) + 1) > 2 +POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +#### A masked pattern was here #### +2 0.0 +2 0.0 +2 0.0 +12 10.0 +102 200.0 +102 200.0 +105 206.0 +105 206.0 +106 208.0 +106 208.0 +107 105.0 +13 11.0 +113 111.0 +115 226.0 +115 226.0 +116 114.0 +118 116.0 +120 236.0 +120 236.0 +121 357.0 +121 357.0 +121 357.0 +14 24.0 +14 24.0 +122 240.0 +122 240.0 +127 250.0 +127 250.0 +128 126.0 +130 384.0 +130 384.0 +130 384.0 +131 258.0 +131 258.0 +133 131.0 +135 133.0 +136 268.0 +136 268.0 +138 136.0 +139 274.0 +139 274.0 +140 552.0 +140 552.0 +140 552.0 +140 552.0 +145 143.0 +147 145.0 +148 292.0 +148 292.0 +151 298.0 +151 298.0 +17 30.0 +17 30.0 +152 150.0 +154 304.0 +154 304.0 +155 153.0 +157 155.0 +158 156.0 +159 157.0 +160 158.0 +162 160.0 +164 162.0 +165 163.0 +166 328.0 +166 328.0 +167 330.0 +167 330.0 +168 166.0 +169 501.0 +169 501.0 +169 501.0 +170 168.0 +171 676.0 +171 676.0 +171 676.0 +171 676.0 +19 17.0 +172 170.0 +174 344.0 +174 344.0 +176 348.0 +176 348.0 +177 350.0 +177 350.0 +178 352.0 +178 352.0 +179 177.0 +180 178.0 +181 358.0 +181 358.0 +20 36.0 +20 36.0 +182 180.0 +183 181.0 +185 183.0 +188 186.0 +189 561.0 +189 561.0 +189 561.0 +191 189.0 +21 19.0 +192 190.0 +193 382.0 +193 382.0 +194 192.0 +195 579.0 +195 579.0 +195 579.0 +196 194.0 +197 390.0 +197 390.0 +198 196.0 +199 394.0 +199 394.0 +201 597.0 +201 597.0 +201 597.0 +4 2.0 +22 20.0 +202 400.0 +202 400.0 +203 201.0 +204 202.0 +205 406.0 +205 406.0 +207 410.0 +207 410.0 +209 414.0 +209 414.0 +210 624.0 +210 624.0 +210 624.0 +211 418.0 +211 418.0 +215 426.0 +215 426.0 +216 214.0 +218 432.0 +218 432.0 +219 434.0 +219 434.0 +220 218.0 +221 438.0 +221 438.0 +223 442.0 +223 442.0 +224 222.0 +225 446.0 +225 446.0 +226 448.0 +226 448.0 +228 226.0 +230 228.0 +231 458.0 +231 458.0 +232 1150.0 +232 1150.0 +232 1150.0 +232 1150.0 +232 1150.0 +235 466.0 +235 466.0 +237 235.0 +239 474.0 +239 474.0 +240 476.0 +240 476.0 +241 478.0 +241 478.0 +26 48.0 +26 48.0 +243 241.0 +244 484.0 +244 484.0 +246 244.0 +249 247.0 +250 248.0 +251 249.0 +254 252.0 +257 510.0 +257 510.0 +258 512.0 +258 512.0 +259 257.0 +260 258.0 +28 52.0 +28 52.0 +262 260.0 +264 262.0 +265 263.0 +267 530.0 +267 530.0 +268 266.0 +29 27.0 +274 544.0 +274 544.0 +275 819.0 +275 819.0 +275 819.0 +276 274.0 +277 275.0 +279 1108.0 +279 1108.0 +279 1108.0 +279 1108.0 +280 556.0 +280 556.0 +30 28.0 +282 560.0 +282 560.0 +283 562.0 +283 562.0 +284 564.0 +284 564.0 +285 283.0 +286 284.0 +287 285.0 +288 286.0 +289 287.0 +290 576.0 +290 576.0 +291 289.0 +293 291.0 +294 292.0 +298 296.0 +300 894.0 +300 894.0 +300 894.0 +32 30.0 +304 302.0 +307 305.0 +308 306.0 +309 614.0 +309 614.0 +310 308.0 +311 618.0 +311 618.0 +312 310.0 +313 933.0 +313 933.0 +313 933.0 +317 315.0 +318 948.0 +318 948.0 +318 948.0 +319 634.0 +319 634.0 +320 954.0 +320 954.0 +320 954.0 +323 642.0 +323 642.0 +324 644.0 +324 644.0 +325 323.0 +327 650.0 +327 650.0 +329 981.0 +329 981.0 +329 981.0 +35 33.0 +333 662.0 +333 662.0 +334 332.0 +335 666.0 +335 666.0 +337 335.0 +338 336.0 +340 338.0 +341 339.0 +36 34.0 +343 341.0 +344 684.0 +344 684.0 +346 688.0 +346 688.0 +347 345.0 +350 1740.0 +350 1740.0 +350 1740.0 +350 1740.0 +350 1740.0 +37 105.0 +37 105.0 +37 105.0 +353 351.0 +355 706.0 +355 706.0 +358 356.0 +362 360.0 +364 362.0 +366 364.0 +367 365.0 +368 366.0 +369 734.0 +369 734.0 +370 368.0 +371 1107.0 +371 1107.0 +371 1107.0 +39 74.0 +39 74.0 +375 373.0 +376 374.0 +377 375.0 +379 377.0 +380 378.0 +381 379.0 +384 764.0 +384 764.0 +386 1152.0 +386 1152.0 +386 1152.0 +388 386.0 +391 389.0 +394 392.0 +395 393.0 +396 394.0 +397 790.0 +397 790.0 +398 1188.0 +398 1188.0 +398 1188.0 +399 794.0 +399 794.0 +401 798.0 +401 798.0 +6 4.0 +402 400.0 +403 2005.0 +403 2005.0 +403 2005.0 +403 2005.0 +403 2005.0 +404 402.0 +405 1209.0 +405 1209.0 +405 1209.0 +406 808.0 +406 808.0 +408 1624.0 +408 1624.0 +408 1624.0 +408 1624.0 +409 407.0 +411 1227.0 +411 1227.0 +411 1227.0 +43 41.0 +413 411.0 +415 826.0 +415 826.0 +416 828.0 +416 828.0 +419 1251.0 +419 1251.0 +419 1251.0 +420 418.0 +421 419.0 +44 84.0 +44 84.0 +423 421.0 +426 848.0 +426 848.0 +429 427.0 +431 858.0 +431 858.0 +45 43.0 +432 1290.0 +432 1290.0 +432 1290.0 +433 1293.0 +433 1293.0 +433 1293.0 +434 432.0 +437 435.0 +438 436.0 +439 437.0 +440 1314.0 +440 1314.0 +440 1314.0 +441 878.0 +441 878.0 +46 44.0 +445 443.0 +446 444.0 +448 446.0 +450 448.0 +451 449.0 +454 452.0 +455 453.0 +456 1362.0 +456 1362.0 +456 1362.0 +457 455.0 +459 457.0 +460 916.0 +460 916.0 +461 918.0 +461 918.0 +462 460.0 +464 924.0 +464 924.0 +465 926.0 +465 926.0 +468 1398.0 +468 1398.0 +468 1398.0 +469 467.0 +470 1872.0 +470 1872.0 +470 1872.0 +470 1872.0 +471 2345.0 +471 2345.0 +471 2345.0 +471 2345.0 +471 2345.0 +49 47.0 +472 470.0 +474 472.0 +477 475.0 +479 477.0 +480 956.0 +480 956.0 +481 479.0 +482 1440.0 +482 1440.0 +482 1440.0 +483 481.0 +484 482.0 +485 483.0 +486 484.0 +487 485.0 +489 487.0 +491 1956.0 +491 1956.0 +491 1956.0 +491 1956.0 +492 490.0 +493 491.0 +494 984.0 +494 984.0 +495 493.0 +496 494.0 +497 495.0 +498 496.0 +499 497.0 +500 1494.0 +500 1494.0 +500 1494.0 +7 15.0 +7 15.0 +7 15.0 +53 102.0 +53 102.0 +55 53.0 +56 54.0 +59 57.0 +60 116.0 +60 116.0 +66 64.0 +67 65.0 +68 66.0 +69 134.0 +69 134.0 +71 69.0 +72 210.0 +72 210.0 +72 210.0 +74 144.0 +74 144.0 +76 74.0 +78 152.0 +78 152.0 +79 77.0 +80 78.0 +10 8.0 +82 80.0 +84 82.0 +85 166.0 +85 166.0 +86 168.0 +86 168.0 +87 85.0 +88 86.0 +89 87.0 +11 9.0 +92 270.0 +92 270.0 +92 270.0 +94 92.0 +97 190.0 +97 190.0 +98 96.0 +99 194.0 +99 194.0 +100 196.0 +100 196.0 +PREHOOK: query: -- Test PPD through Windowing where predicate is a subset of partition keys +select * from (SELECT key, sum(key) over(partition by key, value) as c1 from src)r1 where key > '2' +PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### +POSTHOOK: query: -- Test PPD through Windowing where predicate is a subset of partition keys +select * from (SELECT key, sum(key) over(partition by key, value) as c1 from src)r1 where key > '2' +POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +#### A masked pattern was here #### +20 20.0 +200 400.0 +200 400.0 +201 201.0 +202 202.0 +203 406.0 +203 406.0 +205 410.0 +205 410.0 +207 414.0 +207 414.0 +208 624.0 +208 624.0 +208 624.0 +209 418.0 +209 418.0 +213 426.0 +213 426.0 +214 214.0 +216 432.0 +216 432.0 +217 434.0 +217 434.0 +218 218.0 +219 438.0 +219 438.0 +221 442.0 +221 442.0 +222 222.0 +223 446.0 +223 446.0 +224 448.0 +224 448.0 +226 226.0 +228 228.0 +229 458.0 +229 458.0 +230 1150.0 +230 1150.0 +230 1150.0 +230 1150.0 +230 1150.0 +233 466.0 +233 466.0 +235 235.0 +237 474.0 +237 474.0 +238 476.0 +238 476.0 +239 478.0 +239 478.0 +24 48.0 +24 48.0 +241 241.0 +242 484.0 +242 484.0 +244 244.0 +247 247.0 +248 248.0 +249 249.0 +252 252.0 +255 510.0 +255 510.0 +256 512.0 +256 512.0 +257 257.0 +258 258.0 +26 52.0 +26 52.0 +260 260.0 +262 262.0 +263 263.0 +265 530.0 +265 530.0 +266 266.0 +27 27.0 +272 544.0 +272 544.0 +273 819.0 +273 819.0 +273 819.0 +274 274.0 +275 275.0 +277 1108.0 +277 1108.0 +277 1108.0 +277 1108.0 +278 556.0 +278 556.0 +28 28.0 +280 560.0 +280 560.0 +281 562.0 +281 562.0 +282 564.0 +282 564.0 +283 283.0 +284 284.0 +285 285.0 +286 286.0 +287 287.0 +288 576.0 +288 576.0 +289 289.0 +291 291.0 +292 292.0 +296 296.0 +298 894.0 +298 894.0 +298 894.0 +30 30.0 +302 302.0 +305 305.0 +306 306.0 +307 614.0 +307 614.0 +308 308.0 +309 618.0 +309 618.0 +310 310.0 +311 933.0 +311 933.0 +311 933.0 +315 315.0 +316 948.0 +316 948.0 +316 948.0 +317 634.0 +317 634.0 +318 954.0 +318 954.0 +318 954.0 +321 642.0 +321 642.0 +322 644.0 +322 644.0 +323 323.0 +325 650.0 +325 650.0 +327 981.0 +327 981.0 +327 981.0 +33 33.0 +331 662.0 +331 662.0 +332 332.0 +333 666.0 +333 666.0 +335 335.0 +336 336.0 +338 338.0 +339 339.0 +34 34.0 +341 341.0 +342 684.0 +342 684.0 +344 688.0 +344 688.0 +345 345.0 +348 1740.0 +348 1740.0 +348 1740.0 +348 1740.0 +348 1740.0 +35 105.0 +35 105.0 +35 105.0 +351 351.0 +353 706.0 +353 706.0 +356 356.0 +360 360.0 +362 362.0 +364 364.0 +365 365.0 +366 366.0 +367 734.0 +367 734.0 +368 368.0 +369 1107.0 +369 1107.0 +369 1107.0 +37 74.0 +37 74.0 +373 373.0 +374 374.0 +375 375.0 +377 377.0 +378 378.0 +379 379.0 +382 764.0 +382 764.0 +384 1152.0 +384 1152.0 +384 1152.0 +386 386.0 +389 389.0 +392 392.0 +393 393.0 +394 394.0 +395 790.0 +395 790.0 +396 1188.0 +396 1188.0 +396 1188.0 +397 794.0 +397 794.0 +399 798.0 +399 798.0 +4 4.0 +400 400.0 +401 2005.0 +401 2005.0 +401 2005.0 +401 2005.0 +401 2005.0 +402 402.0 +403 1209.0 +403 1209.0 +403 1209.0 +404 808.0 +404 808.0 +406 1624.0 +406 1624.0 +406 1624.0 +406 1624.0 +407 407.0 +409 1227.0 +409 1227.0 +409 1227.0 +41 41.0 +411 411.0 +413 826.0 +413 826.0 +414 828.0 +414 828.0 +417 1251.0 +417 1251.0 +417 1251.0 +418 418.0 +419 419.0 +42 84.0 +42 84.0 +421 421.0 +424 848.0 +424 848.0 +427 427.0 +429 858.0 +429 858.0 +43 43.0 +430 1290.0 +430 1290.0 +430 1290.0 +431 1293.0 +431 1293.0 +431 1293.0 +432 432.0 +435 435.0 +436 436.0 +437 437.0 +438 1314.0 +438 1314.0 +438 1314.0 +439 878.0 +439 878.0 +44 44.0 +443 443.0 +444 444.0 +446 446.0 +448 448.0 +449 449.0 +452 452.0 +453 453.0 +454 1362.0 +454 1362.0 +454 1362.0 +455 455.0 +457 457.0 +458 916.0 +458 916.0 +459 918.0 +459 918.0 +460 460.0 +462 924.0 +462 924.0 +463 926.0 +463 926.0 +466 1398.0 +466 1398.0 +466 1398.0 +467 467.0 +468 1872.0 +468 1872.0 +468 1872.0 +468 1872.0 +469 2345.0 +469 2345.0 +469 2345.0 +469 2345.0 +469 2345.0 +47 47.0 +470 470.0 +472 472.0 +475 475.0 +477 477.0 +478 956.0 +478 956.0 +479 479.0 +480 1440.0 +480 1440.0 +480 1440.0 +481 481.0 +482 482.0 +483 483.0 +484 484.0 +485 485.0 +487 487.0 +489 1956.0 +489 1956.0 +489 1956.0 +489 1956.0 +490 490.0 +491 491.0 +492 984.0 +492 984.0 +493 493.0 +494 494.0 +495 495.0 +496 496.0 +497 497.0 +498 1494.0 +498 1494.0 +498 1494.0 +5 15.0 +5 15.0 +5 15.0 +51 102.0 +51 102.0 +53 53.0 +54 54.0 +57 57.0 +58 116.0 +58 116.0 +64 64.0 +65 65.0 +66 66.0 +67 134.0 +67 134.0 +69 69.0 +70 210.0 +70 210.0 +70 210.0 +72 144.0 +72 144.0 +74 74.0 +76 152.0 +76 152.0 +77 77.0 +78 78.0 +8 8.0 +80 80.0 +82 82.0 +83 166.0 +83 166.0 +84 168.0 +84 168.0 +85 85.0 +86 86.0 +87 87.0 +9 9.0 +90 270.0 +90 270.0 +90 270.0 +92 92.0 +95 190.0 +95 190.0 +96 96.0 +97 194.0 +97 194.0 +98 196.0 +98 196.0 +PREHOOK: query: select * from (SELECT key, sum(key) over(partition by key, value) as c1 from src)r1 where key > 2 +PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### +POSTHOOK: query: select * from (SELECT key, sum(key) over(partition by key, value) as c1 from src)r1 where key > 2 +POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +#### A masked pattern was here #### +10 10.0 +100 200.0 +100 200.0 +103 206.0 +103 206.0 +104 208.0 +104 208.0 +105 105.0 +11 11.0 +111 111.0 +113 226.0 +113 226.0 +114 114.0 +116 116.0 +118 236.0 +118 236.0 +119 357.0 +119 357.0 +119 357.0 +12 24.0 +12 24.0 +120 240.0 +120 240.0 +125 250.0 +125 250.0 +126 126.0 +128 384.0 +128 384.0 +128 384.0 +129 258.0 +129 258.0 +131 131.0 +133 133.0 +134 268.0 +134 268.0 +136 136.0 +137 274.0 +137 274.0 +138 552.0 +138 552.0 +138 552.0 +138 552.0 +143 143.0 +145 145.0 +146 292.0 +146 292.0 +149 298.0 +149 298.0 +15 30.0 +15 30.0 +150 150.0 +152 304.0 +152 304.0 +153 153.0 +155 155.0 +156 156.0 +157 157.0 +158 158.0 +160 160.0 +162 162.0 +163 163.0 +164 328.0 +164 328.0 +165 330.0 +165 330.0 +166 166.0 +167 501.0 +167 501.0 +167 501.0 +168 168.0 +169 676.0 +169 676.0 +169 676.0 +169 676.0 +17 17.0 +170 170.0 +172 344.0 +172 344.0 +174 348.0 +174 348.0 +175 350.0 +175 350.0 +176 352.0 +176 352.0 +177 177.0 +178 178.0 +179 358.0 +179 358.0 +18 36.0 +18 36.0 +180 180.0 +181 181.0 +183 183.0 +186 186.0 +187 561.0 +187 561.0 +187 561.0 +189 189.0 +19 19.0 +190 190.0 +191 382.0 +191 382.0 +192 192.0 +193 579.0 +193 579.0 +193 579.0 +194 194.0 +195 390.0 +195 390.0 +196 196.0 +197 394.0 +197 394.0 +199 597.0 +199 597.0 +199 597.0 +20 20.0 +200 400.0 +200 400.0 +201 201.0 +202 202.0 +203 406.0 +203 406.0 +205 410.0 +205 410.0 +207 414.0 +207 414.0 +208 624.0 +208 624.0 +208 624.0 +209 418.0 +209 418.0 +213 426.0 +213 426.0 +214 214.0 +216 432.0 +216 432.0 +217 434.0 +217 434.0 +218 218.0 +219 438.0 +219 438.0 +221 442.0 +221 442.0 +222 222.0 +223 446.0 +223 446.0 +224 448.0 +224 448.0 +226 226.0 +228 228.0 +229 458.0 +229 458.0 +230 1150.0 +230 1150.0 +230 1150.0 +230 1150.0 +230 1150.0 +233 466.0 +233 466.0 +235 235.0 +237 474.0 +237 474.0 +238 476.0 +238 476.0 +239 478.0 +239 478.0 +24 48.0 +24 48.0 +241 241.0 +242 484.0 +242 484.0 +244 244.0 +247 247.0 +248 248.0 +249 249.0 +252 252.0 +255 510.0 +255 510.0 +256 512.0 +256 512.0 +257 257.0 +258 258.0 +26 52.0 +26 52.0 +260 260.0 +262 262.0 +263 263.0 +265 530.0 +265 530.0 +266 266.0 +27 27.0 +272 544.0 +272 544.0 +273 819.0 +273 819.0 +273 819.0 +274 274.0 +275 275.0 +277 1108.0 +277 1108.0 +277 1108.0 +277 1108.0 +278 556.0 +278 556.0 +28 28.0 +280 560.0 +280 560.0 +281 562.0 +281 562.0 +282 564.0 +282 564.0 +283 283.0 +284 284.0 +285 285.0 +286 286.0 +287 287.0 +288 576.0 +288 576.0 +289 289.0 +291 291.0 +292 292.0 +296 296.0 +298 894.0 +298 894.0 +298 894.0 +30 30.0 +302 302.0 +305 305.0 +306 306.0 +307 614.0 +307 614.0 +308 308.0 +309 618.0 +309 618.0 +310 310.0 +311 933.0 +311 933.0 +311 933.0 +315 315.0 +316 948.0 +316 948.0 +316 948.0 +317 634.0 +317 634.0 +318 954.0 +318 954.0 +318 954.0 +321 642.0 +321 642.0 +322 644.0 +322 644.0 +323 323.0 +325 650.0 +325 650.0 +327 981.0 +327 981.0 +327 981.0 +33 33.0 +331 662.0 +331 662.0 +332 332.0 +333 666.0 +333 666.0 +335 335.0 +336 336.0 +338 338.0 +339 339.0 +34 34.0 +341 341.0 +342 684.0 +342 684.0 +344 688.0 +344 688.0 +345 345.0 +348 1740.0 +348 1740.0 +348 1740.0 +348 1740.0 +348 1740.0 +35 105.0 +35 105.0 +35 105.0 +351 351.0 +353 706.0 +353 706.0 +356 356.0 +360 360.0 +362 362.0 +364 364.0 +365 365.0 +366 366.0 +367 734.0 +367 734.0 +368 368.0 +369 1107.0 +369 1107.0 +369 1107.0 +37 74.0 +37 74.0 +373 373.0 +374 374.0 +375 375.0 +377 377.0 +378 378.0 +379 379.0 +382 764.0 +382 764.0 +384 1152.0 +384 1152.0 +384 1152.0 +386 386.0 +389 389.0 +392 392.0 +393 393.0 +394 394.0 +395 790.0 +395 790.0 +396 1188.0 +396 1188.0 +396 1188.0 +397 794.0 +397 794.0 +399 798.0 +399 798.0 +4 4.0 +400 400.0 +401 2005.0 +401 2005.0 +401 2005.0 +401 2005.0 +401 2005.0 +402 402.0 +403 1209.0 +403 1209.0 +403 1209.0 +404 808.0 +404 808.0 +406 1624.0 +406 1624.0 +406 1624.0 +406 1624.0 +407 407.0 +409 1227.0 +409 1227.0 +409 1227.0 +41 41.0 +411 411.0 +413 826.0 +413 826.0 +414 828.0 +414 828.0 +417 1251.0 +417 1251.0 +417 1251.0 +418 418.0 +419 419.0 +42 84.0 +42 84.0 +421 421.0 +424 848.0 +424 848.0 +427 427.0 +429 858.0 +429 858.0 +43 43.0 +430 1290.0 +430 1290.0 +430 1290.0 +431 1293.0 +431 1293.0 +431 1293.0 +432 432.0 +435 435.0 +436 436.0 +437 437.0 +438 1314.0 +438 1314.0 +438 1314.0 +439 878.0 +439 878.0 +44 44.0 +443 443.0 +444 444.0 +446 446.0 +448 448.0 +449 449.0 +452 452.0 +453 453.0 +454 1362.0 +454 1362.0 +454 1362.0 +455 455.0 +457 457.0 +458 916.0 +458 916.0 +459 918.0 +459 918.0 +460 460.0 +462 924.0 +462 924.0 +463 926.0 +463 926.0 +466 1398.0 +466 1398.0 +466 1398.0 +467 467.0 +468 1872.0 +468 1872.0 +468 1872.0 +468 1872.0 +469 2345.0 +469 2345.0 +469 2345.0 +469 2345.0 +469 2345.0 +47 47.0 +470 470.0 +472 472.0 +475 475.0 +477 477.0 +478 956.0 +478 956.0 +479 479.0 +480 1440.0 +480 1440.0 +480 1440.0 +481 481.0 +482 482.0 +483 483.0 +484 484.0 +485 485.0 +487 487.0 +489 1956.0 +489 1956.0 +489 1956.0 +489 1956.0 +490 490.0 +491 491.0 +492 984.0 +492 984.0 +493 493.0 +494 494.0 +495 495.0 +496 496.0 +497 497.0 +498 1494.0 +498 1494.0 +498 1494.0 +5 15.0 +5 15.0 +5 15.0 +51 102.0 +51 102.0 +53 53.0 +54 54.0 +57 57.0 +58 116.0 +58 116.0 +64 64.0 +65 65.0 +66 66.0 +67 134.0 +67 134.0 +69 69.0 +70 210.0 +70 210.0 +70 210.0 +72 144.0 +72 144.0 +74 74.0 +76 152.0 +76 152.0 +77 77.0 +78 78.0 +8 8.0 +80 80.0 +82 82.0 +83 166.0 +83 166.0 +84 168.0 +84 168.0 +85 85.0 +86 86.0 +87 87.0 +9 9.0 +90 270.0 +90 270.0 +90 270.0 +92 92.0 +95 190.0 +95 190.0 +96 96.0 +97 194.0 +97 194.0 +98 196.0 +98 196.0 +PREHOOK: query: select * from (SELECT key, sum(key) over(partition by key, value) as c1 from src)r1 where cast(key as int) > 2 +PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### +POSTHOOK: query: select * from (SELECT key, sum(key) over(partition by key, value) as c1 from src)r1 where cast(key as int) > 2 +POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +#### A masked pattern was here #### +10 10.0 +100 200.0 +100 200.0 +103 206.0 +103 206.0 +104 208.0 +104 208.0 +105 105.0 +11 11.0 +111 111.0 +113 226.0 +113 226.0 +114 114.0 +116 116.0 +118 236.0 +118 236.0 +119 357.0 +119 357.0 +119 357.0 +12 24.0 +12 24.0 +120 240.0 +120 240.0 +125 250.0 +125 250.0 +126 126.0 +128 384.0 +128 384.0 +128 384.0 +129 258.0 +129 258.0 +131 131.0 +133 133.0 +134 268.0 +134 268.0 +136 136.0 +137 274.0 +137 274.0 +138 552.0 +138 552.0 +138 552.0 +138 552.0 +143 143.0 +145 145.0 +146 292.0 +146 292.0 +149 298.0 +149 298.0 +15 30.0 +15 30.0 +150 150.0 +152 304.0 +152 304.0 +153 153.0 +155 155.0 +156 156.0 +157 157.0 +158 158.0 +160 160.0 +162 162.0 +163 163.0 +164 328.0 +164 328.0 +165 330.0 +165 330.0 +166 166.0 +167 501.0 +167 501.0 +167 501.0 +168 168.0 +169 676.0 +169 676.0 +169 676.0 +169 676.0 +17 17.0 +170 170.0 +172 344.0 +172 344.0 +174 348.0 +174 348.0 +175 350.0 +175 350.0 +176 352.0 +176 352.0 +177 177.0 +178 178.0 +179 358.0 +179 358.0 +18 36.0 +18 36.0 +180 180.0 +181 181.0 +183 183.0 +186 186.0 +187 561.0 +187 561.0 +187 561.0 +189 189.0 +19 19.0 +190 190.0 +191 382.0 +191 382.0 +192 192.0 +193 579.0 +193 579.0 +193 579.0 +194 194.0 +195 390.0 +195 390.0 +196 196.0 +197 394.0 +197 394.0 +199 597.0 +199 597.0 +199 597.0 +20 20.0 +200 400.0 +200 400.0 +201 201.0 +202 202.0 +203 406.0 +203 406.0 +205 410.0 +205 410.0 +207 414.0 +207 414.0 +208 624.0 +208 624.0 +208 624.0 +209 418.0 +209 418.0 +213 426.0 +213 426.0 +214 214.0 +216 432.0 +216 432.0 +217 434.0 +217 434.0 +218 218.0 +219 438.0 +219 438.0 +221 442.0 +221 442.0 +222 222.0 +223 446.0 +223 446.0 +224 448.0 +224 448.0 +226 226.0 +228 228.0 +229 458.0 +229 458.0 +230 1150.0 +230 1150.0 +230 1150.0 +230 1150.0 +230 1150.0 +233 466.0 +233 466.0 +235 235.0 +237 474.0 +237 474.0 +238 476.0 +238 476.0 +239 478.0 +239 478.0 +24 48.0 +24 48.0 +241 241.0 +242 484.0 +242 484.0 +244 244.0 +247 247.0 +248 248.0 +249 249.0 +252 252.0 +255 510.0 +255 510.0 +256 512.0 +256 512.0 +257 257.0 +258 258.0 +26 52.0 +26 52.0 +260 260.0 +262 262.0 +263 263.0 +265 530.0 +265 530.0 +266 266.0 +27 27.0 +272 544.0 +272 544.0 +273 819.0 +273 819.0 +273 819.0 +274 274.0 +275 275.0 +277 1108.0 +277 1108.0 +277 1108.0 +277 1108.0 +278 556.0 +278 556.0 +28 28.0 +280 560.0 +280 560.0 +281 562.0 +281 562.0 +282 564.0 +282 564.0 +283 283.0 +284 284.0 +285 285.0 +286 286.0 +287 287.0 +288 576.0 +288 576.0 +289 289.0 +291 291.0 +292 292.0 +296 296.0 +298 894.0 +298 894.0 +298 894.0 +30 30.0 +302 302.0 +305 305.0 +306 306.0 +307 614.0 +307 614.0 +308 308.0 +309 618.0 +309 618.0 +310 310.0 +311 933.0 +311 933.0 +311 933.0 +315 315.0 +316 948.0 +316 948.0 +316 948.0 +317 634.0 +317 634.0 +318 954.0 +318 954.0 +318 954.0 +321 642.0 +321 642.0 +322 644.0 +322 644.0 +323 323.0 +325 650.0 +325 650.0 +327 981.0 +327 981.0 +327 981.0 +33 33.0 +331 662.0 +331 662.0 +332 332.0 +333 666.0 +333 666.0 +335 335.0 +336 336.0 +338 338.0 +339 339.0 +34 34.0 +341 341.0 +342 684.0 +342 684.0 +344 688.0 +344 688.0 +345 345.0 +348 1740.0 +348 1740.0 +348 1740.0 +348 1740.0 +348 1740.0 +35 105.0 +35 105.0 +35 105.0 +351 351.0 +353 706.0 +353 706.0 +356 356.0 +360 360.0 +362 362.0 +364 364.0 +365 365.0 +366 366.0 +367 734.0 +367 734.0 +368 368.0 +369 1107.0 +369 1107.0 +369 1107.0 +37 74.0 +37 74.0 +373 373.0 +374 374.0 +375 375.0 +377 377.0 +378 378.0 +379 379.0 +382 764.0 +382 764.0 +384 1152.0 +384 1152.0 +384 1152.0 +386 386.0 +389 389.0 +392 392.0 +393 393.0 +394 394.0 +395 790.0 +395 790.0 +396 1188.0 +396 1188.0 +396 1188.0 +397 794.0 +397 794.0 +399 798.0 +399 798.0 +4 4.0 +400 400.0 +401 2005.0 +401 2005.0 +401 2005.0 +401 2005.0 +401 2005.0 +402 402.0 +403 1209.0 +403 1209.0 +403 1209.0 +404 808.0 +404 808.0 +406 1624.0 +406 1624.0 +406 1624.0 +406 1624.0 +407 407.0 +409 1227.0 +409 1227.0 +409 1227.0 +41 41.0 +411 411.0 +413 826.0 +413 826.0 +414 828.0 +414 828.0 +417 1251.0 +417 1251.0 +417 1251.0 +418 418.0 +419 419.0 +42 84.0 +42 84.0 +421 421.0 +424 848.0 +424 848.0 +427 427.0 +429 858.0 +429 858.0 +43 43.0 +430 1290.0 +430 1290.0 +430 1290.0 +431 1293.0 +431 1293.0 +431 1293.0 +432 432.0 +435 435.0 +436 436.0 +437 437.0 +438 1314.0 +438 1314.0 +438 1314.0 +439 878.0 +439 878.0 +44 44.0 +443 443.0 +444 444.0 +446 446.0 +448 448.0 +449 449.0 +452 452.0 +453 453.0 +454 1362.0 +454 1362.0 +454 1362.0 +455 455.0 +457 457.0 +458 916.0 +458 916.0 +459 918.0 +459 918.0 +460 460.0 +462 924.0 +462 924.0 +463 926.0 +463 926.0 +466 1398.0 +466 1398.0 +466 1398.0 +467 467.0 +468 1872.0 +468 1872.0 +468 1872.0 +468 1872.0 +469 2345.0 +469 2345.0 +469 2345.0 +469 2345.0 +469 2345.0 +47 47.0 +470 470.0 +472 472.0 +475 475.0 +477 477.0 +478 956.0 +478 956.0 +479 479.0 +480 1440.0 +480 1440.0 +480 1440.0 +481 481.0 +482 482.0 +483 483.0 +484 484.0 +485 485.0 +487 487.0 +489 1956.0 +489 1956.0 +489 1956.0 +489 1956.0 +490 490.0 +491 491.0 +492 984.0 +492 984.0 +493 493.0 +494 494.0 +495 495.0 +496 496.0 +497 497.0 +498 1494.0 +498 1494.0 +498 1494.0 +5 15.0 +5 15.0 +5 15.0 +51 102.0 +51 102.0 +53 53.0 +54 54.0 +57 57.0 +58 116.0 +58 116.0 +64 64.0 +65 65.0 +66 66.0 +67 134.0 +67 134.0 +69 69.0 +70 210.0 +70 210.0 +70 210.0 +72 144.0 +72 144.0 +74 74.0 +76 152.0 +76 152.0 +77 77.0 +78 78.0 +8 8.0 +80 80.0 +82 82.0 +83 166.0 +83 166.0 +84 168.0 +84 168.0 +85 85.0 +86 86.0 +87 87.0 +9 9.0 +90 270.0 +90 270.0 +90 270.0 +92 92.0 +95 190.0 +95 190.0 +96 96.0 +97 194.0 +97 194.0 +98 196.0 +98 196.0 +PREHOOK: query: select * from (SELECT key, sum(key) over(partition by key, value) as c1 from src)r1 where (cast(key as int) + 1) > 2 +PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### +POSTHOOK: query: select * from (SELECT key, sum(key) over(partition by key, value) as c1 from src)r1 where (cast(key as int) + 1) > 2 +POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +#### A masked pattern was here #### +10 10.0 +100 200.0 +100 200.0 +103 206.0 +103 206.0 +104 208.0 +104 208.0 +105 105.0 +11 11.0 +111 111.0 +113 226.0 +113 226.0 +114 114.0 +116 116.0 +118 236.0 +118 236.0 +119 357.0 +119 357.0 +119 357.0 +12 24.0 +12 24.0 +120 240.0 +120 240.0 +125 250.0 +125 250.0 +126 126.0 +128 384.0 +128 384.0 +128 384.0 +129 258.0 +129 258.0 +131 131.0 +133 133.0 +134 268.0 +134 268.0 +136 136.0 +137 274.0 +137 274.0 +138 552.0 +138 552.0 +138 552.0 +138 552.0 +143 143.0 +145 145.0 +146 292.0 +146 292.0 +149 298.0 +149 298.0 +15 30.0 +15 30.0 +150 150.0 +152 304.0 +152 304.0 +153 153.0 +155 155.0 +156 156.0 +157 157.0 +158 158.0 +160 160.0 +162 162.0 +163 163.0 +164 328.0 +164 328.0 +165 330.0 +165 330.0 +166 166.0 +167 501.0 +167 501.0 +167 501.0 +168 168.0 +169 676.0 +169 676.0 +169 676.0 +169 676.0 +17 17.0 +170 170.0 +172 344.0 +172 344.0 +174 348.0 +174 348.0 +175 350.0 +175 350.0 +176 352.0 +176 352.0 +177 177.0 +178 178.0 +179 358.0 +179 358.0 +18 36.0 +18 36.0 +180 180.0 +181 181.0 +183 183.0 +186 186.0 +187 561.0 +187 561.0 +187 561.0 +189 189.0 +19 19.0 +190 190.0 +191 382.0 +191 382.0 +192 192.0 +193 579.0 +193 579.0 +193 579.0 +194 194.0 +195 390.0 +195 390.0 +196 196.0 +197 394.0 +197 394.0 +199 597.0 +199 597.0 +199 597.0 +2 2.0 +20 20.0 +200 400.0 +200 400.0 +201 201.0 +202 202.0 +203 406.0 +203 406.0 +205 410.0 +205 410.0 +207 414.0 +207 414.0 +208 624.0 +208 624.0 +208 624.0 +209 418.0 +209 418.0 +213 426.0 +213 426.0 +214 214.0 +216 432.0 +216 432.0 +217 434.0 +217 434.0 +218 218.0 +219 438.0 +219 438.0 +221 442.0 +221 442.0 +222 222.0 +223 446.0 +223 446.0 +224 448.0 +224 448.0 +226 226.0 +228 228.0 +229 458.0 +229 458.0 +230 1150.0 +230 1150.0 +230 1150.0 +230 1150.0 +230 1150.0 +233 466.0 +233 466.0 +235 235.0 +237 474.0 +237 474.0 +238 476.0 +238 476.0 +239 478.0 +239 478.0 +24 48.0 +24 48.0 +241 241.0 +242 484.0 +242 484.0 +244 244.0 +247 247.0 +248 248.0 +249 249.0 +252 252.0 +255 510.0 +255 510.0 +256 512.0 +256 512.0 +257 257.0 +258 258.0 +26 52.0 +26 52.0 +260 260.0 +262 262.0 +263 263.0 +265 530.0 +265 530.0 +266 266.0 +27 27.0 +272 544.0 +272 544.0 +273 819.0 +273 819.0 +273 819.0 +274 274.0 +275 275.0 +277 1108.0 +277 1108.0 +277 1108.0 +277 1108.0 +278 556.0 +278 556.0 +28 28.0 +280 560.0 +280 560.0 +281 562.0 +281 562.0 +282 564.0 +282 564.0 +283 283.0 +284 284.0 +285 285.0 +286 286.0 +287 287.0 +288 576.0 +288 576.0 +289 289.0 +291 291.0 +292 292.0 +296 296.0 +298 894.0 +298 894.0 +298 894.0 +30 30.0 +302 302.0 +305 305.0 +306 306.0 +307 614.0 +307 614.0 +308 308.0 +309 618.0 +309 618.0 +310 310.0 +311 933.0 +311 933.0 +311 933.0 +315 315.0 +316 948.0 +316 948.0 +316 948.0 +317 634.0 +317 634.0 +318 954.0 +318 954.0 +318 954.0 +321 642.0 +321 642.0 +322 644.0 +322 644.0 +323 323.0 +325 650.0 +325 650.0 +327 981.0 +327 981.0 +327 981.0 +33 33.0 +331 662.0 +331 662.0 +332 332.0 +333 666.0 +333 666.0 +335 335.0 +336 336.0 +338 338.0 +339 339.0 +34 34.0 +341 341.0 +342 684.0 +342 684.0 +344 688.0 +344 688.0 +345 345.0 +348 1740.0 +348 1740.0 +348 1740.0 +348 1740.0 +348 1740.0 +35 105.0 +35 105.0 +35 105.0 +351 351.0 +353 706.0 +353 706.0 +356 356.0 +360 360.0 +362 362.0 +364 364.0 +365 365.0 +366 366.0 +367 734.0 +367 734.0 +368 368.0 +369 1107.0 +369 1107.0 +369 1107.0 +37 74.0 +37 74.0 +373 373.0 +374 374.0 +375 375.0 +377 377.0 +378 378.0 +379 379.0 +382 764.0 +382 764.0 +384 1152.0 +384 1152.0 +384 1152.0 +386 386.0 +389 389.0 +392 392.0 +393 393.0 +394 394.0 +395 790.0 +395 790.0 +396 1188.0 +396 1188.0 +396 1188.0 +397 794.0 +397 794.0 +399 798.0 +399 798.0 +4 4.0 +400 400.0 +401 2005.0 +401 2005.0 +401 2005.0 +401 2005.0 +401 2005.0 +402 402.0 +403 1209.0 +403 1209.0 +403 1209.0 +404 808.0 +404 808.0 +406 1624.0 +406 1624.0 +406 1624.0 +406 1624.0 +407 407.0 +409 1227.0 +409 1227.0 +409 1227.0 +41 41.0 +411 411.0 +413 826.0 +413 826.0 +414 828.0 +414 828.0 +417 1251.0 +417 1251.0 +417 1251.0 +418 418.0 +419 419.0 +42 84.0 +42 84.0 +421 421.0 +424 848.0 +424 848.0 +427 427.0 +429 858.0 +429 858.0 +43 43.0 +430 1290.0 +430 1290.0 +430 1290.0 +431 1293.0 +431 1293.0 +431 1293.0 +432 432.0 +435 435.0 +436 436.0 +437 437.0 +438 1314.0 +438 1314.0 +438 1314.0 +439 878.0 +439 878.0 +44 44.0 +443 443.0 +444 444.0 +446 446.0 +448 448.0 +449 449.0 +452 452.0 +453 453.0 +454 1362.0 +454 1362.0 +454 1362.0 +455 455.0 +457 457.0 +458 916.0 +458 916.0 +459 918.0 +459 918.0 +460 460.0 +462 924.0 +462 924.0 +463 926.0 +463 926.0 +466 1398.0 +466 1398.0 +466 1398.0 +467 467.0 +468 1872.0 +468 1872.0 +468 1872.0 +468 1872.0 +469 2345.0 +469 2345.0 +469 2345.0 +469 2345.0 +469 2345.0 +47 47.0 +470 470.0 +472 472.0 +475 475.0 +477 477.0 +478 956.0 +478 956.0 +479 479.0 +480 1440.0 +480 1440.0 +480 1440.0 +481 481.0 +482 482.0 +483 483.0 +484 484.0 +485 485.0 +487 487.0 +489 1956.0 +489 1956.0 +489 1956.0 +489 1956.0 +490 490.0 +491 491.0 +492 984.0 +492 984.0 +493 493.0 +494 494.0 +495 495.0 +496 496.0 +497 497.0 +498 1494.0 +498 1494.0 +498 1494.0 +5 15.0 +5 15.0 +5 15.0 +51 102.0 +51 102.0 +53 53.0 +54 54.0 +57 57.0 +58 116.0 +58 116.0 +64 64.0 +65 65.0 +66 66.0 +67 134.0 +67 134.0 +69 69.0 +70 210.0 +70 210.0 +70 210.0 +72 144.0 +72 144.0 +74 74.0 +76 152.0 +76 152.0 +77 77.0 +78 78.0 +8 8.0 +80 80.0 +82 82.0 +83 166.0 +83 166.0 +84 168.0 +84 168.0 +85 85.0 +86 86.0 +87 87.0 +9 9.0 +90 270.0 +90 270.0 +90 270.0 +92 92.0 +95 190.0 +95 190.0 +96 96.0 +97 194.0 +97 194.0 +98 196.0 +98 196.0 +PREHOOK: query: select * from (SELECT (cast(key as int))+2 as key, sum(key) over(partition by key, value) as c1 from src)r1 where (cast(key as int) + 1) > 2 +PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### +POSTHOOK: query: select * from (SELECT (cast(key as int))+2 as key, sum(key) over(partition by key, value) as c1 from src)r1 where (cast(key as int) + 1) > 2 +POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +#### A masked pattern was here #### +2 0.0 +2 0.0 +2 0.0 +12 10.0 +102 200.0 +102 200.0 +105 206.0 +105 206.0 +106 208.0 +106 208.0 +107 105.0 +13 11.0 +113 111.0 +115 226.0 +115 226.0 +116 114.0 +118 116.0 +120 236.0 +120 236.0 +121 357.0 +121 357.0 +121 357.0 +14 24.0 +14 24.0 +122 240.0 +122 240.0 +127 250.0 +127 250.0 +128 126.0 +130 384.0 +130 384.0 +130 384.0 +131 258.0 +131 258.0 +133 131.0 +135 133.0 +136 268.0 +136 268.0 +138 136.0 +139 274.0 +139 274.0 +140 552.0 +140 552.0 +140 552.0 +140 552.0 +145 143.0 +147 145.0 +148 292.0 +148 292.0 +151 298.0 +151 298.0 +17 30.0 +17 30.0 +152 150.0 +154 304.0 +154 304.0 +155 153.0 +157 155.0 +158 156.0 +159 157.0 +160 158.0 +162 160.0 +164 162.0 +165 163.0 +166 328.0 +166 328.0 +167 330.0 +167 330.0 +168 166.0 +169 501.0 +169 501.0 +169 501.0 +170 168.0 +171 676.0 +171 676.0 +171 676.0 +171 676.0 +19 17.0 +172 170.0 +174 344.0 +174 344.0 +176 348.0 +176 348.0 +177 350.0 +177 350.0 +178 352.0 +178 352.0 +179 177.0 +180 178.0 +181 358.0 +181 358.0 +20 36.0 +20 36.0 +182 180.0 +183 181.0 +185 183.0 +188 186.0 +189 561.0 +189 561.0 +189 561.0 +191 189.0 +21 19.0 +192 190.0 +193 382.0 +193 382.0 +194 192.0 +195 579.0 +195 579.0 +195 579.0 +196 194.0 +197 390.0 +197 390.0 +198 196.0 +199 394.0 +199 394.0 +201 597.0 +201 597.0 +201 597.0 +4 2.0 +22 20.0 +202 400.0 +202 400.0 +203 201.0 +204 202.0 +205 406.0 +205 406.0 +207 410.0 +207 410.0 +209 414.0 +209 414.0 +210 624.0 +210 624.0 +210 624.0 +211 418.0 +211 418.0 +215 426.0 +215 426.0 +216 214.0 +218 432.0 +218 432.0 +219 434.0 +219 434.0 +220 218.0 +221 438.0 +221 438.0 +223 442.0 +223 442.0 +224 222.0 +225 446.0 +225 446.0 +226 448.0 +226 448.0 +228 226.0 +230 228.0 +231 458.0 +231 458.0 +232 1150.0 +232 1150.0 +232 1150.0 +232 1150.0 +232 1150.0 +235 466.0 +235 466.0 +237 235.0 +239 474.0 +239 474.0 +240 476.0 +240 476.0 +241 478.0 +241 478.0 +26 48.0 +26 48.0 +243 241.0 +244 484.0 +244 484.0 +246 244.0 +249 247.0 +250 248.0 +251 249.0 +254 252.0 +257 510.0 +257 510.0 +258 512.0 +258 512.0 +259 257.0 +260 258.0 +28 52.0 +28 52.0 +262 260.0 +264 262.0 +265 263.0 +267 530.0 +267 530.0 +268 266.0 +29 27.0 +274 544.0 +274 544.0 +275 819.0 +275 819.0 +275 819.0 +276 274.0 +277 275.0 +279 1108.0 +279 1108.0 +279 1108.0 +279 1108.0 +280 556.0 +280 556.0 +30 28.0 +282 560.0 +282 560.0 +283 562.0 +283 562.0 +284 564.0 +284 564.0 +285 283.0 +286 284.0 +287 285.0 +288 286.0 +289 287.0 +290 576.0 +290 576.0 +291 289.0 +293 291.0 +294 292.0 +298 296.0 +300 894.0 +300 894.0 +300 894.0 +32 30.0 +304 302.0 +307 305.0 +308 306.0 +309 614.0 +309 614.0 +310 308.0 +311 618.0 +311 618.0 +312 310.0 +313 933.0 +313 933.0 +313 933.0 +317 315.0 +318 948.0 +318 948.0 +318 948.0 +319 634.0 +319 634.0 +320 954.0 +320 954.0 +320 954.0 +323 642.0 +323 642.0 +324 644.0 +324 644.0 +325 323.0 +327 650.0 +327 650.0 +329 981.0 +329 981.0 +329 981.0 +35 33.0 +333 662.0 +333 662.0 +334 332.0 +335 666.0 +335 666.0 +337 335.0 +338 336.0 +340 338.0 +341 339.0 +36 34.0 +343 341.0 +344 684.0 +344 684.0 +346 688.0 +346 688.0 +347 345.0 +350 1740.0 +350 1740.0 +350 1740.0 +350 1740.0 +350 1740.0 +37 105.0 +37 105.0 +37 105.0 +353 351.0 +355 706.0 +355 706.0 +358 356.0 +362 360.0 +364 362.0 +366 364.0 +367 365.0 +368 366.0 +369 734.0 +369 734.0 +370 368.0 +371 1107.0 +371 1107.0 +371 1107.0 +39 74.0 +39 74.0 +375 373.0 +376 374.0 +377 375.0 +379 377.0 +380 378.0 +381 379.0 +384 764.0 +384 764.0 +386 1152.0 +386 1152.0 +386 1152.0 +388 386.0 +391 389.0 +394 392.0 +395 393.0 +396 394.0 +397 790.0 +397 790.0 +398 1188.0 +398 1188.0 +398 1188.0 +399 794.0 +399 794.0 +401 798.0 +401 798.0 +6 4.0 +402 400.0 +403 2005.0 +403 2005.0 +403 2005.0 +403 2005.0 +403 2005.0 +404 402.0 +405 1209.0 +405 1209.0 +405 1209.0 +406 808.0 +406 808.0 +408 1624.0 +408 1624.0 +408 1624.0 +408 1624.0 +409 407.0 +411 1227.0 +411 1227.0 +411 1227.0 +43 41.0 +413 411.0 +415 826.0 +415 826.0 +416 828.0 +416 828.0 +419 1251.0 +419 1251.0 +419 1251.0 +420 418.0 +421 419.0 +44 84.0 +44 84.0 +423 421.0 +426 848.0 +426 848.0 +429 427.0 +431 858.0 +431 858.0 +45 43.0 +432 1290.0 +432 1290.0 +432 1290.0 +433 1293.0 +433 1293.0 +433 1293.0 +434 432.0 +437 435.0 +438 436.0 +439 437.0 +440 1314.0 +440 1314.0 +440 1314.0 +441 878.0 +441 878.0 +46 44.0 +445 443.0 +446 444.0 +448 446.0 +450 448.0 +451 449.0 +454 452.0 +455 453.0 +456 1362.0 +456 1362.0 +456 1362.0 +457 455.0 +459 457.0 +460 916.0 +460 916.0 +461 918.0 +461 918.0 +462 460.0 +464 924.0 +464 924.0 +465 926.0 +465 926.0 +468 1398.0 +468 1398.0 +468 1398.0 +469 467.0 +470 1872.0 +470 1872.0 +470 1872.0 +470 1872.0 +471 2345.0 +471 2345.0 +471 2345.0 +471 2345.0 +471 2345.0 +49 47.0 +472 470.0 +474 472.0 +477 475.0 +479 477.0 +480 956.0 +480 956.0 +481 479.0 +482 1440.0 +482 1440.0 +482 1440.0 +483 481.0 +484 482.0 +485 483.0 +486 484.0 +487 485.0 +489 487.0 +491 1956.0 +491 1956.0 +491 1956.0 +491 1956.0 +492 490.0 +493 491.0 +494 984.0 +494 984.0 +495 493.0 +496 494.0 +497 495.0 +498 496.0 +499 497.0 +500 1494.0 +500 1494.0 +500 1494.0 +7 15.0 +7 15.0 +7 15.0 +53 102.0 +53 102.0 +55 53.0 +56 54.0 +59 57.0 +60 116.0 +60 116.0 +66 64.0 +67 65.0 +68 66.0 +69 134.0 +69 134.0 +71 69.0 +72 210.0 +72 210.0 +72 210.0 +74 144.0 +74 144.0 +76 74.0 +78 152.0 +78 152.0 +79 77.0 +80 78.0 +10 8.0 +82 80.0 +84 82.0 +85 166.0 +85 166.0 +86 168.0 +86 168.0 +87 85.0 +88 86.0 +89 87.0 +11 9.0 +92 270.0 +92 270.0 +92 270.0 +94 92.0 +97 190.0 +97 190.0 +98 96.0 +99 194.0 +99 194.0 +100 196.0 +100 196.0 +PREHOOK: query: -- Test PPD through Windowing where predicate is a subset of partition keys, multiple windows are involved and UDAF is same +select * from (SELECT key, sum(key) over(partition by key,value) as c1, sum(key) over(partition by key) as c2 from src)r1 where key > '2' +PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### +POSTHOOK: query: -- Test PPD through Windowing where predicate is a subset of partition keys, multiple windows are involved and UDAF is same +select * from (SELECT key, sum(key) over(partition by key,value) as c1, sum(key) over(partition by key) as c2 from src)r1 where key > '2' +POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +#### A masked pattern was here #### +20 20.0 20.0 +200 400.0 400.0 +200 400.0 400.0 +201 201.0 201.0 +202 202.0 202.0 +203 406.0 406.0 +203 406.0 406.0 +205 410.0 410.0 +205 410.0 410.0 +207 414.0 414.0 +207 414.0 414.0 +208 624.0 624.0 +208 624.0 624.0 +208 624.0 624.0 +209 418.0 418.0 +209 418.0 418.0 +213 426.0 426.0 +213 426.0 426.0 +214 214.0 214.0 +216 432.0 432.0 +216 432.0 432.0 +217 434.0 434.0 +217 434.0 434.0 +218 218.0 218.0 +219 438.0 438.0 +219 438.0 438.0 +221 442.0 442.0 +221 442.0 442.0 +222 222.0 222.0 +223 446.0 446.0 +223 446.0 446.0 +224 448.0 448.0 +224 448.0 448.0 +226 226.0 226.0 +228 228.0 228.0 +229 458.0 458.0 +229 458.0 458.0 +230 1150.0 1150.0 +230 1150.0 1150.0 +230 1150.0 1150.0 +230 1150.0 1150.0 +230 1150.0 1150.0 +233 466.0 466.0 +233 466.0 466.0 +235 235.0 235.0 +237 474.0 474.0 +237 474.0 474.0 +238 476.0 476.0 +238 476.0 476.0 +239 478.0 478.0 +239 478.0 478.0 +24 48.0 48.0 +24 48.0 48.0 +241 241.0 241.0 +242 484.0 484.0 +242 484.0 484.0 +244 244.0 244.0 +247 247.0 247.0 +248 248.0 248.0 +249 249.0 249.0 +252 252.0 252.0 +255 510.0 510.0 +255 510.0 510.0 +256 512.0 512.0 +256 512.0 512.0 +257 257.0 257.0 +258 258.0 258.0 +26 52.0 52.0 +26 52.0 52.0 +260 260.0 260.0 +262 262.0 262.0 +263 263.0 263.0 +265 530.0 530.0 +265 530.0 530.0 +266 266.0 266.0 +27 27.0 27.0 +272 544.0 544.0 +272 544.0 544.0 +273 819.0 819.0 +273 819.0 819.0 +273 819.0 819.0 +274 274.0 274.0 +275 275.0 275.0 +277 1108.0 1108.0 +277 1108.0 1108.0 +277 1108.0 1108.0 +277 1108.0 1108.0 +278 556.0 556.0 +278 556.0 556.0 +28 28.0 28.0 +280 560.0 560.0 +280 560.0 560.0 +281 562.0 562.0 +281 562.0 562.0 +282 564.0 564.0 +282 564.0 564.0 +283 283.0 283.0 +284 284.0 284.0 +285 285.0 285.0 +286 286.0 286.0 +287 287.0 287.0 +288 576.0 576.0 +288 576.0 576.0 +289 289.0 289.0 +291 291.0 291.0 +292 292.0 292.0 +296 296.0 296.0 +298 894.0 894.0 +298 894.0 894.0 +298 894.0 894.0 +30 30.0 30.0 +302 302.0 302.0 +305 305.0 305.0 +306 306.0 306.0 +307 614.0 614.0 +307 614.0 614.0 +308 308.0 308.0 +309 618.0 618.0 +309 618.0 618.0 +310 310.0 310.0 +311 933.0 933.0 +311 933.0 933.0 +311 933.0 933.0 +315 315.0 315.0 +316 948.0 948.0 +316 948.0 948.0 +316 948.0 948.0 +317 634.0 634.0 +317 634.0 634.0 +318 954.0 954.0 +318 954.0 954.0 +318 954.0 954.0 +321 642.0 642.0 +321 642.0 642.0 +322 644.0 644.0 +322 644.0 644.0 +323 323.0 323.0 +325 650.0 650.0 +325 650.0 650.0 +327 981.0 981.0 +327 981.0 981.0 +327 981.0 981.0 +33 33.0 33.0 +331 662.0 662.0 +331 662.0 662.0 +332 332.0 332.0 +333 666.0 666.0 +333 666.0 666.0 +335 335.0 335.0 +336 336.0 336.0 +338 338.0 338.0 +339 339.0 339.0 +34 34.0 34.0 +341 341.0 341.0 +342 684.0 684.0 +342 684.0 684.0 +344 688.0 688.0 +344 688.0 688.0 +345 345.0 345.0 +348 1740.0 1740.0 +348 1740.0 1740.0 +348 1740.0 1740.0 +348 1740.0 1740.0 +348 1740.0 1740.0 +35 105.0 105.0 +35 105.0 105.0 +35 105.0 105.0 +351 351.0 351.0 +353 706.0 706.0 +353 706.0 706.0 +356 356.0 356.0 +360 360.0 360.0 +362 362.0 362.0 +364 364.0 364.0 +365 365.0 365.0 +366 366.0 366.0 +367 734.0 734.0 +367 734.0 734.0 +368 368.0 368.0 +369 1107.0 1107.0 +369 1107.0 1107.0 +369 1107.0 1107.0 +37 74.0 74.0 +37 74.0 74.0 +373 373.0 373.0 +374 374.0 374.0 +375 375.0 375.0 +377 377.0 377.0 +378 378.0 378.0 +379 379.0 379.0 +382 764.0 764.0 +382 764.0 764.0 +384 1152.0 1152.0 +384 1152.0 1152.0 +384 1152.0 1152.0 +386 386.0 386.0 +389 389.0 389.0 +392 392.0 392.0 +393 393.0 393.0 +394 394.0 394.0 +395 790.0 790.0 +395 790.0 790.0 +396 1188.0 1188.0 +396 1188.0 1188.0 +396 1188.0 1188.0 +397 794.0 794.0 +397 794.0 794.0 +399 798.0 798.0 +399 798.0 798.0 +4 4.0 4.0 +400 400.0 400.0 +401 2005.0 2005.0 +401 2005.0 2005.0 +401 2005.0 2005.0 +401 2005.0 2005.0 +401 2005.0 2005.0 +402 402.0 402.0 +403 1209.0 1209.0 +403 1209.0 1209.0 +403 1209.0 1209.0 +404 808.0 808.0 +404 808.0 808.0 +406 1624.0 1624.0 +406 1624.0 1624.0 +406 1624.0 1624.0 +406 1624.0 1624.0 +407 407.0 407.0 +409 1227.0 1227.0 +409 1227.0 1227.0 +409 1227.0 1227.0 +41 41.0 41.0 +411 411.0 411.0 +413 826.0 826.0 +413 826.0 826.0 +414 828.0 828.0 +414 828.0 828.0 +417 1251.0 1251.0 +417 1251.0 1251.0 +417 1251.0 1251.0 +418 418.0 418.0 +419 419.0 419.0 +42 84.0 84.0 +42 84.0 84.0 +421 421.0 421.0 +424 848.0 848.0 +424 848.0 848.0 +427 427.0 427.0 +429 858.0 858.0 +429 858.0 858.0 +43 43.0 43.0 +430 1290.0 1290.0 +430 1290.0 1290.0 +430 1290.0 1290.0 +431 1293.0 1293.0 +431 1293.0 1293.0 +431 1293.0 1293.0 +432 432.0 432.0 +435 435.0 435.0 +436 436.0 436.0 +437 437.0 437.0 +438 1314.0 1314.0 +438 1314.0 1314.0 +438 1314.0 1314.0 +439 878.0 878.0 +439 878.0 878.0 +44 44.0 44.0 +443 443.0 443.0 +444 444.0 444.0 +446 446.0 446.0 +448 448.0 448.0 +449 449.0 449.0 +452 452.0 452.0 +453 453.0 453.0 +454 1362.0 1362.0 +454 1362.0 1362.0 +454 1362.0 1362.0 +455 455.0 455.0 +457 457.0 457.0 +458 916.0 916.0 +458 916.0 916.0 +459 918.0 918.0 +459 918.0 918.0 +460 460.0 460.0 +462 924.0 924.0 +462 924.0 924.0 +463 926.0 926.0 +463 926.0 926.0 +466 1398.0 1398.0 +466 1398.0 1398.0 +466 1398.0 1398.0 +467 467.0 467.0 +468 1872.0 1872.0 +468 1872.0 1872.0 +468 1872.0 1872.0 +468 1872.0 1872.0 +469 2345.0 2345.0 +469 2345.0 2345.0 +469 2345.0 2345.0 +469 2345.0 2345.0 +469 2345.0 2345.0 +47 47.0 47.0 +470 470.0 470.0 +472 472.0 472.0 +475 475.0 475.0 +477 477.0 477.0 +478 956.0 956.0 +478 956.0 956.0 +479 479.0 479.0 +480 1440.0 1440.0 +480 1440.0 1440.0 +480 1440.0 1440.0 +481 481.0 481.0 +482 482.0 482.0 +483 483.0 483.0 +484 484.0 484.0 +485 485.0 485.0 +487 487.0 487.0 +489 1956.0 1956.0 +489 1956.0 1956.0 +489 1956.0 1956.0 +489 1956.0 1956.0 +490 490.0 490.0 +491 491.0 491.0 +492 984.0 984.0 +492 984.0 984.0 +493 493.0 493.0 +494 494.0 494.0 +495 495.0 495.0 +496 496.0 496.0 +497 497.0 497.0 +498 1494.0 1494.0 +498 1494.0 1494.0 +498 1494.0 1494.0 +5 15.0 15.0 +5 15.0 15.0 +5 15.0 15.0 +51 102.0 102.0 +51 102.0 102.0 +53 53.0 53.0 +54 54.0 54.0 +57 57.0 57.0 +58 116.0 116.0 +58 116.0 116.0 +64 64.0 64.0 +65 65.0 65.0 +66 66.0 66.0 +67 134.0 134.0 +67 134.0 134.0 +69 69.0 69.0 +70 210.0 210.0 +70 210.0 210.0 +70 210.0 210.0 +72 144.0 144.0 +72 144.0 144.0 +74 74.0 74.0 +76 152.0 152.0 +76 152.0 152.0 +77 77.0 77.0 +78 78.0 78.0 +8 8.0 8.0 +80 80.0 80.0 +82 82.0 82.0 +83 166.0 166.0 +83 166.0 166.0 +84 168.0 168.0 +84 168.0 168.0 +85 85.0 85.0 +86 86.0 86.0 +87 87.0 87.0 +9 9.0 9.0 +90 270.0 270.0 +90 270.0 270.0 +90 270.0 270.0 +92 92.0 92.0 +95 190.0 190.0 +95 190.0 190.0 +96 96.0 96.0 +97 194.0 194.0 +97 194.0 194.0 +98 196.0 196.0 +98 196.0 196.0 +PREHOOK: query: select * from (SELECT key, sum(key) over(partition by key,value) as c1, sum(key) over(partition by key) as c2 from src)r1 where key > 2 +PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### +POSTHOOK: query: select * from (SELECT key, sum(key) over(partition by key,value) as c1, sum(key) over(partition by key) as c2 from src)r1 where key > 2 +POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +#### A masked pattern was here #### +10 10.0 10.0 +100 200.0 200.0 +100 200.0 200.0 +103 206.0 206.0 +103 206.0 206.0 +104 208.0 208.0 +104 208.0 208.0 +105 105.0 105.0 +11 11.0 11.0 +111 111.0 111.0 +113 226.0 226.0 +113 226.0 226.0 +114 114.0 114.0 +116 116.0 116.0 +118 236.0 236.0 +118 236.0 236.0 +119 357.0 357.0 +119 357.0 357.0 +119 357.0 357.0 +12 24.0 24.0 +12 24.0 24.0 +120 240.0 240.0 +120 240.0 240.0 +125 250.0 250.0 +125 250.0 250.0 +126 126.0 126.0 +128 384.0 384.0 +128 384.0 384.0 +128 384.0 384.0 +129 258.0 258.0 +129 258.0 258.0 +131 131.0 131.0 +133 133.0 133.0 +134 268.0 268.0 +134 268.0 268.0 +136 136.0 136.0 +137 274.0 274.0 +137 274.0 274.0 +138 552.0 552.0 +138 552.0 552.0 +138 552.0 552.0 +138 552.0 552.0 +143 143.0 143.0 +145 145.0 145.0 +146 292.0 292.0 +146 292.0 292.0 +149 298.0 298.0 +149 298.0 298.0 +15 30.0 30.0 +15 30.0 30.0 +150 150.0 150.0 +152 304.0 304.0 +152 304.0 304.0 +153 153.0 153.0 +155 155.0 155.0 +156 156.0 156.0 +157 157.0 157.0 +158 158.0 158.0 +160 160.0 160.0 +162 162.0 162.0 +163 163.0 163.0 +164 328.0 328.0 +164 328.0 328.0 +165 330.0 330.0 +165 330.0 330.0 +166 166.0 166.0 +167 501.0 501.0 +167 501.0 501.0 +167 501.0 501.0 +168 168.0 168.0 +169 676.0 676.0 +169 676.0 676.0 +169 676.0 676.0 +169 676.0 676.0 +17 17.0 17.0 +170 170.0 170.0 +172 344.0 344.0 +172 344.0 344.0 +174 348.0 348.0 +174 348.0 348.0 +175 350.0 350.0 +175 350.0 350.0 +176 352.0 352.0 +176 352.0 352.0 +177 177.0 177.0 +178 178.0 178.0 +179 358.0 358.0 +179 358.0 358.0 +18 36.0 36.0 +18 36.0 36.0 +180 180.0 180.0 +181 181.0 181.0 +183 183.0 183.0 +186 186.0 186.0 +187 561.0 561.0 +187 561.0 561.0 +187 561.0 561.0 +189 189.0 189.0 +19 19.0 19.0 +190 190.0 190.0 +191 382.0 382.0 +191 382.0 382.0 +192 192.0 192.0 +193 579.0 579.0 +193 579.0 579.0 +193 579.0 579.0 +194 194.0 194.0 +195 390.0 390.0 +195 390.0 390.0 +196 196.0 196.0 +197 394.0 394.0 +197 394.0 394.0 +199 597.0 597.0 +199 597.0 597.0 +199 597.0 597.0 +20 20.0 20.0 +200 400.0 400.0 +200 400.0 400.0 +201 201.0 201.0 +202 202.0 202.0 +203 406.0 406.0 +203 406.0 406.0 +205 410.0 410.0 +205 410.0 410.0 +207 414.0 414.0 +207 414.0 414.0 +208 624.0 624.0 +208 624.0 624.0 +208 624.0 624.0 +209 418.0 418.0 +209 418.0 418.0 +213 426.0 426.0 +213 426.0 426.0 +214 214.0 214.0 +216 432.0 432.0 +216 432.0 432.0 +217 434.0 434.0 +217 434.0 434.0 +218 218.0 218.0 +219 438.0 438.0 +219 438.0 438.0 +221 442.0 442.0 +221 442.0 442.0 +222 222.0 222.0 +223 446.0 446.0 +223 446.0 446.0 +224 448.0 448.0 +224 448.0 448.0 +226 226.0 226.0 +228 228.0 228.0 +229 458.0 458.0 +229 458.0 458.0 +230 1150.0 1150.0 +230 1150.0 1150.0 +230 1150.0 1150.0 +230 1150.0 1150.0 +230 1150.0 1150.0 +233 466.0 466.0 +233 466.0 466.0 +235 235.0 235.0 +237 474.0 474.0 +237 474.0 474.0 +238 476.0 476.0 +238 476.0 476.0 +239 478.0 478.0 +239 478.0 478.0 +24 48.0 48.0 +24 48.0 48.0 +241 241.0 241.0 +242 484.0 484.0 +242 484.0 484.0 +244 244.0 244.0 +247 247.0 247.0 +248 248.0 248.0 +249 249.0 249.0 +252 252.0 252.0 +255 510.0 510.0 +255 510.0 510.0 +256 512.0 512.0 +256 512.0 512.0 +257 257.0 257.0 +258 258.0 258.0 +26 52.0 52.0 +26 52.0 52.0 +260 260.0 260.0 +262 262.0 262.0 +263 263.0 263.0 +265 530.0 530.0 +265 530.0 530.0 +266 266.0 266.0 +27 27.0 27.0 +272 544.0 544.0 +272 544.0 544.0 +273 819.0 819.0 +273 819.0 819.0 +273 819.0 819.0 +274 274.0 274.0 +275 275.0 275.0 +277 1108.0 1108.0 +277 1108.0 1108.0 +277 1108.0 1108.0 +277 1108.0 1108.0 +278 556.0 556.0 +278 556.0 556.0 +28 28.0 28.0 +280 560.0 560.0 +280 560.0 560.0 +281 562.0 562.0 +281 562.0 562.0 +282 564.0 564.0 +282 564.0 564.0 +283 283.0 283.0 +284 284.0 284.0 +285 285.0 285.0 +286 286.0 286.0 +287 287.0 287.0 +288 576.0 576.0 +288 576.0 576.0 +289 289.0 289.0 +291 291.0 291.0 +292 292.0 292.0 +296 296.0 296.0 +298 894.0 894.0 +298 894.0 894.0 +298 894.0 894.0 +30 30.0 30.0 +302 302.0 302.0 +305 305.0 305.0 +306 306.0 306.0 +307 614.0 614.0 +307 614.0 614.0 +308 308.0 308.0 +309 618.0 618.0 +309 618.0 618.0 +310 310.0 310.0 +311 933.0 933.0 +311 933.0 933.0 +311 933.0 933.0 +315 315.0 315.0 +316 948.0 948.0 +316 948.0 948.0 +316 948.0 948.0 +317 634.0 634.0 +317 634.0 634.0 +318 954.0 954.0 +318 954.0 954.0 +318 954.0 954.0 +321 642.0 642.0 +321 642.0 642.0 +322 644.0 644.0 +322 644.0 644.0 +323 323.0 323.0 +325 650.0 650.0 +325 650.0 650.0 +327 981.0 981.0 +327 981.0 981.0 +327 981.0 981.0 +33 33.0 33.0 +331 662.0 662.0 +331 662.0 662.0 +332 332.0 332.0 +333 666.0 666.0 +333 666.0 666.0 +335 335.0 335.0 +336 336.0 336.0 +338 338.0 338.0 +339 339.0 339.0 +34 34.0 34.0 +341 341.0 341.0 +342 684.0 684.0 +342 684.0 684.0 +344 688.0 688.0 +344 688.0 688.0 +345 345.0 345.0 +348 1740.0 1740.0 +348 1740.0 1740.0 +348 1740.0 1740.0 +348 1740.0 1740.0 +348 1740.0 1740.0 +35 105.0 105.0 +35 105.0 105.0 +35 105.0 105.0 +351 351.0 351.0 +353 706.0 706.0 +353 706.0 706.0 +356 356.0 356.0 +360 360.0 360.0 +362 362.0 362.0 +364 364.0 364.0 +365 365.0 365.0 +366 366.0 366.0 +367 734.0 734.0 +367 734.0 734.0 +368 368.0 368.0 +369 1107.0 1107.0 +369 1107.0 1107.0 +369 1107.0 1107.0 +37 74.0 74.0 +37 74.0 74.0 +373 373.0 373.0 +374 374.0 374.0 +375 375.0 375.0 +377 377.0 377.0 +378 378.0 378.0 +379 379.0 379.0 +382 764.0 764.0 +382 764.0 764.0 +384 1152.0 1152.0 +384 1152.0 1152.0 +384 1152.0 1152.0 +386 386.0 386.0 +389 389.0 389.0 +392 392.0 392.0 +393 393.0 393.0 +394 394.0 394.0 +395 790.0 790.0 +395 790.0 790.0 +396 1188.0 1188.0 +396 1188.0 1188.0 +396 1188.0 1188.0 +397 794.0 794.0 +397 794.0 794.0 +399 798.0 798.0 +399 798.0 798.0 +4 4.0 4.0 +400 400.0 400.0 +401 2005.0 2005.0 +401 2005.0 2005.0 +401 2005.0 2005.0 +401 2005.0 2005.0 +401 2005.0 2005.0 +402 402.0 402.0 +403 1209.0 1209.0 +403 1209.0 1209.0 +403 1209.0 1209.0 +404 808.0 808.0 +404 808.0 808.0 +406 1624.0 1624.0 +406 1624.0 1624.0 +406 1624.0 1624.0 +406 1624.0 1624.0 +407 407.0 407.0 +409 1227.0 1227.0 +409 1227.0 1227.0 +409 1227.0 1227.0 +41 41.0 41.0 +411 411.0 411.0 +413 826.0 826.0 +413 826.0 826.0 +414 828.0 828.0 +414 828.0 828.0 +417 1251.0 1251.0 +417 1251.0 1251.0 +417 1251.0 1251.0 +418 418.0 418.0 +419 419.0 419.0 +42 84.0 84.0 +42 84.0 84.0 +421 421.0 421.0 +424 848.0 848.0 +424 848.0 848.0 +427 427.0 427.0 +429 858.0 858.0 +429 858.0 858.0 +43 43.0 43.0 +430 1290.0 1290.0 +430 1290.0 1290.0 +430 1290.0 1290.0 +431 1293.0 1293.0 +431 1293.0 1293.0 +431 1293.0 1293.0 +432 432.0 432.0 +435 435.0 435.0 +436 436.0 436.0 +437 437.0 437.0 +438 1314.0 1314.0 +438 1314.0 1314.0 +438 1314.0 1314.0 +439 878.0 878.0 +439 878.0 878.0 +44 44.0 44.0 +443 443.0 443.0 +444 444.0 444.0 +446 446.0 446.0 +448 448.0 448.0 +449 449.0 449.0 +452 452.0 452.0 +453 453.0 453.0 +454 1362.0 1362.0 +454 1362.0 1362.0 +454 1362.0 1362.0 +455 455.0 455.0 +457 457.0 457.0 +458 916.0 916.0 +458 916.0 916.0 +459 918.0 918.0 +459 918.0 918.0 +460 460.0 460.0 +462 924.0 924.0 +462 924.0 924.0 +463 926.0 926.0 +463 926.0 926.0 +466 1398.0 1398.0 +466 1398.0 1398.0 +466 1398.0 1398.0 +467 467.0 467.0 +468 1872.0 1872.0 +468 1872.0 1872.0 +468 1872.0 1872.0 +468 1872.0 1872.0 +469 2345.0 2345.0 +469 2345.0 2345.0 +469 2345.0 2345.0 +469 2345.0 2345.0 +469 2345.0 2345.0 +47 47.0 47.0 +470 470.0 470.0 +472 472.0 472.0 +475 475.0 475.0 +477 477.0 477.0 +478 956.0 956.0 +478 956.0 956.0 +479 479.0 479.0 +480 1440.0 1440.0 +480 1440.0 1440.0 +480 1440.0 1440.0 +481 481.0 481.0 +482 482.0 482.0 +483 483.0 483.0 +484 484.0 484.0 +485 485.0 485.0 +487 487.0 487.0 +489 1956.0 1956.0 +489 1956.0 1956.0 +489 1956.0 1956.0 +489 1956.0 1956.0 +490 490.0 490.0 +491 491.0 491.0 +492 984.0 984.0 +492 984.0 984.0 +493 493.0 493.0 +494 494.0 494.0 +495 495.0 495.0 +496 496.0 496.0 +497 497.0 497.0 +498 1494.0 1494.0 +498 1494.0 1494.0 +498 1494.0 1494.0 +5 15.0 15.0 +5 15.0 15.0 +5 15.0 15.0 +51 102.0 102.0 +51 102.0 102.0 +53 53.0 53.0 +54 54.0 54.0 +57 57.0 57.0 +58 116.0 116.0 +58 116.0 116.0 +64 64.0 64.0 +65 65.0 65.0 +66 66.0 66.0 +67 134.0 134.0 +67 134.0 134.0 +69 69.0 69.0 +70 210.0 210.0 +70 210.0 210.0 +70 210.0 210.0 +72 144.0 144.0 +72 144.0 144.0 +74 74.0 74.0 +76 152.0 152.0 +76 152.0 152.0 +77 77.0 77.0 +78 78.0 78.0 +8 8.0 8.0 +80 80.0 80.0 +82 82.0 82.0 +83 166.0 166.0 +83 166.0 166.0 +84 168.0 168.0 +84 168.0 168.0 +85 85.0 85.0 +86 86.0 86.0 +87 87.0 87.0 +9 9.0 9.0 +90 270.0 270.0 +90 270.0 270.0 +90 270.0 270.0 +92 92.0 92.0 +95 190.0 190.0 +95 190.0 190.0 +96 96.0 96.0 +97 194.0 194.0 +97 194.0 194.0 +98 196.0 196.0 +98 196.0 196.0 +PREHOOK: query: select * from (SELECT key, sum(key) over(partition by key,value) as c1, sum(key) over(partition by key) as c2 from src)r1 where (cast(key as int) + 1) > 2 +PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### +POSTHOOK: query: select * from (SELECT key, sum(key) over(partition by key,value) as c1, sum(key) over(partition by key) as c2 from src)r1 where (cast(key as int) + 1) > 2 +POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +#### A masked pattern was here #### +10 10.0 10.0 +100 200.0 200.0 +100 200.0 200.0 +103 206.0 206.0 +103 206.0 206.0 +104 208.0 208.0 +104 208.0 208.0 +105 105.0 105.0 +11 11.0 11.0 +111 111.0 111.0 +113 226.0 226.0 +113 226.0 226.0 +114 114.0 114.0 +116 116.0 116.0 +118 236.0 236.0 +118 236.0 236.0 +119 357.0 357.0 +119 357.0 357.0 +119 357.0 357.0 +12 24.0 24.0 +12 24.0 24.0 +120 240.0 240.0 +120 240.0 240.0 +125 250.0 250.0 +125 250.0 250.0 +126 126.0 126.0 +128 384.0 384.0 +128 384.0 384.0 +128 384.0 384.0 +129 258.0 258.0 +129 258.0 258.0 +131 131.0 131.0 +133 133.0 133.0 +134 268.0 268.0 +134 268.0 268.0 +136 136.0 136.0 +137 274.0 274.0 +137 274.0 274.0 +138 552.0 552.0 +138 552.0 552.0 +138 552.0 552.0 +138 552.0 552.0 +143 143.0 143.0 +145 145.0 145.0 +146 292.0 292.0 +146 292.0 292.0 +149 298.0 298.0 +149 298.0 298.0 +15 30.0 30.0 +15 30.0 30.0 +150 150.0 150.0 +152 304.0 304.0 +152 304.0 304.0 +153 153.0 153.0 +155 155.0 155.0 +156 156.0 156.0 +157 157.0 157.0 +158 158.0 158.0 +160 160.0 160.0 +162 162.0 162.0 +163 163.0 163.0 +164 328.0 328.0 +164 328.0 328.0 +165 330.0 330.0 +165 330.0 330.0 +166 166.0 166.0 +167 501.0 501.0 +167 501.0 501.0 +167 501.0 501.0 +168 168.0 168.0 +169 676.0 676.0 +169 676.0 676.0 +169 676.0 676.0 +169 676.0 676.0 +17 17.0 17.0 +170 170.0 170.0 +172 344.0 344.0 +172 344.0 344.0 +174 348.0 348.0 +174 348.0 348.0 +175 350.0 350.0 +175 350.0 350.0 +176 352.0 352.0 +176 352.0 352.0 +177 177.0 177.0 +178 178.0 178.0 +179 358.0 358.0 +179 358.0 358.0 +18 36.0 36.0 +18 36.0 36.0 +180 180.0 180.0 +181 181.0 181.0 +183 183.0 183.0 +186 186.0 186.0 +187 561.0 561.0 +187 561.0 561.0 +187 561.0 561.0 +189 189.0 189.0 +19 19.0 19.0 +190 190.0 190.0 +191 382.0 382.0 +191 382.0 382.0 +192 192.0 192.0 +193 579.0 579.0 +193 579.0 579.0 +193 579.0 579.0 +194 194.0 194.0 +195 390.0 390.0 +195 390.0 390.0 +196 196.0 196.0 +197 394.0 394.0 +197 394.0 394.0 +199 597.0 597.0 +199 597.0 597.0 +199 597.0 597.0 +2 2.0 2.0 +20 20.0 20.0 +200 400.0 400.0 +200 400.0 400.0 +201 201.0 201.0 +202 202.0 202.0 +203 406.0 406.0 +203 406.0 406.0 +205 410.0 410.0 +205 410.0 410.0 +207 414.0 414.0 +207 414.0 414.0 +208 624.0 624.0 +208 624.0 624.0 +208 624.0 624.0 +209 418.0 418.0 +209 418.0 418.0 +213 426.0 426.0 +213 426.0 426.0 +214 214.0 214.0 +216 432.0 432.0 +216 432.0 432.0 +217 434.0 434.0 +217 434.0 434.0 +218 218.0 218.0 +219 438.0 438.0 +219 438.0 438.0 +221 442.0 442.0 +221 442.0 442.0 +222 222.0 222.0 +223 446.0 446.0 +223 446.0 446.0 +224 448.0 448.0 +224 448.0 448.0 +226 226.0 226.0 +228 228.0 228.0 +229 458.0 458.0 +229 458.0 458.0 +230 1150.0 1150.0 +230 1150.0 1150.0 +230 1150.0 1150.0 +230 1150.0 1150.0 +230 1150.0 1150.0 +233 466.0 466.0 +233 466.0 466.0 +235 235.0 235.0 +237 474.0 474.0 +237 474.0 474.0 +238 476.0 476.0 +238 476.0 476.0 +239 478.0 478.0 +239 478.0 478.0 +24 48.0 48.0 +24 48.0 48.0 +241 241.0 241.0 +242 484.0 484.0 +242 484.0 484.0 +244 244.0 244.0 +247 247.0 247.0 +248 248.0 248.0 +249 249.0 249.0 +252 252.0 252.0 +255 510.0 510.0 +255 510.0 510.0 +256 512.0 512.0 +256 512.0 512.0 +257 257.0 257.0 +258 258.0 258.0 +26 52.0 52.0 +26 52.0 52.0 +260 260.0 260.0 +262 262.0 262.0 +263 263.0 263.0 +265 530.0 530.0 +265 530.0 530.0 +266 266.0 266.0 +27 27.0 27.0 +272 544.0 544.0 +272 544.0 544.0 +273 819.0 819.0 +273 819.0 819.0 +273 819.0 819.0 +274 274.0 274.0 +275 275.0 275.0 +277 1108.0 1108.0 +277 1108.0 1108.0 +277 1108.0 1108.0 +277 1108.0 1108.0 +278 556.0 556.0 +278 556.0 556.0 +28 28.0 28.0 +280 560.0 560.0 +280 560.0 560.0 +281 562.0 562.0 +281 562.0 562.0 +282 564.0 564.0 +282 564.0 564.0 +283 283.0 283.0 +284 284.0 284.0 +285 285.0 285.0 +286 286.0 286.0 +287 287.0 287.0 +288 576.0 576.0 +288 576.0 576.0 +289 289.0 289.0 +291 291.0 291.0 +292 292.0 292.0 +296 296.0 296.0 +298 894.0 894.0 +298 894.0 894.0 +298 894.0 894.0 +30 30.0 30.0 +302 302.0 302.0 +305 305.0 305.0 +306 306.0 306.0 +307 614.0 614.0 +307 614.0 614.0 +308 308.0 308.0 +309 618.0 618.0 +309 618.0 618.0 +310 310.0 310.0 +311 933.0 933.0 +311 933.0 933.0 +311 933.0 933.0 +315 315.0 315.0 +316 948.0 948.0 +316 948.0 948.0 +316 948.0 948.0 +317 634.0 634.0 +317 634.0 634.0 +318 954.0 954.0 +318 954.0 954.0 +318 954.0 954.0 +321 642.0 642.0 +321 642.0 642.0 +322 644.0 644.0 +322 644.0 644.0 +323 323.0 323.0 +325 650.0 650.0 +325 650.0 650.0 +327 981.0 981.0 +327 981.0 981.0 +327 981.0 981.0 +33 33.0 33.0 +331 662.0 662.0 +331 662.0 662.0 +332 332.0 332.0 +333 666.0 666.0 +333 666.0 666.0 +335 335.0 335.0 +336 336.0 336.0 +338 338.0 338.0 +339 339.0 339.0 +34 34.0 34.0 +341 341.0 341.0 +342 684.0 684.0 +342 684.0 684.0 +344 688.0 688.0 +344 688.0 688.0 +345 345.0 345.0 +348 1740.0 1740.0 +348 1740.0 1740.0 +348 1740.0 1740.0 +348 1740.0 1740.0 +348 1740.0 1740.0 +35 105.0 105.0 +35 105.0 105.0 +35 105.0 105.0 +351 351.0 351.0 +353 706.0 706.0 +353 706.0 706.0 +356 356.0 356.0 +360 360.0 360.0 +362 362.0 362.0 +364 364.0 364.0 +365 365.0 365.0 +366 366.0 366.0 +367 734.0 734.0 +367 734.0 734.0 +368 368.0 368.0 +369 1107.0 1107.0 +369 1107.0 1107.0 +369 1107.0 1107.0 +37 74.0 74.0 +37 74.0 74.0 +373 373.0 373.0 +374 374.0 374.0 +375 375.0 375.0 +377 377.0 377.0 +378 378.0 378.0 +379 379.0 379.0 +382 764.0 764.0 +382 764.0 764.0 +384 1152.0 1152.0 +384 1152.0 1152.0 +384 1152.0 1152.0 +386 386.0 386.0 +389 389.0 389.0 +392 392.0 392.0 +393 393.0 393.0 +394 394.0 394.0 +395 790.0 790.0 +395 790.0 790.0 +396 1188.0 1188.0 +396 1188.0 1188.0 +396 1188.0 1188.0 +397 794.0 794.0 +397 794.0 794.0 +399 798.0 798.0 +399 798.0 798.0 +4 4.0 4.0 +400 400.0 400.0 +401 2005.0 2005.0 +401 2005.0 2005.0 +401 2005.0 2005.0 +401 2005.0 2005.0 +401 2005.0 2005.0 +402 402.0 402.0 +403 1209.0 1209.0 +403 1209.0 1209.0 +403 1209.0 1209.0 +404 808.0 808.0 +404 808.0 808.0 +406 1624.0 1624.0 +406 1624.0 1624.0 +406 1624.0 1624.0 +406 1624.0 1624.0 +407 407.0 407.0 +409 1227.0 1227.0 +409 1227.0 1227.0 +409 1227.0 1227.0 +41 41.0 41.0 +411 411.0 411.0 +413 826.0 826.0 +413 826.0 826.0 +414 828.0 828.0 +414 828.0 828.0 +417 1251.0 1251.0 +417 1251.0 1251.0 +417 1251.0 1251.0 +418 418.0 418.0 +419 419.0 419.0 +42 84.0 84.0 +42 84.0 84.0 +421 421.0 421.0 +424 848.0 848.0 +424 848.0 848.0 +427 427.0 427.0 +429 858.0 858.0 +429 858.0 858.0 +43 43.0 43.0 +430 1290.0 1290.0 +430 1290.0 1290.0 +430 1290.0 1290.0 +431 1293.0 1293.0 +431 1293.0 1293.0 +431 1293.0 1293.0 +432 432.0 432.0 +435 435.0 435.0 +436 436.0 436.0 +437 437.0 437.0 +438 1314.0 1314.0 +438 1314.0 1314.0 +438 1314.0 1314.0 +439 878.0 878.0 +439 878.0 878.0 +44 44.0 44.0 +443 443.0 443.0 +444 444.0 444.0 +446 446.0 446.0 +448 448.0 448.0 +449 449.0 449.0 +452 452.0 452.0 +453 453.0 453.0 +454 1362.0 1362.0 +454 1362.0 1362.0 +454 1362.0 1362.0 +455 455.0 455.0 +457 457.0 457.0 +458 916.0 916.0 +458 916.0 916.0 +459 918.0 918.0 +459 918.0 918.0 +460 460.0 460.0 +462 924.0 924.0 +462 924.0 924.0 +463 926.0 926.0 +463 926.0 926.0 +466 1398.0 1398.0 +466 1398.0 1398.0 +466 1398.0 1398.0 +467 467.0 467.0 +468 1872.0 1872.0 +468 1872.0 1872.0 +468 1872.0 1872.0 +468 1872.0 1872.0 +469 2345.0 2345.0 +469 2345.0 2345.0 +469 2345.0 2345.0 +469 2345.0 2345.0 +469 2345.0 2345.0 +47 47.0 47.0 +470 470.0 470.0 +472 472.0 472.0 +475 475.0 475.0 +477 477.0 477.0 +478 956.0 956.0 +478 956.0 956.0 +479 479.0 479.0 +480 1440.0 1440.0 +480 1440.0 1440.0 +480 1440.0 1440.0 +481 481.0 481.0 +482 482.0 482.0 +483 483.0 483.0 +484 484.0 484.0 +485 485.0 485.0 +487 487.0 487.0 +489 1956.0 1956.0 +489 1956.0 1956.0 +489 1956.0 1956.0 +489 1956.0 1956.0 +490 490.0 490.0 +491 491.0 491.0 +492 984.0 984.0 +492 984.0 984.0 +493 493.0 493.0 +494 494.0 494.0 +495 495.0 495.0 +496 496.0 496.0 +497 497.0 497.0 +498 1494.0 1494.0 +498 1494.0 1494.0 +498 1494.0 1494.0 +5 15.0 15.0 +5 15.0 15.0 +5 15.0 15.0 +51 102.0 102.0 +51 102.0 102.0 +53 53.0 53.0 +54 54.0 54.0 +57 57.0 57.0 +58 116.0 116.0 +58 116.0 116.0 +64 64.0 64.0 +65 65.0 65.0 +66 66.0 66.0 +67 134.0 134.0 +67 134.0 134.0 +69 69.0 69.0 +70 210.0 210.0 +70 210.0 210.0 +70 210.0 210.0 +72 144.0 144.0 +72 144.0 144.0 +74 74.0 74.0 +76 152.0 152.0 +76 152.0 152.0 +77 77.0 77.0 +78 78.0 78.0 +8 8.0 8.0 +80 80.0 80.0 +82 82.0 82.0 +83 166.0 166.0 +83 166.0 166.0 +84 168.0 168.0 +84 168.0 168.0 +85 85.0 85.0 +86 86.0 86.0 +87 87.0 87.0 +9 9.0 9.0 +90 270.0 270.0 +90 270.0 270.0 +90 270.0 270.0 +92 92.0 92.0 +95 190.0 190.0 +95 190.0 190.0 +96 96.0 96.0 +97 194.0 194.0 +97 194.0 194.0 +98 196.0 196.0 +98 196.0 196.0 +PREHOOK: query: select * from (SELECT (cast(key as int))+2 as key, sum(key) over(partition by key,value) as c1, sum(key) over(partition by key) as c2 from src)r1 where (cast(key as int) + 1) > 2 +PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### +POSTHOOK: query: select * from (SELECT (cast(key as int))+2 as key, sum(key) over(partition by key,value) as c1, sum(key) over(partition by key) as c2 from src)r1 where (cast(key as int) + 1) > 2 +POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +#### A masked pattern was here #### +2 0.0 0.0 +2 0.0 0.0 +2 0.0 0.0 +12 10.0 10.0 +102 200.0 200.0 +102 200.0 200.0 +105 206.0 206.0 +105 206.0 206.0 +106 208.0 208.0 +106 208.0 208.0 +107 105.0 105.0 +13 11.0 11.0 +113 111.0 111.0 +115 226.0 226.0 +115 226.0 226.0 +116 114.0 114.0 +118 116.0 116.0 +120 236.0 236.0 +120 236.0 236.0 +121 357.0 357.0 +121 357.0 357.0 +121 357.0 357.0 +14 24.0 24.0 +14 24.0 24.0 +122 240.0 240.0 +122 240.0 240.0 +127 250.0 250.0 +127 250.0 250.0 +128 126.0 126.0 +130 384.0 384.0 +130 384.0 384.0 +130 384.0 384.0 +131 258.0 258.0 +131 258.0 258.0 +133 131.0 131.0 +135 133.0 133.0 +136 268.0 268.0 +136 268.0 268.0 +138 136.0 136.0 +139 274.0 274.0 +139 274.0 274.0 +140 552.0 552.0 +140 552.0 552.0 +140 552.0 552.0 +140 552.0 552.0 +145 143.0 143.0 +147 145.0 145.0 +148 292.0 292.0 +148 292.0 292.0 +151 298.0 298.0 +151 298.0 298.0 +17 30.0 30.0 +17 30.0 30.0 +152 150.0 150.0 +154 304.0 304.0 +154 304.0 304.0 +155 153.0 153.0 +157 155.0 155.0 +158 156.0 156.0 +159 157.0 157.0 +160 158.0 158.0 +162 160.0 160.0 +164 162.0 162.0 +165 163.0 163.0 +166 328.0 328.0 +166 328.0 328.0 +167 330.0 330.0 +167 330.0 330.0 +168 166.0 166.0 +169 501.0 501.0 +169 501.0 501.0 +169 501.0 501.0 +170 168.0 168.0 +171 676.0 676.0 +171 676.0 676.0 +171 676.0 676.0 +171 676.0 676.0 +19 17.0 17.0 +172 170.0 170.0 +174 344.0 344.0 +174 344.0 344.0 +176 348.0 348.0 +176 348.0 348.0 +177 350.0 350.0 +177 350.0 350.0 +178 352.0 352.0 +178 352.0 352.0 +179 177.0 177.0 +180 178.0 178.0 +181 358.0 358.0 +181 358.0 358.0 +20 36.0 36.0 +20 36.0 36.0 +182 180.0 180.0 +183 181.0 181.0 +185 183.0 183.0 +188 186.0 186.0 +189 561.0 561.0 +189 561.0 561.0 +189 561.0 561.0 +191 189.0 189.0 +21 19.0 19.0 +192 190.0 190.0 +193 382.0 382.0 +193 382.0 382.0 +194 192.0 192.0 +195 579.0 579.0 +195 579.0 579.0 +195 579.0 579.0 +196 194.0 194.0 +197 390.0 390.0 +197 390.0 390.0 +198 196.0 196.0 +199 394.0 394.0 +199 394.0 394.0 +201 597.0 597.0 +201 597.0 597.0 +201 597.0 597.0 +4 2.0 2.0 +22 20.0 20.0 +202 400.0 400.0 +202 400.0 400.0 +203 201.0 201.0 +204 202.0 202.0 +205 406.0 406.0 +205 406.0 406.0 +207 410.0 410.0 +207 410.0 410.0 +209 414.0 414.0 +209 414.0 414.0 +210 624.0 624.0 +210 624.0 624.0 +210 624.0 624.0 +211 418.0 418.0 +211 418.0 418.0 +215 426.0 426.0 +215 426.0 426.0 +216 214.0 214.0 +218 432.0 432.0 +218 432.0 432.0 +219 434.0 434.0 +219 434.0 434.0 +220 218.0 218.0 +221 438.0 438.0 +221 438.0 438.0 +223 442.0 442.0 +223 442.0 442.0 +224 222.0 222.0 +225 446.0 446.0 +225 446.0 446.0 +226 448.0 448.0 +226 448.0 448.0 +228 226.0 226.0 +230 228.0 228.0 +231 458.0 458.0 +231 458.0 458.0 +232 1150.0 1150.0 +232 1150.0 1150.0 +232 1150.0 1150.0 +232 1150.0 1150.0 +232 1150.0 1150.0 +235 466.0 466.0 +235 466.0 466.0 +237 235.0 235.0 +239 474.0 474.0 +239 474.0 474.0 +240 476.0 476.0 +240 476.0 476.0 +241 478.0 478.0 +241 478.0 478.0 +26 48.0 48.0 +26 48.0 48.0 +243 241.0 241.0 +244 484.0 484.0 +244 484.0 484.0 +246 244.0 244.0 +249 247.0 247.0 +250 248.0 248.0 +251 249.0 249.0 +254 252.0 252.0 +257 510.0 510.0 +257 510.0 510.0 +258 512.0 512.0 +258 512.0 512.0 +259 257.0 257.0 +260 258.0 258.0 +28 52.0 52.0 +28 52.0 52.0 +262 260.0 260.0 +264 262.0 262.0 +265 263.0 263.0 +267 530.0 530.0 +267 530.0 530.0 +268 266.0 266.0 +29 27.0 27.0 +274 544.0 544.0 +274 544.0 544.0 +275 819.0 819.0 +275 819.0 819.0 +275 819.0 819.0 +276 274.0 274.0 +277 275.0 275.0 +279 1108.0 1108.0 +279 1108.0 1108.0 +279 1108.0 1108.0 +279 1108.0 1108.0 +280 556.0 556.0 +280 556.0 556.0 +30 28.0 28.0 +282 560.0 560.0 +282 560.0 560.0 +283 562.0 562.0 +283 562.0 562.0 +284 564.0 564.0 +284 564.0 564.0 +285 283.0 283.0 +286 284.0 284.0 +287 285.0 285.0 +288 286.0 286.0 +289 287.0 287.0 +290 576.0 576.0 +290 576.0 576.0 +291 289.0 289.0 +293 291.0 291.0 +294 292.0 292.0 +298 296.0 296.0 +300 894.0 894.0 +300 894.0 894.0 +300 894.0 894.0 +32 30.0 30.0 +304 302.0 302.0 +307 305.0 305.0 +308 306.0 306.0 +309 614.0 614.0 +309 614.0 614.0 +310 308.0 308.0 +311 618.0 618.0 +311 618.0 618.0 +312 310.0 310.0 +313 933.0 933.0 +313 933.0 933.0 +313 933.0 933.0 +317 315.0 315.0 +318 948.0 948.0 +318 948.0 948.0 +318 948.0 948.0 +319 634.0 634.0 +319 634.0 634.0 +320 954.0 954.0 +320 954.0 954.0 +320 954.0 954.0 +323 642.0 642.0 +323 642.0 642.0 +324 644.0 644.0 +324 644.0 644.0 +325 323.0 323.0 +327 650.0 650.0 +327 650.0 650.0 +329 981.0 981.0 +329 981.0 981.0 +329 981.0 981.0 +35 33.0 33.0 +333 662.0 662.0 +333 662.0 662.0 +334 332.0 332.0 +335 666.0 666.0 +335 666.0 666.0 +337 335.0 335.0 +338 336.0 336.0 +340 338.0 338.0 +341 339.0 339.0 +36 34.0 34.0 +343 341.0 341.0 +344 684.0 684.0 +344 684.0 684.0 +346 688.0 688.0 +346 688.0 688.0 +347 345.0 345.0 +350 1740.0 1740.0 +350 1740.0 1740.0 +350 1740.0 1740.0 +350 1740.0 1740.0 +350 1740.0 1740.0 +37 105.0 105.0 +37 105.0 105.0 +37 105.0 105.0 +353 351.0 351.0 +355 706.0 706.0 +355 706.0 706.0 +358 356.0 356.0 +362 360.0 360.0 +364 362.0 362.0 +366 364.0 364.0 +367 365.0 365.0 +368 366.0 366.0 +369 734.0 734.0 +369 734.0 734.0 +370 368.0 368.0 +371 1107.0 1107.0 +371 1107.0 1107.0 +371 1107.0 1107.0 +39 74.0 74.0 +39 74.0 74.0 +375 373.0 373.0 +376 374.0 374.0 +377 375.0 375.0 +379 377.0 377.0 +380 378.0 378.0 +381 379.0 379.0 +384 764.0 764.0 +384 764.0 764.0 +386 1152.0 1152.0 +386 1152.0 1152.0 +386 1152.0 1152.0 +388 386.0 386.0 +391 389.0 389.0 +394 392.0 392.0 +395 393.0 393.0 +396 394.0 394.0 +397 790.0 790.0 +397 790.0 790.0 +398 1188.0 1188.0 +398 1188.0 1188.0 +398 1188.0 1188.0 +399 794.0 794.0 +399 794.0 794.0 +401 798.0 798.0 +401 798.0 798.0 +6 4.0 4.0 +402 400.0 400.0 +403 2005.0 2005.0 +403 2005.0 2005.0 +403 2005.0 2005.0 +403 2005.0 2005.0 +403 2005.0 2005.0 +404 402.0 402.0 +405 1209.0 1209.0 +405 1209.0 1209.0 +405 1209.0 1209.0 +406 808.0 808.0 +406 808.0 808.0 +408 1624.0 1624.0 +408 1624.0 1624.0 +408 1624.0 1624.0 +408 1624.0 1624.0 +409 407.0 407.0 +411 1227.0 1227.0 +411 1227.0 1227.0 +411 1227.0 1227.0 +43 41.0 41.0 +413 411.0 411.0 +415 826.0 826.0 +415 826.0 826.0 +416 828.0 828.0 +416 828.0 828.0 +419 1251.0 1251.0 +419 1251.0 1251.0 +419 1251.0 1251.0 +420 418.0 418.0 +421 419.0 419.0 +44 84.0 84.0 +44 84.0 84.0 +423 421.0 421.0 +426 848.0 848.0 +426 848.0 848.0 +429 427.0 427.0 +431 858.0 858.0 +431 858.0 858.0 +45 43.0 43.0 +432 1290.0 1290.0 +432 1290.0 1290.0 +432 1290.0 1290.0 +433 1293.0 1293.0 +433 1293.0 1293.0 +433 1293.0 1293.0 +434 432.0 432.0 +437 435.0 435.0 +438 436.0 436.0 +439 437.0 437.0 +440 1314.0 1314.0 +440 1314.0 1314.0 +440 1314.0 1314.0 +441 878.0 878.0 +441 878.0 878.0 +46 44.0 44.0 +445 443.0 443.0 +446 444.0 444.0 +448 446.0 446.0 +450 448.0 448.0 +451 449.0 449.0 +454 452.0 452.0 +455 453.0 453.0 +456 1362.0 1362.0 +456 1362.0 1362.0 +456 1362.0 1362.0 +457 455.0 455.0 +459 457.0 457.0 +460 916.0 916.0 +460 916.0 916.0 +461 918.0 918.0 +461 918.0 918.0 +462 460.0 460.0 +464 924.0 924.0 +464 924.0 924.0 +465 926.0 926.0 +465 926.0 926.0 +468 1398.0 1398.0 +468 1398.0 1398.0 +468 1398.0 1398.0 +469 467.0 467.0 +470 1872.0 1872.0 +470 1872.0 1872.0 +470 1872.0 1872.0 +470 1872.0 1872.0 +471 2345.0 2345.0 +471 2345.0 2345.0 +471 2345.0 2345.0 +471 2345.0 2345.0 +471 2345.0 2345.0 +49 47.0 47.0 +472 470.0 470.0 +474 472.0 472.0 +477 475.0 4
<TRUNCATED>
