Note
To optimize the speed of querying Big Catalog from the VAST Web UI, create a dedicated VIP pool for Big Catalog by creating a VIP pool and setting it's role to Big Catalog. For example:
vcli: admin> vippool create --ip-ranges 192.0.2.0,192.0.2.1 --subnet-cidr 24 --name BC-CLIPool --role BIG_CATALOG
-
From the left navigation menu, select Database and then Global Catalog.
-
Click Open Query Panel.
-
In the Active Query tab, define a query condition based on a Big Catalog table column, as follows:
-
From the Column name dropdown, select the column based on which you want to search.
-
From the Operator dropdown, select from the available operators, which are suited to the data type stored in the selected column. Then provide any relevant further criteria.
For example, for the column group_owner_name, you can select either is exactly to search for a given group, and then enter a group name into a provided field, or is null and then select True or False to search for all entries that have a group owner name or for entries that do not have group owner name.
-
If you want to widen the query by adding OR criteria for the same column (to return results with either the above condition or another condition based on the same column), click OR, select another operator for the column and complete any relevant further criteria. Repeat as needed for additional OR criteria.
-
When you are done defining the condition, click Add .
The condition is added to a list of conditions.
-
If you want to limit the query by defining AND conditions so that the query will return only results that match the condition already listed AND further conditions, repeat the above steps to add further conditions to the list.
-
-
Click Execute Query to run it.
The results are displayed in the grid.
You can now:
-
See all columns searched in the query above the results grid, each with a removal button. You can remove each one using delete button provided.
-
Change which columns are displayed in the results grid by clicking
and then adjusting the selection.
-
Comments
0 comments
Article is closed for comments.