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 dlee@amplience.com designates
 213.199.154.11 as permitted sender)
From: Darren Lee <dlee@amplience.com>
To: "'dev@cassandra.apache.org'" <dev@cassandra.apache.org>
Subject: Composite Key Overload
Thread-Topic: Composite Key Overload
Thread-Index: Ac58yndBxMfKWFa/RWS3vsGOy3bjdg==
Date: Tue, 9 Jul 2013 17:46:31 +0000
Message-ID: 
 <5904defb3cbf4e00b18c3f2ca70048df@DBXPR07MB111.eurprd07.prod.outlook.com>
Accept-Language: en-GB, en-US
Content-Language: en-US
Content-Type: multipart/alternative;
	boundary="_000_5904defb3cbf4e00b18c3f2ca70048dfDBXPR07MB111eurprd07pro_"
MIME-Version: 1.0

--_000_5904defb3cbf4e00b18c3f2ca70048dfDBXPR07MB111eurprd07pro_
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

Hi Everyone,

I have a CF which currently has a large composite key. Let's say it has 5 c=
omponents, A,B,C,D,E.

I know I need to be able to query and find all rows where A,B,C equal a cer=
tain value. And I also need to query when A,B,C,D are a certain value.

Traditionally what is the best approach for this?

*         Composite key? Is it possible to query on components of the compo=
site key?

*         Duplicate the fields I want to query on and create a secondary in=
dex

*         Expand the data into supercolumns for horizontal traversal

*         Create lookup tables and suffer having to do reads before being a=
ble to write updates

Thanks

--_000_5904defb3cbf4e00b18c3f2ca70048dfDBXPR07MB111eurprd07pro_--