I am using druid 0.8.3 and I followed below steps to delete my data older than 1 hour.
Deleted segments entries from segments table with used = 0 field.
Deleted all segments from deep storage (local file system)
Deleted data from basePersist directory (realtime data)
After deleting data from every possible location, my query still returns the data that is deleted.
Is druid storing any data in-memory (cache) ? As I have set druid.cache.sizeInBytes = 0 sdfsdsdf
Note: I restarted druid cluster nodes after following these 3 steps, in this case query was not returning any data ( which was expected result), so druid must be storing something in-memory.
Hoping for quick reply.