Settings
You can use AQL to set and get settings for its environment in an interactive session. Additionally, some settings can be set using the command-line which is useful when you would like to run a command without opening an interactive session by using the --command
or -c
option.
To get the value of a setting, run:
aql> get <setting>
Where <setting>
is the name of the setting.
The following is an example of getting the setting for OUTPUT
:
aql> get output
OUTPUT = TABLE
To set the value of a setting, run:
aql> set <setting> <value>
Where:
<setting>
is the name of the setting.<value>
is the value to change the setting to.
The following is an example of setting OUTPUT=JSON
.
aql> set output json
The available settings are:
ECHOโ
Echo commands. Also available using the --echo
flag.
ECHO (TRUE | FALSE)
OUTPUTโ
The output mode. Also available using the --output
flag.
OUTPUT (TABLE | JSON | MUTE | RAW)
Example
aql> set output table
OUTPUT_TYPESโ
Disable printing of type of the data value such as GeoJSON, LIST, MAP_KEY_ORDERED, and so on. The output mode. Also available using the --outputtypes
flag.
OUTPUT_TYPES (FALSE | TRUE)
VERBOSEโ
Enable verbose output. The output mode. Also available using the --verbose
flag.
VERBOSE (TRUE | FALSE)
TIMEOUTโ
The time, in milliseconds, to wait for a query to complete. Also available using the --timeout
flag.
TIMEOUT <milliseconds>
SOCKET_TIMEOUTโ
Socket idle timeout in milliseconds for a query. Also available using the --socket-timeout
flag.
SOCKET_TIMEOUT <milliseconds>
LUA_USERPATHโ
The path to the user-managed Lua files. Also available using the --udfuser
flag.
LUA_USERPATH <path>
RECORD_TTLโ
The time, in seconds, that subsequently created or updated record will live before being evicted by the server.
RECORD_TTL <seconds>
RECORD_PRINT_METADATAโ
Enable printing of metadata (digest, ttl, generation) of the record. Valid only in JSON view.
RECORD_PRINT_METADATA (TRUE | FALSE)
REPLICA_ANYโ
Option removed as of aql 7.0.
Flag for sending the primary key lookup request to all the replicas in round-robin manner, not just master.
REPLICA_ANY (TRUE | FALSE)
KEY_SENDโ
Flag for sending the key to the server in read/write/delete operations.
KEY_SEND (TRUE | FALSE)
DURABLE_DELETEโ
Flag for setting policy value on the underlying C API calls used by DELETE, INSERT, EXECUTE, and SELECT (when doing a scan) operations. Applicable only for server version 3.10+. See Durable Delete for details.
DURABLE_DELETE (TRUE | FALSE)
The setting values set using aql are valid only for the current session. A new invoking of aql would have the default values.