Code Monkey home page Code Monkey logo

elasticsearch-sql's Introduction

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 6.8.23 Build Status 7.17.16 7.17.16 Build Status 8.11.3 8.11.3 Build Status master master Build Status

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

Check out our wiki!

explain example

Web frontend overview

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 7.8.1.0 elastic7.8.1
7.9.0 7.9.0.0 elastic7.9.0
7.9.1 7.9.1.0 elastic7.9.1
7.9.2 7.9.2.0 elastic7.9.2
7.9.3 7.9.3.0 elastic7.9.3
7.10.0 7.10.0.0 elastic7.10.0
7.10.1 7.10.1.0 elastic7.10.1
7.10.2 7.10.2.0 elastic7.10.2
7.11.0 7.11.0.0 elastic7.11.0
7.11.1 7.11.1.0 elastic7.11.1
7.11.2 7.11.2.0 elastic7.11.2
7.12.0 7.12.0.0 elastic7.12.0
7.12.1 7.12.1.0 elastic7.12.1
7.13.0 7.13.0.0 elastic7.13.0
7.13.1 7.13.1.0 elastic7.13.1
7.13.2 7.13.2.0 elastic7.13.2
7.13.3 7.13.3.0 elastic7.13.3
7.13.4 7.13.4.0 elastic7.13.4
7.14.0 7.14.0.0 elastic7.14.0
7.14.1 7.14.1.0 elastic7.14.1
7.14.2 7.14.2.0 elastic7.14.2
7.15.0 7.15.0.0 elastic7.15.0
7.15.1 7.15.1.0 elastic7.15.1
7.15.2 7.15.2.0 elastic7.15.2
7.16.0 7.16.0.0 elastic7.16.0
7.16.1 7.16.1.0 elastic7.16.1
7.16.2 7.16.2.0 elastic7.16.2
7.16.3 7.16.3.0 elastic7.16.3
7.17.0 7.17.0.0 elastic7.17.0
7.17.1 7.17.1.0 elastic7.17.1
7.17.2 7.17.2.0 elastic7.17.2
7.17.3 7.17.3.0 elastic7.17.3
7.17.4 7.17.4.0 elastic7.17.4
7.17.5 7.17.5.0 elastic7.17.5
7.17.6 7.17.6.0 elastic7.17.6
7.17.7 7.17.7.0 elastic7.17.7
7.17.8 7.17.8.0 elastic7.17.8
7.17.9 7.17.9.0 elastic7.17.9
7.17.10 7.17.10.0 elastic7.17.10
7.17.11 7.17.11.0 elastic7.17.11
7.17.12 7.17.12.0 elastic7.17.12
7.17.13 7.17.13.0 elastic7.17.13
7.17.14 7.17.14.0 elastic7.17.14
7.17.15 7.17.15.0 elastic7.17.15
7.17.16 7.17.16.0 elastic7.17.16
8.5.3 8.5.3.0 elastic8.5.3
8.6.0 8.6.0.0 elastic8.6.0
8.6.1 8.6.1.0 elastic8.6.1
8.6.2 8.6.2.0 elastic8.6.2
8.7.0 8.7.0.0 elastic8.7.0
8.7.1 8.7.1.0 elastic8.7.1
8.8.0 8.8.0.0 elastic8.8.0
8.8.1 8.8.1.0 elastic8.8.1
8.8.2 8.8.2.0 elastic8.8.2
8.9.0 8.9.0.0 elastic8.9.0
8.9.1 8.9.1.0 elastic8.9.1
8.9.2 8.9.2.0 elastic8.9.2
8.10.0 8.10.0.0 elastic8.10.0
8.10.1 8.10.1.0 elastic8.10.1
8.10.2 8.10.2.0 elastic8.10.2
8.10.3 8.10.3.0 elastic8.10.3
8.10.4 8.10.4.0 elastic8.10.4
8.11.0 8.11.0.0 elastic8.11.0
8.11.1 8.11.1.0 elastic8.11.1
8.11.2 8.11.2.0 elastic8.11.2
8.11.3 8.11.3.0 elastic8.11.3

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 6.8.7

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

Elasticsearch 6.8.8

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

Elasticsearch 6.8.9

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

Elasticsearch 6.8.10

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

Elasticsearch 6.8.11

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

Elasticsearch 6.8.12

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

Elasticsearch 6.8.13

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

Elasticsearch 6.8.14

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

