FAQ
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!

Search Discussions

  • Harsh J at Sep 8, 2012 at 1:08 pm
    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

Related Discussions

Discussion Navigation
viewthread | post
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