You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@cassandra.apache.org by tommaso barbugli <tb...@gmail.com> on 2014/09/07 17:14:49 UTC
update static column using partition key
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
Re: update static column using partition key
Posted by graham sanderson <gr...@vast.com>.
Note also (though you are likely not hitting them) there were a bunch of static column related edge cases fixed in 2.0.10
On Sep 7, 2014, at 1:18 PM, graham sanderson <gr...@vast.com> wrote:
> 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 <tb...@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
>
Re: update static column using partition key
Posted by graham sanderson <gr...@vast.com>.
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 <tb...@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