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