You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Ashish Kumar Singh (JIRA)" <ji...@apache.org> on 2014/05/23 23:37:03 UTC
[jira] [Commented] (HIVE-7070) UDF conversion with from_unixtime
from timestamp to yyyy-ww format returns wrong year for days in next-year
week
[ https://issues.apache.org/jira/browse/HIVE-7070?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14007743#comment-14007743 ]
Ashish Kumar Singh commented on HIVE-7070:
------------------------------------------
Not an issue in Hive 0.12.
> UDF conversion with from_unixtime from timestamp to yyyy-ww format returns wrong year for days in next-year week
> ----------------------------------------------------------------------------------------------------------------
>
> Key: HIVE-7070
> URL: https://issues.apache.org/jira/browse/HIVE-7070
> Project: Hive
> Issue Type: Bug
> Components: UDF
> Affects Versions: 0.11.0
> Environment: AWS EMR AMI Version 3.0.4
> Reporter: Giacomo Ghidini
>
> The function {{from_unixtime(<unixtimestampinsecondsfromepoch>, 'yyyy-ww')}} returns the following:
> # Input: 1387670400 -- 1388275199 (2013-12-22 -- 2013-12-28T23:59:59) --> 2013-52
> # Input: 1388275200 -- 1388534399 (2013-12-29 -- 2013-12-31T23:59:59) --> {color:red}2013-01 instead of 2014-01{color}
> # Input: 1388534400 -- 1388879999 (2014-01-01 -- 2014-01-04T23:59:59) --> 2014-01
> # Input: 1388880000 -- 1389484799 (2014-01-05 -- 2014-01-11T23:59:59) --> 2014-02
--
This message was sent by Atlassian JIRA
(v6.2#6252)