elasticsearch-sql

by NLPchina

Use SQL to query Elasticsearch

6.1K Stars 1.4K Forks Last release: 3 months ago (7.8.0.0) Apache License 2.0 936 Commits 147 Releases

Available items

No Items, yet!

The developer of this repository has not created any items for sale yet. Need a bug fixed? Help with integration? A different license? Create a request here:

IMPORTANT

Since 7.5.0.0, the path
/_sql
is changed to
/_nlpcn/sql
, and the path
/_sql/_explain
is changed to
/_nlpcn/sql/explain
.


DEPRECATED

Please note, this project is no longer in active development, and is deprecated, please use official version x-pack-sql and OpenDistro for Elasticsearch SQL supported by AWS and licensed under Apache 2.


Elasticsearch-SQL

build status

1.7.6 1.7.6 Build Status 2.0.0 2.0.0 Build Status 2.1.0 2.1.0 Build Status 2.1.1 2.1.1 Build Status 2.1.2 2.1.2 Build Status 2.2.0 2.2.0 Build Status
2.2.1 2.2.1 Build Status 2.3.0 2.3.0 Build Status 2.3.1 2.3.1 Build Status 2.3.2 2.3.2 Build Status 2.3.3 2.3.3 Build Status 2.3.4 2.3.4 Build Status
2.3.5 2.3.5 Build Status 2.4.0 2.4.0 Build Status 2.4.1 2.4.1 Build Status 2.4.2 2.4.2 Build Status 2.4.3 2.4.3 Build Status 2.4.4 2.4.4 Build Status
2.4.5 2.4.5 Build Status 2.4.6 2.4.6 Build Status 5.0.1 5.0.1 Build Status 5.1.1 5.1.1 Build Status 5.1.2 5.1.2 Build Status 5.2.0 5.2.0 Build Status
5.2.1 5.2.1 Build Status 5.2.2 5.2.2 Build Status 5.3.0 5.3.0 Build Status 5.3.1 5.3.1 Build Status 5.3.2 5.3.2 Build Status 5.3.3 5.3.3 Build Status
5.4.0 5.4.0 Build Status 5.4.1 5.4.1 Build Status 5.4.2 5.4.2 Build Status 5.4.3 5.4.3 Build Status 5.5.0 5.5.0 Build Status 5.5.1 5.5.1 Build Status
5.5.2 5.5.2 Build Status 5.5.3 5.5.3 Build Status 5.6.0 5.6.0 Build Status 5.6.1 5.6.1 Build Status 5.6.2 5.6.2 Build Status 5.6.3 5.6.3 Build Status
5.6.4 5.6.4 Build Status 5.6.5 5.6.5 Build Status 5.6.6 5.6.6 Build Status 5.6.7 5.6.7 Build Status 5.6.8 5.6.8 Build Status 5.6.9 5.6.9 Build Status
5.6.10 5.6.10 Build Status 5.6.11 5.6.11 Build Status 5.6.12 5.6.12 Build Status 5.6.13 5.6.13 Build Status 5.6.14 5.6.14 Build Status 5.6.15 5.6.15 Build Status
5.6.16 5.6.16 Build Status 6.0.0 6.0.0 Build Status 6.0.1 6.0.1 Build Status 6.1.0 6.1.0 Build Status 6.1.1 6.1.1 Build Status 6.1.2 6.1.2 Build Status
6.1.3 6.1.3 Build Status 6.1.4 6.1.4 Build Status 6.2.0 6.2.0 Build Status 6.2.1 6.2.1 Build Status 6.2.2 6.2.2 Build Status 6.2.3 6.2.3 Build Status
6.2.4 6.2.4 Build Status 6.3.0 6.3.0 Build Status 6.3.1 6.3.1 Build Status 6.3.2 6.3.2 Build Status 6.4.0 6.4.0 Build Status 6.4.1 6.4.1 Build Status
6.4.2 6.4.2 Build Status 6.4.3 6.4.3 Build Status 6.5.0 6.5.0 Build Status 6.5.1 6.5.1 Build Status 6.5.2 6.5.2 Build Status 6.5.3 6.5.3 Build Status
6.5.4 6.5.4 Build Status 6.6.0 6.6.0 Build Status 6.6.1 6.6.1 Build Status 6.6.2 6.6.2 Build Status 6.7.0 6.7.0 Build Status 6.7.1 6.7.1 Build Status
6.7.2 6.7.2 Build Status 6.8.0 6.8.0 Build Status 6.8.1 6.8.1 Build Status 6.8.2 6.8.2 Build Status 6.8.3 6.8.3 Build Status 6.8.4 6.8.4 Build Status
6.8.5 6.8.5 Build Status 6.8.6 6.8.6 Build Status 6.8.7 6.8.7 Build Status 6.8.8 6.8.8 Build Status 6.8.9 6.8.9 Build Status 6.8.10 6.8.10 Build Status
7.0.0 7.0.0 Build Status 7.0.1 7.0.1 Build Status 7.1.0 7.1.0 Build Status 7.1.1 7.1.1 Build Status 7.2.0 7.2.0 Build Status 7.2.1 7.2.1 Build Status
7.3.0 7.3.0 Build Status 7.3.1 7.3.1 Build Status 7.3.2 7.3.2 Build Status 7.4.0 7.4.0 Build Status 7.4.1 7.4.1 Build Status 7.4.2 7.4.2 Build Status
7.5.0 7.5.0 Build Status 7.5.1 7.5.1 Build Status 7.5.2 7.5.2 Build Status 7.6.0 7.6.0 Build Status 7.6.1 7.6.1 Build Status 7.6.2 7.6.2 Build Status
7.7.0 7.7.0 Build Status 7.7.1 7.7.1 Build Status 7.8.0 7.8.0 Build Status

