[jira] [Assigned] (SPARK-41355) Workaround hive table name validation issue

["Apache Spark (Jira)" <ji...@apache.org>]

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

Apache Spark reassigned SPARK-41355:
------------------------------------

    Assignee: Apache Spark

> Workaround hive table name validation issue
> -------------------------------------------
>
>                 Key: SPARK-41355
>                 URL: https://issues.apache.org/jira/browse/SPARK-41355
>             Project: Spark
>          Issue Type: Improvement
>          Components: SQL
>    Affects Versions: 3.4.0
>            Reporter: Wan Kun
>            Assignee: Apache Spark
>            Priority: Minor
>
> For example:
>  * We want to create a table called {{tAb_I}}
>  * Hive metastore will check if the table name is valid by {{MetaStoreUtils.validateName(tbl.getTableName())}}
>  * Hive will call {{HiveStringUtils.normalizeIdentifier(tbl.getTableName())}} and then save the save the table name to lower case, *but after setting the local to "tr", it will be {{tab_ı}} which is not a valid table name*
>  * When we run alter table command, we will first get the hive table from hive metastore which is not a valid table name.
>  * Update some properties or other, and then try to save it to hive metastore.
>  * Hive metastore will check if the table name is valid and then throw exception {{org.apache.hadoop.hive.ql.metadata.HiveException: [tab_ı]: is not a valid table name}}



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

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