You can use blobAs<Type> functions to insert empty blobs/values right
into your cells, for example blobAsInt(0x) will insert an *empty* integer.
http://cassandra.apache.org/doc/cql3/CQL.html#blobFun
On 3/10/14, 9:56, Rahul Gupta 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 StManchester, 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.