Query elasticsearch using familiar SQL syntax. You can also use ES functions in SQL.

Check out our wiki!

explain example

Web frontend overview

Web frontend overview

SETUP

Install as plugin:

Versions

| elasticsearch version | latest version | remarks | branch | | --------------------- | ------------- | ----------------------------- | ------------ | | 1.x | 1.7.6 | tested against elastic 1.7.6 | elastic1.x | | 2.0.0 | 2.0.4 | delete commands not supported | elastic2.0 | | 2.1.0 | 2.1.0.2 | delete commands not supported | elastic2.1 | | 2.1.1 | 2.1.1.1 | delete commands not supported | elastic2.1.1 | | 2.1.2 | 2.1.2.0 | delete commands not supported | elastic2.1.2 | | 2.2.0 | 2.2.0.1 | delete commands not supported | elastic2.2.0 | | 2.2.1 | 2.2.1.0 | delete commands not supported | elastic2.2.1 | | 2.3.0 | 2.3.0.0 | delete commands not supported | elastic2.3.0 | | 2.3.1 | 2.3.1.1 | delete commands not supported | elastic2.3.1 | | 2.3.2 | 2.3.2.0 | delete commands not supported | elastic2.3.2 | | 2.3.3 | 2.3.3.0 | delete commands not supported | elastic2.3.3 | | 2.3.4 | 2.3.4.0 | delete commands not supported | elastic2.3.4 | | 2.3.5 | 2.3.5.0 | delete commands not supported | elastic2.3.5 | | 2.4.0 | 2.4.0.1 | delete commands not supported | elastic2.4.0 | | 2.4.1 | 2.4.1.0 | delete commands not supported | elastic2.4.1 | | 2.4.2 | 2.4.2.1 | delete commands not supported | elastic2.4.2 | | 2.4.3 | 2.4.3.0 | delete commands not supported | elastic2.4.3 | | 2.4.4 | 2.4.4.0 | delete commands not supported | elastic2.4.4 | | 2.4.5 | 2.4.5.0 | delete commands not supported | elastic2.4.5 | | 2.4.6 | 2.4.6.0 | delete commands not supported | elastic2.4.6 | | 5.0.1 | 5.0.1.0 | delete commands not supported | elastic5.0.1 | | 5.1.1 | 5.1.1.0 | delete commands not supported | elastic5.1.1 | | 5.1.2 | 5.1.2.0 | delete commands not supported | elastic5.1.2 | | 5.2.0 | 5.2.0.0 | delete commands not supported | elastic5.2.0 | | 5.2.1 | 5.2.1.0 | delete commands not supported | elastic5.2.1 | | 5.2.2 | 5.2.2.0 | delete commands not supported | elastic5.2.2 | | 5.3.0 | 5.3.0.0 | delete commands not supported | elastic5.3.0 | | 5.3.1 | 5.3.1.0 | delete commands not supported | elastic5.3.1 | | 5.3.2 | 5.3.2.0 | delete commands not supported | elastic5.3.2 | | 5.3.3 | 5.3.3.0 | delete commands not supported | elastic5.3.3 | | 5.4.0 | 5.4.0.0 | delete commands not supported | elastic5.4.0 | | 5.4.1 | 5.4.1.0 | delete commands not supported | elastic5.4.1 | | 5.4.2 | 5.4.2.0 | delete commands not supported | elastic5.4.2 | | 5.4.3 | 5.4.3.0 | delete commands not supported | elastic5.4.3 | | 5.5.0 | 5.5.0.1 | delete commands not supported | elastic5.5.0 | | 5.5.1 | 5.5.1.0 | delete commands not supported | elastic5.5.1 | | 5.5.2 | 5.5.2.0 | delete commands not supported | elastic5.5.2 | | 5.5.3 | 5.5.3.0 | delete commands not supported | elastic5.5.3 | | 5.6.0 | 5.6.0.0 | delete commands not supported | elastic5.6.0 | | 5.6.1 | 5.6.1.0 | delete commands not supported | elastic5.6.1 | | 5.6.2 | 5.6.2.0 | delete commands not supported | elastic5.6.2 | | 5.6.3 | 5.6.3.0 | delete commands not supported | elastic5.6.3 | | 5.6.4 | 5.6.4.0 | delete commands not supported | elastic5.6.4 | | 5.6.5 | 5.6.5.0 | delete commands not supported | elastic5.6.5 | | 5.6.6 | 5.6.6.0 | | elastic5.6.6 | | 5.6.7 | 5.6.7.0 | | elastic5.6.7 | | 5.6.8 | 5.6.8.0 | | elastic5.6.8 | | 5.6.9 | 5.6.9.0 | | elastic5.6.9 | | 5.6.10 | 5.6.10.0 | | elastic5.6.10| | 5.6.11 | 5.6.11.0 | | elastic5.6.11| | 5.6.12 | 5.6.12.0 | | elastic5.6.12| | 5.6.13 | 5.6.13.0 | | elastic5.6.13| | 5.6.14 | 5.6.14.0 | | elastic5.6.14| | 5.6.15 | 5.6.15.0 | | elastic5.6.15| | 5.6.16 | 5.6.16.0 | | elastic5.6.16| | 6.0.0 | 6.0.0.0 | | elastic6.0.0 | | 6.0.1 | 6.0.1.0 | | elastic6.0.1 | | 6.1.0 | 6.1.0.0 | | elastic6.1.0 | | 6.1.1 | 6.1.1.0 | | elastic6.1.1 | | 6.1.2 | 6.1.2.0 | | elastic6.1.2 | | 6.1.3 | 6.1.3.0 | | elastic6.1.3 | | 6.1.4 | 6.1.4.0 | | elastic6.1.4 | | 6.2.0 | 6.2.0.0 | | elastic6.2.0 | | 6.2.1 | 6.2.1.0 | | elastic6.2.1 | | 6.2.2 | 6.2.2.0 | | elastic6.2.2 | | 6.2.3 | 6.2.3.0 | | elastic6.2.3 | | 6.2.4 | 6.2.4.0 | | elastic6.2.4 | | 6.3.0 | 6.3.0.0 | | elastic6.3.0 | | 6.3.1 | 6.3.1.0 | | elastic6.3.1 | | 6.3.2 | 6.3.2.0 | | elastic6.3.2 | | 6.4.0 | 6.4.0.0 | | elastic6.4.0 | | 6.4.1 | 6.4.1.0 | | elastic6.4.1 | | 6.4.2 | 6.4.2.0 | | elastic6.4.2 | | 6.4.3 | 6.4.3.0 | | elastic6.4.3 | | 6.5.0 | 6.5.0.0 | | elastic6.5.0 | | 6.5.1 | 6.5.1.0 | | elastic6.5.1 | | 6.5.2 | 6.5.2.0 | | elastic6.5.2 | | 6.5.3 | 6.5.3.0 | | elastic6.5.3 | | 6.5.4 | 6.5.4.0 | | elastic6.5.4 | | 6.6.0 | 6.6.0.0 | | elastic6.6.0 | | 6.6.1 | 6.6.1.0 | | elastic6.6.1 | | 6.6.2 | 6.6.2.0 | | elastic6.6.2 | | 6.7.0 | 6.7.0.0 | | elastic6.7.0 | | 6.7.1 | 6.7.1.0 | | elastic6.7.1 | | 6.7.2 | 6.7.2.0 | | elastic6.7.2 | | 6.8.0 | 6.8.0.0 | | elastic6.8.0 | | 6.8.1 | 6.8.1.0 | | elastic6.8.1 | | 6.8.2 | 6.8.2.0 | | elastic6.8.2 | | 6.8.3 | 6.8.3.0 | | elastic6.8.3 | | 6.8.4 | 6.8.4.0 | | elastic6.8.4 | | 6.8.5 | 6.8.5.0 | | elastic6.8.5 | | 6.8.6 | 6.8.6.0 | | elastic6.8.6 | | 6.8.7 | 6.8.7.0 | | elastic6.8.7 | | 6.8.8 | 6.8.8.0 | | elastic6.8.8 | | 6.8.9 | 6.8.9.0 | | elastic6.8.9 | | 6.8.10 | 6.8.10.0 | | elastic6.8.10| | 7.0.0 | 7.0.0.0 | | elastic7.0.0 | | 7.0.1 | 7.0.1.0 | | elastic7.0.1 | | 7.1.0 | 7.1.0.0 | | elastic7.1.0 | | 7.1.1 | 7.1.1.0 | | elastic7.1.1 | | 7.2.0 | 7.2.0.0 | | elastic7.2.0 | | 7.2.1 | 7.2.1.0 | | elastic7.2.1 | | 7.3.0 | 7.3.0.0 | | elastic7.3.0 | | 7.3.1 | 7.3.1.0 | | elastic7.3.1 | | 7.3.2 | 7.3.2.0 | | elastic7.3.2 | | 7.4.0 | 7.4.0.0 | | elastic7.4.0 | | 7.4.1 | 7.4.1.0 | | elastic7.4.1 | | 7.4.2 | 7.4.2.0 | | elastic7.4.2 | | 7.5.0 | 7.5.0.0 | | elastic7.5.0 | | 7.5.1 | 7.5.1.0 | | elastic7.5.1 | | 7.5.2 | 7.5.2.0 | | elastic7.5.2 | | 7.6.0 | 7.6.0.0 | | elastic7.6.0 | | 7.6.1 | 7.6.1.0 | | elastic7.6.1 | | 7.6.2 | 7.6.2.0 | | elastic7.6.2 | | 7.7.0 | 7.7.0.0 | | elastic7.7.0 | | 7.7.1 | 7.7.1.0 | | elastic7.7.1 | | 7.8.0 | 7.8.0.0 | | elastic7.8.0 |

