Does Cloudera navigator has an option to identify Unused objects for a particular period (like more than 6 months, 1 year, etc)?
The object can be HDFS files, Hive/Impala tables/Oozie, dataset, etc
This is my requirement: Our non-prod environment has been used by multiple users for different reasons like dev, test, etc. Sometimes they use common user id & user space to create db, create/import tables, etc. After the task finished, they will move to the next task without cleaning the old DB, tables, files which become garbage after few days.
It has been accumulated and become a big garbage now (with 3 replication). I want to identify the DB, tables, files which are not in use for more than 6 months (or) 1 year and delete them (with proper approval...)
Is it possible with Navigator? is there any other option/ideas?