ElasticSearch安装SQL插件下载地址(中国大佬开发的,膜拜ing):https://github.com/NLPchina/elasticsearch-sql
1、记得选择和自己Elasticsearch对应的版本哦!如果你的是集群默认,每个节点都要按照这个SQL插件的哦,由于我的是伪分布集群模式,我的安装操作如下所示:
注意:安装成功以后,是在/home/hadoop/soft/elasticsearch-5.4.3/plugins这个目录下面的。请注意进行查收。
1 [elsearch@slaver4 soft]$ ls 2 elasticsearch-5.4.3 elasticsearch-head-master el_slave node-v8.16.2-linux-x64 nohup.out 3 [elsearch@slaver4 soft]$ cd elasticsearch-5.4.3/ 4 [elsearch@slaver4 elasticsearch-5.4.3]$ ls 5 bin config data hs_err_pid11491.log lib LICENSE.txt logs modules NOTICE.txt plugins README.textile 6 [elsearch@slaver4 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 7 -> Downloading https://github.com/NLPchina/elasticsearch-sql/releases/download/5.4.3.0/elasticsearch-sql-5.4.3.0.zip 8 [=================================================] 100% 9 -> Installed sql 10 [elsearch@slaver4 elasticsearch-5.4.3]$ ls 11 bin config data hs_err_pid11491.log lib LICENSE.txt logs modules NOTICE.txt plugins README.textile 12 [elsearch@slaver4 elasticsearch-5.4.3]$ cd plugins/ 13 [elsearch@slaver4 plugins]$ ls 14 elasticsearch-analysis-ik sql 15 [elsearch@slaver4 plugins]$ cd sql/ 16 [elsearch@slaver4 sql]$ ls 17 druid.jar elasticsearch-sql-5.4.3.0.jar guava.jar plugin-descriptor.properties 18 [elsearch@slaver4 sql]$
2、我在一个节点执行的,安装成功以后,然后将解压到plugins目录下sql目录拷贝到其他es的节点的plugins目录下面即可。如下所示:
1 [elsearch@slaver4 soft]$ ls 2 elasticsearch-5.4.3 elasticsearch-head-master el_slave node-v8.16.2-linux-x64 nohup.out 3 [elsearch@slaver4 soft]$ cd elasticsearch-5.4.3/plugins/ 4 [elsearch@slaver4 plugins]$ ls 5 elasticsearch-analysis-ik sql 6 [elsearch@slaver4 plugins]$ cp -r sql/ /home/hadoop/soft/el_slave/elasticsearch-5.4.3-slaver1/plugins/ 7 [elsearch@slaver4 plugins]$ cp -r sql/ /home/hadoop/soft/el_slave/elasticsearch-5.4.3-slaver2/plugins/ 8 [elsearch@slaver4 plu