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 <[email protected]> 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 >> <[email protected]> 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 <[email protected]> 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 <[email protected]> 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 <[email protected]> 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. >>> >> >
