*Hi Hive Community,*

I have a question regarding handling databases across multiple catalogs in
HMS.

As per the HMS design, it accepts catalog names in all API calls, either by
appending the database name with the catalog name using # or by setting the
catalog name in the request object of _req methods as optional. Suppose an
HMS client starts passing the catalog name in all API calls. Since the HMS
schema ensures that the combination of database_name and catalog_name is
unique in the DBS table, users can create the same database name in
different catalogs (e.g., database1 in both catalog1 and catalog2).

Given this setup, here's the scenario I need clarification on:

If a user wants to retrieve all databases belonging to a specific catalog,
is there an HMS API available for this? Currently, get_all_databases()
returns a list of database names but doesn't differentiate which catalog
they belong to. This becomes problematic when the same database name exists
in different catalogs, as the HMS client won't be able to filter and
associate each database with its respective catalog.

Is there a recommended way or any API to get database details based on the
catalog name so that HMS clients can filter and use the correct databases
accordingly?

Thanks for your help!

Thanks & Regards
  Anurag Dwivedi
  Mob - 9331339700

Reply via email to