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.
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:
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:
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.
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.