You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by ha...@apache.org on 2015/06/23 20:44:28 UTC
hive git commit: HIVE-11083 : Make test cbo_windowing robust
(Ashutosh Chauhan via Hari Sankar Subramaniyan)
Repository: hive
Updated Branches:
refs/heads/master ebd883a3b -> aa0c0beef
HIVE-11083 : Make test cbo_windowing robust (Ashutosh Chauhan via Hari Sankar Subramaniyan)
Project: http://git-wip-us.apache.org/repos/asf/hive/repo
Commit: http://git-wip-us.apache.org/repos/asf/hive/commit/aa0c0bee
Tree: http://git-wip-us.apache.org/repos/asf/hive/tree/aa0c0bee
Diff: http://git-wip-us.apache.org/repos/asf/hive/diff/aa0c0bee
Branch: refs/heads/master
Commit: aa0c0beef37e66842c24dab96615974eff2582e6
Parents: ebd883a
Author: Ashutosh Chauhan <ha...@apache.org>
Authored: Tue Jun 23 11:43:04 2015 -0700
Committer: Ashutosh Chauhan <ha...@apache.org>
Committed: Tue Jun 23 11:44:10 2015 -0700
----------------------------------------------------------------------
.../test/queries/clientpositive/cbo_windowing.q | 4 +-
.../results/clientpositive/cbo_windowing.q.out | 88 ++++++++++----------
.../clientpositive/tez/cbo_windowing.q.out | 88 ++++++++++----------
3 files changed, 90 insertions(+), 90 deletions(-)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/hive/blob/aa0c0bee/ql/src/test/queries/clientpositive/cbo_windowing.q
----------------------------------------------------------------------
diff --git a/ql/src/test/queries/clientpositive/cbo_windowing.q b/ql/src/test/queries/clientpositive/cbo_windowing.q
index c5bb683..030deb0 100644
--- a/ql/src/test/queries/clientpositive/cbo_windowing.q
+++ b/ql/src/test/queries/clientpositive/cbo_windowing.q
@@ -8,8 +8,8 @@ set hive.auto.convert.join=false;
-- SORT_QUERY_RESULTS
select count(c_int) over() from cbo_t1;
-select count(c_int) over(), sum(c_float) over(), max(c_int) over(), min(c_int) over(), row_number() over() as rn, rank() over(), dense_rank() over(), percent_rank() over(), lead(c_int, 2, c_int) over(partition by c_boolean order by c_float), lag(c_float, 2, c_float) over(partition by c_boolean order by c_float) from cbo_t1 order by rn;
-select * from (select count(c_int) over(), sum(c_float) over(), max(c_int) over(), min(c_int) over(), row_number() over() as rn, rank() over(), dense_rank() over(), percent_rank() over(), lead(c_int, 2, c_int) over(partition by c_boolean order by c_float), lag(c_float, 2, c_float) over(partition by c_boolean order by c_float) from cbo_t1 order by rn) cbo_t1;
+select count(c_int) over(partition by c_float order by key), sum(c_float) over(partition by c_float order by key), max(c_int) over(partition by c_float order by key), min(c_int) over(partition by c_float order by key), row_number() over(partition by c_float order by key) as rn, rank() over(partition by c_float order by key), dense_rank() over(partition by c_float order by key), round(percent_rank() over(partition by c_float order by key), 2), lead(c_int, 2, c_int) over(partition by c_float order by key), lag(c_float, 2, c_float) over(partition by c_float order by key) from cbo_t1 order by rn;
+select * from (select count(c_int) over(partition by c_float order by key), sum(c_float) over(partition by c_float order by key), max(c_int) over(partition by c_float order by key), min(c_int) over(partition by c_float order by key), row_number() over(partition by c_float order by key) as rn, rank() over(partition by c_float order by key), dense_rank() over(partition by c_float order by key), round(percent_rank() over(partition by c_float order by key),2), lead(c_int, 2, c_int) over(partition by c_float order by key ), lag(c_float, 2, c_float) over(partition by c_float order by key) from cbo_t1 order by rn) cbo_t1;
select x from (select count(c_int) over() as x, sum(c_float) over() from cbo_t1) cbo_t1;
select 1+sum(c_int) over() from cbo_t1;
select sum(c_int)+sum(sum(c_int)) over() from cbo_t1;
http://git-wip-us.apache.org/repos/asf/hive/blob/aa0c0bee/ql/src/test/results/clientpositive/cbo_windowing.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/cbo_windowing.q.out b/ql/src/test/results/clientpositive/cbo_windowing.q.out
index bec3f1a..52b584a 100644
--- a/ql/src/test/results/clientpositive/cbo_windowing.q.out
+++ b/ql/src/test/results/clientpositive/cbo_windowing.q.out
@@ -34,66 +34,66 @@ POSTHOOK: Input: default@cbo_t1@dt=2014
18
18
18
-PREHOOK: query: select count(c_int) over(), sum(c_float) over(), max(c_int) over(), min(c_int) over(), row_number() over() as rn, rank() over(), dense_rank() over(), percent_rank() over(), lead(c_int, 2, c_int) over(partition by c_boolean order by c_float), lag(c_float, 2, c_float) over(partition by c_boolean order by c_float) from cbo_t1 order by rn
+PREHOOK: query: select count(c_int) over(partition by c_float order by key), sum(c_float) over(partition by c_float order by key), max(c_int) over(partition by c_float order by key), min(c_int) over(partition by c_float order by key), row_number() over(partition by c_float order by key) as rn, rank() over(partition by c_float order by key), dense_rank() over(partition by c_float order by key), round(percent_rank() over(partition by c_float order by key), 2), lead(c_int, 2, c_int) over(partition by c_float order by key), lag(c_float, 2, c_float) over(partition by c_float order by key) from cbo_t1 order by rn
PREHOOK: type: QUERY
PREHOOK: Input: default@cbo_t1
PREHOOK: Input: default@cbo_t1@dt=2014
#### A masked pattern was here ####
-POSTHOOK: query: select count(c_int) over(), sum(c_float) over(), max(c_int) over(), min(c_int) over(), row_number() over() as rn, rank() over(), dense_rank() over(), percent_rank() over(), lead(c_int, 2, c_int) over(partition by c_boolean order by c_float), lag(c_float, 2, c_float) over(partition by c_boolean order by c_float) from cbo_t1 order by rn
+POSTHOOK: query: select count(c_int) over(partition by c_float order by key), sum(c_float) over(partition by c_float order by key), max(c_int) over(partition by c_float order by key), min(c_int) over(partition by c_float order by key), row_number() over(partition by c_float order by key) as rn, rank() over(partition by c_float order by key), dense_rank() over(partition by c_float order by key), round(percent_rank() over(partition by c_float order by key), 2), lead(c_int, 2, c_int) over(partition by c_float order by key), lag(c_float, 2, c_float) over(partition by c_float order by key) from cbo_t1 order by rn
POSTHOOK: type: QUERY
POSTHOOK: Input: default@cbo_t1
POSTHOOK: Input: default@cbo_t1@dt=2014
#### A masked pattern was here ####
-18 18.0 1 1 1 1 1 0.0 NULL NULL
-18 18.0 1 1 10 1 1 0.0 1 1.0
-18 18.0 1 1 11 1 1 0.0 1 1.0
-18 18.0 1 1 12 1 1 0.0 1 1.0
-18 18.0 1 1 13 1 1 0.0 1 1.0
-18 18.0 1 1 14 1 1 0.0 1 1.0
-18 18.0 1 1 15 1 1 0.0 1 1.0
-18 18.0 1 1 16 1 1 0.0 1 1.0
-18 18.0 1 1 17 1 1 0.0 1 1.0
-18 18.0 1 1 18 1 1 0.0 1 1.0
-18 18.0 1 1 19 1 1 0.0 1 1.0
-18 18.0 1 1 2 1 1 0.0 NULL NULL
-18 18.0 1 1 20 1 1 0.0 1 1.0
-18 18.0 1 1 3 1 1 0.0 1 1.0
-18 18.0 1 1 4 1 1 0.0 1 1.0
-18 18.0 1 1 5 1 1 0.0 1 1.0
-18 18.0 1 1 6 1 1 0.0 1 1.0
-18 18.0 1 1 7 1 1 0.0 1 1.0
-18 18.0 1 1 8 1 1 0.0 1 1.0
-18 18.0 1 1 9 1 1 0.0 1 1.0
-PREHOOK: query: select * from (select count(c_int) over(), sum(c_float) over(), max(c_int) over(), min(c_int) over(), row_number() over() as rn, rank() over(), dense_rank() over(), percent_rank() over(), lead(c_int, 2, c_int) over(partition by c_boolean order by c_float), lag(c_float, 2, c_float) over(partition by c_boolean order by c_float) from cbo_t1 order by rn) cbo_t1
+0 NULL NULL NULL 1 1 1 0.0 NULL NULL
+0 NULL NULL NULL 2 1 1 0.0 NULL NULL
+16 16.0 1 1 10 5 3 0.24 1 1.0
+16 16.0 1 1 11 5 3 0.24 1 1.0
+16 16.0 1 1 12 5 3 0.24 1 1.0
+16 16.0 1 1 13 5 3 0.24 1 1.0
+16 16.0 1 1 14 5 3 0.24 1 1.0
+16 16.0 1 1 15 5 3 0.24 1 1.0
+16 16.0 1 1 16 5 3 0.24 1 1.0
+16 16.0 1 1 5 5 3 0.24 1 1.0
+16 16.0 1 1 6 5 3 0.24 1 1.0
+16 16.0 1 1 7 5 3 0.24 1 1.0
+16 16.0 1 1 8 5 3 0.24 1 1.0
+16 16.0 1 1 9 5 3 0.24 1 1.0
+18 18.0 1 1 17 17 4 0.94 1 1.0
+18 18.0 1 1 18 17 4 0.94 1 1.0
+2 2.0 1 1 1 1 1 0.0 1 1.0
+2 2.0 1 1 2 1 1 0.0 1 1.0
+4 4.0 1 1 3 3 2 0.12 1 1.0
+4 4.0 1 1 4 3 2 0.12 1 1.0
+PREHOOK: query: select * from (select count(c_int) over(partition by c_float order by key), sum(c_float) over(partition by c_float order by key), max(c_int) over(partition by c_float order by key), min(c_int) over(partition by c_float order by key), row_number() over(partition by c_float order by key) as rn, rank() over(partition by c_float order by key), dense_rank() over(partition by c_float order by key), round(percent_rank() over(partition by c_float order by key),2), lead(c_int, 2, c_int) over(partition by c_float order by key ), lag(c_float, 2, c_float) over(partition by c_float order by key) from cbo_t1 order by rn) cbo_t1
PREHOOK: type: QUERY
PREHOOK: Input: default@cbo_t1
PREHOOK: Input: default@cbo_t1@dt=2014
#### A masked pattern was here ####
-POSTHOOK: query: select * from (select count(c_int) over(), sum(c_float) over(), max(c_int) over(), min(c_int) over(), row_number() over() as rn, rank() over(), dense_rank() over(), percent_rank() over(), lead(c_int, 2, c_int) over(partition by c_boolean order by c_float), lag(c_float, 2, c_float) over(partition by c_boolean order by c_float) from cbo_t1 order by rn) cbo_t1
+POSTHOOK: query: select * from (select count(c_int) over(partition by c_float order by key), sum(c_float) over(partition by c_float order by key), max(c_int) over(partition by c_float order by key), min(c_int) over(partition by c_float order by key), row_number() over(partition by c_float order by key) as rn, rank() over(partition by c_float order by key), dense_rank() over(partition by c_float order by key), round(percent_rank() over(partition by c_float order by key),2), lead(c_int, 2, c_int) over(partition by c_float order by key ), lag(c_float, 2, c_float) over(partition by c_float order by key) from cbo_t1 order by rn) cbo_t1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@cbo_t1
POSTHOOK: Input: default@cbo_t1@dt=2014
#### A masked pattern was here ####
-18 18.0 1 1 1 1 1 0.0 NULL NULL
-18 18.0 1 1 10 1 1 0.0 1 1.0
-18 18.0 1 1 11 1 1 0.0 1 1.0
-18 18.0 1 1 12 1 1 0.0 1 1.0
-18 18.0 1 1 13 1 1 0.0 1 1.0
-18 18.0 1 1 14 1 1 0.0 1 1.0
-18 18.0 1 1 15 1 1 0.0 1 1.0
-18 18.0 1 1 16 1 1 0.0 1 1.0
-18 18.0 1 1 17 1 1 0.0 1 1.0
-18 18.0 1 1 18 1 1 0.0 1 1.0
-18 18.0 1 1 19 1 1 0.0 1 1.0
-18 18.0 1 1 2 1 1 0.0 NULL NULL
-18 18.0 1 1 20 1 1 0.0 1 1.0
-18 18.0 1 1 3 1 1 0.0 1 1.0
-18 18.0 1 1 4 1 1 0.0 1 1.0
-18 18.0 1 1 5 1 1 0.0 1 1.0
-18 18.0 1 1 6 1 1 0.0 1 1.0
-18 18.0 1 1 7 1 1 0.0 1 1.0
-18 18.0 1 1 8 1 1 0.0 1 1.0
-18 18.0 1 1 9 1 1 0.0 1 1.0
+0 NULL NULL NULL 1 1 1 0.0 NULL NULL
+0 NULL NULL NULL 2 1 1 0.0 NULL NULL
+16 16.0 1 1 10 5 3 0.24 1 1.0
+16 16.0 1 1 11 5 3 0.24 1 1.0
+16 16.0 1 1 12 5 3 0.24 1 1.0
+16 16.0 1 1 13 5 3 0.24 1 1.0
+16 16.0 1 1 14 5 3 0.24 1 1.0
+16 16.0 1 1 15 5 3 0.24 1 1.0
+16 16.0 1 1 16 5 3 0.24 1 1.0
+16 16.0 1 1 5 5 3 0.24 1 1.0
+16 16.0 1 1 6 5 3 0.24 1 1.0
+16 16.0 1 1 7 5 3 0.24 1 1.0
+16 16.0 1 1 8 5 3 0.24 1 1.0
+16 16.0 1 1 9 5 3 0.24 1 1.0
+18 18.0 1 1 17 17 4 0.94 1 1.0
+18 18.0 1 1 18 17 4 0.94 1 1.0
+2 2.0 1 1 1 1 1 0.0 1 1.0
+2 2.0 1 1 2 1 1 0.0 1 1.0
+4 4.0 1 1 3 3 2 0.12 1 1.0
+4 4.0 1 1 4 3 2 0.12 1 1.0
PREHOOK: query: select x from (select count(c_int) over() as x, sum(c_float) over() from cbo_t1) cbo_t1
PREHOOK: type: QUERY
PREHOOK: Input: default@cbo_t1
http://git-wip-us.apache.org/repos/asf/hive/blob/aa0c0bee/ql/src/test/results/clientpositive/tez/cbo_windowing.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/tez/cbo_windowing.q.out b/ql/src/test/results/clientpositive/tez/cbo_windowing.q.out
index bec3f1a..52b584a 100644
--- a/ql/src/test/results/clientpositive/tez/cbo_windowing.q.out
+++ b/ql/src/test/results/clientpositive/tez/cbo_windowing.q.out
@@ -34,66 +34,66 @@ POSTHOOK: Input: default@cbo_t1@dt=2014
18
18
18
-PREHOOK: query: select count(c_int) over(), sum(c_float) over(), max(c_int) over(), min(c_int) over(), row_number() over() as rn, rank() over(), dense_rank() over(), percent_rank() over(), lead(c_int, 2, c_int) over(partition by c_boolean order by c_float), lag(c_float, 2, c_float) over(partition by c_boolean order by c_float) from cbo_t1 order by rn
+PREHOOK: query: select count(c_int) over(partition by c_float order by key), sum(c_float) over(partition by c_float order by key), max(c_int) over(partition by c_float order by key), min(c_int) over(partition by c_float order by key), row_number() over(partition by c_float order by key) as rn, rank() over(partition by c_float order by key), dense_rank() over(partition by c_float order by key), round(percent_rank() over(partition by c_float order by key), 2), lead(c_int, 2, c_int) over(partition by c_float order by key), lag(c_float, 2, c_float) over(partition by c_float order by key) from cbo_t1 order by rn
PREHOOK: type: QUERY
PREHOOK: Input: default@cbo_t1
PREHOOK: Input: default@cbo_t1@dt=2014
#### A masked pattern was here ####
-POSTHOOK: query: select count(c_int) over(), sum(c_float) over(), max(c_int) over(), min(c_int) over(), row_number() over() as rn, rank() over(), dense_rank() over(), percent_rank() over(), lead(c_int, 2, c_int) over(partition by c_boolean order by c_float), lag(c_float, 2, c_float) over(partition by c_boolean order by c_float) from cbo_t1 order by rn
+POSTHOOK: query: select count(c_int) over(partition by c_float order by key), sum(c_float) over(partition by c_float order by key), max(c_int) over(partition by c_float order by key), min(c_int) over(partition by c_float order by key), row_number() over(partition by c_float order by key) as rn, rank() over(partition by c_float order by key), dense_rank() over(partition by c_float order by key), round(percent_rank() over(partition by c_float order by key), 2), lead(c_int, 2, c_int) over(partition by c_float order by key), lag(c_float, 2, c_float) over(partition by c_float order by key) from cbo_t1 order by rn
POSTHOOK: type: QUERY
POSTHOOK: Input: default@cbo_t1
POSTHOOK: Input: default@cbo_t1@dt=2014
#### A masked pattern was here ####
-18 18.0 1 1 1 1 1 0.0 NULL NULL
-18 18.0 1 1 10 1 1 0.0 1 1.0
-18 18.0 1 1 11 1 1 0.0 1 1.0
-18 18.0 1 1 12 1 1 0.0 1 1.0
-18 18.0 1 1 13 1 1 0.0 1 1.0
-18 18.0 1 1 14 1 1 0.0 1 1.0
-18 18.0 1 1 15 1 1 0.0 1 1.0
-18 18.0 1 1 16 1 1 0.0 1 1.0
-18 18.0 1 1 17 1 1 0.0 1 1.0
-18 18.0 1 1 18 1 1 0.0 1 1.0
-18 18.0 1 1 19 1 1 0.0 1 1.0
-18 18.0 1 1 2 1 1 0.0 NULL NULL
-18 18.0 1 1 20 1 1 0.0 1 1.0
-18 18.0 1 1 3 1 1 0.0 1 1.0
-18 18.0 1 1 4 1 1 0.0 1 1.0
-18 18.0 1 1 5 1 1 0.0 1 1.0
-18 18.0 1 1 6 1 1 0.0 1 1.0
-18 18.0 1 1 7 1 1 0.0 1 1.0
-18 18.0 1 1 8 1 1 0.0 1 1.0
-18 18.0 1 1 9 1 1 0.0 1 1.0
-PREHOOK: query: select * from (select count(c_int) over(), sum(c_float) over(), max(c_int) over(), min(c_int) over(), row_number() over() as rn, rank() over(), dense_rank() over(), percent_rank() over(), lead(c_int, 2, c_int) over(partition by c_boolean order by c_float), lag(c_float, 2, c_float) over(partition by c_boolean order by c_float) from cbo_t1 order by rn) cbo_t1
+0 NULL NULL NULL 1 1 1 0.0 NULL NULL
+0 NULL NULL NULL 2 1 1 0.0 NULL NULL
+16 16.0 1 1 10 5 3 0.24 1 1.0
+16 16.0 1 1 11 5 3 0.24 1 1.0
+16 16.0 1 1 12 5 3 0.24 1 1.0
+16 16.0 1 1 13 5 3 0.24 1 1.0
+16 16.0 1 1 14 5 3 0.24 1 1.0
+16 16.0 1 1 15 5 3 0.24 1 1.0
+16 16.0 1 1 16 5 3 0.24 1 1.0
+16 16.0 1 1 5 5 3 0.24 1 1.0
+16 16.0 1 1 6 5 3 0.24 1 1.0
+16 16.0 1 1 7 5 3 0.24 1 1.0
+16 16.0 1 1 8 5 3 0.24 1 1.0
+16 16.0 1 1 9 5 3 0.24 1 1.0
+18 18.0 1 1 17 17 4 0.94 1 1.0
+18 18.0 1 1 18 17 4 0.94 1 1.0
+2 2.0 1 1 1 1 1 0.0 1 1.0
+2 2.0 1 1 2 1 1 0.0 1 1.0
+4 4.0 1 1 3 3 2 0.12 1 1.0
+4 4.0 1 1 4 3 2 0.12 1 1.0
+PREHOOK: query: select * from (select count(c_int) over(partition by c_float order by key), sum(c_float) over(partition by c_float order by key), max(c_int) over(partition by c_float order by key), min(c_int) over(partition by c_float order by key), row_number() over(partition by c_float order by key) as rn, rank() over(partition by c_float order by key), dense_rank() over(partition by c_float order by key), round(percent_rank() over(partition by c_float order by key),2), lead(c_int, 2, c_int) over(partition by c_float order by key ), lag(c_float, 2, c_float) over(partition by c_float order by key) from cbo_t1 order by rn) cbo_t1
PREHOOK: type: QUERY
PREHOOK: Input: default@cbo_t1
PREHOOK: Input: default@cbo_t1@dt=2014
#### A masked pattern was here ####
-POSTHOOK: query: select * from (select count(c_int) over(), sum(c_float) over(), max(c_int) over(), min(c_int) over(), row_number() over() as rn, rank() over(), dense_rank() over(), percent_rank() over(), lead(c_int, 2, c_int) over(partition by c_boolean order by c_float), lag(c_float, 2, c_float) over(partition by c_boolean order by c_float) from cbo_t1 order by rn) cbo_t1
+POSTHOOK: query: select * from (select count(c_int) over(partition by c_float order by key), sum(c_float) over(partition by c_float order by key), max(c_int) over(partition by c_float order by key), min(c_int) over(partition by c_float order by key), row_number() over(partition by c_float order by key) as rn, rank() over(partition by c_float order by key), dense_rank() over(partition by c_float order by key), round(percent_rank() over(partition by c_float order by key),2), lead(c_int, 2, c_int) over(partition by c_float order by key ), lag(c_float, 2, c_float) over(partition by c_float order by key) from cbo_t1 order by rn) cbo_t1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@cbo_t1
POSTHOOK: Input: default@cbo_t1@dt=2014
#### A masked pattern was here ####
-18 18.0 1 1 1 1 1 0.0 NULL NULL
-18 18.0 1 1 10 1 1 0.0 1 1.0
-18 18.0 1 1 11 1 1 0.0 1 1.0
-18 18.0 1 1 12 1 1 0.0 1 1.0
-18 18.0 1 1 13 1 1 0.0 1 1.0
-18 18.0 1 1 14 1 1 0.0 1 1.0
-18 18.0 1 1 15 1 1 0.0 1 1.0
-18 18.0 1 1 16 1 1 0.0 1 1.0
-18 18.0 1 1 17 1 1 0.0 1 1.0
-18 18.0 1 1 18 1 1 0.0 1 1.0
-18 18.0 1 1 19 1 1 0.0 1 1.0
-18 18.0 1 1 2 1 1 0.0 NULL NULL
-18 18.0 1 1 20 1 1 0.0 1 1.0
-18 18.0 1 1 3 1 1 0.0 1 1.0
-18 18.0 1 1 4 1 1 0.0 1 1.0
-18 18.0 1 1 5 1 1 0.0 1 1.0
-18 18.0 1 1 6 1 1 0.0 1 1.0
-18 18.0 1 1 7 1 1 0.0 1 1.0
-18 18.0 1 1 8 1 1 0.0 1 1.0
-18 18.0 1 1 9 1 1 0.0 1 1.0
+0 NULL NULL NULL 1 1 1 0.0 NULL NULL
+0 NULL NULL NULL 2 1 1 0.0 NULL NULL
+16 16.0 1 1 10 5 3 0.24 1 1.0
+16 16.0 1 1 11 5 3 0.24 1 1.0
+16 16.0 1 1 12 5 3 0.24 1 1.0
+16 16.0 1 1 13 5 3 0.24 1 1.0
+16 16.0 1 1 14 5 3 0.24 1 1.0
+16 16.0 1 1 15 5 3 0.24 1 1.0
+16 16.0 1 1 16 5 3 0.24 1 1.0
+16 16.0 1 1 5 5 3 0.24 1 1.0
+16 16.0 1 1 6 5 3 0.24 1 1.0
+16 16.0 1 1 7 5 3 0.24 1 1.0
+16 16.0 1 1 8 5 3 0.24 1 1.0
+16 16.0 1 1 9 5 3 0.24 1 1.0
+18 18.0 1 1 17 17 4 0.94 1 1.0
+18 18.0 1 1 18 17 4 0.94 1 1.0
+2 2.0 1 1 1 1 1 0.0 1 1.0
+2 2.0 1 1 2 1 1 0.0 1 1.0
+4 4.0 1 1 3 3 2 0.12 1 1.0
+4 4.0 1 1 4 3 2 0.12 1 1.0
PREHOOK: query: select x from (select count(c_int) over() as x, sum(c_float) over() from cbo_t1) cbo_t1
PREHOOK: type: QUERY
PREHOOK: Input: default@cbo_t1