[SQOOP-1559] Unable to import data from Postgresql to HBase

• Type: Task
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 1.4.4
• Component/s: connectors/postgresql
• Labels: sqoop

Environment

Cent OS, rackspace cloud, Hadoop version:2.4.0

• Assignee: Unassigned
• Reporter: George Jaffa
• Created: 30/Sep/14 11:22
• Updated: 03/Oct/14 10:14

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