title: How to write a shell script that will alter tables drop partitions in hive for more than 10 days for multiple tables(by importing a hql file)
body: <p>I wanna write a shell script that will drop partitions for multiple tables in hive that have partitions greater than 10 days, can someone please help me out</p>
  <p>I am able to hardcode it for only one table, but I do not want to hardcode anything as I am need to deploy it with oozie, So I want to make everything dynamic</p>