Hi,
I am working on CDH4 install. We do not have a MySQL or a PostGreSQL to
work with Hive. How can I allow multiple users to share the same space in
derby db?
I have tried giving 777 permission along with deleting the 2 lock files as
below but that does not work for me.
dbex.lck
db.lck
I get these errors:
hive> show tables;
FAILED: Error in metadata: javax.jdo.JDOFatalDataStoreException: Cannot get
a connection, pool error Could not create a validated object, cause: A
read-only user or a user in a read-only database is not permitted to
disable read-only mode on a connection.
NestedThrowables:
org.apache.commons.dbcp.SQLNestedException: Cannot get a connection, pool
error Could not create a validated object, cause: A read-only user or a
user in a read-only database is not permitted to disable read-only mode on
a connection.
FAILED: Execution Error, return code 1 from
org.apache.hadoop.hive.ql.exec.DDLTask
hive>
----------------------------------------------------------------------
And this error when the db is held under another id:
FAILED: Error in metadata: javax.jdo.JDOFatalDataStoreException: Failed to
start database '/cmls/hive/metastore/metastore_db', see the next exception
for details.
NestedThrowables:
java.sql.SQLException: Failed to start database
'/cmls/hive/metastore/metastore_db', see the next exception for details.
FAILED: Execution Error, return code 1 from
org.apache.hadoop.hive.ql.exec.DDLTask
Can you please share how you did it?
Thanks,
Sumit.
--