# This query will do a full table scan to count the num of rows
# read during a scan
select * from alltypesagg
---- RUNTIME_PROFILE
row_regex: .*RowsRead: 11.00K .
====
---- QUERY
# This query verifies that a scan range is marked as skipped
# in the profile if the correct compression cannot be inferred
# for a scan range
select count(*) from tpcds_parquet.store_sales
---- RUNTIME_PROFILE
row_regex: .*File Formats: PARQUET/Unknown\(Skipped\):.*
====
---- QUERY
# This query verifies that a when a parquet scan range is runtime
# filtered, it is marked as skipped and the compression codec is
# marked as unknown.
set runtime_filter_wait_time_ms=500000;
select count(*) from tpcds_parquet.store_sales
join tpcds_parquet.date_dim on
ss_sold_date_sk = d_date_sk where d_qoy=1
---- RUNTIME_PROFILE
row_regex: .*File Formats: PARQUET/NONE:.* PARQUET/Unknown\(Skipped\).*
====
---- QUERY
# This query verifies that a when a text scan range is runtime
# filtered, it is marked as skipped.
set runtime_filter_wait_time_ms=100000;
select count(*) from tpcds.store_sales join tpcds.date_dim on
ss_sold_date_sk = d_date_sk where d_qoy=1
---- RUNTIME_PROFILE
row_regex: .*File Formats: TEXT/NONE:.* TEXT/NONE\(Skipped\):.*
====