[HIVE-25608] Document special characters for table names

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Component/s: Documentation
• Assignee: Unassigned
• Reporter: Ruslan Dautkhanov
• Created: 12/Oct/21 03:42
• Updated: 12/Oct/21 03:48

Description

From Hive documentation - 

 

Hive documentation

 

Table names and column names are case insensitive.

• In Hive 0.12 and earlier, only alphanumeric and underscore characters are allowed in table and column names.

 

https://cwiki.apache.org/confluence/display/hive/languagemanual+select

metastore.support.special.characters.tablename=true 

makes possible to use special characters in table names.

https://github.com/apache/hive/blob/af2089370130e0fc5c1c70600b2b45f91d12813e/standalone-metastore/metastore-common/src/main/java/org/apache/hadoop/hive/metastore/conf/MetastoreConf.java#L1268

and https://github.com/apache/hive/blob/32c9a71ca3481688071fc1ba1db8685adcb2a6fd/standalone-metastore/metastore-common/src/main/java/org/apache/hadoop/hive/metastore/utils/MetaStoreUtils.java#L202

If special characters are officially supported in Hive, I will be happy to update the wiki or send a PR to fix this omission. Thanks!