- Notifications
You must be signed in to change notification settings - Fork1.5k
Use SQL to query Elasticsearch
License
NotificationsYou must be signed in to change notification settings
NLPchina/elasticsearch-sql
Folders and files
| Name | Name | Last commit message | Last commit date | |
|---|---|---|---|---|
Repository files navigation
Since 7.5.0.0, the path/_sql is changed to/_nlpcn/sql, and the path/_sql/_explain is changed to/_nlpcn/sql/explain.
Please note, this project is no longer in active development, and is deprecated, please use official versionx-pack-sql andOpenDistro for Elasticsearch SQL supported by AWS and licensed under Apache 2.
6.8.23
Query elasticsearch using familiar SQL syntax.You can also use ES functions in SQL.
Check out ourwiki!
| 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 | |
| 6.8.11 | 6.8.11.0 | elastic6.8.11 | |
| 6.8.12 | 6.8.12.0 | elastic6.8.12 | |
| 6.8.13 | 6.8.13.0 | elastic6.8.13 | |
| 6.8.14 | 6.8.14.0 | elastic6.8.14 | |
| 6.8.15 | 6.8.15.0 | elastic6.8.15 | |
| 6.8.16 | 6.8.16.0 | elastic6.8.16 | |
| 6.8.17 | 6.8.17.0 | elastic6.8.17 | |
| 6.8.18 | 6.8.18.0 | elastic6.8.18 | |
| 6.8.19 | 6.8.19.0 | elastic6.8.19 | |
| 6.8.20 | 6.8.20.0 | elastic6.8.20 | |
| 6.8.21 | 6.8.21.0 | elastic6.8.21 | |
| 6.8.22 | 6.8.22.0 | elastic6.8.22 | |
| 6.8.23 | 6.8.23.0 | elastic6.8.23 | |
| 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 | |
| 7.8.1 | 7.8.1.0 | elastic7.8.1 | |
| 7.9.0 | 7.9.0.0 | elastic7.9.0 | |
| 7.9.1 | 7.9.1.0 | elastic7.9.1 | |
| 7.9.2 | 7.9.2.0 | elastic7.9.2 | |
| 7.9.3 | 7.9.3.0 | elastic7.9.3 | |
| 7.10.0 | 7.10.0.0 | elastic7.10.0 | |
| 7.10.1 | 7.10.1.0 | elastic7.10.1 | |
| 7.10.2 | 7.10.2.0 | elastic7.10.2 | |
| 7.11.0 | 7.11.0.0 | elastic7.11.0 | |
| 7.11.1 | 7.11.1.0 | elastic7.11.1 | |
| 7.11.2 | 7.11.2.0 | elastic7.11.2 | |
| 7.12.0 | 7.12.0.0 | elastic7.12.0 | |
| 7.12.1 | 7.12.1.0 | elastic7.12.1 | |
| 7.13.0 | 7.13.0.0 | elastic7.13.0 | |
| 7.13.1 | 7.13.1.0 | elastic7.13.1 | |
| 7.13.2 | 7.13.2.0 | elastic7.13.2 | |
| 7.13.3 | 7.13.3.0 | elastic7.13.3 | |
| 7.13.4 | 7.13.4.0 | elastic7.13.4 | |
| 7.14.0 | 7.14.0.0 | elastic7.14.0 | |
| 7.14.1 | 7.14.1.0 | elastic7.14.1 | |
| 7.14.2 | 7.14.2.0 | elastic7.14.2 | |
| 7.15.0 | 7.15.0.0 | elastic7.15.0 | |
| 7.15.1 | 7.15.1.0 | elastic7.15.1 | |
| 7.15.2 | 7.15.2.0 | elastic7.15.2 | |
| 7.16.0 | 7.16.0.0 | elastic7.16.0 | |
| 7.16.1 | 7.16.1.0 | elastic7.16.1 | |
| 7.16.2 | 7.16.2.0 | elastic7.16.2 | |
| 7.16.3 | 7.16.3.0 | elastic7.16.3 | |
| 7.17.0 | 7.17.0.0 | elastic7.17.0 | |
| 7.17.1 | 7.17.1.0 | elastic7.17.1 | |
| 7.17.2 | 7.17.2.0 | elastic7.17.2 | |
| 7.17.3 | 7.17.3.0 | elastic7.17.3 | |
| 7.17.4 | 7.17.4.0 | elastic7.17.4 | |
| 7.17.5 | 7.17.5.0 | elastic7.17.5 | |
| 7.17.6 | 7.17.6.0 | elastic7.17.6 | |
| 7.17.7 | 7.17.7.0 | elastic7.17.7 | |
| 7.17.8 | 7.17.8.0 | elastic7.17.8 | |
| 7.17.9 | 7.17.9.0 | elastic7.17.9 | |
| 7.17.10 | 7.17.10.0 | elastic7.17.10 | |
| 7.17.11 | 7.17.11.0 | elastic7.17.11 | |
| 7.17.12 | 7.17.12.0 | elastic7.17.12 | |
| 7.17.13 | 7.17.13.0 | elastic7.17.13 | |
| 7.17.14 | 7.17.14.0 | elastic7.17.14 | |
| 7.17.15 | 7.17.15.0 | elastic7.17.15 | |
| 7.17.16 | 7.17.16.0 | elastic7.17.16 | |
| 7.17.17 | 7.17.17.0 | elastic7.17.17 | |
| 7.17.18 | 7.17.18.0 | elastic7.17.18 | |
| 7.17.19 | 7.17.19.0 | elastic7.17.19 | |
| 7.17.20 | 7.17.20.0 | elastic7.17.20 | |
| 7.17.21 | 7.17.21.0 | elastic7.17.21 | |
| 7.17.22 | 7.17.22.0 | elastic7.17.22 | |
| 7.17.23 | 7.17.23.0 | elastic7.17.23 | |
| 7.17.24 | 7.17.24.0 | elastic7.17.24 | |
| 7.17.25 | 7.17.25.0 | elastic7.17.25 | |
| 7.17.26 | 7.17.26.0 | elastic7.17.26 | |
| 7.17.27 | 7.17.27.0 | elastic7.17.27 | |
| 7.17.28 | 7.17.28.0 | elastic7.17.28 | |
| 8.5.3 | 8.5.3.0 | elastic8.5.3 | |
| 8.6.0 | 8.6.0.0 | elastic8.6.0 | |
| 8.6.1 | 8.6.1.0 | elastic8.6.1 | |
| 8.6.2 | 8.6.2.0 | elastic8.6.2 | |
| 8.7.0 | 8.7.0.0 | elastic8.7.0 | |
| 8.7.1 | 8.7.1.0 | elastic8.7.1 | |
| 8.8.0 | 8.8.0.0 | elastic8.8.0 | |
| 8.8.1 | 8.8.1.0 | elastic8.8.1 | |
| 8.8.2 | 8.8.2.0 | elastic8.8.2 | |
| 8.9.0 | 8.9.0.0 | elastic8.9.0 | |
| 8.9.1 | 8.9.1.0 | elastic8.9.1 | |
| 8.9.2 | 8.9.2.0 | elastic8.9.2 | |
| 8.10.0 | 8.10.0.0 | elastic8.10.0 | |
| 8.10.1 | 8.10.1.0 | elastic8.10.1 | |
| 8.10.2 | 8.10.2.0 | elastic8.10.2 | |
| 8.10.3 | 8.10.3.0 | elastic8.10.3 | |
| 8.10.4 | 8.10.4.0 | elastic8.10.4 | |
| 8.11.0 | 8.11.0.0 | elastic8.11.0 | |
| 8.11.1 | 8.11.1.0 | elastic8.11.1 | |
| 8.11.2 | 8.11.2.0 | elastic8.11.2 | |
| 8.11.3 | 8.11.3.0 | elastic8.11.3 | |
| 8.11.4 | 8.11.4.0 | elastic8.11.4 | |
| 8.12.0 | 8.12.0.0 | elastic8.12.0 | |
| 8.12.1 | 8.12.1.0 | elastic8.12.1 | |
| 8.12.2 | 8.12.2.0 | elastic8.12.2 | |
| 8.13.0 | 8.13.0.0 | elastic8.13.0 | |
| 8.13.1 | 8.13.1.0 | elastic8.13.1 | |
| 8.13.2 | 8.13.2.0 | elastic8.13.2 | |
| 8.13.3 | 8.13.3.0 | elastic8.13.3 | |
| 8.13.4 | 8.13.4.0 | elastic8.13.4 | |
| 8.14.0 | 8.14.0.0 | elastic8.14.0 | |
| 8.14.1 | 8.14.1.0 | elastic8.14.1 | |
| 8.14.2 | 8.14.2.0 | elastic8.14.2 | |
| 8.14.3 | 8.14.3.0 | elastic8.14.3 | |
| 8.15.0 | 8.15.0.0 | elastic8.15.0 | |
| 8.15.1 | 8.15.1.0 | elastic8.15.1 | |
| 8.15.2 | 8.15.2.0 | elastic8.15.2 | |
| 8.15.3 | 8.15.3.0 | elastic8.15.3 | |
| 8.15.4 | 8.15.4.0 | elastic8.15.4 | |
| 8.15.5 | 8.15.5.0 | elastic8.15.5 | |
| 8.16.0 | 8.16.0.0 | elastic8.16.0 | |
| 8.16.1 | 8.16.1.0 | elastic8.16.1 | |
| 8.16.2 | 8.16.2.0 | elastic8.16.2 | |
| 8.16.3 | 8.16.3.0 | elastic8.16.3 | |
| 8.17.0 | 8.17.0.0 | elastic8.17.0 | |
| 8.17.1 | 8.17.1.0 | elastic8.17.1 | |
| 8.17.2 | 8.17.2.0 | elastic8.17.2 | |
| 8.17.3 | 8.17.3.0 | elastic8.17.3 | |
| 8.17.4 | 8.17.4.0 | elastic8.17.4 | |
| 8.17.5 | 8.17.5.0 | elastic8.17.5 | |
| 8.18.0 | 8.18.0.0 | elastic8.18.0 | |
| 8.18.1 | 8.18.1.0 | elastic8.18.1 | |
| 8.18.2 | 8.18.2.0 | elastic8.18.2 | |
| 8.18.3 | 8.18.3.0 | elastic8.18.3 | |
| 8.18.4 | 8.18.4.0 | elastic8.18.4 | |
| 8.18.5 | 8.18.5.0 | elastic8.18.5 | |
| 8.18.6 | 8.18.6.0 | elastic8.18.6 | |
| 8.18.7 | 8.18.7.0 | elastic8.18.7 | |
| 8.19.0 | 8.19.0.0 | elastic8.19.0 | |
| 8.19.1 | 8.19.1.0 | elastic8.19.1 | |
| 8.19.2 | 8.19.2.0 | elastic8.19.2 | |
| 8.19.3 | 8.19.3.0 | elastic8.19.3 | |
| 8.19.4 | 8.19.4.0 | elastic8.19.4 | |
| 9.0.0 | 9.0.0.0 | elastic9.0.0 | |
| 9.0.1 | 9.0.1.0 | elastic9.0.1 | |
| 9.0.2 | 9.0.2.0 | elastic9.0.2 | |
| 9.0.3 | 9.0.3.0 | elastic9.0.3 | |
| 9.0.4 | 9.0.4.0 | elastic9.0.4 | |
| 9.0.5 | 9.0.5.0 | elastic9.0.5 | |
| 9.0.6 | 9.0.6.0 | elastic9.0.6 | |
| 9.0.7 | 9.0.7.0 | elastic9.0.7 | |
| 9.1.0 | 9.1.0.0 | elastic9.1.0 | |
| 9.1.1 | 9.1.1.0 | elastic9.1.1 | |
| 9.1.2 | 9.1.2.0 | elastic9.1.2 | |
| 9.1.3 | 9.1.3.0 | elastic9.1.3 | |
| 9.1.4 | 9.1.4.0 | elastic9.1.4 |
./bin/plugin -u https://github.com/NLPchina/elasticsearch-sql/releases/download/1.7.6/elasticsearch-sql-1.7.6.zip --install sql./bin/plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/2.0.4/elasticsearch-sql-2.0.4.zip./bin/plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/2.1.0.2/elasticsearch-sql-2.1.0.2.zip./bin/plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/2.1.1.1/elasticsearch-sql-2.1.1.1.zip./bin/plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/2.1.2.0/elasticsearch-sql-2.1.2.0.zip./bin/plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/2.2.0.1/elasticsearch-sql-2.2.0.1.zip./bin/plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/2.2.1.0/elasticsearch-sql-2.2.1.0.zip./bin/plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/2.3.0.0/elasticsearch-sql-2.3.0.0.zip./bin/plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/2.3.1.1/elasticsearch-sql-2.3.1.1.zip./bin/plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/2.3.2.0/elasticsearch-sql-2.3.2.0.zip./bin/plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/2.3.3.0/elasticsearch-sql-2.3.3.0.zip./bin/plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/2.3.4.0/elasticsearch-sql-2.3.4.0.zip./bin/plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/2.3.5.0/elasticsearch-sql-2.3.5.0.zip./bin/plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/2.4.0.1/elasticsearch-sql-2.4.0.1.zip./bin/plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/2.4.1.0/elasticsearch-sql-2.4.1.0.zip./bin/plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/2.4.2.1/elasticsearch-sql-2.4.2.1.zip./bin/plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/2.4.3.0/elasticsearch-sql-2.4.3.0.zip./bin/plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/2.4.4.0/elasticsearch-sql-2.4.4.0.zip./bin/plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/2.4.5.0/elasticsearch-sql-2.4.5.0.zip./bin/plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/2.4.6.0/elasticsearch-sql-2.4.6.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/5.0.1/elasticsearch-sql-5.0.1.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/5.1.1.0/elasticsearch-sql-5.1.1.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/5.1.2.0/elasticsearch-sql-5.1.2.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/5.2.0.0/elasticsearch-sql-5.2.0.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/5.2.1.0/elasticsearch-sql-5.2.1.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/5.2.2.0/elasticsearch-sql-5.2.2.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/5.3.0.0/elasticsearch-sql-5.3.0.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/5.3.1.0/elasticsearch-sql-5.3.1.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/5.3.2.0/elasticsearch-sql-5.3.2.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/5.3.3.0/elasticsearch-sql-5.3.3.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/5.4.0.0/elasticsearch-sql-5.4.0.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/5.4.1.0/elasticsearch-sql-5.4.1.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/5.4.2.0/elasticsearch-sql-5.4.2.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/5.4.3.0/elasticsearch-sql-5.4.3.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/5.5.0.0/elasticsearch-sql-5.5.0.1.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/5.5.1.0/elasticsearch-sql-5.5.1.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/5.5.2.0/elasticsearch-sql-5.5.2.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/5.5.3.0/elasticsearch-sql-5.5.3.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/5.6.0.0/elasticsearch-sql-5.6.0.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/5.6.1.0/elasticsearch-sql-5.6.1.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/5.6.2.0/elasticsearch-sql-5.6.2.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/5.6.3.0/elasticsearch-sql-5.6.3.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/5.6.4.0/elasticsearch-sql-5.6.4.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/5.6.5.0/elasticsearch-sql-5.6.5.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/5.6.6.0/elasticsearch-sql-5.6.6.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/5.6.7.0/elasticsearch-sql-5.6.7.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/5.6.8.0/elasticsearch-sql-5.6.8.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/5.6.9.0/elasticsearch-sql-5.6.9.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/5.6.10.0/elasticsearch-sql-5.6.10.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/5.6.11.0/elasticsearch-sql-5.6.11.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/5.6.12.0/elasticsearch-sql-5.6.12.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/5.6.13.0/elasticsearch-sql-5.6.13.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/5.6.14.0/elasticsearch-sql-5.6.14.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/5.6.15.0/elasticsearch-sql-5.6.15.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/5.6.16.0/elasticsearch-sql-5.6.16.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/6.0.0.0/elasticsearch-sql-6.0.0.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/6.0.1.0/elasticsearch-sql-6.0.1.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/6.1.0.0/elasticsearch-sql-6.1.0.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/6.1.1.0/elasticsearch-sql-6.1.1.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/6.1.2.0/elasticsearch-sql-6.1.2.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/6.1.3.0/elasticsearch-sql-6.1.3.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/6.1.4.0/elasticsearch-sql-6.1.4.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/6.2.0.0/elasticsearch-sql-6.2.0.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/6.2.1.0/elasticsearch-sql-6.2.1.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/6.2.2.0/elasticsearch-sql-6.2.2.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/6.2.3.0/elasticsearch-sql-6.2.3.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/6.2.4.0/elasticsearch-sql-6.2.4.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/6.3.0.0/elasticsearch-sql-6.3.0.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/6.3.1.0/elasticsearch-sql-6.3.1.1.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/6.3.2.0/elasticsearch-sql-6.3.2.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/6.4.0.0/elasticsearch-sql-6.4.0.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/6.4.1.0/elasticsearch-sql-6.4.1.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/6.4.2.0/elasticsearch-sql-6.4.2.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/6.4.3.0/elasticsearch-sql-6.4.3.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/6.5.0.0/elasticsearch-sql-6.5.0.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/6.5.1.0/elasticsearch-sql-6.5.1.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/6.5.2.0/elasticsearch-sql-6.5.2.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/6.5.3.0/elasticsearch-sql-6.5.3.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/6.5.4.0/elasticsearch-sql-6.5.4.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/6.6.0.0/elasticsearch-sql-6.6.0.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/6.6.1.0/elasticsearch-sql-6.6.1.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/6.6.2.0/elasticsearch-sql-6.6.2.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/6.7.0.0/elasticsearch-sql-6.7.0.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/6.7.1.0/elasticsearch-sql-6.7.1.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/6.7.2.0/elasticsearch-sql-6.7.2.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/6.8.0.0/elasticsearch-sql-6.8.0.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/6.8.1.0/elasticsearch-sql-6.8.1.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/6.8.2.0/elasticsearch-sql-6.8.2.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/6.8.3.0/elasticsearch-sql-6.8.3.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/6.8.4.0/elasticsearch-sql-6.8.4.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/6.8.5.0/elasticsearch-sql-6.8.5.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/6.8.6.0/elasticsearch-sql-6.8.6.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/6.8.7.0/elasticsearch-sql-6.8.7.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/6.8.8.0/elasticsearch-sql-6.8.8.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/6.8.9.0/elasticsearch-sql-6.8.9.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/6.8.10.0/elasticsearch-sql-6.8.10.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/6.8.11.0/elasticsearch-sql-6.8.11.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/6.8.12.0/elasticsearch-sql-6.8.12.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/6.8.13.0/elasticsearch-sql-6.8.13.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/6.8.14.0/elasticsearch-sql-6.8.14.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/6.8.15.0/elasticsearch-sql-6.8.15.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/6.8.16.0/elasticsearch-sql-6.8.16.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/6.8.17.0/elasticsearch-sql-6.8.17.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/6.8.18.0/elasticsearch-sql-6.8.18.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/6.8.19.0/elasticsearch-sql-6.8.19.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/6.8.20.0/elasticsearch-sql-6.8.20.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/6.8.21.0/elasticsearch-sql-6.8.21.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/6.8.22.0/elasticsearch-sql-6.8.22.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/6.8.23.0/elasticsearch-sql-6.8.23.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/7.0.0.0/elasticsearch-sql-7.0.0.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/7.0.1.0/elasticsearch-sql-7.0.1.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/7.1.0.0/elasticsearch-sql-7.1.0.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/7.1.1.0/elasticsearch-sql-7.1.1.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/7.2.0.0/elasticsearch-sql-7.2.0.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/7.2.1.0/elasticsearch-sql-7.2.1.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/7.3.0.0/elasticsearch-sql-7.3.0.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/7.3.1.0/elasticsearch-sql-7.3.1.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/7.3.2.0/elasticsearch-sql-7.3.2.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/7.4.0.0/elasticsearch-sql-7.4.0.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/7.4.1.0/elasticsearch-sql-7.4.1.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/7.4.2.0/elasticsearch-sql-7.4.2.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/7.5.0.0/elasticsearch-sql-7.5.0.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/7.5.1.0/elasticsearch-sql-7.5.1.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/7.5.2.0/elasticsearch-sql-7.5.2.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/7.6.0.0/elasticsearch-sql-7.6.0.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/7.6.1.0/elasticsearch-sql-7.6.1.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/7.6.2.0/elasticsearch-sql-7.6.2.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/7.7.0.0/elasticsearch-sql-7.7.0.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/7.7.1.0/elasticsearch-sql-7.7.1.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/7.8.0.0/elasticsearch-sql-7.8.0.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/7.8.1.0/elasticsearch-sql-7.8.1.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/7.9.0.0/elasticsearch-sql-7.9.0.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/7.9.1.0/elasticsearch-sql-7.9.1.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/7.9.2.0/elasticsearch-sql-7.9.2.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/7.9.3.0/elasticsearch-sql-7.9.3.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/7.10.0.0/elasticsearch-sql-7.10.0.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/7.10.1.0/elasticsearch-sql-7.10.1.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/7.10.2.0/elasticsearch-sql-7.10.2.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/7.11.0.0/elasticsearch-sql-7.11.0.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/7.11.1.0/elasticsearch-sql-7.11.1.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/7.11.2.0/elasticsearch-sql-7.11.2.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/7.12.0.0/elasticsearch-sql-7.12.0.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/7.12.1.0/elasticsearch-sql-7.12.1.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/7.13.0.0/elasticsearch-sql-7.13.0.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/7.13.1.0/elasticsearch-sql-7.13.1.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/7.13.2.0/elasticsearch-sql-7.13.2.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/7.13.3.0/elasticsearch-sql-7.13.3.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/7.13.4.0/elasticsearch-sql-7.13.4.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/7.14.0.0/elasticsearch-sql-7.14.0.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/7.14.1.0/elasticsearch-sql-7.14.1.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/7.14.2.0/elasticsearch-sql-7.14.2.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/7.15.0.0/elasticsearch-sql-7.15.0.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/7.15.1.0/elasticsearch-sql-7.15.1.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/7.15.2.0/elasticsearch-sql-7.15.2.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/7.16.0.0/elasticsearch-sql-7.16.0.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/7.16.1.0/elasticsearch-sql-7.16.1.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/7.16.2.0/elasticsearch-sql-7.16.2.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/7.16.3.0/elasticsearch-sql-7.16.3.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/7.17.0.0/elasticsearch-sql-7.17.0.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/7.17.1.0/elasticsearch-sql-7.17.1.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/7.17.2.0/elasticsearch-sql-7.17.2.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/7.17.3.0/elasticsearch-sql-7.17.3.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/7.17.4.0/elasticsearch-sql-7.17.4.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/7.17.5.0/elasticsearch-sql-7.17.5.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/7.17.6.0/elasticsearch-sql-7.17.6.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/7.17.7.0/elasticsearch-sql-7.17.7.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/v7.17.8/elasticsearch-sql-7.17.8.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/v7.17.9/elasticsearch-sql-7.17.9.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/v7.17.10/elasticsearch-sql-7.17.10.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/v7.17.11/elasticsearch-sql-7.17.11.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/v7.17.12/elasticsearch-sql-7.17.12.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/v7.17.13/elasticsearch-sql-7.17.13.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/v7.17.14/elasticsearch-sql-7.17.14.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/v7.17.15/elasticsearch-sql-7.17.15.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/v7.17.16/elasticsearch-sql-7.17.16.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/v7.17.17/elasticsearch-sql-7.17.17.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/v7.17.18/elasticsearch-sql-7.17.18.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/v7.17.19/elasticsearch-sql-7.17.19.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/v7.17.20/elasticsearch-sql-7.17.20.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/v7.17.21/elasticsearch-sql-7.17.21.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/v7.17.22/elasticsearch-sql-7.17.22.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/v7.17.23/elasticsearch-sql-7.17.23.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/v7.17.24/elasticsearch-sql-7.17.24.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/v7.17.25/elasticsearch-sql-7.17.25.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/v7.17.26/elasticsearch-sql-7.17.26.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/v7.17.27/elasticsearch-sql-7.17.27.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/v7.17.28/elasticsearch-sql-7.17.28.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/8.5.3.0/elasticsearch-sql-8.5.3.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/v8.6.0/elasticsearch-sql-8.6.0.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/v8.6.1/elasticsearch-sql-8.6.1.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/v8.6.2/elasticsearch-sql-8.6.2.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/v8.7.0/elasticsearch-sql-8.7.0.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/v8.7.1/elasticsearch-sql-8.7.1.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/v8.8.0/elasticsearch-sql-8.8.0.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/v8.8.1/elasticsearch-sql-8.8.1.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/v8.8.2/elasticsearch-sql-8.8.2.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/v8.9.0/elasticsearch-sql-8.9.0.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/v8.9.1/elasticsearch-sql-8.9.1.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/v8.9.2/elasticsearch-sql-8.9.2.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/v8.10.0/elasticsearch-sql-8.10.0.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/v8.10.1/elasticsearch-sql-8.10.1.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/v8.10.2/elasticsearch-sql-8.10.2.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/v8.10.3/elasticsearch-sql-8.10.3.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/v8.10.4/elasticsearch-sql-8.10.4.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/v8.11.0/elasticsearch-sql-8.11.0.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/v8.11.1/elasticsearch-sql-8.11.1.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/v8.11.2/elasticsearch-sql-8.11.2.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/v8.11.3/elasticsearch-sql-8.11.3.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/v8.11.4/elasticsearch-sql-8.11.4.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/v8.12.0/elasticsearch-sql-8.12.0.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/v8.12.1/elasticsearch-sql-8.12.1.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/v8.12.2/elasticsearch-sql-8.12.2.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/v8.13.0/elasticsearch-sql-8.13.0.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/v8.13.1/elasticsearch-sql-8.13.1.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/v8.13.2/elasticsearch-sql-8.13.2.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/v8.13.3/elasticsearch-sql-8.13.3.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/v8.13.4/elasticsearch-sql-8.13.4.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/v8.14.0/elasticsearch-sql-8.14.0.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/v8.14.1/elasticsearch-sql-8.14.1.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/v8.14.2/elasticsearch-sql-8.14.2.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/v8.14.3/elasticsearch-sql-8.14.3.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/v8.15.0/elasticsearch-sql-8.15.0.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/v8.15.1/elasticsearch-sql-8.15.1.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/v8.15.2/elasticsearch-sql-8.15.2.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/v8.15.3/elasticsearch-sql-8.15.3.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/v8.15.4/elasticsearch-sql-8.15.4.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/v8.15.5/elasticsearch-sql-8.15.5.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/v8.16.0/elasticsearch-sql-8.16.0.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/v8.16.1/elasticsearch-sql-8.16.1.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/v8.16.2/elasticsearch-sql-8.16.2.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/v8.16.3/elasticsearch-sql-8.16.3.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/v8.17.0/elasticsearch-sql-8.17.0.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/v8.17.1/elasticsearch-sql-8.17.1.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/v8.17.2/elasticsearch-sql-8.17.2.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/v8.17.3/elasticsearch-sql-8.17.3.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/v8.17.4/elasticsearch-sql-8.17.4.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/v8.17.5/elasticsearch-sql-8.17.5.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/v8.18.0/elasticsearch-sql-8.18.0.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/v8.18.1/elasticsearch-sql-8.18.1.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/v8.18.2/elasticsearch-sql-8.18.2.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/v8.18.3/elasticsearch-sql-8.18.3.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/v8.18.4/elasticsearch-sql-8.18.4.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/v8.18.5/elasticsearch-sql-8.18.5.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/v8.18.6/elasticsearch-sql-8.18.6.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/v8.18.7/elasticsearch-sql-8.18.7.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/v8.19.0/elasticsearch-sql-8.19.0.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/v8.19.1/elasticsearch-sql-8.19.1.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/v8.19.2/elasticsearch-sql-8.19.2.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/v8.19.3/elasticsearch-sql-8.19.3.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/v8.19.4/elasticsearch-sql-8.19.4.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/v9.0.0/elasticsearch-sql-9.0.0.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/v9.0.1/elasticsearch-sql-9.0.1.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/v9.0.2/elasticsearch-sql-9.0.2.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/v9.0.3/elasticsearch-sql-9.0.3.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/v9.0.4/elasticsearch-sql-9.0.4.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/v9.0.5/elasticsearch-sql-9.0.5.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/v9.0.6/elasticsearch-sql-9.0.6.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/v9.0.7/elasticsearch-sql-9.0.7.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/v9.1.0/elasticsearch-sql-9.1.0.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/v9.1.1/elasticsearch-sql-9.1.1.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/v9.1.2/elasticsearch-sql-9.1.2.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/v9.1.3/elasticsearch-sql-9.1.3.0.zip./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/v9.1.4/elasticsearch-sql-9.1.4.0.zipAfter doing this, you need to restart the Elasticsearch server. Otherwise you may get errors likeInvalid index name [sql], must not start with '']; ","status":400}.
On elasticsearch 1.x / 2.x, visit the elasticsearch-sql web front-end:
http://localhost:9200/_plugin/sql/On elasticsearch 5.x/6.x, useelasticsearch 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-servernpm install express --savenode 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'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 DESCDelete
DELETE FROM bank WHERE age >30 AND gender = 'm'
Search
SELECT address FROM bank WHERE address = matchQuery('880 Holmes Lane') ORDER BY _score DESC LIMIT 3Aggregations
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 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 field_1 + field_2 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 user_count from t_user group by city limit 100;
- on the above example, the bucket size is 100, shard size is 20*100 = 2000
Check details :JDBC Support
- ES TopHits
- ES MISSING
- ES STATS
- ES GEO_INTERSECTS
- ES GEO_BOUNDING_BOX
- ES GEO_DISTANCE
- ES GEOHASH_GRID aggregation
About
Use SQL to query Elasticsearch
Topics
Resources
License
Uh oh!
There was an error while loading.Please reload this page.
Stars
Watchers
Forks
Packages0
No packages published
Uh oh!
There was an error while loading.Please reload this page.