I am using a Hive instance using MySQL as the meta-data store. The cluster
works fine in command line mode.
The problem I am having is that when I attempt to connect using the Hive
JDBC connector I get the following error:
java.sql.SQLException:
org.jpox.jdo.exceptions.TransactionNotReadableException: Cant read fields
outside of transactions. You may want to set 'NontransactionalRead=true'.
[java] FailedObject:1[OID]org.apache.hadoop.hive.metastore.model.MDatabase
[java] at org.apache.hadoop.hive.jdbc.HiveDriver.connect(HiveDriver.java:71)
[java] at java.sql.DriverManager.getConnection(DriverManager.java:582)
[java] at java.sql.DriverManager.getConnection(DriverManager.java:185)
[java] at com.adknowledge.HiveDriver.HiveDrvr.<init>(HiveDrvr.java:27)
[java] at com.adknowledge.HiveDriver.HiveDrvr.main(HiveDrvr.java:46)
[java] java.lang.NullPointerException
[java] at com.adknowledge.HiveDriver.HiveDrvr.go(HiveDrvr.java:36)
[java] at com.adknowledge.HiveDriver.HiveDrvr.main(HiveDrvr.java:47)
This is after the basic connection to the meta-store has worked.
.
.
.
. [java] 09/06/01 17:08:41 INFO Datastore.Schema: Validating 1 foreign
key(s) for table `PARTITION_KEY_VALS`
[java] 09/06/01 17:08:41 INFO Datastore.Schema: Validating 1 unique key(s)
for table `PARTITION_KEY_VALS`
[java] 09/06/01 17:08:41 INFO Datastore.Schema: Catalog "hive", Schema ""
initialised - managing 14 classes
[java] 09/06/01 17:08:41 INFO metastore.ObjectStore: Initialized ObjectStore
.
.Has anyone tried this combination before or am I in uncharted waters?
