Java查询es用sql_lasticsearch-SQL：使用SQL查询Elasticsearch

最新推荐文章于 2024-03-28 09:59:00 发布
最新推荐文章于 2024-03-28 09:59:00 发布
阅读量667 收藏
点赞数
文章标签： Java查询es用sql
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/weixin_39772388/article/details/114812817
版权

IMPORTANT

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

DEPRECATED

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

Elasticsearch-SQL

build status

1.7.6 68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963312e78 2.0.0 68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963322e30 2.1.0 68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963322e31 2.1.1 68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963322e312e31 2.1.2 68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963322e312e32 2.2.0 68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963322e322e30

2.2.1 68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963322e322e31 2.3.0 68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963322e332e30 2.3.1 68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963322e332e31 2.3.2 68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963322e332e32 2.3.3 68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963322e332e33 2.3.4 68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963322e332e34

2.3.5 68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963322e332e35 2.4.0 68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963322e342e30 2.4.1 68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963322e342e31 2.4.2 68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963322e342e32 2.4.3 68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963322e342e33 2.4.4 68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963322e342e34

2.4.5 68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963322e342e35 2.4.6 68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963322e342e36 5.0.1 68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963352e302e31 5.1.1 68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963352e312e31 5.1.2 68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963352e312e32 5.2.0 68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963352e322e30

5.2.1 68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963352e322e31 5.2.2 68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963352e322e32 5.3.0 68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963352e332e30 5.3.1 68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963352e332e31 5.3.2 68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963352e332e32 5.3.3 68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963352e332e33

5.4.0 68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963352e342e30 5.4.1 68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963352e342e31 5.4.2 68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963352e342e32 5.4.3 68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963352e342e33 5.5.0 68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963352e352e30 5.5.1 68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963352e352e31

5.5.2 68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963352e352e32 5.5.3 68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963352e352e33 5.6.0 68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963352e362e30 5.6.1 68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963352e362e31 5.6.2 68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963352e362e32 5.6.3 68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963352e362e33

5.6.4 68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963352e362e34 5.6.5 68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963352e362e35 5.6.6 68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963352e362e36 5.6.7 68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963352e362e37 5.6.8 68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963352e362e38 5.6.9 68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963352e362e39

5.6.10 68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963352e362e3130 5.6.11 68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963352e362e3131 5.6.12 68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963352e362e3132 5.6.13 68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963352e362e3133 5.6.14 68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963352e362e3134 5.6.15 68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963352e362e3135

5.6.16 68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963352e362e3136 6.0.0 68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963362e302e30 6.0.1 68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963362e302e31 6.1.0 68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963362e312e30 6.1.1 68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963362e312e31 6.1.2 68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963362e312e32

6.1.3 68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963362e312e33 6.1.4 68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963362e312e34 6.2.0 68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963362e322e30 6.2.1 68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963362e322e31 6.2.2 68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963362e322e32 6.2.3 68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963362e322e33

6.2.4 68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963362e322e34 6.3.0 68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963362e332e30 6.3.1 68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963362e332e31 6.3.2 68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963362e332e32 6.4.0 68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963362e342e30 6.4.1 68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963362e342e31

6.4.2 68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963362e342e32 6.4.3 68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963362e342e33 6.5.0 68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963362e352e30 6.5.1 68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963362e352e31 6.5.2 68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963362e352e32 6.5.3 68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963362e352e33

6.5.4 68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963362e352e34 6.6.0 68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963362e362e30 6.6.1 68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963362e362e31 6.6.2 68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963362e362e32 6.7.0 68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963362e372e30 6.7.1 68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963362e372e31

6.7.2 68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963362e372e32 6.8.0 68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963362e382e30 6.8.1 68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963362e382e31 6.8.2 68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963362e382e32 6.8.3 68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963362e382e33 6.8.4 68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963362e382e34

6.8.5 68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963362e382e35 6.8.6 68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963362e382e36 7.0.0 68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963372e302e30 7.0.1 68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963372e302e31 7.1.0 68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963372e312e30 7.1.1 68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963372e312e31

7.2.0 68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963372e322e30 7.2.1 68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963372e322e31 7.3.0 68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963372e332e30 7.3.1 68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963372e332e31 7.3.2 68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963372e332e32 7.4.0 68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963372e342e30

