Starrocks自定义函数(实战篇)

自定义全局函数

CREATE GLOBAL FUNCTION _function_name(string) 
RETURNS string
PROPERTIES (
    "symbol" = "com.xx.xx", 
    "type" = "StarrocksJar",
    "file" = "http://xx:8889/udf/xx-udf-1.0-SNAPSHOT-jar-with-dependencies.jar"
);
SHOW GLOBAL FUNCTIONS\G
DROP GLOBAL FUNCTION _function_name(string);

自定义数据库内函数

use dbname;
CREATE FUNCTION _function_name(string) 
RETURNS string
PROPERTIES (
    "symbol" = "com.xx.xx", 
    "type" = "StarrocksJar",
    "file" = "http://xx:8889/udf/xx-udf-1.0-SNAPSHOT-jar-with-dependencies.jar"
);
show full functions in dbname\G
DROP FUNCTION _function_name(string);