Re: Data modeling question

2012-06-29 Thread Peter Hsu
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}

Data modeling question

2012-06-29 Thread Peter Hsu
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

Re: data modeling question

2011-11-30 Thread Deno Vichas
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");

Re: data modeling question

2011-11-30 Thread David McNelis
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

Re: data modeling question

2011-11-30 Thread Deno Vichas
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

Re: data modeling question

2011-11-30 Thread David McNelis
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

data modeling question

2011-11-30 Thread Deno Vichas
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 : { : {