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
