Repository: hive Updated Branches: refs/heads/master 1ed36f042 -> b271bcb7c
http://git-wip-us.apache.org/repos/asf/hive/blob/b271bcb7/ql/src/test/results/clientpositive/windowing_windowspec.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/windowing_windowspec.q.out b/ql/src/test/results/clientpositive/windowing_windowspec.q.out index 52fe871..9da6183 100644 --- a/ql/src/test/results/clientpositive/windowing_windowspec.q.out +++ b/ql/src/test/results/clientpositive/windowing_windowspec.q.out @@ -800,6 +800,114 @@ POSTHOOK: Input: default@over10k 71.68 722.6499947607517 79.46 802.1099938452244 80.02 882.1299904882908 +PREHOOK: query: select f, sum(f) over (partition by ts order by f rows between 2 preceding and 1 preceding) from over10k limit 100 +PREHOOK: type: QUERY +PREHOOK: Input: default@over10k +#### A masked pattern was here #### +POSTHOOK: query: select f, sum(f) over (partition by ts order by f rows between 2 preceding and 1 preceding) from over10k limit 100 +POSTHOOK: type: QUERY +POSTHOOK: Input: default@over10k +#### A masked pattern was here #### +3.17 NULL +10.89 3.1700000762939453 +14.54 14.0600004196167 +14.78 25.43000030517578 +17.85 29.31999969482422 +20.61 32.63000011444092 +28.69 38.46000099182129 +29.22 49.30000114440918 +31.17 57.90999984741211 +38.35 60.38999938964844 +38.61 69.51999855041504 +39.48 76.95999908447266 +40.54 78.09000015258789 +41.6 80.02000045776367 +46.08 82.13999938964844 +54.36 87.68000030517578 +56.94 100.44000244140625 +64.96 111.29999923706055 +73.52 121.89999771118164 +78.58 138.47999572753906 +81.41 152.0999984741211 +84.71 159.99000549316406 +87.43 166.12000274658203 +91.36 172.13999938964844 +92.96 178.79000091552734 +95.04 184.31999969482422 +0.83 NULL +1.99 0.8299999833106995 +3.73 2.8199999928474426 +8.86 5.7200000286102295 +10.62 12.589999675750732 +11.32 19.479999542236328 +12.83 21.9399995803833 +14.7 24.149999618530273 +14.96 27.52999973297119 +17.58 29.65999984741211 +19.1 32.53999996185303 +21.01 36.68000030517578 +26.95 40.11000061035156 +27.23 47.96000099182129 +29.07 54.18000030517578 +29.71 56.29999923706055 +31.84 58.779998779296875 +31.94 61.54999923706055 +35.32 63.78000068664551 +37.32 67.26000022888184 +38.5 72.63999938964844 +42.08 75.81999969482422 +44.3 80.58000183105469 +44.66 86.38000106811523 +46.84 88.95999908447266 +48.89 91.5 +49.64 95.72999954223633 +50.28 98.52999877929688 +52.09 99.91999816894531 +53.26 102.36999893188477 +54.09 105.3499984741211 +56.45 107.3499984741211 +56.76 110.54000091552734 +61.41 113.20999908447266 +61.88 118.16999816894531 +63.03 123.29000091552734 +64.55 124.90999984741211 +68.62 127.58000183105469 +76.13 133.17000579833984 +79.05 144.75 +80.43 155.18000030517578 +81.41 159.4800033569336 +82.85 161.84000396728516 +83.98 164.26000213623047 +84.21 166.8300018310547 +85.55 168.19000244140625 +87.93 169.76000213623047 +88.93 173.4800033569336 +94.27 176.86000061035156 +99.45 183.1999969482422 +0.36 NULL +0.48 0.36000001430511475 +0.79 0.8400000035762787 +1.27 1.270000010728836 +4.48 2.060000002384186 +9.0 5.75 +23.27 13.480000019073486 +25.13 32.27000045776367 +25.34 48.39999961853027 +25.91 50.46999931335449 +29.01 51.25 +30.47 54.920000076293945 +37.95 59.47999954223633 +39.3 68.42000007629395 +45.91 77.25 +52.44 85.20999908447266 +54.1 98.3499984741211 +56.7 106.53999710083008 +58.77 110.79999923706055 +62.09 115.47000122070312 +68.2 120.86000061035156 +71.68 130.28999710083008 +79.46 139.87999725341797 +80.02 151.13999938964844 PREHOOK: query: select s, i, round(avg(d) over (partition by s order by i) / 10.0 , 2) from over10k limit 7 PREHOOK: type: QUERY PREHOOK: Input: default@over10k