[jira] [Created] (IMPALA-8367) from_unixtime Bad date/time conversion format: u on NULL value

["Sergio Leoni (JIRA)" <ji...@apache.org>]

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: issues-all-unsubscribe@impala.apache.org
For additional commands, e-mail: issues-all-help@impala.apache.org