[jira] [Comment Edited] (FLINK-27296) CalcOperator CodeGenException: Boolean expression type expected

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

    [ https://issues.apache.org/jira/browse/FLINK-27296?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17527920#comment-17527920 ] 

luoyuxia edited comment on FLINK-27296 at 4/26/22 6:29 AM:
-----------------------------------------------------------

More detail analysis is in FLINK-27402.

At end, I prefer to fix it in Flink-26771 for the root cause is same. Both of them are it's not supported to cast boolean to string/int implicitly.


was (Author: luoyuxia):
More detail analysis is in FLINK-27402.

At end, I perfer to fix it in [Flink-26771|https://issues.apache.org/jira/browse/FLINK-26771] for the root cause is same. Both of them are it's not supported to cast boolean to string/int implicitly.

> CalcOperator CodeGenException: Boolean expression type expected
> ---------------------------------------------------------------
>
>                 Key: FLINK-27296
>                 URL: https://issues.apache.org/jira/browse/FLINK-27296
>             Project: Flink
>          Issue Type: Sub-task
>          Components: Connectors / Hive
>    Affects Versions: 1.13.1, 1.15.0
>            Reporter: tartarus
>            Priority: Major
>
> We can reproduce through a UT
> Add test case in HiveDialectITCase
> {code:java}
>     @Test
>     public void testHiveBooleanExpressionTypeExpected() {
>         tableEnv.loadModule("hive", new HiveModule(hiveCatalog.getHiveVersion()));
>         tableEnv.executeSql(
>                 "create table src (x int,y string, z int, a map<string,string>) partitioned by (p_date string)");
>         tableEnv.executeSql(
>                 "select * from src where x > 0 and a['liveStream_isFemale'] = true ");
>     } {code}



--
This message was sent by Atlassian Jira
(v8.20.7#820007)