You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@drill.apache.org by John Omernik <jo...@omernik.com> on 2015/10/09 16:58:54 UTC
Drill PoC - Working with Restrictive Environments and JDBC
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
Re: Drill PoC - Working with Restrictive Environments and JDBC
Posted by John Omernik <jo...@omernik.com>.
AWESOME Thanks!
On Fri, Oct 9, 2015 at 11:30 AM, Andries Engelbrecht <
aengelbrecht@maprtech.com> 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 <jo...@omernik.com> 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
>
>
Re: Drill PoC - Working with Restrictive Environments and JDBC
Posted by Andries Engelbrecht <ae...@maprtech.com>.
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 <jo...@omernik.com> 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