cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Joshua McKenzie (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (CASSANDRA-9229) Add functions to convert timeuuid to date or time
Date Mon, 11 May 2015 12:42:34 GMT

    [ https://issues.apache.org/jira/browse/CASSANDRA-9229?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14537891#comment-14537891
] 

Joshua McKenzie commented on CASSANDRA-9229:
--------------------------------------------

bq. Having that said, I'd like to leave any time-conversion up to the client
I agree with that; my thought was that if we give the conversion to them in terms of UTC and
let them do TZ conversion on their side that's getting half of the way there rather than forcing
clients to roll their own toTime and TZ both.

> 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
>            Assignee: Benjamin Lerer
>              Labels: cql, doc-impacting
>             Fix For: 3.x
>
>         Attachments: CASSANDRA-9229.txt
>
>
> 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