Elasticsearch 6.8.15

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

Elasticsearch 6.8.16

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

Elasticsearch 6.8.17

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

Elasticsearch 6.8.18

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

Elasticsearch 6.8.19

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

Elasticsearch 6.8.20

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

Elasticsearch 6.8.21

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

Elasticsearch 6.8.22

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

Elasticsearch 6.8.23

./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/6.8.23.0/elasticsearch-sql-6.8.23.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

Elasticsearch 7.5.2

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

Elasticsearch 7.6.0

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

Elasticsearch 7.6.1

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

Elasticsearch 7.6.2

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

Elasticsearch 7.7.0

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

Elasticsearch 7.7.1

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

Elasticsearch 7.8.0

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

Elasticsearch 7.8.1

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

Elasticsearch 7.9.0

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

Elasticsearch 7.9.1

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

Elasticsearch 7.9.2

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

Elasticsearch 7.9.3

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

Elasticsearch 7.10.0

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

Elasticsearch 7.10.1

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

Elasticsearch 7.10.2

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

Elasticsearch 7.11.0

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

Elasticsearch 7.11.1

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

Elasticsearch 7.11.2

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

Elasticsearch 7.12.0

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

Elasticsearch 7.12.1

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

Elasticsearch 7.13.0

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

Elasticsearch 7.13.1

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

Elasticsearch 7.13.2

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

Elasticsearch 7.13.3

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

Elasticsearch 7.13.4

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

Elasticsearch 7.14.0

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

Elasticsearch 7.14.1

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

Elasticsearch 7.14.2

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

Elasticsearch 7.15.0

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

Elasticsearch 7.15.1

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

Elasticsearch 7.15.2

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

Elasticsearch 7.16.0

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

Elasticsearch 7.16.1

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

Elasticsearch 7.16.2

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

Elasticsearch 7.16.3

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

Elasticsearch 7.17.0

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

Elasticsearch 7.17.1

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

Elasticsearch 7.17.2

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

Elasticsearch 7.17.3

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

Elasticsearch 7.17.4

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

Elasticsearch 7.17.5

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

Elasticsearch 7.17.6

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

Elasticsearch 7.17.7

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

Elasticsearch 7.17.8

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

Elasticsearch 7.17.9

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

Elasticsearch 7.17.10

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

Elasticsearch 7.17.11

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

Elasticsearch 7.17.12

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

Elasticsearch 7.17.13

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

Elasticsearch 7.17.14

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

Elasticsearch 7.17.15

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

Elasticsearch 7.17.16

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

Elasticsearch 8.5.3

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

Elasticsearch 8.6.0

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

Elasticsearch 8.6.1

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

Elasticsearch 8.6.2

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

Elasticsearch 8.7.0

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

Elasticsearch 8.7.1

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

Elasticsearch 8.8.0

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

Elasticsearch 8.8.1

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

Elasticsearch 8.8.2

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

Elasticsearch 8.9.0

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

Elasticsearch 8.9.1

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

Elasticsearch 8.9.2

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

Elasticsearch 8.10.0

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

Elasticsearch 8.10.1

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

Elasticsearch 8.10.2

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

Elasticsearch 8.10.3

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

Elasticsearch 8.10.4

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

Elasticsearch 8.11.0

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

Elasticsearch 8.11.1

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

Elasticsearch 8.11.2

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

Elasticsearch 8.11.3

./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/v8.11.3/elasticsearch-sql-8.11.3.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

elasticsearch-sql's People

Contributors

allwefantasy avatar ansjsun avatar anton-johansson avatar calebott avatar dai-chen avatar dependabot[bot] avatar detongz avatar eliranmoyal avatar ianvdl avatar iceneve avatar jasonliaoxiaoge avatar javadevmtl avatar juanpaulo avatar landraxee avatar lshb avatar mrfsong avatar mtdavidson avatar nezhazheng avatar olleolleolle avatar omershelef avatar perlun avatar pilere avatar rrequero avatar shi-yuan avatar stegano avatar stopit avatar terryjaychan avatar xumeng avatar yongkyun avatar zhaolihe avatar

Stargazers

avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar

Watchers

avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar

Forkers

