database design - how to change (update) a hbase row key value from aaa to bbb for example? -
how can change row key value in hbase row key made of column in table , values doesn't come in same time. after update value of column want update row key possible do? example have c1 , c2 , c3 columns , uniq value in each row c1, c2 , row key c1.value concatenate c2.value. first insert fill c1 , row key c1 next time fill c2 existing row (c1) , row key must set c1c2 c1 existing row
at splice machine (open source) hit problem base table , index table updates in hbase. "update" delete , insert when primary key or index key modified (no way around that). in our system this...
create table foo (col1, col2, primary key(col1)); insert foo values (1,2),(3,4);
update foo set col1 = col2;
we delete rows 1,3 , write rows 2,4 inside single transaction/buffer.
hope helps , luck.
here link our community site in case want @ our code.
Comments
Post a Comment