I just used 'synthetic key' as it's a term used with standard rdbms to
mean a key that means nothing in the model, and is often a sequence or such.
There's nothing particular to cassandra specific to that term. Just
thought it would be something familiar to someone who understood rdbms.
On 05
I never thought about using a synthetic key, but in this instance with
about a dozen rows it's probably ok. Thanks for your great idea.
Where did you read about the synthetic key idea? I've not come across it
before.
Thanks
Jabbar Azam
On 4 May 2013 19:30, Dave Brosius wrote:
> if you want
if you want to store all the roles in one row, you can do
create table roles (synthetic_key int, name text, primary
key(synthetic_key, name)) with compact storage
when inserting roles, just use the same key
insert into roles (synthetic_key, name) values (0, 'Programmer');
insert into roles (s
