[ https://issues.apache.org/jira/browse/SPARK-28551?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17337731#comment-17337731 ]
Apache Spark commented on SPARK-28551: -------------------------------------- User 'vinodkc' has created a pull request for this issue: https://github.com/apache/spark/pull/32411 > CTAS SQL with LOCATION properties won't check location path, cause data under > this location lose > ------------------------------------------------------------------------------------------------ > > Key: SPARK-28551 > URL: https://issues.apache.org/jira/browse/SPARK-28551 > Project: Spark > Issue Type: Bug > Components: SQL > Affects Versions: 2.4.0 > Reporter: angerszhu > Priority: Major > > When we run SQL like > {code:java} > CRETE TABLE TBL > LOCATION 'PATH_URI' > AS > SELECT QUERY{code} > It won't check PATH_URI status, if there is some data under this path, it > will just overwrite this path. > If user careless write a path with important data store under the path, it > will be a disaster。 > Thought about add a checker in Catalyst for this situation. > In addition, if it fails to delete the old path completely, old data and new > data coexists. -- This message was sent by Atlassian Jira (v8.3.4#803005) --------------------------------------------------------------------- To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org