If the general idea of what you are trying to accomplish with this function is not private, it might be useful to ask about your use case more generally. Although we are still working to integrate the JDBC plugin into the Drill mainline and it still requires a thorough testing cycle, this might be able to help you with your use case.
On Wed, Jul 1, 2015 at 3:14 PM, Jim Scott <[email protected]> wrote: > 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? > > > > > > > > > > > > > > > > > > > > > > >
