static column is exactly what I want!
Thank you Duyhai!
On Fri, 29 Jan 2016 07:22 DuyHai Doan wrote:
> This data model should do the job
>
> Create table Data (
>text uuid;
>text value1 static;
>text value2 static;
>...
>text valueN static;
>text mapKey;
>Double mapV
This data model should do the job
Create table Data (
text uuid;
text value1 static;
text value2 static;
...
text valueN static;
text mapKey;
Double mapValue;
primary key(key, mapKey);
);
Warning, value1... valueN being static, there will be a 1:1 relationship
between them
Thanks Jack.
the columns to be used for query will be 'uuid' and 'key' in mapValues. For
value1 to valueN, and Double in mapValues will be merely return.
there are 2 scenarios to query.
1. Query for value, it can be any one from value1 to valueN. The query
criteria will be 'uuid'.
2. Query for th
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
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 mapValues;
}
For one
