[jira] [Commented] (FLINK-15066) Cannot run multiple `insert into csvTable values ()`

["Caizhi Weng (Jira)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/FLINK-15066?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17014210#comment-17014210 ] 

Caizhi Weng commented on FLINK-15066:
-------------------------------------

From the perspective of a new user, especially a user from the traditional database, insert overwrite is a really strange behavior. It would be nice if the appending mode is made as the default behavior.

> 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: Jingsong Lee
>            Priority: Major
>             Fix For: 1.11.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)