Mailing-List: contact user-help@cassandra.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@cassandra.apache.org
Received-SPF: pass (nike.apache.org: domain of sorinm@gmail.com designates
 74.125.82.180 as permitted sender)
Message-ID: <51797E0B.6060803@gmail.com>
Date: Thu, 25 Apr 2013 21:03:39 +0200
From: Sorin Manolache <sorinm@gmail.com>
User-Agent: Mozilla/5.0 (X11; Linux x86_64;
 rv:17.0) Gecko/20130112 Icedove/17.0.2
MIME-Version: 1.0
To: user@cassandra.apache.org
Subject: Re: Deletes, null values
References: 
 <CA+VSrLo6+wk9OKUXoO9qWc30i0g1axM7D40DKbn8fH-=tkJnZw@mail.gmail.com>
In-Reply-To: 
 <CA+VSrLo6+wk9OKUXoO9qWc30i0g1axM7D40DKbn8fH-=tkJnZw@mail.gmail.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

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