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 <sor...@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 > >