[FLINK-29068] Release Testing: Verify FLIP-214 Create function using jar syntax

• Type: Sub-task
• Status: Closed
• Priority: Blocker
• Resolution: Resolved
• Affects Version/s: 1.16.0
• Fix Version/s: 1.16.0
• Component/s: Table SQL / API
• Labels: release-testing
• Assignee: Qingsheng Ren
• Reporter: dalongliu
• Created: 23/Aug/22 01:48
• Updated: 06/Sep/22 09:23
• Resolved: 06/Sep/22 09:23

Description

This issue aims to verify FLIP-214: https://cwiki.apache.org/confluence/display/FLINK/FLIP-214+Support+Advanced+Function+DDL

We can verify it in SQL client after we build the flink-dist package.

verify create function using jar syntax

1. Preparing a jar that contains the udf class implementation, the jar path should be a local or remote path such as hdfs/s3/oss.
2. Creating a catalog function/temporary catalog function/temporary system function using the jar provided jar path.
3. Using `show jars` to verify whether the function has been created successfully. 
4. Write a query which refer to the above udf, and then execute it. Verify the query execution and result correctness.

 

verify add jar syntax

We have ported the implementation of add jar/show jars from SQL client to TableEnvironment in FLIP-214, and the customed jar class load using user classloader instead of thread context classloader now, so we also should verify the add jar syntax.

1. Preparing a jar that contains the udf or catalog implementation, the jar path should be a local or remote path such as hdfs/s3/oss.
2. Using add jar syntax by the provided jar resource.
3. Creating a catalog(such as jdbc/hive) using the added jar and execute other ddls within the catalog
4. Creating a udf using the added jar and write a query referring to the udf, then submit it.