hive-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From ga...@apache.org
Subject [23/50] [abbrv] hive git commit: HIVE-10878 : Add tests to cover avg() function for 'x preceding and y preceding' windowing spec (Aihua Xu via Ashutosh Chauhan)
Date Fri, 05 Jun 2015 23:16:36 GMT
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 <hashutosh@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 <aihuaxu@gmail.com>
Authored: Mon Jun 1 07:56:00 2015 -0700
Committer: Ashutosh Chauhan <hashutosh@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


Mime
View raw message