Presumably you meant unread_ids to be a static column (it isn’t in your table definition)
On Sep 7, 2014, at 10:14 AM, tommaso barbugli <tbarbu...@gmail.com> wrote:
> Hi,
> I am trying to use a couple of static columns; I am using cassandra 2.0.7 and
> when I try to set a value using the partition key only, I get a primary key
> incomplete error.
>
> Here is the schema and the query with the error I get from cqlsh
>
> CREATE TABLE shard75 (
> group_id ascii,
> event_id timeuuid,
> group ascii,
> unread_ids set<timeuuid>,
> unseen_ids set<timeuuid>,
> PRIMARY KEY (group_id, event_id)
> ) WITH CLUSTERING ORDER BY (event_id DESC) AND
> bloom_filter_fp_chance=0.100000 AND
> caching='KEYS_ONLY' AND
> comment='' AND
> dclocal_read_repair_chance=0.000000 AND
> gc_grace_seconds=864000 AND
> index_interval=128 AND
> read_repair_chance=0.100000 AND
> populate_io_cache_on_flush='false' AND
> default_time_to_live=0 AND
> speculative_retry='99.0PERCENTILE' AND
> memtable_flush_period_in_ms=0 AND
> compaction={'sstable_size_in_mb': '64', 'tombstone_threshold': '0.2',
> 'class': 'LeveledCompactionStrategy'} AND
> compression={'sstable_compression': 'LZ4Compressor'};
>
>
> UPDATE shard75 set unread_ids = { } WHERE group_id = 'asd';
>
> Bad Request: Missing mandatory PRIMARY KEY part event_id
>
>
> Am I doing something unsupported here? I am trying to follow the examples in
> the release docs (from cassandra 2.0.6)
>
> Thank you,
> Tommaso
smime.p7s
Description: S/MIME cryptographic signature
