Hive CLI Error: Unable to instantiate org.apache.hadoop.hive.ql.metadata.SessionHiveMetaStoreClient
Hi All, I'm new to Hive and did this tutorial: https://cwiki.apache.org/confluence/display/Hive/GettingStarted After the "Running Hive CLI" step I've decided to run the "show tables;" command and got this error: FAILED: HiveException java.lang.RuntimeException: Unable to instantiate org.apache.hadoop.hive.ql.metadata.SessionHiveMetaStoreClient Do you have any idea how to solve this? I've tried implementing solutions listed in the top 10 search results for this error to no avail. Should I try the next 10 results? Thanks, Val
Re: Error "Unable to instantiate org.apache.hadoop.hive.ql.metadata.SessionHiveMetaStoreClient"
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 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: > > > > > > > > > > *javax.jdo.option.ConnectionURL > jdbc:derby://h-master:1527/metastore_db;create=true > 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. > * > > *[...]* > > > > > > * javax.jdo.option.ConnectionDriverName > org.apache.derby.jdbc.ClientDriverDriver > class name for a JDBC metastore * > > > > 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 >
RES: Error "Unable to instantiate org.apache.hadoop.hive.ql.metadata.SessionHiveMetaStoreClient"
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: javax.jdo.option.ConnectionURL jdbc:derby://h-master:1527/metastore_db;create=true 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. [...] javax.jdo.option.ConnectionDriverName org.apache.derby.jdbc.ClientDriver Driver class name for a JDBC metastore 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
Re: Error "Unable to instantiate org.apache.hadoop.hive.ql.metadata.SessionHiveMetaStoreClient"
Hi, I recommend you try using HiveServer2 and beeline as explained here: https://cwiki.apache.org/confluence/display/Hive/GettingStarted#GettingStarted-RunningHiveServer2andBeeline.1 In particular, please make sure you have run "bin/schematool -dbType derby -initSchema" and that it returned successfully, as this command is required to initialize your derby backend. Hope this helps, Furcy 2017-11-21 1:37 GMT+01:00 Fabricio Pedroso Jorge : > 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: > > > > > > > > *javax.jdo.option.ConnectionURL > jdbc:derby://h-master:1527/metastore_db;create=true > 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. > * > *[...]* > > > > > * javax.jdo.option.ConnectionDriverName > org.apache.derby.jdbc.ClientDriverDriver > class name for a JDBC metastore * > > 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 >
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: *javax.jdo.option.ConnectionURL jdbc:derby://h-master:1527/metastore_db;create=true 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. * *[...]* * javax.jdo.option.ConnectionDriverName org.apache.derby.jdbc.ClientDriverDriver class name for a JDBC metastore * 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 skype: fabricio.pedroso.jorge fpjb...@gmail.com