ES 安装 elasticsearch-sql插件

1、查看sql插件github

https://github.com/NLPchina/elasticsearch-sql

2、安装

1、cd elasticsearch  #进入目录

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

3、下载SQL的Server

wget https://github.com/NLPchina/elasticsearch-sql/releases/download/5.4.1.0/es-sql-site-standalone.zip

4、解压编译安装

unzip es-sql-site-standalone.zip
cd site-server/
npm install express --save

5、修改启动端口，然后启动server

1、修改SQL的Server的端口
　　vi site_configuration.json
2、启动服务
　　node node-server.js &

6、访问前端

遇到的问题

uncaught exception in thread [main]

org.elasticsearch.bootstrap.StartupException: java.lang.IllegalArgumentException: Cannot replace existing handler for [/_sql] for method: POST

原因：elasticsearch-sql与自带的x-pack-sql模块冲突，vi /opt/elasticsearch/config/elasticsearch.yml 修改

xpack.sql.enabled: false重启ES
参考 添加链接描述