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?
better to contact the moderator for this query,. you would definitly be resolved with this situation here..
You need a SQL-MR with Multiple Inputs. See the Aster_Analytics_Foundation_Guide_<your version>.pdf for detailed instructions.