Re: Update/where statement Adds Row

[Hossein Ghiyasi Mehr]

Update in Cassandra is upsert (update or insert). So when you update a row
which isn't exist, it will create it.
"IF EXIST" can be used in some queries.

On Thu, Sep 12, 2019 at 8:35 AM A  wrote:

> I have an update statement that has a where clause with the primary key
> (email,companyid).
>
> When executed it always creates a new row. It’s like it’s not finding the
> existing row with the primary key.
>
> I’m using Cassandra-driver.
>
> What am I doing wrong? I don’t want a new row. Why doesn’t it seem to be
> using the where clause to identify the existing row?
>
> Thanks,
> Angel
>
>
>
> Sent from Yahoo Mail for iPhone
> 
>

Re: Update/where statement Adds Row

[Jon Haddad]

Probably not a great idea unless you're using it sparingly. Using LWTs
without knowing all the caveats is likely to lead to terrible cluster
performance.




On Wed, Sep 11, 2019, 10:59 PM A  wrote:

> Is it ok if I do this?
>
> ... where email = em AND company_id = id IF EXISTS
>
>
>
>
>
> Sent from Yahoo Mail for iPhone
> 
>
> On Wednesday, September 11, 2019, 9:08 PM, JOHN, BIBIN 
> wrote:
>
> Use if exists clause.
>
>
>
> *UPDATE* table
>
> *SET* column ='something'
>
> WHERE key = ‘value’ IF EXISTS;
>
>
>
>
>
>
>
>
>
>
>
> *From:* A 
> *Sent:* Wednesday, September 11, 2019 11:05 PM
> *To:* User cassandra.apache.org 
> *Subject:* Update/where statement Adds Row
>
>
>
> I have an update statement that has a where clause with the primary key
> (email,companyid).
>
>
>
> When executed it always creates a new row. It’s like it’s not finding the
> existing row with the primary key.
>
>
>
> I’m using Cassandra-driver.
>
>
>
> What am I doing wrong? I don’t want a new row. Why doesn’t it seem to be
> using the where clause to identify the existing row?
>
>
>
> Thanks,
>
> Angel
>
>
>
>
> Sent from Yahoo Mail for iPhone
> 
>
>