Re: remotely using drill - is this possible ?

[M Gates <ga...@gmail.com>]

Looking to connect to a Hadoop edge node with drill installed on my laptop connecting through Knox to hive using jdbc.
Anyone know if this is possible ?

thanks
M

> On Apr 25, 2016, at 11:21 AM, M Gates <ga...@gmail.com> wrote:
> 
> 
> Wondering if there are any examples of connecting drill to hive through knox - is this possible ?
> 
> Mark.
> 
> 
>> On Apr 19, 2016, at 10:39 AM, Andries Engelbrecht <ae...@maprtech.com> wrote:
>> 
>> You have to use the Drill ODBC driver. Download it and the configure it.
>> The Drill ODBC driver comes with a very nice tool called Drill Explorer that is pretty handy to view and work with Drill data sources.
>> 
>> https://drill.apache.org/docs/installing-the-driver-on-windows/ <https://drill.apache.org/docs/installing-the-driver-on-windows/>
>> 
>> https://drill.apache.org/docs/configuring-odbc-on-windows/ <https://drill.apache.org/docs/configuring-odbc-on-windows/>
>> 
>> --Andries
>> 
>> 
>> 
>>> On Apr 19, 2016, at 6:31 AM, M Gates <ga...@gmail.com> wrote:
>>> 
>>> Thanks for the info.
>>> One thing I am trying to do is on Windows connect drill through the the Hortonworks Hive ODBC driver. Bit stuck on how to configure this in drill, any how to’s on available ?
>>> 
>>> Mark.
>>> 
>>>> On Apr 18, 2016, at 1:31 PM, Jim Bates <jb...@maprtech.com> wrote:
>>>> 
>>>> Absolutely. Use the JDBC/ODBC interfaces and a workspace / storage plugin
>>>> writing the data into a distributed file system.
>>>> 
>>>> https://drill.apache.org/docs/odbc-jdbc-interfaces/
>>>> 
>>>> 
>>>> 
>>>> On Mon, Apr 18, 2016 at 12:25 PM, M Gates <ga...@gmail.com> wrote:
>>>> 
>>>>> 
>>>>> 
>>>>> Question on drill, completely new to this tool and it looks awesome.
>>>>> 
>>>>> Is there a way to run drill remotely and over say over ODBC/JDBC driver
>>>>> send a query to my hadoop cluster ? i.e.: drill is on my client computer
>>>>> but the write stays in my hadoop workspace.
>>>>> 
>>>>> Thanks,
>>>>> Mark.
>>> 
>> 
>