本章内容概述
1、各种query查询
2、聚合查询
1、各种query查询
range限定范围查询
//查询出生年月在1980-01-22 到 1990-12-12之间的用户
RangeQueryBuilder builder = QueryBuilders.rangeQuery("birthday")
.from("1980-01-22")
.to("1990-12-12")
.format("yyyy-MM-dd");
SearchResponse response = client.prepareSearch("lib3")
.setQuery(builder)
.get();
prefix前缀查询
//查询姓名以"赵"开头的用户
PrefixQueryBuilder builder = QueryBuilders.prefixQuery("name", "赵");
wildcard通配符查询
//查询姓名中包含"明"的用户
WildcardQueryBuilder builder = QueryBuilders.wildcardQuery("name", "明");
fuzzy模糊查询
//查询爱好中包含"change"的用户
FuzzyQueryBuilder builder = QueryBuilders.fuzzyQuery("interests", "change");
type
//根据类型进行查询
TypeQueryBuilder builder = QueryBuilders.typeQuery("user");
ids查询
//根据多个id查询
IdsQueryBuilder builder = QueryBuilders.idsQuery().addIds("1","3","7");
2、聚合查询
2.1 求最大值
AggregationBuilder agg = AggregationBuilders.max("aggMax").field("age");
SearchResponse response =
client.prepareSearch("lib3").addAggregation(agg).get();
//获取最大值对象
Max max = response.getAggregations().get("aggMax");
System.out.println(max.getValue());
2.2 求最小值
AggregationBuilder agg = AggregationBuilders.max("aggMin").field("age");
SearchResponse response = client.prepareSearch("lib3").addAggregation(agg).get();
//获取最大值对象
Min min = response.getAggregations().get("aggMin");
System.out.println(min.getValue());
2.3 求平均值
AggregationBuilder agg = AggregationBuilders.max("aggAvg").field("age");
SearchResponse response =
client.prepareSearch("lib3").addAggregation(agg).get();
//获取最大值对象
Avg avg = response.getAggregations().get("aggAvg");
System.out.println(avg.getValue());
2.4 求和
AggregationBuilder agg = AggregationBuilders.max("aggSum").field("age");
SearchResponse response =
client.prepareSearch("lib3").addAggregation(agg).get();
//获取最大值对象
Sum sum = response.getAggregations().get("aggSum");
System.out.println(sum.getValue());
2.5 基数查询
AggregationBuilder agg = AggregationBuilders.cardinality("aggCardinality").field("age");
SearchResponse response =
client.prepareSearch("lib3").addAggregation(agg).get();
//获取最大值对象
Cardinality cardinality = response.getAggregations().get("aggCardinality");
System.out.println(cardinality.getValue());