Uploaded image for project: 'Sqoop'
  1. Sqoop
  2. SQOOP-1559

Unable to import data from Postgresql to HBase

    XMLWordPrintableJSON

    Details

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

      Cent OS, rackspace cloud, Hadoop version:2.4.0

      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

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              george9999 George Jaffa
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:

                Time Tracking

                Estimated:
                Original Estimate - 4h
                4h
                Remaining:
                Remaining Estimate - 4h
                4h
                Logged:
                Time Spent - Not Specified
                Not Specified