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 etc. 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.