[SPARK-34439] Recognize `spark_catalog` in new identifier while view/table renaming

• Type: Sub-task
• Status: Resolved
• Priority: Major
• Resolution: Won't Fix
• Affects Version/s: 3.2.0
• Component/s: SQL
• Assignee: Unassigned
• Reporter: Max Gekk
• Created: 15/Feb/21 09:13
• Updated: 18/Feb/21 18:19
• Resolved: 18/Feb/21 18:19

Description

Currently, v1 ALTER TABLE .. RENAME TO doesn't recognize spark_catalog in new view/table identifiers. The example below demonstrates the issue:

spark-sql> CREATE DATABASE db;
spark-sql> CREATE TABLE spark_catalog.db.tbl (c0 INT) USING parquet;
spark-sql> INSERT INTO spark_catalog.db.tbl SELECT 0;
spark-sql> SELECT * FROM spark_catalog.db.tbl;
0
spark-sql> ALTER TABLE spark_catalog.db.tbl RENAME TO spark_catalog.db.tbl2;
Error in query: spark_catalog.db.tbl2 is not a valid TableIdentifier as it has more than 2 name parts.

Issue Links

• links to: [Github] Pull Request #31566 (MaxGekk)
• links to: [Github] Pull Request #31566 (MaxGekk)