Thanks.Actually i want to start ttl from the record timestamp field, not
from insertion time(ttl starts from insertion time).
On Mon, Aug 8, 2016 at 9:36 PM, <sean_r_dur...@homedepot.com> wrote:
> Perhaps you can set the default TTL when you create the table instead of
> on every insert:
>
> http://docs.datastax.com/en/cql/3.1/cql/cql_reference/tabProp.html
>
> (see default_time_to_live property)
>
>
>
> Then no need for UDF.
>
>
>
>
>
> Sean Durity
>
> lord of the (C*) rings (Lead Cassandra Admin)
>
> Big DATA Team
>
> MTC 2250
>
> #cassandra - for the latest news and updates
>
>
>
> *From:* Sujeet Kumar [mailto:genioussuj...@gmail.com]
> *Sent:* Monday, August 08, 2016 11:18 AM
> *To:* user@cassandra.apache.org
> *Subject:* setting ttl using timestamp field of record during insertion
> in cassandra
>
>
>
> Hi
>
>
>
> I want to set TTL 30 days from the time field of table
> record(id,name,time) during insertion.For this I am creating a User Defined
> Function(UDF) bigint fun(rTime,cTime) as
>
>
>
> CREATE FUNCTION fun(rtime timestamp,ctime timestamp) CALLED ON NULL INPUT
> RETURNS bigint LANGUAGE java as 'return 2592000-((ctime.toTime()
> -rtime.toTime())/1000);';
>
>
>
> here,function fun is calculating the time in seconds this data should
> live.
>
> 2592000 is the time in seconds for 30 days.
>
>
>
> I am trying to use above function for setting TTL as
>
>
>
> INSERT INTO record(id,name,time) VALUES (123,'data123','2016-08-08
> 06:06:00') USING TTL fun('2016-08-08 06:06:00',totimestamp(now()));
>
>
>
> getting error as
>
> Syntax Exception: ErrorMessage code=2000
>
>
>
> Is there any other way to set ttl based on record time field. What is
> problem with above approach.
>
>
>
> Thanks.
>
>
>
> Sujeet
>
>
>
> --
>
>
>
> --
>
> Sujeet Kumar
>
> ME(CSA)
>
> IISc Banglore
>
> sujeet.ku...@csa.iisc.ernet.in
>
> sujeet.cs...@mnnit.ac.in
>
> --
>
> The information in this Internet Email is confidential and may be legally
> privileged. It is intended solely for the addressee. Access to this Email
> by anyone else is unauthorized. If you are not the intended recipient, any
> disclosure, copying, distribution or any action taken or omitted to be
> taken in reliance on it, is prohibited and may be unlawful. When addressed
> to our clients any opinions or advice contained in this Email are subject
> to the terms and conditions expressed in any applicable governing The Home
> Depot terms of business or client engagement letter. The Home Depot
> disclaims all responsibility and liability for the accuracy and content of
> this attachment and for any damages or losses arising from any
> inaccuracies, errors, viruses, e.g., worms, trojan horses, etc., or other
> items of a destructive nature, which may be contained in this attachment
> and shall not be liable for direct, indirect, consequential or special
> damages in connection with this e-mail message or its attachment.
>
--
--
Sujeet Kumar
ME(CSA)
IISc Banglore
sujeet.ku...@csa.iisc.ernet.in
sujeet.cs...@mnnit.ac.in
