Any idea to get the location, Itention of location is to copy the data from one cluser to another clusert. So i would need the hdfs location ... View more

@Rohit Sinha 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. ... View more