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 

SQL Usage

Beyond SQL

SQL Features

JDBC Support (Experimental feature)

Check details : JDBC Support

Beyond sql features