Databases
Table Usage by Query count
The tree map chart depicts various table usages by query count for the selected database. The number of queries is displayed in parenthesis next to the table name.
The database table provides the details of each table for a particular database.
Database Table
The following table provides description of the details displayed in the Databases page:
| Column Name | Description |
|---|---|
| Name | Name of the table. Click on the table name, to view the details of the table in the Databases Table Details page. |
| Location | The location of the table. You can click the folder icon to view the complete path. |
| Table Temp | The current temperature of the table. A red dot indicates hot table, a yellow dot indicates warm table and a blue dot indicates cold table. |
| Action | Click on the action to view the details of the table in the HDFS File Explorer page. |
| Type | Displays the type of data stored inside the database. The following are the types: Managed table and External table |
| Owner | Displays the name of the Integration |
| Created Time | Displays the date and time when the table was created. |
| Input Format | Displays the input format of the table. |
| Output Format | Displays the output 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 buckets used for data partitioning. |
| Table Size | The total size of all the Tables in the Database. |
| # of Files | The number of files in the Database. |
You can customize the columns by using the settings icon.
Global Filter
The Global Filter allows you to view tables by the created time period. For example, you can view the tables which were created in the past 24 hours. By default the Global Calendar displays all the tables created since the filter is set to All time. You can set any time period to view the tables created during the selected time period. The Global filter is applicable to the whole Database page.
Applying Filter to Table
Apart from the Global filter, you can also apply filters at table level. You can apply filter for the name of the table, to apply filter for the following options select the Other Filters radio button:
- Type
- Owner
- Input Format
- Output Format
- Compression
To apply the filter perform the following:
- Click on the name of the filter. 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.
Adding/Removing Columns
To add or remove a column to the Database table, perform the following:
- In the top right column of the table, click the table
settings icon. A Select Column window appears. - From the available list of columns, select the column name you want to add to the table or deselect a column name you want to remove from the table.
- Click Apply.
- (Optional) You can search for the name of the column using the search box.
Databases
You can view data, specific to a database. To view data on the dashboard for the particular database, perform the following:
- Click on the name of the queue. The data corresponding to the selected queue is displayed in the dashboard.
- (Optional) To search the name of the database, click the
icon. The search box appears, type the name you want to search in the search box. - (Optional) To delete search, click
.