NLPchina/elasticsearch-sql

BranchesTags
 
 

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

1,074 Commits
doc
doc
 
 
src
src
 
 
.DS_Store
.DS_Store
 
 
.gitignore
.gitignore
 
 
.travis.yml
.travis.yml
 
 
BUILDING.md
BUILDING.md
 
 
LICENSE
LICENSE
 
 
README.md
README.md
 
 
open-source.pom.xml
open-source.pom.xml
 
 
pom.xml
pom.xml
 
 

Repository files navigation

6.8.23 6.8.23 Build Status7.17.28 7.17.28 Build Status8.17.4 8.17.4 Build Statusmaster master Build Status

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

Check out our wiki!

Web frontend overview

elasticsearch versionlatest versionremarksbranch
1.x1.7.6tested against elastic 1.7.6elastic1.x
2.0.02.0.4delete commands not supportedelastic2.0
2.1.02.1.0.2delete commands not supportedelastic2.1
2.1.12.1.1.1delete commands not supportedelastic2.1.1
2.1.22.1.2.0delete commands not supportedelastic2.1.2
2.2.02.2.0.1delete commands not supportedelastic2.2.0
2.2.12.2.1.0delete commands not supportedelastic2.2.1
2.3.02.3.0.0delete commands not supportedelastic2.3.0
2.3.12.3.1.1delete commands not supportedelastic2.3.1
2.3.22.3.2.0delete commands not supportedelastic2.3.2
2.3.32.3.3.0delete commands not supportedelastic2.3.3
2.3.42.3.4.0delete commands not supportedelastic2.3.4
2.3.52.3.5.0delete commands not supportedelastic2.3.5
2.4.02.4.0.1delete commands not supportedelastic2.4.0
2.4.12.4.1.0delete commands not supportedelastic2.4.1
2.4.22.4.2.1delete commands not supportedelastic2.4.2
2.4.32.4.3.0delete commands not supportedelastic2.4.3
2.4.42.4.4.0delete commands not supportedelastic2.4.4
2.4.52.4.5.0delete commands not supportedelastic2.4.5
2.4.62.4.6.0delete commands not supportedelastic2.4.6
5.0.15.0.1.0delete commands not supportedelastic5.0.1
5.1.15.1.1.0delete commands not supportedelastic5.1.1
5.1.25.1.2.0delete commands not supportedelastic5.1.2
5.2.05.2.0.0delete commands not supportedelastic5.2.0
5.2.15.2.1.0delete commands not supportedelastic5.2.1
5.2.25.2.2.0delete commands not supportedelastic5.2.2
5.3.05.3.0.0delete commands not supportedelastic5.3.0
5.3.15.3.1.0delete commands not supportedelastic5.3.1
5.3.25.3.2.0delete commands not supportedelastic5.3.2
5.3.35.3.3.0delete commands not supportedelastic5.3.3
5.4.05.4.0.0delete commands not supportedelastic5.4.0
5.4.15.4.1.0delete commands not supportedelastic5.4.1
5.4.25.4.2.0delete commands not supportedelastic5.4.2
5.4.35.4.3.0delete commands not supportedelastic5.4.3
5.5.05.5.0.1delete commands not supportedelastic5.5.0
5.5.15.5.1.0delete commands not supportedelastic5.5.1
5.5.25.5.2.0delete commands not supportedelastic5.5.2
5.5.35.5.3.0delete commands not supportedelastic5.5.3
5.6.05.6.0.0delete commands not supportedelastic5.6.0
5.6.15.6.1.0delete commands not supportedelastic5.6.1
5.6.25.6.2.0delete commands not supportedelastic5.6.2
5.6.35.6.3.0delete commands not supportedelastic5.6.3
5.6.45.6.4.0delete commands not supportedelastic5.6.4
5.6.55.6.5.0delete commands not supportedelastic5.6.5
5.6.65.6.6.0elastic5.6.6
5.6.75.6.7.0elastic5.6.7
5.6.85.6.8.0elastic5.6.8
5.6.95.6.9.0elastic5.6.9
5.6.105.6.10.0elastic5.6.10
5.6.115.6.11.0elastic5.6.11
5.6.125.6.12.0elastic5.6.12
5.6.135.6.13.0elastic5.6.13
5.6.145.6.14.0elastic5.6.14
5.6.155.6.15.0elastic5.6.15
5.6.165.6.16.0elastic5.6.16
6.0.06.0.0.0elastic6.0.0
6.0.16.0.1.0elastic6.0.1
6.1.06.1.0.0elastic6.1.0
6.1.16.1.1.0elastic6.1.1
6.1.26.1.2.0elastic6.1.2
6.1.36.1.3.0elastic6.1.3
6.1.46.1.4.0elastic6.1.4
6.2.06.2.0.0elastic6.2.0
6.2.16.2.1.0elastic6.2.1
6.2.26.2.2.0elastic6.2.2
6.2.36.2.3.0elastic6.2.3
6.2.46.2.4.0elastic6.2.4
6.3.06.3.0.0elastic6.3.0
6.3.16.3.1.0elastic6.3.1
6.3.26.3.2.0elastic6.3.2
6.4.06.4.0.0elastic6.4.0
6.4.16.4.1.0elastic6.4.1
6.4.26.4.2.0elastic6.4.2
6.4.36.4.3.0elastic6.4.3
6.5.06.5.0.0elastic6.5.0
6.5.16.5.1.0elastic6.5.1
6.5.26.5.2.0elastic6.5.2
6.5.36.5.3.0elastic6.5.3
6.5.46.5.4.0elastic6.5.4
6.6.06.6.0.0elastic6.6.0
6.6.16.6.1.0elastic6.6.1
6.6.26.6.2.0elastic6.6.2
6.7.06.7.0.0elastic6.7.0
6.7.16.7.1.0elastic6.7.1
6.7.26.7.2.0elastic6.7.2
6.8.06.8.0.0elastic6.8.0
6.8.16.8.1.0elastic6.8.1
6.8.26.8.2.0elastic6.8.2
6.8.36.8.3.0elastic6.8.3
6.8.46.8.4.0elastic6.8.4
6.8.56.8.5.0elastic6.8.5
6.8.66.8.6.0elastic6.8.6
6.8.76.8.7.0elastic6.8.7
6.8.86.8.8.0elastic6.8.8
6.8.96.8.9.0elastic6.8.9
6.8.106.8.10.0elastic6.8.10
6.8.116.8.11.0elastic6.8.11
6.8.126.8.12.0elastic6.8.12
6.8.136.8.13.0elastic6.8.13
6.8.146.8.14.0elastic6.8.14
6.8.156.8.15.0elastic6.8.15
6.8.166.8.16.0elastic6.8.16
6.8.176.8.17.0elastic6.8.17
6.8.186.8.18.0elastic6.8.18
6.8.196.8.19.0elastic6.8.19
6.8.206.8.20.0elastic6.8.20
6.8.216.8.21.0elastic6.8.21
6.8.226.8.22.0elastic6.8.22
6.8.236.8.23.0elastic6.8.23
7.0.07.0.0.0elastic7.0.0
7.0.17.0.1.0elastic7.0.1
7.1.07.1.0.0elastic7.1.0
7.1.17.1.1.0elastic7.1.1
7.2.07.2.0.0elastic7.2.0
7.2.17.2.1.0elastic7.2.1
7.3.07.3.0.0elastic7.3.0
7.3.17.3.1.0elastic7.3.1
7.3.27.3.2.0elastic7.3.2
7.4.07.4.0.0elastic7.4.0
7.4.17.4.1.0elastic7.4.1
7.4.27.4.2.0elastic7.4.2
7.5.07.5.0.0elastic7.5.0
7.5.17.5.1.0elastic7.5.1
7.5.27.5.2.0elastic7.5.2
7.6.07.6.0.0elastic7.6.0
7.6.17.6.1.0elastic7.6.1
7.6.27.6.2.0elastic7.6.2
7.7.07.7.0.0elastic7.7.0
7.7.17.7.1.0elastic7.7.1
7.8.07.8.0.0elastic7.8.0
7.8.17.8.1.0elastic7.8.1
7.9.07.9.0.0elastic7.9.0
7.9.17.9.1.0elastic7.9.1
7.9.27.9.2.0elastic7.9.2
7.9.37.9.3.0elastic7.9.3
7.10.07.10.0.0elastic7.10.0
7.10.17.10.1.0elastic7.10.1
7.10.27.10.2.0elastic7.10.2
7.11.07.11.0.0elastic7.11.0
7.11.17.11.1.0elastic7.11.1
7.11.27.11.2.0elastic7.11.2
7.12.07.12.0.0elastic7.12.0
7.12.17.12.1.0elastic7.12.1
7.13.07.13.0.0elastic7.13.0
7.13.17.13.1.0elastic7.13.1
7.13.27.13.2.0elastic7.13.2
7.13.37.13.3.0elastic7.13.3
7.13.47.13.4.0elastic7.13.4
7.14.07.14.0.0elastic7.14.0
7.14.17.14.1.0elastic7.14.1
7.14.27.14.2.0elastic7.14.2
7.15.07.15.0.0elastic7.15.0
7.15.17.15.1.0elastic7.15.1
7.15.27.15.2.0elastic7.15.2
7.16.07.16.0.0elastic7.16.0
7.16.17.16.1.0elastic7.16.1
7.16.27.16.2.0elastic7.16.2
7.16.37.16.3.0elastic7.16.3
7.17.07.17.0.0elastic7.17.0
7.17.17.17.1.0elastic7.17.1
7.17.27.17.2.0elastic7.17.2
7.17.37.17.3.0elastic7.17.3
7.17.47.17.4.0elastic7.17.4
7.17.57.17.5.0elastic7.17.5
7.17.67.17.6.0elastic7.17.6
7.17.77.17.7.0elastic7.17.7
7.17.87.17.8.0elastic7.17.8
7.17.97.17.9.0elastic7.17.9
7.17.107.17.10.0elastic7.17.10
7.17.117.17.11.0elastic7.17.11
7.17.127.17.12.0elastic7.17.12
7.17.137.17.13.0elastic7.17.13
7.17.147.17.14.0elastic7.17.14
7.17.157.17.15.0elastic7.17.15
7.17.167.17.16.0elastic7.17.16
7.17.177.17.17.0elastic7.17.17
7.17.187.17.18.0elastic7.17.18
7.17.197.17.19.0elastic7.17.19
7.17.207.17.20.0elastic7.17.20
7.17.217.17.21.0elastic7.17.21
7.17.227.17.22.0elastic7.17.22
7.17.237.17.23.0elastic7.17.23
7.17.247.17.24.0elastic7.17.24
7.17.257.17.25.0elastic7.17.25
7.17.267.17.26.0elastic7.17.26
7.17.277.17.27.0elastic7.17.27
7.17.287.17.28.0elastic7.17.28
8.5.38.5.3.0elastic8.5.3
8.6.08.6.0.0elastic8.6.0
8.6.18.6.1.0elastic8.6.1
8.6.28.6.2.0elastic8.6.2
8.7.08.7.0.0elastic8.7.0
8.7.18.7.1.0elastic8.7.1
8.8.08.8.0.0elastic8.8.0
8.8.18.8.1.0elastic8.8.1
8.8.28.8.2.0elastic8.8.2
8.9.08.9.0.0elastic8.9.0
8.9.18.9.1.0elastic8.9.1
8.9.28.9.2.0elastic8.9.2
8.10.08.10.0.0elastic8.10.0
8.10.18.10.1.0elastic8.10.1
8.10.28.10.2.0elastic8.10.2
8.10.38.10.3.0elastic8.10.3
8.10.48.10.4.0elastic8.10.4
8.11.08.11.0.0elastic8.11.0
8.11.18.11.1.0elastic8.11.1
8.11.28.11.2.0elastic8.11.2
8.11.38.11.3.0elastic8.11.3
8.11.48.11.4.0elastic8.11.4
8.12.08.12.0.0elastic8.12.0
8.12.18.12.1.0elastic8.12.1
8.12.28.12.2.0elastic8.12.2
8.13.08.13.0.0elastic8.13.0
8.13.18.13.1.0elastic8.13.1
8.13.28.13.2.0elastic8.13.2
8.13.38.13.3.0elastic8.13.3
8.13.48.13.4.0elastic8.13.4
8.14.08.14.0.0elastic8.14.0
8.14.18.14.1.0elastic8.14.1
8.14.28.14.2.0elastic8.14.2
8.14.38.14.3.0elastic8.14.3
8.15.08.15.0.0elastic8.15.0
8.15.18.15.1.0elastic8.15.1
8.15.28.15.2.0elastic8.15.2
8.15.38.15.3.0elastic8.15.3
8.15.48.15.4.0elastic8.15.4
8.15.58.15.5.0elastic8.15.5
8.16.08.16.0.0elastic8.16.0
8.16.18.16.1.0elastic8.16.1
8.16.28.16.2.0elastic8.16.2
8.16.38.16.3.0elastic8.16.3
8.17.08.17.0.0elastic8.17.0
8.17.18.17.1.0elastic8.17.1
8.17.28.17.2.0elastic8.17.2
8.17.38.17.3.0elastic8.17.3
8.17.48.17.4.0elastic8.17.4
./bin/plugin -u https://.com/NLPchina/elasticsearch-sql/releases/download/1.7.6/elasticsearch-sql-1.7.6.zip --install sql

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

