ElasticSearch-match查询

偏执的太偏执、 2022-10-05 14:47 155阅读 0赞

# 引言： #

**match查询属于高层查询，他会根据你查询的字段类型不一样，采用不同的查询方式。**

>  *  查询的是日期或者是数值的话，他会将你基于的字符串查询内容转换为日期或者数值对待。
>  *  如果查询的内容是一个不能被分词的内容（keyword），match查询不会对你指定的查询关键字进行分词。
>  *  如果查询的内容时一个可以被分词的内容（text），match会将你指定的查询内容根据一定的方式去分词，去分词库中匹配指定的内容。 
> 
> match查询，实际底层就是多个term查询，将多个term查询的结果给你封装到了一起。

# 一.match查询 #

## 1.match\_all查询 ##

查询全部内容，不指定任何查询条件。

# match_all查询
    POST /sms-logs-index/sms-logs-type/_search
    {
      "query": {
        "match_all": {}
      }
    }

###  使用kibana ###

![20210609174813546.png][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3F3cTE1MTgzNDY4NjQ_size_16_color_FFFFFF_t_70][]

### 代码实现方式 ###

/**
     * @author: qiuyongqi
     * @time: 11:25 2021/6/8
     * @description: match 查询
     */
    public class demo5 {
        //定义RestHighLevelClient对象
        RestHighLevelClient client = EsClient.getClient();
        //创建objectMaper对象
        ObjectMapper objectMapper = new ObjectMapper();
        //定义索引名称
        String index = "sms-logs-index";
        //定义类型名称
        String type = "sms-logs-type";
    
        /**
         * @author: qiuyongqi
         * @time: 11:19 2021/6/8
         * @description:   match_all查询
         */
        @Test
        public void matchAllQuery() throws IOException {
            //1.创建一个searchRequest
            SearchRequest request = new SearchRequest(index);
            request.types(type);
    
            //2. 指定查询条件
            SearchSourceBuilder builder = new SearchSourceBuilder();
            builder.size(20);
            builder.query(QueryBuilders.matchAllQuery());
            request.source(builder);
            //3. 执行查询
            SearchResponse response = client.search(request, RequestOptions.DEFAULT);
    
            //4. 输出结果
            for (SearchHit hit : response.getHits().getHits()) {
                System.out.println(hit.getSourceAsMap());
            }
            System.out.println(response.getHits().getTotalHits());
        }
    
    
    }

## 2 match查询 ##

> 指定一个Field作为筛选的条件

# match查询
    POST /sms-logs-index/sms-logs-type/_search
    {
      "query": {
        "match": {
          "smsContent": "收货安装"
        }
      }
    }

###  使用kibana ###

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3F3cTE1MTgzNDY4NjQ_size_16_color_FFFFFF_t_70 1][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3F3cTE1MTgzNDY4NjQ_size_16_color_FFFFFF_t_70 2][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3F3cTE1MTgzNDY4NjQ_size_16_color_FFFFFF_t_70 3][]

### 代码实现方式 ###

/**
         * @author: qiuyongqi
         * @time: 11:21 2021/6/8
         * @description:  match查询
         */
        @Test
        public void matchQuery() throws IOException {
            //1. 创建request
            SearchRequest request=new SearchRequest(index);
            request.types(type);
            //2. 封装查询条件
            SearchSourceBuilder builder=new SearchSourceBuilder();
            builder.query(QueryBuilders.matchQuery("smsContent","收货安装"));
            request.source(builder);
            //3. 执行查询
            SearchResponse response = client.search(request, RequestOptions.DEFAULT);
            //4. 输出结果
            for (SearchHit hit : response.getHits().getHits()) {
                System.out.println(hit.getSourceAsMap());
            }
    
            System.out.println(response.getHits().getTotalHits());
        }

## 3 布尔match查询 ##

> 基于一个Field匹配的内容，采用and或者or的方式连接

# 布尔match查询
    POST /sms-logs-index/sms-logs-type/_search
    {
      "query": {
        "match": {
          "smsContent": {
            "query": "中国 健康",
            "operator": "and"      # 内容既包含中国也包含健康
          }
        }
      }
    }
    
    
    # 布尔match查询
    POST /sms-logs-index/sms-logs-type/_search
    {
      "query": {
        "match": {
          "smsContent": {
            "query": "中国 健康",
            "operator": "or"		# 内容包括健康或者包括中国
          }
        }
      }
    }

###  使用kibana ###

### 3.1and ###

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3F3cTE1MTgzNDY4NjQ_size_16_color_FFFFFF_t_70 4][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3F3cTE1MTgzNDY4NjQ_size_16_color_FFFFFF_t_70 5][]

