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
