testdata/workloads/functional-query/queries/QueryTest/iceberg-tablesample-v2.test

====
---- QUERY
select * from iceberg_v2_no_deletes tablesample system(10) repeatable(1234)
---- RESULTS
1,'x'
2,'y'
3,'z'
---- TYPES
INT, STRING
====
---- QUERY
select count(*) from iceberg_v2_no_deletes tablesample system(10) repeatable(1234)
---- RESULTS
3
---- TYPES
BIGINT
====
---- QUERY
select * from iceberg_v2_positional_not_all_data_files_have_delete_files tablesample system(10) repeatable(1234)
---- RESULTS
5,'X'
---- TYPES
INT, STRING
====
---- QUERY
select count(*) from iceberg_v2_positional_not_all_data_files_have_delete_files tablesample system(10) repeatable(1234)
---- RESULTS
1
---- TYPES
BIGINT
====
---- QUERY
select * from iceberg_v2_partitioned_position_deletes tablesample system(50) repeatable(1234);
---- RESULTS
18,'Alan','click',2020-01-01 10:00:00
12,'Alan','click',2020-01-01 10:00:00
10,'Alan','click',2020-01-01 10:00:00
6,'Alex','view',2020-01-01 09:00:00
20,'Alex','view',2020-01-01 09:00:00
4,'Alex','view',2020-01-01 09:00:00
---- TYPES
INT, STRING, STRING, TIMESTAMP
====
---- QUERY
select * from iceberg_v2_partitioned_position_deletes tablesample system(50) repeatable(1234)
where action = 'click';
---- RESULTS
18,'Alan','click',2020-01-01 10:00:00
12,'Alan','click',2020-01-01 10:00:00
10,'Alan','click',2020-01-01 10:00:00
---- TYPES
INT, STRING, STRING, TIMESTAMP
====
---- QUERY
select * from iceberg_v2_no_deletes_orc tablesample system(10) repeatable(1234)
---- RESULTS
1,'x'
2,'y'
3,'z'
---- TYPES
INT, STRING
====
---- QUERY
select count(*) from iceberg_v2_no_deletes_orc tablesample system(10) repeatable(1234)
---- RESULTS
3
---- TYPES
BIGINT
====
---- QUERY
select * from iceberg_v2_positional_not_all_data_files_have_delete_files_orc tablesample system(10) repeatable(1234)
---- RESULTS
5,'X'
---- TYPES
INT, STRING
====
---- QUERY
select count(*) from iceberg_v2_positional_not_all_data_files_have_delete_files tablesample system(10) repeatable(1234)
---- RESULTS
1
---- TYPES
BIGINT
====
---- QUERY
select * from iceberg_v2_partitioned_position_deletes_orc tablesample system(50) repeatable(1234);
---- RESULTS
20,'Alex','view',2020-01-01 09:00:00
6,'Alex','view',2020-01-01 09:00:00
4,'Alex','view',2020-01-01 09:00:00
12,'Alan','click',2020-01-01 10:00:00
18,'Alan','click',2020-01-01 10:00:00
10,'Alan','click',2020-01-01 10:00:00
---- TYPES
INT, STRING, STRING, TIMESTAMP
====
---- QUERY
select * from iceberg_v2_partitioned_position_deletes_orc tablesample system(50) repeatable(1234)
where action = 'click';
---- RESULTS
12,'Alan','click',2020-01-01 10:00:00
18,'Alan','click',2020-01-01 10:00:00
10,'Alan','click',2020-01-01 10:00:00
---- TYPES
INT, STRING, STRING, TIMESTAMP
====