Elasticsearch查询之Term?Query示例解析

来源：jb51　　时间：2023/4/24 8:52:27　　对本文有异议

Term Query

Term Query是一种最基本的查询方式，它用于在Elasticsearch中查询一个字段中包含指定关键词的文档，与MySQL中的等值查询类似。使用Term Query时，可以对字段进行完全匹配，且区分大小写。

基本语法

GET /{index}/_search
{
    "query": {
        "term": {
            "{field}": "{value}"
        }
    }
}

其中，{index}表示查询的索引名称，{field}表示需要查询的字段，{value}表示需要匹配的值。

Java代码写法

// TODO 省略导入包
import java.io.IOException;
public class TermQueryExample {
    public static void main(String[] args) throws IOException {
        RestHighLevelClient client = new RestHighLevelClient(
                RestClient.builder(
                        new HttpHost("localhost", 9200, "http")));
        SearchRequest searchRequest = new SearchRequest("my_index");
        // 这里的searchSourceBuilder 相当于 query:{}
        SearchSourceBuilder searchSourceBuilder = new SearchSourceBuilder();
        // query:{term:{"field_name":"field_value"}}
        searchSourceBuilder.query(QueryBuilders.termQuery("field_name", "field_value"));
        searchSourceBuilder.timeout(new TimeValue(60, TimeUnit.SECONDS));
        searchRequest.source(searchSourceBuilder);
        // 执行查询
        SearchResponse searchResponse = client.search(searchRequest, RequestOptions.DEFAULT);
        // TODO: 解析搜索结果
        client.close();
    }
}

Terms-匹配多个值

term查询只能用于匹配该属性的单个值，若想匹配多个值，可以用terms查询

基本语法

GET /{index}/_search
{
    "query": {
        "terms": {
            "{field}": [
                "{value1}",
                "{value2}",
                "{value3}"
            ]
        }
    }
}

Java写法

SearchRequest searchRequest = new SearchRequest("index");
SearchSourceBuilder searchSourceBuilder = new SearchSourceBuilder();
// 注意这里是使用termsQuery("field",value1,value2)
TermsQueryBuilder termsQueryBuilder = QueryBuilders.termsQuery("field", "value1", "value2", "value3");
searchSourceBuilder.query(termsQueryBuilder);
searchRequest.source(searchSourceBuilder);
SearchResponse searchResponse = client.search(searchRequest, RequestOptions.DEFAULT);