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

Posted to dev@flink.apache.org by "luoyuxia (Jira)" <ji...@apache.org> on 2022/03/21 09:43:00 UTC

[jira] [Created] (FLINK-26771) Hive dialect supports to compare boolean type with numeric type

luoyuxia created FLINK-26771:
--------------------------------

             Summary: Hive dialect supports to compare boolean type with numeric type
                 Key: FLINK-26771
                 URL: https://issues.apache.org/jira/browse/FLINK-26771
             Project: Flink
          Issue Type: Improvement
          Components: Connectors / Hive
            Reporter: luoyuxia
             Fix For: 1.16.0


Hive support compare boolean type with numeric type, for example such sql can be excuted in Hive:
{code:java}
// the data type for `status` is `int`
select * from employee where status = true;  {code}
But in Flink, with Hive dialect, it'll throw  "Incomparable types: BOOLEAN and INT NOT NULL" exception.

For such case, it should be consistent with Hive while using Hive dialect in Flink.



--
This message was sent by Atlassian Jira
(v8.20.1#820001)