索引较多:
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" } } } }