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

系统管理员 2022-11-09 11:30 381阅读 0赞

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

[68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963312e78]: https://camo.githubusercontent.com/c35e8f0237f07d757e3e1a0d4d8eb17a2122fc86/68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963312e78
[68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963322e30]: https://camo.githubusercontent.com/014f46c83ce7e3551c1e04e4619ed9d72ff83d89/68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963322e30
[68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963322e31]: https://camo.githubusercontent.com/3590879ad397cb0d35a6654a901ca6061e7caa59/68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963322e31
[68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963322e312e31]: https://camo.githubusercontent.com/ec6d9b05ad53ac1d659d3431e2c559a6078663d4/68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963322e312e31
[68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963322e312e32]: https://camo.githubusercontent.com/3e30a1926a17a856fd363f0154f5cda2894f555e/68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963322e312e32
[68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963322e322e30]: /images/20221023/7219581fb05a4cc599ee7e0f841a4690.png
[68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963322e322e31]: https://camo.githubusercontent.com/e320381d7511301896abfcc7f1357f1b0f4bce74/68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963322e322e31
[68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963322e332e30]: https://camo.githubusercontent.com/782f83cac6e85d7762c19cd644112e46d8f3379c/68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963322e332e30
[68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963322e332e31]: https://camo.githubusercontent.com/6642396d3bb99e4d9734a417aef28a7be889a6c2/68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963322e332e31
[68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963322e332e32]: https://camo.githubusercontent.com/3dd83185d3d641c34132e60fd9c503f9b62ca7ed/68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963322e332e32
[68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963322e332e33]: https://camo.githubusercontent.com/f7a8d987819a74625573ebf29afaf584ff9131ce/68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963322e332e33
[68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963322e332e34]: /images/20221023/02b218bb4a0a448f8175bb1b80dafbd8.png
[68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963322e332e35]: https://camo.githubusercontent.com/92a0944eb029588c932eed7bfe266cfd931ce059/68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963322e332e35
[68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963322e342e30]: https://camo.githubusercontent.com/5af979b8d6cdd59d9a20d268e0f9cff6d9c4b0e7/68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963322e342e30
[68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963322e342e31]: https://camo.githubusercontent.com/0332407fbe3adc7e65f9eb01ce3efacc2b9aa8df/68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963322e342e31
[68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963322e342e32]: https://camo.githubusercontent.com/ea914d00fb2a3e31797d25f3eb5cbb63f7b4f6d0/68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963322e342e32
[68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963322e342e33]: https://camo.githubusercontent.com/1d8ebc150220bea1d487277b55eb86a7fe8dd3be/68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963322e342e33
[68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963322e342e34]: /images/20221023/33648805f03d41dc8413552d89287b85.png
[68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963322e342e35]: https://camo.githubusercontent.com/1db19afe3fcb0a5c362c037c8442ce42f864f0a3/68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963322e342e35
[68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963322e342e36]: https://camo.githubusercontent.com/3e0087a1506d66b9838c396dec8990e645b03cda/68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963322e342e36
[68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963352e302e31]: https://camo.githubusercontent.com/d83edb25c88f7f20cf8fbb11defee97a6501b5ae/68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963352e302e31
[68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963352e312e31]: https://camo.githubusercontent.com/2e3c6d457f63ca95721484f80f16d231dde93f56/68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963352e312e31
[68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963352e312e32]: https://camo.githubusercontent.com/6d5fd0db93d03033223fea1216c20eaf50d4c50b/68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963352e312e32
[68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963352e322e30]: /images/20221023/62f66f94072c4dbfad12f9ff44aa29c1.png
[68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963352e322e31]: https://camo.githubusercontent.com/ae93da2e70c31c0b82df94075bfe10328258a63b/68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963352e322e31
[68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963352e322e32]: https://camo.githubusercontent.com/dfb64f3d24f7cea168821e9f1df06dfab4911b9f/68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963352e322e32
[68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963352e332e30]: https://camo.githubusercontent.com/9db0c6f2fa7d9688937adceac09e1973e69ccbd5/68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963352e332e30
[68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963352e332e31]: https://camo.githubusercontent.com/ebd15d8b8caa312f2884232ab61a790a1008fb91/68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963352e332e31
[68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963352e332e32]: https://camo.githubusercontent.com/3f886d3dccbdb6f59e677c72ca1dcd238f7bced3/68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963352e332e32
[68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963352e332e33]: /images/20221023/4bec182daef544a6ab743a9d8ee43a60.png
[68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963352e342e30]: https://camo.githubusercontent.com/914d4c5221f052ce589682f8b171e554e952a3c7/68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963352e342e30
[68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963352e342e31]: https://camo.githubusercontent.com/9641bbe1c3f659a11d02b70e06d32d541cef7f4e/68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963352e342e31
[68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963352e342e32]: https://camo.githubusercontent.com/f003b33ade8768e7c540ea2baddee0928f3f8ce0/68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963352e342e32
[68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963352e342e33]: https://camo.githubusercontent.com/a04ccc38ea2d9952e3bf05631a55ee998a74eb2f/68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963352e342e33
[68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963352e352e30]: https://camo.githubusercontent.com/b063b645a6f2e289232aafde7051db54e2313db2/68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963352e352e30
[68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963352e352e31]: /images/20221023/042b60db70d6445896965a543eb5953f.png
[68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963352e352e32]: https://camo.githubusercontent.com/8d10bbcddc501bf1e77acc95cdc40b762e04d0ec/68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963352e352e32
[68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963352e352e33]: https://camo.githubusercontent.com/49d23f2dab7f37f6993bfd4b8ceae5e5d9e8f53a/68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963352e352e33
[68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963352e362e30]: https://camo.githubusercontent.com/ff81a3ca28596218ab8b139f4c606354262a1da7/68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963352e362e30
[68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963352e362e31]: https://camo.githubusercontent.com/e635b526b3d932863b7d3c32a8b0d3a2479222f1/68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963352e362e31
[68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963352e362e32]: https://camo.githubusercontent.com/64852826ced915be4669c6fde82364459660b3a0/68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963352e362e32
[68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963352e362e33]: /images/20221023/0acce6651d0346c8a369ba7ec783bef4.png
[68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963352e362e34]: https://camo.githubusercontent.com/6c294a6b20fd0ee08027cc9e029c5977ccb2cd15/68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963352e362e34
[68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963352e362e35]: https://camo.githubusercontent.com/e2925f8485968192f745796fa315f28f6cf96953/68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963352e362e35
[68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963352e362e36]: https://camo.githubusercontent.com/3baa4598ef3ba7bb6a071bc052655c42455715ea/68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963352e362e36
[68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963352e362e37]: https://camo.githubusercontent.com/beaf08fd1675d2fcac92e1d7836745e563f1fd86/68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963352e362e37
[68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963352e362e38]: https://camo.githubusercontent.com/7365ea35fe81c45f0be1a88b36549501e4a13681/68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963352e362e38
[68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963352e362e39]: /images/20221023/39194616d2c24d6e846f37b2a082abf3.png
[68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963352e362e3130]: https://camo.githubusercontent.com/0484dded0d39e350176d5d3b1e49410b0c8f7731/68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963352e362e3130
[68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963352e362e3131]: https://camo.githubusercontent.com/31dfa90e5a4a1868bef8d194475a120918692aeb/68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963352e362e3131
[68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963352e362e3132]: https://camo.githubusercontent.com/cb2639a4aeada0780ff8934411c83ed6fdd78190/68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963352e362e3132
[68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963352e362e3133]: https://camo.githubusercontent.com/eba3d413f93d093ad7c1086fbfca252674e2a73d/68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963352e362e3133
[68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963352e362e3134]: https://camo.githubusercontent.com/31574ed5bd314d27d4fe3e742e9870c82fb351ce/68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963352e362e3134
[68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963352e362e3135]: /images/20221023/71d24f16518f4209ad0bc6233d636ecf.png
[68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963352e362e3136]: https://camo.githubusercontent.com/1c441a274a23ebbfe7292240247f1b9cc3211eee/68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963352e362e3136
[68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963362e302e30]: https://camo.githubusercontent.com/6b4e21d5ad25451f6eb8d6f46b90d69750339595/68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963362e302e30
[68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963362e302e31]: https://camo.githubusercontent.com/6b8937f76f77d8b3ae9d5145f0a0d1f9bf080fa7/68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963362e302e31
[68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963362e312e30]: https://camo.githubusercontent.com/a7dad176dbae22e0af118717e2c3b76d83253995/68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963362e312e30
[68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963362e312e31]: https://camo.githubusercontent.com/3f1553497771c7d38c2c52ac8d77e8e755633e26/68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963362e312e31
[68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963362e312e32]: /images/20221023/8e5a47a9843f4dd3857855c9430ae3b6.png
[68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963362e312e33]: https://camo.githubusercontent.com/ef10c2c5d5fa0c6ad9e7c58cbbec53c69d245493/68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963362e312e33
[68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963362e312e34]: https://camo.githubusercontent.com/b88f35618f9b2bfc2b1a03fc44703bd26feaabae/68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963362e312e34
[68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963362e322e30]: https://camo.githubusercontent.com/110ab563607dfe84027412039c25114762d4cfc0/68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963362e322e30
[68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963362e322e31]: https://camo.githubusercontent.com/3dc9c30721ab8ac63b1d44c1909764da555d3a5c/68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963362e322e31
[68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963362e322e32]: https://camo.githubusercontent.com/8a849ef4c90af01987e936dad4a1bd3d6f7a632e/68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963362e322e32
[68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963362e322e33]: /images/20221023/8cb0d2bf9e8d44aeb0c70e9459c19fc4.png
[68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963362e322e34]: https://camo.githubusercontent.com/eec0dfa7308f0f7e0804bea90f543a766a0eefda/68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963362e322e34
[68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963362e332e30]: https://camo.githubusercontent.com/ef81fd7c29d7dc0f001876d94c14a53946c7f1a9/68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963362e332e30
[68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963362e332e31]: https://camo.githubusercontent.com/17413e163451272f228e444ec17ca3c06be2ccc9/68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963362e332e31
[68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963362e332e32]: https://camo.githubusercontent.com/b581596ee8bed7f487d453f6d5475f1cc79ccc77/68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963362e332e32
[68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963362e342e30]: https://camo.githubusercontent.com/980dbf806bea02ea7464e6ed923d18e557e77ebb/68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963362e342e30
[68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963362e342e31]: /images/20221023/e0fd27e17d574626aad430d1e11209db.png
[68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963362e342e32]: https://camo.githubusercontent.com/f6cbbfbdc425ddf2236e759ea2b862e8ef4e9189/68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963362e342e32
[68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963362e342e33]: https://camo.githubusercontent.com/1cb480e3d010e39c369771af7fd51d5e851183f9/68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963362e342e33
[68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963362e352e30]: https://camo.githubusercontent.com/ba1166f04ca735cca6e8e842a8b80ac46fb088cc/68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963362e352e30
[68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963362e352e31]: https://camo.githubusercontent.com/01a35ce4560e1a1ee2f2b10edab96e0b7e0f20d1/68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963362e352e31
[68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963362e352e32]: https://camo.githubusercontent.com/67d7847998d55f794cfbc12cb4219b7702a0f581/68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963362e352e32
[68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963362e352e33]: /images/20221023/36558ae2c4f84a5f961a07a3d11a49c3.png
[68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963362e352e34]: https://camo.githubusercontent.com/e949b7984e39327b0c00d82056838dced638824d/68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963362e352e34
[68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963362e362e30]: https://camo.githubusercontent.com/de63618fae08e2e9092c1450b3627f775889f4bc/68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963362e362e30
[68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963362e362e31]: https://camo.githubusercontent.com/956c2a2d26ffae2ca2cbcc3e6ce9dfc381d2f61a/68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963362e362e31
[68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963362e362e32]: https://camo.githubusercontent.com/ecf132f33c19d128945e302f9ad7830a38b4b79c/68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963362e362e32
[68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963362e372e30]: https://camo.githubusercontent.com/66f7d0c5ab740c76758a6ca9e71db038fdf5ccb0/68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963362e372e30
[68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963362e372e31]: /images/20221023/2b027b50d37647aa9fb28083a04b7b11.png
[68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963362e372e32]: https://camo.githubusercontent.com/99958e8474bbde99e6ff4b81ea33fa8888ac4630/68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963362e372e32
[68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963362e382e30]: https://camo.githubusercontent.com/9be400551a388d9df61a4dfd0e6e2970e00d76c2/68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963362e382e30
[68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963362e382e31]: https://camo.githubusercontent.com/7bc6f5740116e5c20b6294ab9d359507343b6eb8/68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963362e382e31
[68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963362e382e32]: https://camo.githubusercontent.com/7bdea266f821f50457be3103cfa6cabbb16e7804/68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963362e382e32
[68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963362e382e33]: https://camo.githubusercontent.com/5c8e503a6e20553cb7004b5e785664c612e1e4fc/68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963362e382e33
[68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963362e382e34]: /images/20221023/9154e860bd20402283f82837487dc6ee.png
[68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963362e382e35]: https://camo.githubusercontent.com/f39f7be5bd9829cb0ea612ed8435d403652c1e90/68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963362e382e35
[68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963362e382e36]: https://camo.githubusercontent.com/906bae61f6ae6aef0b0e81b6d2b60f552cb58d52/68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963362e382e36
[68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963372e302e30]: https://camo.githubusercontent.com/a6aa1f4c7e4ff9c81014fee094bc4db777e2ed06/68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963372e302e30
[68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963372e302e31]: https://camo.githubusercontent.com/5a67085eeea8e0976c80bf5da4b19b1f6e28166d/68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963372e302e31
[68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963372e312e30]: https://camo.githubusercontent.com/06e49a846fd42d3f621a9c78370842605f1e1509/68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963372e312e30
[68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963372e312e31]: /images/20221023/e8a7a91d3c494847bbf2575deb50e492.png
[68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963372e322e30]: https://camo.githubusercontent.com/958bfc4e0eac4a9a3965fa607d04ce06c6a47540/68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963372e322e30
[68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963372e322e31]: https://camo.githubusercontent.com/cb170cf43ec9a19f78d279e93194e5811128f2da/68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963372e322e31
[68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963372e332e30]: https://camo.githubusercontent.com/0fc5e9375c97c054f81453dc2bb9e4c9c9f74ae9/68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963372e332e30
[68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963372e332e31]: https://camo.githubusercontent.com/060e0c4058492a41707e47a468251e16cbd49174/68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963372e332e31
[68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963372e332e32]: https://camo.githubusercontent.com/940b6e438033a96a66e2ed62dadb832379bd8da4/68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963372e332e32
[68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963372e342e30]: /images/20221023/5000cd7dca2f4bc88d0d1be369e42a3e.png
[68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963372e342e31]: https://camo.githubusercontent.com/6fabd9f4a1077665865f4a3ecf8b38462942e08a/68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963372e342e31
[68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963372e342e32]: https://camo.githubusercontent.com/0b5b3d4d87fe68362a7f1a16ac55eb82a6a409cb/68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963372e342e32
[68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963372e352e30]: https://camo.githubusercontent.com/feda5481abfe683cd5a54ae0a8f4f5e3753bff25/68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963372e352e30
[68747470733a2f2f7472617669732d63692e6f72672f4e4c506368696e612f656c61737469637365617263682d73716c2e7376673f6272616e63683d656c6173746963372e352e31]: /images/20221023/fca43a18c0ea4f34afcecff8e2bd6a64.png
[db23a84aa59d053355a2cf06bcf7a43f.png]: /images/20221023/0be40bdc790f46bb8d70391607b1603f.png