WARN [main] metastore.MetaStoreDirectSql: Self-test query [select "DB_ID" from "DBS"] failed; direct SQL is disabled

Posted on by Leave a comment
While starting the “hive” on “hadoop” using the “Derby Database” I got the below errors.

hive -hiveconf hive.root.logger=DEBUG,console

……………………
……………………

……………………

2017-03-06T14:18:26,222  WARN [main] metastore.MetaStoreDirectSql: Self-test query [select “DB_ID” from “DBS”] failed; direct SQL is disabled
javax.jdo.JDODataStoreException: Error executing SQL query “select “DB_ID” from “DBS””.

……………………
……………………
……………………
NestedThrowablesStackTrace:
java.sql.SQLSyntaxErrorException: Table/View ‘DBS’ does not exist.
……………………
……………………
……………………
Caused by: java.sql.SQLException: Table/View ‘DBS’ does not exist.
        at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
        at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source)
        … 69 more
Caused by: ERROR 42X05: Table/View ‘DBS’ does not exist.
……………………
……………………
……………………
This is a bug in apache-hive-2.1.1. Install the stable version “apache-hive-1.2.1”.

Leave a Reply

Fill in your details below or click an icon to log in:

Gravatar
WordPress.com Logo

You are commenting using your WordPress.com account. ( Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. ( Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. ( Log Out /  Change )

Cancel

Connecting to %s