elasticsearch常用操作之QueryBuilders范围时间组合查询

1.BoolQuery( ) 用于组合多个叶子或复合查询子句的默认查询

• must 相当于 与 & =

• must not 相当于 非 ~ ！=

• should 相当于 或 | or

• filter 过滤

  boolQuery().must(termQuery("content", "query1")) .must(termQuery("content", "query2")) .mustNot(termQuery("content", "query3")) .should(termQuery("content", "query4")) .filter(termQuery("content", "query5"));

2.精确查询

以下字段名用 ${fieldName} 代替，具体值用 ${fieldValue} 代替

数字查询

//单个
QueryBuilder qb1 = QueryBuilders.termQuery("${fieldName}", "${fieldValue}");
 
//批量
QueryBuilder qb1 = QueryBuilders.termsQuery("${fieldName}", "${fieldValues}");

字符串查询

//单个
QueryBuilder qb1 = QueryBuilders.termQuery("${fieldName}.keyword", "${fieldValue}");
 
//批量
QueryBuilder qb1 = QueryBuilders.termsQuery("${fieldName}.keyword", "${fieldValues}");

3.模糊查询

数字

数字查询只能是精确查询

字符串

QueryBuilder qb1 = QueryBuilders.moreLikeThisQuery(
                                                    new String[]{"${fieldName}"}, 
                                                    new String[]{"${fieldValue}"}, null);

4.范围查询

数字

//闭区间查询
QueryBuilder qb1 = QueryBuilders.rangeQuery("${fieldName}").from(${fieldValue1}).to(${fieldValue2}); 
 
//开区间查询
QueryBuilder qb1 = QueryBuilders.rangeQuery("${fieldName}").from(${fieldValue1}, false).to(${fieldValue2}, false);
 
//大于
QueryBuilder qb1 = QueryBuilders.rangeQuery("${fieldName}").gt(${fieldValue});
 
 //大于等于
QueryBuilder qb1 = QueryBuilders.rangeQuery("${fieldName}").gte(${fieldValue}); 
 
//小于
QueryBuilder qb1 = QueryBuilders.rangeQuery("${fieldName}").lt(${fieldValue}); 
 
//小于等于
QueryBuilder qb1 = QueryBuilders.rangeQuery("${fieldName}").lte(${fieldValue});

5.多条件查询

QueryBuilder qb1 = QueryBuilders.moreLikeThisQuery(new String[]{"${fieldName1}"}, new String[]{"${fieldValue1}"}, null);
QueryBuilder qb2 = QueryBuilders.rangeQuery("${fieldName2}").gt("${fieldValue2}");
QueryBuilder qb3 = QueryBuilders.boolQuery().must(qb1).must(qb2);