Refreshing Metadata in Impala

If you are already operating in both “Hive” and “Impala-shell” and the tables created in Hive do not appear in Impala, the solution below will help you.

It is mandatory to refresh the metadata in Impala-shell to view the newly created tables using “Invalidate Metadata.” Often, even though you refresh the metadata, if the tables don’t show, here’s the answer.



We created a table in Hive. When attempting to fetch the same from Impala, it is throwing an error, ‘Could not resolve table reference’: ‘sampletable’

In such cases, refresh the metadata by specifying the table name as shown below:

Invalidate metadata sampletable;



Hope you find this article helpful.