incubator-cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Vivek Mishra <mishra.v...@gmail.com>
Subject Re: Querying composite keys
Date Mon, 11 Feb 2013 07:00:22 GMT
You can query over composite columns as:
1) Partition key
2) First part of clustered key(using EQ ops).

Secondary indexes over non composite columns are not possible.

-Vivek
On Mon, Feb 11, 2013 at 12:06 PM, Rishabh Agrawal <
rishabh.agrawal@impetus.co.in> wrote:

>  Hello
>
>
>
> I have key and columns defined in following fashion:
>
>
>
>
>
> HotelName1:RoomNum1
>
> HotelName2:RoomNum2
>
> HotelName3:RoomNum3
>
> Key1:TimeStamp:VersionNum
>
>
>
>
>
>
>
>
>
>
>
> Is there a way that I can query this schema by only ‘key’ or ‘HotelName’
> i.e. querying using a part of composite key and not the full key.
>
>
>
>
>
> Thanks and Regards
>
> Rishabh Agrawal
>
>
>
> ------------------------------
>
>
>
>
>
>
> NOTE: This message may contain information that is confidential,
> proprietary, privileged or otherwise protected by law. The message is
> intended solely for the named addressee. If received in error, please
> destroy and notify the sender. Any use of this email is prohibited when
> received in error. Impetus does not represent, warrant and/or guarantee,
> that the integrity of this communication has been maintained nor that the
> communication is free of errors, virus, interception or interference.
>

Mime
View raw message