Delete ES data by query

Rahul Kumar
Apr 8, 2021

--

  1. Delete between timeStamp range
curl -XPOST "https://domain-url/index-name/_delete_by_query?pretty" -H 'Content-Type: application/json'  -d '
{
"query": {
"range" : {
"timeStamp" : {
"gte" : 1617820217000,
"lte" : 1617858017000
}
}
}
}'

2. Delete between timeStamp range and with a match query on cameraId:

curl -XPOST "https://domain-url/index-name/_delete_by_query?pretty" -H 'Content-Type: application/json'  -d '{"query":{"bool":{"must":[{"range":{"timeStamp":{"gte":1621276200000,"lte":1621323000000}}},{"match":{"cameraId":"camera-name"}}]}}}'

3.

curl -XPOST "https://domain-url/index-name/_delete_by_query?pretty" -H 'Content-Type: application/json'  -d '
{
"query": {
"bool": {
"must": [
{
"range": {
"timeStamp": {
"gte": 1621276200000,
"lte": 1621323000000
}
}
},
{
"match": {
"cameraId": "camera-name"
}
}
]
}
}
}

--

--

Rahul Kumar
Rahul Kumar

No responses yet