java - 如何在 ElasticSearch 和 Java 中进行 AND + OR 查询

Question

我正在尝试在 SQL 中执行与以下操作等效的 Elastic:

select * from Pets 
where type is 'cat'
and age > 10
and name in ("Barry", "Oscar", .....)  

我有以下 Java 代码:

SearchRequest searchRequest = new SearchRequest(elasticIndexName);
BoolQueryBuilder queryBuilder = QueryBuilders.boolQuery();
queryBuilder.must(QueryBuilders.termQuery("type", "cat"));
queryBuilder.must(QueryBuilders.rangeQuery("age").from("10"));
queryBuilder.must(QueryBuilders.termQuery("name", "Oscar"));
queryBuilder.must(QueryBuilders.termQuery("name", "Barry"));

但是，如果我理解正确的话，最后两个“必须”的陈述是相互矛盾的。我尝试使用“应该”一词，但它似乎带来了所有猫的名字。

Answer 1

你就快到了，你需要这样做(即使用 terms 查询):

SearchRequest searchRequest = new SearchRequest(elasticIndexName);
BoolQueryBuilder queryBuilder = QueryBuilders.boolQuery();
queryBuilder.must(QueryBuilders.termQuery("type", "cat"));
queryBuilder.must(QueryBuilders.rangeQuery("age").from("10"));
queryBuilder.must(QueryBuilders.termsQuery("name", "Oscar", "Barry"));