Elasticsearch插件集成

简繁通检

- 安装的插件一版本大多数要和es版本保持一致

简繁体转化
1
./bin/elasticsearch-plugin install https://github.com/medcl/elasticsearch-analysis-stconvert/releases/download/v7.6.2/elasticsearch-analysis-stconvert-7.6.2.zip
阅读更多

Kibana入门

安装Elasticsearch请看Docker入门或者Elasticsearch安装

安装Kibana请看Docker入门

IK分词器安装请看Docker入门

阅读更多

Kibana入门

FIND_IN_SET()函数无法识别

方案一(有效果,但不多,mybatis中会出问题)

解决方案
1
2
3
4
5
6
7
CREATE OR REPLACE  FUNCTION find_in_set(str text, strlist text) RETURNS int
AS
DECLARE b1 VARCHAR;
begin
b1:=array_position(string_to_array($2, ','),$1);
RETURN b1;
end;
测试
1
SELECT t.dept_id FROM sys_dept t WHERE find_in_set(#{deptId}, ancestors) 

方案二,有效

1
2
SELECT t.dept_id FROM sys_dept t WHERE find_in_set(#{deptId}, ancestors)
SELECT t.dept_id FROM sys_dept t WHERE position(#{deptId} in ancestors)

Elasticsearch安装

ES不允许在root权限下运行,所以要先创建一个用户

1
useradd search

下载ES

1
wget https://artifacts.elastic.co/downloads/elasticsearch/elasticsearch-7.6.2-linux-x86_64.tar.gz
阅读更多