UDF Function - Finding function

1

I need help with 2 things that i cant understand/solve, it is problem with finding function (Dremio verision 24.1.0-202306130653310132-d30779f6, Community Edition)

image
image1210×85 4.23 KB

  1. Why does Dremio not find the function hello() when combined ?

I also want to build a function with a varchar in and convert to timestamp in right timezone out. But Dremio will not find the function, for some weeks ago it worked, but now i cant find the function when i want to use it. I cant understand what changed.

  1. How to solve “Failure finding function:” ?
2

image
image725×255 8.71 KB

One of the function i create.

3

@permatsson Are you able to send profiles for the 3 jobs?

5

1.Hello - works.zip (13.4 KB)
2.Id - Works.zip (16.6 KB)
3.Hello and id - Not works.zip (12.3 KB)

Here is the files.

6

@permatsson hello() is not a supported SQL function in Dremio and i expect that error, I am not able to open the profile #1, is that Select hello() as hello from "NGCIS-brnopowerco".Preparation."Product Components"."Product Components Flattened" and it works?

7

Hallo () function has i made as a test, and returns “Hello Word”, when i use that in a sql with a table as you se in my first post then it works. When i combine the function with another field in the table, it doesnt work (se my first post).

Any idea why ?

8

@permatsson Sorry for the delay,

Can you please send the code for function Hello so we can reproduce. Also can you disable reflection used and retry?