The Driver maps SQL to HiveQL, enabling direct standard SQL-92 access to Apache Hive. Let me know if it Ahmad Below steps will help you in setting up ODBC. The Hive ODBC Driver is a powerful tool that allows you to connect with Apache Hive, directly from any applications that support ODBC connectivity. In case of LDAP pass username/password with auth as username and password.

Check property value, if it is None, you can set Authentication Mechanism in ODBC config as just Username and pass the end user otherwise if it is Kerberos, you can set Kerberos for it. I would check FQDN of HS2 host from end client and set the same in Host for ODBC.ģ.

Test the connectivity between end Client and Hiveserver2 host by using ping or telnet on the port we got from above point. If it is binary then set Thrift Transport mode to default SASL.Ģ.

If the above is set to binary, in that case, your Hiveserver2 is running on Binary Mode i.e based on above configs it should be port 10000, otherwise, if it is HTTP then your HS2 is running on PORT 10001įor HTTP Transport mode, set transport mode as HTTP and HTTP Path as cliservice Check on what Mode my Hiveserver2 is running, From Ambari -> Hive -> Conf check property value For this tutorial, we will configure for Excel 2013 64-bit, so we’ll select Windows 64-bit (msi). Based on your operating system settings, you might get a security warning when you try to open the file. On the Add-Ons page, scroll down to Hortonworks Hive ODBC Driver (Windows + Mac) and select the driver that matches the version of Excel installed on your system (32-bit or 64-bit). Open the 32-bit ODBC driver before you open the 64-bit driver.

Ahmad Below steps will help you in setting up ODBC.ġ. Navigate to the location where you download the Hortonworks Hive ODBC drivers.

Hortonworks hive odbc driver for mac