How to find the database daily refresh time sync up time

+1 vote
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.
Sep 17, 2019 in Big Data Hadoop by Hemanth
• 250 points
8,732 views
Hi @Hemanth. Which database are you using?
Hi Ritu, It is hadoop and hive as web interface

2 answers to this question.

+1 vote

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.

answered Sep 17, 2019 by Ritu

It is giving the error like this for refresh command

Hey @Hemanth. Please try with the keyword table.

refresh table sr_denorm_incidents
+1 vote

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'
answered Sep 17, 2019 by Raman

Related Questions In Big Data Hadoop

0 votes
1 answer

How to find the used cache in HDFS

hdfs dfsadmin -report This command tells fs ...READ MORE

answered May 4, 2018 in Big Data Hadoop by Shubham
• 13,490 points
2,037 views
0 votes
1 answer

How to create a project for the first time in Hadoop.?

If you want to learn Hadoop framework ...READ MORE

answered Jul 27, 2018 in Big Data Hadoop by Neha
• 6,300 points
938 views
0 votes
1 answer

How to find the running namenodes and secondary name nodes in hadoop?

Name nodes: hdfs getconf -namenodes Secondary name nodes: hdfs getconf ...READ MORE

answered Nov 26, 2018 in Big Data Hadoop by Omkar
• 69,210 points
2,347 views
0 votes
1 answer

How to find the number of blocks a hdfs file is divided into?

Yes. you can use the hadoop fsck command to do ...READ MORE

answered Nov 30, 2018 in Big Data Hadoop by Omkar
• 69,210 points
5,455 views
0 votes
1 answer

What is Metastore in Hive?

It stores metadata for Hive tables (like their schema ...READ MORE

answered Dec 20, 2018 in Big Data Hadoop by Frankie
• 9,830 points
2,862 views
0 votes
1 answer

What is metastore in Hive architecture?

Hey, Hive chooses respective database servers to store ...READ MORE

answered May 10, 2019 in Big Data Hadoop by Gitika
• 65,910 points
1,052 views
0 votes
1 answer

Why for metastore RDBMS is used?

Hey, Yes, it is correct that Hive is ...READ MORE

answered May 11, 2019 in Big Data Hadoop by Gitika
• 65,910 points
1,517 views
0 votes
1 answer

How to add a column in Hive table?

Hi@akhtar, You can use the alter table command ...READ MORE

answered Oct 19, 2020 in Big Data Hadoop by MD
• 95,440 points
1,542 views
0 votes
1 answer

How to find the default database in Hive?

Yes, you can find out which database ...READ MORE

answered May 20, 2019 in Big Data Hadoop by Shiro
4,021 views
0 votes
1 answer

How to configure the metastore service to communicate with the MySQL database in Hive?

Hey, This step shows the configuration properties you ...READ MORE

answered May 29, 2019 in Big Data Hadoop by Gitika
• 65,910 points
510 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP