[
https://issues.apache.org/jira/browse/FLINK-26771?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Jark Wu closed FLINK-26771.
---------------------------
Resolution: Fixed
Fixed in master: 1455e51c7cd64264f5ddebd0b768efc109fab74f
> Fix incomparable exception between boolean type and numeric type in Hive
> dialect
> --------------------------------------------------------------------------------
>
> Key: FLINK-26771
> URL: https://issues.apache.org/jira/browse/FLINK-26771
> Project: Flink
> Issue Type: Sub-task
> Components: Connectors / Hive
> Reporter: luoyuxia
> Assignee: luoyuxia
> Priority: Critical
> Labels: pull-request-available, stale-assigned
> 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.10#820010)