Full support for Hive metastore catalog

### What's the feature are you trying to implement?

### Problem

Right now the HMS catalog implementation is lacking some of the core features and there are others that are nice to have. Specifically, `update_table` and `register_table` and hive muticatalog support.

#### Plan

- [ ] implement update_table with support for both locking and optimistic flows
- [ ] implement register_table
- [ ] implement explicit catalog support

### Willingness to contribute

I can contribute to this feature independently

Start by locating the existing Hive metastore catalog implementation and reading how its current table operations are structured. Compare the three planned capabilities—update_table with locking and optimistic flows, register_table, and explicit catalog support—with the current behavior. Done means all three plan items are implemented, including both update flows.

Written by the indexing model from the issue text.