Elasticsearch 1.x

./bin/plugin -u https://github.com/NLPchina/elasticsearch-sql/releases/download/1.7.6/elasticsearch-sql-1.7.6.zip --install sql

Elasticsearch 2.0.0

./bin/plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/2.0.4/elasticsearch-sql-2.0.4.zip 

Elasticsearch 2.1.0

./bin/plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/2.1.0.2/elasticsearch-sql-2.1.0.2.zip 

Elasticsearch 2.1.1

./bin/plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/2.1.1.1/elasticsearch-sql-2.1.1.1.zip 

Elasticsearch 2.1.2

./bin/plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/2.1.2.0/elasticsearch-sql-2.1.2.0.zip 

Elasticsearch 2.2.0

./bin/plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/2.2.0.1/elasticsearch-sql-2.2.0.1.zip 

Elasticsearch 2.2.1

./bin/plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/2.2.1.0/elasticsearch-sql-2.2.1.0.zip 

Elasticsearch 2.3.0

./bin/plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/2.3.0.0/elasticsearch-sql-2.3.0.0.zip 

Elasticsearch 2.3.1

./bin/plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/2.3.1.1/elasticsearch-sql-2.3.1.1.zip 

Elasticsearch 2.3.2

./bin/plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/2.3.2.0/elasticsearch-sql-2.3.2.0.zip 

