You might want to check the HiveServer2 log which should have the complete exception trace to understand why it is not able to create a MetastoreClient.
On Sun, Nov 26, 2017 at 3:48 PM, Marco <mgar...@cetax.com.br> wrote: > Hi Fabricio, did you solve this ? > > Looks that your Hive is not accessing the MetaStore database... > > Did you try to connect on Derby directly ? or this Machine and port are > accessible ? > > > > Regards > > Marco Garcia > > ( www.cetax.com.br ) > > > > *De:* Fabricio Pedroso Jorge [mailto:fpjb...@gmail.com] > *Enviada em:* segunda-feira, 20 de novembro de 2017 22:37 > *Para:* user@hive.apache.org > *Assunto:* Error "Unable to instantiate org.apache.hadoop.hive.ql. > metadata.SessionHiveMetaStoreClient" > > > > Hi all, > > > Hadoop verrsion...: 2.6.0 (Oracle Linux 7) > > Hive version.........: 2.3.2 > > > > I am quite a newbie at the Hive world, and because of that, i am getting > the following error averytime i try to execute a command at the hive CLI: > > > > > *hive> show tables;FAILED: SemanticException > org.apache.hadoop.hive.ql.metadata.HiveException: > java.lang.RuntimeException: Unable to instantiate > org.apache.hadoop.hive.ql.metadata.SessionHiveMetaStoreClient* > > > > My metastore is at $DERBY_HOME/data and my hive-site.xml has the following > configuration, regarding the Derby connection: > > > > > > > > > > * <name>javax.jdo.option.ConnectionURL</name> > <value>jdbc:derby://h-master:1527/metastore_db;create=true</value> > <description> JDBC connect string for a JDBC metastore. To use > SSL to encrypt/authenticate the connection, provide database-specific SSL > flag in the connection URL. For example, > jdbc:postgresql://myhost/db?ssl=true for postgres database. > </description>* > > *[...]* > > > > > > * <property> <name>javax.jdo.option.ConnectionDriverName</name> > <value>org.apache.derby.jdbc.ClientDriver</value> <description>Driver > class name for a JDBC metastore</description> </property>* > > > > I am using the Derby Database at the Network Server mode. > > > Any help will be appreciated. Thanks. > > > -- > > *FabrÃcio Pedroso Jorge.* > > Administrador de Banco de Dados > > > > *Resumo Profissional:* > http://br.linkedin.com/in/fabriciojorge > > > > *Contatos:* > + 55 91 988991116 <+55%2091%2098899-1116> > skype: fabricio.pedroso.jorge > fpjb...@gmail.com >
