sqoop-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Bilung Lee (Commented) (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (SQOOP-387) Use TRUNCATE for PostgreSQLManager
Date Thu, 03 Nov 2011 20:15:33 GMT

    [ https://issues.apache.org/jira/browse/SQOOP-387?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13143501#comment-13143501
] 

Bilung Lee commented on SQOOP-387:
----------------------------------

Thanks for your contribution!  One comment.  Instead of overriding the whole migrateData and
deleteAllRecords methods, how about having a getDeleteQuery method to return the DELETE statement
in SqlManager?  Then, use it in migrateData/deleteAllRecords methods of SqlManager and only
override that in PostgreSQLManager to return TRUNCATE statement?

                
> Use TRUNCATE for PostgreSQLManager
> ----------------------------------
>
>                 Key: SQOOP-387
>                 URL: https://issues.apache.org/jira/browse/SQOOP-387
>             Project: Sqoop
>          Issue Type: Improvement
>          Components: connectors/postgresql
>            Reporter: Shinichi Yamashita
>         Attachments: 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 is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

Mime
View raw message