Mailing-List: contact user-help@cassandra.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@cassandra.apache.org
Received-SPF: neutral (nike.apache.org: local policy)
From: David Turnbull <david@broodax.net>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: quoted-printable
Subject: Partial composite result limit possible?
Message-Id: <372132B6-F983-4573-902F-232382DD8520@broodax.net>
Date: Wed, 15 Aug 2012 14:10:42 +1000
To: user@cassandra.apache.org
Mime-Version: 1.0 (Mac OS X Mail 6.0 \(1485\))

Hi, I have a CF with a composite type (LongType, IntegerType) with some =
data like this:

RowKey: hihi
=3D> (column=3D1000:1, value=3D616263)
=3D> (column=3D1000:2, value=3D6465)
=3D> (column=3D1000:3, value=3D66)
=3D> (column=3D1000:4, value=3D6768)
=3D> (column=3D2000:1, value=3D616263)
=3D> (column=3D2000:2, value=3D6465)
=3D> (column=3D2000:3, value=3D66)
=3D> (column=3D2000:4, value=3D6768)

I want to query from (1000,0 to 2000,2) such that I get 1000:1, 1000:2, =
2000:1 and 2000:2 back.
Is this possible?

In pycassa, I can do cf.get('hihi', column_start=3D(1000,0), =
column_finish=3D(2000,2) but that gives me 1000:1-4 and 2000:1-2.
Specifying a limit of 2 columns for the query just applies to the total =
results, i.e. only 1000:1 and 1000:2.

I could specify the composite columns fully in the query, but I'm hoping =
to query over at least 300 columns, which seems bad.