cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From laxmikanth sadula <laxmikanth...@gmail.com>
Subject Re: Cannot set TTL in COPY command
Date Wed, 26 Oct 2016 15:36:04 GMT
You mean to say instead of
*COPY keyspace1.columnFamily1 FROM 'dump_data.csv' WITH TTL = '7200';*use


*COPY keyspace1.columnFamily1 FROM 'dump_data.csv'
WITH DEFAULT_TIME_TO_LIVE = '7200';*
I tried this way too, but again exception thrown saying "*Unrecognized COPY
FROM options: default_time_to_live*" :( :(

On Wed, Oct 26, 2016 at 8:53 PM, Lahiru Gamathige <lahiru@highfive.com>
wrote:

> You have to use with default_time_to_live = 7200.
>
> On Wed, Oct 26, 2016 at 8:07 AM, techpyaasa . <techpyaasa@gmail.com>
> wrote:
>
>> Hi all,
>>
>> I'm getting following exception when I try to set TTL using COPY command,
>> where as it is working fine without TTL option. Followed doc at
>> https://docs.datastax.com/en/cql/3.1/cql/cql_reference/copy_r.html
>>
>> *"**Improper COPY command.**"*
>>
>> Command used as below
>>
>> *COPY keyspace1.columnFamily1 FROM 'dump_data.csv' WITH TTL = '7200';*
>>
>>
>> Version is as below
>>
>> *[cqlsh 4.1.1 | Cassandra 2.0.17 | CQL spec 3.1.1 | Thrift protocol
>> 19.39.0]*
>>
>>
>> Can some one please tell me how to set TTL using COPY command?
>>
>> Thanks
>> Techpyaasa
>>
>
>


-- 
Regards,
Laxmikanth
99621 38051

Mime
View raw message