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