default_time_to_live vs TTL on insert statement

2018-07-11 Thread Nitan Kainth
Hi, As per document: https://docs.datastax.com/en/cql/3.3/cql/cql_using/useExpireExample.html - You can set a default TTL for an entire table by setting the table's default_time_to_live

Re: default_time_to_live vs TTL on insert statement

2018-07-11 Thread DuyHai Doan
default_time_to_live property applies if you don't specify any TTL on your CQL statement However you can always override the default_time_to_live

Re: default_time_to_live vs TTL on insert statement

2018-07-11 Thread Nitan Kainth
Hi DuyHai, Could you please explain in what case C* will error based on documented statement: You can set a default TTL for an entire table by setting the table's default_time_to_live propert

Re: default_time_to_live vs TTL on insert statement

2018-07-11 Thread kurt greaves
The Datastax documentation is wrong. It won't error, and it shouldn't. If you want to fix that documentation I suggest contacting Datastax. On 11 July 2018 at 19:56, Nitan Kainth wrote: > Hi DuyHai, > > Could you please explain in what case C* will error based on documented > statement: > > You

Re: default_time_to_live vs TTL on insert statement

2018-07-12 Thread Nitan Kainth
Kurt, It is same mentioned on apache docuemtation too, I am not able to find it right now. But my question is: How to set TTL for a whole column? On Wed, Jul 11, 2018 at 11:36 PM, kurt greaves wrote: > The Datastax documentation is wrong. It won't error, and it shouldn't. If > you want to fix

Re: default_time_to_live vs TTL on insert statement

2018-07-12 Thread DuyHai Doan
To set TTL on a column only and not on the whole CQL row, use UPDATE instead: UPDATE USING TTL xxx SET = WHERE partition=yyy On Thu, Jul 12, 2018 at 2:42 PM, Nitan Kainth wrote: > Kurt, > > It is same mentioned on apache docuemtation too, I am not able to find it > right now. > > But my questi

Re: default_time_to_live vs TTL on insert statement

2018-07-12 Thread Nitan Kainth
Okay so it means regular update and any ttl set with write overrides default setting. Which means datastax documentation is incorrect and should be updated. Sent from my iPhone > On Jul 12, 2018, at 9:35 AM, DuyHai Doan wrote: > > To set TTL on a column only and not on the whole CQL row, use U