sqoop-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Farhan Khan (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (SQOOP-387) Use TRUNCATE for PostgreSQLManager
Date Sat, 03 Feb 2018 11:24:00 GMT

     [ https://issues.apache.org/jira/browse/SQOOP-387?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Farhan Khan updated SQOOP-387:
------------------------------
    Attachment:     (was: SQOOP-387.patch)

> Use TRUNCATE for PostgreSQLManager
> ----------------------------------
>
>                 Key: SQOOP-387
>                 URL: https://issues.apache.org/jira/browse/SQOOP-387
>             Project: Sqoop
>          Issue Type: Improvement
>          Components: connectors/postgresql
>    Affects Versions: 1.4.2
>            Reporter: Shinichi Yamashita
>            Priority: Major
>              Labels: newbie
>         Attachments: SQOOP-387.patch, SQOOP-387.patch
>
>
> 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.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

Mime
View raw message