As usual, the first step should be to example your queries and use them as the guide to data modeling. So... how do you need to access the data? What columns do you need to be able to query on vs. merely return? What data needs to be accessed at the same time? What data does not need to be accessed at the same time?
-- Jack Krupansky On Thu, Jan 28, 2016 at 5:51 PM, Qi Li <[email protected]> wrote: > Hi all, > > I've found something in Internet, but still want to consult with your > expertise. > > I'm designing a table, the object model will be like, > class Data{ > String uuid; //partition key > String value1; > String value2; > ... > String valueN; > Map<String, Double> mapValues; > } > > > For one Data object, I would like it to be saved into one wide row in C*, > that means the mapValues will be extended as dynamic columns. AFAIK, I can > put the mapValues' key into Cluster column, then C* will use the wide row > to save the data. Then I would use 'uuid' as partition key, and mapKey into > cluster key. My question is for the other columns : value1 to valueN, shall > I put them into ClusterKey too? like below, > > create table Data ( > text uuid; > text value1; > text value2; > ... > text valueN; > text mapKey; > Double mapValue; > primary key(key, mapKey, value1, value2, ..., valueN); > ); > > The reason I put them into cluster keys is I don't want value1 to valueN > are saved duplicated each time when the mapKey is created. For example, the > mapValues can have 100 entries, I don't want value1 to valueN are saved 100 > times, I only want them saved 1 time together with the partition key. Is > this correct? > > Thanks for your help. > > -- > Ken Li >
