Question

elasticSearch用java查询问题

如下sql 用 ES 的java API 如何实现
sql:
select c,d from my_table where a = 1
and (b = 2 or b=3)
group by c,d

请大神优先回答 括号 or 的实现吧

Answer 1

你这个查询用filter、must皆可，推荐filter

String index = "indexName"; // 你的index名称
String type = "my_table";

BoolQueryBuilder boolQuery = QueryBuilders.boolQuery();
// boolQuery.must(QueryBuilders.termQuery("a", 1));
// boolQuery.must(QueryBuilders.termsQuery("b", 2, 3));
boolQuery.filter(QueryBuilders.termQuery("a", 1));
boolQuery.filter(QueryBuilders.termsQuery("b", 2, 3));

SearchResponse searchResponse = client.prepareSearch(index).setTypes(type)
                                                .setQuery(boolQuery)
                                                .addSort("c", SortOrder.ASC)
                                                .addSort("d", SortOrder.ASC)
                                                .storedFields("c", "d")
                                                .get();

Answer 2

查询器里的should是或，must是且