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 <fpjb...@gmail.com>: > 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 >
