Understanding the Hive Metastore category
Learn about the Cloudera Observability OnPremises Hive Metastore category that lists the details about each table available in your system and visually displays the current state and activity of your tables in the selected environment.
For users with a Hive Metastore deployment, Cloudera Observability OnPremises captures the Hive Metastore (HMS) metadata about your tables and displays it into meaningful cards and views. These can be found in the HMS Summary and HMS Tables views, which display the current state and activity of all your tables and list details about each table available in your system, regardless of whether they have been queried or not.
About the HMS Summary view
The Hive Metastore (HMS) Summary view visually displays information about the current state and activity of all your tables in the selected Environment.
 Overview
 Table Insights
 Table Statistics
Overview
The Overview section displays general information about your tables and the number of databases in which they reside.
Card  Description 

DATABASES  The number of databases in which your tables reside. 
TABLES  The number of tables and the percentage of tables that are External and Managed. 
VIEWS  The number of views and the percentage of views that are Materialized and Virtual. 
PARTITIONS  The number of partitions. 
Tables Insights
Card  Description 

NUMBER OF PARTITIONS  The partition distribution across all tables. 
PARTITION KEY SIZE  The partition key size distribution across all tables. 
COLUMN SIZE  The column size distribution across all tables. 
NUMBER OF BUCKET COLUMNS SIZE  The bucket column size distribution across all tables. 
BUCKETED TABLES  The number of bucketed tables and the percentage across all tables. 
COMPRESSED TABLES  The number of compressed tables and the percentage across all tables. 
NON PARTITIONED TABLES  The number of non partitioned tables and the percentage across all tables. 
PARTITIONED TABLES  The number of partitioned tables and the percentage across all tables. 
TABLES WITH ARRAY COLUMNS  The number of tables with array columns and the percentage across all tables. 
TABLES WITH BINARY COLUMNS  The number of tables with binary columns and the percentage across all tables. 
TABLES WITH MAP COLUMNS  The number of tables with map columns and the percentage across all tables. 
TABLES WITH STRUCT COLUMNS  The number of tables with struct data type columns and the percentage across all tables. 
TEMPORARY TABLES  The number of temporary tables and the percentage across all tables. 
Table Statistics
Card  Description 

STATISTICS ENABLED  The number and percentage across all tables with statistics enabled. 
DATA VOLUME  The total size of tables with statistics enabled and the distribution across all tables. 
NUMBER OF FILES displayed by distribution  The total number of files with statistics enabled and the distribution across all tables. 
NUMBER OF ROWS  The total number of rows with statistics enabled and the distribution across all tables. 
TOTAL DATA VOLUME  The total size of your tables with statistics enabled and the size of each storage format. 
NUMBER OF FILES displayed by type  The total number of files that form the tables with statistics enabled and their storage formats displayed as a percentage as a whole. 
About the HMS Tables view
The HMS Extract, which is updated daily, is displayed in the Hive Metastore (HMS) Tables view. It lists the details about each table available in your system, regardless of whether they have been queried or not.
Column Name  Description 

Table  The name of the table. 
Database  The database in which the table resides. 
Partitions  The number of partitions. 
Volume  The total table size in bytes. 
Rows  The number of records in the table. 
Files  The number of files that make up the table. 
Frequency of Access  The number of times queries have accessed the table. 
Storage Format  The table’s storage format, such as but not limited to:

Table Type  The table’s type, such as but not limited to:
