====
---- QUERY
# IMPALA-7076: this query will fail if the Kudu scan spins up too many scanner threads.
# Only one scanner thread per impalad should be started.
# Set num_scanner_threads to reduce the row batch queue length and avoid IMPALA-7465.
set num_scanner_threads=2;
set mem_limit="6.5mb";
select * from tpch_kudu.orders
order by o_orderkey limit 3;
---- TYPES
BIGINT,BIGINT,STRING,DECIMAL,STRING,STRING,STRING,INT,STRING
---- RESULTS
1,36901,'O',173665.47,'1996-01-02','5-LOW','Clerk#000000951',0,'nstructions sleep furiously among '
2,78002,'O',46929.18,'1996-12-01','1-URGENT','Clerk#000000880',0,' foxes. pending accounts at the pending, silent asymptot'
3,123314,'F',193846.25,'1993-10-14','5-LOW','Clerk#000000955',0,'sly final accounts boost. carefully regular ideas cajole carefully. depos'
---- RUNTIME_PROFILE
aggregation(SUM, NumScannerThreadsStarted): 3
====
---- QUERY
# Test with lower limit that reliably hits memory limit exceeded.
set disable_codegen=true;
set mem_limit=32k;
select * from tpch_kudu.orders
order by o_orderkey limit 3;
---- CATCH
Memory limit exceeded
====