openjpa-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "jackielihf (JIRA)" <j...@apache.org>
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
                 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)

Mime
View raw message