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

0 votes
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
• 210 points
48 views
Hi @Hemanth. Which database are you using?
Hi Ritu, It is hadoop and hive as web interface

2 answers to this question.

0 votes

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

0 votes

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,300 points
245 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
80 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
• 67,600 points
87 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
• 67,600 points
533 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
140 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,340 points
47 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,340 points
38 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,690 points
3,033 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
31 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,340 points
39 views