settings.md

layout	title	parent	nav_order
default	Settings	SQL	16

Settings

The SQL plugin adds a few settings to the standard Elasticsearch cluster settings. Most are dynamic, so you can change the default behavior of the plugin without restarting your cluster.

You can update these settings like any other cluster setting:

PUT _cluster/settings
{
  "transient" : {
    "opendistro.sql.enabled" : false
  }
}

Setting	Default	Description
opendistro.sql.enabled	True	Change to false to disable the plugin.
opendistro.sql.query.slowlog	2 seconds	Configure the time limit (in seconds) for slow queries. The plugin logs slow queries as Slow query: elapsed=xxx (ms) in elasticsearch.log.
opendistro.sql.query.analysis.enabled	True	Enables or disables the query analyzer. Changing this setting to false lets you bypass strict syntactic and semantic analysis.
opendistro.sql.query.analysis.semantic.suggestion	False	If enabled, the query analyzer suggests correct field names for quick fixes.
opendistro.sql.query.analysis.semantic.threshold	200	Because query analysis needs to build semantic context in memory, indices with a large number of fields are be skipped. You can update this setting to apply analysis to smaller or larger indices as needed.
opendistro.sql.query.response.format	JDBC	Sets the default response format for queries. The supported formats are JDBC, JSON, CSV, raw, and table.
opendistro.sql.cursor.enabled	False	You can enable or disable pagination for all queries that are supported.
opendistro.sql.cursor.fetch_size	1,000	You can set the default fetch_size for all queries that are supported by pagination. An explicit fetch_size passed in request overrides this value.
opendistro.sql.cursor.keep_alive	1 minute	This value configures how long the cursor context is kept open. Cursor contexts are resource heavy, so we recommend a low value.
opendistro.sql.engine.new.enabled	True	Enables or disables the new query engine. This setting must be true in order to use date and time functions.
opendistro.query.size_limit	200	Defines the default index size. Cannot be greater than the maximum result window value (10000 by default).