How to use static columns inside clustering keys in Cassandra -



have table

create table my_table (     user_id text,     add_id  text,     other_user_id text,     date timestamp,     primary key (user_id, add_id, other_user_id) ); 

and want share column date not hole partition (that user_id) user_ud/add_id level.

so want similar making date static column, add_id in consideration.

example of desired table:

'user1'  'add1'  'otheruser1' date1 'user1'  'add1'  'otheruser2' date1 'user1'  'add1'  'otheruser3' date1  'user1'  'add2'  'otheruser4' date2 'user1'  'add2'  'otheruser5' date2 'user1'  'add2'  'otheruser6' date2 

(*the space in midle explanation purpose)

this posible? if so, how?


more explanation:

in relational database relations 1 table with:
[ user_id(pk) | add_id(pk) | date ]

pk: primary key

the other_user_id in cassandra table experiment doing improve read time cassandra @ costs of penalizing write time

thanks!

this not possible have static column on clustering level. created jira here dismissed


Comments