HIVE-11962 : Improve windowing_windowspec2.q tests to return consistent results (Aihua Xu via Szehon)
Project: http://git-wip-us.apache.org/repos/asf/hive/repo Commit: http://git-wip-us.apache.org/repos/asf/hive/commit/274847e2 Tree: http://git-wip-us.apache.org/repos/asf/hive/tree/274847e2 Diff: http://git-wip-us.apache.org/repos/asf/hive/diff/274847e2 Branch: refs/heads/llap Commit: 274847e2a38164637701ac4c62802ac91cca4432 Parents: b36cb37 Author: Szehon Ho <[email protected]> Authored: Wed Sep 30 12:17:06 2015 -0700 Committer: Szehon Ho <[email protected]> Committed: Wed Sep 30 12:18:27 2015 -0700 ---------------------------------------------------------------------- .../clientpositive/windowing_windowspec2.q | 16 +- .../clientpositive/windowing_windowspec2.q.out | 198 +++++++++---------- 2 files changed, 107 insertions(+), 107 deletions(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/hive/blob/274847e2/ql/src/test/queries/clientpositive/windowing_windowspec2.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientpositive/windowing_windowspec2.q b/ql/src/test/queries/clientpositive/windowing_windowspec2.q index 3c5bc3d..0ec1e99 100644 --- a/ql/src/test/queries/clientpositive/windowing_windowspec2.q +++ b/ql/src/test/queries/clientpositive/windowing_windowspec2.q @@ -36,16 +36,16 @@ select ts, f, count(f) over (partition by ts order by f rows between 1 following select ts, f, count(f) over (partition by ts order by f rows between unbounded preceding and 1 following) from over10k limit 100; -- max -select ts, f, max(f) over (partition by ts order by t rows between 2 preceding and 1 preceding) from over10k limit 100; -select ts, f, max(f) over (partition by ts order by t rows between unbounded preceding and 1 preceding) from over10k limit 100; -select ts, f, max(f) over (partition by ts order by t rows between 1 following and 2 following) from over10k limit 100; -select ts, f, max(f) over (partition by ts order by t rows between unbounded preceding and 1 following) from over10k limit 100; +select ts, f, max(f) over (partition by ts order by t,f rows between 2 preceding and 1 preceding) from over10k limit 100; +select ts, f, max(f) over (partition by ts order by t,f rows between unbounded preceding and 1 preceding) from over10k limit 100; +select ts, f, max(f) over (partition by ts order by t,f rows between 1 following and 2 following) from over10k limit 100; +select ts, f, max(f) over (partition by ts order by t,f rows between unbounded preceding and 1 following) from over10k limit 100; -- min -select ts, f, min(f) over (partition by ts order by t rows between 2 preceding and 1 preceding) from over10k limit 100; -select ts, f, min(f) over (partition by ts order by t rows between unbounded preceding and 1 preceding) from over10k limit 100; -select ts, f, min(f) over (partition by ts order by t rows between 1 following and 2 following) from over10k limit 100; -select ts, f, min(f) over (partition by ts order by t rows between unbounded preceding and 1 following) from over10k limit 100; +select ts, f, min(f) over (partition by ts order by t,f rows between 2 preceding and 1 preceding) from over10k limit 100; +select ts, f, min(f) over (partition by ts order by t,f rows between unbounded preceding and 1 preceding) from over10k limit 100; +select ts, f, min(f) over (partition by ts order by t,f rows between 1 following and 2 following) from over10k limit 100; +select ts, f, min(f) over (partition by ts order by t,f rows between unbounded preceding and 1 following) from over10k limit 100; -- first_value select ts, f, first_value(f) over (partition by ts order by f rows between 2 preceding and 1 preceding) from over10k limit 100; http://git-wip-us.apache.org/repos/asf/hive/blob/274847e2/ql/src/test/results/clientpositive/windowing_windowspec2.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/windowing_windowspec2.q.out b/ql/src/test/results/clientpositive/windowing_windowspec2.q.out index e71a03f..a88eb6c 100644 --- a/ql/src/test/results/clientpositive/windowing_windowspec2.q.out +++ b/ql/src/test/results/clientpositive/windowing_windowspec2.q.out @@ -1347,12 +1347,12 @@ POSTHOOK: Input: default@over10k 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 rows between 2 preceding and 1 preceding) from over10k limit 100 +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 rows between 2 preceding and 1 preceding) from over10k limit 100 +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 #### @@ -1363,8 +1363,8 @@ POSTHOOK: Input: default@over10k 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 38.61 78.58 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 @@ -1397,10 +1397,10 @@ POSTHOOK: Input: default@over10k 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 64.55 54.09 -2013-03-01 09:11:58.703071 48.89 64.55 +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 56.45 +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 @@ -1419,23 +1419,23 @@ POSTHOOK: Input: default@over10k 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 53.26 50.28 -2013-03-01 09:11:58.703071 29.71 53.26 +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 29.71 +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.88 29.07 -2013-03-01 09:11:58.703071 61.41 61.88 +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 95.01 NULL -2013-03-01 09:11:58.703072 62.09 95.01 +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 62.09 +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 @@ -1453,14 +1453,14 @@ POSTHOOK: Input: default@over10k 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 88.83 88.08 -2013-03-01 09:11:58.703072 9.0 88.83 -2013-03-01 09:11:58.703072 54.1 88.83 -PREHOOK: query: select ts, f, max(f) over (partition by ts order by t rows between unbounded preceding and 1 preceding) from over10k limit 100 +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 rows between unbounded preceding and 1 preceding) from over10k limit 100 +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 #### @@ -1471,8 +1471,8 @@ POSTHOOK: Input: default@over10k 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 38.61 78.58 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 @@ -1505,8 +1505,8 @@ POSTHOOK: Input: default@over10k 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 64.55 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 @@ -1527,8 +1527,8 @@ POSTHOOK: Input: default@over10k 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 53.26 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 @@ -1537,11 +1537,11 @@ POSTHOOK: Input: default@over10k 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.88 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 95.01 NULL -2013-03-01 09:11:58.703072 62.09 95.01 +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 @@ -1561,14 +1561,14 @@ POSTHOOK: Input: default@over10k 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 88.83 99.26 2013-03-01 09:11:58.703072 9.0 99.26 -2013-03-01 09:11:58.703072 54.1 99.26 -PREHOOK: query: select ts, f, max(f) over (partition by ts order by t rows between 1 following and 2 following) from over10k limit 100 +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 rows between 1 following and 2 following) from over10k limit 100 +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 #### @@ -1579,8 +1579,8 @@ POSTHOOK: Input: default@over10k 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 38.61 91.36 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 @@ -1611,10 +1611,10 @@ POSTHOOK: Input: default@over10k 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 64.55 +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 48.89 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 @@ -1633,23 +1633,23 @@ POSTHOOK: Input: default@over10k 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 53.26 +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 53.26 29.71 -2013-03-01 09:11:58.703071 29.71 21.01 +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.88 +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.88 61.41 -2013-03-01 09:11:58.703071 61.41 46.84 +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 95.01 62.09 -2013-03-01 09:11:58.703072 62.09 79.46 +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 @@ -1667,16 +1667,16 @@ POSTHOOK: Input: default@over10k 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 88.83 +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 9.0 54.1 -2013-03-01 09:11:58.703072 54.1 45.91 -PREHOOK: query: select ts, f, max(f) over (partition by ts order by t rows between unbounded preceding and 1 following) from over10k limit 100 +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 rows between unbounded preceding and 1 following) from over10k limit 100 +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 #### @@ -1687,8 +1687,8 @@ POSTHOOK: Input: default@over10k 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 38.61 78.58 -2013-03-01 09:11:58.70307 14.78 91.36 +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 @@ -1721,8 +1721,8 @@ POSTHOOK: Input: default@over10k 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 64.55 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 @@ -1743,8 +1743,8 @@ POSTHOOK: Input: default@over10k 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 53.26 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 @@ -1753,11 +1753,11 @@ POSTHOOK: Input: default@over10k 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.88 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 95.01 95.01 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 @@ -1777,16 +1777,16 @@ POSTHOOK: Input: default@over10k 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 88.83 99.26 2013-03-01 09:11:58.703072 9.0 99.26 -2013-03-01 09:11:58.703072 54.1 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 rows between 2 preceding and 1 preceding) from over10k limit 100 +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 rows between 2 preceding and 1 preceding) from over10k limit 100 +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 #### @@ -1797,10 +1797,10 @@ POSTHOOK: Input: default@over10k 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 38.61 56.94 -2013-03-01 09:11:58.70307 14.78 38.61 +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 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 @@ -1831,10 +1831,10 @@ POSTHOOK: Input: default@over10k 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 64.55 42.08 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 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 @@ -1853,8 +1853,8 @@ POSTHOOK: Input: default@over10k 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 53.26 3.73 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 @@ -1863,11 +1863,11 @@ POSTHOOK: Input: default@over10k 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.88 12.83 -2013-03-01 09:11:58.703071 61.41 29.07 +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 95.01 NULL -2013-03-01 09:11:58.703072 62.09 95.01 +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 @@ -1887,14 +1887,14 @@ POSTHOOK: Input: default@over10k 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 88.83 0.48 2013-03-01 09:11:58.703072 9.0 0.48 -2013-03-01 09:11:58.703072 54.1 9.0 -PREHOOK: query: select ts, f, min(f) over (partition by ts order by t rows between unbounded preceding and 1 preceding) from over10k limit 100 +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 rows between unbounded preceding and 1 preceding) from over10k limit 100 +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 #### @@ -1905,8 +1905,8 @@ POSTHOOK: Input: default@over10k 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 38.61 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 @@ -1939,8 +1939,8 @@ POSTHOOK: Input: default@over10k 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 64.55 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 @@ -1961,8 +1961,8 @@ POSTHOOK: Input: default@over10k 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 53.26 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 @@ -1971,11 +1971,11 @@ POSTHOOK: Input: default@over10k 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.88 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 95.01 NULL -2013-03-01 09:11:58.703072 62.09 95.01 +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 @@ -1995,14 +1995,14 @@ POSTHOOK: Input: default@over10k 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 88.83 0.48 2013-03-01 09:11:58.703072 9.0 0.48 -2013-03-01 09:11:58.703072 54.1 0.48 -PREHOOK: query: select ts, f, min(f) over (partition by ts order by t rows between 1 following and 2 following) from over10k limit 100 +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 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, min(f) over (partition by ts order by t rows between 1 following and 2 following) from over10k limit 100 +POSTHOOK: query: select ts, f, min(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 #### @@ -2011,10 +2011,10 @@ POSTHOOK: Input: default@over10k 2013-03-01 09:11:58.70307 39.48 17.85 2013-03-01 09:11:58.70307 17.85 31.17 2013-03-01 09:11:58.70307 31.17 56.94 -2013-03-01 09:11:58.70307 56.94 38.61 +2013-03-01 09:11:58.70307 56.94 14.78 2013-03-01 09:11:58.70307 78.58 14.78 -2013-03-01 09:11:58.70307 38.61 14.78 -2013-03-01 09:11:58.70307 14.78 28.69 +2013-03-01 09:11:58.70307 14.78 38.61 +2013-03-01 09:11:58.70307 38.61 28.69 2013-03-01 09:11:58.70307 91.36 28.69 2013-03-01 09:11:58.70307 28.69 73.52 2013-03-01 09:11:58.70307 73.52 92.96 @@ -2047,8 +2047,8 @@ POSTHOOK: Input: default@over10k 2013-03-01 09:11:58.703071 80.43 42.08 2013-03-01 09:11:58.703071 54.09 42.08 2013-03-01 09:11:58.703071 42.08 48.89 -2013-03-01 09:11:58.703071 64.55 48.89 -2013-03-01 09:11:58.703071 48.89 1.99 +2013-03-01 09:11:58.703071 48.89 56.45 +2013-03-01 09:11:58.703071 64.55 1.99 2013-03-01 09:11:58.703071 56.45 1.99 2013-03-01 09:11:58.703071 1.99 35.32 2013-03-01 09:11:58.703071 94.27 10.62 @@ -2069,8 +2069,8 @@ POSTHOOK: Input: default@over10k 2013-03-01 09:11:58.703071 31.84 3.73 2013-03-01 09:11:58.703071 50.28 3.73 2013-03-01 09:11:58.703071 3.73 29.71 -2013-03-01 09:11:58.703071 53.26 8.86 2013-03-01 09:11:58.703071 29.71 8.86 +2013-03-01 09:11:58.703071 53.26 8.86 2013-03-01 09:11:58.703071 8.86 21.01 2013-03-01 09:11:58.703071 21.01 19.1 2013-03-01 09:11:58.703071 84.21 19.1 @@ -2079,11 +2079,11 @@ POSTHOOK: Input: default@over10k 2013-03-01 09:11:58.703071 88.93 12.83 2013-03-01 09:11:58.703071 12.83 29.07 2013-03-01 09:11:58.703071 29.07 61.41 -2013-03-01 09:11:58.703071 61.88 46.84 2013-03-01 09:11:58.703071 61.41 46.84 +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 95.01 29.01 2013-03-01 09:11:58.703072 62.09 29.01 +2013-03-01 09:11:58.703072 95.01 29.01 2013-03-01 09:11:58.703072 29.01 4.48 2013-03-01 09:11:58.703072 79.46 4.48 2013-03-01 09:11:58.703072 4.48 58.77 @@ -2103,14 +2103,14 @@ POSTHOOK: Input: default@over10k 2013-03-01 09:11:58.703072 25.91 0.48 2013-03-01 09:11:58.703072 88.08 0.48 2013-03-01 09:11:58.703072 0.48 9.0 -2013-03-01 09:11:58.703072 88.83 9.0 2013-03-01 09:11:58.703072 9.0 45.91 -2013-03-01 09:11:58.703072 54.1 0.36 -PREHOOK: query: select ts, f, min(f) over (partition by ts order by t rows between unbounded preceding and 1 following) from over10k limit 100 +2013-03-01 09:11:58.703072 88.83 45.91 +2013-03-01 09:11:58.703072 45.91 0.36 +PREHOOK: query: select ts, f, min(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, min(f) over (partition by ts order by t rows between unbounded preceding and 1 following) from over10k limit 100 +POSTHOOK: query: select ts, f, min(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 #### @@ -2121,8 +2121,8 @@ POSTHOOK: Input: default@over10k 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 38.61 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 @@ -2155,8 +2155,8 @@ POSTHOOK: Input: default@over10k 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 64.55 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 @@ -2177,8 +2177,8 @@ POSTHOOK: Input: default@over10k 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 53.26 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 @@ -2187,11 +2187,11 @@ POSTHOOK: Input: default@over10k 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.88 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 95.01 62.09 -2013-03-01 09:11:58.703072 62.09 29.01 +2013-03-01 09:11:58.703072 62.09 62.09 +2013-03-01 09:11:58.703072 95.01 29.01 2013-03-01 09:11:58.703072 29.01 29.01 2013-03-01 09:11:58.703072 79.46 4.48 2013-03-01 09:11:58.703072 4.48 4.48 @@ -2211,9 +2211,9 @@ POSTHOOK: Input: default@over10k 2013-03-01 09:11:58.703072 25.91 0.79 2013-03-01 09:11:58.703072 88.08 0.48 2013-03-01 09:11:58.703072 0.48 0.48 -2013-03-01 09:11:58.703072 88.83 0.48 2013-03-01 09:11:58.703072 9.0 0.48 -2013-03-01 09:11:58.703072 54.1 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: -- first_value select ts, f, first_value(f) over (partition by ts order by f rows between 2 preceding and 1 preceding) from over10k limit 100 PREHOOK: type: QUERY
