Upgrading Database Catalogs and Virtual Warehouses in Cloudera Data Warehouse Public Cloud

This topic describes how to upgrade Database Catalogs and Virtual Warehouses in Cloudera Data Warehouse (CDW) Public Cloud.

Before you begin

Obtain the DWAdmin role.

Take a look at the release notes for the following information:

Database Catalogs and Virtual Warehouse must be compatible, but the CDW upgrade framework understands the interoperability constraints between them. The CDW UI displays visual alerts in the Database Catalog and Virtual Warehouse tiles which indicate when there are upgrades available:

You can also check for upgrades by selecting Upgrade from the options menu on the tile:

"Latest releases" compared to "compatible releases"

A release is considered compatible with the current release if its dependents or dependencies do not need to be upgraded. For Database Catalogs, this means that it does not need to be upgraded to function effectively with its associated Virtual Warehouses. For Virtual Warehouses, this means that it does not need to be upgraded to function effectively with its associated Database Catalog.

However, some releases contain changes that require upgrading associated components. For example, a Hive Virtual Warehouse might use new APIs introduced in a new release of the Hive metastore/Database Catalog. In this case, you must upgrade the Database Catalog that is associated with this Hive Virtual Warehouse. On the other hand, if you upgrade a Database Catalog, you are not required to upgrade its associated Virtual Warehouse. These releases are called Latest releases in the CDW UI.

These "rules" are embedded in the CDW upgrade framework. Your upgrade choices are Latest version or Compatible version. Depending on the available new releases and the current version of your Database Catalogs and Virtual Warehouses, one or both choices are displayed. If the release is current, no upgrade choices are presented.

Available upgrade choices

When you select the Upgrade option in the tile or from the drop-down options menu in the tile, you might see one of the following options:

  • Already up-to-date, which means there are no new releases that you can upgrade to:

  • Do you want to upgrade Database Catalog to compatible version X.X.X.X-XX?:

    A similar dialog box displays for Virtual Warehouses when a compatible version is available for upgrade.

  • Sometimes if upgrading to a latest version causes dependent components to be upgraded as well, you might get a more complicated message in the Upgrade dialog box. For example:

    A similar dialog box displays for Virtual Warehouses if CDW detects that a decision about choosing a compatible or latest version is required.

Clicking on one of the "Upgrade..." buttons starts the upgrade process. The CDW UI displays the status of the upgrade: Upgrading, Starting, or Started.