Introduced in release: 1.19
Drill's ElasticSearch storage plugin allows you to perform SQL queries against ElasticSearch indices. This storage plugin implementation is based on Apache Calcite adapter for ElasticSearch.
For more details about supported versions please refer to Supported versions page.
This storage plugin supports the following optimizations:
Besides these optimizations, ElasticSearch storage plugin supports the schema provisioning feature. For more details please refer to Specifying the Schema as Table Function Parameter.
The plugin can be registered in Apache Drill using the drill web interface by navigating to the storage
page. Following is the default registration configuration.
{ "type": "elastic", "hosts": [ "http://localhost:9200" ], "credentialsProvider": { "credentialsProviderType": "PlainCredentialsProvider", "credentials": { "username": "elastic", "password": "password" } }, "enabled": false }
|----------|-----------------------|----------------------------------------------------| | Option | Default | Description | |----------|-----------------------|----------------------------------------------------| | type | (none) | Set to “elastic” to use this plugin | | hosts | http://localhost:9200 | List of ElasticSearch hosts to be queried by Drill | | username | null | ElasticSearch username to be used by Drill | | password | null | ElasticSearch password to be used by Drill | |----------|-----------------------|----------------------------------------------------|