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)
