[docs] Update "How to invalidate metastore cache?" in connector/hive.rst

Update "How to invalidate metastore cache?" in connector/hive.rst as described in @imjalpreet's comment in #24549.

Expected Behavior or Use Case

Updated documentation.

Presto Component, Service, or Connector

Hive metastore documentation.

Context

In #24549 , @imjalpreet commented:

"How to invalidate metastore cache?": This is one of the ways to invalidate the metastore cache and we should update the details in that section.

The last part of that section

Currently, this procedure flushes the cache for all the tables in all the schemas. This is a known limitation and will be enhanced in the future.

This enhancement was actually added a few months back. More advanced procedures to invalidate the cache are documented here: https://prestodb.github.io/docs/0.292/connector/hive.html#procedures - system.invalidate_metastore_cache() and its variants.

Opened this issue.