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

• Type: New Feature
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.4.3
• Fix Version/s: 1.4.4
• Component/s: connectors/postgresql

Environment

PostgreSQL

• Assignee: Masatake Iwasaki
• Reporter: Ruslan Al-Fakikh
• Created: 19/Apr/13 20:15
• Updated: 23/Jun/16 08:59
• Resolved: 04/Jul/13 01:39

Description

Initially taken from here:
https://issues.cloudera.org/browse/SQOOP-184
As Cloudera site is no longer used:

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.

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.

Issue Links

• relates to: SQOOP-2972 SQOOP Direct Export To PostgreSQL Supports Selective Columns
• relates to: SQOOP-1118 Move PostgreSQL specific MR codes to org.apache.sqoop.mapreduce.posgresql
• links to: Review board link