[jira] [Updated] (SQOOP-999) Support bulk load from HDFS to PostgreSQL using COPY ... FROM

["Masatake Iwasaki (JIRA)" <ji...@apache.org>]

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

Masatake Iwasaki updated SQOOP-999:
-----------------------------------

    Attachment: export-to-postgresql-with-copy.patch

Export with PostgreSQL Copy API can be realized in a straitforward way. Attached file is not complete patch but sample implementation without test and consideration for corner cases.
Though this code resolves dependency for PostgreSQL JDBC by ivy, is it acceptable for the project?

                
> Support bulk load from HDFS to PostgreSQL using COPY ... FROM
> -------------------------------------------------------------
>
>                 Key: SQOOP-999
>                 URL: https://issues.apache.org/jira/browse/SQOOP-999
>             Project: Sqoop
>          Issue Type: New Feature
>          Components: connectors/postgresql
>    Affects Versions: 1.4.3
>         Environment: PostgreSQL
>            Reporter: Ruslan Al-Fakikh
>         Attachments: export-to-postgresql-with-copy.patch
>
>
> Initially taken from here:
> https://issues.cloudera.org/browse/SQOOP-184
> As Cloudera site is no longer used:
> {quote}
> Sqoop currently supports bulk export from PostgreSQL but not bulk import. PostgreSQL support COPY <table> FROM <filename> syntax and readily accepts CSV data. We should support this so there is --direct support in both directions.
> {quote}
> A note from myself:
> the pg_bulkupload feature is already implemented:
> https://issues.apache.org/jira/browse/SQOOP-390
> pg_builupload is a third-party tool, I guess supporting COPY would be a better case.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira