cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From A <htt...@yahoo.com.INVALID>
Subject Re: Update/where statement Adds Row
Date Thu, 12 Sep 2019 05:59:35 GMT
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 <bj9306@att.com> wrote:

#yiv9726893009 #yiv9726893009 -- _filtered #yiv9726893009 {panose-1:2 4 5 3 5 4 6 3 2 4;}
_filtered #yiv9726893009 {font-family:Calibri;panose-1:2 15 5 2 2 2 4 3 2 4;}#yiv9726893009
#yiv9726893009 p.yiv9726893009MsoNormal, #yiv9726893009 li.yiv9726893009MsoNormal, #yiv9726893009
div.yiv9726893009MsoNormal {margin:0in;margin-bottom:.0001pt;font-size:11.0pt;font-family:sans-serif;}#yiv9726893009
a:link, #yiv9726893009 span.yiv9726893009MsoHyperlink {color:blue;text-decoration:underline;}#yiv9726893009
a:visited, #yiv9726893009 span.yiv9726893009MsoHyperlinkFollowed {color:purple;text-decoration:underline;}#yiv9726893009
pre {margin:0in;margin-bottom:.0001pt;font-size:10.0pt;}#yiv9726893009 p.yiv9726893009msonormal0,
#yiv9726893009 li.yiv9726893009msonormal0, #yiv9726893009 div.yiv9726893009msonormal0 {margin-right:0in;margin-left:0in;font-size:11.0pt;font-family:sans-serif;}#yiv9726893009
span.yiv9726893009EmailStyle18 {font-family:sans-serif;color:#1F497D;}#yiv9726893009 span.yiv9726893009HTMLPreformattedChar
{}#yiv9726893009 span.yiv9726893009hljs-operator {}#yiv9726893009 span.yiv9726893009hljs-keyword
{}#yiv9726893009 span.yiv9726893009hljs-string {}#yiv9726893009 span.yiv9726893009hljs-builtin
{}#yiv9726893009 .yiv9726893009MsoChpDefault {font-size:10.0pt;} _filtered #yiv9726893009
{margin:1.0in 1.0in 1.0in 1.0in;}#yiv9726893009 div.yiv9726893009WordSection1 {}#yiv9726893009

Use if exists clause.
 
  
 
UPDATE table
 
SET column ='something'
 
WHERE key = ‘value’ IF EXISTS;
 
  
 
  
 
  
 
  
 
  
 
From: A <httpex@yahoo.com.INVALID> 
Sent: Wednesday, September 11, 2019 11:05 PM
To: User cassandra.apache.org <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
 



Mime
View raw message