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.DDLT

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.Objec

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)
________________________________________________________________________________
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
________________________________________________________________________________

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)

Thanks, I'll give it a shot on Monday.

On Mar 10, 2012, at 01:12 , Jagat wrote:

> Dear Keith
>
> Please delete $HADOOP_HOME/build , in your hadoop home the build directory
>
> And try again
>
> Thanks
>
> Jagat
________________________________________________________________________________
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
________________________________________________________________________________

Thanks for the suggestion, but my hadoop directory doesn't have a build directory at all.  I suppose that makes sense.  I haven't tried to rebuild hadoop since I installed it (CDH3).  I'm just using the executables as they came in the original .zip.

Gah, hive sorta works but I can't get this last bit.  It creates tables around an existing csv file, it can describe them, but queries against those tables return empty results.

On Mar 10, 2012, at 01:12 , Jagat wrote:

> 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?
________________________________________________________________________________
Keith Wiley     [EMAIL PROTECTED]     keithwiley.com    music.keithwiley.com

"And what if we picked the wrong religion?  Every week, we're just making God
madder and madder!"
                                           --  Homer Simpson
________________________________________________________________________________

hi all,

What may be the different causes for getting this error.

Execution Error, return code 2 from org.apache.hadoop.hive.ql.exec.MapRedTask

Regards
Abhishek