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

Support UPDATE with IN requirement for clustering key

    Details

    • Type: Wish
    • Status: Resolved
    • Priority: Minor
    • Resolution: Duplicate
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      None

      Description

      CREATE TABLE events (
          userid uuid,
          id timeuuid,
          content text,
          type text,
          PRIMARY KEY (userid, id)
      )
      
      # Add data
      
      cqlsh:mykeyspace> UPDATE events SET content='Hello' WHERE userid=57b47f85-56c4-4968-83cf-4c4e533944e9 AND id IN (046e9da0-7945-11e4-a76f-770773bbbf7e, 046e0160-7945-11e4-a76f-770773bbbf7e);
      code=2200 [Invalid query] message="Invalid operator IN for PRIMARY KEY part id"
      

      I was surprised this doesn't work.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                blerer Benjamin Lerer
                Reporter:
                ztyx Jens Rantil
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: