FluentCassandra Range Selection Problem

Question

I have a problem getting some data from Cassandra using C # and FluentCassandra. In my Cassandra key space, I have the following definition of a supercommand family:

<ColumnFamily Name="MySCFName"
                    ColumnType="Super"
                    CompareWith="TimeUUIDType"

                CompareSubcolumnsWith="AsciiType"/>

What I would like to do is run a query on this supercolumn, similar to the following in sql:

select "something" from MyTable where "timestamp" between "2011-01-01 00:00:00.000" and "2011-03-01 00:00:00.000"

Following one tutorial, I found that I can get some data from Cassandra with the following command:

family.Get("238028210009775").Fetch(DateTime.Parse("2011-01-01 00:00:00.000")).FirstOrDefault();

but it is equivalent in sql "timestamp" > "2011-01-01 00:00:00.000"

and so far I can’t figure out how to extract data from a range of values.

Any tips or help would be appreciated :) Thanks in advance, Nicola

Answer 1

:

using (var db = new CassandraContext(keyspace: "keyspace_name", host: "localhost"))
{
    var fromDate = DateTime.Now.Subtract(new TimeSpan(0, 30, 0));
    var toDate = DateTime.Now;
    var family = db.GetColumnFamily<TimeUUIDType, AsciiType>("family_name");
    var results = family.Get("row_key")
                        .Fetch(fromDate)
                        .TakeUntil(toDate)
                        .FirstOrDefault();
}