[jira] [Comment Edited] (SQOOP-3190) Remove dependency on PSQL for postgres direct import

["Ang Hock Hee (JIRA)" <ji...@apache.org>]

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

Ang Hock Hee edited comment on SQOOP-3190 at 5/30/17 12:43 PM:
---------------------------------------------------------------

Patch attached as DirectPostgresqlManager.patch.
Tested with PostgresqlImportTest and passed all tests.



was (Author: alexanghh):
Patch attached as DirectPostgresqlManager.patch

> Remove dependency on PSQL for postgres direct import
> ----------------------------------------------------
>
>                 Key: SQOOP-3190
>                 URL: https://issues.apache.org/jira/browse/SQOOP-3190
>             Project: Sqoop
>          Issue Type: Improvement
>          Components: connectors/postgresql
>    Affects Versions: 1.4.7
>            Reporter: Ang Hock Hee
>            Priority: Minor
>              Labels: newbie
>             Fix For: 1.4.7
>
>         Attachments: DirectPostgresqlManager.patch
>
>   Original Estimate: 24h
>  Remaining Estimate: 24h
>
> Current Postgres direct import requires the installation of the psql utility on all hadoop nodes. However, due to system constraints, this may not always be possible. 
> It should be noted that Postgres provides a Java API which can execute the same copy command as the psql utility. As such, it would be more ideal to remove the psql utility dependency and switch to the Postgres Java API.



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)