cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From graham sanderson <gra...@vast.com>
Subject Re: update static column using partition key
Date Sun, 07 Sep 2014 18:18:27 GMT
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 <tbarbugli@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


Mime
View raw message