I have created an elasticsearch (version -6.3) domain in AWS and there is only one index(mindtrace) to which data gets streamed. I need to delete the data in the index for particular time and i tried using below delete query
POST mindtrace/_delete_by_query
{
"query": {
"range" : {
"@timestamp" : {
"gte" : "2019-08-15T00:00:00Z",
"lte" : "2019-08-20T00:00:00Z",
"format": "yyyy-MM-dd'T'HH:mm:ssz"
}
}
}
}
Once i run the query in DEV Tools of kibana I get the below results
{
"took": 6,
"timed_out": false,
"total": 0,
"deleted": 0,
"batches": 0,
"version_conflicts": 0,
"noops": 0,
"retries": {
"bulk": 0,
"search": 0
},
"throttled_millis": 0,
"requests_per_second": -1,
"throttled_until_millis": 0,
"failures":
}
Deleted shows 0. No documents are deleted
Please help me with this to delete index data for particular dates or retaining since 15 days and deleting remaining data