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.