baojie luyee younglibin thehunter songtao1987 bx5974 nile landraxee kingice vvw fc13240 ilevin echozhjun derweeyang dluobo crudbug wowuwowuwo lemonhall goeswind jxs-xx huanglz yangaoquan jheimbouch jaanek tianhonglouis skpcandy yongkyun zhangwei5095 jimlgx glycerine ehalpern ceo4ever songwie qingyu1229 saidimu adaksuman shengxinking open-party wking1986 sonatans mlc0202 xb1078 goodljy seanxiao1981 24601 lzyang hiteshjoshi miguelrincon davismathew adian98 morgango xuanyuanking enilu lingfeng3007 dbirchak willschipp popacai eliranmoyal code-hunter excedis td-frank jeremylei mavencode01 adamstortz xingzhixi lviiii mindis tongchuanwei knc331 jkusachi hemant-kumar dongbin86 giddily amitsrivastav dongfanliang gewaski mermalrain anhzhi beans07 mindops khaliyo victoryxs zhj12388 hancy2013 henry2005 myunxi flowbywind fengshao0907 zuoguocai huangpeide tangjie231 agilemobiledev ianvdl rtvt123 imogots sagarl x645383133 xie645383133 anujsrc jision

elasticsearch-sql's Issues

Use match_phrase instead of terms filter for equality operator?

Suppose we indexed two documents:
document 1:

{
    "message": "hello"
}

document 2:

{
    "message": "hello world"
}

when running:

SELECT * FROM myindex WHERE message='hello world'

The two of the above documents will be return instead of just document number 2.
maybe use match_phrase instead of term filter?

Cannot parse less than or greater than on Date

Sample Query:

select * from revisions where  dInDate >= {ts '2015-03-16 09:50:00.000'}  AND  dInDate < {ts '2015-03-16 09:54:00.000'}

The response is

{"error":"ParserException[ERROR. token : LBRACE dInDate]","status":500}

I am able to execute this query against SQL Server no problem.

I would be interested in helping solve this problem (contributing to the code). I'm still trying to comb through and see where this happens.

1.4.1版本,使用报错

Error: {"error":"RemoteTransportException[[Novs][inet[localhost:9300]][indices/create]]; nested: InvalidIndexNameException[[_sql] Invalid index name [sql], must not start with '']; ","status":400}

另外一个es节点上报:
{"error":"NoClassDefFoundError[org/durid/sql/ast/statement/SQLSelectQuery]; nested: ClassNotFoundException[org.durid.sql.ast.statement.SQLSelectQuery]; ","status":500}

es版本为:1.3.6

页面上我填写的是本机的9200啊,不知道为什么网络请求是9300.语句就是readme上的示例.

add desc table or show tables command

add desc table or show tables command!
i think it is useful like this

show indexs  ; //return all indexes ;

show [indexName] ; // return all mapping

desc [indexName] ; //return index fields

desc [indexName]/[mapping] ; //return mapping config

and if sql end with ";" replace it to empty.

how about ?

Support for Elasticsearch 1.5

I am not sure if that's currently an issue, but when installing the plugin into an Elasticsearch 1.5 cluster, I can't see anything happening when navigating to the plugin url.

Having issues with Operator Precedence when enclosed with in brackets

We have a case where we create dynamic queries depending on the user criteria and user permission.
with this we may land up creating queries like

(firstname LIKE 'A%%' OR firstname LIKE 'B%%') AND (firstname LIKE 'C%%' OR firstname LIKE 'D%%')

this may end up giving no result when executing in sql . But when using elasticsearch-sql it is just adding up all the criteria under should{} with out considering AND .

error while executing sql

it always gives me this
{"error":"InvalidIndexNameException[[_sql] Invalid index name [sql], must not start with '']","status":400}"

for any correct index against simple select * from <index_name>

Elasticsearch-sql site. URL box

The url box at the upper right corner in the site, need to show the base url of the elasticsearch host, instead the hard coded value: "http://localhost:9200".

After changing the URL the site need to save the value, and show it at the next refresh.

incorrect dsl generation for 'IN' operator

SQL input:
select field1,field2 FROM index1 WHERE field3 in (5,7,9)

output as shown by explain tool:
{
"from" : 0,
"size" : 200,
"post_filter" : {
"bool" : {
"must" : {
"range" : {
"field3" : {
"from" : 5,
"to" : 7,
"include_lower" : true,
"include_upper" : true
}
}
}
}
},
"fields" : [ "field1", "field2" ]
}

when I try to execute the above query (edited) , I always find query returns fault results. When I further analyze to see how the SQL to DSL conversion is happening, I see the 'IN' usage is converted to 'range' in DSL which I believe is incorrect. It show be ideally be using "terms" filter I believe. Please correct me if I am wrong.

