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.

Continue reading:

• ABORT_ON_DEFAULT_LIMIT_EXCEEDED Query Option
• ABORT_ON_ERROR Query Option
• ALLOW_UNSUPPORTED_FORMATS Query Option
• APPX_COUNT_DISTINCT Query Option (CDH 5.2 or higher only)
• BATCH_SIZE Query Option
• COMPRESSION_CODEC Query Option (CDH 5.2 or higher only)
• DEBUG_ACTION Query Option
• DEFAULT_ORDER_BY_LIMIT Query Option
• DISABLE_CODEGEN Query Option
• DISABLE_ROW_RUNTIME_FILTERING Query Option (CDH 5.7 or higher only)
• DISABLE_STREAMING_PREAGGREGATIONS Query Option (CDH 5.7 or higher only)
• DISABLE_UNSAFE_SPILLS Query Option (CDH 5.2 or higher only)
• EXEC_SINGLE_NODE_ROWS_THRESHOLD Query Option (CDH 5.3 or higher only)
• EXPLAIN_LEVEL Query Option
• HBASE_CACHE_BLOCKS Query Option
• HBASE_CACHING Query Option
• LIVE_PROGRESS Query Option (CDH 5.5 or higher only)
• LIVE_SUMMARY Query Option (CDH 5.5 or higher only)
• MAX_ERRORS Query Option
• MAX_IO_BUFFERS Query Option
• MAX_SCAN_RANGE_LENGTH Query Option
• MAX_NUM_RUNTIME_FILTERS Query Option (CDH 5.7 or higher only)
• MEM_LIMIT Query Option
• NUM_NODES Query Option
• NUM_SCANNER_THREADS Query Option
• OPTIMIZE_PARTITION_KEY_SCANS Query Option (CDH 5.7 or higher only)
• PARQUET_COMPRESSION_CODEC Query Option
• PARQUET_ANNOTATE_STRINGS_UTF8 Query Option (CDH 5.8 or higher only)
• PARQUET_FALLBACK_SCHEMA_RESOLUTION Query Option (CDH 5.8 or higher only)
• PARQUET_FILE_SIZE Query Option
• QUERY_TIMEOUT_S Query Option (CDH 5.2 or higher only)
• REQUEST_POOL Query Option
• SCHEDULE_RANDOM_REPLICA Query Option (CDH 5.7 or higher only)
• RESERVATION_REQUEST_TIMEOUT Query Option (CDH 5 only)
• RUNTIME_BLOOM_FILTER_SIZE Query Option (CDH 5.7 or higher only)
• RUNTIME_FILTER_MAX_SIZE Query Option (CDH 5.8 or higher only)
• RUNTIME_FILTER_MIN_SIZE Query Option (CDH 5.8 or higher only)
• RUNTIME_FILTER_MODE Query Option (CDH 5.7 or higher only)
• RUNTIME_FILTER_WAIT_TIME_MS Query Option (CDH 5.7 or higher only)
• S3_SKIP_INSERT_STAGING Query Option (CDH 5.8 or higher only)
• SCAN_NODE_CODEGEN_THRESHOLD Query Option (CDH 5.7 or higher only)
• SUPPORT_START_OVER Query Option
• SYNC_DDL Query Option
• V_CPU_CORES Query Option (CDH 5 only)

Related information:

SET Statement