hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Zoltan Haindrich (JIRA)" <>
Subject [jira] [Created] (HIVE-16505) Support "unknown" boolean truth value
Date Fri, 21 Apr 2017 19:25:04 GMT
Zoltan Haindrich created HIVE-16505:

             Summary: Support "unknown" boolean truth value
                 Key: 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:
select 1 where null is unknown;
select 1 where (select cast(null as boolean) ) is unknown;

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

This message was sent by Atlassian JIRA

View raw message