[
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)
