Return-Path: X-Original-To: apmail-hive-commits-archive@www.apache.org Delivered-To: apmail-hive-commits-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id B87CD18352 for ; Tue, 23 Jun 2015 18:45:14 +0000 (UTC) Received: (qmail 35234 invoked by uid 500); 23 Jun 2015 18:45:14 -0000 Delivered-To: apmail-hive-commits-archive@hive.apache.org Received: (qmail 35192 invoked by uid 500); 23 Jun 2015 18:45: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 35181 invoked by uid 99); 23 Jun 2015 18:45: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; Tue, 23 Jun 2015 18:45:14 +0000 Received: by git1-us-west.apache.org (ASF Mail Server at git1-us-west.apache.org, from userid 33) id 3DC7FE04E4; Tue, 23 Jun 2015 18:45:14 +0000 (UTC) Content-Type: text/plain; charset="us-ascii" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit From: hashutosh@apache.org To: commits@hive.apache.org Message-Id: <2c473463ad7b40cebad56e6b95ecfc88@git.apache.org> X-Mailer: ASF-Git Admin Mailer Subject: hive git commit: HIVE-11083 : Make test cbo_windowing robust (Ashutosh Chauhan via Hari Sankar Subramaniyan) Date: Tue, 23 Jun 2015 18:45:14 +0000 (UTC) Repository: hive Updated Branches: refs/heads/branch-1.2 ebd24aee4 -> fb51422e7 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/fb51422e Tree: http://git-wip-us.apache.org/repos/asf/hive/tree/fb51422e Diff: http://git-wip-us.apache.org/repos/asf/hive/diff/fb51422e Branch: refs/heads/branch-1.2 Commit: fb51422e7e0b9f150565f5a034b8d09fb55e37fc Parents: ebd24ae Author: Ashutosh Chauhan Authored: Tue Jun 23 11:43:04 2015 -0700 Committer: Ashutosh Chauhan Committed: Tue Jun 23 11:44:57 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/fb51422e/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/fb51422e/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/fb51422e/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