Mailing-List: contact dev-help@cassandra.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@cassandra.apache.org
Received-SPF: pass (athena.apache.org: domain of jbellis@gmail.com designates
 209.85.215.44 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=mime-version:in-reply-to:references:date:message-id:subject:from:to
         :content-type:content-transfer-encoding;
        b=M/68s2If+yOWnSfBaNWchDd9bdjhbCjFwkG6oEHE3Tm/7VV5HY8MGkMVd16Fr5b1aZ
         JrvinqKaVG/p0S6zLFj1vrEAKGAjUesDbeP+8+S6ec5pGluspFrGz8QICqsRGpi+0U57
         24qRNeecbn68kJtk6dBHadxBLRRvrA/+wO5Mo=
MIME-Version: 1.0
In-Reply-To: <AANLkTinOEvDeFMB_k3+NMHM1tr6K22jbk5WZYoo+7Bdp@mail.gmail.com>
References: <AANLkTi=GrAt09ep_NDEpQyvNqyK-hem3OBgoNdWBkSPj@mail.gmail.com>
	<1289234576.46236761@192.168.2.228>
	<AANLkTikYN-er5venuCfrQSQKmmbQO_3rAYH48TYNPU5q@mail.gmail.com>
	<1289317896.180116986@192.168.2.228>
	<AANLkTinn8c2kPs0Exj+fdgtpY5Faz_BbFbxjrQdOcxxS@mail.gmail.com>
	<1289320161.063728937@192.168.2.228>
	<AANLkTim8BXBMscAqAofiTD-MgQzsi_r1_Hqd1azSOwNi@mail.gmail.com>
	<1289325924.168626883@192.168.2.228>
	<AANLkTikW8=WMB=Vy0R10=gL-47b4nro1NUy572OBjNVK@mail.gmail.com>
	<AANLkTinABm7mirGx-3nE7Lhs58uv07LxdE=VFVM=8C+k@mail.gmail.com>
	<AANLkTimbwCGBRnxLi9pG79TdDCTA4ukp5MkUnZJzv+cZ@mail.gmail.com>
	<AANLkTikyBSFjzDSK+bb7WtkeD2Fq5mj38AdNop4g8cWD@mail.gmail.com>
	<AANLkTinJmXr4zHw=+8QPXeCjd5J61Bef=TpE4mnGyaha@mail.gmail.com>
	<AANLkTi=CsAcmO2uHUKwea8430kk9evkUpES+miJMRdOt@mail.gmail.com>
	<AANLkTinOEvDeFMB_k3+NMHM1tr6K22jbk5WZYoo+7Bdp@mail.gmail.com>
Date: Mon, 22 Nov 2010 13:39:30 -0600
Message-ID: <AANLkTimNk+5mX99t5FUe3qX4+nE4Rb3T4kSsDm_TjGAY@mail.gmail.com>
Subject: Re: CASSANDRA-1472 (bitmap indexes)
From: Jonathan Ellis <jbellis@gmail.com>
To: dev <dev@cassandra.apache.org>
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

Let's start wth the low-hanging fruit: can you give steps to reproduce
queries that fail right away?

On Wed, Nov 17, 2010 at 10:37 AM, dragos cernahoschi
<dragos.cernahoschi@gmail.com> wrote:
> Back. I've tested the keys index pagination once again. 0.7 head. Smaller
> data set: 1 million rows. It seems there are still some issues:
>
> 1. *test*: query on one column, count: 1000, expected number of distinct
> results: 48251
> =A0 =A0*result*: 5 pages of 1000 results, than, after the 6th page, the r=
esults
> begin to repeat, I would expect that repetition begins after the 48251-th
> row
>
> 2. *test*: query on 3 columns, count: 10 (count 100, count 1000 failed wi=
th
> time out)
> =A0 =A0*result*: 1 page of 10 results, than second page =3D> time out
>
> 3. There are queries with combinations of 2, 3 columns that fail right aw=
ay
> with time out (count 10, 100).
>
> Dragos
>
>
> On Mon, Nov 15, 2010 at 2:29 PM, Jonathan Ellis <jbellis@gmail.com> wrote=
:
>
>> On Mon, Nov 15, 2010 at 5:57 AM, dragos cernahoschi
>> <dragos.cernahoschi@gmail.com> wrote:
>> > I've tested 0.7-beta3 branch index feature without the 1472 patch. The
>> > queries on more than one column works better than the patched version,
>> but
>> > definitely not correctly.
>>
>> Please test 0.7 branch head, as you can see from the CHANGES there
>> have been a lot of fixes.
>>
>> > 1.
>> > 2.
>> > 4.
>>
>> Should be fixed in head.
>>
>> > 3. Is there any example on the pagination feature? (without knowing th=
e
>> > expected number of rows).
>>
>> Same way you paginate through range slices or columns within a row,
>> set start to the last result you got w/ previous query.
>>
>> > Will the get_indexed_slices return an empty list when there is no more
>> > results?
>>
>> No, all queries are start-inclusive.
>>
>> --
>> Jonathan Ellis
>> Project Chair, Apache Cassandra
>> co-founder of Riptano, the source for professional Cassandra support
>> http://riptano.com
>>
>


--=20
Jonathan Ellis
Project Chair, Apache Cassandra
co-founder of Riptano, the source for professional Cassandra support
http://riptano.com