7.4.1 68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963372e342e31 7.4.2 68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963372e342e32 7.5.0 68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963372e352e30 7.5.1 68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963372e352e31

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

Check out our wiki!

explain example

you can visite : http://essql.nlpcn.org/ , it is a sample example for explain

Web frontend overview

db23a84aa59d053355a2cf06bcf7a43f.png

SETUP

Install as plugin: Versions

elasticsearch version

latest version

remarks

branch

1.x

1.7.6

tested against elastic 1.7.6

elastic1.x

2.0.0

2.0.4

delete commands not supported

elastic2.0

2.1.0

2.1.0.2

delete commands not supported

elastic2.1

2.1.1

2.1.1.1

delete commands not supported

elastic2.1.1

2.1.2

2.1.2.0

delete commands not supported

elastic2.1.2

2.2.0

2.2.0.1

delete commands not supported

elastic2.2.0

2.2.1

2.2.1.0

delete commands not supported

elastic2.2.1

2.3.0

2.3.0.0

delete commands not supported

elastic2.3.0

2.3.1

2.3.1.1

delete commands not supported

elastic2.3.1

2.3.2

2.3.2.0

delete commands not supported

elastic2.3.2

2.3.3

2.3.3.0

delete commands not supported

elastic2.3.3

2.3.4

2.3.4.0

delete commands not supported

elastic2.3.4

2.3.5

2.3.5.0

delete commands not supported

elastic2.3.5

2.4.0

2.4.0.1

delete commands not supported

elastic2.4.0

2.4.1

2.4.1.0

delete commands not supported

elastic2.4.1

2.4.2

2.4.2.1

delete commands not supported

elastic2.4.2

2.4.3

2.4.3.0

delete commands not supported

elastic2.4.3

2.4.4

2.4.4.0

delete commands not supported

elastic2.4.4

2.4.5

2.4.5.0

delete commands not supported

elastic2.4.5

2.4.6

2.4.6.0

delete commands not supported

elastic2.4.6

5.0.1

5.0.1.0

delete commands not supported

elastic5.0.1

5.1.1

5.1.1.0

delete commands not supported

elastic5.1.1

5.1.2

5.1.2.0

delete commands not supported

elastic5.1.2

5.2.0

5.2.0.0

delete commands not supported

elastic5.2.0

5.2.1

5.2.1.0

delete commands not supported

elastic5.2.1

5.2.2

5.2.2.0

delete commands not supported

elastic5.2.2

5.3.0

5.3.0.0

delete commands not supported

elastic5.3.0

5.3.1

5.3.1.0

delete commands not supported

elastic5.3.1

5.3.2

5.3.2.0

delete commands not supported

elastic5.3.2

5.3.3

5.3.3.0

delete commands not supported

elastic5.3.3

5.4.0

5.4.0.0

delete commands not supported

elastic5.4.0

5.4.1

5.4.1.0

delete commands not supported

elastic5.4.1

5.4.2

5.4.2.0

delete commands not supported

elastic5.4.2

5.4.3

5.4.3.0

delete commands not supported

elastic5.4.3

5.5.0

5.5.0.1

delete commands not supported

elastic5.5.0

5.5.1

5.5.1.0

delete commands not supported

elastic5.5.1

5.5.2

5.5.2.0

delete commands not supported

elastic5.5.2

5.5.3

5.5.3.0

delete commands not supported

elastic5.5.3

5.6.0

5.6.0.0

delete commands not supported

elastic5.6.0

5.6.1

5.6.1.0

delete commands not supported

elastic5.6.1

5.6.2

5.6.2.0

delete commands not supported

elastic5.6.2

5.6.3

5.6.3.0

delete commands not supported

elastic5.6.3

5.6.4

5.6.4.0

delete commands not supported

elastic5.6.4

5.6.5

5.6.5.0

delete commands not supported

elastic5.6.5

5.6.6

5.6.6.0

elastic5.6.6

5.6.7

5.6.7.0

elastic5.6.7

5.6.8

5.6.8.0

elastic5.6.8

5.6.9

5.6.9.0

elastic5.6.9

5.6.10

5.6.10.0

elastic5.6.10

5.6.11

5.6.11.0

elastic5.6.11

5.6.12

5.6.12.0

elastic5.6.12

5.6.13

