prestodb/presto

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

Open

#25738 opened on Aug 11, 2025

View on GitHub
 (1 comment) (1 reaction) (1 assignee)Java (15,558 stars) (5,240 forks)batch import
docsfeature requestgood first issue

Description

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.

Contributor guide

Tech stack
None
Domain
documentation
Issue type
documentation
DifficultyEstimated implementation difficulty for a new contributor, from 1 for very small changes to 5 for expert-level work.
2
Estimated timeA rough time range for an experienced contributor to investigate, implement, test, and prepare a pull request.
under 1 hour
Activity statusHow available the issue appears right now: fresh, active, stale, blocked, or waiting on maintainer input.
blocked
ClarityHow clearly the issue explains the expected change, acceptance criteria, and next step.
clear
Prerequisites
Basic knowledge of PrestoFamiliarity with Hive connector docs
Newbie friendlinessA 1-100 score estimating how approachable this issue is for first-time contributors.
70
Research direction
Review the linked PR comment in #24549 and the existing section in connector/hive.rst. Update the section to reflect that the cache invalidation enhancement has been added, and link to the procedures documentation at https://prestodb.github.io/docs/0.292/connector/hive.html#procedures. Follow the guidance from @imjalpreet's comment.