Hadoop Hive in cygwin on windows 7 causes problem at running HiveQL.

[mahabub sikder <ma...@yahoo.com>]

Hi there,
I have been running into trouble to work with Hive in cygwin on windows 7 (64 bit).I have installed hadoop and its working fine. I can run word count job in to that successfully.I have also installed Hive on top of that and configured as default. I'm using derby db as metastore and I've created tmp and warehouse directory  as follows...
$/bin/hadoop dfs -mkdir       /tmp

/bin/hadoop dfs -mkdir       /user/hive/warehouse

/bin/hadoop dfs -chmod g+w   /tmp

/bin/hadoop dfs -chmod g+w   /user/hive/warehouseHowever, when put $HIVE_HOME/bin/hive to run hive commandline. I got hive prompt but putting HiveQL it does not respond. Cursor is blinking.
Further I tried to run HiveQL with shell together and put as like ..$ bin/hive -e 'CREATE TABLE tab1 (a INT);'
This time I got an error message like as below..
Logging initialized using configuration in file:/C:/work/hadoop/hive-0.10.0/conf/hive-log4j.propertiesHive history file=/tmp/cyg_server/hive_job_log_cyg_server_201302190038_691941401.txtFAILED: Error in metadata: java.lang.RuntimeException: Unable to instantiate org.apache.hadoop.hive.metastore.HiveMetaStoreClientFAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask

I am also paste log from hive.log2013-02-19 00:38:13,861 ERROR exec.Task (SessionState.java:printError(401)) - FAILED: Error in metadata: java.lang.RuntimeException: Unable to instantiate org.apache.hadoop.hive.metastore.HiveMetaStoreClientorg.apache.hadoop.hive.ql.metadata.HiveException: java.lang.RuntimeException: Unable to instantiate org.apache.hadoop.hive.metastore.HiveMetaStoreClient	at org.apache.hadoop.hive.ql.metadata.Hive.createTable(Hive.java:576)	at org.apache.hadoop.hive.ql.exec.DDLTask.createTable(DDLTask.java:3698)	at org.apache.hadoop.hive.ql.exec.DDLTask.execute(DDLTask.java:253)	at org.apache.hadoop.hive.ql.exec.Task.executeTask(Task.java:138)	at org.apache.hadoop.hive.ql.exec.TaskRunner.runSequential(TaskRunner.java:57)	at org.apache.hadoop.hive.ql.Driver.launchTask(Driver.java:1336)	at org.apache.hadoop.hive.ql.Driver.execute(Driver.java:1122)	at org.apache.hadoop.hive.ql.Driver.run(Driver.java:935)	at
 org.apache.hadoop.hive.cli.CliDriver.processLocalCmd(CliDriver.java:259)	at org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:216)	at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:412)	at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:347)	at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:706)	at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:613)	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)	at java.lang.reflect.Method.invoke(Method.java:601)	at org.apache.hadoop.util.RunJar.main(RunJar.java:156)Caused by: java.lang.RuntimeException: Unable to instantiate org.apache.hadoop.hive.metastore.HiveMetaStoreClient	at org.apache.hadoop.hive.metastore.MetaStoreUtils.newInstance(MetaStoreUtils.java:1078)	at
 org.apache.hadoop.hive.metastore.RetryingMetaStoreClient.<init>(RetryingMetaStoreClient.java:51)	at org.apache.hadoop.hive.metastore.RetryingMetaStoreClient.getProxy(RetryingMetaStoreClient.java:61)	at org.apache.hadoop.hive.ql.metadata.Hive.createMetaStoreClient(Hive.java:2136)	at org.apache.hadoop.hive.ql.metadata.Hive.getMSC(Hive.java:2147)	at org.apache.hadoop.hive.ql.metadata.Hive.createTable(Hive.java:570)	... 18 moreCaused by: java.lang.reflect.InvocationTargetException	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)	at java.lang.reflect.Constructor.newInstance(Constructor.java:525)	at org.apache.hadoop.hive.metastore.MetaStoreUtils.newInstance(MetaStoreUtils.java:1076)	... 23 moreCaused 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:262)	at org.apache.hadoop.hive.metastore.ObjectStore.getPersistenceManager(ObjectStore.java:291)	at org.apache.hadoop.hive.metastore.ObjectStore.initialize(ObjectStore.java:224)	at org.apache.hadoop.hive.metastore.ObjectStore.setConf(ObjectStore.java:199)	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.RetryingRawStore.<init>(RetryingRawStore.java:62)	at
 org.apache.hadoop.hive.metastore.RetryingRawStore.getProxy(RetryingRawStore.java:71)	at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.newRawStore(HiveMetaStore.java:395)	at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.getMS(HiveMetaStore.java:383)	at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.createDefaultDB(HiveMetaStore.java:421)	at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.init(HiveMetaStore.java:315)	at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.<init>(HiveMetaStore.java:285)	at org.apache.hadoop.hive.metastore.RetryingHMSHandler.<init>(RetryingHMSHandler.java:56)	at org.apache.hadoop.hive.metastore.RetryingHMSHandler.getProxy(RetryingHMSHandler.java:61)	at org.apache.hadoop.hive.metastore.HiveMetaStore.newHMSHandler(HiveMetaStore.java:4001)	at org.apache.hadoop.hive.metastore.HiveMetaStoreClient.<init>(HiveMetaStoreClient.java:120)	... 28 moreCaused by:
 java.lang.reflect.InvocationTargetException	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)	at java.lang.reflect.Method.invoke(Method.java:601)	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)	... 47 moreCaused 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)	... 55 more
2013-02-19 00:38:13,877 ERROR ql.Driver (SessionState.java:printError(401)) - FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask

Would you please help me out...Why I'm getting this kind of error and how to get rid of that.
Thanks in advance.
Mahabubur Rahaman

Sr. SOftware Engineer.

Orion Informatics Ltd.

Dhaka, Bangladesh