Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: ODBC driver information

...

Does Hive have an ODBC driver?

Yes.  Many third-party vendors provide ODBC drivers.

Simba provides both ODBC and JDBC drivers, and developed many of the drivers for other companies.

http://www.simba.com/drivers/hive-odbc-jdbc/

Microsoft provides an ODBC driver for Hive in HDInsight and local clusters.

https://azure.microsoft.com/en-us/documentation/articles/hdinsight-connect-excel-hive-odbc-driver/
https://www.microsoft.com/en-ca/download/details.aspx?id=40886 

Hortonworks provides an ODBC driver for HDP

http://hortonworks.com/hdp/addons/

Cloudera provides an ODBC driver for Cloudera Enterprise

http://www.cloudera.com/downloads/connectors/hive/odbc/2-5-12.html

MapR provides ODBC drivers

http://doc.mapr.com/display/MapR/Hive+ODBC+Connector

Progress offers a DataDirect ODBC driver

https://www.progress.com/odbc/apache-hadoop-hive

Amazon provides ODBC/JDBC drivers for Amazon EMR

https://docs.aws.amazon.com/ElasticMapReduce/latest/DeveloperGuide/emr-bi-tools.html