代码拉取完成，页面将自动刷新
1.7.6 
2.0.0 
2.1.0 
2.1.1 
2.1.2 
2.2.0 
2.2.1 
2.3.0 
2.3.1 
2.3.2 
2.3.3 
2.3.4 
2.3.5 
2.4.0 
2.4.1 
2.4.2 
2.4.3 
2.4.4 
2.4.5 
2.4.6 
5.0.1 
5.1.1 
5.1.2 
5.2.0 
5.2.1 
5.2.2 
5.3.0 
5.3.1 
5.3.2 
5.3.3 
5.4.0 
5.4.1 
5.4.2 
5.4.3 
5.5.0 
5.5.1 
5.5.2 
5.5.3 
5.6.0 
5.6.1 
5.6.2 
5.6.3 
5.6.4 
5.6.5 
5.6.6 
5.6.7 
5.6.8 
5.6.9 
5.6.10 
5.6.11 
5.6.12 
6.0.0 
6.0.1 
6.1.0 
6.1.1 
6.1.2 
6.1.3 
6.1.4 
6.2.0 
6.2.1 
6.2.2 
6.2.3 
6.2.4 
6.3.0 
6.3.1 
6.3.2 
6.4.0 
6.4.1 
6.4.2 
Query elasticsearch using familiar SQL syntax. You can also use ES functions in SQL.
Check out our wiki!
you can visite : http://essql.nlpcn.org/ , it is a sample example for explain
| 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 | |
| 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 |
./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/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
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, download and extract site.
Then start the web front-end like this:
cd site-server
npm install express --save
node node-server.js
http://localhost:9200/_sql?sql=select * from indexName limit 10
http://localhost:9200/_sql/_explain?sql=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
Check details : JDBC Support
此处可能存在不合适展示的内容，页面不予展示。您可通过相关编辑功能自查并修改。
如您确认内容无涉及 不当用语 / 纯广告导流 / 暴力 / 低俗色情 / 侵权 / 盗版 / 虚假 / 无价值内容或违法国家有关法律法规的内容，可点击提交进行申诉，我们将尽快为您处理。
马建仓 AI 助手