How to delete keys from Distributed Cache with CohQL?

snidely_whiplash

Hello,

What's the trick to deleting keys from a cache with CohQL?

CohQL> select count(symbol) from executions

Results

3608

CohQL> select count(symbol) from executions where key().symbol="SPY"

Results

2139

CohQL> delete from executions where key().symbol="SPY"

Results

CohQL> select count(symbol) from executions

Results

3608

snidely_whiplash

Solved.  There was a trigger that was causing null to be reinserted on delete.  Oops.

snidely_whiplash

Solved.  There was a trigger that was causing null to be reinserted on delete.  Oops.