blob: 9127bd4dd4c6f3ee4e19748241470e820df8bfab (
plain) (
tree)
|
|
-- Automatically generated by SQLQueryTestSuite
-- Number of queries: 6
-- !query 0
create temporary view myview as values 128, 256 as v(int_col)
-- !query 0 schema
struct<>
-- !query 0 output
-- !query 1
select int_col, count(*) from myview group by int_col
-- !query 1 schema
struct<int_col:int,count(1):bigint>
-- !query 1 output
128 1
256 1
-- !query 2
select 'foo', count(*) from myview group by 1
-- !query 2 schema
struct<foo:string,count(1):bigint>
-- !query 2 output
foo 2
-- !query 3
select 'foo' from myview where int_col == 0 group by 1
-- !query 3 schema
struct<foo:string>
-- !query 3 output
-- !query 4
select 'foo', approx_count_distinct(int_col) from myview where int_col == 0 group by 1
-- !query 4 schema
struct<foo:string,approx_count_distinct(int_col):bigint>
-- !query 4 output
-- !query 5
select 'foo', max(struct(int_col)) from myview where int_col == 0 group by 1
-- !query 5 schema
struct<foo:string,max(struct(int_col)):struct<int_col:int>>
-- !query 5 output
|
