You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Giacomo Ghidini (JIRA)" <ji...@apache.org> on 2014/05/16 12:48:05 UTC
[jira] [Created] (HIVE-7070) UDF conversion with from_unixtime from
timestamp to yyyy-ww format returns wrong year for days in next-year week
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)