On Thu, Jun 21, 2012 at 5:11 AM, Stephen Powis <stephen.po...@pardot.com> wrote: > I have the following schema: > > describe columnfamily visitor_audit; > > CREATE TABLE visitor_audit ( > visitor_id text, > audit_id uuid, > account_id int, > audit_type int, > created_at text, > PRIMARY KEY (visitor_id, audit_id) > ) WITH > comment='' AND > caching='KEYS_ONLY' AND > read_repair_chance=0.100000 AND > gc_grace_seconds=864000 AND > min_compaction_threshold=4 AND > max_compaction_threshold=32 AND > replicate_on_write='true' AND > compaction_strategy_class='SizeTieredCompactionStrategy' AND > compression_parameters:sstable_compression='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=1; > 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
