[
https://issues.apache.org/jira/browse/FLINK-30030?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17637203#comment-17637203
]
Jing Zhang commented on FLINK-30030:
------------------------------------
[~luoyuxia] Thanks for open this issue.
We also received some flink batch user's complain, they said if they run the
following query multiple times, they would got wrong result.
{code:java}
// SQL
insert
overwrite table `db.tb` partition(p_date)
select ** {code}
> Unexpected behavior for overwrite in Hive dialect
> -------------------------------------------------
>
> Key: FLINK-30030
> URL: https://issues.apache.org/jira/browse/FLINK-30030
> Project: Flink
> Issue Type: Bug
> Components: Connectors / Hive
> Affects Versions: 1.15.0
> Reporter: luoyuxia
> Priority: Major
> Labels: pull-request-available
>
> When overwrite a table in hive dialect, it might not overwrite but to append.
> It can reproduce using the following sql:
> {code:java}
> insert into table `db.tab` values (1, 2) {code}
> only happen when the table is encapsulated by backquote and the table contain
> two splits with ".".
>
> Just find the behavior in hive is also incorrect as reported in HIVE-26741.
> Let'us keep to see what's the expected behavior.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
