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 <lah...@highfive.com> wrote: > You have to use with default_time_to_live = 7200. > > On Wed, Oct 26, 2016 at 8:07 AM, techpyaasa . <techpya...@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