es练习册

最新推荐文章于 2022-10-08 18:07:37 发布

J练习生

最新推荐文章于 2022-10-08 18:07:37 发布

阅读量316

点赞数

分类专栏： JAVA 文章标签： elasticsearch 大数据搜索引擎

本文链接：https://blog.csdn.net/m0_51458935/article/details/126680688

版权

JAVA 专栏收录该内容

27 篇文章 0 订阅

订阅专栏

GET bank/_search
{
“query”: {
“match”: {
“account_number” : 248
}
},
“sort”: [
{
“balance”: {
“order”: “desc”
}
}
],
“from”: 0,
“size”: 5,
“_source”: [“account_number”,“balance”,“firstname”,“lastname”,“age”,“gender”,“address”,“employer”,“email”,“city”]

}

GET bank/_search
{
“query”: {
“match”: {
“address”: “Hendrickson Street”
}
}
}

GET bank/_search
{
“query”: {
“match_phrase”: {
“address”: “Hendrickson Street”
}
}
}

GET bank/_search
{
“query”: {
“multi_match”: {
“query”: “mill Lopezo”,
“fields”: [“address”,“city”]
}
}
}

GET bank/_search
{
“query”: {
“bool”: {
“must”: [
{“match”: {
“gender”: “M”
}},
{“match”: {
“address”: “Mill”
}}
],
“must_not”: [
{“match”: {
“age”: “28”
}}
],
“should”: [
{“match”: {
“lastname”: “Wallace”
}}
]
}
}
}

GET bank/_search
{
“query”: {
“bool”: {
“must”: [
{“range”: {
“age”: {
“gte”: 18,
“lte”: 30
}
}}
]
}
}
}

GET bank/_search
{
“query”: {
“bool”: {
“filter”: [
{“range”: {
“age”: {
“gte”: 18,
“lte”: 30
}
}}
]
}
}
}

GET bank/_search
{
“query”: {
“match”: {
“address”: “mill”
}
},
“aggs”: {
“ageAgg”: {
“terms”: {
“field”: “age”,
“size”: 10
}
},
“ageAvg”: {
“avg”: {
“field”: “age”
}
}
}
}

GET bank/_search
{
“query”: {
“match_all”: {}
},
“aggs”: {
“ageAgg”: {
“terms”: {
“field”: “age”,
“size”: 100
},
“aggs”: {
“balanceAvg”: {
“avg”: {
“field”: “balance”
}
}
}
}
}
}

GET bank/_search
{
“query”: {
“match_all”: {}
},
“aggs”: {
“ageAgg”: {
“terms”: {
“field”: “age”,
“size”: 100
},
“aggs”: {
“balanceAvg”: {
“terms”: {
“field”: “gender.keyword”,
“size”: 100
},
“aggs”: {
“balanceAvg”: {
“avg”: {
“field”: “balance”
}
}
}
}
}
}
}
}