Query Options
This document contains all the available 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) | false (disabled) |
explainPlanVerbose | Return verbose result for EXPLAIN query (introduced in 0.11.0) | false (not verbose) |
useMultistageEngine | Use multi-stage engine to execute the query (introduced in 0.11.0) | false (use single-stage engine) |
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) | 1 (only query servers within the same replica-group) |
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 | false (exclude the replaced records) |
useStarTree | Useful to debug the star-tree index (introduced in 0.11.0) | true (use star-tree if available) |
AndScanReordering | disabled |
After release 0.11.0, query options can be set using the
SET statement:SET key1 = 'value1';
SET key2 = 123;
SELECT * FROM myTable
Before release 0.11.0, query options can be appended to the query with the
OPTION keyword:SELECT * FROM myTable OPTION(key1=value1, key2=123)
SELECT * FROM myTable OPTION(key1=value1) OPTION(key2=123)
SELECT * FROM myTable OPTION(timeoutMs=30000)
Last modified 29d ago