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

Unable to import data from Postgresql to HBase

    XMLWordPrintableJSON

Details

    • Task
    • Status: Open
    • Major
    • Resolution: Unresolved
    • 1.4.4
    • None
    • connectors/postgresql
    • 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

            Unassigned Unassigned
            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