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?