[SPARK-37546] V2 ReplaceTableAsSelect command should qualify location

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 3.3.0
• Fix Version/s: 3.3.0
• Component/s: SQL
• Assignee: Huaxin Gao
• Reporter: Huaxin Gao
• Created: 04/Dec/21 23:10
• Updated: 06/Dec/21 10:31
• Resolved: 06/Dec/21 10:31

Description

V2 ReplaceTableAsSelect command should qualify location. Currently,

spark.sql("REPLACE TABLE testcat.t USING foo LOCATION '/tmp/foo' AS SELECT id FROM source")
spark.sql("DESCRIBE EXTENDED testcat.t").show(false)

displays the location as `/tmp/foo` whereas V1 command displays/stores it as qualified (`file:/tmp/foo`).

Issue Links

• links to: [Github] Pull Request #34807 (huaxingao)
• links to: [Github] Pull Request #34807 (huaxingao)