You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@sqoop.apache.org by "Arun Chowdary (JIRA)" <ji...@apache.org> on 2015/12/17 16:24:46 UTC

[jira] [Created] (SQOOP-2749) xmltype not working in Sqoop

Arun Chowdary created SQOOP-2749:
------------------------------------

             Summary: 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


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)