Use the MAX_RESULT_SPOOLING_MEM query option to set the
maximum amount of memory used when spooling query results.
If the amount of memory exceeds this value when spooling query results, all memory will most likely be spilled to disk.
The MAX_RESULT_SPOOLING_MEM query option is applicable
only when query result spooling is enabled with the
SPOOL_QUERY_RESULTS query option set to
TRUE.
Setting the option to 0 or -1 means the
memory is unbounded.
You cannot set this query option to values below -1.
Type:
INT
Default:
100 * 1024 * 1024 (100 MB)
Added in: Impala 3.4
Related information: FETCH_ROWS_TIMEOUT_MS Query Option, MAX_SPILLED_RESULT_SPOOLING_MEM Query Option, SPOOL_QUERY_RESULTS Query Option