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: local policy)
DomainKey-Signature: a=rsa-sha1; c=nofws; d=thelastpickle.com; h=to:from
	:subject:date:message-id:content-type:mime-version:in-reply-to;
	 q=dns; s=thelastpickle.com; b=xSX4I1VH/n+npMGRAVRVW2L0F/Vdr5fCz
	sSoEHQB5Zn43jMmqIpmQLX95Md00XYxaGoq1wnOeAawl8Qpd8cFG6KQFyAfLYOgs
	Arcm/hdlj2BQxT0qzWcTQcc/Q81R3ZIMu+dLLc6/epzU4YC9aYMEDvFShsJo9bBG
	bsvnCfaBQQ=
To: user@cassandra.apache.org
From: Aaron Morton <aaron@thelastpickle.com>
Subject: Re: Secondary index query return row should not return?
Date: Thu, 11 Nov 2010 20:20:28 GMT
Message-id: <05c626a6-714a-65c9-b963-e0248981bc2f@me.com>
Content-Type: multipart/alternative;
 boundary=Apple-Webmail-42--1082d7ca-4031-e76b-cfd6-c1a4977ad9d6
MIME-Version: 1.0
In-Reply-To: <AANLkTi==XMnkqfXjJbNr_ZbfWD6Y29CwMbY3onX2ivJg@mail.gmail.com>


--Apple-Webmail-42--1082d7ca-4031-e76b-cfd6-c1a4977ad9d6
Content-Transfer-Encoding: quoted-printable
Content-Type: text/plain;
    charset=ISO-8859-1;
    format=flowed

My understanding is the clauses are AND'd together.=A0=0A=0AThere is some =
nice logging from the ColumnFamilyStore when it's running the request, can=
 you turn the logging up to DEBUG and send them along?=A0=0A=0AThe first l=
og message will say something like "Primary scan clause is.."=A0=0A=0AChee=
rs=0AAaron=0A=0AOn 12 Nov, 2010,at 02:04 AM, Ching-Cheng Chen <cchen@evide=
ntsoftware.com> wrote:=0A=0ANot sure if this the intended behavior of the =
indexed query.=A0=0A=0AI created a column family and added index on column=
 A,B,C.=A0=0A=0ANow I insert three rows.=A0=0A=0Arow1 : A=3D123, B=3D456, =
C=3D789=A0=0Arow2 : A=3D123, C=3D789=A0=0Arow3 : A=3D123, B=3D789, C=3D789=
=A0=0A=0ANow if I perform an indexed query for A=3D123 and B=3D456, both r=
ow1 and row2 are returned.=A0=0A=0AIs this the expected behavior? =A0Since=
 row2 doesn't have column B, I would expect B=3D456 expression should retu=
rn false. =A0=A0=0A=0AI'm using cassandra-0.7.0-beta3 and hector-0.7.0-19_=
11042010=A0=0A=0ARegards,=A0=0A=0AChen
--Apple-Webmail-42--1082d7ca-4031-e76b-cfd6-c1a4977ad9d6
Content-Type: multipart/related;
    type="text/html";
    boundary=Apple-Webmail-86--1082d7ca-4031-e76b-cfd6-c1a4977ad9d6


--Apple-Webmail-86--1082d7ca-4031-e76b-cfd6-c1a4977ad9d6
Content-Transfer-Encoding: quoted-printable
Content-Type: text/html;
    charset=ISO-8859-1;

<html><body><div>My understanding is the clauses are AND'd together.&nbsp;</div><div><=
br></div><div>There is some nice logging from the ColumnFamilyStore when i=
t's running the request, can you turn the logging up to DEBUG and send the=
m along?&nbsp;</div><div><br></div><div>The first log message will say som=
ething like "Primary scan clause is.."&nbsp;</div><div><br></div><div>Chee=
rs</div><div>Aaron</div><div><br>On 12 Nov, 2010,at 02:04 AM, Ching-Cheng =
Chen &lt;cchen@evidentsoftware.com&gt; wrote:<br><br></div><div><blockquot=
e type=3D"cite"><div><span class=3D"Apple-style-span" style=3D"font-family=
: verdana, geneva, helvetica, arial, sans-serif; font-size: 13px; border-c=
ollapse: collapse; " _mce_style=3D"font-family: verdana, geneva, helvetica=
, arial, sans-serif; font-size: 13px; border-collapse: collapse;">Not sure=
 if this the intended behavior of the indexed query.&nbsp;<br><br>I create=
d a column family and added index on column A,B,C.&nbsp;<br>=0A<br>Now I i=
nsert three rows.&nbsp;<br><br>row1 : A=3D123, B=3D456, C=3D789&nbsp;<br>r=
ow2 : A=3D123, C=3D789&nbsp;<br>row3 : A=3D123, B=3D789, C=3D789&nbsp;<br>=
<br>Now if I perform an indexed query for A=3D123 and B=3D456, both row1 a=
nd row2 are returned.&nbsp;<br><br>=0AIs this the expected behavior? &nbsp=
;Since row2 doesn't have column B, I would expect B=3D456 expression shoul=
d return false. &nbsp;&nbsp;<br><br>I'm using cassandra-0.7.0-beta3 and he=
ctor-0.7.0-19_11042010&nbsp;<br><br>Regards,&nbsp;<br><br>=0AChen</span>=0A=
</div></blockquote></div></body></html>
--Apple-Webmail-86--1082d7ca-4031-e76b-cfd6-c1a4977ad9d6--

--Apple-Webmail-42--1082d7ca-4031-e76b-cfd6-c1a4977ad9d6--