How to find the database daily refresh time / sync up time

Question

Hello All,

i have one issue with ETA job. When the job finish the data we are receiving with 24 hrs delay. I need to find out the daily sync or refresh time. Can any one please do let me know the commands or how to check the last refresh time for particular DB.

Comments

Hi @Hemanth. Which database are you using?

---

Hi Ritu, It is hadoop and hive as web interface

Answer 1

You can refresh the table after the job is complete. After the job finishes, run the following command in Hive:

> refresh tablename;

This will refresh the data in the table, updating the new data.

Comments

It is giving the error like this for refresh command

---

Hey @Hemanth. Please try with the keyword table.

refresh table sr_denorm_incidents

Answer 2

I use this code to get the latest refresh time:

SELECT MAX(restore_date) as LAST_RESTORE_DT
FROM restorehistory
WHERE destination_database_name = 'yourdb'