You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@hive.apache.org by Eric Hernandez <er...@sellingsource.com> on 2011/09/09 01:30:52 UTC

Hive in Read Only Mode

Hi ,
I am getting this error when I do a show schemas;

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


I am running

hadoop-0.20-0.20.2+923.97-1
hadoop-zookeeper-3.3.3+12.12-1
hadoop-0.20-native-0.20.2+923.97-1
hadoop-hbase-0.90.3+15.3-1
hadoop-0.20-sbin-0.20.2+923.97-1
hadoop-hive-0.7.1+42.9-2
hadoop-pig-0.8.1+28.2-1
hadoop-0.20-sbin-0.20.2+923.97-1
hadoop-0.20-native-0.20.2+923.97-1

And I configured everything using cloudera-scm-server-express-3.6.1.1-1


I can acces hive just fine via the HUE desktop but when I try to access hive through the cli I get these problems.

Please Advise,

Thanks -Eric

RE: Hive in Read Only Mode

Posted by Steven Wong <sw...@netflix.com>.
Sounds like you're trying to create/modify the metastore over a read-only database connection.


From: Eric Hernandez [mailto:eric.hernandez@sellingsource.com]
Sent: Thursday, September 08, 2011 4:31 PM
To: user@hive.apache.org
Subject: Hive in Read Only Mode

Hi ,
I am getting this error when I do a show schemas;

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


I am running

hadoop-0.20-0.20.2+923.97-1
hadoop-zookeeper-3.3.3+12.12-1
hadoop-0.20-native-0.20.2+923.97-1
hadoop-hbase-0.90.3+15.3-1
hadoop-0.20-sbin-0.20.2+923.97-1
hadoop-hive-0.7.1+42.9-2
hadoop-pig-0.8.1+28.2-1
hadoop-0.20-sbin-0.20.2+923.97-1
hadoop-0.20-native-0.20.2+923.97-1

And I configured everything using cloudera-scm-server-express-3.6.1.1-1


I can acces hive just fine via the HUE desktop but when I try to access hive through the cli I get these problems.

Please Advise,

Thanks -Eric