I am able to create user defined functions in Dremio 22.1.1 community, can confirm they are added to the sys.user_defined_functions table, and can see them in the results of SHOW FUNCTIONS. But when I try to use them in a query, I get an error. By way of example, I utilized one of the sample UDFs from the documentation:
CREATE FUNCTION hello() RETURNS VARCHAR RETURN SELECT 'Hello World!';
When I attempt to call it without a fully qualified path:
I get this error: “No match found for function signature hello()”
If I fully qualify it with the namespace:
I receive this error: ‘com.dremio.service.namespace.NamespaceNotFoundException: not found: “@workspace”.hello’
This same thing happens no matter what UDF I define. What am I missing?