A UDF is just code, so you are going to make it do pretty much anything you want.
What is advisable is different than what is capable. A function that requires a database to work is a tough one though. You would have to bake in special functionality or hard code to find the configuration to connect to your database. On Wed, Jul 1, 2015 at 2:15 PM, Alok Tanna <[email protected]> wrote: > I am trying to look further into UDF, write more complex UDF using which we > call out a JDBC source in UDF . > > Thanks, > Alok Tanna > > --- > > On Wed, Jul 1, 2015 at 11:30 AM, Jim Scott <[email protected]> wrote: > > > I am curious to understand the reason you want a UDF to call out to a > JDBC > > source. > > > > You can call a JDBC source directly from within Drill which makes it so > > that you can query a JDBC source and join it to other sources just like > the > > DFS. > > > > > > On Wed, Jul 1, 2015 at 9:58 AM, Alok Tanna <[email protected]> > > wrote: > > > > > Ted\ Vince, > > > Can you help me with below quick question related to UDF . > > > 1. Can I call a jdbc from within a UDF ? > > > 2. Can we have JDBC UDF work with embedded Drill Install without > cluster > > > mode & zookeeper . > > > referring to > > > > > > > > > https://github.com/vicenteg/DrillJDBCExample/blob/master/src/main/java/com/mapr/drill/DrillJDBCExample.java > > > > > > Thanks, > > > Alok Tanna > > > > > > > > > On Mon, Jun 29, 2015 at 6:00 PM, Ted Dunning <[email protected]> > > > wrote: > > > > > > > Thanks. Very interesting input. > > > > > > > > On Mon, Jun 29, 2015 at 2:09 PM, Alok Tanna <[email protected] > > > > > > wrote: > > > > > > > > > Maven 3.3.3 -- Latest version , it worked with 3.0.5 > > > > > > > > > > On Mon, Jun 29, 2015 at 4:23 PM, Ted Dunning < > [email protected]> > > > > > wrote: > > > > > > > > > > > On Mon, Jun 29, 2015 at 1:03 PM, Alok Tanna < > > [email protected] > > > > > > > > > > wrote: > > > > > > > > > > > > > I was using latest version of Maven , guess that > > > > > > > was the issue. > > > > > > > > > > > > > > > > > > > What was the version? > > > > > > > > > > > > > > > > > >
