Re: The changing clustering key

2017-04-06 Thread Monmohan Singh
a on that portion in > descending order by mod_date. > > > > For a normal loopkup you do not need to know mod_date, a simple SELECT * > FROM users WHERE dept_id=foo and user_id=bar LIMIT 1 will do. > > > > http://datascale.io/cassandra-partitioning-and-clustering-keys-expla

Re: The changing clustering key

2017-04-06 Thread Monmohan Singh
te desc) > > On Thu, Apr 6, 2017 at 5:54 AM Monmohan Singh wrote: > > Dear Cassandra experts, > I have a data modeling question for cases where data needs to be sorted by > keys which can be modified. > So , say we have a user table > { >dept_id text, >us

The changing clustering key

2017-04-06 Thread Monmohan Singh
Dear Cassandra experts, I have a data modeling question for cases where data needs to be sorted by keys which can be modified. So , say we have a user table { dept_id text, user_id text, user_name text, mod_date timestamp PRIMARY KEY (dept_id,user_id) } Now I can query cassandra to g