Hi Rajanish, Cassandra imposes a max TTL of 20 years.
public static final int MAX_TTL = 20 * 365 * 24 * 60 * 60; // 20 years in > seconds See: https://github.com/apache/cassandra/blob/8d8fed52242c34b477d0384ba1d1ce3978efbbe8/src/java/org/apache/cassandra/db/ExpiringCell.java#L37 Mark On 21 November 2014 17:29, Rajanish GJ <rajan...@apigee.com> wrote: > > Does hector or cassandra imposes a limit on max ttl value for a column? > > I am trying to insert record into one of the column family and seeing the > following error.. > Cassandra version : 1.1.12 > Hector : 1.1-4 > > Any pointers appreciated. > > me.prettyprint.hector.api.exceptions.HInvalidRequestException: > InvalidRequestException(why:ttl is too large. requested (951027277) maximum > (630720000)) > at > me.prettyprint.cassandra.service.ExceptionsTranslatorImpl.translate(ExceptionsTranslatorImpl.java:52) > ~[hector-core-1.1-4.jar:na] > at > me.prettyprint.cassandra.connection.HConnectionManager.operateWithFailover(HConnectionManager.java:260) > ~[hector-core-1.1-4.jar:na] > at > me.prettyprint.cassandra.model.ExecutingKeyspace.doExecuteOperation(ExecutingKeyspace.java:113) > ~[hector-core-1.1-4.jar:na] > at > me.prettyprint.cassandra.model.MutatorImpl.execute(MutatorImpl.java:243) > ~[hector-core-1.1-4.jar:na] > at > me.prettyprint.cassandra.service.template.AbstractColumnFamilyTemplate.executeBatch(AbstractColumnFamilyTemplate.java:115) > ~[hector-core-1.1-4.jar:na] > at > me.prettyprint.cassandra.service.template.AbstractColumnFamilyTemplate.executeIfNotBatched(AbstractColumnFamilyTemplate.java:163) > ~[hector-core-1.1-4.jar:na] > at > me.prettyprint.cassandra.service.template.ColumnFamilyTemplate.update(ColumnFamilyTemplate.java:69) > ~[hector-core-1.1-4.jar:na] > > ================================= > *Also tried using cql, and it seems to hangs and not responding.. trying > again with few combinations* > > *INSERT INTO users (key,id) values ('test6','951027277 secs') USING > TTL 951027277 ; * > > > > Regards > Rajanish GJ > apigee | rajan...@apigee.com >
