Hi there, I'm new to Hive, any suggestion or comment on the following installation issue? Thanks a lot! I found the questions asked over google the web, but did not find solution.
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, also, the lib files from my /build/dist/lib is attached. I use single machine mode for Hadoop on Mac. I had two tries, one is hive-0.7.0-bin (http://www.gtlib.gatech.edu/pub/apache//hive/hive-0.7.0/), another is compiling the code checked out from http://svn.apache.org/repos/asf/hive/trunk. Both have the same problem, I did not make additional changes for the configuration files under .../conf/. I also asked on stackoverflow, http://stackoverflow.com/questions/6344942/hive-installation-issue-while-following-hive-apache-wiki-step-by-step. Error Messages: 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 -- Joe (Zhiyong) Xie Graduate Student Electrical Engineering Department University of Washington, Seattle, WA LinkedIn: http://www.linkedin.com/in/zhiyongxie
build/dist/lib/ant-contrib-1.0b3.jar build/dist/lib/antlr-runtime-3.0.1.jar build/dist/lib/asm-3.1.jar build/dist/lib/commons-cli-1.2.jar build/dist/lib/commons-codec-1.3.jar build/dist/lib/commons-collections-3.2.1.jar build/dist/lib/commons-dbcp-1.4.jar build/dist/lib/commons-lang-2.4.jar build/dist/lib/commons-logging-1.0.4.jar build/dist/lib/commons-logging-api-1.0.4.jar build/dist/lib/commons-pool-1.5.4.jar build/dist/lib/datanucleus-connectionpool-2.0.3.jar build/dist/lib/datanucleus-core-2.0.3.jar build/dist/lib/datanucleus-enhancer-2.0.3.jar build/dist/lib/datanucleus-rdbms-2.0.3.jar build/dist/lib/derby.jar build/dist/lib/guava-r06.jar build/dist/lib/hbase-0.89.0-SNAPSHOT-tests.jar build/dist/lib/hbase-0.89.0-SNAPSHOT.jar build/dist/lib/hive-anttasks-0.8.0-SNAPSHOT.jar build/dist/lib/hive-cli-0.8.0-SNAPSHOT.jar build/dist/lib/hive-common-0.8.0-SNAPSHOT.jar build/dist/lib/hive-contrib-0.8.0-SNAPSHOT.jar build/dist/lib/hive-exec-0.8.0-SNAPSHOT.jar build/dist/lib/hive-hbase-handler-0.8.0-SNAPSHOT.jar build/dist/lib/hive-hwi-0.8.0-SNAPSHOT.jar build/dist/lib/hive-hwi-0.8.0-SNAPSHOT.war build/dist/lib/hive-jdbc-0.8.0-SNAPSHOT.jar build/dist/lib/hive-metastore-0.8.0-SNAPSHOT.jar build/dist/lib/hive-serde-0.8.0-SNAPSHOT.jar build/dist/lib/hive-service-0.8.0-SNAPSHOT.jar build/dist/lib/hive-shims-0.8.0-SNAPSHOT.jar build/dist/lib/hive_contrib.jar build/dist/lib/javaewah-0.2.jar build/dist/lib/jdo2-api-2.3-ec.jar build/dist/lib/jline-0.9.94.jar build/dist/lib/json.jar build/dist/lib/junit-3.8.1.jar build/dist/lib/libfb303.jar build/dist/lib/libthrift.jar build/dist/lib/log4j-1.2.15.jar build/dist/lib/log4j-1.2.16.jar build/dist/lib/slf4j-api-1.6.1.jar build/dist/lib/slf4j-log4j12-1.6.1.jar build/dist/lib/stringtemplate-3.1b1.jar build/dist/lib/thrift-0.5.0.jar build/dist/lib/thrift-fb303-0.5.0.jar build/dist/lib/velocity-1.5.jar build/dist/lib/zookeeper-3.3.1.jar build/dist/lib/php: Thrift.php autoload.php ext packages protocol transport build/dist/lib/py: fb303 fb303_scripts hive_metastore hive_serde hive_service queryplan thrift
