Known Issues in Hive Virtual Warehouses on public clouds

Learn about the known issues related to Hive Virtual Warehouse in Cloudera Data Warehouse service on public clouds, the impact or changes to the functionality, and the workaround.

Result caching:
This feature is limited to 10 GB.
Data caching:
This feature is limited to 200 GB per compute node, multiplied by the total number of compute nodes.
DWX-5926: Cloning an existing Hive Virtual Warehouse fails
Problem: If you have an existing Hive Virtual Warehouse that you clone by selecting Clone from the drop-down menu, the cloning process fails. This does not apply to creating a new Hive Virtual Warehouse.
Workaround: Make the following configuration change to resolve this issue:
  1. In the Hive Virtual Warehouse tile, click the edit icon. This launches the Virtual Warehouse details page.
  2. In the details page for the Virtual Warehouse:
    1. Click the Configurations tab:
    2. Click the Hiveserver2 sub-tab.
    3. Select hive-site from the configuration file drop-down list menu.
    4. Search for the configuration property hive.metastore.sasl.enabled.
    5. Set the hive.metastore.sasl.enabled configuration property to true.
    6. Click Apply in the upper right corner of the page to save the configuration.
  3. Click the Actions menu and select Clone to clone the Hive Virtual Warehouse:
DWX-5277: Race condition might occur during auto-scaling that can result in query failures
Problem: This race condition occurs intermittently when queries are submitted rapidly from tools such as jmeter. To mitigate this issue, the default value for the hive.llap.split.location.provider.class has been set to com.github.cloudera.llap.K8sHostAffinitySplitLocationProvider in this release. This configuration change is known to cause up to 10% performance degradation for some Hive workloads.
Workaround: If performance degradation is observed, edit the Hive Virtual Warehouse hive-site setting for the Query coordinator and Hiveserver2, by setting hive.llap.split.location.provider.class=org.apache.hadoop.hive.ql.exec.tez.HostAffinitySplitLocationProvider.
DWX-2690: Older versions of Beeline return SSLPeerUnverifiedException when submitting a query

Problem: When submitting queries to Virtual Warehouses that use Hive, older Beeline clients return an SSLPeerUnverifiedException error: Host name ‘’ does not
match the certificate subject provided by the peer (CN=* (state=08S01,code=0)

Workaround: Only use Beeline clients from CDP Runtime version or later.