FAQ
Hi Mark,

Seems like you're using the default Derby database instance in your
Hive configuration (the one that gets applied OOB). The Derby
metastore backend doesn't support multiple users and hence if you do
not use the same user as the one that owns the directory
/var/lib/hive/metastore to run "hive", it will not work.

We highly recommend setting up MySQL and using that for your Hive
metastore backend, rather than sticking with the Derby default. Setup
help for MySQL is documented on the same Hive Installation page:
https://ccp.cloudera.com/display/CDH4DOC/Hive+Installation#HiveInstallation-ConfiguringtheHiveMetastore
(The Derby caveat is also mentioned in it).
On Thu, Sep 6, 2012 at 1:18 AM, Mark wrote:
Hi,

I built a cluster using cloudera manager on EC2 and when I run Hive I get
the following Error:

hdfs@ip-xx-xx-xx-xxx:~$ hive
WARNING: org.apache.hadoop.metrics.jvm.EventCounter is deprecated. Please
use org.apache.hadoop.log.metrics.EventCounter in all the log4j.properties
files.
Logging initialized using configuration in
jar:file:/usr/lib/hive/lib/hive-common-0.8.1-cdh4.0.1.jar!/hive-log4j.properties
Hive history file=/tmp/hdfs/hive_job_log_hdfs_201209051942_279112843.txt
hive> create table test(i int);
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> quit;

Thanks for your help!


--
Harsh J

Search Discussions

Discussion Posts

Previous

Related Discussions

Discussion Navigation
viewthread | post
posts ‹ prev | 2 of 2 | next ›
Discussion Overview
groupscm-users @
categorieshadoop
postedSep 5, '12 at 7:49p
activeSep 8, '12 at 1:08p
posts2
users2
websitecloudera.com
irc#hadoop

2 users in discussion

Mark: 1 post Harsh J: 1 post

People

Translate

site design / logo © 2022 Grokbase