You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@spark.apache.org by "Hyukjin Kwon (JIRA)" <ji...@apache.org> on 2019/05/21 04:25:23 UTC

[jira] [Updated] (SPARK-14857) Table/Database Name Validation in SessionCatalog

     [ https://issues.apache.org/jira/browse/SPARK-14857?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Hyukjin Kwon updated SPARK-14857:
---------------------------------
    Labels: bulk-closed  (was: )

> 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
>            Assignee: Xiao Li
>            Priority: Major
>              Labels: bulk-closed
>
> 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
(v7.6.3#76005)

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@spark.apache.org
For additional commands, e-mail: issues-help@spark.apache.org