blob: 940fd6eb6a58ad8bd068e2860151c0d256f9b3ca [file] [log] [blame]
====
---- QUERY
set mem_limit=10mb;
select distinct * from functional_parquet.alltypesagg
---- CATCH
minimum memory reservation is greater than memory available to the
query for buffer reservations. Memory reservation needed given the
current plan: 67.00 MB. Set mem_limit to at least 142.00 MB.
====
---- QUERY
set mem_limit=150mb;
select distinct * from functional_parquet.alltypesagg
---- CATCH
minimum memory reservation needed is greater than pool max mem resources.
Pool max mem resources: 10.00 MB.
Cluster-wide memory reservation needed: 201.00 MB
====
---- QUERY
set buffer_pool_limit=10mb;
select distinct * from functional_parquet.alltypesagg
---- CATCH
minimum memory reservation is greater than memory available to the query
for buffer reservations. Increase the buffer_pool_limit to 67.00 MB.
====
---- QUERY
set mem_limit=1024;
select count(*)
from tpch_parquet.lineitem join tpch_parquet.orders on l_orderkey = o_orderkey
---- CATCH
minimum memory reservation is greater than memory available to the
query for buffer reservations. Memory reservation needed given the
current plan: 4.75 MB. Set mem_limit to at least 79.75 MB.
====
---- QUERY
set mem_limit=80mb;
select count(*)
from tpch_parquet.lineitem join tpch_parquet.orders on l_orderkey = o_orderkey
---- CATCH
minimum memory reservation is greater than memory available to the
query for buffer reservations. Memory reservation needed given the
current plan: 17.00 MB. Set mem_limit to at least 92.00 MB.
====