With the newest versions of Cassandra, cql is not hanging, but returns the
same Invalid Query Exception you are seeing through hector. I would assume
from the exception that 630720000 is in fact that largest TTL you can use.
What are you doing that you need to set a TTL of approximately 30 years?
On Fri, Nov 21, 2014 at 11:29 AM, 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
>
