[jira] [Commented] (FLINK-27378) Unexpected rexnode : org.apache.calcite.rex.RexFieldAccess

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

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

luoyuxia commented on FLINK-27378:
----------------------------------

[~tartarus] Thanks for reportiing it. I also noticed such case and had created a Jira Flink-27016. 

The pr is available [https://github.com/apache/flink/pull/19283]

The failure can be fixed by this patch.

> Unexpected rexnode : org.apache.calcite.rex.RexFieldAccess
> ----------------------------------------------------------
>
>                 Key: FLINK-27378
>                 URL: https://issues.apache.org/jira/browse/FLINK-27378
>             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 testHiveUnexpectedRexFieldAccess() {
>     tableEnv.executeSql("create table src (id bigint, type string, complex_struct struct<result:array<struct<name:string,score:double,rank:int>>>) partitioned by (p_date string)");
>     tableEnv.executeSql("select complex_struct.result.name as tags from src where p_date = '20220319'");
> } {code}



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