The Table Details page displays the details of the table you selected in Spark Thrift -> Tables. As a summary, the following data of a table is displayed under Queries executed on.
Note: 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.
|# 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 on (table name)
The following metrics gives you brief information about the table you selected.
|Row Count during query execution||The number of rows while executing a table query.|
|# of Times Query Executed||The number of times the query executed.|
|Join Types||The associated types of joins in the query.|
|# of Join Columns||The number of columns in the resultant table join.|
|# of Filter Columns||The number of columns filtered by Spark.|
|Join Output Row Range||The first and last row value of a resultant join query.|
|Query Times Range||The time range within which the query executed.|
|Unique Users||The number of unique users of the queries executed in the table.|
Note: Click any row in Queries executed on to view the following.
- The query is displayed along with the names of the tables that the query ran on. The Join Type and Output Rows are also displayed for each table.
- Information about the Filter Column, Filter Expression, Table Output rows is also displayed.