I can not initiate derby schema

Asked Dec 28 '22 at 00:56

Active Dec 28 '22 at 19:04

Viewed 20 times

when i run $HIVE_HOME/bin/schematool -initSchema -dbType derby

the output is

Metastore connection URL:    jdbc:derby://localhost:1527/metastore_db;create=true
Metastore Connection Driver :    org.apache.derby.jdbc.EmbeddedDriver
Metastore connection User:   APP
org.apache.hadoop.hive.metastore.HiveMetaException: Failed to get schema version.
Underlying cause: java.sql.SQLException : No suitable driver found for jdbc:derby://localhost:1527/metastore_db;create=true
SQL Error code: 0
Use --verbose for detailed stacktrace.
*** schemaTool failed ***

edited Dec 28 '22 at 19:04

OneCricketeer

179,855
19
132
245

asked Dec 28 '22 at 00:56

Ahmed Zedan

1

Summary of reasons for this exception from a different context: https://stackoverflow.com/a/1911487/13447 – Olaf Kock Dec 28 '22 at 01:54
Are you certain that your Derby Network Server is up and running on port 1527? – Bryan Pendleton Dec 28 '22 at 15:37
@BryanPendleton Hive should start an embedded Derby on its own. Error says driver isn't found – OneCricketeer Dec 28 '22 at 19:05

I can not initiate derby schema

0 Answers0