5.6.13.0

elastic5.6.13

5.6.14

5.6.14.0

elastic5.6.14

5.6.15

5.6.15.0

elastic5.6.15

5.6.16

5.6.16.0

elastic5.6.16

6.0.0

6.0.0.0

elastic6.0.0

6.0.1

6.0.1.0

elastic6.0.1

6.1.0

6.1.0.0

elastic6.1.0

6.1.1

6.1.1.0

elastic6.1.1

6.1.2

6.1.2.0

elastic6.1.2

6.1.3

6.1.3.0

elastic6.1.3

6.1.4

6.1.4.0

elastic6.1.4

6.2.0

6.2.0.0

elastic6.2.0

6.2.1

6.2.1.0

elastic6.2.1

6.2.2

6.2.2.0

elastic6.2.2

6.2.3

6.2.3.0

elastic6.2.3

6.2.4

6.2.4.0

elastic6.2.4

6.3.0

6.3.0.0

elastic6.3.0

6.3.1

6.3.1.0

elastic6.3.1

6.3.2

6.3.2.0

elastic6.3.2

6.4.0

6.4.0.0

elastic6.4.0

6.4.1

6.4.1.0

elastic6.4.1

6.4.2

6.4.2.0

elastic6.4.2

6.4.3

6.4.3.0

elastic6.4.3

6.5.0

6.5.0.0

elastic6.5.0

6.5.1

6.5.1.0

elastic6.5.1

6.5.2

6.5.2.0

elastic6.5.2

6.5.3

6.5.3.0

elastic6.5.3

6.5.4

6.5.4.0

elastic6.5.4

6.6.0

6.6.0.0

elastic6.6.0

6.6.1

6.6.1.0

elastic6.6.1

6.6.2

6.6.2.0

elastic6.6.2

6.7.0

6.7.0.0

elastic6.7.0

6.7.1

6.7.1.0

elastic6.7.1

6.7.2

6.7.2.0

elastic6.7.2

6.8.0

6.8.0.0

elastic6.8.0

6.8.1

6.8.1.0

elastic6.8.1

6.8.2

6.8.2.0

elastic6.8.2

6.8.3

6.8.3.0

elastic6.8.3

6.8.4

6.8.4.0

elastic6.8.4

6.8.5

6.8.5.0

elastic6.8.5

6.8.6

6.8.6.0

elastic6.8.6

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

Elasticsearch 1.x

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

Elasticsearch 2.0.0

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

Elasticsearch 2.1.0

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

Elasticsearch 2.1.1

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

Elasticsearch 2.1.2

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

Elasticsearch 2.2.0

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

Elasticsearch 2.2.1

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

Elasticsearch 2.3.0

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

Elasticsearch 2.3.1

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

Elasticsearch 2.3.2

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

Elasticsearch 2.3.3

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

Elasticsearch 2.3.4

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

Elasticsearch 2.3.5

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

Elasticsearch 2.4.0

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

Elasticsearch 2.4.1

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

Elasticsearch 2.4.2

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

Elasticsearch 2.4.3

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

Elasticsearch 2.4.4

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

Elasticsearch 2.4.5

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

Elasticsearch 2.4.6

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

Elasticsearch 5.0.1

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

Elasticsearch 5.1.1

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

Elasticsearch 5.1.2

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

Elasticsearch 5.2.0

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

Elasticsearch 5.2.1

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

Elasticsearch 5.2.2

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

Elasticsearch 5.3.0

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

Elasticsearch 5.3.1

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

Elasticsearch 5.3.2

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

Elasticsearch 5.3.3

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

Elasticsearch 5.4.0

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

Elasticsearch 5.4.1

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

Elasticsearch 5.4.2

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

Elasticsearch 5.4.3

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

Elasticsearch 5.5.0

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

Elasticsearch 5.5.1

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

Elasticsearch 5.5.2

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

Elasticsearch 5.5.3

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

Elasticsearch 5.6.0

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

Elasticsearch 5.6.1

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

Elasticsearch 5.6.2

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

Elasticsearch 5.6.3

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

Elasticsearch 5.6.4

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

Elasticsearch 5.6.5

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

Elasticsearch 5.6.6

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

Elasticsearch 5.6.7

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

Elasticsearch 5.6.8

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

Elasticsearch 5.6.9

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

