Better oozie coordinator and Hive metastore integration

One common use case:

1) Kick off daily sqoop job that retrieves (e.g.) 1 week of data
2) Drop Hive partitions for the previous 1 week

ALTER TABLE foo DROP PARTITION (day = 'yyyy-mm-dd') ;

3) Run Hive job for dynamic partition of the data

This is currently not supported by Oozie coordinator jobs.

There are other variations of this use case, but they all involve performing Hive operations across multiple concrete date/time based partitions.