Hive File Analytics

The following tabs provides details of the bar charts displayed on the Hive File Analytics page:

File Analytics

Chart NameDescription
Least Recently Modified Partitioned TablesDisplays the size of the partitioned tables that were last modified.
Least Recently Modified Unpartitioned TablesDisplays the size of the unpartitioned tables that were last modified.
Top Tables by Num Files (Unpartitioned)Displays the top unpartitioned tables with highest number of files.
Top Tables by Size (Partitioned)Displays the top tables with partition and largest size.
Top Tables by Size (Unpartitioned)Displays the top tables that are unpartitioned and of the largest size.
Top Tables by Small Files (Partitioned)Displays the top tables with partition and smallest size.
Top Tables by Small Files (Unpartitioned)Displays the top tables that are unpartitioned and of the smallest size.
Top Tables by Num Files (Partitioned)Displays the top partitioned tables with highest number of files.

Table Instights

ChartDescription
Table Temperature

The file system is displayed as a bar chart classed as Hot, Warm, or Cold based on the most recent revisions.

- Cold: The number of files that have not been modified in at least 6 months.

Warm: The number of files modified in the last three to six months.

Hot: The number of files modified in the last three months. Note: The duration of defining the Hot, Warm, and Cold can be modified.

Hive Files by DatabasesThe Hive Files by Databases provides database-level visibility into file distribution across Hive.
Hive Table File Count DistributionThe Hive Table File Count Distribution visualization shows how file counts are distributed across Hive tables.
Type to search, ESC to discard
Type to search, ESC to discard
Type to search, ESC to discard