Elasticsearch-5.4.0安装sql插件

下载环境包

wget https://github.com/NLPchina/elasticsearch-sql/releases/download/5.4.0.0/elasticsearch-sql-5.4.0.0.zip

解压后得到elasticsearch文件夹,将该文件夹移动到es安装目录下plugins文件夹下并改名为sql
每个节点都进行上述操作
重启集群

下载jdbc

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

jdbc连接方式
properties.put("url", "jdbc:elasticsearch://139.196.218.206:9300,139.196.218.205:9300/");

sql界面

wget https://github.com/NLPchina/elasticsearch-sql/releases/download/5.4.0.0/es-sql-site-standalone.zip
unzip es-sql-site-standalone.zip -d es-sql-site
sed -i ‘s/8080/11112/g’ site_configuration.json
cd es-sql-site/site-server
npm install express --save
node node-server.js
ip:11112即可访问