[ https://issues.apache.org/jira/browse/FLINK-26771?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
luoyuxia updated FLINK-26771: ----------------------------- Summary: Fix incomparable exception between boolean type and numeric type in Hive dialect (was: Fix ecompare between boolean type with numeric type in Hive dialect) > 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: Major > 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)