You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@spark.apache.org by "Wenchen Fan (JIRA)" <ji...@apache.org> on 2017/03/02 06:50:46 UTC

[jira] [Resolved] (SPARK-19583) CTAS for data source tables with an created location does not work

     [ https://issues.apache.org/jira/browse/SPARK-19583?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Wenchen Fan resolved SPARK-19583.
---------------------------------
       Resolution: Fixed
    Fix Version/s: 2.2.0

Issue resolved by pull request 16938
[https://github.com/apache/spark/pull/16938]

> CTAS for data source tables with an created location does not work
> ------------------------------------------------------------------
>
>                 Key: SPARK-19583
>                 URL: https://issues.apache.org/jira/browse/SPARK-19583
>             Project: Spark
>          Issue Type: Bug
>          Components: SQL
>    Affects Versions: 2.2.0
>            Reporter: Xiao Li
>             Fix For: 2.2.0
>
>
> {noformat}
>         spark.sql(
>           s"""
>              |CREATE TABLE t
>              |USING parquet
>              |PARTITIONED BY(a, b)
>              |LOCATION '$dir'
>              |AS SELECT 3 as a, 4 as b, 1 as c, 2 as d
>            """.stripMargin)
> {noformat}
> Failed with the error message:
> {noformat}
> path file:/private/var/folders/6r/15tqm8hn3ldb3rmbfqm1gf4c0000gn/T/spark-195cd513-428a-4df9-b196-87db0c73e772 already exists.;
> org.apache.spark.sql.AnalysisException: path file:/private/var/folders/6r/15tqm8hn3ldb3rmbfqm1gf4c0000gn/T/spark-195cd513-428a-4df9-b196-87db0c73e772 already exists.;
> 	at org.apache.spark.sql.execution.datasources.InsertIntoHadoopFsRelationCommand.run(InsertIntoHadoopFsRelationCommand.scala:102)
> {noformat}



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@spark.apache.org
For additional commands, e-mail: issues-help@spark.apache.org