FAQ
Hi,

I am trying to installing Hive w/ mysql database..and I am seeing the
below errors when I do "show tables"

hive> show tables;
FAILED: Error in metadata: javax.jdo.JDOFatalDataStoreException: null,
message from server: "Host 'edge003.map.att.com' is not allowed to
connect to this MySQL server"
NestedThrowables:
java.sql.SQLException: null, message from server: "Host
'edge003.map.att.com' is not allowed to connect to this MySQL server"
FAILED: Execution Error, return code 1 from
org.apache.hadoop.hive.ql.exec.DDLTask

Thanks,
Chittu

Search Discussions

  • Philip Langdale at Nov 20, 2012 at 5:09 pm
    Hi Chittu,

    By default, mysql does not allow remote access. Here's a guide on how to
    enable it.

    http://www.cyberciti.biz/tips/how-do-i-enable-remote-access-to-mysql-database-server.html

    --phil


    On 16 November 2012 15:05, wrote:

    Hi,

    I am trying to installing Hive w/ mysql database..and I am seeing the
    below errors when I do "show tables"

    hive> show tables;
    FAILED: Error in metadata: javax.jdo.JDOFatalDataStoreException: null,
    message from server: "Host 'edge003.map.att.com' is not allowed to
    connect to this MySQL server"
    NestedThrowables:
    java.sql.SQLException: null, message from server: "Host
    'edge003.map.att.com' is not allowed to connect to this MySQL server"
    FAILED: Execution Error, return code 1 from
    org.apache.hadoop.hive.ql.exec.DDLTask

    Thanks,
    Chittu

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
groupscm-users @
categorieshadoop
postedNov 20, '12 at 3:43p
activeNov 20, '12 at 5:09p
posts2
users2
websitecloudera.com
irc#hadoop

2 users in discussion

Chittu546: 1 post Philip Langdale: 1 post

People

Translate

site design / logo © 2022 Grokbase