====
---- QUERY
# A basic spilling query to exercise spill-to-disk end-to-end.
set buffer_pool_limit=90m;
set default_spillable_buffer_size=64k;
select count(*)
from (select distinct o_orderdate, o_custkey, o_comment
      from tpch_parquet.orders) v;
---- RESULTS
1500000
---- TYPES
BIGINT
---- RUNTIME_PROFILE
# Verify that spilling was activated.
row_regex: .*SpilledPartitions: .* \([1-9][0-9]*\)
====