incubator-cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From DuyHai Doan <doanduy...@gmail.com>
Subject Re: NULL in CQL
Date Mon, 10 Mar 2014 21:30:37 GMT
@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 <rgupta@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.
>

Mime
View raw message