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

["godfrey he (Jira)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/FLINK-26771?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

godfrey he reassigned FLINK-26771:
----------------------------------

    Assignee: luoyuxia

> 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: Sub-task
>          Components: Connectors / Hive
>            Reporter: luoyuxia
>            Assignee: luoyuxia
>            Priority: Major
>              Labels: pull-request-available
>             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.7#820007)