FAQ
Hi Team ,
I have added Hive Metastore Server role to new host using CM and set up my
own postgresql on the new HMS host

I have changed hive-site.xml to point new HMS host using CM but i am
getting following error message when i restart hive service using cloudera
manager4.7.3

+ exec /usr/lib/hive/bin/hive --config
/var/run/cloudera-scm-agent/process/616-hive-HIVEMETASTORE --service
metastore -p 9083
javax.jdo.JDOException: Exception thrown when executing query
NestedThrowablesStackTrace:
org.postgresql.util.PSQLException: ERROR: permission denied for relation DBS

I have added below config information using CM

<property>

   <name>javax.jdo.option.ConnectionURL</name>

   <value>jdbc:postgresql://slave1/metastore</value>

</property>



<property>

   <name>javax.jdo.option.ConnectionDriverName</name>

   <value>org.postgresql.Driver</value>

</property>



<property>

   <name>javax.jdo.option.ConnectionUserName</name>

   <value>hive</value>

</property>



<property>

   <name>javax.jdo.option.ConnectionPassword</name>

   <value>xxxxx</value>

</property>



<property>

   <name>datanucleus.autoCreateSchema</name>

   <value>false</value>

</property>



<property>

   <name>hive.metastore.uris</name>

   <value>thrift://slave1:9083</value>

   <description>IP address (or fully-qualified domain name) and port of the
metastore host</description>

</property>


please do needful .

Regards ,
Jagan M

To unsubscribe from this group and stop receiving emails from it, send an email to scm-users+unsubscribe@cloudera.org.

Search Discussions

  • Darren Lo at Dec 16, 2013 at 7:24 pm
    Hi Jagan,

    That error means your postgresql user doesn't have the right permissions.

    Can you make sure you've followed the following guide to set up user
    permissions for your postgresql user correctly?
    http://www.cloudera.com/content/cloudera-content/cloudera-docs/CM5/latest/Cloudera-Manager-Installation-Guide/cm5ig_install_xtrnl_pstgrs.html

    See the section "Create the PostgreSQL Database for the Hive Metastore
    Server"

    Thanks,
    Darren

    On Mon, Dec 16, 2013 at 3:24 AM, Jagan Madhappan wrote:

    Hi Team ,
    I have added Hive Metastore Server role to new host using CM and set
    up my own postgresql on the new HMS host

    I have changed hive-site.xml to point new HMS host using CM but i am
    getting following error message when i restart hive service using cloudera
    manager4.7.3

    + exec /usr/lib/hive/bin/hive --config
    /var/run/cloudera-scm-agent/process/616-hive-HIVEMETASTORE --service
    metastore -p 9083
    javax.jdo.JDOException: Exception thrown when executing query
    NestedThrowablesStackTrace:
    org.postgresql.util.PSQLException: ERROR: permission denied for relation
    DBS

    I have added below config information using CM

    <property>

    <name>javax.jdo.option.ConnectionURL</name>

    <value>jdbc:postgresql://slave1/metastore</value>

    </property>



    <property>

    <name>javax.jdo.option.ConnectionDriverName</name>

    <value>org.postgresql.Driver</value>

    </property>



    <property>

    <name>javax.jdo.option.ConnectionUserName</name>

    <value>hive</value>

    </property>



    <property>

    <name>javax.jdo.option.ConnectionPassword</name>

    <value>xxxxx</value>

    </property>



    <property>

    <name>datanucleus.autoCreateSchema</name>

    <value>false</value>

    </property>



    <property>

    <name>hive.metastore.uris</name>

    <value>thrift://slave1:9083</value>

    <description>IP address (or fully-qualified domain name) and port of
    the metastore host</description>

    </property>


    please do needful .

    Regards ,
    Jagan M

    To unsubscribe from this group and stop receiving emails from it, send an
    email to scm-users+unsubscribe@cloudera.org.


    --
    Thanks,
    Darren

    To unsubscribe from this group and stop receiving emails from it, send an email to scm-users+unsubscribe@cloudera.org.

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
groupscm-users @
categorieshadoop
postedDec 16, '13 at 11:24a
activeDec 16, '13 at 7:24p
posts2
users2
websitecloudera.com
irc#hadoop

2 users in discussion

Darren Lo: 1 post Jagan Madhappan: 1 post

People

Translate

site design / logo © 2022 Grokbase