Hi Guys, Is there a way to check hive external tables which are created N days before and drop those tables along with underlying hdfs data. Can this be achieved in unix script?
We can run
Desc formatted <db_name>.<tab_name>;
then extract CreateTime value in your shell script, to get when was the table is created and then make a decision to drop the table (or) not.
If you have external table then follow this way to drop the table with hdfs data.