For workspaces that were upgraded to Unity Catalog and have legacy tables, hive_metastore is often used as the default catalog for backward compatibility when a 2-tier namespace is referenced and no specific default catalog is configured. (Note: Some newly created workspaces may set main or a workspace-specific name as the default catalog, but hive_metastore represents the legacy default).