Displaying the Metadata of a Table

Steps for displaying a table's metadata that could be causing a query to run slowly.

Describes how to display the metadata of table used in your query, such as the table's file size distribution that could be causing your query statement to run slowly.

In a supported browser, log in to Workload XM.
In the Search field of the Clusters page, enter the name of the cluster whose workloads you want to analyze.
From the navigation panel under Data Warehouse, select Summary.
In the Queries page, select the query of interest and then select the HDFS Tables Scanned tab.
For example, the Duration column shows that the query took over six hours to run and the HDFS Tables Scanned section displays the metadata for the tables that were scanned.
note
This is not the number of files accessed, but the total number of files that were in the table the last time a HDFS snapshot was taken before the query was run.
To display the file size distribution details for a table, click the Table name .

Displaying the Metadata of a Table

We want your opinion

How can we improve this page?