HIVE-10878 : Add tests to cover avg() function for 'x preceding and y preceding' windowing spec (Aihua Xu via Ashutosh Chauhan)
Signed-off-by: Ashutosh Chauhan <hashut...@apache.org> Project: http://git-wip-us.apache.org/repos/asf/hive/repo Commit: http://git-wip-us.apache.org/repos/asf/hive/commit/715871a0 Tree: http://git-wip-us.apache.org/repos/asf/hive/tree/715871a0 Diff: http://git-wip-us.apache.org/repos/asf/hive/diff/715871a0 Branch: refs/heads/hbase-metastore Commit: 715871a0e66c9686a707986109316dba358b5c88 Parents: e22aaf6 Author: Aihua Xu <aihu...@gmail.com> Authored: Mon Jun 1 07:56:00 2015 -0700 Committer: Ashutosh Chauhan <hashut...@apache.org> Committed: Tue Jun 2 09:55:56 2015 -0700 ---------------------------------------------------------------------- .../clientpositive/windowing_windowspec2.q | 6 + .../clientpositive/windowing_windowspec2.q.out | 434 +++++++++++++++++++ 2 files changed, 440 insertions(+) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/hive/blob/715871a0/ql/src/test/queries/clientpositive/windowing_windowspec2.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientpositive/windowing_windowspec2.q b/ql/src/test/queries/clientpositive/windowing_windowspec2.q index e270a86..3c5bc3d 100644 --- a/ql/src/test/queries/clientpositive/windowing_windowspec2.q +++ b/ql/src/test/queries/clientpositive/windowing_windowspec2.q @@ -23,6 +23,12 @@ select ts, f, sum(f) over (partition by ts order by f rows between unbounded pre select ts, f, sum(f) over (partition by ts order by f rows between 1 following and 2 following) from over10k limit 100; select ts, f, sum(f) over (partition by ts order by f rows between unbounded preceding and 1 following) from over10k limit 100; +-- avg +select ts, f, avg(f) over (partition by ts order by f rows between 2 preceding and 1 preceding) from over10k limit 100; +select ts, f, avg(f) over (partition by ts order by f rows between unbounded preceding and 1 preceding) from over10k limit 100; +select ts, f, avg(f) over (partition by ts order by f rows between 1 following and 2 following) from over10k limit 100; +select ts, f, avg(f) over (partition by ts order by f rows between unbounded preceding and 1 following) from over10k limit 100; + -- count select ts, f, count(f) over (partition by ts order by f rows between 2 preceding and 1 preceding) from over10k limit 100; select ts, f, count(f) over (partition by ts order by f rows between unbounded preceding and 1 preceding) from over10k limit 100; http://git-wip-us.apache.org/repos/asf/hive/blob/715871a0/ql/src/test/results/clientpositive/windowing_windowspec2.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/windowing_windowspec2.q.out b/ql/src/test/results/clientpositive/windowing_windowspec2.q.out index a318398..e71a03f 100644 --- a/ql/src/test/results/clientpositive/windowing_windowspec2.q.out +++ b/ql/src/test/results/clientpositive/windowing_windowspec2.q.out @@ -478,6 +478,440 @@ POSTHOOK: Input: default@over10k 2013-03-01 09:11:58.703072 71.68 802.1099938452244 2013-03-01 09:11:58.703072 79.46 882.1299904882908 2013-03-01 09:11:58.703072 80.02 963.4199914038181 +PREHOOK: query: -- avg +select ts, f, avg(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: -- avg +select ts, f, avg(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 #### +2013-03-01 09:11:58.70307 3.17 NULL +2013-03-01 09:11:58.70307 10.89 3.1700000762939453 +2013-03-01 09:11:58.70307 14.54 7.03000020980835 +2013-03-01 09:11:58.70307 14.78 12.71500015258789 +2013-03-01 09:11:58.70307 17.85 14.65999984741211 +2013-03-01 09:11:58.70307 20.61 16.31500005722046 +2013-03-01 09:11:58.70307 28.69 19.230000495910645 +2013-03-01 09:11:58.70307 29.22 24.65000057220459 +2013-03-01 09:11:58.70307 31.17 28.954999923706055 +2013-03-01 09:11:58.70307 38.35 30.19499969482422 +2013-03-01 09:11:58.70307 38.61 34.75999927520752 +2013-03-01 09:11:58.70307 39.48 38.47999954223633 +2013-03-01 09:11:58.70307 40.54 39.045000076293945 +2013-03-01 09:11:58.70307 41.6 40.010000228881836 +2013-03-01 09:11:58.70307 46.08 41.06999969482422 +2013-03-01 09:11:58.70307 54.36 43.84000015258789 +2013-03-01 09:11:58.70307 56.94 50.220001220703125 +2013-03-01 09:11:58.70307 64.96 55.64999961853027 +2013-03-01 09:11:58.70307 73.52 60.94999885559082 +2013-03-01 09:11:58.70307 78.58 69.23999786376953 +2013-03-01 09:11:58.70307 81.41 76.04999923706055 +2013-03-01 09:11:58.70307 84.71 79.99500274658203 +2013-03-01 09:11:58.70307 87.43 83.06000137329102 +2013-03-01 09:11:58.70307 91.36 86.06999969482422 +2013-03-01 09:11:58.70307 92.96 89.39500045776367 +2013-03-01 09:11:58.70307 95.04 92.15999984741211 +2013-03-01 09:11:58.703071 0.83 NULL +2013-03-01 09:11:58.703071 1.99 0.8299999833106995 +2013-03-01 09:11:58.703071 3.73 1.4099999964237213 +2013-03-01 09:11:58.703071 8.86 2.8600000143051147 +2013-03-01 09:11:58.703071 10.62 6.294999837875366 +2013-03-01 09:11:58.703071 11.32 9.739999771118164 +2013-03-01 09:11:58.703071 12.83 10.96999979019165 +2013-03-01 09:11:58.703071 14.7 12.074999809265137 +2013-03-01 09:11:58.703071 14.96 13.764999866485596 +2013-03-01 09:11:58.703071 17.58 14.829999923706055 +2013-03-01 09:11:58.703071 19.1 16.269999980926514 +2013-03-01 09:11:58.703071 21.01 18.34000015258789 +2013-03-01 09:11:58.703071 26.95 20.05500030517578 +2013-03-01 09:11:58.703071 27.23 23.980000495910645 +2013-03-01 09:11:58.703071 29.07 27.09000015258789 +2013-03-01 09:11:58.703071 29.71 28.149999618530273 +2013-03-01 09:11:58.703071 31.84 29.389999389648438 +2013-03-01 09:11:58.703071 31.94 30.774999618530273 +2013-03-01 09:11:58.703071 35.32 31.890000343322754 +2013-03-01 09:11:58.703071 37.32 33.63000011444092 +2013-03-01 09:11:58.703071 38.5 36.31999969482422 +2013-03-01 09:11:58.703071 42.08 37.90999984741211 +2013-03-01 09:11:58.703071 44.3 40.290000915527344 +2013-03-01 09:11:58.703071 44.66 43.19000053405762 +2013-03-01 09:11:58.703071 46.84 44.47999954223633 +2013-03-01 09:11:58.703071 48.89 45.75 +2013-03-01 09:11:58.703071 49.64 47.864999771118164 +2013-03-01 09:11:58.703071 50.28 49.26499938964844 +2013-03-01 09:11:58.703071 52.09 49.959999084472656 +2013-03-01 09:11:58.703071 53.26 51.18499946594238 +2013-03-01 09:11:58.703071 54.09 52.67499923706055 +2013-03-01 09:11:58.703071 56.45 53.67499923706055 +2013-03-01 09:11:58.703071 56.76 55.27000045776367 +2013-03-01 09:11:58.703071 61.41 56.60499954223633 +2013-03-01 09:11:58.703071 61.88 59.084999084472656 +2013-03-01 09:11:58.703071 63.03 61.64500045776367 +2013-03-01 09:11:58.703071 64.55 62.454999923706055 +2013-03-01 09:11:58.703071 68.62 63.790000915527344 +2013-03-01 09:11:58.703071 76.13 66.58500289916992 +2013-03-01 09:11:58.703071 79.05 72.375 +2013-03-01 09:11:58.703071 80.43 77.59000015258789 +2013-03-01 09:11:58.703071 81.41 79.7400016784668 +2013-03-01 09:11:58.703071 82.85 80.92000198364258 +2013-03-01 09:11:58.703071 83.98 82.13000106811523 +2013-03-01 09:11:58.703071 84.21 83.41500091552734 +2013-03-01 09:11:58.703071 85.55 84.09500122070312 +2013-03-01 09:11:58.703071 87.93 84.88000106811523 +2013-03-01 09:11:58.703071 88.93 86.7400016784668 +2013-03-01 09:11:58.703071 94.27 88.43000030517578 +2013-03-01 09:11:58.703071 99.45 91.5999984741211 +2013-03-01 09:11:58.703072 0.36 NULL +2013-03-01 09:11:58.703072 0.48 0.36000001430511475 +2013-03-01 09:11:58.703072 0.79 0.42000000178813934 +2013-03-01 09:11:58.703072 1.27 0.635000005364418 +2013-03-01 09:11:58.703072 4.48 1.030000001192093 +2013-03-01 09:11:58.703072 9.0 2.875 +2013-03-01 09:11:58.703072 23.27 6.740000009536743 +2013-03-01 09:11:58.703072 25.13 16.135000228881836 +2013-03-01 09:11:58.703072 25.34 24.199999809265137 +2013-03-01 09:11:58.703072 25.91 25.234999656677246 +2013-03-01 09:11:58.703072 29.01 25.625 +2013-03-01 09:11:58.703072 30.47 27.460000038146973 +2013-03-01 09:11:58.703072 37.95 29.739999771118164 +2013-03-01 09:11:58.703072 39.3 34.21000003814697 +2013-03-01 09:11:58.703072 45.91 38.625 +2013-03-01 09:11:58.703072 52.44 42.60499954223633 +2013-03-01 09:11:58.703072 54.1 49.17499923706055 +2013-03-01 09:11:58.703072 56.7 53.26999855041504 +2013-03-01 09:11:58.703072 58.77 55.39999961853027 +2013-03-01 09:11:58.703072 62.09 57.73500061035156 +2013-03-01 09:11:58.703072 68.2 60.43000030517578 +2013-03-01 09:11:58.703072 71.68 65.14499855041504 +2013-03-01 09:11:58.703072 79.46 69.93999862670898 +2013-03-01 09:11:58.703072 80.02 75.56999969482422 +PREHOOK: query: select ts, f, avg(f) over (partition by ts order by f rows between unbounded preceding and 1 preceding) from over10k limit 100 +PREHOOK: type: QUERY +PREHOOK: Input: default@over10k +#### A masked pattern was here #### +POSTHOOK: query: select ts, f, avg(f) over (partition by ts order by f rows between unbounded preceding and 1 preceding) from over10k limit 100 +POSTHOOK: type: QUERY +POSTHOOK: Input: default@over10k +#### A masked pattern was here #### +2013-03-01 09:11:58.70307 3.17 NULL +2013-03-01 09:11:58.70307 10.89 3.1700000762939453 +2013-03-01 09:11:58.70307 14.54 7.03000020980835 +2013-03-01 09:11:58.70307 14.78 9.533333460489908 +2013-03-01 09:11:58.70307 17.85 10.84500002861023 +2013-03-01 09:11:58.70307 20.61 12.24600009918213 +2013-03-01 09:11:58.70307 28.69 13.640000184377035 +2013-03-01 09:11:58.70307 29.22 15.790000234331403 +2013-03-01 09:11:58.70307 31.17 17.46875011920929 +2013-03-01 09:11:58.70307 38.35 18.99111122555203 +2013-03-01 09:11:58.70307 38.61 20.926999950408934 +2013-03-01 09:11:58.70307 39.48 22.534545464949176 +2013-03-01 09:11:58.70307 40.54 23.94666663805644 +2013-03-01 09:11:58.70307 41.6 25.22307696709266 +2013-03-01 09:11:58.70307 46.08 26.39285707473755 +2013-03-01 09:11:58.70307 54.36 27.70533339182536 +2013-03-01 09:11:58.70307 56.94 29.371250092983246 +2013-03-01 09:11:58.70307 64.96 30.992941183202408 +2013-03-01 09:11:58.70307 73.52 32.8799999554952 +2013-03-01 09:11:58.70307 78.58 35.01894714957789 +2013-03-01 09:11:58.70307 81.41 37.196999883651735 +2013-03-01 09:11:58.70307 84.71 39.30238101595924 +2013-03-01 09:11:58.70307 87.43 41.36636365543712 +2013-03-01 09:11:58.70307 91.36 43.369130466295324 +2013-03-01 09:11:58.70307 92.96 45.368750055631004 +2013-03-01 09:11:58.70307 95.04 47.272400016784665 +2013-03-01 09:11:58.703071 0.83 NULL +2013-03-01 09:11:58.703071 1.99 0.8299999833106995 +2013-03-01 09:11:58.703071 3.73 1.4099999964237213 +2013-03-01 09:11:58.703071 8.86 2.1833333373069763 +2013-03-01 09:11:58.703071 10.62 3.8524999171495438 +2013-03-01 09:11:58.703071 11.32 5.205999910831451 +2013-03-01 09:11:58.703071 12.83 6.224999874830246 +2013-03-01 09:11:58.703071 14.7 7.168571310383933 +2013-03-01 09:11:58.703071 14.96 8.109999872744083 +2013-03-01 09:11:58.703071 17.58 8.871111002233294 +2013-03-01 09:11:58.703071 19.1 9.74199989438057 +2013-03-01 09:11:58.703071 21.01 10.592727211388675 +2013-03-01 09:11:58.703071 26.95 11.460833296179771 +2013-03-01 09:11:58.703071 27.23 12.652307716699747 +2013-03-01 09:11:58.703071 29.07 13.693571418523788 +2013-03-01 09:11:58.703071 29.71 14.718666636943817 +2013-03-01 09:11:58.703071 31.84 15.65562491491437 +2013-03-01 09:11:58.703071 31.94 16.607646987718695 +2013-03-01 09:11:58.703071 35.32 17.459444406959747 +2013-03-01 09:11:58.703071 37.32 18.399473632636823 +2013-03-01 09:11:58.703071 38.5 19.345499935746194 +2013-03-01 09:11:58.703071 42.08 20.257618986424944 +2013-03-01 09:11:58.703071 44.3 21.249545479362663 +2013-03-01 09:11:58.703071 44.66 22.251739121001698 +2013-03-01 09:11:58.703071 46.84 23.1854166512688 +2013-03-01 09:11:58.703071 48.89 24.131599991321565 +2013-03-01 09:11:58.703071 49.64 25.083846122026443 +2013-03-01 09:11:58.703071 50.28 25.993333280086517 +2013-03-01 09:11:58.703071 52.09 26.8607141907726 +2013-03-01 09:11:58.703071 53.26 27.73068956876623 +2013-03-01 09:11:58.703071 54.09 28.581666527191796 +2013-03-01 09:11:58.703071 56.45 29.40451599897877 +2013-03-01 09:11:58.703071 56.76 30.24968739785254 +2013-03-01 09:11:58.703071 61.41 31.05303015311559 +2013-03-01 09:11:58.703071 61.88 31.945882202947843 +2013-03-01 09:11:58.703071 63.03 32.801142741952624 +2013-03-01 09:11:58.703071 64.55 33.64083318743441 +2013-03-01 09:11:58.703071 68.62 34.47621615674045 +2013-03-01 09:11:58.703071 76.13 35.37473685647312 +2013-03-01 09:11:58.703071 79.05 36.419743533317856 +2013-03-01 09:11:58.703071 80.43 37.48550002127886 +2013-03-01 09:11:58.703071 81.41 38.532926857471466 +2013-03-01 09:11:58.703071 82.85 39.553809638534275 +2013-03-01 09:11:58.703071 83.98 40.56069775098978 +2013-03-01 09:11:58.703071 84.21 41.547500151124865 +2013-03-01 09:11:58.703071 85.55 42.49555568297704 +2013-03-01 09:11:58.703071 87.93 43.43152193012445 +2013-03-01 09:11:58.703071 88.93 44.378298065763836 +2013-03-01 09:11:58.703071 94.27 45.30645852908492 +2013-03-01 09:11:58.703071 99.45 46.305714408962096 +2013-03-01 09:11:58.703072 0.36 NULL +2013-03-01 09:11:58.703072 0.48 0.36000001430511475 +2013-03-01 09:11:58.703072 0.79 0.42000000178813934 +2013-03-01 09:11:58.703072 1.27 0.5433333416779836 +2013-03-01 09:11:58.703072 4.48 0.7250000014901161 +2013-03-01 09:11:58.703072 9.0 1.47600000500679 +2013-03-01 09:11:58.703072 23.27 2.730000004172325 +2013-03-01 09:11:58.703072 25.13 5.664285783256803 +2013-03-01 09:11:58.703072 25.34 8.097499955445528 +2013-03-01 09:11:58.703072 25.91 10.013333310683569 +2013-03-01 09:11:58.703072 29.01 11.602999964356423 +2013-03-01 09:11:58.703072 30.47 13.185454533858733 +2013-03-01 09:11:58.703072 37.95 14.62583326548338 +2013-03-01 09:11:58.703072 39.3 16.419999996056923 +2013-03-01 09:11:58.703072 45.91 18.05428565612861 +2013-03-01 09:11:58.703072 52.44 19.911333268880846 +2013-03-01 09:11:58.703072 54.1 21.944374853745103 +2013-03-01 09:11:58.703072 56.7 23.835882125531924 +2013-03-01 09:11:58.703072 58.77 25.661666494276787 +2013-03-01 09:11:58.703072 62.09 27.404210387091887 +2013-03-01 09:11:58.703072 68.2 29.138499875366687 +2013-03-01 09:11:58.703072 71.68 30.998571164551237 +2013-03-01 09:11:58.703072 79.46 32.84772703457963 +2013-03-01 09:11:58.703072 80.02 34.87434755848802 +PREHOOK: query: select ts, f, avg(f) over (partition by ts order by f rows between 1 following and 2 following) from over10k limit 100 +PREHOOK: type: QUERY +PREHOOK: Input: default@over10k +#### A masked pattern was here #### +POSTHOOK: query: select ts, f, avg(f) over (partition by ts order by f rows between 1 following and 2 following) from over10k limit 100 +POSTHOOK: type: QUERY +POSTHOOK: Input: default@over10k +#### A masked pattern was here #### +2013-03-01 09:11:58.70307 3.17 12.71500015258789 +2013-03-01 09:11:58.70307 10.89 14.65999984741211 +2013-03-01 09:11:58.70307 14.54 16.31500005722046 +2013-03-01 09:11:58.70307 14.78 19.230000495910645 +2013-03-01 09:11:58.70307 17.85 24.65000057220459 +2013-03-01 09:11:58.70307 20.61 28.954999923706055 +2013-03-01 09:11:58.70307 28.69 30.19499969482422 +2013-03-01 09:11:58.70307 29.22 34.75999927520752 +2013-03-01 09:11:58.70307 31.17 38.47999954223633 +2013-03-01 09:11:58.70307 38.35 39.045000076293945 +2013-03-01 09:11:58.70307 38.61 40.010000228881836 +2013-03-01 09:11:58.70307 39.48 41.06999969482422 +2013-03-01 09:11:58.70307 40.54 43.84000015258789 +2013-03-01 09:11:58.70307 41.6 50.220001220703125 +2013-03-01 09:11:58.70307 46.08 55.64999961853027 +2013-03-01 09:11:58.70307 54.36 60.94999885559082 +2013-03-01 09:11:58.70307 56.94 69.23999786376953 +2013-03-01 09:11:58.70307 64.96 76.04999923706055 +2013-03-01 09:11:58.70307 73.52 79.99500274658203 +2013-03-01 09:11:58.70307 78.58 83.06000137329102 +2013-03-01 09:11:58.70307 81.41 86.06999969482422 +2013-03-01 09:11:58.70307 84.71 89.39500045776367 +2013-03-01 09:11:58.70307 87.43 92.15999984741211 +2013-03-01 09:11:58.70307 91.36 94.0 +2013-03-01 09:11:58.70307 92.96 95.04000091552734 +2013-03-01 09:11:58.70307 95.04 NULL +2013-03-01 09:11:58.703071 0.83 2.8600000143051147 +2013-03-01 09:11:58.703071 1.99 6.294999837875366 +2013-03-01 09:11:58.703071 3.73 9.739999771118164 +2013-03-01 09:11:58.703071 8.86 10.96999979019165 +2013-03-01 09:11:58.703071 10.62 12.074999809265137 +2013-03-01 09:11:58.703071 11.32 13.764999866485596 +2013-03-01 09:11:58.703071 12.83 14.829999923706055 +2013-03-01 09:11:58.703071 14.7 16.269999980926514 +2013-03-01 09:11:58.703071 14.96 18.34000015258789 +2013-03-01 09:11:58.703071 17.58 20.05500030517578 +2013-03-01 09:11:58.703071 19.1 23.980000495910645 +2013-03-01 09:11:58.703071 21.01 27.09000015258789 +2013-03-01 09:11:58.703071 26.95 28.149999618530273 +2013-03-01 09:11:58.703071 27.23 29.389999389648438 +2013-03-01 09:11:58.703071 29.07 30.774999618530273 +2013-03-01 09:11:58.703071 29.71 31.890000343322754 +2013-03-01 09:11:58.703071 31.84 33.63000011444092 +2013-03-01 09:11:58.703071 31.94 36.31999969482422 +2013-03-01 09:11:58.703071 35.32 37.90999984741211 +2013-03-01 09:11:58.703071 37.32 40.290000915527344 +2013-03-01 09:11:58.703071 38.5 43.19000053405762 +2013-03-01 09:11:58.703071 42.08 44.47999954223633 +2013-03-01 09:11:58.703071 44.3 45.75 +2013-03-01 09:11:58.703071 44.66 47.864999771118164 +2013-03-01 09:11:58.703071 46.84 49.26499938964844 +2013-03-01 09:11:58.703071 48.89 49.959999084472656 +2013-03-01 09:11:58.703071 49.64 51.18499946594238 +2013-03-01 09:11:58.703071 50.28 52.67499923706055 +2013-03-01 09:11:58.703071 52.09 53.67499923706055 +2013-03-01 09:11:58.703071 53.26 55.27000045776367 +2013-03-01 09:11:58.703071 54.09 56.60499954223633 +2013-03-01 09:11:58.703071 56.45 59.084999084472656 +2013-03-01 09:11:58.703071 56.76 61.64500045776367 +2013-03-01 09:11:58.703071 61.41 62.454999923706055 +2013-03-01 09:11:58.703071 61.88 63.790000915527344 +2013-03-01 09:11:58.703071 63.03 66.58500289916992 +2013-03-01 09:11:58.703071 64.55 72.375 +2013-03-01 09:11:58.703071 68.62 77.59000015258789 +2013-03-01 09:11:58.703071 76.13 79.7400016784668 +2013-03-01 09:11:58.703071 79.05 80.92000198364258 +2013-03-01 09:11:58.703071 80.43 82.13000106811523 +2013-03-01 09:11:58.703071 81.41 83.41500091552734 +2013-03-01 09:11:58.703071 82.85 84.09500122070312 +2013-03-01 09:11:58.703071 83.98 84.88000106811523 +2013-03-01 09:11:58.703071 84.21 86.7400016784668 +2013-03-01 09:11:58.703071 85.55 88.43000030517578 +2013-03-01 09:11:58.703071 87.93 91.5999984741211 +2013-03-01 09:11:58.703071 88.93 96.8599967956543 +2013-03-01 09:11:58.703071 94.27 99.44999694824219 +2013-03-01 09:11:58.703071 99.45 NULL +2013-03-01 09:11:58.703072 0.36 0.635000005364418 +2013-03-01 09:11:58.703072 0.48 1.030000001192093 +2013-03-01 09:11:58.703072 0.79 2.875 +2013-03-01 09:11:58.703072 1.27 6.740000009536743 +2013-03-01 09:11:58.703072 4.48 16.135000228881836 +2013-03-01 09:11:58.703072 9.0 24.199999809265137 +2013-03-01 09:11:58.703072 23.27 25.234999656677246 +2013-03-01 09:11:58.703072 25.13 25.625 +2013-03-01 09:11:58.703072 25.34 27.460000038146973 +2013-03-01 09:11:58.703072 25.91 29.739999771118164 +2013-03-01 09:11:58.703072 29.01 34.21000003814697 +2013-03-01 09:11:58.703072 30.47 38.625 +2013-03-01 09:11:58.703072 37.95 42.60499954223633 +2013-03-01 09:11:58.703072 39.3 49.17499923706055 +2013-03-01 09:11:58.703072 45.91 53.26999855041504 +2013-03-01 09:11:58.703072 52.44 55.39999961853027 +2013-03-01 09:11:58.703072 54.1 57.73500061035156 +2013-03-01 09:11:58.703072 56.7 60.43000030517578 +2013-03-01 09:11:58.703072 58.77 65.14499855041504 +2013-03-01 09:11:58.703072 62.09 69.93999862670898 +2013-03-01 09:11:58.703072 68.2 75.56999969482422 +2013-03-01 09:11:58.703072 71.68 79.73999786376953 +2013-03-01 09:11:58.703072 79.46 80.65499877929688 +2013-03-01 09:11:58.703072 80.02 84.13500213623047 +PREHOOK: query: select ts, f, avg(f) over (partition by ts order by f rows between unbounded preceding and 1 following) from over10k limit 100 +PREHOOK: type: QUERY +PREHOOK: Input: default@over10k +#### A masked pattern was here #### +POSTHOOK: query: select ts, f, avg(f) over (partition by ts order by f rows between unbounded preceding and 1 following) from over10k limit 100 +POSTHOOK: type: QUERY +POSTHOOK: Input: default@over10k +#### A masked pattern was here #### +2013-03-01 09:11:58.70307 3.17 7.03000020980835 +2013-03-01 09:11:58.70307 10.89 9.533333460489908 +2013-03-01 09:11:58.70307 14.54 10.84500002861023 +2013-03-01 09:11:58.70307 14.78 12.24600009918213 +2013-03-01 09:11:58.70307 17.85 13.640000184377035 +2013-03-01 09:11:58.70307 20.61 15.790000234331403 +2013-03-01 09:11:58.70307 28.69 17.46875011920929 +2013-03-01 09:11:58.70307 29.22 18.99111122555203 +2013-03-01 09:11:58.70307 31.17 20.926999950408934 +2013-03-01 09:11:58.70307 38.35 22.534545464949176 +2013-03-01 09:11:58.70307 38.61 23.94666663805644 +2013-03-01 09:11:58.70307 39.48 25.22307696709266 +2013-03-01 09:11:58.70307 40.54 26.39285707473755 +2013-03-01 09:11:58.70307 41.6 27.70533339182536 +2013-03-01 09:11:58.70307 46.08 29.371250092983246 +2013-03-01 09:11:58.70307 54.36 30.992941183202408 +2013-03-01 09:11:58.70307 56.94 32.8799999554952 +2013-03-01 09:11:58.70307 64.96 35.01894714957789 +2013-03-01 09:11:58.70307 73.52 37.196999883651735 +2013-03-01 09:11:58.70307 78.58 39.30238101595924 +2013-03-01 09:11:58.70307 81.41 41.36636365543712 +2013-03-01 09:11:58.70307 84.71 43.369130466295324 +2013-03-01 09:11:58.70307 87.43 45.368750055631004 +2013-03-01 09:11:58.70307 91.36 47.272400016784665 +2013-03-01 09:11:58.70307 92.96 49.10961543596708 +2013-03-01 09:11:58.70307 95.04 49.10961543596708 +2013-03-01 09:11:58.703071 0.83 1.4099999964237213 +2013-03-01 09:11:58.703071 1.99 2.1833333373069763 +2013-03-01 09:11:58.703071 3.73 3.8524999171495438 +2013-03-01 09:11:58.703071 8.86 5.205999910831451 +2013-03-01 09:11:58.703071 10.62 6.224999874830246 +2013-03-01 09:11:58.703071 11.32 7.168571310383933 +2013-03-01 09:11:58.703071 12.83 8.109999872744083 +2013-03-01 09:11:58.703071 14.7 8.871111002233294 +2013-03-01 09:11:58.703071 14.96 9.74199989438057 +2013-03-01 09:11:58.703071 17.58 10.592727211388675 +2013-03-01 09:11:58.703071 19.1 11.460833296179771 +2013-03-01 09:11:58.703071 21.01 12.652307716699747 +2013-03-01 09:11:58.703071 26.95 13.693571418523788 +2013-03-01 09:11:58.703071 27.23 14.718666636943817 +2013-03-01 09:11:58.703071 29.07 15.65562491491437 +2013-03-01 09:11:58.703071 29.71 16.607646987718695 +2013-03-01 09:11:58.703071 31.84 17.459444406959747 +2013-03-01 09:11:58.703071 31.94 18.399473632636823 +2013-03-01 09:11:58.703071 35.32 19.345499935746194 +2013-03-01 09:11:58.703071 37.32 20.257618986424944 +2013-03-01 09:11:58.703071 38.5 21.249545479362663 +2013-03-01 09:11:58.703071 42.08 22.251739121001698 +2013-03-01 09:11:58.703071 44.3 23.1854166512688 +2013-03-01 09:11:58.703071 44.66 24.131599991321565 +2013-03-01 09:11:58.703071 46.84 25.083846122026443 +2013-03-01 09:11:58.703071 48.89 25.993333280086517 +2013-03-01 09:11:58.703071 49.64 26.8607141907726 +2013-03-01 09:11:58.703071 50.28 27.73068956876623 +2013-03-01 09:11:58.703071 52.09 28.581666527191796 +2013-03-01 09:11:58.703071 53.26 29.40451599897877 +2013-03-01 09:11:58.703071 54.09 30.24968739785254 +2013-03-01 09:11:58.703071 56.45 31.05303015311559 +2013-03-01 09:11:58.703071 56.76 31.945882202947843 +2013-03-01 09:11:58.703071 61.41 32.801142741952624 +2013-03-01 09:11:58.703071 61.88 33.64083318743441 +2013-03-01 09:11:58.703071 63.03 34.47621615674045 +2013-03-01 09:11:58.703071 64.55 35.37473685647312 +2013-03-01 09:11:58.703071 68.62 36.419743533317856 +2013-03-01 09:11:58.703071 76.13 37.48550002127886 +2013-03-01 09:11:58.703071 79.05 38.532926857471466 +2013-03-01 09:11:58.703071 80.43 39.553809638534275 +2013-03-01 09:11:58.703071 81.41 40.56069775098978 +2013-03-01 09:11:58.703071 82.85 41.547500151124865 +2013-03-01 09:11:58.703071 83.98 42.49555568297704 +2013-03-01 09:11:58.703071 84.21 43.43152193012445 +2013-03-01 09:11:58.703071 85.55 44.378298065763836 +2013-03-01 09:11:58.703071 87.93 45.30645852908492 +2013-03-01 09:11:58.703071 88.93 46.305714408962096 +2013-03-01 09:11:58.703071 94.27 47.3686000597477 +2013-03-01 09:11:58.703071 99.45 47.3686000597477 +2013-03-01 09:11:58.703072 0.36 0.42000000178813934 +2013-03-01 09:11:58.703072 0.48 0.5433333416779836 +2013-03-01 09:11:58.703072 0.79 0.7250000014901161 +2013-03-01 09:11:58.703072 1.27 1.47600000500679 +2013-03-01 09:11:58.703072 4.48 2.730000004172325 +2013-03-01 09:11:58.703072 9.0 5.664285783256803 +2013-03-01 09:11:58.703072 23.27 8.097499955445528 +2013-03-01 09:11:58.703072 25.13 10.013333310683569 +2013-03-01 09:11:58.703072 25.34 11.602999964356423 +2013-03-01 09:11:58.703072 25.91 13.185454533858733 +2013-03-01 09:11:58.703072 29.01 14.62583326548338 +2013-03-01 09:11:58.703072 30.47 16.419999996056923 +2013-03-01 09:11:58.703072 37.95 18.05428565612861 +2013-03-01 09:11:58.703072 39.3 19.911333268880846 +2013-03-01 09:11:58.703072 45.91 21.944374853745103 +2013-03-01 09:11:58.703072 52.44 23.835882125531924 +2013-03-01 09:11:58.703072 54.1 25.661666494276787 +2013-03-01 09:11:58.703072 56.7 27.404210387091887 +2013-03-01 09:11:58.703072 58.77 29.138499875366687 +2013-03-01 09:11:58.703072 62.09 30.998571164551237 +2013-03-01 09:11:58.703072 68.2 32.84772703457963 +2013-03-01 09:11:58.703072 71.68 34.87434755848802 +2013-03-01 09:11:58.703072 79.46 36.75541627034545 +2013-03-01 09:11:58.703072 80.02 38.53679965615272 PREHOOK: query: -- count select ts, f, count(f) over (partition by ts order by f rows between 2 preceding and 1 preceding) from over10k limit 100 PREHOOK: type: QUERY