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

["Wan Kun (Jira)" <ji...@apache.org>]

Wan Kun created SPARK-41355:
-------------------------------

             Summary: 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


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