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 in Big Data Hadoop by Hemanth
• 240 points
79 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 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 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,350 points
303 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 26, 2018 in Big Data Hadoop by Neha
• 6,280 points
110 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
• 68,480 points
107 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 29, 2018 in Big Data Hadoop by Omkar
• 68,480 points
734 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,810 points
223 views
0 votes
1 answer

What is metastore in Hive architecture?

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

answered May 10 in Big Data Hadoop by Gitika
• 25,420 points
83 views
0 votes
1 answer

Why for metastore RDBMS is used?

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

answered May 10 in Big Data Hadoop by Gitika
• 25,420 points
53 views
0 votes
1 answer

Hadoop Mapreduce word count Program

Firstly you need to understand the concept ...READ MORE

answered Mar 16, 2018 in Data Analytics by nitinrawat895
• 10,800 points
3,582 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 in Big Data Hadoop by Shiro
48 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 in Big Data Hadoop by Gitika
• 25,420 points
54 views