hive-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From hashut...@apache.org
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 GMT
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 <hashutosh@apache.org>
Authored: Tue Jun 23 11:43:04 2015 -0700
Committer: Ashutosh Chauhan <hashutosh@apache.org>
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


Mime
View raw message