Sergio Leoni created IMPALA-8367:
------------------------------------
Summary: from_unixtime Bad date/time conversion format: u on NULL
value
Key: IMPALA-8367
URL: https://issues.apache.org/jira/browse/IMPALA-8367
Project: IMPALA
Issue Type: Bug
Components: Backend
Affects Versions: Impala 2.11.0
Environment: impalad version 2.11.0-cdh5.14.2 RELEASE (build
ed85dce709da9557aeb28be89e8044947708876c) Built on Tue Mar 27 13:39:48 PDT 2018
Reporter: Sergio Leoni
The function
{code:sql}
from_unixtime(bigint unixtime[, string format]) {code}
output error if the value of unixtime is NULL and format is 'u'.
This doesn't work:
{code:sql}
SELECT FROM_UNIXTIME(NULL, 'u')
{code}
{noformat}
Bad date/time conversion format: u{noformat}
This works:
{code:sql}
SELECT FROM_UNIXTIME(NULL, 'yyyy-MM-dd')
{code}
{noformat}
|from_unixtime(null, 'yyyy-mm-dd')|
|---------------------------------|
| NULL |
|---------------------------------|{noformat}
I haven't check all the possible combinations.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
