Ya, the issue ended up being I had some thirft settings that came with previous versions of MapR
!-- <property> <name>hive.metastore.local</name> <value>true</value> <description>controls whether to connect to remove metastore server or open a new metastore server in Hive Client JVM</description> </property> --> <!-- <property> <name>hive.metastore.uris</name> <value>thrift://localhost:3306</value> </property> --> Once commented out, it worked... *shrug* I did read some stuff about these settings changing in 0.10 On Wed, Apr 3, 2013 at 6:59 PM, Richard Nadeau <strout...@gmail.com> wrote: > Hi John, > > Do you have a copy of the MySQL JDBC driver in your Hive library path? > > Rick > On Apr 3, 2013 3:57 PM, "John Omernik" <j...@omernik.com> wrote: > >> Not sure what the issues is, conf is good, validated I can log in to >> mysql with username in the hive-site, and I ran the metastore update >> scripts. >> >> show tables; >> java.lang.OutOfMemoryError: Java heap space >> at >> org.apache.thrift.protocol.TBinaryProtocol.readStringBody(TBinaryProtocol.java:353) >> at >> org.apache.thrift.protocol.TBinaryProtocol.readMessageBegin(TBinaryProtocol.java:215) >> at org.apache.thrift.TServiceClient.receiveBase(TServiceClient.java:69) >> at >> org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$Client.recv_get_database(ThriftHiveMetastore.java:412) >> at >> org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$Client.get_database(ThriftHiveMetastore.java:399) >> at >> org.apache.hadoop.hive.metastore.HiveMetaStoreClient.getDatabase(HiveMetaStoreClient.java:736) >> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) >> at >> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) >> at >> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) >> at java.lang.reflect.Method.invoke(Method.java:597) >> at >> org.apache.hadoop.hive.metastore.RetryingMetaStoreClient.invoke(RetryingMetaStoreClient.java:74) >> at $Proxy6.getDatabase(Unknown Source) >> at org.apache.hadoop.hive.ql.metadata.Hive.getDatabase(Hive.java:1110) >> at org.apache.hadoop.hive.ql.metadata.Hive.databaseExists(Hive.java:1099) >> at org.apache.hadoop.hive.ql.exec.DDLTask.showTables(DDLTask.java:2206) >> at org.apache.hadoop.hive.ql.exec.DDLTask.execute(DDLTask.java:334) >> at org.apache.hadoop.hive.ql.exec.Task.executeTask(Task.java:138) >> at >> org.apache.hadoop.hive.ql.exec.TaskRunner.runSequential(TaskRunner.java:57) >> at org.apache.hadoop.hive.ql.Driver.launchTask(Driver.java:1336) >> at org.apache.hadoop.hive.ql.Driver.execute(Driver.java:1122) >> at org.apache.hadoop.hive.ql.Driver.run(Driver.java:935) >> at >> org.apache.hadoop.hive.cli.CliDriver.processLocalCmd(CliDriver.java:259) >> at org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:216) >> at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:412) >> at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:755) >> at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:613) >> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) >> at >> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) >> at >> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) >> at java.lang.reflect.Method.invoke(Method.java:597) >> at org.apache.hadoop.util.RunJar.main(RunJar.java:197) >> FAILED: Execution Error, return code -101 from >> org.apache.hadoop.hive.ql.exec.DDLTask >> >> >> Thoughts? >> >