./bin/elasticsearch-plugin install https://.com/NLPchina/elasticsearch-sql/releases/download/v7.17.8/elasticsearch-sql-7.17.8.0.zip

./bin/elasticsearch-plugin install https://.com/NLPchina/elasticsearch-sql/releases/download/v7.17.9/elasticsearch-sql-7.17.9.0.zip

./bin/elasticsearch-plugin install https://.com/NLPchina/elasticsearch-sql/releases/download/v7.17.10/elasticsearch-sql-7.17.10.0.zip

./bin/elasticsearch-plugin install https://.com/NLPchina/elasticsearch-sql/releases/download/v7.17.11/elasticsearch-sql-7.17.11.0.zip

./bin/elasticsearch-plugin install https://.com/NLPchina/elasticsearch-sql/releases/download/v7.17.12/elasticsearch-sql-7.17.12.0.zip

./bin/elasticsearch-plugin install https://.com/NLPchina/elasticsearch-sql/releases/download/v7.17.13/elasticsearch-sql-7.17.13.0.zip

./bin/elasticsearch-plugin install https://.com/NLPchina/elasticsearch-sql/releases/download/v7.17.14/elasticsearch-sql-7.17.14.0.zip

./bin/elasticsearch-plugin install https://.com/NLPchina/elasticsearch-sql/releases/download/v7.17.15/elasticsearch-sql-7.17.15.0.zip

