Thank you all for your concern.I found the problem.It was while setting up the mysql metastore.
On Friday, 27 June 2014 6:05 PM, Nagarjuna Vissarapu <nagarjuna.v...@gmail.com> wrote: can u please attach hive-site.xml file. On Thu, Jun 26, 2014 at 2:11 PM, Rishabh Bhardwaj <rbnex...@yahoo.com> wrote: HI all, >I have changed my hive metastore to mysql using the steps described here > >http://www.cloudera.com/content/cloudera-content/cloudera-docs/CDH4/4.2.0/CDH4-Installation-Guide/cdh4ig_topic_18_4.html > > >Now when I am running any hive command on cli like show databases or show >tables , It gives me the following error: > > >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 > > > > > >This is related to hive metastore only. >Can anyone please help me out with this. > > >Thanks, >Rishabh > -- With Thanks & Regards Nagarjuna Vissarapu 9052179339