> I thought that C* had no null values... I use a lot of CF in which only the
> columns name are filled up and I request a range of column to see which
> references (like 1228#16866) exists. So I would like those column to simply
> disappear from the table.
Cassandra does not store null values.
I created it almost a year ago with cassandra-cli. Now show_schema returns:
create column family myCF
with column_type = 'Standard'
and comparator = 'UTF8Type'
and default_validation_class = 'UTF8Type'
and key_validation_class = 'UTF8Type'
and read_repair_chance = 0.1
and dclocal_read_
What's your table definition ?
>> select '1228#16857','1228#16866','1228#16875','1237#16544','1237#16553'
>> from myCF where key = 'all';
The output looks correct to me. CQL table return values, including null, for
all of the selected columns.
Cheers
-
Aaron Morton
Freelance C
On 2013-04-26 11:55, Alain RODRIGUEZ wrote:
Of course:
From CQL 2 (cqlsh -2):
delete '183#16684','183#16714','183#16717' from myCF where key = 'all';
And selecting this data as follow gives me the result above:
select '1228#16857','1228#16866','1228#16875','1237#16544','1237#16553'
from myCF
I copied the wrong query:
In CQL 2 it was:
delete '1228#16857','1228#16866','1228#16875' from myCF where key = 'all';
Sorry about the mistake.
2013/4/26 Alain RODRIGUEZ
> Of course:
>
> From CQL 2 (cqlsh -2):
>
> delete '183#16684','183#16714','183#16717' from myCF where key = 'all';
>
> And
Of course:
>From CQL 2 (cqlsh -2):
delete '183#16684','183#16714','183#16717' from myCF where key = 'all';
And selecting this data as follow gives me the result above:
select '1228#16857','1228#16866','1228#16875','1237#16544','1237#16553'
from myCF where key = 'all';
>From thrift (phpCassa cl
On 2013-04-25 11:48, Alain RODRIGUEZ wrote:
Hi, I tried to delete some columns using cql2 as well as thrift on
C*1.2.2 and instead of being unreachable, deleted columns have a null value.
I am using no value in this CF, the only information I use is the
existence of the column. So when I select
Hi, I tried to delete some columns using cql2 as well as thrift on C*1.2.2
and instead of being unreachable, deleted columns have a null value.
I am using no value in this CF, the only information I use is the existence
of the column. So when I select all the column for a given key I have the
foll