hadoop-hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Ning Zhang (JIRA)" <j...@apache.org>
Subject [jira] Commented: (HIVE-983) Function from_unixtime only takes Int. Override to support Long
Date Wed, 13 Jan 2010 20:21:54 GMT

    [ 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.


Mime
View raw message