Hey, The current state of the JDBC driver for Hive is probably best described as "busted". See the following thread for more: http://markmail.org/thread/w6if4fqxgdzxq4r5.
If you have significant expertise with JDBC, drop me a line off list. Regards, Jeff On Mon, Jun 1, 2009 at 3:14 PM, <[email protected]> wrote: > 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?
