hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Keith Wiley <kwi...@keithwiley.com>
Subject Re: Error
Date Fri, 09 Mar 2012 23:37:27 GMT
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" <kwiley@keithwiley.com>
> To: user@hive.apache.org
> 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     kwiley@keithwiley.com     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     kwiley@keithwiley.com     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
________________________________________________________________________________


Mime
View raw message