Query Options

Query options provide control over the Hydrolix query system. These settings control output format, pool selection, query rate limiting, circuit breakers and observability features. They're available over the many Query Interfaces.

The wide array of mechanisms for setting query options is intended to support as many query interfaces and client applications as possible. For example, some HTTP query clients can set query parameters, but can't easily add HTTP headers.

For every query, options are collected from all of the below supported by that interface. Later-defined query options always take precedence.

• System defaults (all interfaces)
• Organization (org), project, table query options (in-cluster interfaces)
• HTTP query headers (HTTP query API only)
• HTTP query parameters (HTTP query API only)
• SQL SETTINGS clause (for clients with SQL dialect supporting SETTINGS)

The last applied query option setting wins.

Read more

• See the Table of Query Options for the terse listing of all available query options and how each can be conveyed to the query system.
• See Query Options Precedenceto learn how query options are resolved when specified in the SQL query, as HTTP headers or query parameters, and on projects and tables.
• See Query Options Reference for a detailed description of all query options.