You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@hive.apache.org by Rahul Channe <dr...@googlemail.com> on 2014/08/07 03:13:32 UTC

error on show databases

Hi All,

I am getting following error

hive> show databases;
FAILED: Execution Error, return code 1 from
org.apache.hadoop.hive.ql.exec.DDLTask. java.lang.RuntimeException: Unable
to instantiate org.apache.hadoop.hive.metastore.HiveMetaStoreClient
hive>

Regards,
Rahul

Re: error on show databases

Posted by "Subramanian, Sanjay (HQP)" <sa...@roberthalf.com>.
Are u using mysql as the metastore ?

Thanks

Warm Regards

sanjay



From: Rahul Channe <dr...@googlemail.com>>
Reply-To: "user@hive.apache.org<ma...@hive.apache.org>" <us...@hive.apache.org>>
Date: Thursday, August 7, 2014 at 7:35 AM
To: "user@hive.apache.org<ma...@hive.apache.org>" <us...@hive.apache.org>>
Subject: Re: error on show databases

The below change in configuration parameter in hive-site.xml fixed the issue

 <name>hive.metastore.schema.verification</name>
  <value>false</value>
   <description>

It was TRUE earlier later i changed it to False.
Not sure if its an issue with Hive or expected behaviour

Even ,when i tried to start metastore following error popped up


MetaException(message:Version information not found in metastore. )
        at org.apache.hadoop.hive.metastore.ObjectStore.checkSchema(ObjectStore.java:5638)



On Wed, Aug 6, 2014 at 9:28 PM, Divakar Reddy <di...@gmail.com>> wrote:
It seems your hive metastore is down. restart it and try again.

Thanks,
Divakar


On Wed, Aug 6, 2014 at 9:13 PM, Rahul Channe <dr...@googlemail.com>> wrote:
Hi All,

I am getting following error

hive> show databases;
FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. java.lang.RuntimeException: Unable to instantiate org.apache.hadoop.hive.metastore.HiveMetaStoreClient
hive>

Regards,
Rahul

Re: error on show databases

Posted by Rahul Channe <dr...@googlemail.com>.
The below change in configuration parameter in hive-site.xml fixed the
issue

 <name>hive.metastore.schema.verification</name>
  <value>false</value>
   <description>

It was TRUE earlier later i changed it to False.
Not sure if its an issue with Hive or expected behaviour

Even ,when i tried to start metastore following error popped up

MetaException(message:Version information not found in metastore. )
        at org.apache.hadoop.hive.metastore.ObjectStore.checkSchema(ObjectStore.java:5638)




On Wed, Aug 6, 2014 at 9:28 PM, Divakar Reddy <di...@gmail.com>
wrote:

> It seems your hive metastore is down. restart it and try again.
>
> Thanks,
> Divakar
>
>
> On Wed, Aug 6, 2014 at 9:13 PM, Rahul Channe <dr...@googlemail.com>
> wrote:
>
>> Hi All,
>>
>> I am getting following error
>>
>> hive> show databases;
>> FAILED: Execution Error, return code 1 from
>> org.apache.hadoop.hive.ql.exec.DDLTask. java.lang.RuntimeException: Unable
>> to instantiate org.apache.hadoop.hive.metastore.HiveMetaStoreClient
>> hive>
>>
>> Regards,
>> Rahul
>>
>
>

Re: error on show databases

Posted by Divakar Reddy <di...@gmail.com>.
It seems your hive metastore is down. restart it and try again.

Thanks,
Divakar


On Wed, Aug 6, 2014 at 9:13 PM, Rahul Channe <dr...@googlemail.com> wrote:

> Hi All,
>
> I am getting following error
>
> hive> show databases;
> FAILED: Execution Error, return code 1 from
> org.apache.hadoop.hive.ql.exec.DDLTask. java.lang.RuntimeException: Unable
> to instantiate org.apache.hadoop.hive.metastore.HiveMetaStoreClient
> hive>
>
> Regards,
> Rahul
>

Re: error on show databases

Posted by Andrew Mains <an...@kontagent.com>.
Can you check the hive logs (which should be located in 
/tmp/<user.name>/hive.log )? See 
https://cwiki.apache.org/confluence/display/Hive/GettingStarted#GettingStarted-ErrorLogs

There ought to be a more specific error there.

Andrew

On 8/6/14, 6:13 PM, Rahul Channe wrote:
> Hi All,
>
> I am getting following error
>
> hive> show databases;
> FAILED: Execution Error, return code 1 from 
> org.apache.hadoop.hive.ql.exec.DDLTask. java.lang.RuntimeException: 
> Unable to instantiate org.apache.hadoop.hive.metastore.HiveMetaStoreClient
> hive>
>
> Regards,
> Rahul