I have an element that seems to be holding old table data that no longer exists. Is there a delete statement or command that can be used with Cassandra to delete data for a specific element and /or a specific table from an element?
Marieke Goethals [SLC] [DevOps Catalyst] Selected answer as best 18th July 2023
Hi Nigel, some protocols have the "Clear Missing" command in the element card, on the top of the table - this helps when clearing rows related to e.g. input feeds no longer existing on the device - some have also an Auto-Remove feature.
If data is no longer on the element, but just stored within the local DB of the DMA, you'd need the Cassandra query to remove it - is it trend or alarms?
Best checked with your deploy-squad I guess.
Marieke Goethals [SLC] [DevOps Catalyst] Selected answer as best 18th July 2023