[SPARK-26613] Add another rename table grammar for spark sql

• Type: New Feature
• Status: Resolved
• Priority: Minor
• Resolution: Won't Fix
• Affects Version/s: 2.0.0, 2.1.0, 2.2.0, 2.3.0, 2.4.0
• Component/s: SQL
• Assignee: Unassigned
• Reporter: Jiaan Geng
• Created: 14/Jan/19 11:20
• Updated: 15/Jan/19 01:54
• Resolved: 14/Jan/19 17:16

Description

The current version of spark sql contains a rename grammar,like:

`alter table nameA rename to nameB` or `alter view nameA rename to nameB`.

Many database(e.g. mysql,oracle.) provide another grammar,like:

`rename table nameA to nameB`.

I thought maybe spark sql could consider the compatibility.

Issue Links

• links to: GitHub Pull Request #23535