hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Aihua Xu (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-10399) from_unixtime_millis() Hive UDF
Date Tue, 21 Apr 2015 21:58:00 GMT

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

Aihua Xu commented on HIVE-10399:
---------------------------------

I don't think you need such UDF. You can just call "cast(123.123 as timestamp)" to convert
a double to timestamp. Give it a try to see if it's what you want.

> from_unixtime_millis() Hive UDF
> -------------------------------
>
>                 Key: HIVE-10399
>                 URL: https://issues.apache.org/jira/browse/HIVE-10399
>             Project: Hive
>          Issue Type: New Feature
>          Components: UDF
>         Environment: HDP 2.2
>            Reporter: Hari Sekhon
>            Priority: Minor
>
> Feature request for a
> {code}from_unixtime_millis(){code}
> Hive UDF - from_unixtime() accepts only secs since epoch, and right now the solution
is to create a custom UDF, but this seems like quite a standard thing to support millisecond
precision dates in Hive natively.
> Hari Sekhon
> http://www.linkedin.com/in/harisekhon



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

Mime
View raw message