Create a function with ADE which query an other table

Aster
N/A

Create a function with ADE which query an other table

Hi everyone,

I want to create a function with ADE. This is a PARTITION BY function, of course the function takes as input some rows of a table. 

I want to know what is the best solution if, inside the function, I want to query an other table. Let's say that my function acts on user table and for formulating the output rows I need to query the product table.

Should I use the JDBC connector or there is an other solution?

Thanks!

2 REPLIES

Re: Create a function with ADE which query an other table

better to contact the moderator for this query,. you would definitly be resolved with this situation here..

Re: Create a function with ADE which query an other table

You need a SQL-MR with Multiple Inputs. See the Aster_Analytics_Foundation_Guide_<your version>.pdf for detailed instructions.