Downloading Impala diagnostic bundles

Learn how to download diagnostic bundles to use for troubleshooting an Impala Virtual Warehouse in Cloudera Data Warehouse (CDW) Public Cloud.

To troubleshoot issues with your Impala Virtual Warehouses, download diagnostic bundles of log files for the sidecar containers that support Impala components and for the components themselves. These diagnostic bundles are ZIP files stored in your public cloud account.

Required role: DWAdmin

Before you can download log files, you must, of course, run workloads on your Impala Virtual Warehouse to generate the logs.

  1. Log in to the CDP web interface and navigate to the CDW service.
  2. In the CDW service, click Overview in the left navigation panel, and in the Impala Virtual Warehouse tile, click Options , and select Collect Diagnostic Bundle.


  3. Set options that select which logs to generate for the diagnostic bundle.
    • By Time Range: Select a specific time range of log files to generate from the drop-down list, or you can choose a custom interval in the next option.
    • By Custom Time Interval: Select the start and end time from the drop-down list to define the specific time interval for the log files in the diagnostic bundle.
    • Collect For: Remove any of the available categories of log files by clicking the adjacent X:
      • Workload contains the log files for the Impala components, such as statestored, impalad, catalogd, coordinator, auto-scaler, and Hue frontend and backend logs. See Impala Logs.
      • Profile contains log files for Impala Query Profiles. See Understanding Performance Using Query Profiles.
      • Minidump contains the breakpad minidump log files. See Using Breakpad Minidumps for Crash Reporting.
      • Sidecar contains the logs for the sidecar containers that support Impala components.
      • HMS contains sidecar container logs that support the metastore.
      • K8S RESOURCE INFO contains Kubernetes information.
  4. Click Collect to generate the bundle.
    After some time, depending on your cluster size and log sizes, but typically after 10 seconds, a message indicating completion appears indicating the diagnostic bundle is generated:
    Collection of Diagnostic Bundle for impala-mpvt initiated. Please go to
    details page for more information.
  5. In the CDW service, click Overview in the left navigation panel, and in the Impala Virtual Warehouse tile, click Options > Edit > Diagnostic Bundle.
  6. Click copy-to-clipboard to copy the path to the diagnostic bundle on S3/ABFS.
  7. Paste the path to the diagnostic bundle into a text document, and navigate to the diagnostic bundle in AWS or Azure to download the ZIP file.
    When you expand the diagnostic bundle ZIP file that you downloaded, directories appear for log files and a diagnostic-data-generator.log file, which contains troubleshooting information.