I have created a couple of UDF in Hive and when I was deploying the jar i didn't write that the functions are temporary, so when they were created they remained permanently which is what I want, now I want to use these functions to write a stored procedure in HPL/SQL but when I try to use the function that I created I get an error while it's not the case en I use the built in UDF of Hive.
Can anyone tell me what I'm doing wrong ?