[jira] [Resolved] (CASSANDRA-6306) "No indexed columns" error when using equals on compound primary key

["Aleksey Yeschenko (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/CASSANDRA-6306?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Aleksey Yeschenko resolved CASSANDRA-6306.
------------------------------------------

    Resolution: Invalid

Can only use equality op (=) on 2i columns. This query would work if instead of creating an index you make i_time part of the primary key, though.

> "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)