[jira] [Commented] (SQOOP-1559) Unable to import data from Postgresql to HBase

["Chiwan Park (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/SQOOP-1559?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14153097#comment-14153097 ] 

Chiwan Park commented on SQOOP-1559:
------------------------------------

I think there is no user named 'root' in postgresql. Could you check existence user 'root' with following command "psql -d core -U root"?

> Unable to import data from Postgresql to HBase
> ----------------------------------------------
>
>                 Key: SQOOP-1559
>                 URL: https://issues.apache.org/jira/browse/SQOOP-1559
>             Project: Sqoop
>          Issue Type: Task
>          Components: connectors/postgresql
>    Affects Versions: 1.4.4
>         Environment: Cent OS, rackspace cloud, Hadoop version:2.4.0
>            Reporter: George Jaffa
>              Labels: sqoop
>   Original Estimate: 4h
>  Remaining Estimate: 4h
>
> Trying to import data from Postgresql to HDFS by using sqoop. The relevant connector was placed at correct path but still unable to import the data.
> Command used:
> sqoop import --connect jdbc:postgresql://xxx.xx.xxx.xxx:5432/core --username root --password xxxxxxxxxx --table channels
> Error:
> ERROR manager.SqlManager: Error executing statement: org.postgresql.util.PSQLException: FATAL: role "root" does not exist



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)