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
Post a Comment