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