does copy command will clear all the old data?

[Peng Xiao <25...@qq.com>]

Dear All,


I'm trying to import csv file to a table with copy command?The question is:
will the copy command clear all the old data in this table?as we only want to append the csv file to this table


Thanks

回复： does copy command will clear all the old data?

[Peng Xiao <25...@qq.com>]

Thanks Nandan for the confirmation.I also did the test.




------------------ 原始邮件 ------------------
发件人: "@Nandan@"<na...@gmail.com>;
发送时间: 2018年2月13日(星期二) 中午12:52
收件人: "user"<us...@cassandra.apache.org>;

主题: Re: does copy command will clear all the old data?



Hi Peng,Copy command will append upsert all data [based on size] to your existing Cassandra table. Just for testing, I executed before for 500000 data by using COPY command into small cql table and it work very fine. 


Point to make sure :- Please check your primary key before play with COPY command. 


Thanks 




On Tue, Feb 13, 2018 at 12:49 PM, Peng Xiao <25...@qq.com> wrote:
Dear All,


I'm trying to import csv file to a table with copy command?The question is:
will the copy command clear all the old data in this table?as we only want to append the csv file to this table


Thanks

Re: does copy command will clear all the old data?

["@Nandan@" <na...@gmail.com>]

Hi Peng,
Copy command will append upsert all data [based on size] to your existing
Cassandra table. Just for testing, I executed before for 500000 data by
using COPY command into small cql table and it work very fine.

Point to make sure :- Please check your primary key before play with COPY
command.

Thanks


On Tue, Feb 13, 2018 at 12:49 PM, Peng Xiao <25...@qq.com> wrote:

> Dear All,
>
> I'm trying to import csv file to a table with copy command?The question is:
> will the copy command clear all the old data in this table?as we only want
> to append the csv file to this table
>
> Thanks
>