You can specify the following options within an impala-shell session, 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.

  Note: Currently, there is no way to set query options directly through the JDBC and ODBC interfaces. For JDBC and ODBC applications, you can execute queries that need specific query options by invoking impala-shell to run a script that starts with SET commands, or by defining query options globally through the impalad startup flag --default_query_options.

Continue reading:

• ABORT_ON_DEFAULT_LIMIT_EXCEEDED
• ABORT_ON_ERROR
• ALLOW_UNSUPPORTED_FORMATS
• BATCH_SIZE
• DEBUG_ACTION
• DEFAULT_ORDER_BY_LIMIT
• DISABLE_CODEGEN
• EXPLAIN_LEVEL
• HBASE_CACHE_BLOCKS
• HBASE_CACHING
• MAX_ERRORS
• MAX_IO_BUFFERS
• MAX_SCAN_RANGE_LENGTH
• MEM_LIMIT
• NUM_NODES
• NUM_SCANNER_THREADS
• PARQUET_COMPRESSION_CODEC
• PARQUET_FILE_SIZE
• REQUEST_POOL
• RESERVATION_REQUEST_TIMEOUT (CDH 5 Only)
• SUPPORT_START_OVER
• SYNC_DDL
• V_CPU_CORES (CDH 5 Only)