[HIVE-12351] add mssql tables for authorization in pre-upgrade script

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 0.14.0
• Component/s: Metastore
• Assignee: Thejas Nair
• Reporter: Thejas Nair
• Created: 05/Nov/15 20:54
• Updated: 05/Nov/15 21:01

Description

With schematool becoming increasingly the tool of choice for upgrades, datanucleus.autoCreateSchema is often turned off for newer versions of hive.

However, this can be a problem if old schema was created using DataNucleus autocreate-schema, it might not have created the tables related to authorization if authorization functionality was not being used.

Issue Links

• is related to: HIVE-9919 upgrade scripts don't work on some auto-created DBs due to absence of tables