Forum Stats

  • 3,814,069 Users
  • 2,258,814 Discussions
  • 7,892,523 Comments

Discussions

How to delete keys from Distributed Cache with CohQL?

snidely_whiplash
snidely_whiplash Member Posts: 576
edited Oct 25, 2018 1:42PM in Coherence Support

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

Answers