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

Use TRUNCATE for PostgreSQLManager

    Details

    • Type: Improvement
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 1.4.2
    • Fix Version/s: None
    • Component/s: connectors/postgresql
    • Labels:

      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
          Farhan Khan
        2. SQOOP-387.patch
          3 kB
          Shinichi Yamashita
        3. SQOOP-387.patch
          3 kB
          Shinichi Yamashita

          Activity

            People

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

              Dates

              • Created:
                Updated: