[
https://issues.apache.org/jira/browse/OPENJPA-2498?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Rick Curtis closed OPENJPA-2498.
--------------------------------
Resolution: Invalid
This JIRA is for OpenJPA, not Sqoop. Please open a JIRA against
https://issues.apache.org/jira/browse/SQOOP
> sqoop import, --hive-delims-replacement option not work
> -------------------------------------------------------
>
> Key: OPENJPA-2498
> URL: https://issues.apache.org/jira/browse/OPENJPA-2498
> Project: OpenJPA
> Issue Type: Bug
> Reporter: jackielihf
>
> I am using sqoop to import data from oracle into Hive. Oracle database's
> rows contain string fields that have delimiters '\r\n'.
> sqoop script:
> import --connect jdbc:oracle:thin:@127.0.0.1:1521:riskdb --username
> CENTER_READ --password center_read --table BIGDATA_ADMIN.TXT_NWS_BAS
> --target-dir /user/admin/sqoop/sqoop-gfinfo-oracle-txt_nws_bas --incremental
> append --check-column id --last-value 1 --hive-import --hive-table
> gfinfodb.txt_nws_bas
> --hive-delims-replacement "####" -m 1
> But the delimeters cannot be replaced by '####', and the string fields are
> parsed into several records respectively.
> Am i using it correctly?
> thks very much.
--
This message was sent by Atlassian JIRA
(v6.2#6252)
