RE: Hive ODBC - Microsofts Involvement
The Hive driver that Microsoft will be releasing is ODBC, so you should be able to interact with Hive just like you would with any other relational database. From: John Omernik [mailto:j...@omernik.com] Sent: Wednesday, February 01, 2012 3:22 PM To: user@hive.apache.org Subject: Hive ODBC - Microsofts Involvement Does anyone know if the driver Microsoft is talking about with their Azure based hadoop/hive setup would work for connecting Windows applications (Excel/.NET Web Apps etc) to Apache Hive running on Unix? Looking for a way to connect .NET Web apps to Hive for some process flow upgrades. Thanks!
Re: Hive ODBC - Microsofts Involvement
I see that, but will that hive ODBC driver work with a standard hive install, or will it be limited to Microsoft's cloud version of Hadoop/Hive? Anyone tried the driver? On Wed, Feb 1, 2012 at 4:23 PM, Tucker, Matt matt.tuc...@disney.com wrote: The Hive driver that Microsoft will be releasing is ODBC, so you should be able to interact with Hive just like you would with any other relational database. ** ** *From:* John Omernik [mailto:j...@omernik.com] *Sent:* Wednesday, February 01, 2012 3:22 PM *To:* user@hive.apache.org *Subject:* Hive ODBC - Microsofts Involvement ** ** Does anyone know if the driver Microsoft is talking about with their Azure based hadoop/hive setup would work for connecting Windows applications (Excel/.NET Web Apps etc) to Apache Hive running on Unix? Looking for a way to connect .NET Web apps to Hive for some process flow upgrades. ** ** Thanks! ** **
Re: Hive ODBC - Microsofts Involvement
Any reason you want to use a ODBC and not Thrift ? Hive supports the thrift protocol. There are thrift libraries for C# and you can easily integrate it into your project for direct access to HIVE via your C# code. On Wed, Feb 1, 2012 at 6:40 PM, John Omernik j...@omernik.com wrote: I see that, but will that hive ODBC driver work with a standard hive install, or will it be limited to Microsoft's cloud version of Hadoop/Hive? Anyone tried the driver? On Wed, Feb 1, 2012 at 4:23 PM, Tucker, Matt matt.tuc...@disney.comwrote: The Hive driver that Microsoft will be releasing is ODBC, so you should be able to interact with Hive just like you would with any other relational database. ** ** *From:* John Omernik [mailto:j...@omernik.com] *Sent:* Wednesday, February 01, 2012 3:22 PM *To:* user@hive.apache.org *Subject:* Hive ODBC - Microsofts Involvement ** ** Does anyone know if the driver Microsoft is talking about with their Azure based hadoop/hive setup would work for connecting Windows applications (Excel/.NET Web Apps etc) to Apache Hive running on Unix? Looking for a way to connect .NET Web apps to Hive for some process flow upgrades. ** ** Thanks! ** **
Re: Hive ODBC - Microsofts Involvement
I've tried it. It seems to work fine, but with ODBC, you still need to send SQL commands to the server, and Hive SQL is incomplete and non-ansi compliant in many ways. This means that an application that uses ANSI SQL will not always generate Hive friendly queries. They do have an excel connector under development also, which you can get if you are on the beta. On Feb 1, 2012 9:41 PM, John Omernik j...@omernik.com wrote: I see that, but will that hive ODBC driver work with a standard hive install, or will it be limited to Microsoft's cloud version of Hadoop/Hive? Anyone tried the driver? On Wed, Feb 1, 2012 at 4:23 PM, Tucker, Matt matt.tuc...@disney.comwrote: The Hive driver that Microsoft will be releasing is ODBC, so you should be able to interact with Hive just like you would with any other relational database. ** ** *From:* John Omernik [mailto:j...@omernik.com] *Sent:* Wednesday, February 01, 2012 3:22 PM *To:* user@hive.apache.org *Subject:* Hive ODBC - Microsofts Involvement ** ** Does anyone know if the driver Microsoft is talking about with their Azure based hadoop/hive setup would work for connecting Windows applications (Excel/.NET Web Apps etc) to Apache Hive running on Unix? Looking for a way to connect .NET Web apps to Hive for some process flow upgrades. ** ** Thanks! ** **
Re: Hive ODBC - Microsofts Involvement
Btw, i tried it on CDH3 hive. On Feb 1, 2012 10:02 PM, Chris Shain ch...@tresata.com wrote: I've tried it. It seems to work fine, but with ODBC, you still need to send SQL commands to the server, and Hive SQL is incomplete and non-ansi compliant in many ways. This means that an application that uses ANSI SQL will not always generate Hive friendly queries. They do have an excel connector under development also, which you can get if you are on the beta. On Feb 1, 2012 9:41 PM, John Omernik j...@omernik.com wrote: I see that, but will that hive ODBC driver work with a standard hive install, or will it be limited to Microsoft's cloud version of Hadoop/Hive? Anyone tried the driver? On Wed, Feb 1, 2012 at 4:23 PM, Tucker, Matt matt.tuc...@disney.comwrote: The Hive driver that Microsoft will be releasing is ODBC, so you should be able to interact with Hive just like you would with any other relational database. ** ** *From:* John Omernik [mailto:j...@omernik.com] *Sent:* Wednesday, February 01, 2012 3:22 PM *To:* user@hive.apache.org *Subject:* Hive ODBC - Microsofts Involvement ** ** Does anyone know if the driver Microsoft is talking about with their Azure based hadoop/hive setup would work for connecting Windows applications (Excel/.NET Web Apps etc) to Apache Hive running on Unix? Looking for a way to connect .NET Web apps to Hive for some process flow upgrades. ** ** Thanks! ** **