./bin/elasticsearch-plugin install https://.com/NLPchina/elasticsearch-sql/releases/download/v7.17.16/elasticsearch-sql-7.17.16.0.zip

./bin/elasticsearch-plugin install https://.com/NLPchina/elasticsearch-sql/releases/download/v7.17.17/elasticsearch-sql-7.17.17.0.zip

./bin/elasticsearch-plugin install https://.com/NLPchina/elasticsearch-sql/releases/download/v7.17.18/elasticsearch-sql-7.17.18.0.zip

./bin/elasticsearch-plugin install https://.com/NLPchina/elasticsearch-sql/releases/download/v7.17.19/elasticsearch-sql-7.17.19.0.zip

./bin/elasticsearch-plugin install https://.com/NLPchina/elasticsearch-sql/releases/download/v7.17.20/elasticsearch-sql-7.17.20.0.zip

./bin/elasticsearch-plugin install https://.com/NLPchina/elasticsearch-sql/releases/download/v7.17.21/elasticsearch-sql-7.17.21.0.zip

./bin/elasticsearch-plugin install https://.com/NLPchina/elasticsearch-sql/releases/download/v7.17.22/elasticsearch-sql-7.17.22.0.zip

./bin/elasticsearch-plugin install https://.com/NLPchina/elasticsearch-sql/releases/download/v7.17.23/elasticsearch-sql-7.17.23.0.zip

