Using functions

You can call a built-in Hive function to execute one of a wide-range of operations instead of performing multiple steps. You use SHOW FUNCTIONS to search for or list available functions. You can create a user-defined function (UDF) when a built-in is not available to do what you need. You might need to reload functions to update the availability of functions created in another session.