You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@flink.apache.org by "luoyuxia (Jira)" <ji...@apache.org> on 2022/04/25 10:24:00 UTC
[jira] [Comment Edited] (FLINK-27385) Field #1: values VARCHAR(2147483647) ARRAY does not exist for expression index($0, 0)
[ https://issues.apache.org/jira/browse/FLINK-27385?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17527404#comment-17527404 ]
luoyuxia edited comment on FLINK-27385 at 4/25/22 10:23 AM:
------------------------------------------------------------
[~tartarus] Thanks for reportiing it. I also noticed such case and had created a Jira [Flink-27016|https://issues.apache.org/jira/browse/FLINK-27016].
The pr is available [https://github.com/apache/flink/pull/19283]
The failure can be fixed by this patch.
was (Author: luoyuxia):
[~tartarus] Thanks for reportiing it. I also noticed such case and had created a Jira [Flink-27016|https://issues.apache.org/jira/browse/FLINK-27016].
The pr is available [https://github.com/apache/flink/pull/19283]
The failure can be fixed by this patch.
> 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
> Priority: Major
>
> 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)