Re: Fwd: Re: cassandra update vs insert + delete

2018-05-30 Thread Rahul Singh
using Zoho Mail > > > Forwarded message > From : Jonathan Haddad > To : > Date : Mon, 28 May 2018 00:07:36 +0430 > Subject : Re: cassandra update vs insert + delete > Forwarded message > > > What is a “soft delete”? > > >

答复: 答复: Re: cassandra update vs insert + delete

2018-05-28 Thread Xiangfei Ni
8年5月28日 14:42 收件人: user <user@cassandra.apache.org> 主题: Fwd: 答复: Re: cassandra update vs insert + delete It seems that i can't update a part of primary key in cqlsh update: message "PRIMARY Key part column found in SET part" Sent using Zoho Mail<https://www.zoho.com/mail/&

Fwd: 答复: Re: cassandra update vs insert + delete

2018-05-28 Thread onmstester onmstester
er@cassandra.apache.org Date : Mon, 28 May 2018 11:04:06 +0430 Subject : 答复: Re: cassandra update vs insert + delete Forwarded message Yes, you are correct. Best Regards, 倪项菲/ David Ni 中移德电网络科技有限公司 Virtue Intelligent Network Ltd, co. Add: 2003,20F No.35 Luo

答复: Re: cassandra update vs insert + delete

2018-05-28 Thread Xiangfei Ni
<user@cassandra.apache.org> 主题: Fwd: Re: cassandra update vs insert + delete How update is working underneath? Does it create a new row (because i'm changing a column of partition key) and add a tombstone to the old row? Sent using Zoho Mail<https://www.zoho.com/mail/>

Fwd: Re: cassandra update vs insert + delete

2018-05-28 Thread onmstester onmstester
org Date : Mon, 28 May 2018 00:07:36 +0430 Subject : Re: cassandra update vs insert + delete Forwarded message What is a “soft delete”? My 2 cents, if you want to update some information just update it. There’s no need to overthink it. Batches are good if they

Re: cassandra update vs insert + delete

2018-05-27 Thread Jonathan Haddad
What is a “soft delete”? My 2 cents, if you want to update some information just update it. There’s no need to overthink it. Batches are good if they’re constrained to a single partition, not so hot otherwise. On Sun, May 27, 2018 at 8:19 AM Rahul Singh wrote: >

Re: cassandra update vs insert + delete

2018-05-27 Thread Rahul Singh
Deletes create tombstones — not really something to consider. Better to add / update or insert data and do a soft delete on old data and apply a TTL to remove it at a future time. -- Rahul Singh rahul.si...@anant.us Anant Corporation On May 27, 2018, 5:36 AM -0400, onmstester onmstester

cassandra update vs insert + delete

2018-05-27 Thread onmstester onmstester
Hi I want to load all rows from many partitions and change a column value in each row, which of following ways is better concerning disk space and performance? 1. create a update statement for every row and batch update for each partitions 2. create an insert statement for every row and batch