[SPARK-30885] V1 table name should be fully qualified if catalog name is provided

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 3.0.0, 3.1.0
• Fix Version/s: 3.0.0
• Component/s: SQL
• Assignee: Terry Kim
• Reporter: Terry Kim
• Created: 20/Feb/20 06:43
• Updated: 04/Mar/20 10:10
• Resolved: 25/Feb/20 05:39

Description

For the following example,

sql("CREATE TABLE t USING json AS SELECT 1 AS i")
sql("SELECT * FROM spark_catalog.t")

`spark_catalog.t` is expanded to `spark_catalog.default.t` assuming that the current namespace is `default`. However, this is not consistent with V2 behavior where namespace should be provided if the catalog name is also provided.

Issue Links

• links to: GitHub Pull Request #27642
• links to: GitHub Pull Request #27718