Discussions
Categories
- 17.9K All Categories
- 3.4K Industry Applications
- 3.3K Intelligent Advisor
- 63 Insurance
- 535.7K On-Premises Infrastructure
- 138.1K Analytics Software
- 38.6K Application Development Software
- 5.6K Cloud Platform
- 109.3K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 71K Infrastructure Software
- 105.2K Integration
- 41.5K Security Software
How to delete keys from Distributed Cache with CohQL?

snidely_whiplash
Member Posts: 576
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
Best Answer
-
Solved. There was a trigger that was causing null to be reinserted on delete. Oops.
Answers
-
Solved. There was a trigger that was causing null to be reinserted on delete. Oops.