And to be clear, and to elaborate, null is the default state for a
Cassandra cell if you don't write to it, so you can always create a row
with a null column by writing the row without that column being specified.
Additionally, cql's delete statement optionally takes a columns argument,
so if you
@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 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
You can use blobAs 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 wr
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 confli
