elasticsearch 聚合查询

1.查看一天时间内，ip的去重总数

post hqbuy_event_tracking-*/_search
{
  "query":{
    "range": {
      "create_timestamp": {
        "gte": 1702310400,
        "lt": 1702396800
      }
    }
  },
  "size":0,
  "aggs": {
   "group": {
     "cardinality": {
       "field": "ip"
     }
   }
 }
}

 2. 统计sku_goods索引中SpecItems.SpecValue 字段有值的总数，SpecItems属于nested类型

# 统计nested子对象中,SpecValue字段有值的数据总数
POST /sku_goods/_search
{
  "size":0,
  "aggs": {
    "count": {
      "nested": {
        "path": "SpecItems"
      },
      "aggs": {
        "specvalue_count": {
          "value_count": {
            "field": "SpecItems.SpecValue"
          }
        }
      }
    }
  }
}