[SQOOP-1904] support for DB2 XML data type when importing to hdfs

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.4.5
• Fix Version/s: 1.4.7
• Component/s: connectors
• Labels: features

Environment

RedHat6.4 + Sqoop1.4.5 + Hadoop 2.4.1 + Hive 0.14.0 + DB2 10.5

• Assignee: Ying Cao
• Reporter: xieshiju
• Created: 15/Dec/14 03:01
• Updated: 26/Feb/18 14:20
• Resolved: 24/Feb/17 08:47

Description

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

Issue Links

• relates to: SQOOP-3173 support DB2 xml data type when sqoop import with parquet
• relates to: SQOOP-3131 Docuemtn support for DB2 XML data type when importing to hdfs
• links to: ReviewBoard