cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Anuj Kabra <anu...@thoughtworks.com>
Subject Looking for something like "like" of mysql.
Date Thu, 02 Sep 2010 16:27:31 GMT
I am working with cassandra-0.6.4. I am working on mail retreival problem.
We have the metadata of mail like sender, recipient, timestamp, subject and
the location of mail file stored in a cassandra DB.Everyday about 25,000
records will

be entered to this DB. We have not finalised on the data model yet but
starting with a simple one having only one column family.
<ColumnFamily name="MailMetadata" CompareWith="UTF8Type">
which have user_id of recipient as key.and columns for sender_id, timestamp
of mail, subject and location of mail file.
Now our Use case is to get the locations of all mail files which are being
sent by a user matching a given subject(can be a part of the original
subject of mail). Well according to my knowledge till now, we can get all
the rows of a user

by using user_id as key. After that i need to iterate over all the rows i
get and see which mail seems to fit the given condition.(matching a subject
in this case), which is very heavy computationally as we would get thousands
of rows.
So we are looking for something like "like" of mysql provided by thrift. I
also need to know if am going the right way.
Help is much appreciated.

Mime
View raw message