Giacomo Ghidini created HIVE-7070:
-------------------------------------
Summary: 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)