Elasticsearch 5.6.10

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

Elasticsearch 5.6.11

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

Elasticsearch 5.6.12

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

Elasticsearch 5.6.13

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

Elasticsearch 5.6.14

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

Elasticsearch 5.6.15

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

Elasticsearch 5.6.16

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

Elasticsearch 6.0.0

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

Elasticsearch 6.0.1

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

Elasticsearch 6.1.0

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

Elasticsearch 6.1.1

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

Elasticsearch 6.1.2

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

Elasticsearch 6.1.3

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

Elasticsearch 6.1.4

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

Elasticsearch 6.2.0

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

Elasticsearch 6.2.1

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

Elasticsearch 6.2.2

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

Elasticsearch 6.2.3

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

Elasticsearch 6.2.4

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

Elasticsearch 6.3.0

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

Elasticsearch 6.3.1

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

Elasticsearch 6.3.2

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

Elasticsearch 6.4.0

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

Elasticsearch 6.4.1

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

Elasticsearch 6.4.2

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

Elasticsearch 6.4.3

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

Elasticsearch 6.5.0

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

Elasticsearch 6.5.1

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

Elasticsearch 6.5.2

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

Elasticsearch 6.5.3

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

Elasticsearch 6.5.4

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

Elasticsearch 6.6.0

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

Elasticsearch 6.6.1

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

Elasticsearch 6.6.2

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

Elasticsearch 6.7.0

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

Elasticsearch 6.7.1

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

Elasticsearch 6.7.2

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

Elasticsearch 6.8.0

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

Elasticsearch 6.8.1

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

Elasticsearch 6.8.2

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

Elasticsearch 6.8.3

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

Elasticsearch 6.8.4

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

Elasticsearch 6.8.5

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

Elasticsearch 6.8.6

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

Elasticsearch 7.0.0

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

Elasticsearch 7.0.1

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

Elasticsearch 7.1.0

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

Elasticsearch 7.1.1

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

Elasticsearch 7.2.0

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

Elasticsearch 7.2.1

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

Elasticsearch 7.3.0

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

Elasticsearch 7.3.1

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

Elasticsearch 7.3.2

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

Elasticsearch 7.4.0

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

Elasticsearch 7.4.1

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

Elasticsearch 7.4.2

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

Elasticsearch 7.5.0

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

Elasticsearch 7.5.1

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

After doing this, you need to restart the Elasticsearch server. Otherwise you may get errors like Invalid index name [sql], must not start with '']; ","status":400}.

Basic Usage

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

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

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

cd site-server

npm install express --save

node node-server.js

Simple query

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

Explain SQL to elasticsearch query DSL

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

SQL Usage

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

Aggregation select COUNT(*),SUM(age),MIN(age) as m, MAX(age),AVG(age)

FROM bank GROUP BY gender ORDER BY SUM(age), m DESC

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

Beyond SQL

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

Aggregations

range age group 20-25,25-30,30-35,35-40 SELECT COUNT(age) FROM bank GROUP BY range(age, 20,25,30,35,40)

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

range date group by your config SELECT online FROM online GROUP BY date_range(field='insert_time','format'='yyyy-MM-dd' ,'2014-08-18','2014-08-17','now-8d','now-7d','now-6d','now')

ES Geographic SELECT * FROM locations WHERE GEO_BOUNDING_BOX(fieldname,100.0,1.0,101,0.0)

Select type SELECT * FROM indexName/type

SQL Features

SQL Select

SQL Delete

SQL Where

can use "case when" in where clause

SQL Order By

can use "case when" in order by clause

SQL Group By

SQL AND & OR

SQL Like

SQL COUNT distinct

SQL In

SQL Between

SQL Aliases

SQL Not Null

SQL(ES) Date

SQL avg()

SQL count()

SQL last()

SQL max()

SQL min()

SQL sum()

SQL Nulls

SQL isnull()

SQL now()

SQL floor

SQL split

SQL trim

SQL log

SQL log10

SQL substring

SQL round

eg: round(10.135, 2) --> 10.14

SQL sqrt

SQL concat_ws

SQL union and minus

SQL case when

can use "in"、"not in" judge in case when clause

can execute simple calculation in case when clause, eg : case when 1 = 1 then 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

JDBC Support (Experimental feature)

Check details : JDBC Support

