Hi Yogesh Was your hive working before?
If it is first time,then hive tries to create the meta store db. The error looks like hive derby meta store is not able to create the database due to permission issues. Please ensure that the folder has the right permissions before proceeding ahead. Regards Bejoy KS Sent from handheld, please excuse typos. -----Original Message----- From: yogesh dhari <[email protected]> Date: Tue, 3 Jul 2012 14:36:01 To: sqoop help<[email protected]> Reply-To: [email protected] Subject: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask Hi, I have set HIVE_HOME like. export HIVE_HOME = /HADOOP/hive ( here I have kept hive)export PATH = $PATH:$HIVE_HOME/bin then I enterd the command " hive" it went into hive shell(envoirment), hive started successfully, but when I run command show tables; it shows error i.e FAILED: Error in metadata: javax.jdo.JDOFatalDataStoreException: Failed to create database '../build/test/junit_metastore_db', see the next exception for details. NestedThrowables: java.sql.SQLException: Failed to create database '../build/test/junit_metastore_db', see the next exception for details. FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask Please help RegardsYogesh Kumar
