Creating a database on Ozone for Cloudera Data Warehouse Private Cloud Virtual Warehouses

This topic describes how to create a database on Ozone storage that can be used by Cloudera Data Warehouse (CDW) Private Cloud Hive or Impala Virtual Warehouses.

By default, the Hive metastore for Database Catalogs CDW Private Cloud points to HDFS, but you can configure the Database Catalog to point to Ozone storage instead by using the following steps. These steps change the default Hive metastore location to Ozone.

Before you re-configure the Database Catalog settings, make sure there are no running Virtual Warehouses associated with it. Either the Database Catalog has no associated Virtual Warehouses or you have suspended all the Virtual Warehouses associated with it.

  1. Use the following steps to change the Database Catalog setting:
    1. From the Management Console Private Cloud home page left menu, navigate to Data Warehouse > Overview.
    2. In the Database Catalog tile, click the edit icon .
    3. In the Database Catalogs detail page, click the Metastore tab, and select hive-site from the drop-down list on the left side of the tabbed page.
    4. Search for the following configuration properties and update them to Ozone file system paths, which start with o3fs:
      • hive.metastore.warehouse.dir
      • hive.metastore.warehouse.external.dir

      Here is an example of these properties set for the test-env-datalake-default Database Catalog:



    5. Click Apply in the upper right corner of the page to save your settings. The Database Catalog begins updating.
  2. After the Database Catalog has finished updating, perform one of the following actions to get started working with a Virtual Warehouse:
    • Restart any associated Virtual Warehouses that you suspended before updating the Database Catalog properties by clicking the re-start icon in the Virtual Warehouse tile on the Overview page:


    • Create a new Hive or Impala Virtual Warehouse associated with the updated Database Catalog.
  3. Use Data Analytics Studio (DAS) to create a database with your Hive Virtual Warehouse or use Hue to create a database with your Impala Virtual Warehouse. For details, see Querying data.
After configuring the Database Catalog's Hive metastore to point to Ozone, you can create databases on Ozone with either an Impala or a Hive Virtual Warehouse.