Elasticsearch 2.3.3

./bin/plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/2.3.3.0/elasticsearch-sql-2.3.3.0.zip 

Elasticsearch 2.3.4

./bin/plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/2.3.4.0/elasticsearch-sql-2.3.4.0.zip 

Elasticsearch 2.3.5

./bin/plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/2.3.5.0/elasticsearch-sql-2.3.5.0.zip 

Elasticsearch 2.4.0

./bin/plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/2.4.0.1/elasticsearch-sql-2.4.0.1.zip

Elasticsearch 2.4.1

./bin/plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/2.4.1.0/elasticsearch-sql-2.4.1.0.zip

Elasticsearch 2.4.2

./bin/plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/2.4.2.1/elasticsearch-sql-2.4.2.1.zip

Elasticsearch 2.4.3

./bin/plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/2.4.3.0/elasticsearch-sql-2.4.3.0.zip

Elasticsearch 2.4.4

./bin/plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/2.4.4.0/elasticsearch-sql-2.4.4.0.zip

Elasticsearch 2.4.5

./bin/plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/2.4.5.0/elasticsearch-sql-2.4.5.0.zip

Elasticsearch 2.4.6

./bin/plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/2.4.6.0/elasticsearch-sql-2.4.6.0.zip

