Regarding what you call “JDBC storage plugin”. I’d call it a JDBC adapter. Calcite has a JDBC adapter that tries to push down as much of the algebra tree to a foreign database (this depends upon what the database is capable of), then generates database-specific SQL for the tree that it had managed to push.
Drill’s requirements are exactly the same so it seems crazy to not start with Calcite’s adapter. Julian On Mar 6, 2015, at 10:05 AM, Norris Lee <norr...@simba.com> wrote: > Close but not quite. Alex and I are actually working on an ODBC driver. An > open source JDBC driver already exists and is in active development. > > As for a JDBC storage plugin to source data from other JDBC drivers (eg. Of > RDBMSes), it's been requested several times recently but I don't think anyone > is working on it. If I recall correctly, some people expressed interest in > working on it. > > Norris > > -----Original Message----- > From: Yash Sharma [mailto:yash...@gmail.com] > Sent: Friday, March 06, 2015 6:51 AM > To: u...@drill.apache.org > Subject: Re: JDBC data source > > Drill currently doesn't have a jdbc storage plugin. However it has come up in > discussions couple of times. As discussed in last hangout Norris and > Alexander are working on it and we can expect a patch soon. > > -Via mobile. Excuse brevity. > On 6 Mar 2015 8:06 pm, "Chevalier Julien" <j...@numerigraphe.com> wrote: > >> Yash, what you pointed out is a way to produce Drill output through a JDBC. >> I want Drill to consume data from JDBC. >> As Carol clearly explains what I need is a JDBC Storage Plugin. >> >> Precisely are they any JDBC Storage plugin available ? >> >> Best regards. >> >> Juju >> >>> Le 6 mars 2015 à 15:18, Yash Sharma <yash...@gmail.com> a écrit : >>> >>> Hi Juju, check if this can help: >>> >>> >> https://cwiki.apache.org/confluence/display/DRILL/Using+JDBC+to+Access >> +Apache+Drill+from+SQuirreL >>> >>> Regards >>> >>> >>> >>> On Fri, Mar 6, 2015 at 7:13 PM, Chevalier Julien >>> <j...@numerigraphe.com> >>> wrote: >>> >>>> Dear List >>>> >>>> I Wonder if Drill can read data from a RDBMS through a good old >>>> JDBC >> driver >>>> >>>> Examples are welcome. >>>> >>>> Best regards >>>> >>>> Juju >>>> >>>> >> >>
