You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@sqoop.apache.org by "George Jaffa (JIRA)" <ji...@apache.org> on 2014/09/30 13:27:33 UTC

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

     [ https://issues.apache.org/jira/browse/SQOOP-1559?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

George Jaffa updated SQOOP-1559:
--------------------------------
    Description: 
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

  was:
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/shell_core_test --username root --password xxxxxxxxxx --table channels

Error:

ERROR manager.SqlManager: Error executing statement: org.postgresql.util.PSQLException: FATAL: role "root" does not exist


> 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: 40h
>  Remaining Estimate: 40h
>
> 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)