You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@flink.apache.org by "tartarus (Jira)" <ji...@apache.org> on 2022/04/25 08:02:00 UTC

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

tartarus created FLINK-27385:
--------------------------------

             Summary: Field #1: values VARCHAR(2147483647) ARRAY does not exist for expression index($0, 0)
                 Key: FLINK-27385
                 URL: https://issues.apache.org/jira/browse/FLINK-27385
             Project: Flink
          Issue Type: Sub-task
          Components: Connectors / Hive
    Affects Versions: 1.13.1, 1.15.0
            Reporter: tartarus


We can reproduce through a UT

Add test case in HiveDialectITCase
{code:java}
@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\"");
} {code}



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