cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ed Anuff>
Subject Re: Querying by date range when using TimeUUIDType ColumnFamily?
Date Tue, 27 Apr 2010 23:20:48 GMT
Yes, Lucas was correct about the nature of my original question.  I'm glad
to hear that Justin's solution works, it makes for a much simpler schema.


On Tue, Apr 27, 2010 at 3:06 PM, Lucas Di Pentima

> El 27/04/2010, a las 18:23, Lee Parker escribió:
> > I have used the solution presented by Justin and it works just fine.
>  When you construct a TimeUUID with a specific timestamp and use that for
> the start or finish of the range slice, cassandra will use the timestamp
> embedded in the UUID even if that specific UUID doesn't exist in the index.
>  It is not an ideal solution because the timestamp you pass in may not have
> the same granularity as the one used to create your current indexes.  So,
> you might be using a standard unix epoch timestamp in seconds, while a true
> TimeUUID uses 100 nanosecond slices of time.
> I've tried it and am amazed of this feature, I don't know why I supposed
> that wouldn't work, thanks Lee & Justin!!! :)
> --
> Lucas Di Pentima - Santa Fe, Argentina
> Jabber:
> MSN:

View raw message