Elasticsearch模糊查询、多字段in查询、时间范围查询，DSL和java API两种方式

Elasticsearch模糊查询、多字段in查询、时间范围查询，DSL和java API两种方式

 

项目场景：

Elasticsearch模糊查询某字段、多字段in查询、时间范围查询，通过DSL和java API两种方式

---

解决方案： 

一、模糊查询

wildcard 通配符检索

使用wildcard相当于SQL的like，前后都可拼接*，匹配0到多个任意字符

1. {
2. "query": {
3. "wildcard": {
4. "name.keyword": "*文件*"
5. }
6. }
7. }

1. BoolQueryBuilder queryBuilder = QueryBuilders.boolQuery();
2. queryBuilder.must(QueryBuilders.wildcardQuery( "name.keyword", "*文件*"));

fuzzy 模糊/纠错检索

使用fuzzy类似百度搜索，你输入“周杰伦”，也能查出来“周杰轮”，有纠错能力

1. {
2. "query": {
3. "fuzzy": {
4. "name.keyword": "*周杰伦*"
5. }
6. }
7. }

1. BoolQueryBuilder queryBuilder = QueryBuilders.boolQuery();
2. queryBuilder.must(QueryBuilders.fuzzyQuery( "name.keyword", "周杰伦"));

二、多字段in查询

通过terms实现，类似SQL的in查询，多字段用集合表示

1. {
2. "query": {
3. "bool": {
4. "must": {
5. "terms": {
6. "name":[
7. "张三",
8. "李四"
9. ]
10. }
11. }
12. }
13. }
14. }

1. BoolQueryBuilder queryBuilder = QueryBuilders.boolQuery();
2. queryBuilder.must(QueryBuilders.termsQuery( "name.keyword", new ArrayList<>()));

三、时间范围查询

from、to为时间范围，include_lower、include_upper为是否包含左右边界

1. {
2. "query": {
3. "bool": {
4. "must": {
5. "range": {
6. "createTime": {
7. "from": "2022-01-01",
8. "to": "2022-03-01",
9. "include_lower": true,
10. "include_upper": true,
11. "boost": 1
12. }
13. }
14. }
15. }
16. }
17. }

1. BoolQueryBuilder queryBuilder = QueryBuilders.boolQuery();
2. queryBuilder.must(QueryBuilders.rangeQuery( "createTime").gte( "2022-01-01").lte( "2022-03-01"));