Hive stores metadata in a SQL Server database. After you upgrade HDP and its components, you need to update the Hive metastore database table structures to ensure they are compatible with the latest version of Hive.
To upgrade the Hive metastore, use the schematool with the following command:
PS C:\Windows\system32> hive.cmd --service schematool -dbType mssql -upgradeSche ma
