Dear Keith Please delete $HADOOP_HOME/build , in your hadoop home the build directory
And try again Thanks Jagat On Sat, Mar 10, 2012 at 5:07 AM, Keith Wiley <[email protected]> wrote: > Considering that I don't even konw what the metastore is, I doubt I did > anything specifically aside from the instructions. All I did was follow > the startup guide. Nothing more. More to the point, when I followed the > same instructions on a Linux box, it worked. Something is admittedly wrong > with my Mac setup, but I don't think there is any third-party metastore of > some sort. I certainly didn't install or create anything like that. I'm > not even sure what it is. > > Hmmm, how do I resetup or initialize the metastore from scratch and try > again? > > On Mar 9, 2012, at 13:21 , Mark Grover wrote: > > > Hi Keith, > > This error is typically encountered when your metastore (that stores the > metadata related to Hive tables e.g. name of columns, name of tables, etc. > etc.) is not correctly set up. > > > > Have you set up an external metastore? By default, Hive should use an > embedded Derby metastore which only allows one connection at a time. > > > > Mark > > > > Mark Grover, Business Intelligence Analyst > > OANDA Corporation > > > > www: oanda.com www: fxtrade.com > > > > "Best Trading Platform" - World Finance's Forex Awards 2009. > > "The One to Watch" - Treasury Today's Adam Smith Awards 2009. > > > > > > ----- Original Message ----- > > From: "Keith Wiley" <[email protected]> > > To: [email protected] > > Sent: Friday, March 9, 2012 3:02:40 PM > > Subject: Error > > > > I'm quite comfortable hadoop and the associated lingo, been programming > it via Java and via C++ streams for several years. However, I have just > started Hive for the first time...and I'm stuck. I was following the > "getting started" page on the apache site. I got a far as this: > > > > hive> CREATE TABLE pokes (foo INT, bar STRING); > > FAILED: Error in metadata: javax.jdo.JDOFatalInternalException: > Unexpected exception caught. > > NestedThrowables: > > java.lang.reflect.InvocationTargetException > > FAILED: Execution Error, return code 1 from > org.apache.hadoop.hive.ql.exec.DDLTask > > > > If I look at the logs, I see the following. I'm not sure how to proceed > from here. Any help is appreciated. > > > > Thanks. > > > > $ cat /tmp/keithw/hive.log > > 2012-03-09 12:02:22,087 ERROR exec.DDLTask > (SessionState.java:printError(365)) - FAILED: Error in metadata: > javax.jdo.JDOFatalInternalException: Unexpected exception caught. > > NestedThrowables: > > java.lang.reflect.InvocationTargetException > > org.apache.hadoop.hive.ql.metadata.HiveException: > javax.jdo.JDOFatalInternalException: Unexpected exception caught. > > NestedThrowables: > > java.lang.reflect.InvocationTargetException > > at > org.apache.hadoop.hive.ql.metadata.Hive.createTable(Hive.java:476) > > at > org.apache.hadoop.hive.ql.exec.DDLTask.createTable(DDLTask.java:3176) > > at org.apache.hadoop.hive.ql.exec.DDLTask.execute(DDLTask.java:213) > > at org.apache.hadoop.hive.ql.exec.Task.executeTask(Task.java:131) > > at > org.apache.hadoop.hive.ql.exec.TaskRunner.runSequential(TaskRunner.java:57) > > at org.apache.hadoop.hive.ql.Driver.launchTask(Driver.java:1063) > > at org.apache.hadoop.hive.ql.Driver.execute(Driver.java:900) > > at org.apache.hadoop.hive.ql.Driver.run(Driver.java:748) > > at > org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:209) > > at > org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:286) > > at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:516) > > 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) > > Caused by: javax.jdo.JDOFatalInternalException: Unexpected exception > caught. > > NestedThrowables: > > java.lang.reflect.InvocationTargetException > > at > javax.jdo.JDOHelper.invokeGetPersistenceManagerFactoryOnImplementation(JDOHelper.java:1186) > > at > javax.jdo.JDOHelper.getPersistenceManagerFactory(JDOHelper.java:803) > > at > javax.jdo.JDOHelper.getPersistenceManagerFactory(JDOHelper.java:698) > > at > org.apache.hadoop.hive.metastore.ObjectStore.getPMF(ObjectStore.java:234) > > at > org.apache.hadoop.hive.metastore.ObjectStore.getPersistenceManager(ObjectStore.java:261) > > at > org.apache.hadoop.hive.metastore.ObjectStore.initialize(ObjectStore.java:196) > > at > org.apache.hadoop.hive.metastore.ObjectStore.setConf(ObjectStore.java:171) > > at > org.apache.hadoop.util.ReflectionUtils.setConf(ReflectionUtils.java:62) > > at > org.apache.hadoop.util.ReflectionUtils.newInstance(ReflectionUtils.java:117) > > at > org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.getMS(HiveMetaStore.java:354) > > at > org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.executeWithRetry(HiveMetaStore.java:306) > > at > org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.createDefaultDB(HiveMetaStore.java:451) > > at > org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.init(HiveMetaStore.java:232) > > at > org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.<init>(HiveMetaStore.java:197) > > at > org.apache.hadoop.hive.metastore.HiveMetaStoreClient.<init>(HiveMetaStoreClient.java:108) > > at > org.apache.hadoop.hive.ql.metadata.Hive.createMetaStoreClient(Hive.java:1868) > > at org.apache.hadoop.hive.ql.metadata.Hive.getMSC(Hive.java:1878) > > at > org.apache.hadoop.hive.ql.metadata.Hive.createTable(Hive.java:470) > > ... 15 more > > Caused by: java.lang.reflect.InvocationTargetException > > 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 javax.jdo.JDOHelper$16.run(JDOHelper.java:1958) > > at java.security.AccessController.doPrivileged(Native Method) > > at javax.jdo.JDOHelper.invoke(JDOHelper.java:1953) > > at > javax.jdo.JDOHelper.invokeGetPersistenceManagerFactoryOnImplementation(JDOHelper.java:1159) > > ... 32 more > > Caused by: java.lang.NullPointerException > > at > org.datanucleus.plugin.NonManagedPluginRegistry.registerBundle(NonManagedPluginRegistry.java:443) > > at > org.datanucleus.plugin.NonManagedPluginRegistry.registerBundle(NonManagedPluginRegistry.java:355) > > at > org.datanucleus.plugin.NonManagedPluginRegistry.registerExtensions(NonManagedPluginRegistry.java:215) > > at > org.datanucleus.plugin.NonManagedPluginRegistry.registerExtensionPoints(NonManagedPluginRegistry.java:156) > > at > org.datanucleus.plugin.PluginManager.registerExtensionPoints(PluginManager.java:82) > > at org.datanucleus.OMFContext.<init>(OMFContext.java:156) > > at org.datanucleus.OMFContext.<init>(OMFContext.java:137) > > at > org.datanucleus.ObjectManagerFactoryImpl.initialiseOMFContext(ObjectManagerFactoryImpl.java:132) > > at > org.datanucleus.jdo.JDOPersistenceManagerFactory.initialiseProperties(JDOPersistenceManagerFactory.java:363) > > at > org.datanucleus.jdo.JDOPersistenceManagerFactory.<init>(JDOPersistenceManagerFactory.java:307) > > at > org.datanucleus.jdo.JDOPersistenceManagerFactory.createPersistenceManagerFactory(JDOPersistenceManagerFactory.java:255) > > at > org.datanucleus.jdo.JDOPersistenceManagerFactory.getPersistenceManagerFactory(JDOPersistenceManagerFactory.java:182) > > ... 40 more > > > > 2012-03-09 12:02:22,090 ERROR ql.Driver > (SessionState.java:printError(365)) - FAILED: Execution Error, return code > 1 from org.apache.hadoop.hive.ql.exec.DDLTask > > > > > ________________________________________________________________________________ > > Keith Wiley [email protected] keithwiley.com > music.keithwiley.com > > > > "The easy confidence with which I know another man's religion is folly > teaches > > me to suspect that my own is also." > > -- Mark Twain > > > ________________________________________________________________________________ > > > > > > ________________________________________________________________________________ > Keith Wiley [email protected] keithwiley.com > music.keithwiley.com > > "It's a fine line between meticulous and obsessive-compulsive and a > slippery > rope between obsessive-compulsive and debilitatingly slow." > -- Keith Wiley > > ________________________________________________________________________________ > >
