1、高亮查詢
在進行關(guān)鍵字搜索時，搜索出的內(nèi)容中的關(guān)鍵字會顯示不同的顏色，稱之為高亮。
Elasticsearch
可以對查詢內(nèi)容中的關(guān)鍵字部分，進行標(biāo)簽和樣式
(
高亮
)
的設(shè)置。
在使用
match
查詢的同時，加上一個
highlight
屬性：
- pre_tags：前置標(biāo)簽
- post_tags：后置標(biāo)簽
- fields：需要高亮的字段
- title：這里聲明 title 字段需要高亮，后面可以為這個字段設(shè)置特有配置，也可以空
GET /my_index_data/_search
{
"query": {
"match": {
"first_name": "tom6"
}
},
"highlight": {
"pre_tags": "<font color='red'>",
"post_tags": "</font>",
"fields": {
"first_name": {}
}
} }
####結(jié)果
{
"took" : 266,
"timed_out" : false,
"_shards" : {
"total" : 1,
"successful" : 1,
"skipped" : 0,
"failed" : 0
},
"hits" : {
"total" : {
"value" : 1,
"relation" : "eq"
},
"max_score" : 1.7155422,
"hits" : [
{
"_index" : "my_index_data",
"_type" : "_doc",
"_id" : "6",
"_score" : 1.7155422,
"_source" : {
"first_name" : "tom6",
"last_name" : "Smith tom1",
"age" : 39
},
"highlight" : {
"first_name" : [
"<font color='red'>tom6</font>"
]
}
}
]
}
}
2、分頁查詢
from
：當(dāng)前頁的起始索引，默認從
0
開始。
from = (pageNum - 1) * size
size
：每頁顯示多少條
#####模糊查詢first_name為tom 按照age倒敘排序，前兩條數(shù)據(jù)
GET /my_index_data/_search
{
"query": {
"fuzzy": {
"first_name": {
"value": "tom"
}
}
},
"sort": [
{
"age": {
"order": "desc"
}
}
],
"from": 0,
"size": 2
}
########結(jié)果
{
"took" : 44,
"timed_out" : false,
"_shards" : {
"total" : 1,
"successful" : 1,
"skipped" : 0,
"failed" : 0
},
"hits" : {
"total" : {
"value" : 5,
"relation" : "eq"
},
"max_score" : null,
"hits" : [
{
"_index" : "my_index_data",
"_type" : "_doc",
"_id" : "3",
"_score" : null,
"_source" : {
"first_name" : "tom3",
"last_name" : "Smith",
"age" : 39
},
"sort" : [
39
]
},
{
"_index" : "my_index_data",
"_type" : "_doc",
"_id" : "6",
"_score" : null,
"_source" : {
"first_name" : "tom6",
"last_name" : "Smith tom1",
"age" : 39
},
"sort" : [
39
]
}
]
}
}
3、聚合查詢
聚合允許使用者對
es
文檔進行統(tǒng)計分析，類似與關(guān)系型數(shù)據(jù)庫中的
group by
，當(dāng)然還有很
多其他的聚合，例如取最大值、平均值等等。
- 對age取最大值 max
GET /my_index_data/_search
{
"aggs": {
"max_age【別名】": {
"max": {
"field": "age"
}
}
},
"size": 0
}
#結(jié)果
{
"took" : 44,
"timed_out" : false,
"_shards" : {
"total" : 1,
"successful" : 1,
"skipped" : 0,
"failed" : 0
},
"hits" : {
"total" : {
"value" : 8,
"relation" : "eq"
},
"max_score" : null,
"hits" : [ ]
},
"aggregations" : {
"max_age" : {
"value" : 39.0
}
}
}
- 對age取最小值min
GET /my_index_data/_search
{
"aggs": {
"min_age": {
"min": {
"field": "age"
}
}
},
"size": 0
}
###結(jié)果
{
"took" : 7,
"timed_out" : false,
"_shards" : {
"total" : 1,
"successful" : 1,
"skipped" : 0,
"failed" : 0
},
"hits" : {
"total" : {
"value" : 8,
"relation" : "eq"
},
"max_score" : null,
"hits" : [ ]
},
"aggregations" : {
"min_age" : {
"value" : 20.0
}
}
}
- 求和
GET /my_index_data/_search
{
"aggs": {
"ageSum": {
"sum": {
"field": "age"
}
}
},
"size": 0
}
#####求和結(jié)果
{
"took" : 5,
"timed_out" : false,
"_shards" : {
"total" : 1,
"successful" : 1,
"skipped" : 0,
"failed" : 0
},
"hits" : {
"total" : {
"value" : 8,
"relation" : "eq"
},
"max_score" : null,
"hits" : [ ]
},
"aggregations" : {
"ageSum" : {
"value" : 255.0
}
}
}
- 平均值
GET /my_index_data/_search
{
"aggs": {
"ageAvg": {
"avg": {
"field": "age"
}
}
},
"size": 0
}
#平均值
{
"took" : 0,
"timed_out" : false,
"_shards" : {
"total" : 1,
"successful" : 1,
"skipped" : 0,
"failed" : 0
},
"hits" : {
"total" : {
"value" : 8,
"relation" : "eq"
},
"max_score" : null,
"hits" : [ ]
},
"aggregations" : {
"ageAvg" : {
"value" : 31.875
}
}
}
- 數(shù)據(jù)總數(shù)count
GET /my_index_data/_search
{
"aggs": {
"count": {
"value_count": {
"field": "age"
}
}
},
"size": 0
}
####結(jié)果
{
"took" : 35,
"timed_out" : false,
"_shards" : {
"total" : 1,
"successful" : 1,
"skipped" : 0,
"failed" : 0
},
"hits" : {
"total" : {
"value" : 8,
"relation" : "eq"
},
"max_score" : null,
"hits" : [ ]
},
"aggregations" : {
"count" : {
"value" : 8
}
}
}
- 數(shù)據(jù)總數(shù)count (去重之后)
GET /my_index_data/_search
{
"aggs": {
"distinct_age": {
"cardinality": {
"field": "age"
}
}
},
"size": 0
}
####結(jié)果
{
"took" : 35,
"timed_out" : false,
"_shards" : {
"total" : 1,
"successful" : 1,
"skipped" : 0,
"failed" : 0
},
"hits" : {
"total" : {
"value" : 8,
"relation" : "eq"
},
"max_score" : null,
"hits" : [ ]
},
"aggregations" : {
"distinct_age" : {
"value" : 6
}
}
}
4、State 聚合
stats
聚合，對某個字段一次性返回
count
，
max
，
min
，
avg
和
sum
五個指標(biāo)
GET /my_index_data/_search
{
"aggs":{
"stats_age":{
"stats":{"field":"age"}
}
},
"size":0
}
####結(jié)果
{
"took" : 9,
"timed_out" : false,
"_shards" : {
"total" : 1,
"successful" : 1,
"skipped" : 0,
"failed" : 0
},
"hits" : {
"total" : {
"value" : 8,
"relation" : "eq"
},
"max_score" : null,
"hits" : [ ]
},
"aggregations" : {
"stats_age" : {
"count" : 8,
"min" : 20.0,
"max" : 39.0,
"avg" : 31.875,
"sum" : 255.0
}
}
}
5、桶聚合查詢
桶聚和相當(dāng)于
sql
中的
group by
語句
terms
聚合，分組統(tǒng)計
#####對age group by
GET /my_index_data/_search
{
"aggs":{
"age_groupby":{
"terms":{"field":"age"}
}
},
"size":0
}
########結(jié)果
{
"took" : 26,
"timed_out" : false,
"_shards" : {
"total" : 1,
"successful" : 1,
"skipped" : 0,
"failed" : 0
},
"hits" : {
"total" : {
"value" : 8,
"relation" : "eq"
},
"max_score" : null,
"hits" : [ ]
},
"aggregations" : {
"age_groupby" : {
"doc_count_error_upper_bound" : 0,
"sum_other_doc_count" : 0,
"buckets" : [
{
"key" : 30,
"doc_count" : 2
},
{
"key" : 39,
"doc_count" : 2
},
{
"key" : 20,
"doc_count" : 1
},
{
"key" : 29,
"doc_count" : 1
},
{
"key" : 33,
"doc_count" : 1
},
{
"key" : 35,
"doc_count" : 1
}
]
}
}
}
文章來源地址http://www.zghlxwxcb.cn/news/detail-400623.html
文章來源：http://www.zghlxwxcb.cn/news/detail-400623.html
到了這里，關(guān)于七、ElasticSearch-高級查詢操作三的文章就介紹完了。如果您還想了解更多內(nèi)容，請在右上角搜索TOY模板網(wǎng)以前的文章或繼續(xù)瀏覽下面的相關(guān)文章，希望大家以后多多支持TOY模板網(wǎng)！
