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? >> > >