[jira] [Resolved] (CASSANDRA-6318) IN predicates on non-primary-key columns (%s) is not yet supported

["Sylvain Lebresne (JIRA)" <ji...@apache.org>]

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

Sylvain Lebresne resolved CASSANDRA-6318.
-----------------------------------------

       Resolution: Duplicate
    Reproduced In: 2.0.3, 2.0.2  (was: 2.0.2, 2.0.3)

Sorry for not having set the JIRA resolution correctly, but as indicated in the comments, this is a duplicate of CASSANDRA-4386 (or of CASSANDRA-4762, the description wasn't entirely clear which ones it was asking for, but the point is that there is already an existing ticket for this and we don't keep 2 separate ticket open for the same problem). 

To the best of my knowledge no-one has started working on CASSANDRA-4386 so there is no particular targeted milestone. You are, of course, welcome to contribute in changing that.

> IN predicates on non-primary-key columns (%s) is not yet supported
> ------------------------------------------------------------------
>
>                 Key: CASSANDRA-6318
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-6318
>             Project: Cassandra
>          Issue Type: Bug
>            Reporter: Sergey Nagaytsev
>              Labels: cql3
>         Attachments: CASSANDRA_6318_test.cql
>
>
> Query:
> SELECT * FROM post WHERE blog IN (1,2) AND author=3 ALLOW FILTERING -- contrived
> Error: IN predicates on non-primary-key columns (blog) is not yet supported
> Please either implement, set milestone or say will never be implemented !
> P.S. Did search, seemingly found no issue/plan related to it. Maybe CASSANDRA-6048 ?
> P.S.2 What is recommended workaround for this ? Manual index tables, what are design guidelines for them ?



--
This message was sent by Atlassian JIRA
(v6.1.4#6159)