This is an automated email from the ASF dual-hosted git repository. dzamo pushed a commit to branch gh-pages in repository https://gitbox.apache.org/repos/asf/drill.git
commit a485287d9aef0054401a72c2838aea5c24cec06d Author: James Turton <[email protected]> AuthorDate: Sat Jun 19 06:24:38 2021 +0200 Document Casssandra storage plugin. --- _data/docs.json | 131 ++++++++++++++------- .../plugins/130-elasticsearch-plugin.md | 6 +- .../plugins/140-splunk-storage-plugin.md | 4 +- .../plugins/150-cassandra-storage-plugin.md | 51 ++++++++ 4 files changed, 147 insertions(+), 45 deletions(-) diff --git a/_data/docs.json b/_data/docs.json index e70c1ea..a8ef582 100644 --- a/_data/docs.json +++ b/_data/docs.json @@ -1186,6 +1186,23 @@ "title": "CREATE VIEW", "url": "/docs/create-view/" }, + "Cassandra Storage Plugin": { + "breadcrumbs": [ + { + "title": "Connect a Data Source", + "url": "/docs/connect-a-data-source/" + } + ], + "children": [], + "next_title": "ODBC/JDBC Interfaces", + "next_url": "/docs/odbc-jdbc-interfaces/", + "parent": "Connect a Data Source", + "previous_title": "Splunk Storage Plugin", + "previous_url": "/docs/splunk-storage-plugin/", + "relative_path": "_docs/connect-a-data-source/plugins/150-cassandra-storage-plugin.md", + "title": "Cassandra Storage Plugin", + "url": "/docs/cassandra-storage-plugin/" + }, "Choosing a Storage Format": { "breadcrumbs": [ { @@ -3067,8 +3084,8 @@ } ], "children": [], - "next_title": "ElasticSearch Plugin", - "next_url": "/docs/elasticsearch-plugin/", + "next_title": "ElasticSearch Storage Plugin", + "next_url": "/docs/elasticsearch-storage-plugin/", "parent": "Connect a Data Source", "previous_title": "Druid Storage Plugin", "previous_url": "/docs/druid-storage-plugin/", @@ -3084,14 +3101,31 @@ } ], "children": [], - "next_title": "Splunk Plugin", - "next_url": "/docs/splunk-plugin/", + "next_title": "Splunk Storage Plugin", + "next_url": "/docs/splunk-storage-plugin/", "parent": "Connect a Data Source", "previous_title": "HTTP Storage Plugin", "previous_url": "/docs/http-storage-plugin/", "relative_path": "_docs/connect-a-data-source/plugins/130-elasticsearch-plugin.md", - "title": "ElasticSearch Plugin", - "url": "/docs/elasticsearch-plugin/" + "title": "ElasticSearch Storage Plugin", + "url": "/docs/elasticsearch-storage-plugin/" + }, + { + "breadcrumbs": [ + { + "title": "Connect a Data Source", + "url": "/docs/connect-a-data-source/" + } + ], + "children": [], + "next_title": "Cassandra Storage Plugin", + "next_url": "/docs/cassandra-storage-plugin/", + "parent": "Connect a Data Source", + "previous_title": "ElasticSearch Storage Plugin", + "previous_url": "/docs/elasticsearch-storage-plugin/", + "relative_path": "_docs/connect-a-data-source/plugins/140-splunk-storage-plugin.md", + "title": "Splunk Storage Plugin", + "url": "/docs/splunk-storage-plugin/" }, { "breadcrumbs": [ @@ -3104,11 +3138,11 @@ "next_title": "ODBC/JDBC Interfaces", "next_url": "/docs/odbc-jdbc-interfaces/", "parent": "Connect a Data Source", - "previous_title": "ElasticSearch Plugin", - "previous_url": "/docs/elasticsearch-plugin/", - "relative_path": "_docs/connect-a-data-source/plugins/140-splunk-storage-plugin.md", - "title": "Splunk Plugin", - "url": "/docs/splunk-plugin/" + "previous_title": "Splunk Storage Plugin", + "previous_url": "/docs/splunk-storage-plugin/", + "relative_path": "_docs/connect-a-data-source/plugins/150-cassandra-storage-plugin.md", + "title": "Cassandra Storage Plugin", + "url": "/docs/cassandra-storage-plugin/" } ], "next_title": "Connect a Data Source Introduction", @@ -5320,7 +5354,7 @@ "title": "Ecosystem", "url": "/docs/ecosystem/" }, - "ElasticSearch Plugin": { + "ElasticSearch Storage Plugin": { "breadcrumbs": [ { "title": "Connect a Data Source", @@ -5328,14 +5362,14 @@ } ], "children": [], - "next_title": "Splunk Plugin", - "next_url": "/docs/splunk-plugin/", + "next_title": "Splunk Storage Plugin", + "next_url": "/docs/splunk-storage-plugin/", "parent": "Connect a Data Source", "previous_title": "HTTP Storage Plugin", "previous_url": "/docs/http-storage-plugin/", "relative_path": "_docs/connect-a-data-source/plugins/130-elasticsearch-plugin.md", - "title": "ElasticSearch Plugin", - "url": "/docs/elasticsearch-plugin/" + "title": "ElasticSearch Storage Plugin", + "url": "/docs/elasticsearch-storage-plugin/" }, "Embedded Mode Prerequisites": { "breadcrumbs": [ @@ -5742,8 +5776,8 @@ } ], "children": [], - "next_title": "ElasticSearch Plugin", - "next_url": "/docs/elasticsearch-plugin/", + "next_title": "ElasticSearch Storage Plugin", + "next_url": "/docs/elasticsearch-storage-plugin/", "parent": "Connect a Data Source", "previous_title": "Druid Storage Plugin", "previous_url": "/docs/druid-storage-plugin/", @@ -8317,8 +8351,8 @@ "next_title": "Interfaces Introduction", "next_url": "/docs/interfaces-introduction/", "parent": "", - "previous_title": "Splunk Plugin", - "previous_url": "/docs/splunk-plugin/", + "previous_title": "Cassandra Storage Plugin", + "previous_url": "/docs/cassandra-storage-plugin/", "relative_path": "_docs/060-odbc-jdbc-interfaces.md", "title": "ODBC/JDBC Interfaces", "url": "/docs/odbc-jdbc-interfaces/" @@ -15447,7 +15481,7 @@ "title": "Sort-Based and Hash-Based Memory-Constrained Operators", "url": "/docs/sort-based-and-hash-based-memory-constrained-operators/" }, - "Splunk Plugin": { + "Splunk Storage Plugin": { "breadcrumbs": [ { "title": "Connect a Data Source", @@ -15455,14 +15489,14 @@ } ], "children": [], - "next_title": "ODBC/JDBC Interfaces", - "next_url": "/docs/odbc-jdbc-interfaces/", + "next_title": "Cassandra Storage Plugin", + "next_url": "/docs/cassandra-storage-plugin/", "parent": "Connect a Data Source", - "previous_title": "ElasticSearch Plugin", - "previous_url": "/docs/elasticsearch-plugin/", + "previous_title": "ElasticSearch Storage Plugin", + "previous_url": "/docs/elasticsearch-storage-plugin/", "relative_path": "_docs/connect-a-data-source/plugins/140-splunk-storage-plugin.md", - "title": "Splunk Plugin", - "url": "/docs/splunk-plugin/" + "title": "Splunk Storage Plugin", + "url": "/docs/splunk-storage-plugin/" }, "Start-Up Options": { "breadcrumbs": [ @@ -19160,8 +19194,8 @@ } ], "children": [], - "next_title": "ElasticSearch Plugin", - "next_url": "/docs/elasticsearch-plugin/", + "next_title": "ElasticSearch Storage Plugin", + "next_url": "/docs/elasticsearch-storage-plugin/", "parent": "Connect a Data Source", "previous_title": "Druid Storage Plugin", "previous_url": "/docs/druid-storage-plugin/", @@ -19177,14 +19211,31 @@ } ], "children": [], - "next_title": "Splunk Plugin", - "next_url": "/docs/splunk-plugin/", + "next_title": "Splunk Storage Plugin", + "next_url": "/docs/splunk-storage-plugin/", "parent": "Connect a Data Source", "previous_title": "HTTP Storage Plugin", "previous_url": "/docs/http-storage-plugin/", "relative_path": "_docs/connect-a-data-source/plugins/130-elasticsearch-plugin.md", - "title": "ElasticSearch Plugin", - "url": "/docs/elasticsearch-plugin/" + "title": "ElasticSearch Storage Plugin", + "url": "/docs/elasticsearch-storage-plugin/" + }, + { + "breadcrumbs": [ + { + "title": "Connect a Data Source", + "url": "/docs/connect-a-data-source/" + } + ], + "children": [], + "next_title": "Cassandra Storage Plugin", + "next_url": "/docs/cassandra-storage-plugin/", + "parent": "Connect a Data Source", + "previous_title": "ElasticSearch Storage Plugin", + "previous_url": "/docs/elasticsearch-storage-plugin/", + "relative_path": "_docs/connect-a-data-source/plugins/140-splunk-storage-plugin.md", + "title": "Splunk Storage Plugin", + "url": "/docs/splunk-storage-plugin/" }, { "breadcrumbs": [ @@ -19197,11 +19248,11 @@ "next_title": "ODBC/JDBC Interfaces", "next_url": "/docs/odbc-jdbc-interfaces/", "parent": "Connect a Data Source", - "previous_title": "ElasticSearch Plugin", - "previous_url": "/docs/elasticsearch-plugin/", - "relative_path": "_docs/connect-a-data-source/plugins/140-splunk-storage-plugin.md", - "title": "Splunk Plugin", - "url": "/docs/splunk-plugin/" + "previous_title": "Splunk Storage Plugin", + "previous_url": "/docs/splunk-storage-plugin/", + "relative_path": "_docs/connect-a-data-source/plugins/150-cassandra-storage-plugin.md", + "title": "Cassandra Storage Plugin", + "url": "/docs/cassandra-storage-plugin/" } ], "next_title": "Connect a Data Source Introduction", @@ -19826,8 +19877,8 @@ "next_title": "Interfaces Introduction", "next_url": "/docs/interfaces-introduction/", "parent": "", - "previous_title": "Splunk Plugin", - "previous_url": "/docs/splunk-plugin/", + "previous_title": "Cassandra Storage Plugin", + "previous_url": "/docs/cassandra-storage-plugin/", "relative_path": "_docs/060-odbc-jdbc-interfaces.md", "title": "ODBC/JDBC Interfaces", "url": "/docs/odbc-jdbc-interfaces/" diff --git a/_docs/connect-a-data-source/plugins/130-elasticsearch-plugin.md b/_docs/connect-a-data-source/plugins/130-elasticsearch-plugin.md index b9b76aa..2a3899d 100644 --- a/_docs/connect-a-data-source/plugins/130-elasticsearch-plugin.md +++ b/_docs/connect-a-data-source/plugins/130-elasticsearch-plugin.md @@ -1,12 +1,12 @@ --- -title: "ElasticSearch Plugin" -slug: "ElasticSearch Plugin" +title: "ElasticSearch Storage Plugin" +slug: "ElasticSearch Storage Plugin" parent: "Connect a Data Source" --- **Introduced in release:** 1.19 -Drill ElasticSearch storage plugin allows you to perform SQL queries against ElasticSearch indices. +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](https://calcite.apache.org/docs/elasticsearch_adapter.html). For more details about supported versions please refer to [Supported versions](https://calcite.apache.org/docs/elasticsearch_adapter.html#supported-versions) page. diff --git a/_docs/connect-a-data-source/plugins/140-splunk-storage-plugin.md b/_docs/connect-a-data-source/plugins/140-splunk-storage-plugin.md index ed2cd20..1e18ab8 100644 --- a/_docs/connect-a-data-source/plugins/140-splunk-storage-plugin.md +++ b/_docs/connect-a-data-source/plugins/140-splunk-storage-plugin.md @@ -1,6 +1,6 @@ --- -title: "Splunk Plugin" -slug: "Splunk Plugin" +title: "Splunk Storage Plugin" +slug: "Splunk Storage Plugin" parent: "Connect a Data Source" --- diff --git a/_docs/connect-a-data-source/plugins/150-cassandra-storage-plugin.md b/_docs/connect-a-data-source/plugins/150-cassandra-storage-plugin.md new file mode 100644 index 0000000..cc3f470 --- /dev/null +++ b/_docs/connect-a-data-source/plugins/150-cassandra-storage-plugin.md @@ -0,0 +1,51 @@ +--- +title: "Cassandra Storage Plugin" +slug: "Cassandra Storage Plugin" +parent: "Connect a Data Source" +--- + +**Introduced in release:** 1.19 + +Drill's Cassandra storage plugin allows you to execute SQL queries against +Cassandra tables. This storage plugin implementation is based on +[Apache Calcite adapter for Cassandra](https://calcite.apache.org/docs/cassandra_adapter.html). +This plugin is also compatbile with Scylla DB. + +### Supported optimizations and features + +This storage plugin supports the following optimizations: + +- Projection pushdown +- Filter pushdown (only expressions supported by Calcite adapter for Cassandra) +- Limit pushdown + +Except for these optimizations, Cassandra storage plugin supports the schema +provisioning feature. For more details please refer to +[Specifying the Schema as Table Function Parameter](https://drill.apache.org/docs/plugin-configuration-basics/#specifying-the-schema-as-table-function-parameter). + +### Configuration + +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. + +```json +{ + "type" : "cassandra", + "username" : null, + "password" : null, + "host" : "localhost", + "port" : 9042, + "enabled": false +} +``` + +### Configuration Options + +| Option | Default | Description | +| -------- | --------- | ---------------------------------------------------- | +| type | (none) | Set to "cassandra" to use this plugin | +| username | null | Cassandra username to be used by Drill | +| password | null | Cassandra password to be used by Drill | +| host | localhost | Cassandra host to be queried by Drill | +| port | 9042 | TCP port over which Drill will connect to Cassandra. |
