jackielihf created OPENJPA-2498:
-----------------------------------
Summary: 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)