Elasticsearch 5.0.1

./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/5.0.1/elasticsearch-sql-5.0.1.0.zip

Elasticsearch 5.1.1

./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/5.1.1.0/elasticsearch-sql-5.1.1.0.zip

Elasticsearch 5.1.2

./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/5.1.2.0/elasticsearch-sql-5.1.2.0.zip

Elasticsearch 5.2.0

./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/5.2.0.0/elasticsearch-sql-5.2.0.0.zip

Elasticsearch 5.2.1

./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/5.2.1.0/elasticsearch-sql-5.2.1.0.zip

Elasticsearch 5.2.2

./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/5.2.2.0/elasticsearch-sql-5.2.2.0.zip

Elasticsearch 5.3.0

./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/5.3.0.0/elasticsearch-sql-5.3.0.0.zip

Elasticsearch 5.3.1

./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/5.3.1.0/elasticsearch-sql-5.3.1.0.zip

Elasticsearch 5.3.2

./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/5.3.2.0/elasticsearch-sql-5.3.2.0.zip

Elasticsearch 5.3.3

./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/5.3.3.0/elasticsearch-sql-5.3.3.0.zip

Elasticsearch 5.4.0

./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/5.4.0.0/elasticsearch-sql-5.4.0.0.zip

Elasticsearch 5.4.1

./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/5.4.1.0/elasticsearch-sql-5.4.1.0.zip

Elasticsearch 5.4.2

./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/5.4.2.0/elasticsearch-sql-5.4.2.0.zip

Elasticsearch 5.4.3

./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/5.4.3.0/elasticsearch-sql-5.4.3.0.zip

Elasticsearch 5.5.0

./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/5.5.0.0/elasticsearch-sql-5.5.0.1.zip

Elasticsearch 5.5.1

./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/5.5.1.0/elasticsearch-sql-5.5.1.0.zip

Elasticsearch 5.5.2

./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/5.5.2.0/elasticsearch-sql-5.5.2.0.zip

Elasticsearch 5.5.3

./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/5.5.3.0/elasticsearch-sql-5.5.3.0.zip

Elasticsearch 5.6.0

./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/5.6.0.0/elasticsearch-sql-5.6.0.0.zip

Elasticsearch 5.6.1

./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/5.6.1.0/elasticsearch-sql-5.6.1.0.zip

Elasticsearch 5.6.2

./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/5.6.2.0/elasticsearch-sql-5.6.2.0.zip

Elasticsearch 5.6.3

./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/5.6.3.0/elasticsearch-sql-5.6.3.0.zip

Elasticsearch 5.6.4

./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/5.6.4.0/elasticsearch-sql-5.6.4.0.zip

