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

["Aaron Westendorf (JIRA)" <ji...@apache.org>]

Aaron Westendorf created CASSANDRA-6306:
-------------------------------------------

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