You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@spark.apache.org by "Terry Kim (Jira)" <ji...@apache.org> on 2021/12/04 07:05:00 UTC
[jira] [Updated] (SPARK-37545) V2 CreateTableAsSelect command should qualify location
[ https://issues.apache.org/jira/browse/SPARK-37545?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Terry Kim updated SPARK-37545:
------------------------------
Description:
V2 CreateTableAsSelect command should qualify location. Currently,
{code:java}
spark.sql("CREATE TABLE testcat.t USING foo LOCATION '/tmp/foo' AS SELECT id FROM source")
spark.sql("DESCRIBE EXTENDED testcat.t").show(false)
{code}
displays the location as `/tmp/foo` whereas V1 command displays/stores it as qualified (`[file:/tmp/foo|file:///tmp/foo]`).
was:
V2 CreateTableAsSelect command should qualify location. Currently,
{code:java}
spark.sql("CREATE TABLE testcat.t USING foo LOCATION '/tmp/foo' AS SELECT id FROM source")
spark.sql("DESCRIBE EXTENDED $identifier").show(false)
{code}
displays the location as `/tmp/foo` whereas V1 command displays/stores it as qualified (`file:/tmp/foo`).
> V2 CreateTableAsSelect command should qualify location
> ------------------------------------------------------
>
> Key: SPARK-37545
> URL: https://issues.apache.org/jira/browse/SPARK-37545
> Project: Spark
> Issue Type: Bug
> Components: SQL
> Affects Versions: 3.3.0
> Reporter: Terry Kim
> Priority: Major
>
> V2 CreateTableAsSelect command should qualify location. Currently,
>
> {code:java}
> spark.sql("CREATE TABLE testcat.t USING foo LOCATION '/tmp/foo' AS SELECT id FROM source")
> spark.sql("DESCRIBE EXTENDED testcat.t").show(false)
> {code}
> displays the location as `/tmp/foo` whereas V1 command displays/stores it as qualified (`[file:/tmp/foo|file:///tmp/foo]`).
>
--
This message was sent by Atlassian Jira
(v8.20.1#820001)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@spark.apache.org
For additional commands, e-mail: issues-help@spark.apache.org