[FLINK-27385] Field #1: values VARCHAR(2147483647) ARRAY does not exist for expression index($0, 0)

• Type: Sub-task
• Status: Closed
• Priority: Major
• Resolution: Duplicate
• Affects Version/s: 1.13.1, 1.15.0
• Component/s: Connectors / Hive
• Assignee: Unassigned
• Reporter: tartarus
• Created: 25/Apr/22 08:01
• Updated: 10/Jun/22 02:47
• Resolved: 10/Jun/22 02:47

Description

We can reproduce through a UT

Add test case in HiveDialectITCase

@Test
public void testArrayDoesNotExistForExpression() {
    tableEnv.loadModule("hive", new HiveModule(hiveCatalog.getHiveVersion()));
    tableEnv.executeSql("CREATE EXTERNAL TABLE t1(" +
            "  `record` array<struct<name:string,`values`:array<string>,value_type:string>>)" +
            "PARTITIONED BY (" +
            "  `p_date` string)");

    tableEnv.executeSql("SELECT" +
            "n as dpInfo" +
            "FROM t1" +
            "LATERAL VIEW explode(record[0].`values`) nnn as n" +
            "WHERE p_date = \"20220320\"");
} 

Issue Links

• is duplicated by: FLINK-27016 Improve supporting for complex data type for Hive dialect