let previous15Min = now - 15 mins SELECT * FROM client_data WHERE client_id = 1 and last_modified_date >= previous15Min
Same thing for last 5 mins On Wed, Sep 24, 2014 at 12:32 AM, Check Peck <comptechge...@gmail.com> wrote: > Yes I can provide client_id in my where clause. So now my query pattern > will be - > > Give me everything for what has changed within last 15 minutes or 5 > minutes whose client_id is equal to 1? > > How does my query will look like then? > > > On Tue, Sep 23, 2014 at 3:26 PM, DuyHai Doan <doanduy...@gmail.com> wrote: > >> It is possible to request a "range" of data according to the >> last_modified_date but you still need to provide the client_id , the >> partition key, in any case >> >> >> On Wed, Sep 24, 2014 at 12:23 AM, Check Peck <comptechge...@gmail.com> >> wrote: >> >>> I have a table structure like below - >>> >>> CREATE TABLE client_data ( >>> client_id int, >>> consumer_id text, >>> last_modified_date timestamp, >>> PRIMARY KEY (client_id, last_modified_date, consumer_id) >>> ) >>> >>> I have a query pattern like this - Give me everything for what has >>> changed withing last 15 minutes or 5 minutes? Is this possible to in CQL >>> with the above tables? >>> >> >> >