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)
Content-Type: text/plain; charset=iso-8859-1
Mime-Version: 1.0 (Mac OS X Mail 6.6 \(1510\))
Subject: Re: Problems using secondary index with IN keyword
From: Jan Algermissen <jan.algermissen@nordsc.com>
In-Reply-To: 
 <CADFYdErJBGhWmH=1CV16yjSzq=dYw53e+Jcb74C8WqtWEwSXQg@mail.gmail.com>
Date: Thu, 24 Oct 2013 14:44:34 +0200
Content-Transfer-Encoding: quoted-printable
Message-Id: <A6F208EA-2575-411E-B6AF-26E6BABA0408@nordsc.com>
References: 
 <CADFYdErJBGhWmH=1CV16yjSzq=dYw53e+Jcb74C8WqtWEwSXQg@mail.gmail.com>
To: user@cassandra.apache.org

Petter,

On 24.10.2013, at 14:38, Petter von Dolwitz (Hem) =
<petter.von.dolwitz@gmail.com> wrote:

> Hi,
>=20
> I have a table that (in simplified version) looks like this:
>=20
> CREATE TABLE mytable (
>   a varchar,
>   b varchar,
>   c varchar
>   d timstamp,
>   e varchar,
>   PRIMARY KEY (a, b, c, d)
> );
>=20
> CREATE INDEX mytable_c_idx ON mytable ( c );
>=20
> After populating I execute:
>=20
> SELECT * FROM mytable WHERE c=3D'myvalue';
>=20
> which works fine. However, using:
>=20
> SELECT * FROM mytable WHERE c IN ('myvalue');
>=20
> gives me:
> Bad Request: PRIMARY KEY part c cannot be restricted (preceding part b =
is either not restricted or by a non-EQ relation)
>=20
> Can anybody explain this?

You cannot use a part in a where clause unless you specify the =
preceeding parts also.

Think of it this way: To resolve yur restriction, C* would have to do a =
full scan over all rows to find those rows that have a 'myvalue' C-part.

Jan


> My aim is to query for more than one value in the c column. Is this =
supported?
>=20
> Thanks,
> Petter
>=20
>=20
>=20
>=20
>=20