GitHub Address: Https://github.com/NLPchina/elasticsearch-sql
The Elasticsearch-sql plugin makes it easy for us to query the elasticsearch using the SQL language
1, enter the Elasticsearch installation directory, execute the following command (Windows and Linux slashes to note):
./bin/elasticsearch-plugin Install https://github.com/nlpchina/elasticsearch-sql/releases/download/ 6.2.3.0/elasticsearch-sql-6.2.3.0.zip
or download it from GitHub and put it under the plugins\sql of ES.
2. node. js file required for download page
https://github.com/nlpchina/elasticsearch-sql/releases/download/5.4.1.0/es-sql-site-standalone.zip
Install and run in the Unzip directory
NPM Install Express--savenode node-server.js
The default port for Elasticsearch-sql is 8080 and can be modified in the Site-server/site_configuration.json file
Then open the http://localhost:8080/access plugin
Note Modify the address of the local elasticsearch in the upper-right corner , SQL script does not need a semicolon ";" At the end, if an index has more than one type, the table name is represented by Indexname/typename
Elasticsearch-sql Installation