is there a way to delete a view rows matching a query in QuestDB? I can't find any statement allowing me that. This would be the best option: delete from mytable where columnvalue==2; Thanks!

I've seen few places which give definition of time-series cardinality similar to: Assume you have 1000 IoT devices in 20 locations, they're running one of 5 firmware versions, and report input fro...