Skip to main content
Loading

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โ€‹

removed

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)
info

The setting values set using aql are valid only for the current session. A new invoking of aql would have the default values.