8. Updating Hive Metastore Database Table Structures

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.

If you are upgrading from HDP 2.2, run the following scripts, in order, on your SQL Server database. You can find the scripts located in the Hive installation directory: C:\hdp\hive-1.2.1.2.3.0.0-2543\scripts\metastore\upgrade\mssql.

  1. upgrade-0.14.0-to-1.1.0.mssql.sql

  2. upgrade-1.1.0-to-1.2.0.mssql.sql

If you are upgrading from HDP 2.1, run the following scripts, in order, on your SQL Server database:

  1. upgrade-0.13.0-to-0.14.0.mssql.sql

  2. upgrade-0.14.0-to-1.1.0.mssql.sql

  3. upgrade-1.1.0-to-1.2.0.mssql.sql

[Note]Note

If you use a new database name and define new users, you must add this new information into the cluster properties file that you use to upgrade.