Hive installation issue while following Hive apache wiki step by step

⇧

⇩

59 views

After installed Hive by the instruction on Hive apache wiki step by step, I invoked hive shell and typed "CREATE TABLE pokes (foo INT, bar STRING);", then it comes following error, log is also included.

I'm new to Hive, any suggestion or comments? Thanks a lot! I found the questions asked over google the web, but did not find solution.

I use single machine mode for Hadoop on Mac.

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

log file:

Last login: Tue Jun 14 00:27:51 on ttys001 Zhiyong-Xies-MacBook-Pro:~ hadoop$ cat /tmp/*/hive.log 2011-06-14 00:31:54,834 ERROR metastore.HiveMetaStore (HiveMetaStore.java:executeWithRetry(334)) - JDO datastore error. Retrying metastore command after 1000 ms (attempt 1 of 1) 2011-06-14 00:31:56,012 ERROR exec.DDLTask (SessionState.java:printError(374)) - 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:491) at org.apache.hadoop.hive.ql.exec.DDLTask.createTable(DDLTask.java:3233) at org.apache.hadoop.hive.ql.exec.DDLTask.execute(DDLTask.java:221) at org.apache.hadoop.hive.ql.exec.Task.executeTask(Task.java:132) at org.apache.hadoop.hive.ql.exec.TaskRunner.runSequential(TaskRunner.java:57) at org.apache.hadoop.hive.ql.Driver.launchTask(Driver.java:1238) at org.apache.hadoop.hive.ql.Driver.execute(Driver.java:1050) at org.apache.hadoop.hive.ql.Driver.run(Driver.java:885) at org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:224) at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:358) at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:593) 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:156) 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:237) at org.apache.hadoop.hive.metastore.ObjectStore.getPersistenceManager(ObjectStore.java:266) at org.apache.hadoop.hive.metastore.ObjectStore.initialize(ObjectStore.java:199) at org.apache.hadoop.hive.metastore.ObjectStore.setConf(ObjectStore.java:174) 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:369) at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.executeWithRetry(HiveMetaStore.java:321) at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.createDefaultDB(HiveMetaStore.java:466) at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.init(HiveMetaStore.java:240) at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.(HiveMetaStore.java:203) at org.apache.hadoop.hive.metastore.HiveMetaStoreClient.(HiveMetaStoreClient.java:107) at org.apache.hadoop.hive.ql.metadata.Hive.createMetaStoreClient(Hive.java:2010) at org.apache.hadoop.hive.ql.metadata.Hive.getMSC(Hive.java:2020) at org.apache.hadoop.hive.ql.metadata.Hive.createTable(Hive.java:485) ... 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.(OMFContext.java:156) at org.datanucleus.OMFContext.(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.(JDOPersistenceManagerFactory.java:307) at org.datanucleus.jdo.JDOPersistenceManagerFactory.createPersistenceManagerFactory(JDOPersistenceManagerFactory.java:255) at org.datanucleus.jdo.JDOPersistenceManagerFactory.getPersistenceManagerFactory(JDOPersistenceManagerFactory.java:182) ... 40 more

2011-06-14 00:31:56,014 ERROR ql.Driver (SessionState.java:printError(374)) - FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask

hadoop hive

asked June 14, 2011 9:15 am CDT

Joe

posted via StackOverflow

0 Answers

Be the first to answer this question

Similar discussion threads

Where are the step-by-step instructions for building apache 2.2.17 with LDAP authentication?
March 18, 2011 08:30:24 AM
Hello, Can anyone point me to some step-by-step directions on how to build apache 2.2.17 with openldap.... I am on Red Hat 4 2.6.9-89.35.1.ELsmp Do I need to install openldap? I tried to build apache as below. ./configure…

Step by Step Guide – Install Jakarta on Windows 2003 and 2008 Server
December 7, 2010 02:39:19 AM
These Step by Step Guides covers the installation of Apache Tomcat Connector Jakarta on Windows 2003 and 2008 Server. In these guides Jakarta are used by Nordic Edge products to integrate with Windows IIS to enable Single Sign-On to SAML…

Add step to LRANGE
November 17, 2010 03:38:53 PM
In order to facilitate doing stuff with "columns" of data pulled out by SORT ... STORE commands, a step could be added to LRANGE (since STORE creates a List). E.g., suppose the following SORT someset GET somehash.*->field1 GET…

first step with Cassandra
October 4, 2010 10:57:13 AM
Hello all, I am here with a very basic question. I am very new to Cassandra slowly migrating from RDBMS world. Is there any worked example that I can use it to learn Cassandra? I have lots of documentation around Cassandra but any simple worked…

Message cleanup, next step...
August 18, 2010 04:03:03 AM
Hi guys, now that most of the work is done for the message merge, I have a question : - should we keep the message interfaces in a separate package ? Atm, all the message implementation are in org.apache.directory.shared.ldap.message, while…

how to the ATS single-step debugging?
November 18, 2010 01:59:25 AM
Hi, I`ve been debugging the ATS these days, all I want is single-step debugging the below procedures. 1. accept the client request 2. connect the original server and receive the response 3. send the response to the client Unfortunately,…

Parameter passing at every step
November 2, 2010 04:45:51 PM
Hi, I have 10 HTTP request. At each step do i have to send parameters with this request(username, password and domain) ? Is there a better way to send username, password and domain only once. Otherwise thro wireshark i see a different user…

Next step on external certificates
July 1, 2010 04:14:12 PM
Next questions.. again. my goal is to have puppet work with an external set of x.509 credentials. (1) When puppetmasterd starts up, it creates a CSR for $certname. What is this certificate used for? I would assume that the CA's cert and keys …

Transactions while using prepare and step
December 2, 2010 09:44:58 AM
Hello I have a basic question and would be glad if someone can answer it. I understand that if we have "BEGIN TRANSACTION" and "END TRANSACTION" then the transaction(s) within that block would be committed, number of transactions could be…

needed step to alpha-3
August 12, 2010 02:00:39 PM
Hi all guys, this email just to remind the steps have to be completed to before the alpha-3 release. Jira issues have to be created. After the alpha-2 release, in the last development time of C3, 3 new pipeline components have been…

Subentry cache : one step further
January 2, 2011 05:28:24 PM
Hi, today, I modified the SubentryCache to offer an opaque class which hide the inner data structure. In other words, this cache now handles both the UUID -> Subentry and DN -> Suentry caches internally, because there is no reason that…

Step back to build consensus
February 4, 2011 05:08:38 PM
Apache is a place where community matters more than code. Right now, the community dynamics within [math] are clearly difficult. I ask ALL those involved to step back for the weekend and to not post on the topic of [math] until Monday. In that…

Replica set sync problems after step down
November 16, 2010 02:04:40 AM
I've noticed the following thing happen 2 times in a row: I do a step down on the primary, and a new replica becomes primary, but the old primary ends up throwing "duplicate key" errors instead of becoming secondary. I then tried to remove the…

planning portability and scalability from first step
May 30, 2011 10:14:49 PM
Hi, Being new to mongo, I wonder how will decisions I am about make now affect my ability to move data from one (small and temporary) server to another when data scale grows. I also wonder, if I start in a single default installation…

build instructions seems to be missing a step:
November 10, 2010 04:00:11 PM
Following the instructions here: http://activemq.apache.org/getting-started.html#GettingStarted-Startin gActiveMQ I downloaded the source to 5.4.1. (None of the mirrors were working so I downloaded from svn: svn co…

Error after signing certificate step
December 14, 2010 05:23:26 AM
Hi I'm trying puppet for the first time and attempting to get it working in Amazon EC2 with Ubuntu 10.04 using the default puppet 0.25.4-2ubuntu4, I've read the 'Pulling Strings' book and tried following various tutorials found on the net to set…

Re: Parent nodes & multi-step transactions
August 24, 2010 09:58:37 AM
> Every functionality added to ZK will make it harder to maintain. The use case Definitely, but it's hard to debate about features at that level. If we delete the whole code base, we have nothing to maintain, so given this r. >…

Re: Parent nodes & multi-step transactions
August 24, 2010 04:54:40 AM
Hi Thomas, > I have a very strong feeling against more complex operations in the ZK server. Can you please describe a little better what that feeling is about? > These are things that should be provided by a ZK client helper library. The …

Parent nodes & multi-step transactions
August 23, 2010 09:35:26 AM
Greetings, We (a development team at Canonical) are stumbling into a situation here which I'd be curious to understand what is the general practice, since I'm sure this is somewhat of a common issue. It's quite easy to describe it: say there's a…

Replica set step down does not work under high load
March 29, 2011 12:02:20 PM
We had a problem with replica set step down not working under high load. The sequence of events: 1) Run Repair on nonMaster 2) Master monitor's rs.status of nonMaster to determine heath = 1 && status = 2 (there is a bug that when the…

Questions and Answers are licensed under cc-wiki license.

Hive installation issue while following Hive apache wiki step by step

0 Answers

Be the first to answer this question

Join with account you already have