Uploaded image for project: 'Cassandra'
  1. Cassandra
  2. CASSANDRA-6318

IN predicates on non-primary-key columns (%s) is not yet supported

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Normal
    • Resolution: Duplicate
    • Fix Version/s: None
    • Component/s: None
    • Labels:
    • Severity:
      Normal

      Description

      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 ?

        Attachments

        1. CASSANDRA_6318_test.cql
          1 kB
          Sergey Nagaytsev

          Issue Links

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                nsv Sergey Nagaytsev
              • Votes:
                3 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: