Tez Table Details
The Table Details page displays the details of the table you selected in Tez -> Tables.
The default time range is Last 24 hrs. To view statistics from a custom date range, click the icon and select a time frame and timezone of your choice.
Summary Panel
The following table provides details of the summary panel in the Tez Table Details page:
| Data | Description |
|---|---|
| # of Partitions | The number of partitions in the table. |
| # of Files | The number of files in the table. |
| # of Rows | The number of rows in the table. |
| # of Cols | The number of columns in the table. |
| Total Size | The total size of the table (in bytes). |
| Compression | States if a table is compressed by displaying either True if compressed or False if not compressed. |
Queries Executed in Table
The following table provides details of the metric about the table you selected.
| Column Name | Description |
|---|---|
| Group Name | A unique identifier for the query. All runs of this query are bundled under this Group Name. To copy group name, move the cursor on the group name you want to copy and then click |
| Query Count | The total number of times this table was used by executing queries. |
| Failed Queries | The number of queries that failed. |
| Running Queries | The number of queries currently running on the table. |
| Duration | The total time taken to execute the query. |
| Mapper Scan Duration | The minimum, average, and maximum values of vertex runtime for query UID. |
| Users | Users executing the queries. You can click this column to view the list of users. |
Click any group name to view the following information:
The Query panel displays the query that was executed. You can perform the following operations in the Query panel.
- To copy the query to clipboard, click the
icon in the top right corner of the Query panel. - To beautify the query, click the
icon in the top right corner of the Query panel.
- To copy the query to clipboard, click the
The query is displayed along with the names of the tables that the query executed on. The Join Type and Output Rows are also displayed for each table.
Information about the Table Name, Filter Expression, Total Rows, Output Rows is displayed.
Click on the Table Name, to view details of the table in the Database Table Details page.
Features
Searching a Table
To search data in the table, Perform the following:
- Click the Search box and type
name:followed by the table name you want to search. For example, if you want to search for a table named store_sales, typename:store_salesin the search box and press the enter key. - (Optional) Click Reset to clear the applied filter.
Applying Filter
You can apply filter to the name of the group. To apply filter to the name of the group, perform the following:
- Click Group Name, drop-down list is displayed with the list of the group names.
- Select the name of the group. You can select one or more than one. The group details for the selected table is displayed.
- (Optional) To search the group name from the list, type the name in the search box.
- (Optional) Click Reset to remove the applied filter.