[CASSANDRA-6395] Add the ability to query by TimeUUIDs with milisecond granularity

• Type: New Feature
• Status: Resolved
• Priority: Low
• Resolution: Fixed
• Fix Version/s: 2.0.4
• Labels: lhf
• Assignee: Lorcan Coyle
• Reporter: Lorcan Coyle

Authors

Lorcan Coyle

Reviewers

Aleksey Yeschenko

• Created: 22/Nov/13 13:01
• Updated: 16/Apr/19 09:31
• Resolved: 24/Nov/13 18:25

Description

Currently it is impossible to query for dates with the minTimeuuid and maxTimeuuid functions with sub-second accuracy from cqlsh because the parser doesn't recognise dates formatted at that granularity (e.g., 2013-09-30 22:19:06.591). By adding the following ISO8601 patterns to TimestampSerializer this functionality is unlocked:

"yyyy-MM-dd HH:mm:ss.SSS",
"yyyy-MM-dd HH:mm:ss.SSSZ",
"yyyy-MM-dd'T'HH:mm:ss.SSS",
"yyyy-MM-dd'T'HH:mm:ss.SSSZ".

I submitted this as a pull-request on the github mirror (https://github.com/apache/cassandra/pull/23), which I'll close now. I'll submit a patch to address this here.