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: java.net.ConnectException : 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