hub / github.com/NLPchina/elasticsearch-sql
github.com/NLPchina/elasticsearch-sql @v9.3.4 sqlite
2,575 symbols
9,549 edges
245 files
246 documented · 10%
README
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
6.8.23 
7.17.28 
8.19.11 
9.3.0 
master 
Query elasticsearch using familiar SQL syntax. You can also use ES functions in SQL.
Check out our wiki!
explain example
Web frontend overview
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 | |
| 6.8.7 | 6.8.7.0 | elastic6.8.7 | |
| 6.8.8 | 6.8.8.0 | elastic6.8.8 | |
| 6.8.9 | 6.8.9.0 | elastic6.8.9 | |
| 6.8.10 | 6.8.10.0 | elastic6.8.10 | |
| 6.8.11 | 6.8.11.0 | elastic6.8.11 | |
| 6.8.12 | 6.8.12.0 | elastic6.8.12 | |
| 6.8.13 | 6.8.13.0 | elastic6.8.13 | |
| 6.8.14 | 6.8.14.0 | elastic6.8.14 | |
| 6.8.15 | 6.8.15.0 | elastic6.8.15 | |
| 6.8.16 | 6.8.16.0 | elastic6.8.16 | |
| 6.8.17 | 6.8.17.0 | elastic6.8.17 | |
| 6.8.18 | 6.8.18.0 | elastic6.8.18 | |
| 6.8.19 | 6.8.19.0 | elastic6.8.19 | |
| 6.8.20 | 6.8.20.0 | elastic6.8.20 | |
| 6.8.21 | 6.8.21.0 | elastic6.8.21 | |
| 6.8.22 | 6.8.22.0 | elastic6.8.22 | |
| 6.8.23 | 6.8.23.0 | elastic6.8.23 | |
| 7.0.0 | 7.0.0.0 | elastic7.0.0 | |
| 7.0.1 | 7.0.1.0 | elastic7.0.1 | |
| 7.1.0 | 7.1.0.0 | elastic7.1.0 | |
| 7.1.1 | 7.1.1.0 | elastic7.1.1 | |
| 7.2.0 | 7.2.0.0 | elastic7.2.0 | |
| 7.2.1 | 7.2.1.0 | elastic7.2.1 | |
| 7.3.0 | 7.3.0.0 | elastic7.3.0 | |
| 7.3.1 | 7.3.1.0 | elastic7.3.1 | |
| 7.3.2 | 7.3.2.0 | elastic7.3.2 | |
| 7.4.0 | 7.4.0.0 | elastic7.4.0 | |
| 7.4.1 | 7.4.1.0 | elastic7.4.1 | |
| 7.4.2 | 7.4.2.0 | elastic7.4.2 | |
| 7.5.0 | 7.5.0.0 | elastic7.5.0 | |
| 7.5.1 | 7.5.1.0 | elastic7.5.1 | |
| 7.5.2 | 7.5.2.0 | elastic7.5.2 | |
| 7.6.0 | 7.6.0.0 | elastic7.6.0 | |
| 7.6.1 | 7.6.1.0 | elastic7.6.1 | |
| 7.6.2 | 7.6.2.0 | elastic7.6.2 | |
| 7.7.0 | 7.7.0.0 | elastic7.7.0 | |
| 7.7.1 | 7.7.1.0 | elastic7.7.1 | |
| 7.8.0 | 7.8.0.0 | elastic7.8.0 | |
| 7.8.1 |
Extension points exported contracts — how you extend this code
SqlElasticRequestBuilder (Interface)Created by Eliran on 19/8/2015. [9 implementers]
src/main/java/org/nlpcn/es4sql/query/SqlElasticRequestBuilder.java
ElasticHitsExecutor (Interface)
Created by Eliran on 21/8/2016. [8 implementers]
src/main/java/org/elasticsearch/plugin/nlpcn/ElasticHitsExecutor.java
RestExecutor (Interface)
Created by Eliran on 26/12/2015. [8 implementers]
src/main/java/org/elasticsearch/plugin/nlpcn/executors/RestExecutor.java
Core symbols most depended-on inside this repo
getcalled by 782
src/main/java/org/nlpcn/es4sql/query/SqlElasticRequestBuilder.java
add
called by 452
src/main/java/org/nlpcn/es4sql/SQLFunctions.java
toString
called by 313
src/main/java/org/nlpcn/es4sql/domain/Where.java
put
called by 307
src/main/java/com/alibaba/druid/pool/ElasticSearchDruidDataSource.java
format
called by 271
src/main/java/org/elasticsearch/aggregations/pipeline/MovFnPipelineAggregationBuilder.java
name
called by 205
src/main/java/org/elasticsearch/plugin/nlpcn/SqlPlug.java
field
called by 149
src/main/java/org/nlpcn/es4sql/SQLFunctions.java
getHits
called by 144
src/main/java/org/elasticsearch/plugin/nlpcn/ElasticHitsExecutor.java
Shape
Languages
Java99%
TypeScript1%
Modules by API surface
src/main/java/com/alibaba/druid/pool/ElasticSearchDruidDataSource.java135 symbols
src/main/java/org/nlpcn/es4sql/parse/ElasticSqlStatementParser.java115 symbols
src/main/java/com/alibaba/druid/pool/ElasticSearchResultSet.java98 symbols
src/test/java/org/nlpcn/es4sql/QueryTest.java83 symbols
src/test/java/org/nlpcn/es4sql/SqlParserTests.java80 symbols
src/main/java/com/alibaba/druid/pool/ElasticSearchPreparedStatement.java78 symbols
src/test/java/org/nlpcn/es4sql/JoinTests.java72 symbols
src/test/java/org/nlpcn/es4sql/AggregationTest.java56 symbols
src/main/java/com/alibaba/druid/pool/ElasticSearchConnection.java44 symbols
src/main/java/org/nlpcn/es4sql/SQLFunctions.java36 symbols
src/test/java/org/nlpcn/es4sql/MultiQueryTests.java31 symbols
src/main/java/org/nlpcn/es4sql/parse/SqlParser.java29 symbols
Dependencies from manifests, versioned
co.elastic.clients:elasticsearch-java1×
com.alibaba:druid1×
com.fasterxml.jackson.core:jackson-databind2.14.1 · 1×
com.unboundid:unboundid-ldapsdk6.0.7 · 1×
junit:junit4.13.2 · 1×
org.bouncycastle:bcprov-jdk15on1.70 · 1×
org.elasticsearch.client:elasticsearch-rest-client1×
org.elasticsearch:elasticsearch1×
org.hamcrest:hamcrest-all1.3 · 1×
org.locationtech.jts:jts-core1.19.0 · 1×
org.locationtech.spatial4j:spatial4j0.8 · 1×
For agents
$ claude mcp add elasticsearch-sql \
-- python -m otcore.mcp_server <graph>