[HIVE-23033] MSSQL metastore schema init script doesn't initialize NOTIFICATION_SEQUENCE

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 3.1.0, 3.0.0, 3.1.1, 3.1.2
• Fix Version/s: 3.2.0, 4.0.0-alpha-1
• Assignee: David Lavati
• Reporter: David Lavati
• Created: 16/Mar/20 17:01
• Updated: 17/Nov/22 08:49
• Resolved: 20/Mar/20 18:40

Description

• The inital value for this table in the schema scripts was removed in HIVE-17566: https://github.com/apache/hive/commit/32b7abac961ca3879d23b074357f211fc7c49131#diff-3d1a4bae0d5d53c8e4ea79951ebf5eceL598
• This was fixed in a number of scripts in HIVE-18781, but not for mssql: https://github.com/apache/hive/commit/59483bca262880d3e7ef1b873d3c21176e9294cb#diff-4f43efd5a45cc362cb138287d90dbf82
• This is as is since then

When using the schematool, the table gets initialized by other means.

This could be backported to all active branches for 3.x as well.