Are u using mysql as the metastore ? Thanks
Warm Regards sanjay From: Rahul Channe <drah...@googlemail.com<mailto:drah...@googlemail.com>> Reply-To: "user@hive.apache.org<mailto:user@hive.apache.org>" <user@hive.apache.org<mailto:user@hive.apache.org>> Date: Thursday, August 7, 2014 at 7:35 AM To: "user@hive.apache.org<mailto:user@hive.apache.org>" <user@hive.apache.org<mailto:user@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 <divakarredd...@gmail.com<mailto:divakarredd...@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 <drah...@googlemail.com<mailto:drah...@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