Support Questions

Find answers, ask questions, and share your expertise
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Advanced Search
Announcements
Check out our newest addition to the community, the Cloudera Data Analytics (CDA) group hub.

Identify unused tables in Hive

Labels:
crisbcw
New Contributor

Created on ‎12-18-2019 12:00 PM - last edited on ‎12-18-2019 12:51 PM by Community Manager Community Manager

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

731 Views
0 Kudos
1
1 REPLY 1

bandarusridhar1
Guru

Created ‎12-18-2019 01:16 PM

@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. 

681 Views
Take a Tour of the Community
Don't have an account?
Register
Your experience may be limited. Sign in to explore more.
Announcements
Product Announcements
CDP Public Cloud: May 2023 Release Summary
What's New @ Cloudera
Cloudera Operational Database (COD) provides enhancements to the --scale-type CDP CLI option
What's New @ Cloudera
Cloudera Operational Database (COD) UI supports creating a smaller cluster using a predefined Data Lake template
What's New @ Cloudera
Cloudera Operational Database (COD) supports scaling up the clusters vertically
Product Announcements
CDP Public Cloud: April 2023 Release Summary
View More Announcements