Locating Cloudera Data Warehouse on premises logs

Learn how you can access logs for Cloudera Data Warehouse on premises.

When you generate logs using the Collect Diagnostic Bundles option from the environment, they are written to a partition on the Hive sys.logs table and are stored in the following location on HDFS:

/warehouse/[***ENVIRONMENT-NAMEabcde***]/[***DATABASE-CATALOG***]/warehouse/tablespace/external/hive/sys.db/logs

abcde is a random 5-character string that is appended to the environment name.

These partitions are retained for 7 days by default.

Log in to the OpenShift or Experiences Compute Service (ECS) cluster and determine the location of the sys.logs table by running the following query:
```
DESCRIBE FORMATTED sys.logs;
```
This SQL statement returns information about the location of the table which contains the logs.
Use the location obtained in Step 1 to locate the Cloudera Data Warehouse on premises logs on the OpenShift or ECS clusters.

Locating Cloudera Data Warehouse on premises logs

We want your opinion

How can we improve this page?