Beyond sql features

ES TopHits

ES MISSING

ES STATS

ES GEO_INTERSECTS

ES GEO_BOUNDING_BOX

ES GEO_DISTANCE

ES GEOHASH_GRID aggregation

weixin_39772388
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
Java查询es用sql_Elasticsearch 的sql查询Java工具类
weixin_31935793的博客
02-27 2235
package org.vander.es.utils;import java.lang.reflect.Field;import java.util.ArrayList;import java.util.Date;import java.util.HashMap;import java.util.List;import java.util.Map;import org.slf4j.Logger;...
elasticsearch-sql2：基于Java Rest高级客户端的Elasticsearch-Sql组件【已淘汰】
01-28
基于Elasticsearch的Java Rest高级客户端的elasticsearch-sql查询组件【STALLED】 请移至 说明 这个版本的elasticsearch-sql是基于阿里巴巴的Druid中的SqlParser组件，由于elasticsearch许多功能并不适合使用sql表达式，导致实现elasticsearch一些高级功能的时候越来越受到SqlParser的限制，所以这个版本的elasticsearch-sql提高交流，推进另启一个项目 :backhand_index_pointing_right: elasticsearch ，使用Antlr4来解析sql生成dsl，使elasticsql完全可控，可以提供多语言的支持，尽请期待！ 目录 使用文档 依赖 < dependency> < groupId>io.github.iamazy.elasticsearch.dsl</ groupId> < artifactId>elasticsearch-sql</ artifactId> < version>${isql-version}</ v
elasticsearch-sql sql查询 结合java代码查询
王百林的博客
08-27 5693
1.本例子是使用elasticearch-sql插件的jar包结合代码来使用； 2.使用的es版本为5.6.8,elasticsearch-sql 的版本在maven官网库找不到,暂且使用5.2.1.0,可以到git 上去下去,然后自己编译https://github.com/NLPchina/elasticsearch-sql/tree/elastic5.6.8； 3.在pom.xml文件中...
ElasticSearch 7.3 实战：ES7.X SQL新特性解析及使用Java api实现sql功能
最新发布
qq_33240556的博客
03-28 417
请注意，实际的API用法可能会根据Elasticsearch官方发布的具体版本有所不同，请查阅Elasticsearch 7.3的相关文档以获取最新和详细的API使用方法。同时，对于SQL新特性的完整列表和具体用法，建议直接查阅Elasticsearch官方文档。在Elasticsearch 7.x版本中，对SQL的支持得到了增强，使得用户可以直接使用SQL查询语法来操作Elasticsearch中的数据。
Elasticsearch： ES使用sql语句进行查询
热门推荐
Daisy的博客
08-05 1万+
//format 定义返回的数据类型 适合php的推荐使用json ，除此之外还可以选择 txt,csv,yaml,cbor,smile等使用sql语句查询有一个弊端 就是开始定义某列数据的类型 后期存储时 存入了错误的数据类型 存储时成功的 但是使用sql语句查询会报错，所有最有效的ES查询方法还是使用原生的 当我们不确定有哪些SQL函数可以直接使用时 ，可以在 /_xpack/sql?format=json 接口使用query='show functions'，会列举出支持的SQL函数； /*..
【java学习】ES（Elasticsearch）语法学习
午后阳光
10-01 2382
查看es集群状态 结果分析->(1)v表示带表头输出h=index 表示输出index列v"#查看节点的详细信息 结果分析->(9)v"#查看集群健康信息 结果分析->(2)pretty#显示集群系统信息，包括CPU JVM、节点、分片等等#获取集群堆积的任务#查询所有索引,pretty:格式化v&pretty'#查询第一个索引的未分配原因。结果分析->(3)#查询指定索引索引名未分配的原因。结果分析->(4)pretty -d'
lasticsearch-SQL使用SQL查询Elasticsearch
08-07
Elasticsearch-SQL是针对Elasticsearch开发的一个插件，它允许用户通过SQL语句来查询Elasticsearch中的数据，极大地降低了使用Elasticsearch的门槛，特别是对于熟悉SQL语法的开发者来说，这是一个非常友好的特性。...
elasticsearch-sql：使用SQL查询Elasticsearch
01-28
请注意，该项目不再处于活动开发中，已弃用，请使用AWS支持并在Apache 2下获得许可的正式版和 。 弹性搜索 建置状态 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 ...
elasticsearch-sql:使用SQL查询Elasticsearch
05-10
请注意，该项目不再处于活动开发中，已弃用，请使用AWS支持并在Apache 2下获得许可的正式版和 。 弹性搜索 建置状态 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 ...
elasticsearch-sql：使用antlr4将sql解析为elasticsearch dsl
01-30
弹性搜索 建造状态 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...用antlr4重写elasticsearch ，支持 变更日志 Maven < groupId>io.github.iamazy.elasticsearch.ds
elasticsearch-sql插件(es2.2.0版本)
02-04
elasticsearch-sql插件安装包
elasticsearch-sql插件1.x
12-27
elasticsearch-sql插件,这个是支持1.x版本的es,直接解压到plugins,然后重启一下es即可,访问方式如head插件: http://127.0.0.1:9200/_plugin/sql/
elasticsearch-sql插件2.0
12-27
elasticsearch-sql插件,这个是支持2.0版本的es,直接解压到plugins,然后重启一下es即可,访问方式如head插件: http://127.0.0.1:9200/_plugin/sql/
java客户端实现SQL查询ES
qq_41884976的博客
02-08 4021
java客户端实现SQL查询ES 背景： ES 从6.3版本之后开始支持SQL 查询，通过kibana等客户端，可以像查询MySql一样， 查询ES的index，并且支持一次可以查询多个索引，但其原理还是将SQL转成DSl来查询，如下在kibana上面利用SQL查询ES // 通过该SQL查询 POST _xpack/sql?format=txt { "query":"select * from testIndex" } 将该SQL转换成DSL POST /_sql/translate { "que
elasticsearch-sql插件安装使用
weixin_33841722的博客
10-20 187
为什么80%的码农都做不了架构师？>>> ...
ES报“Invalid index name [indexTest001], must be lowercase“
qq_34552189的博客
11-30 4589
ElasticSearch创建索引报错一、创建ES索引 一、创建ES索引 在ES的组件kibana中创建所以 PUT /indexTest005 { "settings" : { "number_of_shards" : 1, "number_of_replicas" : 0 } } 创建时报如下内容： { "error": { "root_cause": [ { "type": "invalid_index_name_e
Elasticsearch SQL
qq_36594703的博客
04-25 1246
一般使用的时候，会使用Query DSL来查询数据，从版本以后，已经支持SQL查询了。是一个X-Pack组件，它允许针对实时执行类似SQL的 查询。无论使用REST接口，命令行还是JDBC，任何客户端都可以使用SQL对中的数据进行原生搜索和聚合数据。可以将看作是一种翻译器，它可以将SQL翻译成Query DSL。
ElasticSearch7.3学习(三十)----ES7.X SQL新特性解析及使用Java api实现sql功能
qq_45562973的博客
06-07 475
创建索引及映射建立价格、颜色、品牌、售卖日期 四个字段 插入数据 1.2 简单示例 返回类似于数据库的界面 2.2 客户端启动 elasticsearch-sql-cli.bat双击执行，在控制台输入即可查询到ES中所有的索引这种方式在下面会介绍上面的ES语句中可以看到，这个是控制返回结果为txt格式，当然也支持其他的格式。如下图所示可以简单的看下其他的格式，例如说,以tab做分割的格式例如说既然支持sql语句，那么底层是怎么运行的呢？ 实际上还是转换成query语句来执行，我们可以用来查看一下也可以与
elasticsearch（es-sql）的安装和使用
weixin_38411472的博客
09-13 6788
elasticsearch的搭建和插件使用 （如果搭建的是6.2.4版本的可以去这个地址去下载，有es的安装包以及es-sql、kibana、nodejs、sql-query等： https://download.csdn.net/download/weixin_38411472/10664023） 一．elasticsearch的安装文档： 1.安装java（因为es底层是Java写...
Java查询es用sql_Elasticsearch-sql 用SQL查询Elasticsearch
06-08
是的，您可以使用Elasticsearch-sql来使用SQL语句查询Elasticsearch。它提供了一种更直观和熟悉的方式来查询和分析数据，尤其是对于那些熟悉SQL的用户。 使用Elasticsearch-sql，您可以使用SELECT语句从Elastic...

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值