You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@hive.apache.org by "Zoltan Haindrich (JIRA)" <ji...@apache.org> on 2017/04/21 19:25:04 UTC

[jira] [Created] (HIVE-16505) Support "unknown" boolean truth value

Zoltan Haindrich created HIVE-16505:
---------------------------------------

             Summary: Support "unknown" boolean truth value
                 Key: HIVE-16505
                 URL: https://issues.apache.org/jira/browse/HIVE-16505
             Project: Hive
          Issue Type: Sub-task
            Reporter: Zoltan Haindrich


according to the standard, boolean truth value might be: {{TRUE|FALSE|UNKNOWN}}.

similar queries to the following should be supported:
{code}
select 1 where null is unknown;
select 1 where (select cast(null as boolean) ) is unknown;
{code}

"unknown" behaves similarily to null. {{(null=null) is null}}



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)