You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@sqoop.apache.org by yogesh dhari <yo...@live.com> on 2012/07/03 11:06:01 UTC
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
RE: FAILED: Execution Error, return code 1 from
org.apache.hadoop.hive.ql.exec.DDLTask
Posted by yogesh dhari <yo...@live.com>.
Hi bejoyks
Thanks a lot, Yes it solved :-)Its working well now :-)
RegardsYogesh Kumar
Subject: Re: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask
To: user@sqoop.apache.org
From: bejoyks@gmail.com
Date: Tue, 3 Jul 2012 11:43:56 +0000
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.From: yogesh dhari <yo...@live.com>
Date: Tue, 3 Jul 2012 14:36:01 +0530To: sqoop help<us...@sqoop.apache.org>ReplyTo: user@sqoop.apache.org
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
Re: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask
Posted by Bejoy KS <be...@gmail.com>.
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 <yo...@live.com>
Date: Tue, 3 Jul 2012 14:36:01
To: sqoop help<us...@sqoop.apache.org>
Reply-To: user@sqoop.apache.org
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
Re: FAILED: Execution Error, return code 1 from
org.apache.hadoop.hive.ql.exec.DDLTask
Posted by Jarek Jarcec Cecho <ja...@apache.org>.
Hi Yogesh,
this seems to me as pure HIVE question and therefore you might consider asking your question on more appropriate mailing list (user@hive.apache.org, information about the list might be found on following link: http://hive.apache.org/mailing_lists.html).
HIVE is using metastore for metadata storage (list of tables, columns, ...). This metastore is by default derby database, that you seem to be using. Your error message looks like HIVE is not able to create/initialize the metastore in the location ../build/test/junit_metastore_db. I would probably check whether the location is writable by your current user. Relative path seems strange to me, so I would also recommend checking HIVE configuration file (hive-site.xml) for correct metastore location.
Jarcec
On Tue, Jul 03, 2012 at 02:36:01PM +0530, yogesh dhari wrote:
>
> 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