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
Hi@akhtar, You can use the alter table command ...READ MORE
Yes, you can find out which database ...READ MORE
Hey, This step shows the configuration properties you ...READ MORE
OR
At least 1 upper-case and 1 lower-case letter
Minimum 8 characters and Maximum 50 characters
Already have an account? Sign in.