Database Reference
In-Depth Information
Command
option
Description
them. Mostly, the
set
command is used with specific options for fine
tuning or troubleshooting the queries.
To set
DEFAULT_ORDER_BY_LIMIT
to
10
, you can use the set com-
mand as follows:
> set default_order_by_limit=10;
Now, running the
set
command in the Impala shell returns the current
set query option, as shown in the following commands:
> set;
Default query options:
NUM_SCANNER_THREADS: 0
ABORT_ON_DEFAULT_LIMIT_EXCEEDED: 0
MAX_IO_BUFFERS: 0
DEFAULT_ORDER_BY_LIMIT: -1
BATCH_SIZE: 0
NUM_NODES: 0
DISABLE_CODEGEN: 0
MAX_ERRORS: 0
ABORT_ON_ERROR: 0
MAX_SCAN_RANGE_LENGTH: 0
ALLOW_UNSUPPORTED_FORMATS: 0
SUPPORT_START_OVER: false
DEBUG_ACTION:
MEM_LIMIT: 0
Query options currently set:
DEFAULT_ORDER_BY_LIMIT: 10
To unset the value, just use the
unset
command as follows: