Every so often, we need to perform data transformation in ways too complicated for SQL (even with the Custom UDF’s provided by hive).