Date column

I have date column. How can I write a SQL statement based on that column in where clause?

Example: SELECT count(*) FROM logstash-2015.03.18 where @datetime between '2015-03-18' and '2015-03-18'

@datetime format: 2015-03-18T12:17:20.000Z

Index name error

Invalid index name [sql], must not start with '']; ","status":400}

Error after starting any select and on any index.
The index names are not started with a "_".

ElasticSearch version: 1.4.4

Not able to query data which has space in column name

Not able to query data which has space in column name like

SELECT * FROM shanghairanking ORDER BY 'WORLD RANK'

error it says Error: {"error":"SqlParseException[unknow field name : 'WORLD RANK']","status":500}

SELECT * FROM shanghairanking shows

Sample Results
World Rank |Institution*|Country /Region |National Rank |Total Score|Alumni|Award|HiCi|N&S|PUB|PCP
4|University of California-Berkeley| |4|70.1|66.8|79.4|65.3|67.5|68.1|55.9

ParserException illegal sql expr

I'm not sure if these are expected behaviors...

Trying to execute this query from the sql web interface... (with or without the semicolon)...

SELECT min(id),max(id) FROM logs-2015.01.13;

Produces this error...

{"error":"ParserException[illegal sql expr : SELECT min(id),max(id) FROM logs-2015.01.13;]","status":500}

But, if I add a LIMIT clause then the query executes...

SELECT min(id),max(id) FROM logs-2015.01.13 limit 1

Also, running the above query with a semicolon at the end produces an error. Note that I also used a semicolon in the first query above for what it's worth...

SELECT min(id),max(id) FROM logs-2015.01.13 limit 1;

{"error":"ParserException[illegal sql expr : SELECT min(id),max(id) FROM TEMP_TABLE limit 1;]","status":500}

Unclosed opened file handlers.

I have a nodes names A which have about 1M docs. Every time I use
select * from A limit 1000, this plugin will open 15 handlers and leave them open after query.

This bug will cause the count of file descriptors reach the max limit after some queries.

problem in using elasticsearch-sql plugin

I used command: curl 'localhost:9200/bank/_search?q=*&pretty' before;
Am I right change my command to string like this: curl 'localhost:9200/_sql?sql=select * from bank' ??

[enhancement] Add math functions

It would be useful to have functions similar to mysql such as round, concat, substr, ceil, etc.

select ROUND(sum(billedamount),5) as billedamt, max(id) as maxid from table;

select CONCAT(someField,'some text') as someData from table order by LENGTH(someData) desc;

"distinct" keyword not working

hi
we are trying to user distinct with selecting multiple columns . But the result end up in showing same data in multiple rows .

we are trying some thing like
select count(distinct HC1_LEVEL_05_CD,HC1_LEVEL_05_DESC,HC2_LEVEL_04_CD,HC2_LEVEL_04_DESC,HC3_LEVEL_03_CD,HC3_LEVEL_03_DESC )
from vwsearchview where HC1_LEVEL_03_CD = 'P0LI8'

even we tried with group by

select count(*)
from vwsearchview where HC1_LEVEL_03_CD = 'P0LI8' group by HC1_LEVEL_05_CD,HC1_LEVEL_05_DESC,HC2_LEVEL_04_CD,
HC2_LEVEL_04_DESC,HC3_LEVEL_03_CD,HC3_LEVEL_03_DESC

out intention is to get count of distinct columns .

connect to remote elasticsearch server

this program is worked well as a plugin in ES 1.4.x

but I want to this program to local to remote server.

so I opened it in Eclipse, and setting host to remote server, but doesn't work. with "None of the configured nodes are available: []" error(exception)

Is it not possible to connect to remote server with this program?

Or possible by doing some customizing

Please tell me,

Thanks

Invalid index name [_sql]

Hi All,

Could you please reopen issue #29 (Invalid index name [_sql] ) ?
There are two new comments to issue #29 but since this issue is closed I am not sure if you follow new comments.

Thank you,
Taras

count(*) 和 sum(f) 一起查询时出错

