Error schemaTool failed

Question

Hi,

I am learning hive and after installation, at the time of installing derby database it gave me this error. Can anyone help me, how to come out of this and solution to this?

Answer 1

Hey,

The error you got because you might have installed derby database and tried run that statement again. So you do one thing, inside your hive directory you will get a directory that is metastore_db. Remove it with the help of  this command:

rm -rf metastore_db/

And again try to reinstall derby database with the command:

schematool -initSchema -dbType derby

I hope it will help and the error will go.

Comments

thank you its works

---

Hi, @There,

Thank you for your contribution. Glad that the solution helped you do upvote the answer once you find it valuable and do register with the Edureka community.