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
.
upgrade-0.14.0-to-1.1.0.mssql.sql
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:
upgrade-0.13.0-to-0.14.0.mssql.sql
upgrade-0.14.0-to-1.1.0.mssql.sql
upgrade-1.1.0-to-1.2.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. |