blob: 6741703d9d82c1516f828654e2b924ef573371b8 (
plain) (
blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
|
-- Temporary data.
create temporary view myview as values 128, 256 as v(int_col);
-- group by should produce all input rows,
select int_col, count(*) from myview group by int_col;
-- group by should produce a single row.
select 'foo', count(*) from myview group by 1;
-- group-by should not produce any rows (whole stage code generation).
select 'foo' from myview where int_col == 0 group by 1;
-- group-by should not produce any rows (hash aggregate).
select 'foo', approx_count_distinct(int_col) from myview where int_col == 0 group by 1;
-- group-by should not produce any rows (sort aggregate).
select 'foo', max(struct(int_col)) from myview where int_col == 0 group by 1;
|
