Hi, I'm trying to send data from oracle to hive hourly and I want to save the last timestamp registered in Hive and based on that, define the timestamp start point in Oracle in the next charge.

For example, I send from oracle to hive data between 16:00:00 ans 16:59:00. After that I want to save the 16:59:00 as  a variable to put in the next charge in oracle query.

How can I do it?

Thanks

Nuno Martins