8. Prepare the Metastore Databases

Hive uses a relational database to store metadata. Normally Hive metadata is stored in SQL Server.

To upgrade an existing MS SQL database for Hive, enter the following command in the Microsoft SQL Server process that contains the Hive database instance:

%HIVE_HOME%\scripts\metastore\upgrade\mssql\hive-txn-schema-0.13.0.mssql.sql

	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 to HDP 2.2.