Elasticsearch 5.6.5

./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/5.6.5.0/elasticsearch-sql-5.6.5.0.zip

Elasticsearch 5.6.6

./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/5.6.6.0/elasticsearch-sql-5.6.6.0.zip

Elasticsearch 5.6.7

./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/5.6.7.0/elasticsearch-sql-5.6.7.0.zip

Elasticsearch 5.6.8

./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/5.6.8.0/elasticsearch-sql-5.6.8.0.zip

Elasticsearch 5.6.9

./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/5.6.9.0/elasticsearch-sql-5.6.9.0.zip

Elasticsearch 5.6.10

./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/5.6.10.0/elasticsearch-sql-5.6.10.0.zip

Elasticsearch 5.6.11

./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/5.6.11.0/elasticsearch-sql-5.6.11.0.zip

Elasticsearch 5.6.12

./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/5.6.12.0/elasticsearch-sql-5.6.12.0.zip

Elasticsearch 5.6.13

./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/5.6.13.0/elasticsearch-sql-5.6.13.0.zip

Elasticsearch 5.6.14

./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/5.6.14.0/elasticsearch-sql-5.6.14.0.zip

Elasticsearch 5.6.15

./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/5.6.15.0/elasticsearch-sql-5.6.15.0.zip

Elasticsearch 5.6.16

./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/5.6.16.0/elasticsearch-sql-5.6.16.0.zip

Elasticsearch 6.0.0

./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/6.0.0.0/elasticsearch-sql-6.0.0.0.zip

Elasticsearch 6.0.1

./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/6.0.1.0/elasticsearch-sql-6.0.1.0.zip

Elasticsearch 6.1.0

./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/6.1.0.0/elasticsearch-sql-6.1.0.0.zip

Elasticsearch 6.1.1

./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/6.1.1.0/elasticsearch-sql-6.1.1.0.zip

Elasticsearch 6.1.2

./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/6.1.2.0/elasticsearch-sql-6.1.2.0.zip

Elasticsearch 6.1.3

./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/6.1.3.0/elasticsearch-sql-6.1.3.0.zip

Elasticsearch 6.1.4

./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/6.1.4.0/elasticsearch-sql-6.1.4.0.zip

Elasticsearch 6.2.0

./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/6.2.0.0/elasticsearch-sql-6.2.0.0.zip

Elasticsearch 6.2.1

./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/6.2.1.0/elasticsearch-sql-6.2.1.0.zip

Elasticsearch 6.2.2

./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/6.2.2.0/elasticsearch-sql-6.2.2.0.zip

Elasticsearch 6.2.3

./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/6.2.3.0/elasticsearch-sql-6.2.3.0.zip

Elasticsearch 6.2.4

./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/6.2.4.0/elasticsearch-sql-6.2.4.0.zip

Elasticsearch 6.3.0

./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/6.3.0.0/elasticsearch-sql-6.3.0.0.zip

Elasticsearch 6.3.1

./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/6.3.1.0/elasticsearch-sql-6.3.1.1.zip

Elasticsearch 6.3.2

./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/6.3.2.0/elasticsearch-sql-6.3.2.0.zip

Elasticsearch 6.4.0

./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/6.4.0.0/elasticsearch-sql-6.4.0.0.zip

Elasticsearch 6.4.1

./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/6.4.1.0/elasticsearch-sql-6.4.1.0.zip

Elasticsearch 6.4.2

./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/6.4.2.0/elasticsearch-sql-6.4.2.0.zip

Elasticsearch 6.4.3

./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/6.4.3.0/elasticsearch-sql-6.4.3.0.zip

Elasticsearch 6.5.0

./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/6.5.0.0/elasticsearch-sql-6.5.0.0.zip

Elasticsearch 6.5.1

./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/6.5.1.0/elasticsearch-sql-6.5.1.0.zip

Elasticsearch 6.5.2

./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/6.5.2.0/elasticsearch-sql-6.5.2.0.zip

Elasticsearch 6.5.3

./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/6.5.3.0/elasticsearch-sql-6.5.3.0.zip

Elasticsearch 6.5.4

./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/6.5.4.0/elasticsearch-sql-6.5.4.0.zip

