Query Options
This document contains all the available query options
Supported Query Options
Key | Description | Default Behavior |
---|---|---|
timeoutMs | Timeout of the query in milliseconds | Use table/broker level timeout |
enableNullHandling | Enable the null handling of the query (introduced in 0.11.0) |
|
explainPlanVerbose | Return verbose result for |
|
useMultistageEngine | Use multi-stage engine to execute the query (introduced in 0.11.0) |
|
maxExecutionThreads | Maximum threads to use to execute the query. Useful to limit the resource usage for expensive queries | Half of the CPU cores for non-group-by queries; all CPU cores for group-by queries |
numReplicaGroupsToQuery | When replica-group based routing is enabled, use it to query multiple replica-groups (introduced in 0.11.0) |
|
minSegmentGroupTrimSize | Minimum groups to keep when trimming groups at the segment level for group-by queries. See Configuration Parameters | Server level config |
minServerGroupTrimSize | Minimum groups to keep when trimming groups at the server level for group-by queries. See Configuration Parameters | Server level config |
skipUpsert | For upsert-enabled table, skip the effect of upsert and query all the records. See Stream Ingestion with Upsert |
|
useStarTree | Useful to debug the star-tree index (introduced in 0.11.0) |
|
Set Query Options
Before release 0.11.0
Before release 0.11.0, query options can be appended to the query with the OPTION
keyword:
After release 0.11.0
After release 0.11.0, query options can be set using the SET
statement:
Last updated