Skip to main content

Home

Tables

You can check the current information for each of the tables in the metastore, for a selected cluster, from the Tables tab. The following details are shown:

  • Users accessing the tables

  • Number of applications accessing the tables

  • Number of partitions in a table

  • Types of applications accessing the tables

  • Table metadata

  • Table size

  • Tables running in (hot, warm, cold, and unknown states)

  • Total number of tables in a cluster

  • Recommendations and insights for the table

Configuring Tables report

Refer to Data Page configurations and ensure that the configurations for Hive Metstore connection and FSImage are set. Data

Viewing table details
  1. Go to the Data > Tables tab.

  2. From the Cluster drop-down, select a cluster. The corresponding metastore IDs are automatically displayed in the Metastore drop-down.

  3. Select a metastore option. A list of tables is displayed with the following metadata. The total tables for the selected cluster and metastore are displayed on the left datapage-total-tables.png. You can click download-csv.png to export the list of tables in CSV format.

    Click column-setting.png in the table header, to add or the columns in the table.

    Metadata

    Description

    Database

    Name of the database where the table is stored.

    Table

    Name of the table.

    Owner

    Owner of the table.

    Path

    Location of the table. Hover over to view the complete path.

    Table Type

    Type of the table.

    File System

    File system that is used to store the table. Hover over to view the source of the table. For example, metastore or apps.

    Storage Format

    The format in which the table is stored. For example, text, ORC, PARQUET.

    Hover over to view the source of the table and the last updated time of this field.

    Created

    Date and time when the table was created. Hover over to view the source of the table and the last updated time of this field.

    Latest Access

    Date and time when the table was last accessed. Hover over to view the source of the table and the last updated time of this field

    Size

    Size of the table.

    Apps

    The type of app accessing the tables. Hover over to view various apps accessing the tables and the last updated time of this field.

    Partitions

    Number of partitions in a table.

    Users

    Number of users accessing the table.

    More Info

    Click View.png to access more information about the selected table.

  4. Select the checkbox corresponding to a table for which you want to view the details. The following graphs are updated based on the selection:

    • Users: This graph plots the number of users who access the tables on a given day.

      datapage-table-users.png
    • Apps: This graph plots the number of applications that access the tables on a given day.

      datapage-table-apps.png
    • Size: This graph plots the table size on a given day.

      datapage-table-size.png
Viewing more information
Searching and filtering tables

You can filter the tables using the heat map labels.

  1. Go to Data > Tables > Table state section.

  2. From the Table State in the left, select any of the following heat labels:

    datapage-heat-labels-list.png

    The tables matching the corresponding heat labels are listed in the table. Here, the Hot option was selected, the corresponding tables, that are color-coded with a red line on the left, are shown. Click the Reset button to discard the filters.

    tables-heat-label-select-red.png
  3. Optionally, you can define the heat labels for the table, click column-setting.png in the Table State section. The Label Tables dialog is displayed.

    datapage-label-tables.png
  4. Move the color-slider to set the period for the tables to be defined under a specific color-coded heat label.

In the Search box, you can enter the name of the table and click search.png, the corresponding tables are displayed.