Support Questions

Find answers, ask questions, and share your expertise

Hive is not starting


Hi Team,

I am getting below error. i am not able to check the error.

please help.hive-error1.txt


Super Mentor

@hema moger

We see the error:

Caused by: MetaException(message:Unable to open a test connection to the given database. JDBC url = jdbc:derby://localhost:1527/metastore_db;create=true , username = APP. Terminating connection pool (set lazyInit to true if you expect to start your database after your app). 

java.sql.SQLNonTransientConnectionException: : Error connecting to server localhost on port 1,527 with message Connection refused (Connection refused).


Can you please check if you are running Derby server running on your local machine where the Hive metastore is running?

Looks like it is not started and thats why the communication on port 1527 of Derby is failing.

Please restart Derby and then verify if it is listening to the correct port ?

# netstat -tnlpa | grep 1527


Super Mentor

@hema moger

It may also be possible that before this error there was some additional error in your hive log which we do not see in your hive-error1.txt.

So can you please attach the log from the beginning (when it should have complete log as soon as the process was started)..