AWESOME Thanks! On Fri, Oct 9, 2015 at 11:30 AM, Andries Engelbrecht < [email protected]> wrote:
> To directly connect to a drillbit with ODBC or JDBC you can use port 31010 > > For ODBC specific direct connect to drillbit and the drillbit IP or > hostname with port 31010 > > For JDBC you can use the connection string, sqlline example > sqlline -u jdbc:drill:drillbit=<hostname or IP>:31010 > > No need to specify the Drill cluster ID if you don’t use ZK. > > —Andries > > > > On Oct 9, 2015, at 7:58 AM, John Omernik <[email protected]> wrote: > > > > I am doing a drill PoC that's frankly a bit of a pain in the butt. > > Basically, to get to my cluster I have to go to a SSH "jump box" and then > > port forward and/or connect to the cluster. > > > > (I wish I could change that, but assume at this point I can't) > > > > With the Drill JDBC and ODBC drivers, they both connect direct to ZK (I > am > > assuming to get a drill bit to connect to ) > > > > This is obvious the best approach. However, would it be possible for me > to > > find the JDBC port and just direct connect to the drill bit that I > manually > > setup a tunnel for on a single port? This is hacky I know, however, > > setting up tunnels for my ZKs, and my ports will get old fast, and I also > > don't have hostname resolution on my Windows client that I want to > connect > > tableau or SQL Squirrel with. > > > > This is not ideal, but it will show the tools can work, is it possible to > > connect direct over single port or is something in how the JDCB/ODBC > > drivers are built keeping that from happening? > > > > John > >
