[HIVE-22546] Postgres schema not using quoted identifiers for certain tables

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 4.0.0
• Fix Version/s: 4.0.0-alpha-1
• Component/s: Database/Schema
• Assignee: Zoltan Chovan
• Reporter: Zoltan Chovan
• Created: 26/Nov/19 13:59
• Updated: 17/Nov/22 08:51
• Resolved: 09/Dec/19 09:51

Description

In the latest postgresql schema (standalone-metastore/metastore-server/src/main/sql/postgres/hive-schema-4.0.0.postgres.sql) the following tables have lowercase table and column names:

aux_table 
compaction_queue 
completed_compactions 
completed_txn_components 
hive_locks 
materialization_rebuild_locks 
min_history_level 
next_compaction_queue_id 
next_lock_id 
next_txn_id 
next_write_id 
repl_txn_map 
runtime_stats 
txn_components 
txn_to_write_id 
txns 
write_set

As these tables are referenced from the Hive sys database, the queries to these tables will fail with a "Table not found" error.

The problem is that the table and column names are not enclosed in quotes, so postgres will turn these identifiers into lowercase.