You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@sqoop.apache.org by "Benjamin MENUET (JIRA)" <ji...@apache.org> on 2016/01/12 11:39:39 UTC
[jira] [Commented] (SQOOP-2749) xmltype not working in Sqoop
[ 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)