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

Learn 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 on 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.

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 > Edit.
3. In the Database Catalogs detail page, click CONFIGURATIONS > Metastore, and select hive-site from the Configuration files drop-down list.
4. Search for the following configuration properties and update them to Ozone file system paths, which start with ofs:
  - hive.metastore.warehouse.dir
  - hive.metastore.warehouse.external.dir
  note
  For the Hive Table creation, the warehouse directory must be set at bucket level or directory level under the hive.metastore.warehouse.dir or hive.metastore.warehouse.external.dir parameters. For more information, see Changing the Hive warehouse location.
  
  Following is an example of these properties set for a Database Catalog:
  
  note
  The example values in the screenshot show the Hive warehouse locations in Ozone (set at a directory level) where Hive stores the tables. hivevolume represents the Ozone volume, hivebucket represents the Ozone bucket, and managed and external are directories where Hive stores the managed and external tables.
5. Click Apply Changes and wait for the Database Catalog to finish applying changes.
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 upper right corner of the Virtual Warehouse tile on the Overview page.
- Create a new Hive or Impala Virtual Warehouse associated with the updated Database Catalog.
Use Hue to create a database with your 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.