Re: Querying key cache

2017-09-14 Thread Jeff Jirsa
Could keep another table and insert into it IF NOT EXISTS. If the insert is applied, you can act on it (perhaps inserting with a column indicating you're starting the action). When complete you can update the column to indicate completion Of course this all sounds queue-like, sometimes it's bet

Re: Querying key cache

2017-09-14 Thread Jagadeesh Mohan
This is our use case. We would like to store series of events, and act on event only once(dedup or abnormal event for same event id is expected to be dropped). Thought of using key cache to check and insert. Would you suggest any other work around? On Fri, Sep 15, 2017 at 11:10 AM, Jeff Jirsa wro

Re: Querying key cache

2017-09-14 Thread Jeff Jirsa
> On Sep 14, 2017, at 10:31 PM, Jagadeesh Mohan > wrote: > > Hi, > I would like to know if there is a way to query key cache. No > Follow up question: Is there a way to use presence of key in key cache in > conditional updates. No > > Primary Use case is to figure out the dedup of t

Querying key cache

2017-09-14 Thread Jagadeesh Mohan
Hi, I would like to know if there is a way to query key cache. Follow up question: Is there a way to use presence of key in key cache in conditional updates. Primary Use case is to figure out the dedup of the data. -- With Regards, Jagadeesh