./bin/elasticsearch-plugin install https://.com/NLPchina/elasticsearch-sql/releases/download/v7.17.24/elasticsearch-sql-7.17.24.0.zip

./bin/elasticsearch-plugin install https://.com/NLPchina/elasticsearch-sql/releases/download/v7.17.25/elasticsearch-sql-7.17.25.0.zip

./bin/elasticsearch-plugin install https://.com/NLPchina/elasticsearch-sql/releases/download/v7.17.26/elasticsearch-sql-7.17.26.0.zip

./bin/elasticsearch-plugin install https://.com/NLPchina/elasticsearch-sql/releases/download/v7.17.27/elasticsearch-sql-7.17.27.0.zip

./bin/elasticsearch-plugin install https://.com/NLPchina/elasticsearch-sql/releases/download/v7.17.28/elasticsearch-sql-7.17.28.0.zip

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

./bin/elasticsearch-plugin install https://.com/NLPchina/elasticsearch-sql/releases/download/v8.6.0/elasticsearch-sql-8.6.0.0.zip

./bin/elasticsearch-plugin install https://.com/NLPchina/elasticsearch-sql/releases/download/v8.6.1/elasticsearch-sql-8.6.1.0.zip

./bin/elasticsearch-plugin install https://.com/NLPchina/elasticsearch-sql/releases/download/v8.6.2/elasticsearch-sql-8.6.2.0.zip

