Hi Yogesh, this seems to me as pure HIVE question and therefore you might consider asking your question on more appropriate mailing list ([email protected], 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
signature.asc
Description: Digital signature
