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

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

Passing arrays to custom functions as parrameters
answered 08-10-2018 21:02:20 -0400

Hi, I was trying to acheive a function with signature as, public Double actualPremiumOrAcqExpOrNonDirExpCalcYearly(Double[] val1, Integer val2, Double val3) But I am not getting any luck to acheive this. Is it possible to pass a combination of parame...

Answers: 3

VDP java code DENODO Custom Functions

Developing Custom Functions
answered 24-07-2018 13:10:48 -0400

Hi, I'm using Denodo Platform 6.0 and I have a specific requirement. I wanted to develop a custom to-date function that calls Denodo's to-date when it's not delegated and calls the underlying to-date of Hive when it's supposed to be delegated. I foll...

Answers: 1

TO_DATE Custom Functions

Pass and access arrays in VDP function
answered 29-05-2018 07:56:33 -0400

Hi, i am sorry to repeat thhis question, but with a slight modification. 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...

Answers: 1

Denodo VDP API users Custom Functions

Custom Function Class Name
answered 05-03-2018 10:11:18 -0500

We need to built Custom function to get AWS Authorization Request Header . Before implementing custom function thought of check how the custom function need to be configured in denodo I have created Jar file out of Concat_SampleVdpFunction.java . I wa...

Answers: 1

Custom Functions

Custom Function - How To call from VDP
answered 17-01-2018 12:02:23 -0500

HI, I have denodo 6.0 with custom function public class ASB_VdpFunction { @CustomExecutor(syntax = "normsdist(double x): double") public double normsdist( Double x ) { return 0.01;} } I compile and generate jar and load using Jar Management. When I t...

Answers: 1

Custom Functions