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 m

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 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 tags and in my my o

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 com

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. > c)

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 set Primary Key((partialtags), tagcombinationid) } IF i need to store TWO tagcombination TC1 as India, Pencil A

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 followi

Help me on Cassandra Data Modelling

2014-01-27 Thread Naresh Yadav
Hi all, Urgently need help on modelling this usecase on Cassandra. I have concept of tags and tagcombinations. For example U.S.A and Pen are two tags AND if they come together in some definition then register a tagcombination(U.S.A-Pen) for that.. *tags *(U.S.A, Pen, Pencil, India, Shampoo) *tag