| and |
and |
boolQueryBuilder.must(queryBuilder) 计算得分 |
| and |
filter |
boolQueryBuilder.filter(queryBuilder)不计算得分 |
| or |
or |
boolQueryBuilder.should(queryBuilder) |
| ! |
not |
boolQueryBuilder.mustNot(queryBuilder) |
| = |
eq |
term |
| > |
gt |
QueryBuilders.rangeQuery('es field').gt() |
| >= |
ge |
.rangeQuery('es field').gte() |
| < |
lt |
.rangeQuery('es field').lt() |
| <= |
le |
.rangeQuery('es field').lte() |
| like '%field%' |
like |
QueryBuilders.wildcardQuery(field,value) |
| not like '%field%' |
notLike |
must not wildcardQuery(field,value) |
| like '%field' |
likeLeft |
QueryBuilders.wildcardQuery(field,*value) |
| like 'field%' |
likeRight |
QueryBuilders.wildcardQuery(field,value*) |
| between |
between |
QueryBuilders.rangeQuery('es field').from(xx).to(xx) |
| is null |
isNull |
must not QueryBuilders.existsQuery(field) |
| in |
in |
QueryBuilders.termsQuery(" xx es field", xx) |
| group by |
groupBy |
AggregationBuilders.terms() |
| order by |
orderBy |
fieldSortBuilder.order(ASC/DESC) |
| min |
min |
AggregationBuilders.min |
| max |
max |
AggregationBuilders.max |
| avg |
avg |
AggregationBuilders.avg |
| sum |
sum |
AggregationBuilders.sum |
| order by xxx asc |
orderByAsc |
fieldSortBuilder.order(SortOrder.ASC) |
| order by xxx desc |
orderByDesc |
fieldSortBuilder.order(SortOrder.DESC) |
| join |
nested |
QueryBuilders.nestedQuery() |
| - |
match |
matchQuery |
| - |
matchPhrase |
QueryBuilders.matchPhraseQuery |
| - |
matchPrefix |
QueryBuilders.matchPhrasePrefixQuery |
| - |
queryStringQuery |
QueryBuilders.queryStringQuery |
| select * |
matchAllQuery |
QueryBuilders.matchAllQuery() |
| - |
highLight |
HighlightBuilder.Field |