[HIVE-15072] Schematool should recognize missing tables in metastore

• Type: Sub-task
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 2.3.0
• Component/s: Metastore
• Assignee: Naveen Gangam
• Reporter: Yongzhi Chen
• Created: 26/Oct/16 18:43
• Updated: 21/Jul/17 18:26
• Resolved: 21/Nov/16 01:26

Description

When Install a new database failed half way(for some other reasons), not all of the metastore tables are installed. This caused HMS server failed to start up due to missing tables. Re-run the Schematool, It ran successfully, and in the stdout log said: "Database already has tables. Skipping table creation".
However, restarting HMS getting the same error reporting missing tables.
Schematool should detect missing tables and provide options to go ahead and recreate missing tables in the case of new installation

Issue Links

• links to: ReviewBoard