# UDF Function - Finding function **URL:** \ **Category:** Uncategorized\ **Created:** [October 17, 2024, 8:31am UTC](https://community.dremio.com/t/udf-function-finding-function/12420 "2024-10-17T08:31:44Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![permatsson](https://avatars.discourse-cdn.com/v4/letter/p/bc8723/32.png) [@permatsson](https://community.dremio.com/u/permatsson)\ **Post date:** [October 17, 2024, 8:31am UTC](https://community.dremio.com/t/udf-function-finding-function/12420/1 "2024-10-17T08:31:44Z")
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](https://us1.discourse-cdn.com/flex020/uploads/dremio/original/2X/7/79bcf4ae74ef698754680d95718348f1ccaddb59.png) 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:” ? ---
**Author:** ![permatsson](https://avatars.discourse-cdn.com/v4/letter/p/bc8723/32.png) [@permatsson](https://community.dremio.com/u/permatsson)\ **Post date:** [October 17, 2024, 8:34am UTC](https://community.dremio.com/t/udf-function-finding-function/12420/2 "2024-10-17T08:34:26Z")
![image](https://us1.discourse-cdn.com/flex020/uploads/dremio/original/2X/e/e87606d04279ddbaa5c915882c21141c4f902e49.png) One of the function i create. ---
**Author:** ![balaji.ramaswamy](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/balaji.ramaswamy/32/843_2.png) [@balaji.ramaswamy](https://community.dremio.com/u/balaji.ramaswamy)\ **Post date:** [October 19, 2024, 6:18am UTC](https://community.dremio.com/t/udf-function-finding-function/12420/3 "2024-10-19T06:18:29Z")
@permatsson Are you able to send profiles for the 3 jobs? ---
**Author:** ![permatsson](https://avatars.discourse-cdn.com/v4/letter/p/bc8723/32.png) [@permatsson](https://community.dremio.com/u/permatsson)\ **Post date:** [November 1, 2024, 7:28am UTC](https://community.dremio.com/t/udf-function-finding-function/12420/5 "2024-11-01T07:28:50Z")
[1.Hello - works.zip](https://community.dremio.com/uploads/short-url/cyq7qFNr9CH1pJ5lqj3qF97iM6F.zip) (13.4 KB) [2.Id - Works.zip](https://community.dremio.com/uploads/short-url/jJ5fhQv6TH8XgUeetmXwM3AVcRy.zip) (16.6 KB) [3.Hello and id - Not works.zip](https://community.dremio.com/uploads/short-url/wXwNqGascaHSlX8POX4D9yWloB3.zip) (12.3 KB) Here is the files. ---
**Author:** ![balaji.ramaswamy](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/balaji.ramaswamy/32/843_2.png) [@balaji.ramaswamy](https://community.dremio.com/u/balaji.ramaswamy)\ **Post date:** [November 7, 2024, 6:27am UTC](https://community.dremio.com/t/udf-function-finding-function/12420/6 "2024-11-07T06:27:15Z")
@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? ---
**Author:** ![permatsson](https://avatars.discourse-cdn.com/v4/letter/p/bc8723/32.png) [@permatsson](https://community.dremio.com/u/permatsson)\ **Post date:** [November 13, 2024, 7:32am UTC](https://community.dremio.com/t/udf-function-finding-function/12420/7 "2024-11-13T07:32:00Z")
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 ? ---
**Author:** ![balaji.ramaswamy](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/balaji.ramaswamy/32/843_2.png) [@balaji.ramaswamy](https://community.dremio.com/u/balaji.ramaswamy)\ **Post date:** [December 1, 2024, 7:32pm UTC](https://community.dremio.com/t/udf-function-finding-function/12420/8 "2024-12-01T19:32:53Z")
@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?