I'm using Hive to query data that I have. The problem is, this data needs to be cleaned and it's way too big for me to try and process it on my computer (hence using Hadoop and Hive). Is there a way for me to do this with Hive? I looked into user defined functions but my understanding is that they operate row by row so might not be an optimal way to clean the data. 

Thanks