You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by se...@apache.org on 2015/10/02 04:37:37 UTC
[02/22] hive git commit: HIVE-11962 : Improve windowing_windowspec2.q
tests to return consistent results (Aihua Xu via Szehon)
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 <sz...@cloudera.com>
Authored: Wed Sep 30 12:17:06 2015 -0700
Committer: Szehon Ho <sz...@cloudera.com>
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