下载插件:https://github.com/NLPchina/elasticsearch-sql/releases/download/5.6.4.0/elasticsearch-sql-5.6.4.0.zip
解压,并将解压出来的文件夹名称修改为【sql】
将sql文件夹拷贝到 elasticsearch/plugins目录下面
重启client节点
使用方式,这里简单介绍两种:
在kibana界面的Dev Tools里面输入:GET _sql?sql=select * from test_index where name = ‘John’
在浏览器地址栏输入:192.168.2.225:9200/_sql?sql=select * from test_index where name = ‘John’
http://192.168.2.200:9200/_sql?sql=select * from tdxzx where rec_id= 6555549