Query Options for the SET Statement

You can specify the following options using the SET statement, and those settings affect all queries issued from that session.

Some query options are useful in day-to-day operations for improving usability, performance, or flexibility.

Other query options control special-purpose aspects of Impala operation and are intended primarily for advanced debugging or troubleshooting.

Options with Boolean parameters can be set to 1 or true to enable, or 0 or false to turn off.

Note:

In Impala 2.0 and later, you can set query options directly through the JDBC and ODBC interfaces by using the SET statement. Formerly, SET was only available as a command within the impala-shell interpreter.

In Impala 2.11 and later, you can set query options for an impala-shell session by specifying one or more command-line arguments of the form --query_option=option=value. See impala-shell Configuration Options for details.

Related information:

SET Statement

• ABORT_ON_ERROR Query Option

• ALLOW_UNSUPPORTED_FORMATS Query Option

• APPX_COUNT_DISTINCT Query Option (Impala 2.0 or higher only)

• BATCH_SIZE Query Option

• BUFFER_POOL_LIMIT Query Option

• COMPRESSION_CODEC Query Option (Impala 2.0 or higher only)

• COMPUTE_STATS_MIN_SAMPLE_SIZE Query Option

• DEBUG_ACTION Query Option

• DECIMAL_V2 Query Option

• DEFAULT_JOIN_DISTRIBUTION_MODE Query Option

• DEFAULT_SPILLABLE_BUFFER_SIZE Query Option

• DISABLE_CODEGEN Query Option

• DISABLE_ROW_RUNTIME_FILTERING Query Option (Impala 2.5 or higher only)

• DISABLE_STREAMING_PREAGGREGATIONS Query Option (Impala 2.5 or higher only)

• DISABLE_UNSAFE_SPILLS Query Option (Impala 2.0 or higher only)

• EXEC_SINGLE_NODE_ROWS_THRESHOLD Query Option (Impala 2.1 or higher only)

• EXEC_TIME_LIMIT_S Query Option (Impala 2.12 or higher only)

• EXPLAIN_LEVEL Query Option

• HBASE_CACHE_BLOCKS Query Option

• HBASE_CACHING Query Option

• LIVE_PROGRESS Query Option (Impala 2.3 or higher only)

• LIVE_SUMMARY Query Option (Impala 2.3 or higher only)

• MAX_ERRORS Query Option

• MAX_ROW_SIZE Query Option

• MAX_NUM_RUNTIME_FILTERS Query Option (Impala 2.5 or higher only)

• MAX_SCAN_RANGE_LENGTH Query Option

• MEM_LIMIT Query Option

• MIN_SPILLABLE_BUFFER_SIZE Query Option

• MT_DOP Query Option

• NUM_NODES Query Option

• NUM_SCANNER_THREADS Query Option

• OPTIMIZE_PARTITION_KEY_SCANS Query Option (Impala 2.5 or higher only)

• PARQUET_COMPRESSION_CODEC Query Option

• PARQUET_ANNOTATE_STRINGS_UTF8 Query Option (Impala 2.6 or higher only)

• PARQUET_ARRAY_RESOLUTION Query Option (Impala 2.9 or higher only)

• PARQUET_FALLBACK_SCHEMA_RESOLUTION Query Option (Impala 2.6 or higher only)

• PARQUET_FILE_SIZE Query Option

• PREFETCH_MODE Query Option (Impala 2.6 or higher only)

• QUERY_TIMEOUT_S Query Option (Impala 2.0 or higher only)

• REQUEST_POOL Query Option

• REPLICA_PREFERENCE Query Option (Impala 2.7 or higher only)

• RUNTIME_BLOOM_FILTER_SIZE Query Option (Impala 2.5 or higher only)

• RUNTIME_FILTER_MAX_SIZE Query Option (Impala 2.6 or higher only)

• RUNTIME_FILTER_MIN_SIZE Query Option (Impala 2.6 or higher only)

• RUNTIME_FILTER_MODE Query Option (Impala 2.5 or higher only)

• RUNTIME_FILTER_WAIT_TIME_MS Query Option (Impala 2.5 or higher only)

• S3_SKIP_INSERT_STAGING Query Option (Impala 2.6 or higher only)

• SCHEDULE_RANDOM_REPLICA Query Option (Impala 2.5 or higher only)

• SCRATCH_LIMIT Query Option

• SHUFFLE_DISTINCT_EXPRS Query Option

• SUPPORT_START_OVER Query Option

• SYNC_DDL Query Option

Parent topic: SET Statement