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 find missing tables in a database?

How to find missing tables in a database?

New Contributor

Let's say I have 1200 tables and 20 tables went missing. How to find which tables are those?

,

2 REPLIES 2
Highlighted

Re: How to find missing tables in a database?

Explorer

If you are taking backup of the metastore, you can compare between the current and the backup metastore (TBLS table) and get the requried information.

Highlighted

Re: How to find missing tables in a database?

@Karthik Shivanna

I dont think there is a default option to find out the missing tables. Only way to do is to compare the previous version of metastore with the current version. Also backup of the previous metastore has to be archived before the deletion of the tables only then you will be able to compare and find out the missing tables. The other way but doesnt work most of the times. Sometimes if the tables are deleted and if the Hcatalog/hive metastore is not updated then you will be able to find out easily. Hope it helps!

Don't have an account?
Coming from Hortonworks? Activate your account here