Mailing-List: contact user-help@cassandra.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@cassandra.apache.org
Received-SPF: pass (athena.apache.org: domain of machielg@gmail.com designates
 209.85.215.181 as permitted sender)
Content-Type: text/plain; charset=iso-8859-1
Mime-Version: 1.0 (Mac OS X Mail 7.1 \(1827\))
Subject: Re: Trying to understand why tombstone is being read
From: Machiel Groeneveld <machielg@gmail.com>
In-Reply-To: 
 <CAHio0ZNX+H0vT6vZwT4Zhni=Zag43wYroKywUHG_EzN-4Zy5Sg@mail.gmail.com>
Date: Thu, 13 Feb 2014 18:43:51 +0100
Reply-To: user@cassandra.apache.org
Content-Transfer-Encoding: quoted-printable
Message-Id: <1F992FB5-FE68-4308-A86C-4B1AD8A39063@gmail.com>
References: 
 <CAHio0ZNX+H0vT6vZwT4Zhni=Zag43wYroKywUHG_EzN-4Zy5Sg@mail.gmail.com>
To: user@cassandra.apache.org

We had a similar question, a column inserted with a null value also =
results in a tombstone.

Also see the (closed) issue about this:
https://issues.apache.org/jira/browse/CASSANDRA-6674

On 13 Feb 2014, at 16:35, Adam Patacchiola <adam@2fours.com> wrote:

> I have a table defined in cql like this:
>=20
> CREATE TABLE chatmessages (
>   username    varchar,
>   spotname    varchar,
>   id          varint,
>   iv          varchar,
>   fromuser        varchar,
>   fromversion varchar,
>   touser          varchar,
>   toversion   varchar,
>   datetime    timestamp,
>   data        varchar,
>   mimetype    varchar,
>   datasize    int,
>   shareable   boolean,
>   PRIMARY KEY (username, spotname, id)
> )
>=20
> That I insert messages into. Occasionally "rows" are deleted. My =
question is why, when I query for a "row" using a select query specific =
to only that "row" which contains cells that have never been deleted =
such as:
>=20
>   select * from chatmessages where username=3D'adam' and =
spotname=3D'adam:cherie' and id =3D1860;
>=20
> Am I seeing in the cqlsh trace that 1 tombstoned cell has been read:
>=20
> "Read 1 live and 1 tombstoned cells"
>=20
> Thanks for any way you can help increase my understanding of what's =
going on here.
>=20
> Adam