To specify request-level parameters for the Analytics Service, do one of the following:
-
In the Analytics Workbench, click the cog icon to display the Run-Time Preferences window.
-
Use the
\SET
command in the cbq Shell. -
Use the Service API.
Common Parameters
The Analytics Service supports the following parameters in common with the Query Service.
For more information on these common parameters, refer to Request-Level Parameters.
Property | Schema | |
---|---|---|
statement |
Specifies at least one valid SQL++ for Analytics statement to run. |
String |
client_context_id |
An identifier passed by the client that is returned verbatim in the query response. Useful for matching a particular query to a specific caller. |
String |
format |
Desired format for the query results. Note that the only possible format is Values: |
String |
pretty |
If Default: |
Boolean |
query_context |
A scope for the statement. The value of this parameter must start with Default: |
String |
readonly |
If Default: |
Boolean |
scan_consistency |
The consistency guarantee constraint for index scanning. If Values: |
String |
scan_wait |
The maximum time to wait for datasets to be updated before the query is executed. The format includes an amount and a unit: Default: |
String |
timeout |
Maximum time to spend on the request before timing out. The format includes an amount and a unit: Default: |
String |
args |
An array of positional parameter values. |
Any Type array |
additional |
A named parameter value. |
Any Type |
The Analytics Service API does not support the prepared parameter.
|
The Analytics Service API does not support the at_plus or
statement_plus settings for scan consistency.
|
Analytics Parameters
In addition, the Service API supports the following parameters which are unique to Analytics.
Property | Schema | |
---|---|---|
plan-format |
The plan format. Values: |
String |
logical-plan |
If Default: |
Boolean |
optimized-logical-plan |
If Default: |
Boolean |
expression-tree |
If Default: |
Boolean |
rewritten-expression-tree |
If Default: |
Boolean |
job |
If Default: |
Boolean |
max-warnings |
An integer specifying the maximum number of warning messages to be included in the query response. Default: |
Integer (int32) |