Elasticsearch按照某个字段去重查询

索引较多：

da-1_t_d_order

da-2_t_d_order

da-32_t_d_order

根据order_no去重。

说明：
1、collapse：去重得到去重后的记录，配合"from": 0, "size": 1分页得到结果

2、cardinality：去重得到统计结果

GET /da-*_t_d_order/_search
{
  "from": 0,
  "size": 1,
  "track_total_hits": true,
  "query": {
    "bool": {
      "filter": [
        {
          "range": {
            "push_time": {
              "gte": "2022-02-08",
              "lte": "2022-02-09",
              "time_zone": "+08:00"
            }
          }
        },
        {
          "terms": {
            "org_code.keyword": [
              "00Y0024",
              "00Y0924"
            ]
          }
        }
      ]
    }
  },
  "collapse": {
    "field": "order_no.keyword"
  },
  "aggregations": {
    "count": {
      "cardinality": {
        "field": "order_no.keyword"
      }
    }
  }
}

 参考：官方文档1      官方文档2