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> http://br.linkedin.com/in/fabriciojorge Contatos: + 55 91 988991116 skype: fabricio.pedroso.jorge <mailto:fpjb...@gmail.com> fpjb...@gmail.com
