RUNTIME_FILTER_MAX_SIZE Query Option (CDH 5.8 or higher only)
The RUNTIME_FILTER_MAX_SIZE query option adjusts the settings for the runtime filtering feature. This option defines the maximum size for a filter, no matter what the estimates produced by the planner are. This value also overrides any lower number specified for the RUNTIME_BLOOM_FILTER_SIZE query option. Filter sizes are rounded up to the nearest power of two.
Default: 0 (meaning use the value from the corresponding impalad startup option)
Added in: CDH 5.8.0 / Impala 2.6.0
Because the runtime filtering feature applies mainly to resource-intensive and long-running queries, only adjust this query option when tuning long-running queries involving some combination of large partitioned tables and joins involving large tables.
Runtime Filtering for Impala Queries (CDH 5.7 or higher only), RUNTIME_FILTER_MODE Query Option (CDH 5.7 or higher only), RUNTIME_FILTER_MIN_SIZE Query Option (CDH 5.8 or higher only), RUNTIME_BLOOM_FILTER_SIZE Query Option (CDH 5.7 or higher only)