You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by jd...@apache.org on 2014/03/15 01:06:24 UTC
svn commit: r1577766 [3/3] - in /hive/branches/branch-0.13:
common/src/java/org/apache/hadoop/hive/conf/
common/src/java/org/apache/hive/common/ conf/
ql/src/java/org/apache/hadoop/hive/ql/exec/
ql/src/java/org/apache/hadoop/hive/ql/udf/generic/ ql/src...
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