[jira] [Created] (HIVE-22546) Postgres schema not using quoted identifiers for certain tables

["Zoltan Chovan (Jira)" <ji...@apache.org>]

Zoltan Chovan created HIVE-22546:
------------------------------------

             Summary: Postgres schema not using quoted identifiers for certain tables
                 Key: HIVE-22546
                 URL: https://issues.apache.org/jira/browse/HIVE-22546
             Project: Hive
          Issue Type: Bug
            Reporter: Zoltan Chovan
            Assignee: Zoltan Chovan


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:
{code:java}
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{code}
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.

 



--
This message was sent by Atlassian Jira
(v8.3.4#803005)