Support Questions

Find answers, ask questions, and share your expertise
Check out our newest addition to the community, the Cloudera Data Analytics (CDA) group hub.

Identify unused tables in Hive

New Contributor

I need to identify which tables are unused in Hive. Is there someway how can I find this tables? 


@crisbcw : I can think of one option which I have used around 15months ago: If you are using Ranger, from ranger audit logs we can get the tables which are used for last n days and compare with tables with existing tables. 

Take a Tour of the Community
Don't have an account?
Your experience may be limited. Sign in to explore more.