Impala Tables
Click Impala --> Tables to view the list of tables. By default, the list of tables is sorted in order of highest number of queries that utilized this table in the given timeframe. You can search for a table by name.
| Column Name | Description |
|---|---|
| Name | The name of the table. |
| Query Count | The number of queries running on the table. |
| Row Count | The number of rows in the table. |
| # of Join Columns | The number of join columns in the table. |
Impala Table Details
Click a table to view its details in the Impala Table Details page.
The following information is displayed for the table:
| Metric | Description |
|---|---|
| # of Partition | The number of partitions in the table. |
| # of Files | The number of files. |
| # of Rows | The number of rows in the table. |
| # of Columns | The number of columns in the table. |
| Total Size | The total size of the table. |
| Compression | Whether the table is compressed or not. |
The list of tables is sorted in order of highest number of Row Count.
| Column Name | Description |
|---|---|
| Group Name | A unique identifier for the query. All runs of this query are bundled under this Group Name. |
| Query Count | The total number of times this table was used by 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 run the query. |
| Users | The total number of users that ran queries on this table. |
Click a query to view its SQL details.
Click the
Click the
Filtering
To filter the Group Name, perform the following:
- Click the Group Name The drop-down list is displayed
- Select the checkbox from the list.
- (Optional) You can search for the name using the search box in the drop-down list.
- (Optional) Select the checkbox All from the drop-down to reset the applied filter.
- (Optional) To remove the applied filter(s), click Reset.
Search Option
#### Perform the following steps to search for a record in the search bar.
- Select a search parameter. Pulse provides you multiple search parameters.
- Select a suitable operator for your parameter.
- Enter the search term and hit the enter key.
For String Data type fields, you can use the =~ operator. This operator allows you to search strings by entering partial string. You can also use regular expressions to search a required value.