[HIVE-19310] Metastore: MetaStoreDirectSql.ensureDbInit has some slow DN calls which might need to be run only in test env

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 3.0.0
• Fix Version/s: 3.0.0
• Component/s: Metastore
• Assignee: Sergey Shelukhin
• Reporter: Vaibhav Gumashta
• Created: 25/Apr/18 20:03
• Updated: 22/May/18 23:16
• Resolved: 07/May/18 20:42

Description

MetaStoreDirectSql.ensureDbInit has the following 2 calls which we have observed taking a long time in our testing:

initQueries.add(pm.newQuery(MNotificationLog.class, "dbName == ''"));
initQueries.add(pm.newQuery(MNotificationNextId.class, "nextEventId < -1"));

In a production environment, these tables should be initialized using schematool, however in a test environment, these calls might be needed.

Issue Links

• is related to: HIVE-19605 TAB_COL_STATS table has no index on db/table name