Return-Path: X-Original-To: archive-asf-public-internal@cust-asf2.ponee.io Delivered-To: archive-asf-public-internal@cust-asf2.ponee.io Received: from cust-asf.ponee.io (cust-asf.ponee.io [163.172.22.183]) by cust-asf2.ponee.io (Postfix) with ESMTP id DE5F7200B9B for ; Wed, 12 Oct 2016 09:27:17 +0200 (CEST) Received: by cust-asf.ponee.io (Postfix) id DBEC2160AFF; Wed, 12 Oct 2016 07:27:17 +0000 (UTC) Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by cust-asf.ponee.io (Postfix) with SMTP id 84DA3160AD3 for ; Wed, 12 Oct 2016 09:27:15 +0200 (CEST) Received: (qmail 2512 invoked by uid 500); 12 Oct 2016 07:27:14 -0000 Mailing-List: contact commits-help@hive.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: hive-dev@hive.apache.org Delivered-To: mailing list commits@hive.apache.org Received: (qmail 2487 invoked by uid 99); 12 Oct 2016 07:27:14 -0000 Received: from git1-us-west.apache.org (HELO git1-us-west.apache.org) (140.211.11.23) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 12 Oct 2016 07:27:14 +0000 Received: by git1-us-west.apache.org (ASF Mail Server at git1-us-west.apache.org, from userid 33) id 16965E07D9; Wed, 12 Oct 2016 07:27:14 +0000 (UTC) Content-Type: text/plain; charset="us-ascii" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit From: prasanthj@apache.org To: commits@hive.apache.org Date: Wed, 12 Oct 2016 07:27:14 -0000 Message-Id: X-Mailer: ASF-Git Admin Mailer Subject: [01/37] hive git commit: HIVE-14877: Move slow CliDriver tests to MiniLlap (Prasanth Jayachandran reviewed by Siddharth Seth) archived-at: Wed, 12 Oct 2016 07:27:18 -0000 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