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

Direct export to Netezza : user/owner confusion

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Patch Available
    • Major
    • Resolution: Unresolved
    • 1.4.6
    • None
    • connectors
    • None

    Description

      Hi,
      when exporting to Netezza, if connected user (in the Netezza URL) is not the target table owner, things go wrong :

      • if you do not use qualified table name, the table existence check will fail since SQOOP will assume table owner is the same as connected user
      • if you do use qualified table name, the table existence check will succeed but table export will fail since SQOOP will try to export to a twice qualified table (db.owner.owner.table instead of db.owner.table)
        Regards

      Attachments

        1. 0001-SQOOP-2821.patch
          1 kB
          Benjamin BONNET

        Issue Links

          Activity

            People

              bbonnet Benjamin BONNET
              bbonnet Benjamin BONNET
              Votes:
              1 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated: