Take the 2-minute tour ×  Forgive me for asking something that
is probably explained elsewhere, but I am having trouble
designing a data model in Cassandra.  I am storing transactions.
These transactions each have a source (user), a timestamp, and
some associated keywords. I need to be able to find transactions
given the source and a date range and (optional) keywords.
Cassandra is attractive because I need to store billions of
transactions.  I have been unable to find a resource that
explains how to do this type of thing. My initial thoughts
involve having a few CFs - a transaction CF, a
keyword_transaction CF, a source_transaction CF, and possible a
day_transaction CF (or something similar). This would make it
very straight forward to find transactions based on any one of
the above items, but it doesn't seem like it will let me search
on all of the above items.  Any thoughts?  share|improve this
question add comment  1 Answer  Start by thinking your query and
then to your data model. Read here and here as t