57120/how-to-find-the-database-daily-refresh-time-sync-up-time
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.
It is giving the error like this for refresh command
Hey @Hemanth. Please try with the keyword table.
refresh table sr_denorm_incidents
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'
hdfs dfsadmin -report This command tells fs ...READ MORE
If you want to learn Hadoop framework ...READ MORE
Name nodes: hdfs getconf -namenodes Secondary name nodes: hdfs getconf ...READ MORE
Yes. you can use the hadoop fsck command to do ...READ MORE
It stores metadata for Hive tables (like their schema ...READ MORE
Hey, Hive chooses respective database servers to store ...READ MORE
Hey, Yes, it is correct that Hive is ...READ MORE
Firstly you need to understand the concept ...READ MORE
Yes, you can find out which database ...READ MORE
Hey, This step shows the configuration properties you ...READ MORE
OR
Already have an account? Sign in.