[
https://issues.apache.org/jira/browse/FLINK-26542?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17503280#comment-17503280
]
luoyuxia edited comment on FLINK-26542 at 3/9/22, 9:24 AM:
-----------------------------------------------------------
It's a know issue of Hive, fixed in
[HIVE-19770|https://issues.apache.org/jira/browse/HIVE-19770] only need the
apply this patch to Flink.
was (Author: luoyuxia):
To fix it, we need to generate unique column alias for such case.
> Hive dialect supports queries with multiple same columns in select
> -------------------------------------------------------------------
>
> Key: FLINK-26542
> URL: https://issues.apache.org/jira/browse/FLINK-26542
> Project: Flink
> Issue Type: Sub-task
> Components: Connectors / Hive
> Reporter: luoyuxia
> Priority: Major
> Labels: pull-request-available
> Fix For: 1.16.0
>
>
> With Hive dialect, when select cluster contains multiple same columns,
> it'll will throw .
> It can be reproduced using the following code in HiveDialectITCase
> {code:java}
> tableEnv.executeSql("create table src(key string, value string)");
> List<Row> results =
> queryResult(
> tableEnv.sqlQuery(
> "select key, key from src"));
> {code}
--
This message was sent by Atlassian Jira
(v8.20.1#820001)
