[ https://issues.apache.org/jira/browse/SQOOP-1904?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16372725#comment-16372725 ]
Szabolcs Vasas commented on SQOOP-1904: --------------------------------------- Hi [~rush27], This improvement was released in Sqoop 1.4.7, what is the version you tried? Szabolcs > support for DB2 XML data type when importing to hdfs > ---------------------------------------------------- > > Key: SQOOP-1904 > URL: https://issues.apache.org/jira/browse/SQOOP-1904 > Project: Sqoop > Issue Type: Improvement > Components: connectors > Affects Versions: 1.4.5 > Environment: RedHat6.4 + Sqoop1.4.5 + Hadoop 2.4.1 + Hive 0.14.0 + > DB2 10.5 > Reporter: xieshiju > Assignee: Ying Cao > Priority: Major > Labels: features > Fix For: 1.4.7 > > Attachments: SQOOP-1904.2.patch, SQOOP-1904.3.patch, > SQOOP-1904.4.patch, SQOOP-1904.5.patch, SQOOP-1904.6.patch, > SQOOP-1904.7.patch, SQOOP-1904.patch > > Original Estimate: 504h > Remaining Estimate: 504h > > The DB2 connector should add XML data type support otherwise you will get an > error that Hive does not support the SQL type. > Example with column DESCRIPTION data type XML: > $SQOOP_HOME/bin/sqoop create-hive-table --connect > 'jdbc:db2://xxx.svl.ibm.com:60000/SAMPLE' --username db2inst1 --password > db2inst1 --hive-table product_ct --table PRODUCT -- This message was sent by Atlassian JIRA (v7.6.3#76005)