Menu
Simba Technologies
Simba Technologies

Simba Hive ODBC Driver with SQL Connector 2.1.7
Installation and Configuration Guide

About the Simba Hive ODBC Driver for Unix/Linux

The Simba Hive ODBC Driver is used for direct SQL and HiveQL access to Apache Hadoop / Hive distributions, enabling Business Intelligence (BI), analytics, and reporting on Hadoop / Hive-based data. The driver efficiently transforms an application’s SQL query into the equivalent form in HiveQL, which is a subset of SQL-92. If an application is Hive-aware, then the driver is configurable to pass the query through to the database for processing. The driver interrogates Hive to obtain schema information to present to a SQL-based application. Queries, including joins, are translated from SQL to HiveQL. For more information about the differences between HiveQL and SQL, see SQL Connector for HiveQL.

The Simba Hive ODBC Driver complies with the ODBC 3.80 data standard and adds important functionality such as Unicode and 32- and 64-bit support for high-performance computing environments.

ODBC is one of the most established and widely supported APIs for connecting to and working with databases. At the heart of the technology is the ODBC driver, which connects an application to the database. For more information about ODBC, see the Data Access Standards Glossaryhttp://www.simba.com/resources/data-access-standards-library. For complete information about the ODBC specification, see the ODBC API Reference: http://msdn.microsoft.com/en-us/library/windows/desktop/ms714562(v=vs.85).aspx.

The Simba Hive ODBC Driver is available for Microsoft® Windows®, Linux, Solaris, AIX, and macOS platforms.

Note:

This is the most up-to-date version of the Installation and Configuration Guide, for use with version 2.1.7 of the driver. If you are using an older version of the driver, certain features may not be available and certain settings may behave in unexpected ways. Please consult the PDF version of the Installation and Configuration Guide that was installed with your driver.

The Installation and Configuration Guide is suitable for users who are looking to access data residing within Hive from their desktop environment. Application developers might also find the information helpful. Refer to your application for details on connecting via ODBC.