Modified: hive/branches/branch-0.13/ql/src/test/results/clientpositive/windowing_expressions.q.out URL: http://svn.apache.org/viewvc/hive/branches/branch-0.13/ql/src/test/results/clientpositive/windowing_expressions.q.out?rev=1577766&r1=1577765&r2=1577766&view=diff ============================================================================== --- hive/branches/branch-0.13/ql/src/test/results/clientpositive/windowing_expressions.q.out (original) +++ hive/branches/branch-0.13/ql/src/test/results/clientpositive/windowing_expressions.q.out Sat Mar 15 00:06:24 2014 @@ -176,106 +176,106 @@ POSTHOOK: query: select s, si, f, si - l POSTHOOK: type: QUERY POSTHOOK: Input: default@over10k #### A masked pattern was here #### -alice allen 400 76.31 337.2299995422363 -alice davidson 384 71.97 357.79000091552734 -alice king 455 2.48 395.9300003051758 -alice king 458 62.77 384.1699981689453 -alice xylophone 485 26.21 464.04999923706055 -bob falkner 260 59.07 242.39999961853027 -bob ichabod 454 73.83 381.6999969482422 -bob polk 264 20.95 257.17000007629395 -bob underhill 454 17.6 424.9400005340576 -bob underhill 465 72.3 453.17000007629395 -bob van buren 433 6.83 398.4000015258789 -calvin ichabod 431 29.06 334.2200012207031 -david garcia 485 11.83 421.5099983215332 -ethan steinbeck 298 34.6 288.14000034332275 -fred ellison 376 96.78 330.7599983215332 -holly steinbeck 384 63.49 293.6999969482422 -holly underhill 318 9.86 269.9099998474121 -irene ellison 458 45.24 365.29000091552734 -irene underhill 307 90.3 244.18999862670898 -jessica johnson 494 48.09 490.1800000667572 -jessica king 459 92.71 452.19999980926514 -jessica white 284 62.81 209.0800018310547 -luke garcia 311 3.82 267.2700004577637 +alice allen 400 76.31 337.23 +alice davidson 384 71.97 357.79 +alice king 455 2.48 395.93 +alice king 458 62.77 384.16998 +alice xylophone 485 26.21 464.05 +bob falkner 260 59.07 242.4 +bob ichabod 454 73.83 381.7 +bob polk 264 20.95 257.17 +bob underhill 454 17.6 424.94 +bob underhill 465 72.3 453.17 +bob van buren 433 6.83 398.4 +calvin ichabod 431 29.06 334.22 +david garcia 485 11.83 421.51 +ethan steinbeck 298 34.6 288.14 +fred ellison 376 96.78 330.76 +holly steinbeck 384 63.49 293.7 +holly underhill 318 9.86 269.91 +irene ellison 458 45.24 365.29 +irene underhill 307 90.3 244.19 +jessica johnson 494 48.09 490.18 +jessica king 459 92.71 452.2 +jessica white 284 62.81 209.08 +luke garcia 311 3.82 267.27 luke young 451 6.8 429.0 -mike king 275 74.92 211.81000137329102 -oscar garcia 362 43.73 340.6599998474121 -priscilla laertes 316 22.0 296.0599994659424 -priscilla quirinius 423 63.19 362.7200012207031 -priscilla zipper 485 21.34 400.61000061035156 -quinn ellison 266 19.94 209.95000076293945 -quinn polk 507 60.28 447.6599998474121 -sarah robinson 320 84.39 309.73999977111816 -tom polk 346 56.05 320.32999992370605 -ulysses ellison 381 59.34 358.6599998474121 -ulysses quirinius 303 10.26 259.5999984741211 -ulysses robinson 313 25.67 269.310001373291 -ulysses steinbeck 333 22.34 270.61000061035156 +mike king 275 74.92 211.81 +oscar garcia 362 43.73 340.66 +priscilla laertes 316 22.0 296.06 +priscilla quirinius 423 63.19 362.72 +priscilla zipper 485 21.34 400.61 +quinn ellison 266 19.94 209.95 +quinn polk 507 60.28 447.66 +sarah robinson 320 84.39 309.74 +tom polk 346 56.05 320.33 +ulysses ellison 381 59.34 358.66 +ulysses quirinius 303 10.26 259.6 +ulysses robinson 313 25.67 269.31 +ulysses steinbeck 333 22.34 270.61 victor allen 337 43.4 311.5 -victor hernandez 447 43.69 375.2200012207031 -victor xylophone 438 62.39 424.32999992370605 +victor hernandez 447 43.69 375.22 +victor xylophone 438 62.39 424.33 wendy quirinius 279 25.5 250.25 -wendy robinson 275 71.78 262.8800001144409 -wendy xylophone 314 13.67 295.7299995422363 -xavier garcia 493 28.75 474.5599994659424 -zach thompson 386 12.12 377.6300001144409 -zach young 286 18.27 263.6499996185303 -alice falkner 280 18.44 227.70000076293945 -bob ellison 339 8.37 300.95000076293945 -bob johnson 374 22.35 326.4900016784668 -calvin white 280 52.3 198.31999969482422 -david carson 270 38.05 255.77000045776367 -david falkner 469 47.51 388.3499984741211 -david hernandez 408 81.68 339.2699966430664 -ethan underhill 339 14.23 256.26000213623047 +wendy robinson 275 71.78 262.88 +wendy xylophone 314 13.67 295.73 +xavier garcia 493 28.75 474.56 +zach thompson 386 12.12 377.63 +zach young 286 18.27 263.65 +alice falkner 280 18.44 227.7 +bob ellison 339 8.37 300.95 +bob johnson 374 22.35 326.49 +calvin white 280 52.3 198.32 +david carson 270 38.05 255.77 +david falkner 469 47.51 388.35 +david hernandez 408 81.68 339.27 +ethan underhill 339 14.23 256.26 gabriella brown 498 80.65 413.25 -holly nixon 505 68.73 440.70999908447266 -holly polk 268 82.74 182.04000091552734 -holly thompson 387 84.75 298.2200012207031 -irene young 458 64.29 401.79999923706055 -jessica miller 299 85.96 243.4099998474121 -katie ichabod 469 88.78 385.61000061035156 -luke ichabod 289 56.2 286.74000000953674 -luke king 337 55.59 274.88000106811523 -mike allen 465 83.39 383.0299987792969 -mike polk 500 2.26 427.73999786376953 -mike white 454 62.12 430.7800006866455 -mike xylophone 448 81.97 447.1700000166893 -nick nixon 335 72.26 240.77999877929688 -nick robinson 350 23.22 294.5900001525879 -oscar davidson 432 0.83 420.9300003051758 -oscar johnson 315 94.22 233.0500030517578 -oscar johnson 469 55.41 468.4399999976158 -oscar miller 324 11.07 265.189998626709 -rachel davidson 507 81.95 468.7799987792969 -rachel thompson 344 0.56 246.12000274658203 -sarah miller 386 58.81 304.36000061035156 -sarah xylophone 275 38.22 177.48999786376953 -sarah zipper 376 97.88 294.61000061035156 -tom hernandez 467 81.64 459.90000009536743 -tom hernandez 477 97.51 415.189998626709 -tom steinbeck 414 81.39 361.86999893188477 -ulysses carson 343 7.1 314.2199993133545 +holly nixon 505 68.73 440.71 +holly polk 268 82.74 182.04001 +holly thompson 387 84.75 298.22 +irene young 458 64.29 401.8 +jessica miller 299 85.96 243.41 +katie ichabod 469 88.78 385.61 +luke ichabod 289 56.2 286.74 +luke king 337 55.59 274.88 +mike allen 465 83.39 383.03 +mike polk 500 2.26 427.74 +mike white 454 62.12 430.78 +mike xylophone 448 81.97 447.17 +nick nixon 335 72.26 240.78 +nick robinson 350 23.22 294.59 +oscar davidson 432 0.83 420.93 +oscar johnson 315 94.22 233.05 +oscar johnson 469 55.41 468.44 +oscar miller 324 11.07 265.19 +rachel davidson 507 81.95 468.78 +rachel thompson 344 0.56 246.12 +sarah miller 386 58.81 304.36 +sarah xylophone 275 38.22 177.48999 +sarah zipper 376 97.88 294.61 +tom hernandez 467 81.64 459.9 +tom hernandez 477 97.51 415.19 +tom steinbeck 414 81.39 361.87 +ulysses carson 343 7.1 314.22 victor robinson 415 61.81 349.5 victor thompson 344 52.13 NULL xavier ovid 280 28.78 NULL yuri xylophone 430 65.5 NULL -alice underhill 389 26.68 368.0599994659424 -alice underhill 446 6.49 444.210000038147 -bob ovid 331 67.12 236.43000030517578 -bob van buren 406 20.94 383.3199996948242 -david falkner 406 1.79 374.3400001525879 -david miller 450 94.57 380.12999725341797 -ethan allen 380 22.68 375.59999990463257 -ethan king 395 31.66 361.5099983215332 -ethan nixon 475 69.87 431.38999938964844 -ethan polk 283 4.4 243.81999969482422 -fred allen 331 33.49 281.6800003051758 -fred king 511 43.61 457.2200012207031 -fred polk 261 39.18 248.72999954223633 -fred young 303 49.32 221.51000213623047 +alice underhill 389 26.68 368.06 +alice underhill 446 6.49 444.21 +bob ovid 331 67.12 236.43 +bob van buren 406 20.94 383.32 +david falkner 406 1.79 374.34 +david miller 450 94.57 380.13 +ethan allen 380 22.68 375.6 +ethan king 395 31.66 361.51 +ethan nixon 475 69.87 431.39 +ethan polk 283 4.4 243.82 +fred allen 331 33.49 281.68 +fred king 511 43.61 457.22 +fred polk 261 39.18 248.73 +fred young 303 49.32 221.51001 PREHOOK: query: select s, i, i - lead(i, 3, 0) over (partition by si order by i,s) from over10k limit 100 PREHOOK: type: QUERY PREHOOK: Input: default@over10k
