Cassandra does not support ad-hoc queries the way SQL does. If you want to ask "what rows have a column X containing value Y" then you need to create a columnfamily whose keys are the values of X, and whose columns are the keys of your original CF.
Read http://arin.me/blog/wtf-is-a-supercolumn-cassandra-data-model if you haven't yet. On Fri, Jan 29, 2010 at 6:16 AM, Mehar Chaitanya <meharchaita...@gmail.com> wrote: > Hi All > > I am a J2EE programmer only i had knowledge related to queries i will query > the sql where i can found the result. > > How can i use cassandra for my requirement is it possible? > > Below is my scenario > > - I have a table which contains columns like > Category_name,Section_name,article,is_published_by with multiple records > in the table. > - I want to retrieve a query based on condition like belongs some > category_name 'X' . > - Same will be applied to other 3 ,condition based on Section and > is_published_by > > > Please let me know if it would be possible. > > Thanks&Regards, > Mehar Chaitanya Bandaru, > Software Engineer, > S cubes IT Solutions India Pvt. Ltd., > http://www.scubian.com > (W) +91 4040307821, > (Cell) +91 9440 999 262, > #4-1-319, 2nd Floor, Abids Road, Hyderabad - 01. >
