ES根据某个字段查询重复数据
对应查询语句:
{
"size": 0,
"aggs": {
"unique_field_values": {
"terms": {
"field": "param",
"min_doc_count": 2 // 只返回 doc_count 大于1的项
}
}
}
}
mysql去重语句: select param, count(*) from gz_verify group by param having count(param) > 1;