[
https://issues.apache.org/jira/browse/FLINK-15066?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16995329#comment-16995329
]
Danny Chen commented on FLINK-15066:
------------------------------------
Thank [~liyu] for checking this, here are something i want to clarify:
1. INSERT OVERWRITE is not supported in SQL-CLI now, without this syntax, it is
hard to make sure what the semantic of writing file. So in my personal option,
the best way is to keep as it is, until we add full support for INSERT
OVERWRITE;
2. The overwrite attribute is not supported now, and the existing file path
check is handled by the CsvTableSink, we may need some refactoring to support
this;
So overall, this is not a bug, this is a usability improvement.
> Cannot run multiple `insert into csvTable values ()`
> ----------------------------------------------------
>
> Key: FLINK-15066
> URL: https://issues.apache.org/jira/browse/FLINK-15066
> Project: Flink
> Issue Type: Bug
> Components: Table SQL / Client
> Reporter: Kurt Young
> Assignee: Danny Chen
> Priority: Major
> Fix For: 1.10.0
>
>
> I created a csv table in sql client, and tried to insert some data into this
> table.
> The first insert into success, but the second one failed with exception:
> {code:java}
> // Caused by: java.io.IOException: File or directory /.../xxx.csv already
> exists. Existing files and directories are not overwritten in NO_OVERWRITE
> mode. Use OVERWRITE mode to overwrite existing files and directories. at
> org.apache.flink.core.fs.FileSystem.initOutPathLocalFS(FileSystem.java:817)
> {code}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
