MaxCompute is currently the major workspace of DataWorks, so the work objects are mostly ODPS_SQL scripts and tasks. When editing the codes for ODPS_SQL scripts and tasks, you often need to use various functions to standardize the data.
Function Management, a feature provided by DataWorks, is used to manage the built-in and user-defined functions that are required to edit MaxCompute SQL. You can search, create directories, refresh, and create functions on the Function Management page.
Therefore, all the functions, whether built-in or user-defined, displayed under the Function Management module are only used for ODPS_SQL tasks and scripts.
The following built-in functions are provided by default. You can choose the most appropriate functions to realize your business demands.
If the built-in functions are not adequate for you, you can create user-defined functions (UDF). For the detailed procedures, see Create a UDF.
Double-click the function name to view the function type, command format, and parameter description.
Double-click to open a code editing task or script. Right-click the required function in the left-side directory tree and select Reference. The function name appears in the code editing area.
Note: Only user-defined functions can be deleted.
Locate the function that you want to delete on the Function Management page. Right-click and select Delete from the menu to delete the function.
On the Function Management page, follow these steps.
Search: Enter any function keyword to search for built-in and user-defined functions in the current project workspace.
Create directories: Enter a directory name to create a directory under Function Management.
Refresh: Refresh the current Function Management directory.
Create functions: Create MaxCompute functions.