Known issues in Hive Virtual Warehouses

This topic describes the Hive Virtual Warehouse known issues for Cloudera Data Warehouse (CDW) Private Cloud.

DWX-8524: Hive queries on sys.db tables may fail
When you run queries on the sys.db table from Data Analytics Studio, you may see the following error: “Cannot create PoolableConnectionFactory (Could not open SSL root certificate file /mnt/config/current/hms-root.crt.)” on a default Database Catalog using PostgreSQL database. This happens because PostgreSQL requires SSL. This issue does not occur on Database Catalogs using MariaDB.
DWX-8500: Toggling the auto-suspend option restarts all the pods on Hive Virtual Warehouses
Both Database Catalog and service pods restart when you enable or disable the auto-suspend button for Hive Virtual Warehouses, instead of restarting only the Database Catalog pods.
DWX-6234: WAIT TIME seconds cannot be set to "0" in the Hive Virtual Warehouse UI
The slider that can be used to set WAIT TIME in the Hive Virtual Warehouse UI displays a range from 0 to 1000, but if you set it to 0, the UI automatically changes it to 60.
DWX-4842: Entities are not being created in Atlas
Base clusters that are using Java 11 might be using truststores in PKCS12 format. Currently, Hive Virtual Warehouses on CDW Private Cloud only supports truststores in JKS format. This prevents the entities from being created in Atlas.
Using the keytool, convert the PKCS12 truststore in the base cluster to a JKS truststore.