title: UDF Table Structure sidebar_position: 2

1. linkis_ps_udf_baseinfo

The basic information table of udf function, which stores basic information such as udf name/type

numbernamedescriptiontypekeyemptyextradefault value
1idprimary key auto-increment idbigint(20)PRINOauto_increment
2create_usercreate uservarchar(50)NO
3udf_nameudf namevarchar(255)NO
4udf_typeudf typeint(11)YES0
5tree_idid of linkis_ps_udf_treebigint(20)NO
6create_timecreation timetimestampNOon update CURRENT_TIMESTAMPCURRENT_TIMESTAMP
7update_timeupdate timetimestampNOCURRENT_TIMESTAMP
8syssource systemvarchar(255)NOide
9cluster_nameCluster name, not used yet, default is allvarchar(255)NO
10is_expireExpired or notbit(1)YES
11is_sharedIs it sharedbit(1)YES

udf_type

udf_type 0: udf function - generic
udf_type 2: udf function - spark

udf_type 3: custom function - python function
udf_type 4: custom function - scala function

2. linkis_ps_udf_manager

The administrator user table of the udf function, with sharing permissions, only the front end of the udf administrator has a shared entry

numbernamedescriptiontypekeyemptyextradefault value
1idbigint(20)PRINOauto_increment
2user_namevarchar(20)YES

3. linkis_ps_udf_shared_info

udf shared record table

numbernamedescriptiontypekeyemptyextradefault value
1idbigint(20)PRINOauto_increment
2udf_idid of linkis_ps_udf_baseinfobigint(20)NO
3user_nameusername used by the sharevarchar(50)NO

4. linkis_ps_udf_tree

Tree-level record table for udf classification

numbernamedescriptiontypekeyemptyextradefault value
1idbigint(20)PRINOauto_increment
2parentparent categorybigint(20)NO
3nameClass name of the functionvarchar(100)YES
4user_nameusernamevarchar(50)NO
5descriptiondescription informationvarchar(255)YES
6create_timetimestampNOon update CURRENT_TIMESTAMPCURRENT_TIMESTAMP
7update_timetimestampNOCURRENT_TIMESTAMP
8categorycategory distinction udf / functionvarchar(50)YES

5. linkis_ps_udf_user_load

Whether udf is the configuration loaded by default

numbernamedescriptiontypekeyemptyextradefault value
1idbigint(20)PRINOauto_increment
2udf_idid of linkis_ps_udf_baseinfoint(11)NO
3user_nameuser ownedvarchar(50)NO

6. linkis_ps_udf_version

udf version information table

numbernamedescriptiontypekeyemptyextradefault value
1idbigint(20)PRINOauto_increment
2udf_idid of linkis_ps_udf_baseinfobigint(20)NO
3pathThe local path of the uploaded script/jar packagevarchar(255)NO
4bml_resource_idMaterial resource id in bmlvarchar(50)NO
5bml_resource_versionbml material versionvarchar(20)NO
6is_publishedwhether to publishbit(1)YES
7register_formatregistration formatvarchar(255)YES
8use_formatuse formatvarchar(255)YES
9descriptionVersion descriptionvarchar(255)NO
10create_timetimestampNOon update CURRENT_TIMESTAMPCURRENT_TIMESTAMP
11md5varchar(100)YES

ER diagram

image