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

Use TRUNCATE for PostgreSQLManager

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Open
    • Major
    • Resolution: Unresolved
    • 1.4.2
    • None
    • connectors/postgresql

    Description

      PostgreSQLManager uses "DELETE" sentence for procesing in staging-table.
      When it does "EXPORT" many times, the processing time is prolonged in "DELETE".
      Therefore replace it with "TRUNCATE" sentence and improve performance.

      Attachments

        1. SQOOP-387.patch
          3 kB
          Shinichi Yamashita
        2. SQOOP-387.patch
          3 kB
          Shinichi Yamashita
        3. SQOOP-387.patch
          3 kB
          Farhan Khan

        Activity

          People

            Unassigned Unassigned
            yamashitasni Shinichi Yamashita
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

            Dates

              Created:
              Updated: