If you have a second could you post the version of derby that you installed, the contents of hive-site.xml and the command you use to run (along with spark version?). I'd like to retry the installation.
On Thu, Jan 7, 2016 at 7:35 AM, Deenar Toraskar <deenar.toras...@gmail.com> wrote: > I sorted this out. There were 2 different version of derby and ensuring > the metastore and spark used the same version of Derby made the problem go > away. > > Deenar > > On 6 January 2016 at 02:55, Yana Kadiyska <yana.kadiy...@gmail.com> wrote: > >> Deenar, I have not resolved this issue. Why do you think it's from >> different versions of Derby? I was playing with this as a fun experiment >> and my setup was on a clean machine -- no other versions of >> hive/hadoop/etc... >> >> On Sun, Dec 20, 2015 at 12:17 AM, Deenar Toraskar < >> deenar.toras...@gmail.com> wrote: >> >>> apparently it is down to different versions of derby in the classpath, >>> but i am unsure where the other version is coming from. The setup worked >>> perfectly with spark 1.3.1. >>> >>> Deenar >>> >>> On 20 December 2015 at 04:41, Deenar Toraskar <deenar.toras...@gmail.com >>> > wrote: >>> >>>> Hi Yana/All >>>> >>>> I am getting the same exception. Did you make any progress? >>>> >>>> Deenar >>>> >>>> On 5 November 2015 at 17:32, Yana Kadiyska <yana.kadiy...@gmail.com> >>>> wrote: >>>> >>>>> Hi folks, trying experiment with a minimal external metastore. >>>>> >>>>> I am following the instructions here: >>>>> https://cwiki.apache.org/confluence/display/Hive/HiveDerbyServerMode >>>>> >>>>> I grabbed Derby 10.12.1.1 and started an instance, verified I can >>>>> connect via ij tool and that process is listening on 1527 >>>>> >>>>> put the following hive-site.xml under conf >>>>> ``` >>>>> <?xml version="1.0"?> >>>>> <?xml-stylesheet type="text/xsl" href="configuration.xsl"?> >>>>> <configuration> >>>>> <property> >>>>> <name>javax.jdo.option.ConnectionURL</name> >>>>> <value>jdbc:derby://localhost:1527/metastore_db;create=true</value> >>>>> <description>JDBC connect string for a JDBC metastore</description> >>>>> </property> >>>>> <property> >>>>> <name>javax.jdo.option.ConnectionDriverName</name> >>>>> <value>org.apache.derby.jdbc.ClientDriver</value> >>>>> <description>Driver class name for a JDBC metastore</description> >>>>> </property> >>>>> </configuration> >>>>> ``` >>>>> >>>>> I then try to run spark-shell thusly: >>>>> bin/spark-shell --driver-class-path >>>>> /home/yana/db-derby-10.12.1.1-bin/lib/derbyclient.jar >>>>> >>>>> and I get an ugly stack trace like so... >>>>> >>>>> Caused by: java.lang.NoClassDefFoundError: Could not initialize class >>>>> org.apache.derby.jdbc.EmbeddedDriver >>>>> at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native >>>>> Method) >>>>> at >>>>> sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57) >>>>> at >>>>> sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) >>>>> at java.lang.reflect.Constructor.newInstance(Constructor.java:526) >>>>> at java.lang.Class.newInstance(Class.java:379) >>>>> at >>>>> org.datanucleus.store.rdbms.connectionpool.AbstractConnectionPoolFactory.loadDriver(AbstractConnectionPoolFactory.java:47) >>>>> at >>>>> org.datanucleus.store.rdbms.connectionpool.DBCPConnectionPoolFactory.createConnectionPool(DBCPConnectionPoolFactory.java:50) >>>>> at >>>>> org.datanucleus.store.rdbms.ConnectionFactoryImpl.generateDataSources(ConnectionFactoryImpl.java:238) >>>>> at >>>>> org.datanucleus.store.rdbms.ConnectionFactoryImpl.initialiseDataSources(ConnectionFactoryImpl.java:131) >>>>> at >>>>> org.datanucleus.store.rdbms.ConnectionFactoryImpl.<init>(ConnectionFactoryImpl.java:85) >>>>> ... 114 more >>>>> >>>>> <console>:10: error: not found: value sqlContext >>>>> import sqlContext.implicits._ >>>>> >>>>> >>>>> What am I doing wrong -- not sure why it's looking for Embedded >>>>> anything, I'm specifically trying to not use the embedded server...but I >>>>> know my hive-site is being read as starting witout --driver-class-path >>>>> does >>>>> say it can't load org.apache.derby.jdbc.ClientDriver >>>>> >>>> >>>> >>> >> >