Xiao Li created SPARK-14857:
-------------------------------

             Summary: Table/Database Name Validation in SessionCatalog
                 Key: SPARK-14857
                 URL: https://issues.apache.org/jira/browse/SPARK-14857
             Project: Spark
          Issue Type: Improvement
          Components: SQL
    Affects Versions: 2.0.0
            Reporter: Xiao Li


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.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to