Re: Help me on Cassandra Data Modelling

2014-01-28 Thread Naresh Yadav
please inputs on last email if any.. On Tue, Jan 28, 2014 at 7:18 AM, Naresh Yadav nyadav@gmail.com wrote: yes thunder you are right, i had simplified that by moving *tags *search(partial/exact) in separate column family tagcombination which will act as index for all search based on

Re: Help me on Cassandra Data Modelling

2014-01-28 Thread Thunder Stumpges
Hey Naresh, Unfortunately I don't have any further advice. I keep feeling like you're looking at a search problem instead of a lookup problem. Perhaps Cassandra is not the right tool for your need in this case. Perhaps something with a full-text index type feature would help. Or perhaps someone

Re: Help me on Cassandra Data Modelling

2014-01-27 Thread Jonathan Lacefield
Hello, The trick with this data model is to get to partition based, and/or cluster based access pattern so C* returns results quickly. In C* you want to model your tables based on your query access patterns and remember that writes are cheap and fast in C*. So, try something like the

Re: Help me on Cassandra Data Modelling

2014-01-27 Thread Naresh Yadav
Thanks Jonathan for guiding me..i just want to confirm my understanding : create columnfamily tagcombinations { partialtags text, tagcombinationid text, tagcombinationtags settags Primary Key((partialtags), tagcombinationid) } IF i need to store TWO tagcombination TC1 as India,

Re: Help me on Cassandra Data Modelling

2014-01-27 Thread Thunder Stumpges
Hey Naresh, You asked a similar question a week or two ago. It looks like you have simplified your needs quite a bit. Were you able to adjust your requirements or separate the issue? You had a complicated time dimension before, as well as a single query for multiple AND cases on tags.

Re: Help me on Cassandra Data Modelling

2014-01-27 Thread Naresh Yadav
yes thunder you are right, i had simplified that by moving *tags *search(partial/exact) in separate column family tagcombination which will act as index for all search based on tags and in my my original metricresult table will store tagcombinationid and time in columns otherwise it was getting