hive-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From prasan...@apache.org
Subject [01/37] hive git commit: HIVE-14877: Move slow CliDriver tests to MiniLlap (Prasanth Jayachandran reviewed by Siddharth Seth)
Date Wed, 12 Oct 2016 07:27:14 GMT
Repository: hive
Updated Branches:
  refs/heads/master 42d997a29 -> 1f258e96a


http://git-wip-us.apache.org/repos/asf/hive/blob/1f258e96/ql/src/test/results/clientpositive/llap/windowing_windowspec2.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/windowing_windowspec2.q.out b/ql/src/test/results/clientpositive/llap/windowing_windowspec2.q.out
new file mode 100644
index 0000000..a88eb6c
--- /dev/null
+++ b/ql/src/test/results/clientpositive/llap/windowing_windowspec2.q.out
@@ -0,0 +1,3084 @@
+PREHOOK: query: drop table over10k
+PREHOOK: type: DROPTABLE
+POSTHOOK: query: drop table over10k
+POSTHOOK: type: DROPTABLE
+PREHOOK: query: create table over10k(
+           t tinyint,
+           si smallint,
+           i int,
+           b bigint,
+           f float,
+           d double,
+           bo boolean,
+           s string,
+	   ts timestamp,
+           dec decimal,
+           bin binary)
+       row format delimited
+       fields terminated by '|'
+PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
+PREHOOK: Output: default@over10k
+POSTHOOK: query: create table over10k(
+           t tinyint,
+           si smallint,
+           i int,
+           b bigint,
+           f float,
+           d double,
+           bo boolean,
+           s string,
+	   ts timestamp,
+           dec decimal,
+           bin binary)
+       row format delimited
+       fields terminated by '|'
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
+POSTHOOK: Output: default@over10k
+PREHOOK: query: load data local inpath '../../data/files/over10k' into table over10k
+PREHOOK: type: LOAD
+#### A masked pattern was here ####
+PREHOOK: Output: default@over10k
+POSTHOOK: query: load data local inpath '../../data/files/over10k' into table over10k
+POSTHOOK: type: LOAD
+#### A masked pattern was here ####
+POSTHOOK: Output: default@over10k
+PREHOOK: query: -- sum
+select ts, 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: -- sum
+select ts, 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 ####
+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	14.0600004196167
+2013-03-01 09:11:58.70307	14.78	25.43000030517578
+2013-03-01 09:11:58.70307	17.85	29.31999969482422
+2013-03-01 09:11:58.70307	20.61	32.63000011444092
+2013-03-01 09:11:58.70307	28.69	38.46000099182129
+2013-03-01 09:11:58.70307	29.22	49.30000114440918
+2013-03-01 09:11:58.70307	31.17	57.90999984741211
+2013-03-01 09:11:58.70307	38.35	60.38999938964844
+2013-03-01 09:11:58.70307	38.61	69.51999855041504
+2013-03-01 09:11:58.70307	39.48	76.95999908447266
+2013-03-01 09:11:58.70307	40.54	78.09000015258789
+2013-03-01 09:11:58.70307	41.6	80.02000045776367
+2013-03-01 09:11:58.70307	46.08	82.13999938964844
+2013-03-01 09:11:58.70307	54.36	87.68000030517578
+2013-03-01 09:11:58.70307	56.94	100.44000244140625
+2013-03-01 09:11:58.70307	64.96	111.29999923706055
+2013-03-01 09:11:58.70307	73.52	121.89999771118164
+2013-03-01 09:11:58.70307	78.58	138.47999572753906
+2013-03-01 09:11:58.70307	81.41	152.0999984741211
+2013-03-01 09:11:58.70307	84.71	159.99000549316406
+2013-03-01 09:11:58.70307	87.43	166.12000274658203
+2013-03-01 09:11:58.70307	91.36	172.13999938964844
+2013-03-01 09:11:58.70307	92.96	178.79000091552734
+2013-03-01 09:11:58.70307	95.04	184.31999969482422
+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	2.8199999928474426
+2013-03-01 09:11:58.703071	8.86	5.7200000286102295
+2013-03-01 09:11:58.703071	10.62	12.589999675750732
+2013-03-01 09:11:58.703071	11.32	19.479999542236328
+2013-03-01 09:11:58.703071	12.83	21.9399995803833
+2013-03-01 09:11:58.703071	14.7	24.149999618530273
+2013-03-01 09:11:58.703071	14.96	27.52999973297119
+2013-03-01 09:11:58.703071	17.58	29.65999984741211
+2013-03-01 09:11:58.703071	19.1	32.53999996185303
+2013-03-01 09:11:58.703071	21.01	36.68000030517578
+2013-03-01 09:11:58.703071	26.95	40.11000061035156
+2013-03-01 09:11:58.703071	27.23	47.96000099182129
+2013-03-01 09:11:58.703071	29.07	54.18000030517578
+2013-03-01 09:11:58.703071	29.71	56.29999923706055
+2013-03-01 09:11:58.703071	31.84	58.779998779296875
+2013-03-01 09:11:58.703071	31.94	61.54999923706055
+2013-03-01 09:11:58.703071	35.32	63.78000068664551
+2013-03-01 09:11:58.703071	37.32	67.26000022888184
+2013-03-01 09:11:58.703071	38.5	72.63999938964844
+2013-03-01 09:11:58.703071	42.08	75.81999969482422
+2013-03-01 09:11:58.703071	44.3	80.58000183105469
+2013-03-01 09:11:58.703071	44.66	86.38000106811523
+2013-03-01 09:11:58.703071	46.84	88.95999908447266
+2013-03-01 09:11:58.703071	48.89	91.5
+2013-03-01 09:11:58.703071	49.64	95.72999954223633
+2013-03-01 09:11:58.703071	50.28	98.52999877929688
+2013-03-01 09:11:58.703071	52.09	99.91999816894531
+2013-03-01 09:11:58.703071	53.26	102.36999893188477
+2013-03-01 09:11:58.703071	54.09	105.3499984741211
+2013-03-01 09:11:58.703071	56.45	107.3499984741211
+2013-03-01 09:11:58.703071	56.76	110.54000091552734
+2013-03-01 09:11:58.703071	61.41	113.20999908447266
+2013-03-01 09:11:58.703071	61.88	118.16999816894531
+2013-03-01 09:11:58.703071	63.03	123.29000091552734
+2013-03-01 09:11:58.703071	64.55	124.90999984741211
+2013-03-01 09:11:58.703071	68.62	127.58000183105469
+2013-03-01 09:11:58.703071	76.13	133.17000579833984
+2013-03-01 09:11:58.703071	79.05	144.75
+2013-03-01 09:11:58.703071	80.43	155.18000030517578
+2013-03-01 09:11:58.703071	81.41	159.4800033569336
+2013-03-01 09:11:58.703071	82.85	161.84000396728516
+2013-03-01 09:11:58.703071	83.98	164.26000213623047
+2013-03-01 09:11:58.703071	84.21	166.8300018310547
+2013-03-01 09:11:58.703071	85.55	168.19000244140625
+2013-03-01 09:11:58.703071	87.93	169.76000213623047
+2013-03-01 09:11:58.703071	88.93	173.4800033569336
+2013-03-01 09:11:58.703071	94.27	176.86000061035156
+2013-03-01 09:11:58.703071	99.45	183.1999969482422
+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.8400000035762787
+2013-03-01 09:11:58.703072	1.27	1.270000010728836
+2013-03-01 09:11:58.703072	4.48	2.060000002384186
+2013-03-01 09:11:58.703072	9.0	5.75
+2013-03-01 09:11:58.703072	23.27	13.480000019073486
+2013-03-01 09:11:58.703072	25.13	32.27000045776367
+2013-03-01 09:11:58.703072	25.34	48.39999961853027
+2013-03-01 09:11:58.703072	25.91	50.46999931335449
+2013-03-01 09:11:58.703072	29.01	51.25
+2013-03-01 09:11:58.703072	30.47	54.920000076293945
+2013-03-01 09:11:58.703072	37.95	59.47999954223633
+2013-03-01 09:11:58.703072	39.3	68.42000007629395
+2013-03-01 09:11:58.703072	45.91	77.25
+2013-03-01 09:11:58.703072	52.44	85.20999908447266
+2013-03-01 09:11:58.703072	54.1	98.3499984741211
+2013-03-01 09:11:58.703072	56.7	106.53999710083008
+2013-03-01 09:11:58.703072	58.77	110.79999923706055
+2013-03-01 09:11:58.703072	62.09	115.47000122070312
+2013-03-01 09:11:58.703072	68.2	120.86000061035156
+2013-03-01 09:11:58.703072	71.68	130.28999710083008
+2013-03-01 09:11:58.703072	79.46	139.87999725341797
+2013-03-01 09:11:58.703072	80.02	151.13999938964844
+PREHOOK: query: select ts, f, sum(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, sum(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	14.0600004196167
+2013-03-01 09:11:58.70307	14.78	28.600000381469727
+2013-03-01 09:11:58.70307	17.85	43.38000011444092
+2013-03-01 09:11:58.70307	20.61	61.230000495910645
+2013-03-01 09:11:58.70307	28.69	81.8400011062622
+2013-03-01 09:11:58.70307	29.22	110.53000164031982
+2013-03-01 09:11:58.70307	31.17	139.75000095367432
+2013-03-01 09:11:58.70307	38.35	170.92000102996826
+2013-03-01 09:11:58.70307	38.61	209.26999950408936
+2013-03-01 09:11:58.70307	39.48	247.88000011444092
+2013-03-01 09:11:58.70307	40.54	287.35999965667725
+2013-03-01 09:11:58.70307	41.6	327.9000005722046
+2013-03-01 09:11:58.70307	46.08	369.4999990463257
+2013-03-01 09:11:58.70307	54.36	415.58000087738037
+2013-03-01 09:11:58.70307	56.94	469.94000148773193
+2013-03-01 09:11:58.70307	64.96	526.8800001144409
+2013-03-01 09:11:58.70307	73.52	591.8399991989136
+2013-03-01 09:11:58.70307	78.58	665.35999584198
+2013-03-01 09:11:58.70307	81.41	743.9399976730347
+2013-03-01 09:11:58.70307	84.71	825.350001335144
+2013-03-01 09:11:58.70307	87.43	910.0600004196167
+2013-03-01 09:11:58.70307	91.36	997.4900007247925
+2013-03-01 09:11:58.70307	92.96	1088.850001335144
+2013-03-01 09:11:58.70307	95.04	1181.8100004196167
+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	2.8199999928474426
+2013-03-01 09:11:58.703071	8.86	6.550000011920929
+2013-03-01 09:11:58.703071	10.62	15.409999668598175
+2013-03-01 09:11:58.703071	11.32	26.029999554157257
+2013-03-01 09:11:58.703071	12.83	37.349999248981476
+2013-03-01 09:11:58.703071	14.7	50.17999917268753
+2013-03-01 09:11:58.703071	14.96	64.87999898195267
+2013-03-01 09:11:58.703071	17.58	79.83999902009964
+2013-03-01 09:11:58.703071	19.1	97.4199989438057
+2013-03-01 09:11:58.703071	21.01	116.51999932527542
+2013-03-01 09:11:58.703071	26.95	137.52999955415726
+2013-03-01 09:11:58.703071	27.23	164.4800003170967
+2013-03-01 09:11:58.703071	29.07	191.70999985933304
+2013-03-01 09:11:58.703071	29.71	220.77999955415726
+2013-03-01 09:11:58.703071	31.84	250.4899986386299
+2013-03-01 09:11:58.703071	31.94	282.3299987912178
+2013-03-01 09:11:58.703071	35.32	314.2699993252754
+2013-03-01 09:11:58.703071	37.32	349.58999902009964
+2013-03-01 09:11:58.703071	38.5	386.90999871492386
+2013-03-01 09:11:58.703071	42.08	425.40999871492386
+2013-03-01 09:11:58.703071	44.3	467.49000054597855
+2013-03-01 09:11:58.703071	44.66	511.7899997830391
+2013-03-01 09:11:58.703071	46.84	556.4499996304512
+2013-03-01 09:11:58.703071	48.89	603.2899997830391
+2013-03-01 09:11:58.703071	49.64	652.1799991726875
+2013-03-01 09:11:58.703071	50.28	701.819998562336
+2013-03-01 09:11:58.703071	52.09	752.0999973416328
+2013-03-01 09:11:58.703071	53.26	804.1899974942207
+2013-03-01 09:11:58.703071	54.09	857.4499958157539
+2013-03-01 09:11:58.703071	56.45	911.5399959683418
+2013-03-01 09:11:58.703071	56.76	967.9899967312813
+2013-03-01 09:11:58.703071	61.41	1024.7499950528145
+2013-03-01 09:11:58.703071	61.88	1086.1599949002266
+2013-03-01 09:11:58.703071	63.03	1148.0399959683418
+2013-03-01 09:11:58.703071	64.55	1211.0699947476387
+2013-03-01 09:11:58.703071	68.62	1275.6199977993965
+2013-03-01 09:11:58.703071	76.13	1344.2400005459785
+2013-03-01 09:11:58.703071	79.05	1420.3699977993965
+2013-03-01 09:11:58.703071	80.43	1499.4200008511543
+2013-03-01 09:11:58.703071	81.41	1579.85000115633
+2013-03-01 09:11:58.703071	82.85	1661.2600048184395
+2013-03-01 09:11:58.703071	83.98	1744.1100032925606
+2013-03-01 09:11:58.703071	84.21	1828.0900066494942
+2013-03-01 09:11:58.703071	85.55	1912.3000057339668
+2013-03-01 09:11:58.703071	87.93	1997.8500087857246
+2013-03-01 09:11:58.703071	88.93	2085.7800090909004
+2013-03-01 09:11:58.703071	94.27	2174.710009396076
+2013-03-01 09:11:58.703071	99.45	2268.9800060391426
+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.8400000035762787
+2013-03-01 09:11:58.703072	1.27	1.6300000250339508
+2013-03-01 09:11:58.703072	4.48	2.9000000059604645
+2013-03-01 09:11:58.703072	9.0	7.380000025033951
+2013-03-01 09:11:58.703072	23.27	16.38000002503395
+2013-03-01 09:11:58.703072	25.13	39.65000048279762
+2013-03-01 09:11:58.703072	25.34	64.77999964356422
+2013-03-01 09:11:58.703072	25.91	90.11999979615211
+2013-03-01 09:11:58.703072	29.01	116.02999964356422
+2013-03-01 09:11:58.703072	30.47	145.03999987244606
+2013-03-01 09:11:58.703072	37.95	175.50999918580055
+2013-03-01 09:11:58.703072	39.3	213.45999994874
+2013-03-01 09:11:58.703072	45.91	252.75999918580055
+2013-03-01 09:11:58.703072	52.44	298.66999903321266
+2013-03-01 09:11:58.703072	54.1	351.10999765992165
+2013-03-01 09:11:58.703072	56.7	405.20999613404274
+2013-03-01 09:11:58.703072	58.77	461.9099968969822
+2013-03-01 09:11:58.703072	62.09	520.6799973547459
+2013-03-01 09:11:58.703072	68.2	582.7699975073338
+2013-03-01 09:11:58.703072	71.68	650.9699944555759
+2013-03-01 09:11:58.703072	79.46	722.6499947607517
+2013-03-01 09:11:58.703072	80.02	802.1099938452244
+PREHOOK: query: select ts, f, sum(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, sum(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	25.43000030517578
+2013-03-01 09:11:58.70307	10.89	29.31999969482422
+2013-03-01 09:11:58.70307	14.54	32.63000011444092
+2013-03-01 09:11:58.70307	14.78	38.46000099182129
+2013-03-01 09:11:58.70307	17.85	49.30000114440918
+2013-03-01 09:11:58.70307	20.61	57.90999984741211
+2013-03-01 09:11:58.70307	28.69	60.38999938964844
+2013-03-01 09:11:58.70307	29.22	69.51999855041504
+2013-03-01 09:11:58.70307	31.17	76.95999908447266
+2013-03-01 09:11:58.70307	38.35	78.09000015258789
+2013-03-01 09:11:58.70307	38.61	80.02000045776367
+2013-03-01 09:11:58.70307	39.48	82.13999938964844
+2013-03-01 09:11:58.70307	40.54	87.68000030517578
+2013-03-01 09:11:58.70307	41.6	100.44000244140625
+2013-03-01 09:11:58.70307	46.08	111.29999923706055
+2013-03-01 09:11:58.70307	54.36	121.89999771118164
+2013-03-01 09:11:58.70307	56.94	138.47999572753906
+2013-03-01 09:11:58.70307	64.96	152.0999984741211
+2013-03-01 09:11:58.70307	73.52	159.99000549316406
+2013-03-01 09:11:58.70307	78.58	166.12000274658203
+2013-03-01 09:11:58.70307	81.41	172.13999938964844
+2013-03-01 09:11:58.70307	84.71	178.79000091552734
+2013-03-01 09:11:58.70307	87.43	184.31999969482422
+2013-03-01 09:11:58.70307	91.36	188.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	5.7200000286102295
+2013-03-01 09:11:58.703071	1.99	12.589999675750732
+2013-03-01 09:11:58.703071	3.73	19.479999542236328
+2013-03-01 09:11:58.703071	8.86	21.9399995803833
+2013-03-01 09:11:58.703071	10.62	24.149999618530273
+2013-03-01 09:11:58.703071	11.32	27.52999973297119
+2013-03-01 09:11:58.703071	12.83	29.65999984741211
+2013-03-01 09:11:58.703071	14.7	32.53999996185303
+2013-03-01 09:11:58.703071	14.96	36.68000030517578
+2013-03-01 09:11:58.703071	17.58	40.11000061035156
+2013-03-01 09:11:58.703071	19.1	47.96000099182129
+2013-03-01 09:11:58.703071	21.01	54.18000030517578
+2013-03-01 09:11:58.703071	26.95	56.29999923706055
+2013-03-01 09:11:58.703071	27.23	58.779998779296875
+2013-03-01 09:11:58.703071	29.07	61.54999923706055
+2013-03-01 09:11:58.703071	29.71	63.78000068664551
+2013-03-01 09:11:58.703071	31.84	67.26000022888184
+2013-03-01 09:11:58.703071	31.94	72.63999938964844
+2013-03-01 09:11:58.703071	35.32	75.81999969482422
+2013-03-01 09:11:58.703071	37.32	80.58000183105469
+2013-03-01 09:11:58.703071	38.5	86.38000106811523
+2013-03-01 09:11:58.703071	42.08	88.95999908447266
+2013-03-01 09:11:58.703071	44.3	91.5
+2013-03-01 09:11:58.703071	44.66	95.72999954223633
+2013-03-01 09:11:58.703071	46.84	98.52999877929688
+2013-03-01 09:11:58.703071	48.89	99.91999816894531
+2013-03-01 09:11:58.703071	49.64	102.36999893188477
+2013-03-01 09:11:58.703071	50.28	105.3499984741211
+2013-03-01 09:11:58.703071	52.09	107.3499984741211
+2013-03-01 09:11:58.703071	53.26	110.54000091552734
+2013-03-01 09:11:58.703071	54.09	113.20999908447266
+2013-03-01 09:11:58.703071	56.45	118.16999816894531
+2013-03-01 09:11:58.703071	56.76	123.29000091552734
+2013-03-01 09:11:58.703071	61.41	124.90999984741211
+2013-03-01 09:11:58.703071	61.88	127.58000183105469
+2013-03-01 09:11:58.703071	63.03	133.17000579833984
+2013-03-01 09:11:58.703071	64.55	144.75
+2013-03-01 09:11:58.703071	68.62	155.18000030517578
+2013-03-01 09:11:58.703071	76.13	159.4800033569336
+2013-03-01 09:11:58.703071	79.05	161.84000396728516
+2013-03-01 09:11:58.703071	80.43	164.26000213623047
+2013-03-01 09:11:58.703071	81.41	166.8300018310547
+2013-03-01 09:11:58.703071	82.85	168.19000244140625
+2013-03-01 09:11:58.703071	83.98	169.76000213623047
+2013-03-01 09:11:58.703071	84.21	173.4800033569336
+2013-03-01 09:11:58.703071	85.55	176.86000061035156
+2013-03-01 09:11:58.703071	87.93	183.1999969482422
+2013-03-01 09:11:58.703071	88.93	193.7199935913086
+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	1.270000010728836
+2013-03-01 09:11:58.703072	0.48	2.060000002384186
+2013-03-01 09:11:58.703072	0.79	5.75
+2013-03-01 09:11:58.703072	1.27	13.480000019073486
+2013-03-01 09:11:58.703072	4.48	32.27000045776367
+2013-03-01 09:11:58.703072	9.0	48.39999961853027
+2013-03-01 09:11:58.703072	23.27	50.46999931335449
+2013-03-01 09:11:58.703072	25.13	51.25
+2013-03-01 09:11:58.703072	25.34	54.920000076293945
+2013-03-01 09:11:58.703072	25.91	59.47999954223633
+2013-03-01 09:11:58.703072	29.01	68.42000007629395
+2013-03-01 09:11:58.703072	30.47	77.25
+2013-03-01 09:11:58.703072	37.95	85.20999908447266
+2013-03-01 09:11:58.703072	39.3	98.3499984741211
+2013-03-01 09:11:58.703072	45.91	106.53999710083008
+2013-03-01 09:11:58.703072	52.44	110.79999923706055
+2013-03-01 09:11:58.703072	54.1	115.47000122070312
+2013-03-01 09:11:58.703072	56.7	120.86000061035156
+2013-03-01 09:11:58.703072	58.77	130.28999710083008
+2013-03-01 09:11:58.703072	62.09	139.87999725341797
+2013-03-01 09:11:58.703072	68.2	151.13999938964844
+2013-03-01 09:11:58.703072	71.68	159.47999572753906
+2013-03-01 09:11:58.703072	79.46	161.30999755859375
+2013-03-01 09:11:58.703072	80.02	168.27000427246094
+PREHOOK: query: select ts, f, sum(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, sum(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	14.0600004196167
+2013-03-01 09:11:58.70307	10.89	28.600000381469727
+2013-03-01 09:11:58.70307	14.54	43.38000011444092
+2013-03-01 09:11:58.70307	14.78	61.230000495910645
+2013-03-01 09:11:58.70307	17.85	81.8400011062622
+2013-03-01 09:11:58.70307	20.61	110.53000164031982
+2013-03-01 09:11:58.70307	28.69	139.75000095367432
+2013-03-01 09:11:58.70307	29.22	170.92000102996826
+2013-03-01 09:11:58.70307	31.17	209.26999950408936
+2013-03-01 09:11:58.70307	38.35	247.88000011444092
+2013-03-01 09:11:58.70307	38.61	287.35999965667725
+2013-03-01 09:11:58.70307	39.48	327.9000005722046
+2013-03-01 09:11:58.70307	40.54	369.4999990463257
+2013-03-01 09:11:58.70307	41.6	415.58000087738037
+2013-03-01 09:11:58.70307	46.08	469.94000148773193
+2013-03-01 09:11:58.70307	54.36	526.8800001144409
+2013-03-01 09:11:58.70307	56.94	591.8399991989136
+2013-03-01 09:11:58.70307	64.96	665.35999584198
+2013-03-01 09:11:58.70307	73.52	743.9399976730347
+2013-03-01 09:11:58.70307	78.58	825.350001335144
+2013-03-01 09:11:58.70307	81.41	910.0600004196167
+2013-03-01 09:11:58.70307	84.71	997.4900007247925
+2013-03-01 09:11:58.70307	87.43	1088.850001335144
+2013-03-01 09:11:58.70307	91.36	1181.8100004196167
+2013-03-01 09:11:58.70307	92.96	1276.850001335144
+2013-03-01 09:11:58.70307	95.04	1276.850001335144
+2013-03-01 09:11:58.703071	0.83	2.8199999928474426
+2013-03-01 09:11:58.703071	1.99	6.550000011920929
+2013-03-01 09:11:58.703071	3.73	15.409999668598175
+2013-03-01 09:11:58.703071	8.86	26.029999554157257
+2013-03-01 09:11:58.703071	10.62	37.349999248981476
+2013-03-01 09:11:58.703071	11.32	50.17999917268753
+2013-03-01 09:11:58.703071	12.83	64.87999898195267
+2013-03-01 09:11:58.703071	14.7	79.83999902009964
+2013-03-01 09:11:58.703071	14.96	97.4199989438057
+2013-03-01 09:11:58.703071	17.58	116.51999932527542
+2013-03-01 09:11:58.703071	19.1	137.52999955415726
+2013-03-01 09:11:58.703071	21.01	164.4800003170967
+2013-03-01 09:11:58.703071	26.95	191.70999985933304
+2013-03-01 09:11:58.703071	27.23	220.77999955415726
+2013-03-01 09:11:58.703071	29.07	250.4899986386299
+2013-03-01 09:11:58.703071	29.71	282.3299987912178
+2013-03-01 09:11:58.703071	31.84	314.2699993252754
+2013-03-01 09:11:58.703071	31.94	349.58999902009964
+2013-03-01 09:11:58.703071	35.32	386.90999871492386
+2013-03-01 09:11:58.703071	37.32	425.40999871492386
+2013-03-01 09:11:58.703071	38.5	467.49000054597855
+2013-03-01 09:11:58.703071	42.08	511.7899997830391
+2013-03-01 09:11:58.703071	44.3	556.4499996304512
+2013-03-01 09:11:58.703071	44.66	603.2899997830391
+2013-03-01 09:11:58.703071	46.84	652.1799991726875
+2013-03-01 09:11:58.703071	48.89	701.819998562336
+2013-03-01 09:11:58.703071	49.64	752.0999973416328
+2013-03-01 09:11:58.703071	50.28	804.1899974942207
+2013-03-01 09:11:58.703071	52.09	857.4499958157539
+2013-03-01 09:11:58.703071	53.26	911.5399959683418
+2013-03-01 09:11:58.703071	54.09	967.9899967312813
+2013-03-01 09:11:58.703071	56.45	1024.7499950528145
+2013-03-01 09:11:58.703071	56.76	1086.1599949002266
+2013-03-01 09:11:58.703071	61.41	1148.0399959683418
+2013-03-01 09:11:58.703071	61.88	1211.0699947476387
+2013-03-01 09:11:58.703071	63.03	1275.6199977993965
+2013-03-01 09:11:58.703071	64.55	1344.2400005459785
+2013-03-01 09:11:58.703071	68.62	1420.3699977993965
+2013-03-01 09:11:58.703071	76.13	1499.4200008511543
+2013-03-01 09:11:58.703071	79.05	1579.85000115633
+2013-03-01 09:11:58.703071	80.43	1661.2600048184395
+2013-03-01 09:11:58.703071	81.41	1744.1100032925606
+2013-03-01 09:11:58.703071	82.85	1828.0900066494942
+2013-03-01 09:11:58.703071	83.98	1912.3000057339668
+2013-03-01 09:11:58.703071	84.21	1997.8500087857246
+2013-03-01 09:11:58.703071	85.55	2085.7800090909004
+2013-03-01 09:11:58.703071	87.93	2174.710009396076
+2013-03-01 09:11:58.703071	88.93	2268.9800060391426
+2013-03-01 09:11:58.703071	94.27	2368.430002987385
+2013-03-01 09:11:58.703071	99.45	2368.430002987385
+2013-03-01 09:11:58.703072	0.36	0.8400000035762787
+2013-03-01 09:11:58.703072	0.48	1.6300000250339508
+2013-03-01 09:11:58.703072	0.79	2.9000000059604645
+2013-03-01 09:11:58.703072	1.27	7.380000025033951
+2013-03-01 09:11:58.703072	4.48	16.38000002503395
+2013-03-01 09:11:58.703072	9.0	39.65000048279762
+2013-03-01 09:11:58.703072	23.27	64.77999964356422
+2013-03-01 09:11:58.703072	25.13	90.11999979615211
+2013-03-01 09:11:58.703072	25.34	116.02999964356422
+2013-03-01 09:11:58.703072	25.91	145.03999987244606
+2013-03-01 09:11:58.703072	29.01	175.50999918580055
+2013-03-01 09:11:58.703072	30.47	213.45999994874
+2013-03-01 09:11:58.703072	37.95	252.75999918580055
+2013-03-01 09:11:58.703072	39.3	298.66999903321266
+2013-03-01 09:11:58.703072	45.91	351.10999765992165
+2013-03-01 09:11:58.703072	52.44	405.20999613404274
+2013-03-01 09:11:58.703072	54.1	461.9099968969822
+2013-03-01 09:11:58.703072	56.7	520.6799973547459
+2013-03-01 09:11:58.703072	58.77	582.7699975073338
+2013-03-01 09:11:58.703072	62.09	650.9699944555759
+2013-03-01 09:11:58.703072	68.2	722.6499947607517
+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
+PREHOOK: Input: default@over10k
+#### A masked pattern was here ####
+POSTHOOK: 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
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@over10k
+#### A masked pattern was here ####
+2013-03-01 09:11:58.70307	3.17	0
+2013-03-01 09:11:58.70307	10.89	1
+2013-03-01 09:11:58.70307	14.54	2
+2013-03-01 09:11:58.70307	14.78	2
+2013-03-01 09:11:58.70307	17.85	2
+2013-03-01 09:11:58.70307	20.61	2
+2013-03-01 09:11:58.70307	28.69	2
+2013-03-01 09:11:58.70307	29.22	2
+2013-03-01 09:11:58.70307	31.17	2
+2013-03-01 09:11:58.70307	38.35	2
+2013-03-01 09:11:58.70307	38.61	2
+2013-03-01 09:11:58.70307	39.48	2
+2013-03-01 09:11:58.70307	40.54	2
+2013-03-01 09:11:58.70307	41.6	2
+2013-03-01 09:11:58.70307	46.08	2
+2013-03-01 09:11:58.70307	54.36	2
+2013-03-01 09:11:58.70307	56.94	2
+2013-03-01 09:11:58.70307	64.96	2
+2013-03-01 09:11:58.70307	73.52	2
+2013-03-01 09:11:58.70307	78.58	2
+2013-03-01 09:11:58.70307	81.41	2
+2013-03-01 09:11:58.70307	84.71	2
+2013-03-01 09:11:58.70307	87.43	2
+2013-03-01 09:11:58.70307	91.36	2
+2013-03-01 09:11:58.70307	92.96	2
+2013-03-01 09:11:58.70307	95.04	2
+2013-03-01 09:11:58.703071	0.83	0
+2013-03-01 09:11:58.703071	1.99	1
+2013-03-01 09:11:58.703071	3.73	2
+2013-03-01 09:11:58.703071	8.86	2
+2013-03-01 09:11:58.703071	10.62	2
+2013-03-01 09:11:58.703071	11.32	2
+2013-03-01 09:11:58.703071	12.83	2
+2013-03-01 09:11:58.703071	14.7	2
+2013-03-01 09:11:58.703071	14.96	2
+2013-03-01 09:11:58.703071	17.58	2
+2013-03-01 09:11:58.703071	19.1	2
+2013-03-01 09:11:58.703071	21.01	2
+2013-03-01 09:11:58.703071	26.95	2
+2013-03-01 09:11:58.703071	27.23	2
+2013-03-01 09:11:58.703071	29.07	2
+2013-03-01 09:11:58.703071	29.71	2
+2013-03-01 09:11:58.703071	31.84	2
+2013-03-01 09:11:58.703071	31.94	2
+2013-03-01 09:11:58.703071	35.32	2
+2013-03-01 09:11:58.703071	37.32	2
+2013-03-01 09:11:58.703071	38.5	2
+2013-03-01 09:11:58.703071	42.08	2
+2013-03-01 09:11:58.703071	44.3	2
+2013-03-01 09:11:58.703071	44.66	2
+2013-03-01 09:11:58.703071	46.84	2
+2013-03-01 09:11:58.703071	48.89	2
+2013-03-01 09:11:58.703071	49.64	2
+2013-03-01 09:11:58.703071	50.28	2
+2013-03-01 09:11:58.703071	52.09	2
+2013-03-01 09:11:58.703071	53.26	2
+2013-03-01 09:11:58.703071	54.09	2
+2013-03-01 09:11:58.703071	56.45	2
+2013-03-01 09:11:58.703071	56.76	2
+2013-03-01 09:11:58.703071	61.41	2
+2013-03-01 09:11:58.703071	61.88	2
+2013-03-01 09:11:58.703071	63.03	2
+2013-03-01 09:11:58.703071	64.55	2
+2013-03-01 09:11:58.703071	68.62	2
+2013-03-01 09:11:58.703071	76.13	2
+2013-03-01 09:11:58.703071	79.05	2
+2013-03-01 09:11:58.703071	80.43	2
+2013-03-01 09:11:58.703071	81.41	2
+2013-03-01 09:11:58.703071	82.85	2
+2013-03-01 09:11:58.703071	83.98	2
+2013-03-01 09:11:58.703071	84.21	2
+2013-03-01 09:11:58.703071	85.55	2
+2013-03-01 09:11:58.703071	87.93	2
+2013-03-01 09:11:58.703071	88.93	2
+2013-03-01 09:11:58.703071	94.27	2
+2013-03-01 09:11:58.703071	99.45	2
+2013-03-01 09:11:58.703072	0.36	0
+2013-03-01 09:11:58.703072	0.48	1
+2013-03-01 09:11:58.703072	0.79	2
+2013-03-01 09:11:58.703072	1.27	2
+2013-03-01 09:11:58.703072	4.48	2
+2013-03-01 09:11:58.703072	9.0	2
+2013-03-01 09:11:58.703072	23.27	2
+2013-03-01 09:11:58.703072	25.13	2
+2013-03-01 09:11:58.703072	25.34	2
+2013-03-01 09:11:58.703072	25.91	2
+2013-03-01 09:11:58.703072	29.01	2
+2013-03-01 09:11:58.703072	30.47	2
+2013-03-01 09:11:58.703072	37.95	2
+2013-03-01 09:11:58.703072	39.3	2
+2013-03-01 09:11:58.703072	45.91	2
+2013-03-01 09:11:58.703072	52.44	2
+2013-03-01 09:11:58.703072	54.1	2
+2013-03-01 09:11:58.703072	56.7	2
+2013-03-01 09:11:58.703072	58.77	2
+2013-03-01 09:11:58.703072	62.09	2
+2013-03-01 09:11:58.703072	68.2	2
+2013-03-01 09:11:58.703072	71.68	2
+2013-03-01 09:11:58.703072	79.46	2
+2013-03-01 09:11:58.703072	80.02	2
+PREHOOK: query: select ts, f, count(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, count(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	0
+2013-03-01 09:11:58.70307	10.89	1
+2013-03-01 09:11:58.70307	14.54	2
+2013-03-01 09:11:58.70307	14.78	3
+2013-03-01 09:11:58.70307	17.85	4
+2013-03-01 09:11:58.70307	20.61	5
+2013-03-01 09:11:58.70307	28.69	6
+2013-03-01 09:11:58.70307	29.22	7
+2013-03-01 09:11:58.70307	31.17	8
+2013-03-01 09:11:58.70307	38.35	9
+2013-03-01 09:11:58.70307	38.61	10
+2013-03-01 09:11:58.70307	39.48	11
+2013-03-01 09:11:58.70307	40.54	12
+2013-03-01 09:11:58.70307	41.6	13
+2013-03-01 09:11:58.70307	46.08	14
+2013-03-01 09:11:58.70307	54.36	15
+2013-03-01 09:11:58.70307	56.94	16
+2013-03-01 09:11:58.70307	64.96	17
+2013-03-01 09:11:58.70307	73.52	18
+2013-03-01 09:11:58.70307	78.58	19
+2013-03-01 09:11:58.70307	81.41	20
+2013-03-01 09:11:58.70307	84.71	21
+2013-03-01 09:11:58.70307	87.43	22
+2013-03-01 09:11:58.70307	91.36	23
+2013-03-01 09:11:58.70307	92.96	24
+2013-03-01 09:11:58.70307	95.04	25
+2013-03-01 09:11:58.703071	0.83	0
+2013-03-01 09:11:58.703071	1.99	1
+2013-03-01 09:11:58.703071	3.73	2
+2013-03-01 09:11:58.703071	8.86	3
+2013-03-01 09:11:58.703071	10.62	4
+2013-03-01 09:11:58.703071	11.32	5
+2013-03-01 09:11:58.703071	12.83	6
+2013-03-01 09:11:58.703071	14.7	7
+2013-03-01 09:11:58.703071	14.96	8
+2013-03-01 09:11:58.703071	17.58	9
+2013-03-01 09:11:58.703071	19.1	10
+2013-03-01 09:11:58.703071	21.01	11
+2013-03-01 09:11:58.703071	26.95	12
+2013-03-01 09:11:58.703071	27.23	13
+2013-03-01 09:11:58.703071	29.07	14
+2013-03-01 09:11:58.703071	29.71	15
+2013-03-01 09:11:58.703071	31.84	16
+2013-03-01 09:11:58.703071	31.94	17
+2013-03-01 09:11:58.703071	35.32	18
+2013-03-01 09:11:58.703071	37.32	19
+2013-03-01 09:11:58.703071	38.5	20
+2013-03-01 09:11:58.703071	42.08	21
+2013-03-01 09:11:58.703071	44.3	22
+2013-03-01 09:11:58.703071	44.66	23
+2013-03-01 09:11:58.703071	46.84	24
+2013-03-01 09:11:58.703071	48.89	25
+2013-03-01 09:11:58.703071	49.64	26
+2013-03-01 09:11:58.703071	50.28	27
+2013-03-01 09:11:58.703071	52.09	28
+2013-03-01 09:11:58.703071	53.26	29
+2013-03-01 09:11:58.703071	54.09	30
+2013-03-01 09:11:58.703071	56.45	31
+2013-03-01 09:11:58.703071	56.76	32
+2013-03-01 09:11:58.703071	61.41	33
+2013-03-01 09:11:58.703071	61.88	34
+2013-03-01 09:11:58.703071	63.03	35
+2013-03-01 09:11:58.703071	64.55	36
+2013-03-01 09:11:58.703071	68.62	37
+2013-03-01 09:11:58.703071	76.13	38
+2013-03-01 09:11:58.703071	79.05	39
+2013-03-01 09:11:58.703071	80.43	40
+2013-03-01 09:11:58.703071	81.41	41
+2013-03-01 09:11:58.703071	82.85	42
+2013-03-01 09:11:58.703071	83.98	43
+2013-03-01 09:11:58.703071	84.21	44
+2013-03-01 09:11:58.703071	85.55	45
+2013-03-01 09:11:58.703071	87.93	46
+2013-03-01 09:11:58.703071	88.93	47
+2013-03-01 09:11:58.703071	94.27	48
+2013-03-01 09:11:58.703071	99.45	49
+2013-03-01 09:11:58.703072	0.36	0
+2013-03-01 09:11:58.703072	0.48	1
+2013-03-01 09:11:58.703072	0.79	2
+2013-03-01 09:11:58.703072	1.27	3
+2013-03-01 09:11:58.703072	4.48	4
+2013-03-01 09:11:58.703072	9.0	5
+2013-03-01 09:11:58.703072	23.27	6
+2013-03-01 09:11:58.703072	25.13	7
+2013-03-01 09:11:58.703072	25.34	8
+2013-03-01 09:11:58.703072	25.91	9
+2013-03-01 09:11:58.703072	29.01	10
+2013-03-01 09:11:58.703072	30.47	11
+2013-03-01 09:11:58.703072	37.95	12
+2013-03-01 09:11:58.703072	39.3	13
+2013-03-01 09:11:58.703072	45.91	14
+2013-03-01 09:11:58.703072	52.44	15
+2013-03-01 09:11:58.703072	54.1	16
+2013-03-01 09:11:58.703072	56.7	17
+2013-03-01 09:11:58.703072	58.77	18
+2013-03-01 09:11:58.703072	62.09	19
+2013-03-01 09:11:58.703072	68.2	20
+2013-03-01 09:11:58.703072	71.68	21
+2013-03-01 09:11:58.703072	79.46	22
+2013-03-01 09:11:58.703072	80.02	23
+PREHOOK: query: select ts, f, count(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, count(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	2
+2013-03-01 09:11:58.70307	10.89	2
+2013-03-01 09:11:58.70307	14.54	2
+2013-03-01 09:11:58.70307	14.78	2
+2013-03-01 09:11:58.70307	17.85	2
+2013-03-01 09:11:58.70307	20.61	2
+2013-03-01 09:11:58.70307	28.69	2
+2013-03-01 09:11:58.70307	29.22	2
+2013-03-01 09:11:58.70307	31.17	2
+2013-03-01 09:11:58.70307	38.35	2
+2013-03-01 09:11:58.70307	38.61	2
+2013-03-01 09:11:58.70307	39.48	2
+2013-03-01 09:11:58.70307	40.54	2
+2013-03-01 09:11:58.70307	41.6	2
+2013-03-01 09:11:58.70307	46.08	2
+2013-03-01 09:11:58.70307	54.36	2
+2013-03-01 09:11:58.70307	56.94	2
+2013-03-01 09:11:58.70307	64.96	2
+2013-03-01 09:11:58.70307	73.52	2
+2013-03-01 09:11:58.70307	78.58	2
+2013-03-01 09:11:58.70307	81.41	2
+2013-03-01 09:11:58.70307	84.71	2
+2013-03-01 09:11:58.70307	87.43	2
+2013-03-01 09:11:58.70307	91.36	2
+2013-03-01 09:11:58.70307	92.96	1
+2013-03-01 09:11:58.70307	95.04	0
+2013-03-01 09:11:58.703071	0.83	2
+2013-03-01 09:11:58.703071	1.99	2
+2013-03-01 09:11:58.703071	3.73	2
+2013-03-01 09:11:58.703071	8.86	2
+2013-03-01 09:11:58.703071	10.62	2
+2013-03-01 09:11:58.703071	11.32	2
+2013-03-01 09:11:58.703071	12.83	2
+2013-03-01 09:11:58.703071	14.7	2
+2013-03-01 09:11:58.703071	14.96	2
+2013-03-01 09:11:58.703071	17.58	2
+2013-03-01 09:11:58.703071	19.1	2
+2013-03-01 09:11:58.703071	21.01	2
+2013-03-01 09:11:58.703071	26.95	2
+2013-03-01 09:11:58.703071	27.23	2
+2013-03-01 09:11:58.703071	29.07	2
+2013-03-01 09:11:58.703071	29.71	2
+2013-03-01 09:11:58.703071	31.84	2
+2013-03-01 09:11:58.703071	31.94	2
+2013-03-01 09:11:58.703071	35.32	2
+2013-03-01 09:11:58.703071	37.32	2
+2013-03-01 09:11:58.703071	38.5	2
+2013-03-01 09:11:58.703071	42.08	2
+2013-03-01 09:11:58.703071	44.3	2
+2013-03-01 09:11:58.703071	44.66	2
+2013-03-01 09:11:58.703071	46.84	2
+2013-03-01 09:11:58.703071	48.89	2
+2013-03-01 09:11:58.703071	49.64	2
+2013-03-01 09:11:58.703071	50.28	2
+2013-03-01 09:11:58.703071	52.09	2
+2013-03-01 09:11:58.703071	53.26	2
+2013-03-01 09:11:58.703071	54.09	2
+2013-03-01 09:11:58.703071	56.45	2
+2013-03-01 09:11:58.703071	56.76	2
+2013-03-01 09:11:58.703071	61.41	2
+2013-03-01 09:11:58.703071	61.88	2
+2013-03-01 09:11:58.703071	63.03	2
+2013-03-01 09:11:58.703071	64.55	2
+2013-03-01 09:11:58.703071	68.62	2
+2013-03-01 09:11:58.703071	76.13	2
+2013-03-01 09:11:58.703071	79.05	2
+2013-03-01 09:11:58.703071	80.43	2
+2013-03-01 09:11:58.703071	81.41	2
+2013-03-01 09:11:58.703071	82.85	2
+2013-03-01 09:11:58.703071	83.98	2
+2013-03-01 09:11:58.703071	84.21	2
+2013-03-01 09:11:58.703071	85.55	2
+2013-03-01 09:11:58.703071	87.93	2
+2013-03-01 09:11:58.703071	88.93	2
+2013-03-01 09:11:58.703071	94.27	1
+2013-03-01 09:11:58.703071	99.45	0
+2013-03-01 09:11:58.703072	0.36	2
+2013-03-01 09:11:58.703072	0.48	2
+2013-03-01 09:11:58.703072	0.79	2
+2013-03-01 09:11:58.703072	1.27	2
+2013-03-01 09:11:58.703072	4.48	2
+2013-03-01 09:11:58.703072	9.0	2
+2013-03-01 09:11:58.703072	23.27	2
+2013-03-01 09:11:58.703072	25.13	2
+2013-03-01 09:11:58.703072	25.34	2
+2013-03-01 09:11:58.703072	25.91	2
+2013-03-01 09:11:58.703072	29.01	2
+2013-03-01 09:11:58.703072	30.47	2
+2013-03-01 09:11:58.703072	37.95	2
+2013-03-01 09:11:58.703072	39.3	2
+2013-03-01 09:11:58.703072	45.91	2
+2013-03-01 09:11:58.703072	52.44	2
+2013-03-01 09:11:58.703072	54.1	2
+2013-03-01 09:11:58.703072	56.7	2
+2013-03-01 09:11:58.703072	58.77	2
+2013-03-01 09:11:58.703072	62.09	2
+2013-03-01 09:11:58.703072	68.2	2
+2013-03-01 09:11:58.703072	71.68	2
+2013-03-01 09:11:58.703072	79.46	2
+2013-03-01 09:11:58.703072	80.02	2
+PREHOOK: query: select ts, f, count(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, count(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	2
+2013-03-01 09:11:58.70307	10.89	3
+2013-03-01 09:11:58.70307	14.54	4
+2013-03-01 09:11:58.70307	14.78	5
+2013-03-01 09:11:58.70307	17.85	6
+2013-03-01 09:11:58.70307	20.61	7
+2013-03-01 09:11:58.70307	28.69	8
+2013-03-01 09:11:58.70307	29.22	9
+2013-03-01 09:11:58.70307	31.17	10
+2013-03-01 09:11:58.70307	38.35	11
+2013-03-01 09:11:58.70307	38.61	12
+2013-03-01 09:11:58.70307	39.48	13
+2013-03-01 09:11:58.70307	40.54	14
+2013-03-01 09:11:58.70307	41.6	15
+2013-03-01 09:11:58.70307	46.08	16
+2013-03-01 09:11:58.70307	54.36	17
+2013-03-01 09:11:58.70307	56.94	18
+2013-03-01 09:11:58.70307	64.96	19
+2013-03-01 09:11:58.70307	73.52	20
+2013-03-01 09:11:58.70307	78.58	21
+2013-03-01 09:11:58.70307	81.41	22
+2013-03-01 09:11:58.70307	84.71	23
+2013-03-01 09:11:58.70307	87.43	24
+2013-03-01 09:11:58.70307	91.36	25
+2013-03-01 09:11:58.70307	92.96	26
+2013-03-01 09:11:58.70307	95.04	26
+2013-03-01 09:11:58.703071	0.83	2
+2013-03-01 09:11:58.703071	1.99	3
+2013-03-01 09:11:58.703071	3.73	4
+2013-03-01 09:11:58.703071	8.86	5
+2013-03-01 09:11:58.703071	10.62	6
+2013-03-01 09:11:58.703071	11.32	7
+2013-03-01 09:11:58.703071	12.83	8
+2013-03-01 09:11:58.703071	14.7	9
+2013-03-01 09:11:58.703071	14.96	10
+2013-03-01 09:11:58.703071	17.58	11
+2013-03-01 09:11:58.703071	19.1	12
+2013-03-01 09:11:58.703071	21.01	13
+2013-03-01 09:11:58.703071	26.95	14
+2013-03-01 09:11:58.703071	27.23	15
+2013-03-01 09:11:58.703071	29.07	16
+2013-03-01 09:11:58.703071	29.71	17
+2013-03-01 09:11:58.703071	31.84	18
+2013-03-01 09:11:58.703071	31.94	19
+2013-03-01 09:11:58.703071	35.32	20
+2013-03-01 09:11:58.703071	37.32	21
+2013-03-01 09:11:58.703071	38.5	22
+2013-03-01 09:11:58.703071	42.08	23
+2013-03-01 09:11:58.703071	44.3	24
+2013-03-01 09:11:58.703071	44.66	25
+2013-03-01 09:11:58.703071	46.84	26
+2013-03-01 09:11:58.703071	48.89	27
+2013-03-01 09:11:58.703071	49.64	28
+2013-03-01 09:11:58.703071	50.28	29
+2013-03-01 09:11:58.703071	52.09	30
+2013-03-01 09:11:58.703071	53.26	31
+2013-03-01 09:11:58.703071	54.09	32
+2013-03-01 09:11:58.703071	56.45	33
+2013-03-01 09:11:58.703071	56.76	34
+2013-03-01 09:11:58.703071	61.41	35
+2013-03-01 09:11:58.703071	61.88	36
+2013-03-01 09:11:58.703071	63.03	37
+2013-03-01 09:11:58.703071	64.55	38
+2013-03-01 09:11:58.703071	68.62	39
+2013-03-01 09:11:58.703071	76.13	40
+2013-03-01 09:11:58.703071	79.05	41
+2013-03-01 09:11:58.703071	80.43	42
+2013-03-01 09:11:58.703071	81.41	43
+2013-03-01 09:11:58.703071	82.85	44
+2013-03-01 09:11:58.703071	83.98	45
+2013-03-01 09:11:58.703071	84.21	46
+2013-03-01 09:11:58.703071	85.55	47
+2013-03-01 09:11:58.703071	87.93	48
+2013-03-01 09:11:58.703071	88.93	49
+2013-03-01 09:11:58.703071	94.27	50
+2013-03-01 09:11:58.703071	99.45	50
+2013-03-01 09:11:58.703072	0.36	2
+2013-03-01 09:11:58.703072	0.48	3
+2013-03-01 09:11:58.703072	0.79	4
+2013-03-01 09:11:58.703072	1.27	5
+2013-03-01 09:11:58.703072	4.48	6
+2013-03-01 09:11:58.703072	9.0	7
+2013-03-01 09:11:58.703072	23.27	8
+2013-03-01 09:11:58.703072	25.13	9
+2013-03-01 09:11:58.703072	25.34	10
+2013-03-01 09:11:58.703072	25.91	11
+2013-03-01 09:11:58.703072	29.01	12
+2013-03-01 09:11:58.703072	30.47	13
+2013-03-01 09:11:58.703072	37.95	14
+2013-03-01 09:11:58.703072	39.3	15
+2013-03-01 09:11:58.703072	45.91	16
+2013-03-01 09:11:58.703072	52.44	17
+2013-03-01 09:11:58.703072	54.1	18
+2013-03-01 09:11:58.703072	56.7	19
+2013-03-01 09:11:58.703072	58.77	20
+2013-03-01 09:11:58.703072	62.09	21
+2013-03-01 09:11:58.703072	68.2	22
+2013-03-01 09:11:58.703072	71.68	23
+2013-03-01 09:11:58.703072	79.46	24
+2013-03-01 09:11:58.703072	80.02	25
+PREHOOK: query: -- max
+select ts, f, max(f) over (partition by ts order by t,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: -- max
+select ts, f, max(f) over (partition by ts order by t,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	14.54	NULL
+2013-03-01 09:11:58.70307	29.22	14.54
+2013-03-01 09:11:58.70307	39.48	29.22
+2013-03-01 09:11:58.70307	17.85	39.48
+2013-03-01 09:11:58.70307	31.17	39.48
+2013-03-01 09:11:58.70307	56.94	31.17
+2013-03-01 09:11:58.70307	78.58	56.94
+2013-03-01 09:11:58.70307	14.78	78.58
+2013-03-01 09:11:58.70307	38.61	78.58
+2013-03-01 09:11:58.70307	91.36	38.61
+2013-03-01 09:11:58.70307	28.69	91.36
+2013-03-01 09:11:58.70307	73.52	91.36
+2013-03-01 09:11:58.70307	92.96	73.52
+2013-03-01 09:11:58.70307	95.04	92.96
+2013-03-01 09:11:58.70307	41.6	95.04
+2013-03-01 09:11:58.70307	64.96	95.04
+2013-03-01 09:11:58.70307	84.71	64.96
+2013-03-01 09:11:58.70307	81.41	84.71
+2013-03-01 09:11:58.70307	10.89	84.71
+2013-03-01 09:11:58.70307	20.61	81.41
+2013-03-01 09:11:58.70307	54.36	20.61
+2013-03-01 09:11:58.70307	87.43	54.36
+2013-03-01 09:11:58.70307	46.08	87.43
+2013-03-01 09:11:58.70307	40.54	87.43
+2013-03-01 09:11:58.70307	38.35	46.08
+2013-03-01 09:11:58.70307	3.17	40.54
+2013-03-01 09:11:58.703071	0.83	NULL
+2013-03-01 09:11:58.703071	56.76	0.83
+2013-03-01 09:11:58.703071	99.45	56.76
+2013-03-01 09:11:58.703071	79.05	99.45
+2013-03-01 09:11:58.703071	14.96	99.45
+2013-03-01 09:11:58.703071	85.55	79.05
+2013-03-01 09:11:58.703071	14.7	85.55
+2013-03-01 09:11:58.703071	81.41	85.55
+2013-03-01 09:11:58.703071	87.93	81.41
+2013-03-01 09:11:58.703071	26.95	87.93
+2013-03-01 09:11:58.703071	37.32	87.93
+2013-03-01 09:11:58.703071	68.62	37.32
+2013-03-01 09:11:58.703071	80.43	68.62
+2013-03-01 09:11:58.703071	54.09	80.43
+2013-03-01 09:11:58.703071	42.08	80.43
+2013-03-01 09:11:58.703071	48.89	54.09
+2013-03-01 09:11:58.703071	64.55	48.89
+2013-03-01 09:11:58.703071	56.45	64.55
+2013-03-01 09:11:58.703071	1.99	64.55
+2013-03-01 09:11:58.703071	94.27	56.45
+2013-03-01 09:11:58.703071	35.32	94.27
+2013-03-01 09:11:58.703071	10.62	94.27
+2013-03-01 09:11:58.703071	52.09	35.32
+2013-03-01 09:11:58.703071	63.03	52.09
+2013-03-01 09:11:58.703071	76.13	63.03
+2013-03-01 09:11:58.703071	44.3	76.13
+2013-03-01 09:11:58.703071	44.66	76.13
+2013-03-01 09:11:58.703071	17.58	44.66
+2013-03-01 09:11:58.703071	11.32	44.66
+2013-03-01 09:11:58.703071	38.5	17.58
+2013-03-01 09:11:58.703071	82.85	38.5
+2013-03-01 09:11:58.703071	49.64	82.85
+2013-03-01 09:11:58.703071	27.23	82.85
+2013-03-01 09:11:58.703071	83.98	49.64
+2013-03-01 09:11:58.703071	31.84	83.98
+2013-03-01 09:11:58.703071	50.28	83.98
+2013-03-01 09:11:58.703071	3.73	50.28
+2013-03-01 09:11:58.703071	29.71	50.28
+2013-03-01 09:11:58.703071	53.26	29.71
+2013-03-01 09:11:58.703071	8.86	53.26
+2013-03-01 09:11:58.703071	21.01	53.26
+2013-03-01 09:11:58.703071	84.21	21.01
+2013-03-01 09:11:58.703071	19.1	84.21
+2013-03-01 09:11:58.703071	31.94	84.21
+2013-03-01 09:11:58.703071	88.93	31.94
+2013-03-01 09:11:58.703071	12.83	88.93
+2013-03-01 09:11:58.703071	29.07	88.93
+2013-03-01 09:11:58.703071	61.41	29.07
+2013-03-01 09:11:58.703071	61.88	61.41
+2013-03-01 09:11:58.703071	46.84	61.88
+2013-03-01 09:11:58.703072	62.09	NULL
+2013-03-01 09:11:58.703072	95.01	62.09
+2013-03-01 09:11:58.703072	29.01	95.01
+2013-03-01 09:11:58.703072	79.46	95.01
+2013-03-01 09:11:58.703072	4.48	79.46
+2013-03-01 09:11:58.703072	99.26	79.46
+2013-03-01 09:11:58.703072	58.77	99.26
+2013-03-01 09:11:58.703072	86.98	99.26
+2013-03-01 09:11:58.703072	30.47	86.98
+2013-03-01 09:11:58.703072	68.2	86.98
+2013-03-01 09:11:58.703072	52.44	68.2
+2013-03-01 09:11:58.703072	0.79	68.2
+2013-03-01 09:11:58.703072	25.34	52.44
+2013-03-01 09:11:58.703072	81.29	25.34
+2013-03-01 09:11:58.703072	71.68	81.29
+2013-03-01 09:11:58.703072	1.27	81.29
+2013-03-01 09:11:58.703072	56.7	71.68
+2013-03-01 09:11:58.703072	39.3	56.7
+2013-03-01 09:11:58.703072	25.91	56.7
+2013-03-01 09:11:58.703072	88.08	39.3
+2013-03-01 09:11:58.703072	0.48	88.08
+2013-03-01 09:11:58.703072	9.0	88.08
+2013-03-01 09:11:58.703072	88.83	9.0
+2013-03-01 09:11:58.703072	45.91	88.83
+PREHOOK: query: select ts, f, max(f) over (partition by ts order by t,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, max(f) over (partition by ts order by t,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	14.54	NULL
+2013-03-01 09:11:58.70307	29.22	14.54
+2013-03-01 09:11:58.70307	39.48	29.22
+2013-03-01 09:11:58.70307	17.85	39.48
+2013-03-01 09:11:58.70307	31.17	39.48
+2013-03-01 09:11:58.70307	56.94	39.48
+2013-03-01 09:11:58.70307	78.58	56.94
+2013-03-01 09:11:58.70307	14.78	78.58
+2013-03-01 09:11:58.70307	38.61	78.58
+2013-03-01 09:11:58.70307	91.36	78.58
+2013-03-01 09:11:58.70307	28.69	91.36
+2013-03-01 09:11:58.70307	73.52	91.36
+2013-03-01 09:11:58.70307	92.96	91.36
+2013-03-01 09:11:58.70307	95.04	92.96
+2013-03-01 09:11:58.70307	41.6	95.04
+2013-03-01 09:11:58.70307	64.96	95.04
+2013-03-01 09:11:58.70307	84.71	95.04
+2013-03-01 09:11:58.70307	81.41	95.04
+2013-03-01 09:11:58.70307	10.89	95.04
+2013-03-01 09:11:58.70307	20.61	95.04
+2013-03-01 09:11:58.70307	54.36	95.04
+2013-03-01 09:11:58.70307	87.43	95.04
+2013-03-01 09:11:58.70307	46.08	95.04
+2013-03-01 09:11:58.70307	40.54	95.04
+2013-03-01 09:11:58.70307	38.35	95.04
+2013-03-01 09:11:58.70307	3.17	95.04
+2013-03-01 09:11:58.703071	0.83	NULL
+2013-03-01 09:11:58.703071	56.76	0.83
+2013-03-01 09:11:58.703071	99.45	56.76
+2013-03-01 09:11:58.703071	79.05	99.45
+2013-03-01 09:11:58.703071	14.96	99.45
+2013-03-01 09:11:58.703071	85.55	99.45
+2013-03-01 09:11:58.703071	14.7	99.45
+2013-03-01 09:11:58.703071	81.41	99.45
+2013-03-01 09:11:58.703071	87.93	99.45
+2013-03-01 09:11:58.703071	26.95	99.45
+2013-03-01 09:11:58.703071	37.32	99.45
+2013-03-01 09:11:58.703071	68.62	99.45
+2013-03-01 09:11:58.703071	80.43	99.45
+2013-03-01 09:11:58.703071	54.09	99.45
+2013-03-01 09:11:58.703071	42.08	99.45
+2013-03-01 09:11:58.703071	48.89	99.45
+2013-03-01 09:11:58.703071	64.55	99.45
+2013-03-01 09:11:58.703071	56.45	99.45
+2013-03-01 09:11:58.703071	1.99	99.45
+2013-03-01 09:11:58.703071	94.27	99.45
+2013-03-01 09:11:58.703071	35.32	99.45
+2013-03-01 09:11:58.703071	10.62	99.45
+2013-03-01 09:11:58.703071	52.09	99.45
+2013-03-01 09:11:58.703071	63.03	99.45
+2013-03-01 09:11:58.703071	76.13	99.45
+2013-03-01 09:11:58.703071	44.3	99.45
+2013-03-01 09:11:58.703071	44.66	99.45
+2013-03-01 09:11:58.703071	17.58	99.45
+2013-03-01 09:11:58.703071	11.32	99.45
+2013-03-01 09:11:58.703071	38.5	99.45
+2013-03-01 09:11:58.703071	82.85	99.45
+2013-03-01 09:11:58.703071	49.64	99.45
+2013-03-01 09:11:58.703071	27.23	99.45
+2013-03-01 09:11:58.703071	83.98	99.45
+2013-03-01 09:11:58.703071	31.84	99.45
+2013-03-01 09:11:58.703071	50.28	99.45
+2013-03-01 09:11:58.703071	3.73	99.45
+2013-03-01 09:11:58.703071	29.71	99.45
+2013-03-01 09:11:58.703071	53.26	99.45
+2013-03-01 09:11:58.703071	8.86	99.45
+2013-03-01 09:11:58.703071	21.01	99.45
+2013-03-01 09:11:58.703071	84.21	99.45
+2013-03-01 09:11:58.703071	19.1	99.45
+2013-03-01 09:11:58.703071	31.94	99.45
+2013-03-01 09:11:58.703071	88.93	99.45
+2013-03-01 09:11:58.703071	12.83	99.45
+2013-03-01 09:11:58.703071	29.07	99.45
+2013-03-01 09:11:58.703071	61.41	99.45
+2013-03-01 09:11:58.703071	61.88	99.45
+2013-03-01 09:11:58.703071	46.84	99.45
+2013-03-01 09:11:58.703072	62.09	NULL
+2013-03-01 09:11:58.703072	95.01	62.09
+2013-03-01 09:11:58.703072	29.01	95.01
+2013-03-01 09:11:58.703072	79.46	95.01
+2013-03-01 09:11:58.703072	4.48	95.01
+2013-03-01 09:11:58.703072	99.26	95.01
+2013-03-01 09:11:58.703072	58.77	99.26
+2013-03-01 09:11:58.703072	86.98	99.26
+2013-03-01 09:11:58.703072	30.47	99.26
+2013-03-01 09:11:58.703072	68.2	99.26
+2013-03-01 09:11:58.703072	52.44	99.26
+2013-03-01 09:11:58.703072	0.79	99.26
+2013-03-01 09:11:58.703072	25.34	99.26
+2013-03-01 09:11:58.703072	81.29	99.26
+2013-03-01 09:11:58.703072	71.68	99.26
+2013-03-01 09:11:58.703072	1.27	99.26
+2013-03-01 09:11:58.703072	56.7	99.26
+2013-03-01 09:11:58.703072	39.3	99.26
+2013-03-01 09:11:58.703072	25.91	99.26
+2013-03-01 09:11:58.703072	88.08	99.26
+2013-03-01 09:11:58.703072	0.48	99.26
+2013-03-01 09:11:58.703072	9.0	99.26
+2013-03-01 09:11:58.703072	88.83	99.26
+2013-03-01 09:11:58.703072	45.91	99.26
+PREHOOK: query: select ts, f, max(f) over (partition by ts order by t,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, max(f) over (partition by ts order by t,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	14.54	39.48
+2013-03-01 09:11:58.70307	29.22	39.48
+2013-03-01 09:11:58.70307	39.48	31.17
+2013-03-01 09:11:58.70307	17.85	56.94
+2013-03-01 09:11:58.70307	31.17	78.58
+2013-03-01 09:11:58.70307	56.94	78.58
+2013-03-01 09:11:58.70307	78.58	38.61
+2013-03-01 09:11:58.70307	14.78	91.36
+2013-03-01 09:11:58.70307	38.61	91.36
+2013-03-01 09:11:58.70307	91.36	73.52
+2013-03-01 09:11:58.70307	28.69	92.96
+2013-03-01 09:11:58.70307	73.52	95.04
+2013-03-01 09:11:58.70307	92.96	95.04
+2013-03-01 09:11:58.70307	95.04	64.96
+2013-03-01 09:11:58.70307	41.6	84.71
+2013-03-01 09:11:58.70307	64.96	84.71
+2013-03-01 09:11:58.70307	84.71	81.41
+2013-03-01 09:11:58.70307	81.41	20.61
+2013-03-01 09:11:58.70307	10.89	54.36
+2013-03-01 09:11:58.70307	20.61	87.43
+2013-03-01 09:11:58.70307	54.36	87.43
+2013-03-01 09:11:58.70307	87.43	46.08
+2013-03-01 09:11:58.70307	46.08	40.54
+2013-03-01 09:11:58.70307	40.54	38.35
+2013-03-01 09:11:58.70307	38.35	3.17
+2013-03-01 09:11:58.70307	3.17	NULL
+2013-03-01 09:11:58.703071	0.83	99.45
+2013-03-01 09:11:58.703071	56.76	99.45
+2013-03-01 09:11:58.703071	99.45	79.05
+2013-03-01 09:11:58.703071	79.05	85.55
+2013-03-01 09:11:58.703071	14.96	85.55
+2013-03-01 09:11:58.703071	85.55	81.41
+2013-03-01 09:11:58.703071	14.7	87.93
+2013-03-01 09:11:58.703071	81.41	87.93
+2013-03-01 09:11:58.703071	87.93	37.32
+2013-03-01 09:11:58.703071	26.95	68.62
+2013-03-01 09:11:58.703071	37.32	80.43
+2013-03-01 09:11:58.703071	68.62	80.43
+2013-03-01 09:11:58.703071	80.43	54.09
+2013-03-01 09:11:58.703071	54.09	48.89
+2013-03-01 09:11:58.703071	42.08	64.55
+2013-03-01 09:11:58.703071	48.89	64.55
+2013-03-01 09:11:58.703071	64.55	56.45
+2013-03-01 09:11:58.703071	56.45	94.27
+2013-03-01 09:11:58.703071	1.99	94.27
+2013-03-01 09:11:58.703071	94.27	35.32
+2013-03-01 09:11:58.703071	35.32	52.09
+2013-03-01 09:11:58.703071	10.62	63.03
+2013-03-01 09:11:58.703071	52.09	76.13
+2013-03-01 09:11:58.703071	63.03	76.13
+2013-03-01 09:11:58.703071	76.13	44.66
+2013-03-01 09:11:58.703071	44.3	44.66
+2013-03-01 09:11:58.703071	44.66	17.58
+2013-03-01 09:11:58.703071	17.58	38.5
+2013-03-01 09:11:58.703071	11.32	82.85
+2013-03-01 09:11:58.703071	38.5	82.85
+2013-03-01 09:11:58.703071	82.85	49.64
+2013-03-01 09:11:58.703071	49.64	83.98
+2013-03-01 09:11:58.703071	27.23	83.98
+2013-03-01 09:11:58.703071	83.98	50.28
+2013-03-01 09:11:58.703071	31.84	50.28
+2013-03-01 09:11:58.703071	50.28	29.71
+2013-03-01 09:11:58.703071	3.73	53.26
+2013-03-01 09:11:58.703071	29.71	53.26
+2013-03-01 09:11:58.703071	53.26	21.01
+2013-03-01 09:11:58.703071	8.86	84.21
+2013-03-01 09:11:58.703071	21.01	84.21
+2013-03-01 09:11:58.703071	84.21	31.94
+2013-03-01 09:11:58.703071	19.1	88.93
+2013-03-01 09:11:58.703071	31.94	88.93
+2013-03-01 09:11:58.703071	88.93	29.07
+2013-03-01 09:11:58.703071	12.83	61.41
+2013-03-01 09:11:58.703071	29.07	61.88
+2013-03-01 09:11:58.703071	61.41	61.88
+2013-03-01 09:11:58.703071	61.88	46.84
+2013-03-01 09:11:58.703071	46.84	NULL
+2013-03-01 09:11:58.703072	62.09	95.01
+2013-03-01 09:11:58.703072	95.01	79.46
+2013-03-01 09:11:58.703072	29.01	79.46
+2013-03-01 09:11:58.703072	79.46	99.26
+2013-03-01 09:11:58.703072	4.48	99.26
+2013-03-01 09:11:58.703072	99.26	86.98
+2013-03-01 09:11:58.703072	58.77	86.98
+2013-03-01 09:11:58.703072	86.98	68.2
+2013-03-01 09:11:58.703072	30.47	68.2
+2013-03-01 09:11:58.703072	68.2	52.44
+2013-03-01 09:11:58.703072	52.44	25.34
+2013-03-01 09:11:58.703072	0.79	81.29
+2013-03-01 09:11:58.703072	25.34	81.29
+2013-03-01 09:11:58.703072	81.29	71.68
+2013-03-01 09:11:58.703072	71.68	56.7
+2013-03-01 09:11:58.703072	1.27	56.7
+2013-03-01 09:11:58.703072	56.7	39.3
+2013-03-01 09:11:58.703072	39.3	88.08
+2013-03-01 09:11:58.703072	25.91	88.08
+2013-03-01 09:11:58.703072	88.08	9.0
+2013-03-01 09:11:58.703072	0.48	88.83
+2013-03-01 09:11:58.703072	9.0	88.83
+2013-03-01 09:11:58.703072	88.83	54.1
+2013-03-01 09:11:58.703072	45.91	54.1
+PREHOOK: query: select ts, f, max(f) over (partition by ts order by t,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, max(f) over (partition by ts order by t,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	14.54	29.22
+2013-03-01 09:11:58.70307	29.22	39.48
+2013-03-01 09:11:58.70307	39.48	39.48
+2013-03-01 09:11:58.70307	17.85	39.48
+2013-03-01 09:11:58.70307	31.17	56.94
+2013-03-01 09:11:58.70307	56.94	78.58
+2013-03-01 09:11:58.70307	78.58	78.58
+2013-03-01 09:11:58.70307	14.78	78.58
+2013-03-01 09:11:58.70307	38.61	91.36
+2013-03-01 09:11:58.70307	91.36	91.36
+2013-03-01 09:11:58.70307	28.69	91.36
+2013-03-01 09:11:58.70307	73.52	92.96
+2013-03-01 09:11:58.70307	92.96	95.04
+2013-03-01 09:11:58.70307	95.04	95.04
+2013-03-01 09:11:58.70307	41.6	95.04
+2013-03-01 09:11:58.70307	64.96	95.04
+2013-03-01 09:11:58.70307	84.71	95.04
+2013-03-01 09:11:58.70307	81.41	95.04
+2013-03-01 09:11:58.70307	10.89	95.04
+2013-03-01 09:11:58.70307	20.61	95.04
+2013-03-01 09:11:58.70307	54.36	95.04
+2013-03-01 09:11:58.70307	87.43	95.04
+2013-03-01 09:11:58.70307	46.08	95.04
+2013-03-01 09:11:58.70307	40.54	95.04
+2013-03-01 09:11:58.70307	38.35	95.04
+2013-03-01 09:11:58.70307	3.17	95.04
+2013-03-01 09:11:58.703071	0.83	56.76
+2013-03-01 09:11:58.703071	56.76	99.45
+2013-03-01 09:11:58.703071	99.45	99.45
+2013-03-01 09:11:58.703071	79.05	99.45
+2013-03-01 09:11:58.703071	14.96	99.45
+2013-03-01 09:11:58.703071	85.55	99.45
+2013-03-01 09:11:58.703071	14.7	99.45
+2013-03-01 09:11:58.703071	81.41	99.45
+2013-03-01 09:11:58.703071	87.93	99.45
+2013-03-01 09:11:58.703071	26.95	99.45
+2013-03-01 09:11:58.703071	37.32	99.45
+2013-03-01 09:11:58.703071	68.62	99.45
+2013-03-01 09:11:58.703071	80.43	99.45
+2013-03-01 09:11:58.703071	54.09	99.45
+2013-03-01 09:11:58.703071	42.08	99.45
+2013-03-01 09:11:58.703071	48.89	99.45
+2013-03-01 09:11:58.703071	64.55	99.45
+2013-03-01 09:11:58.703071	56.45	99.45
+2013-03-01 09:11:58.703071	1.99	99.45
+2013-03-01 09:11:58.703071	94.27	99.45
+2013-03-01 09:11:58.703071	35.32	99.45
+2013-03-01 09:11:58.703071	10.62	99.45
+2013-03-01 09:11:58.703071	52.09	99.45
+2013-03-01 09:11:58.703071	63.03	99.45
+2013-03-01 09:11:58.703071	76.13	99.45
+2013-03-01 09:11:58.703071	44.3	99.45
+2013-03-01 09:11:58.703071	44.66	99.45
+2013-03-01 09:11:58.703071	17.58	99.45
+2013-03-01 09:11:58.703071	11.32	99.45
+2013-03-01 09:11:58.703071	38.5	99.45
+2013-03-01 09:11:58.703071	82.85	99.45
+2013-03-01 09:11:58.703071	49.64	99.45
+2013-03-01 09:11:58.703071	27.23	99.45
+2013-03-01 09:11:58.703071	83.98	99.45
+2013-03-01 09:11:58.703071	31.84	99.45
+2013-03-01 09:11:58.703071	50.28	99.45
+2013-03-01 09:11:58.703071	3.73	99.45
+2013-03-01 09:11:58.703071	29.71	99.45
+2013-03-01 09:11:58.703071	53.26	99.45
+2013-03-01 09:11:58.703071	8.86	99.45
+2013-03-01 09:11:58.703071	21.01	99.45
+2013-03-01 09:11:58.703071	84.21	99.45
+2013-03-01 09:11:58.703071	19.1	99.45
+2013-03-01 09:11:58.703071	31.94	99.45
+2013-03-01 09:11:58.703071	88.93	99.45
+2013-03-01 09:11:58.703071	12.83	99.45
+2013-03-01 09:11:58.703071	29.07	99.45
+2013-03-01 09:11:58.703071	61.41	99.45
+2013-03-01 09:11:58.703071	61.88	99.45
+2013-03-01 09:11:58.703071	46.84	99.45
+2013-03-01 09:11:58.703072	62.09	95.01
+2013-03-01 09:11:58.703072	95.01	95.01
+2013-03-01 09:11:58.703072	29.01	95.01
+2013-03-01 09:11:58.703072	79.46	95.01
+2013-03-01 09:11:58.703072	4.48	99.26
+2013-03-01 09:11:58.703072	99.26	99.26
+2013-03-01 09:11:58.703072	58.77	99.26
+2013-03-01 09:11:58.703072	86.98	99.26
+2013-03-01 09:11:58.703072	30.47	99.26
+2013-03-01 09:11:58.703072	68.2	99.26
+2013-03-01 09:11:58.703072	52.44	99.26
+2013-03-01 09:11:58.703072	0.79	99.26
+2013-03-01 09:11:58.703072	25.34	99.26
+2013-03-01 09:11:58.703072	81.29	99.26
+2013-03-01 09:11:58.703072	71.68	99.26
+2013-03-01 09:11:58.703072	1.27	99.26
+2013-03-01 09:11:58.703072	56.7	99.26
+2013-03-01 09:11:58.703072	39.3	99.26
+2013-03-01 09:11:58.703072	25.91	99.26
+2013-03-01 09:11:58.703072	88.08	99.26
+2013-03-01 09:11:58.703072	0.48	99.26
+2013-03-01 09:11:58.703072	9.0	99.26
+2013-03-01 09:11:58.703072	88.83	99.26
+2013-03-01 09:11:58.703072	45.91	99.26
+PREHOOK: query: -- min
+select ts, f, min(f) over (partition by ts order by t,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: -- min
+select ts, f, min(f) over (partition by ts order by t,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	14.54	NULL
+2013-03-01 09:11:58.70307	29.22	14.54
+2013-03-01 09:11:58.70307	39.48	14.54
+2013-03-01 09:11:58.70307	17.85	29.22
+2013-03-01 09:11:58.70307	31.17	17.85
+2013-03-01 09:11:58.70307	56.94	17.85
+2013-03-01 09:11:58.70307	78.58	31.17
+2013-03-01 09:11:58.70307	14.78	56.94
+2013-03-01 09:11:58.70307	38.61	14.78
+2013-03-01 09:11:58.70307	91.36	14.78
+2013-03-01 09:11:58.70307	28.69	38.61
+2013-03-01 09:11:58.70307	73.52	28.69
+2013-03-01 09:11:58.70307	92.96	28.69
+2013-03-01 09:11:58.70307	95.04	73.52
+2013-03-01 09:11:58.70307	41.6	92.96
+2013-03-01 09:11:58.70307	64.96	41.6
+2013-03-01 09:11:58.70307	84.71	41.6
+2013-03-01 09:11:58.70307	81.41	64.96
+2013-03-01 09:11:58.70307	10.89	81.41
+2013-03-01 09:11:58.70307	20.61	10.89
+2013-03-01 09:11:58.70307	54.36	10.89
+2013-03-01 09:11:58.70307	87.43	20.61
+2013-03-01 09:11:58.70307	46.08	54.36
+2013-03-01 09:11:58.70307	40.54	46.08
+2013-03-01 09:11:58.70307	38.35	40.54
+2013-03-01 09:11:58.70307	3.17	38.35
+2013-03-01 09:11:58.703071	0.83	NULL
+2013-03-01 09:11:58.703071	56.76	0.83
+2013-03-01 09:11:58.703071	99.45	0.83
+2013-03-01 09:11:58.703071	79.05	56.76
+2013-03-01 09:11:58.703071	14.96	79.05
+2013-03-01 09:11:58.703071	85.55	14.96
+2013-03-01 09:11:58.703071	14.7	14.96
+2013-03-01 09:11:58.703071	81.41	14.7
+2013-03-01 09:11:58.703071	87.93	14.7
+2013-03-01 09:11:58.703071	26.95	81.41
+2013-03-01 09:11:58.703071	37.32	26.95
+2013-03-01 09:11:58.703071	68.62	26.95
+2013-03-01 09:11:58.703071	80.43	37.32
+2013-03-01 09:11:58.703071	54.09	68.62
+2013-03-01 09:11:58.703071	42.08	54.09
+2013-03-01 09:11:58.703071	48.89	42.08
+2013-03-01 09:11:58.703071	64.55	42.08
+2013-03-01 09:11:58.703071	56.45	48.89
+2013-03-01 09:11:58.703071	1.99	56.45
+2013-03-01 09:11:58.703071	94.27	1.99
+2013-03-01 09:11:58.703071	35.32	1.99
+2013-03-01 09:11:58.703071	10.62	35.32
+2013-03-01 09:11:58.703071	52.09	10.62
+2013-03-01 09:11:58.703071	63.03	10.62
+2013-03-01 09:11:58.703071	76.13	52.09
+2013-03-01 09:11:58.703071	44.3	63.03
+2013-03-01 09:11:58.703071	44.66	44.3
+2013-03-01 09:11:58.703071	17.58	44.3
+2013-03-01 09:11:58.703071	11.32	17.58
+2013-03-01 09:11:58.703071	38.5	11.32
+2013-03-01 09:11:58.703071	82.85	11.32
+2013-03-01 09:11:58.703071	49.64	38.5
+2013-03-01 09:11:58.703071	27.23	49.64
+2013-03-01 09:11:58.703071	83.98	27.23
+2013-03-01 09:11:58.703071	31.84	27.23
+2013-03-01 09:11:58.703071	50.28	31.84
+2013-03-01 09:11:58.703071	3.73	31.84
+2013-03-01 09:11:58.703071	29.71	3.73
+2013-03-01 09:11:58.703071	53.26	3.73
+2013-03-01 09:11:58.703071	8.86	29.71
+2013-03-01 09:11:58.703071	21.01	8.86
+2013-03-01 09:11:58.703071	84.21	8.86
+2013-03-01 09:11:58.703071	19.1	21.01
+2013-03-01 09:11:58.703071	31.94	19.1
+2013-03-01 09:11:58.703071	88.93	19.1
+2013-03-01 09:11:58.703071	12.83	31.94
+2013-03-01 09:11:58.703071	29.07	12.83
+2013-03-01 09:11:58.703071	61.41	12.83
+2013-03-01 09:11:58.703071	61.88	29.07
+2013-03-01 09:11:58.703071	46.84	61.41
+2013-03-01 09:11:58.703072	62.09	NULL
+2013-03-01 09:11:58.703072	95.01	62.09
+2013-03-01 09:11:58.703072	29.01	62.09
+2013-03-01 09:11:58.703072	79.46	29.01
+2013-03-01 09:11:58.703072	4.48	29.01
+2013-03-01 09:11:58.703072	99.26	4.48
+2013-03-01 09:11:58.703072	58.77	4.48
+2013-03-01 09:11:58.703072	86.98	58.77
+2013-03-01 09:11:58.703072	30.47	58.77
+2013-03-01 09:11:58.703072	68.2	30.47
+2013-03-01 09:11:58.703072	52.44	30.47
+2013-03-01 09:11:58.703072	0.79	52.44
+2013-03-01 09:11:58.703072	25.34	0.79
+2013-03-01 09:11:58.703072	81.29	0.79
+2013-03-01 09:11:58.703072	71.68	25.34
+2013-03-01 09:11:58.703072	1.27	71.68
+2013-03-01 09:11:58.703072	56.7	1.27
+2013-03-01 09:11:58.703072	39.3	1.27
+2013-03-01 09:11:58.703072	25.91	39.3
+2013-03-01 09:11:58.703072	88.08	25.91
+2013-03-01 09:11:58.703072	0.48	25.91
+2013-03-01 09:11:58.703072	9.0	0.48
+2013-03-01 09:11:58.703072	88.83	0.48
+2013-03-01 09:11:58.703072	45.91	9.0
+PREHOOK: query: select ts, f, min(f) over (partition by ts order by t,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, min(f) over (partition by ts order by t,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	14.54	NULL
+2013-03-01 09:11:58.70307	29.22	14.54
+2013-03-01 09:11:58.70307	39.48	14.54
+2013-03-01 09:11:58.70307	17.85	14.54
+2013-03-01 09:11:58.70307	31.17	14.54
+2013-03-01 09:11:58.70307	56.94	14.54
+2013-03-01 09:11:58.70307	78.58	14.54
+2013-03-01 09:11:58.70307	14.78	14.54
+2013-03-01 09:11:58.70307	38.61	14.54
+2013-03-01 09:11:58.70307	91.36	14.54
+2013-03-01 09:11:58.70307	28.69	14.54
+2013-03-01 09:11:58.70307	73.52	14.54
+2013-03-01 09:11:58.70307	92.96	14.54
+2013-03-01 09:11:58.70307	95.04	14.54
+2013-03-01 09:11:58.70307	41.6	14.54
+2013-03-01 09:11:58.70307	64.96	14.54
+2013-03-01 09:11:58.70307	84.71	14.54
+2013-03-01 09:11:58.70307	81.41	14.54
+2013-03-01 09:11:58.70307	10.89	14.54
+2013-03-01 09:11:58.70307	20.61	10.89
+2013-03-01 09:11:58.70307	54.36	10.89
+2013-03-01 09:11:58.70307	87.43	10.89
+2013-03-01 09:11:58.70307	46.08	10.89
+2013-03-01 09:11:58.70307	40.54	10.89
+2013-03-01 09:11:58.70307	38.35	10.89
+2013-03-01 09:11:58.70307	3.17	10.89
+2013-03-01 09:11:58.703071	0.83	NULL
+2013-03-01 09:11:58.703071	56.76	0.83
+2013-03-01 09:11:58.703071	99.45	0.83
+2013-03-01 09:11:58.703071	79.05	0.83
+2013-03-01 09:11:58.703071	14.96	0.83
+2013-03-01 09:11:58.703071	85.55	0.83
+2013-03-01 09:11:58.703071	14.7	0.83
+2013-03-01 09:11:58.703071	81.41	0.83
+2013-03-01 09:11:58.703071	87.93	0.83
+2013-03-01 09:11:58.703071	26.95	0.83
+2013-03-01 09:11:58.703071	37.32	0.83
+2013-03-01 09:11:58.703071	68.62	0.83
+2013-03-01 09:11:58.703071	80.43	0.83
+2013-03-01 09:11:58.703071	54.09	0.83
+2013-03-01 09:11:58.703071	42.08	0.83
+2013-03-01 09:11:58.703071	48.89	0.83
+2013-03-01 09:11:58.703071	64.55	0.83
+2013-03-01 09:11:58.703071	56.45	0.83
+2013-03-01 09:11:58.703071	1.99	0.83
+2013-03-01 09:11:58.703071	94.27	0.83
+2013-03-01 09:11:58.703071	35.32	0.83
+2013-03-01 09:11:58.703071	10.62	0.83
+2013-03-01 09:11:58.703071	52.09	0.83
+2013-03-01 09:11:58.703071	63.03	0.83
+2013-03-01 09:11:58.703071	76.13	0.83
+2013-03-01 09:11:58.703071	44.3	0.83
+2013-03-01 09:11:58.703071	44.66	0.83
+2013-03-01 09:11:58.703071	17.58	0.83
+2013-03-01 09:11:58.703071	11.32	0.83
+2013-03-01 09:11:58.703071	38.5	0.83
+2013-03-01 09:11:58.703071	82.85	0.83
+2013-03-01 09:11:58.703071	49.64	0.83
+2013-03-01 09:11:58.703071	27.23	0.83
+2013-03-01 09:11:58.703071	83.98	0.83
+2013-03-01 09:11:58.703071	31.84	0.83
+2013-03-01 09:11:58.703071	50.28	0.83
+2013-03-01 09:11:58.703071	3.73	0.83
+2013-03-01 09:11:58.703071	29.71	0.83
+2013-03-01 09:11:58.703071	53.26	0.83
+2013-03-01 09:11:58.703071	8.86	0.83
+2013-03-01 09:11:58.703071	21.01	0.83
+2013-03-01 09:11:58.703071	84.21	0.83
+2013-03-01 09:11:58.703071	19.1	0.83
+2013-03-01 09:11:58.703071	31.94	0.83
+2013-03-01 09:11:58.703071	88.93	0.83
+2013-03-01 09:11:58.703071	12.83	0.83
+2013-03-01 09:11:58.703071	29.07	0.83
+2013-03-01 09:11:58.703071	61.41	0.83
+2013-03-01 09:11:58.703071	61.88	0.83
+2013-03-01 09:11:58.703071	46.84	0.83
+2013-03-01 09:11:58.703072	62.09	NULL
+2013-03-01 09:11:58.703072	95.01	62.09
+2013-03-01 09:11:58.703072	29.01	62.09
+2013-03-01 09:11:58.703072	79.46	29.01
+2013-03-01 09:11:58.703072	4.48	29.01
+2013-03-01 09:11:58.703072	99.26	4.48
+2013-03-01 09:11:58.703072	58.77	4.48
+2013-03-01 09:11:58.703072	86.98	4.48
+2013-03-01 09:11:58.703072	30.47	4.48
+2013-03-01 09:11:58.703072	68.2	4.48
+2013-03-01 09:11:58.703072	52.44	4.48
+2013-03-01 09:11:58.703072	0.79	4.48
+2013-03-01 09:11:58.703072	25.34	0.79
+2013-03-01 09:11:58.703072	81.29	0.79
+2013-03-01 09:11:58.703072	71.68	0.79
+2013-03-01 09:11:58.703072	1.27	0.79
+2013-03-01 09:11:58.703072	56.7	0.79
+2013-03-01 09:11:58.703072	39.3	0.79
+2013-03-01 09:11:58.703072	25.91	0.79
+2013-03-01 09:11:58.703072	88.08	0.79
+2013-03-01 09:11:58.703072	0.48	0.79
+2013-03-01 09:11:58.703072	9.0	0.48
+2013-03-01 09:11:58.703072	88.83	0.48
+2013-03-01 09:11:58.703072	45.91	0.48
+PREHOOK: query: select ts, f, min(f) over (partition by ts order b

<TRUNCATED>

Mime
View raw message