Elasticsearch 6.6.0

./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/6.6.0.0/elasticsearch-sql-6.6.0.0.zip

Elasticsearch 6.6.1

./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/6.6.1.0/elasticsearch-sql-6.6.1.0.zip

Elasticsearch 6.6.2

./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/6.6.2.0/elasticsearch-sql-6.6.2.0.zip

Elasticsearch 6.7.0

./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/6.7.0.0/elasticsearch-sql-6.7.0.0.zip

Elasticsearch 6.7.1

./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/6.7.1.0/elasticsearch-sql-6.7.1.0.zip

Elasticsearch 6.7.2

./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/6.7.2.0/elasticsearch-sql-6.7.2.0.zip

Elasticsearch 6.8.0

./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/6.8.0.0/elasticsearch-sql-6.8.0.0.zip

Elasticsearch 6.8.1

./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/6.8.1.0/elasticsearch-sql-6.8.1.0.zip

Elasticsearch 6.8.2

./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/6.8.2.0/elasticsearch-sql-6.8.2.0.zip

Elasticsearch 6.8.3

./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/6.8.3.0/elasticsearch-sql-6.8.3.0.zip

Elasticsearch 6.8.4

./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/6.8.4.0/elasticsearch-sql-6.8.4.0.zip

Elasticsearch 6.8.5

./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/6.8.5.0/elasticsearch-sql-6.8.5.0.zip

Elasticsearch 6.8.6

./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/6.8.6.0/elasticsearch-sql-6.8.6.0.zip

Elasticsearch 6.8.7

./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/6.8.7.0/elasticsearch-sql-6.8.7.0.zip

Elasticsearch 6.8.8

./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/6.8.8.0/elasticsearch-sql-6.8.8.0.zip

Elasticsearch 6.8.9

./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/6.8.9.0/elasticsearch-sql-6.8.9.0.zip

Elasticsearch 6.8.10

./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/6.8.10.0/elasticsearch-sql-6.8.10.0.zip

Elasticsearch 7.0.0

./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/7.0.0.0/elasticsearch-sql-7.0.0.0.zip

Elasticsearch 7.0.1

./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/7.0.1.0/elasticsearch-sql-7.0.1.0.zip

Elasticsearch 7.1.0

./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/7.1.0.0/elasticsearch-sql-7.1.0.0.zip

Elasticsearch 7.1.1

./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/7.1.1.0/elasticsearch-sql-7.1.1.0.zip

Elasticsearch 7.2.0

./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/7.2.0.0/elasticsearch-sql-7.2.0.0.zip

Elasticsearch 7.2.1

./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/7.2.1.0/elasticsearch-sql-7.2.1.0.zip

Elasticsearch 7.3.0

./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/7.3.0.0/elasticsearch-sql-7.3.0.0.zip

Elasticsearch 7.3.1

./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/7.3.1.0/elasticsearch-sql-7.3.1.0.zip

Elasticsearch 7.3.2

./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/7.3.2.0/elasticsearch-sql-7.3.2.0.zip

Elasticsearch 7.4.0

./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/7.4.0.0/elasticsearch-sql-7.4.0.0.zip

Elasticsearch 7.4.1

./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/7.4.1.0/elasticsearch-sql-7.4.1.0.zip

Elasticsearch 7.4.2

./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/7.4.2.0/elasticsearch-sql-7.4.2.0.zip

Elasticsearch 7.5.0

./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/7.5.0.0/elasticsearch-sql-7.5.0.0.zip

Elasticsearch 7.5.1

./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/7.5.1.0/elasticsearch-sql-7.5.1.0.zip

Elasticsearch 7.5.2

./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/7.5.2.0/elasticsearch-sql-7.5.2.0.zip

Elasticsearch 7.6.0

./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/7.6.0.0/elasticsearch-sql-7.6.0.0.zip

Elasticsearch 7.6.1

./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/7.6.1.0/elasticsearch-sql-7.6.1.0.zip

Elasticsearch 7.6.2

./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/7.6.2.0/elasticsearch-sql-7.6.2.0.zip

Elasticsearch 7.7.0

./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/7.7.0.0/elasticsearch-sql-7.7.0.0.zip

Elasticsearch 7.7.1

