hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From vaibhav negi <>
Subject Hive - ERROR XBM0H: Directory /root/metastore_db cannot be created
Date Thu, 02 Sep 2010 07:36:55 GMT
Hi ,

I am running hive on  hadoop 0.20.2  with 2 node cluster.

I had created hadoop user and loaded data into hive. But now after two days
when i am (logging with hadoop user) starting hive and running query for
show tables . I am getting below error.

java.sql.SQLException: Failed to create database 'metastore_db', see the
next exception for details.
FAILED: Execution Error, return code 1 from

When i switch user to root and run same query , no error occurs but i could
see no tables.

Hive history file=/tmp/root/hive_job_log_root_201009021236_1725176336.txt
    > show tables;
Time taken: 9.194 seconds

What may be the problem? Kindly suggest some remedy.

Complete error log  is attached.

Thanks and Regards

Vaibhav Negi

View raw message