RE: TTL can't be speciefied at column level using CQL 3 in Cassandra 1.2.x

2013-06-19 Thread Amresh Kumar Singh
m: Sylvain Lebresne [sylv...@datastax.com] Sent: Wednesday, June 19, 2013 3:45 PM To: user@cassandra.apache.org Subject: Re: TTL can't be speciefied at column level using CQL 3 in Cassandra 1.2.x Hi, > But CQL3 doesn't provide a way for this. That's not true. But the syntax is probably a

Re: TTL can't be speciefied at column level using CQL 3 in Cassandra 1.2.x

2013-06-19 Thread Sylvain Lebresne
Hi, > But CQL3 doesn't provide a way for this. That's not true. But the syntax is probably a bit more verbose than what you were hoping for. Your example (where I assume user_name is you partition key) can be achieved with: BEGIN BATCH UPDATE users SET password = 'aa' WHERE user_name='x

TTL can't be speciefied at column level using CQL 3 in Cassandra 1.2.x

2013-06-19 Thread Amresh Kumar Singh
Hi, Using Thrift, we are allowed to specify different TTL values for each columns in a row. But CQL3 doesn't provide a way for this. For instance, this is allowed: INSERT INTO users (user_name, password, gender, state) VALUES ('xamry2, 'aa', 'm', 'UP') using TTL 5; But something like