select count() from olap.sales 没问题
select count(),sum(order_num) from olap.sales 会报错
{
"error" : "SearchPhaseExecutionException[Failed to execute phase [query], all shards failed; shardFailures {[4d-mEvX1SX6O1-fqCd0sNg][olap][3]: SearchParseException[[olap][3]: from[-1],size[0]: Parse Failure [Failed to parse source [{"size":0,"aggregations":{"COUNT()":{"value_count":{}},"SUM(order_num)":{"sum":{"field":"order_num"}}}}]]]; nested: AggregationExecutionException[could not find the appropriate value context to perform aggregation [COUNT()]]; }{[4d-mEvX1SX6O1-fqCd0sNg][olap][2]: SearchParseException[[olap][2]: from[-1],size[0]: Parse Failure [Failed to parse source [{"size":0,"aggregations":{"COUNT()":{"value_count":{}},"SUM(order_num)":{"sum":{"field":"order_num"}}}}]]]; nested: AggregationExecutionException[could not find the appropriate value context to perform aggregation [COUNT()]]; }{[4d-mEvX1SX6O1-fqCd0sNg][olap][1]: SearchParseException[[olap][1]: from[-1],size[0]: Parse Failure [Failed to parse source [{"size":0,"aggregations":{"COUNT()":{"value_count":{}},"SUM(order_num)":{"sum":{"field":"order_num"}}}}]]]; nested: AggregationExecutionException[could not find the appropriate value context to perform aggregation [COUNT()]]; }{[4d-mEvX1SX6O1-fqCd0sNg][olap][0]: SearchParseException[[olap][0]: from[-1],size[0]: Parse Failure [Failed to parse source [{"size":0,"aggregations":{"COUNT()":{"value_count":{}},"SUM(order_num)":{"sum":{"field":"order_num"}}}}]]]; nested: AggregationExecutionException[could not find the appropriate value context to perform aggregation [COUNT()]]; }{[4d-mEvX1SX6O1-fqCd0sNg][olap][4]: SearchParseException[[olap][4]: from[-1],size[0]: Parse Failure [Failed to parse source [{"size":0,"aggregations":{"COUNT()":{"value_count":{}},"SUM(order_num)":{"sum":{"field":"order_num"}}}}]]]; nested: AggregationExecutionException[could not find the appropriate value context to perform aggregation [COUNT()]]; }]",
"status" : 400
}

IS NULL or IS NOT NULL don't work

When executing the simple query

select * from documents where xComment IS NULL

