【已解决】执行调用自定义函数报错

Viewed 40

执行调用自定义函数报错

select
    TO_CHAR('1.1','fm9999999990.0')

image.png

create GLOBAL FUNCTION to_char(text, text) RETURNS text PROPERTIES (
  "SYMBOL"="org.apache.doris.udf.TO_CHAR",
  "FILE"="file:/hip/doris/be/lib/java-udf-demo.jar",
  "ALWAYS_NULLABLE"="true",
  "TYPE"="JAVA_UDF"
);

三台BE节点/hip/doris/be/lib/java-udf-demo.jar都有了

2 Answers

使用http方式

file:///hip/doris/be/lib/java-udf-demo.jar