Thrift? Hah! Sorry, I can't help you if you are going that route. I recommend CQL - only.
-- Jack Krupansky On Tue, Mar 1, 2016 at 4:47 PM, Sandeep Kalra <sandeep.ka...@gmail.com> wrote: > The way I was planning is to give a restful interface to lookup details of > a question, and then user must get complete list of answers and its > comments. I am using thrift interface and node-js to serve it. Search on > questions are using subject tag and/or its content, > > > > Best Regards, > Sandeep Kalra > > > On Tue, Mar 1, 2016 at 2:49 PM, Jack Krupansky <jack.krupan...@gmail.com> > wrote: > >> Okay, so a very large number of questions, each with a very modest number >> of answers (generally under 5), each with a modest number of comments >> (generally under 5). >> >> Now we're back to the issue of how you wish to query and access the data. >> >> -- Jack Krupansky >> >> On Tue, Mar 1, 2016 at 12:39 PM, Sandeep Kalra <sandeep.ka...@gmail.com> >> wrote: >> >>> I do not have limit of number of Answers or its comments. Assume it to >>> be clone of StackOverflow.. >>> >>> >>> >>> Best Regards, >>> Sandeep Kalra >>> >>> >>> On Tue, Mar 1, 2016 at 11:29 AM, Jack Krupansky < >>> jack.krupan...@gmail.com> wrote: >>> >>>> Clustering columns are your friends. >>>> >>>> But the first question is how you need to query the data. Queries drive >>>> data models in Cassandra. >>>> >>>> What is the cardinality of this data - how many answers per question >>>> and how many comments per answer? >>>> >>>> >>>> -- Jack Krupansky >>>> >>>> On Tue, Mar 1, 2016 at 12:23 PM, Sandeep Kalra <sandeep.ka...@gmail.com >>>> > wrote: >>>> >>>>> Hi all. >>>>> >>>>> I am beginner in Cassandra. >>>>> >>>>> I am working on Q&A project where I have to maintain a list of list >>>>> for objects. >>>>> >>>>> For e.g. A Question can have list of Answers, and each Answer can then >>>>> have list of Comments. >>>>> >>>>> -- >>>>> As of now I have 3 tables. Questions, Answers, and Comments. I have >>>>> stored UID of Answers in List<uid of answers> for question, and then each >>>>> answer has List<UID of comments> in separate table. [Optionally a Comment >>>>> may have replies] >>>>> >>>>> I do multiple queries to find the complete answers-list and then its >>>>> related comments. >>>>> >>>>> This whole thing looks inefficient to me. >>>>> -- >>>>> >>>>> Question: >>>>> *Is there a better way to do it in Cassandra*. What can I do as far >>>>> as re-designing database to have lesser queries. >>>>> >>>>> >>>>> >>>>> Best Regards, >>>>> Sandeep Kalra >>>>> >>>>> >>>> >>> >> >
