【ElasticSearch】去掉重复数据

【ElasticSearch】去掉重复数据

https://blog.csdn.net/qq_33697094/article/details/109735592

https://blog.csdn.net/qq_33697094/article/details/109735592

https://blog.51cto.com/u_14886891/5289676

https://blog.csdn.net/wslyk606/article/details/84315862

GET station_template_access2023/_search
{
  "from": 0,
  "size": 0,
  "query": {
    "bool": {
      "must": [
        {
          "term": {
            "siteId": {
              "value": "1298113079338340354",
              "boost": 1
            }
          }
        },
        {
          "range": {
            "accessTime": {
              "from": "2023-01-01 00:00:00",
              "to": "2023-01-05 23:59:59",
              "include_lower": true,
              "include_upper": true,
              "boost": 1
            }
          }
        }
      ],
      "adjust_pure_negative": true,
      "boost": 1
    }
  },
  "aggregations": {
    "pvCount": {
      "value_count": {
        "field": "id"
      }
    }
  }
}

 

GET station_template_access2023/_search
{
  "from": 0,
  "size": 0,
  "query": {
    "bool": {
      "must": [
        {
          "term": {
            "siteId": {
              "value": "1298113079338340354",
              "boost": 1
            }
          }
        },
        {
          "range": {
            "accessTime": {
              "from": "2023-01-01 00:00:00",
              "to": "2023-01-05 23:59:59",
              "include_lower": true,
              "include_upper": true,
              "boost": 1
            }
          }
        }
      ],
      "adjust_pure_negative": true,
      "boost": 1
    }
  },
  "aggregations": {
    "group_cat_id": {
      "terms": {
        "field": "catId",
        "size": 10
      },
      "aggs": {
        "uvCount": {
          "cardinality": {
            "field": "accessIp"
          }
        }
      }
    }
  }
}