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

2018-05-27 Thread Xiangfei Ni
It is not possible to update the primary key. Best Regards, 倪项菲/ David Ni 中移德电网络科技有限公司 Virtue Intelligent Network Ltd, co. Add: 2003,20F No.35 Luojia creative city,Luoyu Road,Wuhan,HuBei Mob: +86 13797007811|Tel: + 86 27 5024 2516 发件人: onmstester onmstester 发送时间: 2018年5月28日 14:42 收件人: user 主题:

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

2018-05-27 Thread onmstester onmstester
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 Forwarded message >From : Xiangfei Ni To : "user@cassandra.apache.org"

答复: Re: cassandra update vs insert + delete

2018-05-27 Thread Xiangfei Ni
Yes, you are correct. Best Regards, 倪项菲/ David Ni 中移德电网络科技有限公司 Virtue Intelligent Network Ltd, co. Add: 2003,20F No.35 Luojia creative city,Luoyu Road,Wuhan,HuBei Mob: +86 13797007811|Tel: + 86 27 5024 2516 发件人: onmstester onmstester 发送时间: 2018年5月28日 14:33 收件人: user 主题: Fwd: Re: cassandra upda

Fwd: Re: cassandra update vs insert + delete

2018-05-27 Thread onmstester onmstester
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 Forwarded message >From : Jonathan Haddad To :

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: > Deletes create tombstones — no

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 , wro

Create Cassandra DataType object in Java

2018-05-27 Thread Soheil Pourbafrani
Hi, I have a string containing one of the primitive data types in Cassandra, for example String type = "bigint"; Now I want to create a corresponding DataType object for that. I tried : DataType.custom(type) but it was useless. Notice I don't want to use the following solution DataType.bigi

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