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.
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.