Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

How to update Catalog's metadata after creating tables in Hive?

How to update Catalog's metadata after creating tables in Hive?

New Contributor

Hello,

 

It seems taht Catalog-service enabled Imalad instances to synchronize their metadata. However, I find that If I create a table in Hive, Impala is not able to see it right away , I'm wondering if there is any approach to force Catalog-service to synchronize metadata(stored in MySQL) with Hive ? (better through JDBC) Thanks!

 

I'm using Impala 1.2+, refresh

2 REPLIES 2

Re: How to update Catalog's metadata after creating tables in Hive?

New Contributor

Seems INVALIDATE METADATA and REFRESH commands could do the trick, I'll try them first, Thanks!

Highlighted

Re: How to update Catalog's metadata after creating tables in Hive?

Contributor

Impala caches hive metastore metadata and will not automatically pick up tables created in Hive. We're looking into ways to

make that better but for now the solution is what you've already found. Here's a link to some more docs on how those commands

work:

 

http://www.cloudera.com/content/cloudera-content/cloudera-docs/Impala/latest/Installing-and-Using-Im...