Apache Accumulo. I think it might be possible to setup a Hive metastore and run it though that - but we don't have any Hive instances setup and I'm just trying things out with current infrastructure. Somebody else already setup Accumulo+Presto.
I found a couple of inquiries regarding Accumulo plugin for Drill in the list archive, but there doesn't seem to be a suitable option yet. Working off HBase plugin could eventually be a route but I don't have the manpower or expertise at the moment to go down that road. Thanks, Rafael On Wed, Apr 1, 2020, 1:17 PM Charles Givre <[email protected]> wrote: > Hi Rafael, > What connector are you interested in specifically? > Thanks, > -- C > > > > On Apr 1, 2020, at 12:45 PM, Jaimes, Rafael - 0993 - MITLL < > [email protected]> wrote: > > > > As a proof of concept, I thought it might be interesting to see if Drill > could query Presto as if it were a RDBMS. > > In theory, I thought it would work because it uses a JDBC driver. I > plopped it into 3rdparty and setup the config (see bottom) and it saves > without error. However it doesn’t show up in ‘show schemas;’ All attempts > at querying it or showing tables fail. > > Anyone else crazy enough to attempt this? > > If you were wondering, I am interested in a connector that Presto has > that Drill doesn’t, but Drill has better support for other things so I’d > like to keep it on top. > > > > { > > "type": "jdbc", > > "driver": "io.prestosql.jdbc.PrestoDriver", > > "url": "jdbc:presto://presto-url:9999/catalog/schema > <presto://presto-url:9999/catalog/schema>", > > "username": "user", > > "password": null, > > "caseInsensitiveTableNames": false, > > "sourceParameters": {}, > > "enabled": true > > } > >