a QueryParsingException occurs from Elastic. QueryParsingException[[documents] No text specified for text query

The query:

{
    "from": 0,
    "size": 200,
    "query": {
        "filtered": {
            "filter": {
                "bool": {
                    "must": {
                        "not": {
                            "filter": {
                                "query": {
                                    "match": {
                                        "xComment": {
                                            "query": null,
                                            "type": "phrase"
                                        }
                                    }
                                }
                            }
                        }
                    }
                }
            }
        }
    }
}

Should really be:

{
  "query":{
    "constant_score": {
      "filter": {
        "missing": {
          "field": "xComment"
        }
      }
    }
  }
}

Also, the generated query does not make use of the "missing filter" or the "exists filter" from Elastic.
http://www.elastic.co/guide/en/elasticsearch/reference/current/query-dsl-missing-filter.html
http://www.elastic.co/guide/en/elasticsearch/reference/current/query-dsl-exists-filter.html

How can I assist in getting this fixed?

order by not working as expected

Running the following query does not return data ordered by rci.

curl -G "http://localhost:9200/_sql?pretty" --data-urlencode "sql=select rci, sum(costAmountOut) as cost, sum(billedamount) as billedamt, max(datadate) as maxdate, max(id) as maxid from data20141011 where rci <> 0 and rci <> 1538 and rci <> 1624 group by rci order by rci"

Explain outputs:

{
  "size" : 0,
  "fields" : "rci",
  "aggregations" : {
    "filter" : {
      "filter" : {
        "bool" : {
          "must" : {
            "bool" : {
              "must" : [ {
                "not" : {
                  "filter" : {
                    "term" : {
                      "rci" : 0
                    }
                  }
                }
              }, {
                "not" : {
                  "filter" : {
                    "term" : {
                      "rci" : 1538
                    }
                  }
                }
              }, {
                "not" : {
                  "filter" : {
                    "term" : {
                      "rci" : 1624
                    }
                  }
                }
              } ]
            }
          }
        }
      },
      "aggregations" : {
        "rci" : {
          "terms" : {
            "field" : "rci",
            "size" : 2147483647
          },
          "aggregations" : {
            "cost" : {
              "sum" : {
                "field" : "costAmountOut"
              }
            },
            "billedamt" : {
              "sum" : {
                "field" : "billedamount"
              }
            },
            "maxdate" : {
              "max" : {
                "field" : "datadate"
              }
            },
            "maxid" : {
              "max" : {
                "field" : "id"
              }
            }
          }
        }
      }
    }
  }
}

connect to remote elasticsearch server

this program is worked well as a plugin in ES 1.4.x

but I want to this program to local to remote server.

so I opened it in Eclipse, and setting host to remote server, but doesn't work. with "None of the configured nodes are available: []" error(exception)

Is it not possible to connect to remote server with this program?

Or possible by doing some customizing

Please tell me,

Thanks

Add explain button

The explain button should translate the current sql query to ES query using _explain endpoint and display the results to the user.

can not used by 1.4.1 version

{1.4.1}: Initialization Failed ...

  1. NoSuchMethodError[org.elasticsearch.rest.BaseRestHandler.(Lorg/elastics
    earch/common/settings/Settings;Lorg/elasticsearch/client/Client;)V]

Add distinct feature

I thinking of implementing the sql DISTINCT feature.
to make this feature as close as possible to sql behaivor I was thinking to implement it like this:

SELECT DISTINCT(myfield) FROM myindex

on the above query, we first check the analyzer of myfield. if not_analyzed field exist, we will use term filter, which provide in this case exact distinct behaivor.

on the other hand, if not_analyzed does not exist, we will use cardinality aggregation which will provide approximate distinct.

any thougths?

between not working as expected

This query produces an error. id is mapped as an integer and field is mapped as string. Without the q=query works.

curl -G "http://localhost:9200/_sql?pretty" --data-urlencode "sql=SELECT count(*) FROM data where q=query('field:ANS') and id between 20686942977 and 20687130940"

{
  "error" : "SqlParseException[error class type sub :class com.alibaba.druid.sql.ast.expr.SQLBetweenExpr]",
  "status" : 500
}

DSL query

Hi,

These is not an issue, Just checking if it's already available. I am looking for a DSL query generated for every SQL query so that we can understand how it's being translated.

Thanks

Fix index name recognition

When making a query, the sql parser should'nt evaluate the index name as expression, instead it should pick it up AS IS until the space. so the first word after the FROM should be recognized as index name.

The bug causing problems like described in issues #36 and #34

There is one exception, multiple indexes should be supported,
So a query like this, should work:

SELECT * FROM index1, index2, index3

IndexMissingException always

i get this on any querying of my index ES 1.4 ES-SQL 1.3

SELECT * FROM ecapilog-2015-02-04 limit 10

{"error":"IndexMissingException[[ecapilog-2015-2-4] missing]","status":404}

Doesn't like index names with periods?

I have an index named "data-2014.10.08" and when I try this query:

curl -G "http://localhost:9200/_sql?pretty" --data-urlencode "sql=SELECT max(id) as maxid FROM data-2014.10.08"

I receive this error:

{
  "error" : "ParserException[illegal sql expr : SELECT max(id) as maxid FROM data-2014.10.08]",
  "status" : 500
}

Underscore gets replaced with question mark

When executing the following SQL query,

http://localhost:9200/_sql/_explain?sql=select+*+from+revisions+where+%28dDocTitle+LIKE+%27%251018_8161%25%27++OR++dDoc_Title+LIKE+%27%25AEIA-KPUMCN%25%27%29+AND+xGF_1+LIKE+%27MMI_App%25%27

The plugin generates the translated SQL into Elastic Syntax. It incorrectly turns the underscores into question marks. Please see the attached image to see it in action.

Is this something done on purpose? --EDIT: I see that on line 141 in Maker.java, you are explicitly doing the replace.
rcsbase_win7

support for SQL with SubQuery

In source code, there is an class includes method that adds Subquery in class named 'org.nlpcn.es4sql.query.maker.Querymaker'

But SQL like [ select * from where fieldname in (select ~) ] doesn't support I think.

Did I used wrong expression?

Or does it support yet?

if use agg search the talble not hava result

hello @omershelef i found if you use search by aggregation
like this

select sum(age),count(*), count(distinct age) from bank  group by gender order by count(distinct age)

it can not make talbe to view .. and it result hard to table ..

i think if we only resunt json format result .. it will easy ...

Improve all tests

All tests should have assert statements,
printing the ES query after conversion is not enough.

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.