I want to have a function that returns the hour information from a date string (wiz not a known format supported by current date functions, but basically this is just a use case example). In pig, you can create a UDF (user defined function) and apply it to a column. Is there an equivalent thing in Hive? I know I can write a mapper to take whole line and transform the specific column I want. But it's not convenient because you have to duplicate the same code for each different source table.
Thanks!
