Setting up Cloudera Data Warehouse to connect to Cloudera Operational Database

You configure your Virtual Warehouse to use configuration files you generated for connecting to Cloudera Operational Database.

You generated configuration files hbase-site.xml and hbase-cdw.tar.gz as described in the previous topic.

In the Cloudera Data Warehouse UI, in Overview, go to the Virtual Warehouses tab, select a Hive Virtual Warehouse, and click > Edit.
The Virtual Warehouse Details page is displayed.
Go to Configurations > Hiveserver2.
In Configuration files, select hbase-site.xml, and copy the contents of the hbase-site.xml generated by the script you ran.

Create a directory or use an existing directory on S3.

hadoop fs -mkdir s3a://odx-weekly-test/cod--tddl6gutqgn9/jars

Copy the hbase-cdw.tar.gz, which you also obtained from the script you ran, to that directory.
In the Hive Virtual Warehouse > Details > Configurations > Hiveserver2, in Configuration files, select env and select the CDW_HIVE_AUX_JARS_PATH key.
Set the value of the CDW_HIVE_AUX_JARS_PATH key to the path of the jar file.
Go to the Query coordinator tab and select env from the Configuration files drop-down menu, and select the CDW_HIVE_AUX_JARS_PATH key.
Set the value of the CDW_HIVE_AUX_JARS_PATH key to the path to the jar file.
Click Save Changes and restart the Virtual Warehouse.

We want your opinion