Q&A BY TAG 'Custom Functions'

You must sign in to ask a question. If you do not have an account, you can register here

Custom functions jar file renaming and name conflicts
answered 09-06-2021 18:20:55 -0400

Hello, When we started developing custom functions in Denodo, we had stored them all in a single package. However, we have now reached about 200 custom functions and in order to simplify maintenance, we would like to split that package in 3 (Date func...

Answers: 3

Denodo 8.0 extension Custom Functions

Denodo doesn't recognize local file within stored procedure
answered 07-06-2021 05:08:11 -0400

I have denodo platform 8.0 running on EC2 installed using cloudformation template as per the installation guide by Denodo. I am trying to create a custom stored proc which has to read a license file (locally saved inside /opt/denodo/denodo-platform8.0/...

Answers: 4

Logging Custom stored procedure ERROR_HANDLING Custom Functions License File Denodo Jar

Error while using custom function
answered 28-04-2021 00:31:32 -0400

Hi Team, I developed a custom function when I am using it I wm getting error com.denodo.vdb.admin.model.vdbserverproxy.VDBServerProxyException: error computing capabilities: Function 'psi_hashicorp_decrypt' is not executable. Can you please let me kno...

Answers: 3

Custom Functions

Error while using custom function. com.denodo.vdb.admin.model.vdbserverproxy.VDBServerProxyException: error computing capabilities: Function ‘psi_hashicorp_decrypt’ is not executable
answered 16-04-2021 08:36:36 -0400

Thank you for the answering my previous question on custom funtion for the error com.denodo.vdb.admin.model.vdbserverproxy.VDBServerProxyException: error computing capabilities: Function ‘psi_hashicorp_decrypt’ is not executable. I didn’t find any synt...

Answers: 1

Custom Functions

Error Handling with Custom Functions
answered 23-09-2020 08:46:44 -0400

Is there a mechanism by which a custom function can report an error? It appears that exceptions thrown are swallowed and it is treated as though the function returns null.

Answers: 6

Function ERROR_HANDLING Custom Functions Error Handling

Returning an existing compound type from executeReturnType
answered 29-06-2020 09:43:17 -0400

I have a bunch of complex compound types defined via CREATE TYPE syntax. Can I use them as a custom function return type, that is, return this type from executeReturnType()? E.g. something like this: @CustomExecutorReturnType public CustomRecordTy...

Answers: 1

Custom Functions Compound Types

how can I call a custom function created in Oracle DB from denodo
answered 31-12-2019 15:57:53 -0500

Hi , i have created a Pl/SQL function in underlying oracle database which set the context based on passed input user parameter. i want to call this function from denodo VQL. i imported this function in denodo by creating base view on it and then trie...

Answers: 1

Function Custom Functions

Calling Simple API from Custom function/Procedure
answered 30-08-2019 08:39:24 -0400

Hi Team, We have a customer requirement to call the encrption/decrytion activity which will be via simple API from denodo layer.Could you please help /support us how to create custom function/procedure in Java to call simple API from Denodo Thanks Balu S

Answers: 3

Custom Functions

Logger for Custom Function
answered 19-03-2019 05:51:18 -0400

Custom Policies has a context object available which can log into Denodo server logs. On similar lines, do we have any object available for Custom Function which can log into Denodo server logs?

Answers: 4

log Custom Functions

passing arrays to VDP function
answered 09-10-2018 11:35:46 -0400

Hi, I have wrote a custome function (VDP function through annotation methodology ) and I would like to pass an array of double values to the function. But when I import the extension to administration tool and try to use it in the query it says, Fini...

Answers: 3

VDP DENODO Custom Functions