UDF Table Structure
1. linkis_ps_udf_baseinfo
The basic information table of udf function, which stores basic information such as udf name/type
number | name | description | type | key | empty | extra | default value |
---|---|---|---|---|---|---|---|
1 | id | primary key auto-increment id | bigint(20) | PRI | NO | auto_increment | |
2 | create_user | create user | varchar(50) | NO | |||
3 | udf_name | udf name | varchar(255) | NO | |||
4 | udf_type | udf type | int(11) | YES | 0 | ||
5 | tree_id | id of linkis_ps_udf_tree | bigint(20) | NO | |||
6 | create_time | creation time | timestamp | NO | on update CURRENT_TIMESTAMP | CURRENT_TIMESTAMP | |
7 | update_time | update time | timestamp | NO | CURRENT_TIMESTAMP | ||
8 | sys | source system | varchar(255) | NO | ide | ||
9 | cluster_name | Cluster name, not used yet, default is all | varchar(255) | NO | |||
10 | is_expire | Expired or not | bit(1) | YES | |||
11 | is_shared | Is it shared | bit(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
number | name | description | type | key | empty | extra | default value |
---|---|---|---|---|---|---|---|
1 | id | bigint(20) | PRI | NO | auto_increment | ||
2 | user_name | varchar(20) | YES |
3. linkis_ps_udf_shared_info
udf shared record table
number | name | description | type | key | empty | extra | default value |
---|---|---|---|---|---|---|---|
1 | id | bigint(20) | PRI | NO | auto_increment | ||
2 | udf_id | id of linkis_ps_udf_baseinfo | bigint(20) | NO | |||
3 | user_name | username used by the share | varchar(50) | NO |
4. linkis_ps_udf_tree
Tree-level record table for udf classification
number | name | description | type | key | empty | extra | default value |
---|---|---|---|---|---|---|---|
1 | id | bigint(20) | PRI | NO | auto_increment | ||
2 | parent | parent category | bigint(20) | NO | |||
3 | name | Class name of the function | varchar(100) | YES | |||
4 | user_name | username | varchar(50) | NO | |||
5 | description | description information | varchar(255) | YES | |||
6 | create_time | timestamp | NO | on update CURRENT_TIMESTAMP | CURRENT_TIMESTAMP | ||
7 | update_time | timestamp | NO | CURRENT_TIMESTAMP | |||
8 | category | category distinction udf / function | varchar(50) | YES |
5. linkis_ps_udf_user_load
Whether udf is the configuration loaded by default
number | name | description | type | key | empty | extra | default value |
---|---|---|---|---|---|---|---|
1 | id | bigint(20) | PRI | NO | auto_increment | ||
2 | udf_id | id of linkis_ps_udf_baseinfo | int(11) | NO | |||
3 | user_name | user owned | varchar(50) | NO |
6. linkis_ps_udf_version
udf version information table
number | name | description | type | key | empty | extra | default value |
---|---|---|---|---|---|---|---|
1 | id | bigint(20) | PRI | NO | auto_increment | ||
2 | udf_id | id of linkis_ps_udf_baseinfo | bigint(20) | NO | |||
3 | path | The local path of the uploaded script/jar package | varchar(255) | NO | |||
4 | bml_resource_id | Material resource id in bml | varchar(50) | NO | |||
5 | bml_resource_version | bml material version | varchar(20) | NO | |||
6 | is_published | whether to publish | bit(1) | YES | |||
7 | register_format | registration format | varchar(255) | YES | |||
8 | use_format | use format | varchar(255) | YES | |||
9 | description | Version description | varchar(255) | NO | |||
10 | create_time | timestamp | NO | on update CURRENT_TIMESTAMP | CURRENT_TIMESTAMP | ||
11 | md5 | varchar(100) | YES |