[
https://issues.apache.org/jira/browse/SQOOP-3278?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16328532#comment-16328532
]
ASF GitHub Bot commented on SQOOP-3278:
---------------------------------------
GitHub user bonnetb opened a pull request:
https://github.com/apache/sqoop/pull/43
[SQOOP-3278]:Direct export to Netezza and encoding
Direct mode used an OutputStream writes to an export file using UTF-8. So,
if your targeted Netezza uses an ISO encoding, non ASCII chars will be
corrupted when Netezza loads the export file.
Using an OutputStreamWriter and relying on existing 'encoding' extended
parameter (SQOOP-2607) enables to set the encoding that will be used to write
the export file.
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/bonnetb/sqoop SQOOP-3278
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/sqoop/pull/43.patch
To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:
This closes #43
----
commit bb960e587d9d57fdbba3c96b5c1a467166f95016
Author: Benjamin BONNET <benjamin.bonnet@...>
Date: 2018-01-17T09:10:30Z
SQOOP-3278:use writer instead of stream and set encoding
commit e65d324d001d538c2f9bdf946aa7865e879f4222
Author: Benjamin BONNET <benjamin.bonnet@...>
Date: 2018-01-17T09:11:19Z
remove useless imports
----
> Direct export to Netezza and encoding
> -------------------------------------
>
> Key: SQOOP-3278
> URL: https://issues.apache.org/jira/browse/SQOOP-3278
> Project: Sqoop
> Issue Type: Bug
> Components: connectors
> Affects Versions: 1.4.6
> Environment: HDP 2.6
> Reporter: Benjamin BONNET
> Assignee: Benjamin BONNET
> Priority: Major
>
> Hi,
> I encountered an encoding issue while exporting from Hive to a Netezza table
> containing ISO-8859-15 encoded VARCHAR. Using direct mode, non ASCII chars
> are corrupted. That does not occur using non-direct mode.
> This bug is quite similar to
> [https://issues.apache.org/jira/projects/SQOOP/issues/SQOOP-2607] , excepted
> it concerns export (and not import).
> Regards
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
