I am in very early stage , so, I can change. Infact, the videos you pointed also says to do so...
Best Regards, Sandeep Kalra On Tue, Mar 1, 2016 at 3:58 PM, Jack Krupansky <jack.krupan...@gmail.com> wrote: > 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 >>>>>> >>>>>> >>>>> >>>> >>> >> >
