UDF Manage

Resource Management

• The resource management and file management functions are similar. The difference is that the resource management is the UDF upload function, and the file management uploads the user programs, scripts and configuration files.
• It mainly includes the following operations: rename, download, delete, etc.
• Upload UDF resources: Same as uploading files.

Function Management

Create UDF function

Click Create UDF Function, enter the UDF function parameters, select the UDF resource, and click Submit to create the UDF function. Currently only temporary UDF functions for HIVE are supported.

• UDF function name: Enter the name of the UDF function.
• Package name Class name: Enter the full path of the UDF function.
• UDF resource: Set the resource file corresponding to the created UDF function.

Example

Write UDF functions

Users can customize the desired UDF function according to actual production requirements. Here's a function that appends "HelloWorld" to the end of any string. As shown below:

Configure the UDF function

Before configuring UDF functions, you need to upload the required function jar package through resource management. Then enter the function management and configure the relevant information. As shown below:

Use UDF functions

In the process of using UDF functions, users only need to pay attention to the specific function writing, and upload the configuration through the resource center. The system will automatically configure the create function statement, refer to the following: SqlTask

Enter the workflow to define an SQL node, the data source type is HIVE, and the data source instance type is HIVE/IMPALA.

• SQL statement: select HwUdf("abc"); This function is used in the same way as the built-in functions, and can be accessed directly using the function name.
• UDF function: Select the one configured for the resource center.