Hello all,
I have a data set with attributes content and year. I want to put them in
to CF 'words' with attributes ('content','year','frequency'). The CF should
support following operations.
- Frequency attribute of a column can be updated (i.e. - : can run query
like "UPDATE words SET frequency = 2 WHERE content='abc' AND year=1990;),
where clause should contain content and year
- Should support select query like "Select content from words where year
= 2010 ORDER BY frequency DESC LIMIT 10;" (where clause only has year)
where results can be ordered using frequency
Is this kind of requirement can be fulfilled using Cassandra? What is the
CF structure and indexing I need to use here? What queries should I use to
create CF and in indexing?
Thank You!
--
*Chamila Dilshan Wijayarathna,*
SMIEEE, SMIESL,
Undergraduate,
Department of Computer Science and Engineering,
University of Moratuwa.
