[SPARK-32382] Override table renaming in JDBC dialects

• Type: Sub-task
• Status: Resolved
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 3.1.0
• Fix Version/s: 3.1.0
• Component/s: SQL
• Assignee: Max Gekk
• Reporter: Max Gekk
• Created: 21/Jul/20 20:29
• Updated: 28/Jul/20 12:34
• Resolved: 28/Jul/20 12:34

Description

SPARK-32375 adds new method renameTable to JdbcDialect with the default implementation:

ALTER TABLE table_name RENAME TO new_table_name;

which is supported by Oracle, MySQL, MariaDB, PostgreSQL and SQLite but other dialects might not support such syntax, for instance SQL Server (using the stored procedure called sp_rename):

sp_rename 'table_name', 'new_table_name';

The ticket aims to support table renaming in all JDBC dialects.

Issue Links

• is blocked by: SPARK-32375 Implement TableCatalog for JDBC
• links to: [Github] Pull Request #29237 (MaxGekk)
• links to: [Github] Pull Request #29237 (MaxGekk)