Cloudera Docs

Configuring an Operational Database connection

Having a connection to COD, you can create tables from Hive and store data in HBase.

The tables you create from Hive and store in HBase have some metadata stored in the Hive metastore. The data ia stored in HBase.

You must meet the following requirements to configure a COD connection.

  • Have an AWS-based environment.
  • Have administrative access to the S3 object store associated with your Hive Virtual Warehouse.

Configuring a COD connection involves three top-level steps. First, you set up Ranger permissions to access Cloudera Operational Database (COD) from Hive. Next, you generate configuration files. Finally, you configure the Hive Virtual Warehouse to connect to COD.