You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@drill.apache.org by Ian Maloney <ra...@gmail.com> on 2015/12/16 21:51:03 UTC
Windows Drill 1.2 ODBC Driver
Hi,
I'm trying to get a Windows ODBC driver up and running for drill. I've
tried using both the 64 and 32 bit versions of the 1.2 release against both
1.2 and 1.3 drill releases running on Linux.
Even though I can see the schemas in ODBC manager, when I try to test the
connection or select "Ok", the app crashes. I was able to get a connection
from my Mac to the same instance of drill/zookeeper, but Windows has
crashed every time. Any advice?
Re: Windows Drill 1.2 ODBC Driver
Posted by Ian Maloney <ra...@gmail.com>.
I only have Windows 7 to test with.
I'm using a distributed configuration, I put the same values for cluster
name and ZK quorum in as I have in the drill-override.conf file for my
drillbits. I don't have authentication and can actually see the correct
list of schemas in the ODBC Administrator's drop down.
I can ping each ZK and drillbit host from Windows command prompt...
On Thursday, December 17, 2015, Andries Engelbrecht <
aengelbrecht@maprtech.com> wrote:
> Have not seen the ODBC admin crashing with Windows 7. DO you have other
> Windows systems in your environment to test with as well?
>
> What configuration are you using for the ODBC connection?
>
> Please note that if you use ZK you need to make sure the Windows system
> can resolve the ZK node(s) host names. Also make sure you have network
> connectivity and name resolution for the all the drillbits. Have seen that
> in certain network environments.
>
> https://drill.apache.org/docs/installing-the-driver-on-windows/ <
> https://drill.apache.org/docs/installing-the-driver-on-windows/>
>
>
> --Andries
>
>
> > On Dec 16, 2015, at 1:59 PM, Ian Maloney <rachmaninovquartet@gmail.com
> <javascript:;>> wrote:
> >
> > Drill Explorer says: "Connection failed. Please ensure your connection is
> > valid." and the standard Windows ODBC administrator is the one
> experiencing
> > the crashes.
> >
> > I'm on Windows 7 enterprise.
> >
> > On Wednesday, December 16, 2015, Andries Engelbrecht <
> > aengelbrecht@maprtech.com <javascript:;>> wrote:
> >
> >> Are you referring to Drill Explorer that comes with the ODBC driver that
> >> crashes?
> >>
> >> Can you just configure the DSN with the ODBC administrator and then
> >> connect with another Windows tool that uses ODBC to see if the driver is
> >> working?
> >>
> >> What versions of Windows are you using?
> >>
> >> --Andries
> >>> On Dec 16, 2015, at 12:51 PM, Ian Maloney <
> rachmaninovquartet@gmail.com <javascript:;>
> >> <javascript:;>> wrote:
> >>>
> >>> Hi,
> >>>
> >>> I'm trying to get a Windows ODBC driver up and running for drill. I've
> >>> tried using both the 64 and 32 bit versions of the 1.2 release against
> >> both
> >>> 1.2 and 1.3 drill releases running on Linux.
> >>>
> >>> Even though I can see the schemas in ODBC manager, when I try to test
> the
> >>> connection or select "Ok", the app crashes. I was able to get a
> >> connection
> >>> from my Mac to the same instance of drill/zookeeper, but Windows has
> >>> crashed every time. Any advice?
> >>
> >>
>
>
Re: Windows Drill 1.2 ODBC Driver
Posted by Andries Engelbrecht <ae...@maprtech.com>.
Have not seen the ODBC admin crashing with Windows 7. DO you have other Windows systems in your environment to test with as well?
What configuration are you using for the ODBC connection?
Please note that if you use ZK you need to make sure the Windows system can resolve the ZK node(s) host names. Also make sure you have network connectivity and name resolution for the all the drillbits. Have seen that in certain network environments.
https://drill.apache.org/docs/installing-the-driver-on-windows/ <https://drill.apache.org/docs/installing-the-driver-on-windows/>
--Andries
> On Dec 16, 2015, at 1:59 PM, Ian Maloney <ra...@gmail.com> wrote:
>
> Drill Explorer says: "Connection failed. Please ensure your connection is
> valid." and the standard Windows ODBC administrator is the one experiencing
> the crashes.
>
> I'm on Windows 7 enterprise.
>
> On Wednesday, December 16, 2015, Andries Engelbrecht <
> aengelbrecht@maprtech.com> wrote:
>
>> Are you referring to Drill Explorer that comes with the ODBC driver that
>> crashes?
>>
>> Can you just configure the DSN with the ODBC administrator and then
>> connect with another Windows tool that uses ODBC to see if the driver is
>> working?
>>
>> What versions of Windows are you using?
>>
>> --Andries
>>> On Dec 16, 2015, at 12:51 PM, Ian Maloney <rachmaninovquartet@gmail.com
>> <javascript:;>> wrote:
>>>
>>> Hi,
>>>
>>> I'm trying to get a Windows ODBC driver up and running for drill. I've
>>> tried using both the 64 and 32 bit versions of the 1.2 release against
>> both
>>> 1.2 and 1.3 drill releases running on Linux.
>>>
>>> Even though I can see the schemas in ODBC manager, when I try to test the
>>> connection or select "Ok", the app crashes. I was able to get a
>> connection
>>> from my Mac to the same instance of drill/zookeeper, but Windows has
>>> crashed every time. Any advice?
>>
>>
Re: Windows Drill 1.2 ODBC Driver
Posted by Ian Maloney <ra...@gmail.com>.
Drill Explorer says: "Connection failed. Please ensure your connection is
valid." and the standard Windows ODBC administrator is the one experiencing
the crashes.
I'm on Windows 7 enterprise.
On Wednesday, December 16, 2015, Andries Engelbrecht <
aengelbrecht@maprtech.com> wrote:
> Are you referring to Drill Explorer that comes with the ODBC driver that
> crashes?
>
> Can you just configure the DSN with the ODBC administrator and then
> connect with another Windows tool that uses ODBC to see if the driver is
> working?
>
> What versions of Windows are you using?
>
> --Andries
> > On Dec 16, 2015, at 12:51 PM, Ian Maloney <rachmaninovquartet@gmail.com
> <javascript:;>> wrote:
> >
> > Hi,
> >
> > I'm trying to get a Windows ODBC driver up and running for drill. I've
> > tried using both the 64 and 32 bit versions of the 1.2 release against
> both
> > 1.2 and 1.3 drill releases running on Linux.
> >
> > Even though I can see the schemas in ODBC manager, when I try to test the
> > connection or select "Ok", the app crashes. I was able to get a
> connection
> > from my Mac to the same instance of drill/zookeeper, but Windows has
> > crashed every time. Any advice?
>
>
Re: Windows Drill 1.2 ODBC Driver
Posted by Andries Engelbrecht <ae...@maprtech.com>.
Are you referring to Drill Explorer that comes with the ODBC driver that crashes?
Can you just configure the DSN with the ODBC administrator and then connect with another Windows tool that uses ODBC to see if the driver is working?
What versions of Windows are you using?
--Andries
> On Dec 16, 2015, at 12:51 PM, Ian Maloney <ra...@gmail.com> wrote:
>
> Hi,
>
> I'm trying to get a Windows ODBC driver up and running for drill. I've
> tried using both the 64 and 32 bit versions of the 1.2 release against both
> 1.2 and 1.3 drill releases running on Linux.
>
> Even though I can see the schemas in ODBC manager, when I try to test the
> connection or select "Ok", the app crashes. I was able to get a connection
> from my Mac to the same instance of drill/zookeeper, but Windows has
> crashed every time. Any advice?