Analyze Cloudera Data Warehouse Private Cloud logs stored on Ozone

This topic describes how to use Hue or Data Analytics Studio (DAS) to analyze Cloudera Data Warehouse (CDW) Private Cloud logs that are stored on Ozone.

You can use Hue to analyze Impala logs or DAS to analyze Hive logs.

  1. Using Hue or DAS, create an external table that points to the log data on Ozone:
    CREATE EXTERNAL TABLE <table-name> LIKE sys.logs LOCATION 'o3fs://<bucket-name>.s3v.<ozone.service.id>/<warehouse-prefix>/warehouse/tablespace/external/hive/sys.db/logs';
  2. Run the MSCK REPAIR TABLE command on the table you created in Step 1:
    MSCK REPAIR TABLE <table-name>;
After completing the above steps, you can use SQL queries to analyze the log data.