MAX_MEM_ESTIMATE_FOR_ADMISSION Query Option
MAX_MEM_ESTIMATE_FOR_ADMISSION query option to set an upper limit
on the memory estimates of a query as a workaround for over-estimates precluding a query
from being admitted.
The query option takes effect when all of the below conditions are met:
- Memory-based admission control is enabled for the pool.
MEM_LIMITquery option is not set at the query, session, resource pool, or global level.
When the above conditions are met, MIN(
mem_estimate) is used for admission control.
MEM_LIMIT query option is usually a better option. Use the
MAX_MEM_ESTIMATE_FOR_ADMISSION query option when it is not feasible to
MEM_LIMIT for each individual query.
Added in: Impala 3.1