[HIVE-5449] Hive schematool info option incorrectly reports error for Postgres metastore

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 0.12.0, 0.13.0
• Fix Version/s: 0.13.0
• Component/s: Metastore
• Assignee: Prasad Suresh Mujumdar Assign to me
• Reporter: Prasad Suresh Mujumdar
• Created: 04/Oct/13 22:33
• Updated: 10/Oct/13 12:09
• Resolved: 05/Oct/13 16:24

Description

The schema tool has an option to verify the schema version stored in the metastore. This is implemented as a simple select query executed via JDBC. The problem is that Postgres requires object names to be quoted due to the way tables are created. It's a similar issues hit by metastore direct SQL (HIVE-5264, HIVE-5265 etc).

Issue Links

• is related to: HIVE-5301 Add a schema tool for offline metastore schema upgrade