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)
