incubator-cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Alain RODRIGUEZ <arodr...@gmail.com>
Subject Re: Deletes, null values
Date Fri, 26 Apr 2013 09:55:40 GMT
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 client):

$pool = new ConnectionPool('myKeyspace', array('192.168.100.201'), 6, 0,
30000, 30000);
$my_cf= new ColumnFamily($pool, 'myCF', true, true,
ConsistencyLevel::QUORUM, ConsistencyLevel::QUORUM);
$my_cf->remove('all', array('1228#16857','1228#16866','1228#16875'));



2013/4/25 Sorin Manolache <sorinm@gmail.com>

> 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 all the column for a given key
>> I have the following returned:
>>
>>   1228#16857 | 1228#16866 | 1228#16875 | 1237#16544 | 1237#16553
>> -------------------+----------**--------+------------------+--**
>> -----------------+------------**------
>>               null |              null |             null |
>>          |
>>
>>
>> This is quite annoying since my app thinks that I have 5 columns there
>> when I should have 2 only.
>>
>> I first thought that this was a visible marker of tombstones but they
>> didn't vanish after a major compaction.
>>
>> How can I get rid of these null/ghost columns and why does it happen ?
>>
>
> I do something similar but I don't see null values. Could you please post
> the code where you delete the columns?
>
> Sorin
>
>

Mime
View raw message