cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Michaël Figuière (JIRA) <j...@apache.org>
Subject [jira] [Created] (CASSANDRA-9229) Add functions to convert timeuuid to date or time
Date Thu, 23 Apr 2015 17:51:41 GMT
Michaël Figuière created CASSANDRA-9229:
-------------------------------------------

             Summary: Add functions to convert timeuuid to date or time
                 Key: CASSANDRA-9229
                 URL: https://issues.apache.org/jira/browse/CASSANDRA-9229
             Project: Cassandra
          Issue Type: New Feature
            Reporter: Michaël Figuière


As CASSANDRA-7523 brings the {{date}} and {{time}} native types to Cassandra, it would be
useful to add builtin function to convert {{timeuuid}} to these two new types, just like {{dateOf()}}
is doing for timestamps.

{{timeOf()}} would extract the time component from a {{timeuuid}}. Example use case could
be at insert time with for instance {{timeOf(now())}}, as well as at read time to compare
the time component of a {{timeuuid}} column in a {{WHERE}} clause.

The use cases would be similar for {{date}} but the solution is slightly less obvious, as
in a perfect world we would want {{dateOf()}} to convert to {{date}} and {{timestampOf()}}
for {{timestamp}}, unfortunately {{dateOf()}} already exist and convert to a {{timestamp}},
not a {{date}}. Making this change would break many existing CQL queries which is not acceptable.
Therefore we could use a different name formatting logic such as {{toDate}} or {{dateFrom}}.
We could then also consider using this new name convention for the 3 dates related types and
just have {{dateOf}} becoming a deprecated alias.




--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message