You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Ning Zhang (JIRA)" <ji...@apache.org> on 2010/01/13 21:21:54 UTC
[jira] Commented: (HIVE-983) Function from_unixtime only takes Int.
Override to support Long
[ https://issues.apache.org/jira/browse/HIVE-983?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12799912#action_12799912 ]
Ning Zhang commented on HIVE-983:
---------------------------------
> We also have dates stored with milliseconds which blows up the integer limitation. Long support will be helpful.
Matt, please note that the first parameter in from_unixtime() is the # of "seconds". So after we add the support for LongWritable, you still need to convert milliseconds to seconds when calling the function.
> Function from_unixtime only takes Int. Override to support Long
> ----------------------------------------------------------------
>
> Key: HIVE-983
> URL: https://issues.apache.org/jira/browse/HIVE-983
> Project: Hadoop Hive
> Issue Type: Improvement
> Reporter: Matt Pestritto
> Assignee: Ning Zhang
> Priority: Minor
>
> UDFFromUnixTime.java only supports int. We have dates that are future dated so they fail when it tries to parse. Can there be additional support for LongWritable input parameter ?
> We also have dates stored with milliseconds which blows up the integer limitation. Long support will be helpful.
> FAILED: Error in semantic analysis: line 1:7 Function Argument Type Mismatch from_unixtime: Looking for UDF "from_unixtime" with parameters [class org.apache.hadoop.io.LongWritable
> ]
> 09/12/14 11:42:10 ERROR ql.Driver: FAILED: Error in semantic analysis: line 1:7 Function Argument Type Mismatch from_unixtime: Looking for UDF "from_unixtime" with parameters [clas
> s org.apache.hadoop.io.LongWritable]
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.