I need to periodically load files from local file system into hdfs and update hive table partitions. The query for updating the partitions depends on the timestamps(select * where date = "").
The first part I'm presuming can be done using ssh action and hdfs -put, but I dont understand how to update partitions based on date. I could use Oozie EL but I need today's and yesterday's date. Moreover I don't understand how to capture date and pass it as a parameter into hive script. How do I Do this, any ideas ?
