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 >