ES 7.7.1 高效delete_by_query

POST /user_profile_daily/_delete_by_query?conflicts=proceed&scroll_size=10000&wait_for_completion=false
{
  "query": {
   "bool": {
      "filter": [
        { "term": { "recordType": "video"   }}
      ],
      "must_not": [
        {"exists": {"field":"startAt"}
      }]
    }
  }
}

GET /_tasks?detailed=true&actions=*/delete/byquery

POST /_tasks/_cancel?actions=*/delete/byquery

GET _sql?format=csv
{
  "query": """
  select count(*)  from user_profile_daily where recordType='video' and startAt is not null limit 10
  """
}