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

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

Agile BoardAttach filesAttach ScreenshotBulk Copy AttachmentsBulk Move AttachmentsVotersWatch issueWatchersCreate sub-taskConvert to sub-taskMoveLinkCloneLabelsUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Normal
    • Resolution: Duplicate
    • None
    • None
    • 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

        Issue Links

        duplicates

        Improvement - An improvement or enhancement to an existing feature or task. CASSANDRA-4762 Support IN clause for any clustering column

        • Normal -
        • Resolved

        Improvement - An improvement or enhancement to an existing feature or task. CASSANDRA-4386 Allow cql to use the IN syntax on secondary index values

        • Low -
        • Resolved

        Activity
          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

            Unassigned Unassigned Assign to me
            nsv Sergey Nagaytsev
            Votes:
            3 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Slack

                Issue deployment