./bin/elasticsearch-plugin install https://.com/NLPchina/elasticsearch-sql/releases/download/v8.7.0/elasticsearch-sql-8.7.0.0.zip

./bin/elasticsearch-plugin install https://.com/NLPchina/elasticsearch-sql/releases/download/v8.7.1/elasticsearch-sql-8.7.1.0.zip

./bin/elasticsearch-plugin install https://.com/NLPchina/elasticsearch-sql/releases/download/v8.8.0/elasticsearch-sql-8.8.0.0.zip

./bin/elasticsearch-plugin install https://.com/NLPchina/elasticsearch-sql/releases/download/v8.8.1/elasticsearch-sql-8.8.1.0.zip

./bin/elasticsearch-plugin install https://.com/NLPchina/elasticsearch-sql/releases/download/v8.8.2/elasticsearch-sql-8.8.2.0.zip

./bin/elasticsearch-plugin install https://.com/NLPchina/elasticsearch-sql/releases/download/v8.9.0/elasticsearch-sql-8.9.0.0.zip

./bin/elasticsearch-plugin install https://.com/NLPchina/elasticsearch-sql/releases/download/v8.9.1/elasticsearch-sql-8.9.1.0.zip

./bin/elasticsearch-plugin install https://.com/NLPchina/elasticsearch-sql/releases/download/v8.9.2/elasticsearch-sql-8.9.2.0.zip

./bin/elasticsearch-plugin install https://.com/NLPchina/elasticsearch-sql/releases/download/v8.10.0/elasticsearch-sql-8.10.0.0.zip

./bin/elasticsearch-plugin install https://.com/NLPchina/elasticsearch-sql/releases/download/v8.10.1/elasticsearch-sql-8.10.1.0.zip

./bin/elasticsearch-plugin install https://.com/NLPchina/elasticsearch-sql/releases/download/v8.10.2/elasticsearch-sql-8.10.2.0.zip

./bin/elasticsearch-plugin install https://.com/NLPchina/elasticsearch-sql/releases/download/v8.10.3/elasticsearch-sql-8.10.3.0.zip

./bin/elasticsearch-plugin install https://.com/NLPchina/elasticsearch-sql/releases/download/v8.10.4/elasticsearch-sql-8.10.4.0.zip

./bin/elasticsearch-plugin install https://.com/NLPchina/elasticsearch-sql/releases/download/v8.11.0/elasticsearch-sql-8.11.0.0.zip

./bin/elasticsearch-plugin install https://.com/NLPchina/elasticsearch-sql/releases/download/v8.11.1/elasticsearch-sql-8.11.1.0.zip

./bin/elasticsearch-plugin install https://.com/NLPchina/elasticsearch-sql/releases/download/v8.11.2/elasticsearch-sql-8.11.2.0.zip

./bin/elasticsearch-plugin install https://.com/NLPchina/elasticsearch-sql/releases/download/v8.11.3/elasticsearch-sql-8.11.3.0.zip

./bin/elasticsearch-plugin install https://.com/NLPchina/elasticsearch-sql/releases/download/v8.11.4/elasticsearch-sql-8.11.4.0.zip

./bin/elasticsearch-plugin install https://.com/NLPchina/elasticsearch-sql/releases/download/v8.12.0/elasticsearch-sql-8.12.0.0.zip

./bin/elasticsearch-plugin install https://.com/NLPchina/elasticsearch-sql/releases/download/v8.12.1/elasticsearch-sql-8.12.1.0.zip

./bin/elasticsearch-plugin install https://.com/NLPchina/elasticsearch-sql/releases/download/v8.12.2/elasticsearch-sql-8.12.2.0.zip

./bin/elasticsearch-plugin install https://.com/NLPchina/elasticsearch-sql/releases/download/v8.13.0/elasticsearch-sql-8.13.0.0.zip

./bin/elasticsearch-plugin install https://.com/NLPchina/elasticsearch-sql/releases/download/v8.13.1/elasticsearch-sql-8.13.1.0.zip

./bin/elasticsearch-plugin install https://.com/NLPchina/elasticsearch-sql/releases/download/v8.13.2/elasticsearch-sql-8.13.2.0.zip

./bin/elasticsearch-plugin install https://.com/NLPchina/elasticsearch-sql/releases/download/v8.13.3/elasticsearch-sql-8.13.3.0.zip

./bin/elasticsearch-plugin install https://.com/NLPchina/elasticsearch-sql/releases/download/v8.13.4/elasticsearch-sql-8.13.4.0.zip

./bin/elasticsearch-plugin install https://.com/NLPchina/elasticsearch-sql/releases/download/v8.14.0/elasticsearch-sql-8.14.0.0.zip

./bin/elasticsearch-plugin install https://.com/NLPchina/elasticsearch-sql/releases/download/v8.14.1/elasticsearch-sql-8.14.1.0.zip

./bin/elasticsearch-plugin install https://.com/NLPchina/elasticsearch-sql/releases/download/v8.14.2/elasticsearch-sql-8.14.2.0.zip

./bin/elasticsearch-plugin install https://.com/NLPchina/elasticsearch-sql/releases/download/v8.14.3/elasticsearch-sql-8.14.3.0.zip

./bin/elasticsearch-plugin install https://.com/NLPchina/elasticsearch-sql/releases/download/v8.15.0/elasticsearch-sql-8.15.0.0.zip

./bin/elasticsearch-plugin install https://.com/NLPchina/elasticsearch-sql/releases/download/v8.15.1/elasticsearch-sql-8.15.1.0.zip

./bin/elasticsearch-plugin install https://.com/NLPchina/elasticsearch-sql/releases/download/v8.15.2/elasticsearch-sql-8.15.2.0.zip

./bin/elasticsearch-plugin install https://.com/NLPchina/elasticsearch-sql/releases/download/v8.15.3/elasticsearch-sql-8.15.3.0.zip

./bin/elasticsearch-plugin install https://.com/NLPchina/elasticsearch-sql/releases/download/v8.15.4/elasticsearch-sql-8.15.4.0.zip

./bin/elasticsearch-plugin install https://.com/NLPchina/elasticsearch-sql/releases/download/v8.15.5/elasticsearch-sql-8.15.5.0.zip

./bin/elasticsearch-plugin install https://.com/NLPchina/elasticsearch-sql/releases/download/v8.16.0/elasticsearch-sql-8.16.0.0.zip

./bin/elasticsearch-plugin install https://.com/NLPchina/elasticsearch-sql/releases/download/v8.16.1/elasticsearch-sql-8.16.1.0.zip

./bin/elasticsearch-plugin install https://.com/NLPchina/elasticsearch-sql/releases/download/v8.16.2/elasticsearch-sql-8.16.2.0.zip

./bin/elasticsearch-plugin install https://.com/NLPchina/elasticsearch-sql/releases/download/v8.16.3/elasticsearch-sql-8.16.3.0.zip

./bin/elasticsearch-plugin install https://.com/NLPchina/elasticsearch-sql/releases/download/v8.17.0/elasticsearch-sql-8.17.0.0.zip

./bin/elasticsearch-plugin install https://.com/NLPchina/elasticsearch-sql/releases/download/v8.17.1/elasticsearch-sql-8.17.1.0.zip

./bin/elasticsearch-plugin install https://.com/NLPchina/elasticsearch-sql/releases/download/v8.17.2/elasticsearch-sql-8.17.2.0.zip

./bin/elasticsearch-plugin install https://.com/NLPchina/elasticsearch-sql/releases/download/v8.17.3/elasticsearch-sql-8.17.3.0.zip

./bin/elasticsearch-plugin install https://.com/NLPchina/elasticsearch-sql/releases/download/v8.17.4/elasticsearch-sql-8.17.4.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}.

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'

  • 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'

  • 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 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

elasticsearch sql

Resources

Readme

License

Apache-2.0 license
Activity
Custom properties

Stars

7k stars

Watchers

453 watching

Forks

1.5k forks
Report repository

Releases 270

elasticsearch 9.0.1 support Latest
May 9, 2025
+ 269 releases

Packages

No packages published

Contributors 32

+ 18 contributors

Languages