testdata/workloads/functional-query/queries/QueryTest/spilling-query-options.test

====
---- QUERY
# tpch_avro does not have stats computed, so if we set disable_unsafe_spills we should
# not spill to disk.
set disable_unsafe_spills=true;
set buffer_pool_limit=40m;
select distinct *
from tpch_avro.orders
---- CATCH
Could not free memory by spilling to disk: spilling was disabled by planner. Re-enable spilling by setting the query option DISABLE_UNSAFE_SPILLS=false
====
---- QUERY
# IMPALA-5823: make sure that SET_DENY_RESERVATION_PROBABILITY takes effect on PREPARE.
set debug_action="-1:PREPARE:SET_DENY_RESERVATION_PROBABILITY@1.0";
select count(*) from (
  select distinct o_orderdate, o_custkey, o_comment
  from tpch_parquet.orders where o_orderkey < 500000) v;
---- TYPES
BIGINT
---- RESULTS
124999
---- RUNTIME_PROFILE
row_regex: .*SpilledPartitions: .* \([1-9][0-9]*\)
row_regex: .*RowsPassedThrough: .* \([1-9][0-9]*\)
====
---- QUERY
# IMPALA-5823: make sure that SET_DENY_RESERVATION_PROBABILITY takes effect on OPEN.
set debug_action="-1:OPEN:SET_DENY_RESERVATION_PROBABILITY@1.0";
select count(*) from (
  select distinct o_orderdate, o_custkey, o_comment
  from tpch_parquet.orders where o_orderkey < 500000) v;
---- TYPES
BIGINT
---- RESULTS
124999
---- RUNTIME_PROFILE
row_regex: .*SpilledPartitions: .* \([1-9][0-9]*\)
row_regex: .*RowsPassedThrough: .* \([1-9][0-9]*\)
====
---- QUERY
# IMPALA-5823: make sure that SET_DENY_RESERVATION_PROBABILITY takes effect on GETNEXT.
# This won't affect the merge aggregation, which accumulates its memory in Open(), but
# will affect the streaming aggregation.
set debug_action="-1:GETNEXT:SET_DENY_RESERVATION_PROBABILITY@1.0";
select count(*) from (
  select distinct o_orderdate, o_custkey, o_comment
  from tpch_parquet.orders where o_orderkey < 500000) v;
---- TYPES
BIGINT
---- RESULTS
124999
---- RUNTIME_PROFILE
row_regex: .*RowsPassedThrough: .* \([1-9][0-9]*\)
====