blob: 0c3dd048d8a6d8e42e086e7c9edbf4c7b4711c30 [file] [log] [blame]
====
---- QUERY
set TIMEZONE='Europe/Budapest';
select * from iceberg_non_partitioned tablesample system(10) repeatable(1234)
---- RESULTS
20,'Alex','view',2020-01-01 09:00:00
9,'Alan','click',2020-01-01 10:00:00
6,'Alex','view',2020-01-01 09:00:00
---- TYPES
INT, STRING, STRING, TIMESTAMP
====
---- QUERY
select count(*) from iceberg_non_partitioned tablesample system(10) repeatable(1234)
---- RESULTS
3
---- TYPES
BIGINT
====
---- QUERY
set TIMEZONE='Europe/Budapest';
select * from iceberg_partitioned tablesample system(10) repeatable(1234)
---- RESULTS
16,'Lisa','download',2020-01-01 11:00:00
3,'Alan','click',2020-01-01 10:00:00
---- TYPES
INT, STRING, STRING, TIMESTAMP
====
---- QUERY
select count(*) from iceberg_partitioned tablesample system(10) repeatable(1234)
---- RESULTS
2
---- TYPES
BIGINT
====
---- QUERY
set TIMEZONE='Europe/Budapest';
select * from iceberg_partitioned tablesample system(10) repeatable(1234)
where action = 'click';
---- RESULTS
10,'Alan','click',2020-01-01 10:00:00
---- TYPES
INT, STRING, STRING, TIMESTAMP
====