Elasticsearch Examples

最新推荐文章于 2024-10-11 08:14:04 发布

hyx216

最新推荐文章于 2024-10-11 08:14:04 发布

阅读量227

点赞数

分类专栏： Elasticsearch

本文链接：https://blog.youkuaiyun.com/hyx216/article/details/88663706

版权

Elasticsearch 专栏收录该内容

4 篇文章

订阅专栏

博客给出了两个Elasticsearch查询示例。一是Nested Exist查询，用于查看33账号follow_status不存在的用户信息列表；二是获取主文档和子文档字段，使用has_child和inner_hits，结合多个条件进行查询，如mid、source_channel_id等。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

1、Nested Exist 查询

查看33账号follow_status不存在的用户信息列表

curl -X POST "localhost:9200/*/wechat_customer/_search"

{
   "_source": ["nickname", "openid", "follow_status"],
   "query": {
       "filtered": {
           "filter": {
               "bool": {
                   "must": [{
                       "term": {
                           "mid": "33"
                       }
                   }],
                   "must_not": [{
                       "nested": {
                           "path": "follow_status",
                           "query": {
                               "filtered": {
                                   "filter": {
                                       "exists": {
                                           "field": "follow_status.start_intdate"
                                       }
                                   }
                               }
                           }

                       }
                   }]
               }
           }
       }
   }
}

2、获取主文档和子文档的字段，has_child 和 inner_hits

{
"_source":["id","openid","nickname","headimgurl","city","province","country","subscribe_time","action_count","source_type","source_value"],
   "query": {
       "filtered": {
           "filter": {
               "bool": {
                   "must": [ {
                       "term": {
                           "mid": "33"
                       }
                   },{
                       "term": {
                           "source_channel_id": "0"
                       }
                   },{
                   "has_child": {
                   "type":"user_action_record_others",
                   "inner_hits":{
                   "sort":{"create_time":{"order":"desc"}},
                   "_source":["create_time"],
                   "size":1
                   },
                  "query": {
                           "filtered": {
                               "filter": {
                                   "bool": {
                                       "must": [ {
                                           "term": {
                                               "wid": "33"
                                           }
                                       },{
                                       "term": {
                                           "type": "qrcode_scan"
                                       }
                                           },{
                                               "term": {
                                                   "keyword": "9173"
                                               }
                                           }]
                                   }
                               }
                           }
                       }
                   }
                   }]
               }
           }
       }
   }
}