I have playing around with composite CFs, I have one declared: create columnfamily at_event_ac_c ( ac_event_id int, ac_creation timestamp, ac_action text, ac_addr text, ac_advisory_id text, ac_c text, ... ev_sev text, ... ev_total text, ev_url text, ev_used text, toast text, fw text, name text, resp text, size text, PRIMARY KEY (ac_c, ac_creation) ) with compression_parameters:sstable_compression = '';
So, my main primary key is on the ac_c column, text, and the secondary composite key is on ac_creation, which is a date. These queries perform correctly: select * from at_event_ac_c where ac_c = '1234'; select * from at_event_ac_c where ac_c = '1234' and ac_creation > '2012-07-15' and ac_creation < '2012-07-18'; What's weird is I can't qualify on a non-indexed column, like: select * from at_event_ac_c where ac_c = '1234' and ac_creation > '2012-07-15' and ac_creation < '2012-07-18' and ev_sev = 2; I get an error: Bad Request: No indexed columns present in by-columns clause with Equal operator But, I just attended a class on this. I thought that once I used my indices the remaining qualifications would be satisfied via a filtering method. Obviously this is incorrect. Is there a way to 'filter' results? -g