Mailing-List: contact user-help@cassandra.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@cassandra.apache.org
Received-SPF: pass (nike.apache.org: domain of sylvain@datastax.com designates
 209.85.214.172 as permitted sender)
MIME-Version: 1.0
In-Reply-To: 
 <CAD4ZjiEjKB2K=7uuZ9fRwLz6fX0AmqZdXTXAHr4bdFXM-UP_JA@mail.gmail.com>
References: 
 <CAD4ZjiEjKB2K=7uuZ9fRwLz6fX0AmqZdXTXAHr4bdFXM-UP_JA@mail.gmail.com>
Date: Thu, 21 Jun 2012 08:47:10 +0200
Message-ID: 
 <CAKkz8Q0utobZwE831cjvJ59UnWJ3+DM1_WyJfUf5KuspmL3=tw@mail.gmail.com>
Subject: Re: Creating secondary index CQL3 cassandra 1.1.1
From: Sylvain Lebresne <sylvain@datastax.com>
To: user@cassandra.apache.org
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

On Thu, Jun 21, 2012 at 5:11 AM, Stephen Powis <stephen.powis@pardot.com> w=
rote:
> I have the following schema:
>
> describe columnfamily visitor_audit;
>
> CREATE TABLE visitor_audit (
> =A0 visitor_id text,
> =A0 audit_id uuid,
> =A0 account_id int,
> =A0 audit_type int,
> =A0 created_at text,
> =A0 PRIMARY KEY (visitor_id, audit_id)
> ) WITH
> =A0 comment=3D'' AND
> =A0 caching=3D'KEYS_ONLY' AND
> =A0 read_repair_chance=3D0.100000 AND
> =A0 gc_grace_seconds=3D864000 AND
> =A0 min_compaction_threshold=3D4 AND
> =A0 max_compaction_threshold=3D32 AND
> =A0 replicate_on_write=3D'true' AND
> =A0 compaction_strategy_class=3D'SizeTieredCompactionStrategy' AND
> =A0 compression_parameters:sstable_compression=3D'SnappyCompressor';
>
> I then created an index by executing the following:
> CREATE INDEX ix_accountid ON visitor_audit (account_id);
>
> When I attempt to execute: select * from visitor_audit where account_id=
=3D1;
> Nothing is returned even tho I have rows with account_id equal to 1.
>
> Is there anything I am missing here?

You are pretty much hitting
https://issues.apache.org/jira/browse/CASSANDRA-4328.
In other words, secondary indexes is not yet supported on table with
composite PRIMARY KEY, but we don't correctly reject the CREATE INDEX
command.

--
Sylvain