Hi Saurabh, I'd like to use Drill because in my use case I have multiple sources (HDFS, HBase, Phoenix, Oracle, Mysql) and I'd like to allow the user to see the data. Without writing a plugin for each storage system I'd like to leverage Apache Drill as a broker towards all of them.
Right now I've tried to puth the phoenix-core.jar into the jar/3rdparty folder but when I try to create the Phoenix storage I get the following error: Please retry: error (unable to create/ update storage) I'm trying to debug but I don't see anything wrong.. On Fri, Feb 2, 2018 at 1:42 AM, Saurabh Mahapatra < [email protected]> wrote: > Hi Flavio, > > I was curious what your use case is. Phoenix provides SQL access with > secondary indexes on HBase. Why would you want to use Drill? > > Thanks, > Saurabh > > On Thu, Feb 1, 2018 at 3:08 PM, Kunal Khatua <[email protected]> wrote: > > > The JDBC storage plugin allows Drill to leverage any SQL system that has > > JDBC drivers, so it should work. > > > > That said, the JDBC storage plugin is a community developed storage > > plugin, so it might not be fully tested. > > > > If you are looking to simply have the Phoenix JDBC driver bundled into > the > > Drill 3rd party directory, I (think) the reason it is not bundled is > > because we're not actively tracking compatibility of different JDBC > drivers > > with Drill. There could also be license issues, which is why we can't > > bundle drivers for platforms like Oracle, etc. > > > > ~ Kunal > > > > -----Original Message----- > > From: Flavio Pompermaier [mailto:[email protected]] > > Sent: Thursday, February 01, 2018 9:39 AM > > To: [email protected] > > Subject: Apache Phoenix integration > > > > Hi all, > > looking at https://urldefense.proofpoint.com/v2/url?u=https-3A__drill. > > apache.org_docs_apache-2Ddrill-2Dcontribution-2Dideas_&d=DwIBaQ&c= > > cskdkSMqhcnjZxdQVpwTXg&r=-cT6otg6lpT_XkmYy7yg3A&m=daBPP_ > > PaenGs721v8erkPwwO543kYzW-gKUv-c1jVWM&s=KMq_T0hogIOIv_ > > ttrCLCxBeEt-AUKKxpcQt3PpeNSbs&e= > > it seems that Apache Phoenix is not integrated with Drill right now. In > > theory the integration should be quite straightforward using the JDBC > > Phoenix connector, isn't it? > > Right now there are just a few problem of class loading when putting the > > phoenix jar into jars/3rdparty but it shouldn't be too hard to shade > > conflicting classes away. > > > > Has anyone attempted to connect to to Apache before? > > > > Best, > > Flavio > > > -- Flavio Pompermaier Development Department OKKAM S.r.l. Tel. +(39) 0461 041809
