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. >
