[
https://issues.apache.org/jira/browse/CASSANDRA-6306?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13815180#comment-13815180
]
Aaron Westendorf commented on CASSANDRA-6306:
---------------------------------------------
That's annoying, I swear I tried that and had a similar error, but I can't
repeat that now. Apologies for the noob question.
> "No indexed columns" error when using equals on compound primary key
> --------------------------------------------------------------------
>
> Key: CASSANDRA-6306
> URL: https://issues.apache.org/jira/browse/CASSANDRA-6306
> Project: Cassandra
> Issue Type: Bug
> Components: Core
> Environment: Cassandra 2.0.2
> Reporter: Aaron Westendorf
>
> Given the following table and secondary index:
> {noformat}
> TABLE series (
> name text,
> interval text,
> i_time bigint,
> insert_time float,
> r_time bigint,
> value float,
> PRIMARY KEY (name, interval)
> );
> CREATE INDEX series_i_time_idx ON series (i_time);
> {noformat}
> I get the following error
> {noformat}
> cqlsh:kairos> select i_time, r_time, value from series where name='test' and
> interval='hour' and i_time>=500000;
> Bad Request: No indexed columns present in by-columns clause with Equal
> operator
> {noformat}
> I'm new to Cassandra, but of what I've read, this query should work.
--
This message was sent by Atlassian JIRA
(v6.1#6144)
