[HIVE-27348] Database name is not encoded when used to create default database location

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Component/s: Hive, Metastore, Standalone Metastore
• Labels: pull-request-available
• Assignee: Unassigned
• Reporter: Oliver Schiller
• Created: 16/May/23 15:41
• Updated: 20/Aug/23 00:18

Description

The database directory is created using the following code in Warehouse.java:

private String dbDirFromDbName(Database db) throwsMetaException { 
  return db.getName().toLowerCase() +DATABASE_WAREHOUSE_SUFFIX; }

The database name is not encoded, as done when generating directories for table names. As a consequence, special characters in schema names yield problems, e.g., when a schema having name "my:schema" is created:

metastore.RetryingHMSHandler: MetaException(message:java.lang.IllegalArgumentException: java.net.URISyntaxException: Relative path in absolute URI: my:schema.db)
        at org.apache.hadoop.hive.metastore.ExceptionHandler.newMetaException(ExceptionHandler.java:152)
        at org.apache.hadoop.hive.metastore.ExceptionHandler.defaultMetaException(ExceptionHandler.java:168)
        at org.apache.hadoop.hive.metastore.HMSHandler.create_database(HMSHandler.java:1397)

Issue Links

• links to: GitHub Pull Request #4329