Just read up on composite keys and what looks like future deprecation of super
column families.
I guess Option 2 would now be:
- column family with composite key from grouping and location
> e.g.
> '0:0,0': { meta }
> ...
> '0:10,10' : { meta }
> '1:10,0' : {meta}
> …
> '1:20, 10': {meta}
I have a question on what the best way is to store the data in my schema.
The data
I have millions of nodes, each with a different cartesian coordinate. The keys
for the nodes are hashed based on the coordinate.
My search is a proximity search. I'd like to find all the nodes within a given
di
here's what i ended up, this seems to work for me.
@Test
public void readAndWriteSettingTTL() throws Exception {
int ttl = 2;
String columnFamily = "Quote";
Set symbols = new HashSet(){{
add("appl");
You wouldn't query for all the keys that have a column name x exactly.
Instead what you would do is for sector x grab your list of symbols S.
Then you would get the last column for each of those symbols (which you do
in different ways depending on the API), and then test if that date is
within yo
with the quote CF below how would one query for all keys that have a
column name value that have a timeuuid of later than x minutes? i need
to be able to find all symbols that have not been fetch in x minutes by
sector. i know i get list of symbol by sector from my sector CF.
thanks,
deno
O
Personally I would create a separate column family for each basic area.
For example
To organize my sectors and symbols I would create a column family where the
key is the sector name and the column names are the symbols for that
sector, i.e.:
sector : {
key: sector name
Column names: sym
hey all!
i'm started my first project using cassandra and some data model
questions. i'm working on an app that fetches stock market data. i
need to keep track of when i fetch a set of data for any given stock in
any sector; here's what i think my model should look like;
fetches : {
: {
