Databases Table Details

The Database Table Details page displays the table details such as table usage and column details for a particular table.

Summary Panel

The following table provides description of the details displayed in the Summary panel:

Column Name	Description
Type	Displays the type of data stored inside the database. The following are the types: Managed table External table
Name	Name of the table.
Created Time	Displays the date and time when the table was created.
Output Format	Displays the output format of the table.
Input Format	Displays the input format of the table.
Compressed	States if a table is compressed by displaying either True if compressed or False if not compressed.
#Buckets	The number of buckets used for data partitioning.
Location	Displays the name of the table. Click on the name to view location details of the table in the HDFS File Explorer page.
Database	The name of the Database to which the table belongs to.
# Columns	The number of columns in the table.
# Partitions	The number of partitions on the table.
# Delta Files	The number of delta files on the table.

Table Usage

The heat map chart displays the table's usage up to the last 180 days. The Hive Queries box displays the number of hive queries that correspond to the number of days. By default, the data is displayed for the last 7 days. To change the number of days, click on Last 7 days and select the number of days from the drop-down list.

Column Details

The following table provides description of the details displayed in the Column Details table:

Field Name	Description
Column Name	Name of the table column.
Type Name	Displays the type of the column.
Output Format	Displays the output format of the table.
Input Format	Displays the input format of the table.
Compressed	States if a table is compressed by displaying either True if compressed or False if not compressed.
Usage Count	Displays the number of times a column was used across all the queries.

Hive Locks

The Hive Locks section displays real-time information about the locks applied to Hive tables. It helps you monitor shared and exclusive locks, identify blocking queries, and troubleshoot performance or concurrency issues in your Hive environment.

You can view details such as the lock ID, lock type, user, state, and host name. Click Refresh to retrieve the latest lock information.

Info

To enable this feature, you must set the environment variable SHOW_HIVE_LOCKS = true in GraphQL.

Columns

Column	Description
Shared / Exclusive Toggle	Switch between viewing shared (read) locks and exclusive (write) locks.
Search Bar	Use keywords such as user, lock type, or transaction ID to filter and search locks.
Lock Ext ID	Unique identifier for each lock instance in Hive.
Partition	Displays the table partition associated with the lock (if applicable).
Lock State	Shows the current state of the lock, such as Acquired, Waiting, or Released.
Blocked By	Displays the transaction or user causing another lock to wait or block.
Lock Type	Indicates whether the lock is Shared or Exclusive.
Transaction ID	Identifies the transaction associated with the lock.
Acquired At	Displays the timestamp when the lock was acquired.

When to Use Hive Locks View

Use this view when:

You notice query delays, table contention, or blocked transactions in Hive.
You need to analyze lock behavior or identify which users or queries are holding locks.

Create Hive Table Lock Custom Alerts

Go to Alerts > Create Alert, select Hive under Category, choose Hive Metastore Table Locks in Expression, define alert conditions (such as lock hostname, acquired at, etc.), set groups, hosts, and thresholds, then complete and save the alert.

For example, in Define Alert Conditions: Define when the alert should trigger—e.g., evaluate sum/max of lock properties (Locks Acquired At, Database Name, Host Name, etc.) against operators (=, >, <, ≥, ≤) and a threshold value.

For detailed steps on creating alerts, see Creating Alerts.

Last updated on

Was this page helpful?