This is a classic transform-load problem. You'll want to anonymise it once before making it available for analysis.
On Thursday, March 17, 2016, Ajay Chander <hadoopde...@gmail.com> wrote: > Hi Everyone, > > I have a csv.file which has some sensitive data in a particular column > in it. Now I have to create a table in hive and load the data into it. But > when loading the data I have to make sure that the data is masked. Is there > any built in function is used ch supports this or do I have to write UDF ? > Any suggestions are appreciated. Thanks -- Want to work at Handy? Check out our culture deck and open roles <http://www.handy.com/careers> Latest news <http://www.handy.com/press> at Handy Handy just raised $50m <http://venturebeat.com/2015/11/02/on-demand-home-service-handy-raises-50m-in-round-led-by-fidelity/> led by Fidelity