[
https://issues.apache.org/jira/browse/SQOOP-2749?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15093708#comment-15093708
]
Benjamin MENUET commented on SQOOP-2749:
----------------------------------------
Hi,
I have encountred a similar issue.
To fix this, I have converted the Xml format to clob in the Oracle query then I
have mapped the reccord in String using Java map.
Here is an example of my command :
sqoop import --connect <connection> --username <user> --password <password>
--query "select t.XMLRECORD.getclobval() XMLRECORD from <TABLE> t where
\$CONDITIONS" --target-dir <dir> --map-column-java "XMLRECORD=String"
Regards,
Benjamin.
> xmltype not working in Sqoop
> ----------------------------
>
> Key: SQOOP-2749
> URL: https://issues.apache.org/jira/browse/SQOOP-2749
> Project: Sqoop
> Issue Type: Test
> Reporter: Arun Chowdary
> Original Estimate: 12h
> Remaining Estimate: 12h
>
> Hi,
> I'm trying to import a column from oracle which consists of xml files, of
> datatype HUGECLOB using Sqoop. However I'm receiving an error "Cannot resolve
> SQL Type 1009". Below is the sqoop command used.
> sqoop import --jdbc connection --username --password --query "select
> xmltype(xmlfilecolumn) from table where $CONDITIONS" --target dir
> Appreciate your help!
> Regards
> Arun
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
