I've had the best luck with the Hortonworks driver (32-bit Windows). The Cloudera and Microsoft ones have seemed flaky (crashes, some SQL not supported). I haven't tried the Data Direct driver.
Cheers, Toby. On Fri, Mar 11, 2016 at 4:46 AM, Mich Talebzadeh <mich.talebza...@gmail.com> wrote: > Hi, > > The best ODBC drivers that I found to work with Hive 2 is Progress Data > Direct driver for Hive (ODBC 3 compliant).. > > I tried Cloudera one very shaky (although I tried that on Hive 1.2.1). > Tried Microsoft ones but it hangs. Just to be clear I am using 64-bit > drivers. > > This is not direct data fetch from Hive tables. I have used Power Designer > to create a Physical Mo from Hive schema/database using ODBC3 connection > (Power designer does not have Hive in list of its databases so ODB3 is the > choice). > > I then intend to create a logical model from this physical model. > > Anyone has better suggestions(s) for Hive ODBC drivers > > Dr Mich Talebzadeh > > > > LinkedIn * > https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw > <https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw>* > > > > http://talebzadehmich.wordpress.com > > >