### 3.2or ###

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3F3cTE1MTgzNDY4NjQ_size_16_color_FFFFFF_t_70 6][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3F3cTE1MTgzNDY4NjQ_size_16_color_FFFFFF_t_70 7][]

### 代码实现方式 ###

/**
         * @author: qiuyongqi
         * @time: 10:46 2021/6/8
         * @description: 布尔match查询
         *               基于一个Field匹配的内容，采用and或者or的方式连接
         *                  Operator.OR    Operator.AND
         */
        @Test
        public void booleanMatchQuery() throws IOException {
            //1. 创建request
            SearchRequest request=new SearchRequest(index);
            request.types(type);
            //2. 封装查询条件
            SearchSourceBuilder builder=new SearchSourceBuilder();
            builder.query(QueryBuilders.matchQuery("smsContent","健康 中国").operator(Operator.AND));
            request.source(builder);
            //3. 执行查询
            SearchResponse response = client.search(request, RequestOptions.DEFAULT);
            //4. 输出结果
            for (SearchHit hit : response.getHits().getHits()) {
                System.out.println(hit.getSourceAsMap());
            }
    
            System.out.println(response.getHits().getTotalHits());
        }

## 4 multi\_match查询 ##

> match针对一个field做检索，multi\_match针对多个field进行检索，多个field对应一个text。

# multi_match 查询
    POST /sms-logs-index/sms-logs-type/_search
    {
      "query": {
        "multi_match": {
          "query": "北京",					# 指定text
          "fields": ["province","smsContent"]    # 指定field们
        }
      }
    }

###  使用kibana ###

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3F3cTE1MTgzNDY4NjQ_size_16_color_FFFFFF_t_70 8][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3F3cTE1MTgzNDY4NjQ_size_16_color_FFFFFF_t_70 9][]

### 代码实现方式 ###

/**
         * @author: qiuyongqi
         * @time: 10:46 2021/6/8
         * @description: multi_match查询
         */
        @Test
        public void multiMatchQuery() throws IOException {
            //1. 创建request
            SearchRequest request=new SearchRequest(index);
            request.types(type);
            //2. 封装查询条件
            SearchSourceBuilder builder=new SearchSourceBuilder();
            builder.query(QueryBuilders.multiMatchQuery("北京","smsContent","province"));
            request.source(builder);
            //3. 执行查询
            SearchResponse response = client.search(request, RequestOptions.DEFAULT);
            //4. 输出结果
            for (SearchHit hit : response.getHits().getHits()) {
                System.out.println(hit.getSourceAsMap());
            }
    
            System.out.println(response.getHits().getTotalHits());
        }

[20210609174813546.png]: /images/20221005/5cfbb69fd1ec459b8863cf168a24a799.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3F3cTE1MTgzNDY4NjQ_size_16_color_FFFFFF_t_70]: /images/20221005/ae1fa52f72f54ffab9b2c994721e5f3e.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3F3cTE1MTgzNDY4NjQ_size_16_color_FFFFFF_t_70 1]: /images/20221005/81162479dba146ed85a8cecc419d2a0e.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3F3cTE1MTgzNDY4NjQ_size_16_color_FFFFFF_t_70 2]: /images/20221005/cb93bf3b68f24f0cb87fff99c9bf3a41.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3F3cTE1MTgzNDY4NjQ_size_16_color_FFFFFF_t_70 3]: /images/20221005/5030085a13b94599b6486523cfae55c4.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3F3cTE1MTgzNDY4NjQ_size_16_color_FFFFFF_t_70 4]: /images/20221005/6759c85f968545c58f157977599bdd53.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3F3cTE1MTgzNDY4NjQ_size_16_color_FFFFFF_t_70 5]: /images/20221005/fb2aee60e49343f28162c50163707de9.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3F3cTE1MTgzNDY4NjQ_size_16_color_FFFFFF_t_70 6]: /images/20221005/afd27df2eee743d88a8456107da880b2.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3F3cTE1MTgzNDY4NjQ_size_16_color_FFFFFF_t_70 7]: /images/20221005/1ac1ed99e9a54793a54b49d5c0fb2de5.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3F3cTE1MTgzNDY4NjQ_size_16_color_FFFFFF_t_70 8]: /images/20221005/d027604ce6274986a4381886d1da3457.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3F3cTE1MTgzNDY4NjQ_size_16_color_FFFFFF_t_70 9]: /images/20221005/3e436c8f9c7e4736aabe5be6ed6ca543.png