Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Stop hive for backup

Highlighted

Stop hive for backup

Expert Contributor

Do I have to stop hive service before making the backup

if so, Why I have to stop it ?

if not, does that make a trouble for hive?

2 REPLIES 2
Highlighted

Re: Stop hive for backup

Super Mentor

@yassine sihi

In case of any service which is keep on writing into the database on various tables, it is better to stop those services first before taking the Database dump. Else it might be possible that due to continuous update (DML queries) the DB dump might get into some inconsistent state Or there might be some very useful queries getting executed inside your DB while you were collecting the DB dump which might not get captured completely inside the Dump.

So better to stop the services before taking the DB dump as a best practice. However if you can take risk then it is also possible to take the DB dump in running mode of the services.

Highlighted

Re: Stop hive for backup

Expert Contributor

@Jay Kumar SenSharma

Thanks for explanation

Don't have an account?
Coming from Hortonworks? Activate your account here