[SQOOP-3449] Support for DB2 DECFLOAT data type when importing to HDFS/Hive

• Type: Improvement
• Status: Patch Available
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 1.4.7
• Component/s: connectors
• Assignee: Chiran Ravani
• Reporter: Chiran Ravani
• Created: 06/Sep/19 09:15
• Updated: 22/Jan/20 14:32

Description

The DB2 connector should add DECFLOAT data type support otherwise you will get an error that Hive does not support the SQL type.
Example with column DESCRIPTION data type DECFLOAT:
$SQOOP_HOME/bin/sqoop import --connect 'jdbc:db2://xxx.svl.ibm.com:60000/testdb1' --username db2inst1 --password db2inst1 --hive-table product_ct --table dexfloattest

Issue Links

• links to: GitHub Pull Request #84