Delete ES data by query
Apr 8, 2021
- 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"
}
}
]
}
}
}