[IMPALA-5146] from_unixtime() given an out-of-range unix time produces inconsistent results

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: Impala 2.11.0
• Component/s: Backend
• Labels: newbie
• Epic Link: Timestamp Compatibility
• Target Version: Product Backlog
• Epic Color: ghx-label-6
• Assignee: Jin Chul Kim
• Reporter: Daniel Hecht
• Created: 31/Mar/17 17:04
• Updated: 29/Nov/17 07:19
• Resolved: 29/Nov/17 05:24

Description

The FROM_UNIXTIME(time) and FROM_UNIXTIME(time, fmt) produce different results when time is out of range of TimestampValue. The former produces an empty string, while the latter gives null (the latter being better).

[dhecht-desktop.ca.cloudera.com:21000] > select from_unixtime(999999999999999);
Query: select from_unixtime(999999999999999)
Query submitted at: 2017-03-31 10:00:14 (Coordinator: http://dhecht-desktop.ca.cloudera.com:25000)
Query progress can be monitored at: http://dhecht-desktop.ca.cloudera.com:25000/query_plan?query_id=ee4630ce642b62eb:c666b0f500000000
+--------------------------------+
| from_unixtime(999999999999999) |
+--------------------------------+
|                                |
+--------------------------------+
Fetched 1 row(s) in 0.01s
[dhecht-desktop.ca.cloudera.com:21000] > select from_unixtime(999999999999999, "yyyy-MM-dd HH:mm:ss.SSSS");
Query: select from_unixtime(999999999999999, "yyyy-MM-dd HH:mm:ss.SSSS")
Query submitted at: 2017-03-31 10:03:47 (Coordinator: http://dhecht-desktop.ca.cloudera.com:25000)
Query progress can be monitored at: http://dhecht-desktop.ca.cloudera.com:25000/query_plan?query_id=4d46d2087b6f74c0:8ab6d24600000000
+------------------------------------------------------------+
| from_unixtime(999999999999999, 'yyyy-mm-dd hh:mm:ss.ssss') |
+------------------------------------------------------------+
| NULL                                                       |
+------------------------------------------------------------+
Fetched 1 row(s) in 0.01s