Support Questions
Find answers, ask questions, and share your expertise

Permanently store sqoop --map-column-hive mapping for DB2

Explorer

Hello,

I am importing several DB2 database tables with an Oozie workflow that uses Sqoop to import to Hive. Currently I have to map each column with an unsupported data type manually with "--map-column-hive".

Is there any way to permanently store mappings for specific data types? I am importing several tables that contain DB2-"Character" columns which all have to be mapped to HIVE-"STRING" manually.
For ~50 tables there are ~200 columns that use the datatype "Character" for FKs which have to be mapped manually.
I want to permanently save that DB2-"Character" is mapped to the datatype HIVE-"STRING".
Can this be done?

 

regards

 

0 REPLIES 0