incubator-cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Sorin Manolache <sor...@gmail.com>
Subject Re: Deletes, null values
Date Fri, 26 Apr 2013 12:48:16 GMT
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 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'));
>

I see. I'm sorry, I know nothing about phpCassa. I use batch_mutation 
with deletions and it works. But I guess phpCassa must use the same 
thrift primitives.

Sorin


>
>
> 2013/4/25 Sorin Manolache <sorinm@gmail.com <mailto: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