blob: 3f6ddbb8d9080f020705b4834356d07942f35313 [file] [log] [blame]
====
---- QUERY
# Check if count(*) optimization works correctly.
select count(*) from alltypesagg_parquet_v2_uncompressed
---- RESULTS
11000
---- TYPES
BIGINT
====
---- QUERY
select count(*) from alltypesagg_parquet_v2_snappy
---- RESULTS
11000
---- TYPES
BIGINT
====
---- QUERY
# Check that definition levels are decoded correctly.
select count(double_col) from alltypesagg_parquet_v2_uncompressed
---- RESULTS
10980
---- TYPES
BIGINT
====
---- QUERY
select count(double_col) from alltypesagg_parquet_v2_snappy
---- RESULTS
10980
---- TYPES
BIGINT
====
---- QUERY
# Check that values are decoded correctly.
select distinct double_col from alltypesagg_parquet_v2_uncompressed
order by double_col limit 5
---- RESULTS
10.1
20.2
30.3
40.4
50.5
---- TYPES
double
====
---- QUERY
select distinct double_col from alltypesagg_parquet_v2_snappy
order by double_col limit 5
---- RESULTS
10.1
20.2
30.3
40.4
50.5
---- TYPES
double
====
---- QUERY
# Check that repetition levels are decoded correctly.
select int_array from complextypestbl_parquet_v2_uncompressed
---- RESULTS
'[1,2,3]'
'[null,1,2,null,3,null]'
'[]'
'NULL'
'NULL'
'NULL'
'NULL'
'[-1]'
---- TYPES
string
====
---- QUERY
select int_array from complextypestbl_parquet_v2_snappy
---- RESULTS
'[1,2,3]'
'[null,1,2,null,3,null]'
'[]'
'NULL'
'NULL'
'NULL'
'NULL'
'[-1]'
---- TYPES
string
====
---- QUERY
# Check that DELTA_BINARY_PACKED encoding returns an error message.
select count(id) from alltypesagg_parquet_v2_snappy
---- CATCH
unsupported encoding: DELTA_BINARY_PACKED for column 'id'
====
---- QUERY
# Check that DELTA_BYTE_ARRAY encoding returns an error message.
select count(string_col) from alltypesagg_parquet_v2_snappy
---- CATCH
unsupported encoding: DELTA_BYTE_ARRAY for column 'string_col'
====