./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/7.7.1.0/elasticsearch-sql-7.7.1.0.zip

Elasticsearch 7.8.0

./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/7.8.0.0/elasticsearch-sql-7.8.0.0.zip

After doing this, you need to restart the Elasticsearch server. Otherwise you may get errors like

Invalid index name [sql], must not start with '']; ","status":400}
.

Basic Usage

On elasticsearch 1.x / 2.x, visit the elasticsearch-sql web front-end:

http://localhost:9200/_plugin/sql/

On elasticsearch 5.x/6.x, use elasticsearch sql site chrome extension (make sure to enable cors on elasticsearch.yml). Alternatively, download and extract site, then start the web front-end like this:

cd site-server
npm install express --save
node node-server.js 
  • Simple query

    curl -X GET "localhost:9200/_nlpcn/sql" -H 'Content-Type: application/json' -d'select * from indexName limit 10'
    
  • Explain SQL to elasticsearch query DSL

    curl -X GET "localhost:9200/_nlpcn/sql/explain" -H 'Content-Type: application/json' -d'select * from indexName limit 10'
    

SQL Usage

  • Query

    SELECT * FROM bank WHERE age >30 AND gender = 'm'
    
  • Aggregation

    select COUNT(*),SUM(age),MIN(age) as m, MAX(age),AVG(age)
    FROM bank GROUP BY gender ORDER BY SUM(age), m DESC
    
  • Delete

    DELETE FROM bank WHERE age >30 AND gender = 'm'
    

Beyond SQL

  • Search

    SELECT address FROM bank WHERE address = matchQuery('880 Holmes Lane') ORDER BY _score DESC LIMIT 3
    
  • Aggregations

    • range age group 20-25,25-30,30-35,35-40

      SELECT COUNT(age) FROM bank GROUP BY range(age, 20,25,30,35,40)
      
    • range date group by day

      SELECT online FROM online GROUP BY date_histogram(field='insert_time','interval'='1d')
      
    • range date group by your config

      SELECT online FROM online GROUP BY date_range(field='insert_time','format'='yyyy-MM-dd' ,'2014-08-18','2014-08-17','now-8d','now-7d','now-6d','now')
      
  • ES Geographic

    SELECT * FROM locations WHERE GEO_BOUNDING_BOX(fieldname,100.0,1.0,101,0.0)
    
  • Select type

    SELECT * FROM indexName/type
    

SQL Features

  • SQL Select
  • SQL Delete
  • SQL Where
    • can use "case when" in where clause
  • SQL Order By
    • can use "case when" in order by clause
  • SQL Group By
  • SQL AND & OR
  • SQL Like
  • SQL COUNT distinct
  • SQL In
  • SQL Between
  • SQL Aliases
  • SQL Not Null
  • SQL(ES) Date
  • SQL avg()
  • SQL count()
  • SQL last()
  • SQL max()
  • SQL min()
  • SQL sum()
  • SQL Nulls
  • SQL isnull()
  • SQL now()
  • SQL floor
  • SQL split
  • SQL trim
  • SQL log
  • SQL log10
  • SQL substring
  • SQL round
    • eg: round(10.135, 2) --> 10.14
  • SQL sqrt
  • SQL concat_ws
  • SQL union and minus
  • SQL case when
    • can use "in"、"not in" judge in case when clause
    • can execute simple calculation in case when clause, eg : case when 1 = 1 then field1 + field2 else 0 end
  • SQL if
    • select if(sex='1','男','女') from t_user;
  • SQL limit
    • can set aggregation bucket size and shard size by setting limit, shardSize = 20 * bucketSize
    • eg: select city,count(*) as usercount from tuser group by city limit 100;
    • on the above example, the bucket size is 100, shard size is 20*100 = 2000

JDBC Support (Experimental feature)

Check details : JDBC Support

Beyond sql features

  • ES TopHits
  • ES MISSING
  • ES STATS
  • ES GEO_INTERSECTS
  • ES GEOBOUNDINGBOX
  • ES GEO_DISTANCE
  • ES GEOHASH_GRID aggregation

We use cookies. If you continue to browse the site, you agree to the use of cookies. For more information on our use of cookies please see our Privacy Policy.