openjpa-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Rick Curtis (JIRA)" <j...@apache.org>
Subject [jira] [Closed] (OPENJPA-2498) sqoop import, --hive-delims-replacement option not work
Date Tue, 06 May 2014 12:06:14 GMT

     [ 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)

Mime
View raw message