[SPARK-14857] Table/Database Name Validation in SessionCatalog

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Incomplete
• Affects Version/s: 2.0.0
• Component/s: SQL
• Labels: bulk-closed
• Assignee: Xiao Li
• Reporter: Xiao Li
• Created: 22/Apr/16 20:11
• Updated: 21/May/19 04:36
• Resolved: 21/May/19 04:36

Description

We need validate the database/table names before storing these information in `ExternalCatalog`.

For example, if users use `backstick` to quote the table/database names containing illegal characters, these names are allowed by Spark Parser, but Hive metastore does not allow them. We need to catch them in SessionCatalog and issue an appropriate error message.
```
CREATE TABLE `tab:1` ...
```

This PR enforces the name rules of Spark SQL for `table`/`database`/`view`: `only can contain alphanumeric and underscore characters.` Different from Hive, we allow the names with starting underscore characters.

The validation of function/column names will be done in a separate JIRA.

Issue Links

• blocks: SPARK-14603 SessionCatalog needs to check if a metadata operation is valid
• links to: [Github] Pull Request #12618 (gatorsmile)