Today, I will discuss about the masking the details of the customer. It may be mobile number, Bank Account Number,Security PIN,customer_ID etc.
For this, we can use combination of substring and regexp_replace function in hive.
For example, you want to mask the first 5 digit of a mobile number like 1234567890 as #####67890, then use the below query.
select concat(regexp_replace(substring(‘1234567890′,1,5),'[0-9]’,’#’),substring(‘1234567890’,6,5));
You can use mask_show_last_n function but here concern is, it will replace number by “n”. See the below Query :
select mask_show_last_n(‘1234567890’,5) ; Result is nnnnn67890