openjpa-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "jackielihf (JIRA)" <>
Subject [jira] [Created] (OPENJPA-2498) sqoop import, --hive-delims-replacement option not work
Date Tue, 06 May 2014 08:56:16 GMT
jackielihf created OPENJPA-2498:

             Summary: sqoop import, --hive-delims-replacement option not work
                 Key: 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:@ --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

View raw message