Support Questions

Find answers, ask questions, and share your expertise

Spark failed to get database default

avatar

Hi, 

 I just did a fresh clean install of CDH 5.11 and with Hive and Spark, everythin in dev mode - so embedded database, no HA, simple setup.

 

When I try to run spark-shell a got an exception:

 

Spark context available as sc (master = yarn-client, app id = application_1498152485620_0001).
17/06/22 19:30:59 WARN metastore.ObjectStore: Version information not found in metastore. hive.metastore.schema.verification is not enabled so recording the schema version 1.1.0
17/06/22 19:30:59 WARN metastore.ObjectStore: Failed to get database default, returning NoSuchObjectException
SQL context available as sqlContext.

 

 

Is this some bug related to Spark 1.6?

 

Thanks

Tomas

 

1 ACCEPTED SOLUTION

avatar
Champion

@mbigelowi agree with you on this.

 

Could you check your Metastore / HS2  status

 

sudo service hive-metastore status
sudo service hive-server2 status

 

View solution in original post

6 REPLIES 6

avatar
The interesting thing is, that if I download spark 2.1 and configure it (point to hadoop conf dir in etc), it just works ok in YARN a does not have a problem to show databases or show tables.

avatar
Champion

The database it is trying to access is the backend to the Hive Metastore.  Are you able to access and view databases and tables in Hive?

avatar

I am sorry, but probably my mistake. I dont know why but now the sqlContext.sql("show tables").collect gathers the tables so I am able to access the metastore. The warning message is still there during spark-shell startup. But it works. 

 

 

avatar
Champion

@mbigelowi agree with you on this.

 

Could you check your Metastore / HS2  status

 

sudo service hive-metastore status
sudo service hive-server2 status

 

avatar
New Contributor

Still not clear on what the solution is for this error.  We are getting the same error.  Please help !!

avatar
Champion

Could you let me know what is the issue you are facing ? whats the error ?