@Rahul *Null *has a special semantics for CQL3. Setting a column value to *null *means deleting it...
On Mon, Mar 10, 2014 at 5:56 PM, Rahul Gupta <rgu...@dekaresearch.com>wrote: > Hi, > > > > How do I check for NULL values in CQL3? > > I am trying to write a CQL equivalent for below SQL: > > > > SELECT * FROM table1 WHERE col2 IS NULL; > > > > While inserting data into C*, CQL won't let me insert NULL, I have to pass > '' for Strings and 0 for integers. > > I have '' and 0s as valid data so that's conflicting with fillers I have > to use instead of NULL. > > > > Please advise. > > > > Thanks, > > *Rahul Gupta* > *DEKA* *Research & Development* <http://www.dekaresearch.com/> > > 340 Commercial St Manchester, NH 03101 > > P: 603.666.3908 extn. 6504 | C: 603.718.9676 > > > > This e-mail and the information, including any attachments, it contains > are intended to be a confidential communication only to the person or > entity to whom it is addressed and may contain information that is > privileged. If the reader of this message is not the intended recipient, > you are hereby notified that any dissemination, distribution or copying of > this communication is strictly prohibited. If you have received this > communication in error, please immediately notify the sender and destroy > the original message. > > > > ------------------------------ > This e-mail and the information, including any attachments, it contains > are intended to be a confidential communication only to the person or > entity to whom it is addressed and may contain information that is > privileged. If the reader of this message is not the intended recipient, > you are hereby notified that any dissemination, distribution or copying of > this communication is strictly prohibited. If you have received this > communication in error, please immediately notify the sender and destroy > the original message. > > Thank you. > > Please consider the environment before printing this email. >
