Caused by: ERROR XSDB6: Another instance of Derby may have already booted the database /root/metasto

Caused by: ERROR XJ040: Failed to start database ‘metastore_db’ with class loader org.apache.spark.sql.hive.client.IsolatedClientLoader$$anon$1@771506b4, see the next exception for details.
at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
at org.apache.derby.impl.jdbc.SQLExceptionFactory.wrapArgsForTransportAcrossDRDA(Unknown Source)
… 195 more
Caused by: ERROR XSDB6: Another instance of Derby may have already booted the database /root/metastore_db.

在spark-shell中执行sparksql语句报错如下：

解决；

关闭所有SparkSubmit进程，重新进入Spark-shell即可