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