You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "philipse (JIRA)" <ji...@apache.org> on 2019/05/11 02:49:02 UTC

[jira] [Created] (HIVE-21721) nvl function fail with NullPointerException if the two paramtype are different

philipse created HIVE-21721:
-------------------------------

             Summary: nvl function fail with NullPointerException if the two paramtype are different
                 Key: HIVE-21721
                 URL: https://issues.apache.org/jira/browse/HIVE-21721
             Project: Hive
          Issue Type: Bug
          Components: Parser
    Affects Versions: 1.1.0
            Reporter: philipse
            Assignee: philipse
         Attachments: image-2019-05-11-10-41-05-168.png

Hi all

when i user nvl and case when fucntion, it behaviors like the following.which is weird to me, and makes me headache everytime. i need to check where the nullpointexception throws out when it hadppens,So can the reasons more friendly to users,

!image-2019-05-11-10-41-05-168.png!
{code:java}
select nvl(cast('2019-05-10 11:11:11,111' as timestamp),'2019-05-10 11:11:11,111');
Error: Error while compiling statement: FAILED: NullPointerException null (state=42000,code=40000)
{code}



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)