I have a requirement where i need to sqoop data from SQL server to Hadoop hive tables. There are few columns which have masked data. While loading hive with data i would like to unmask it. Is there any way i can achieve this by writing UDF to unmask and load?
If sqoop command does not support using UDF what is the best approach i could use to load unmasked data into hive?
Thanks in advance.!