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 <[email protected]> wrote: > Is it ok if I do this? > > ... where email = em AND company_id = id IF EXISTS > > > > > > Sent from Yahoo Mail for iPhone > <https://overview.mail.yahoo.com/?.src=iOS> > > On Wednesday, September 11, 2019, 9:08 PM, JOHN, BIBIN <[email protected]> > wrote: > > Use if exists clause. > > > > *UPDATE* table > > *SET* column ='something' > > WHERE key = ‘value’ IF EXISTS; > > > > > > > > > > > > *From:* A <[email protected]> > *Sent:* Wednesday, September 11, 2019 11:05 PM > *To:* User cassandra.apache.org <[email protected]> > *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 > <https://urldefense.proofpoint.com/v2/url?u=https-3A__overview.mail.yahoo.com_-3F.src-3DiOS&d=DwMFaQ&c=LFYZ-o9_HUMeMTSQicvjIg&r=eFshZuDXOwvmW_UjVcAH8Q&m=FgFsGQLanA1ngbbLdQ2MKd0wBFNiXHtKVDZIEi2z_Qk&s=ZTUXV9cgMyKnreKaza7UCRQTtJjk_iygFCPGYX5X1es&e=> > >
