[
https://issues.apache.org/jira/browse/PHOENIX-688?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14221703#comment-14221703
]
Alicia Ying Shu commented on PHOENIX-688:
-----------------------------------------
Attached the patch for work in-progress. Followed the instructions in the Jira
description to add build-in functions. It works on default patterns. Need to
see whether there is any additional consideration for To_Time() and
To_Timestamp(). As far as I know Hive supports only To_Date().
> Add to_time and to_timestamp built-in functions
> -----------------------------------------------
>
> Key: PHOENIX-688
> URL: https://issues.apache.org/jira/browse/PHOENIX-688
> Project: Phoenix
> Issue Type: Task
> Affects Versions: 3.0-Release
> Reporter: James Taylor
> Assignee: Alicia Ying Shu
> Attachments: PHOENIX-688.patch
>
>
> We already have a to_date function implemented by ToDateFunction, so adding a
> ToTimeFunction could be done by just deriving the class from ToDateFunction
> and changing the getDataType() to be PDataType.TIME instead.
> For a general overview on adding a new built-in function, see the phoenix
> blog
> [here](http://phoenix-hbase.blogspot.com/2013/04/how-to-add-your-own-built-in-function.html)
> The to_timestamp function would be similar as well, but in this case we'd
> want to register a new ToTimestampParseNode (very similar to
> ToDateParseNode), that uses the DateUtil.getTimestampParser(format) to create
> the timestamp instance. This class would then be defined in the
> ToTimestampFunction as the nodeClass attribute (which would cause it to be
> used to construct a ToTimestampFunction at compile time).
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
