Having separate columns for Year, Month etc seems redundant. It's tons more efficient to keep say UTC time in POSIX format (basically integer). It's easy to convert back and forth.
If you want to get a range of dates, in that case you might use Order Preserving Partitioner, and sort out which systems logged later in client. Read up on consequences of using OPP. Whether to shard data as per system depends on how many you have. If more than a few, don't do that, there are memory considerations. Cheers Maxim -- View this message in context: http://cassandra-user-incubator-apache-org.3065146.n2.nabble.com/Schema-Design-tp5964167p5964227.html Sent from the cassandra-u...@incubator.apache.org mailing list archive at Nabble.com.