Driver Installation and Configuration for Windows
- Download the driver from the Cloudera downloads site (see Cloudera ODBC Connectors downloads page).
Run the downloaded installer on each applicable system:
To install through the installation wizard:
Run the downloaded .exe file, from the command line or by double-clicking its icon. You will need to accept the license agreement, and accept or modify the installation location. The driver is a 32-bit version that can also run on a 64-bit system.
(Optional) To deploy on multiple servers, install silently from the command line:
Run the install executable as:
Install_exe /S [/D="Dir_to_install"]For example, to install in the default location:
ClouderaHiveODBCSetup_v2_00.exe /SOr, to install in a specific directory:
ClouderaHiveODBCSetup_v2_00.exe /S /D="C:\Program Files (x86)\Hive ODBC"The license is accepted automatically when you install in silent mode.
- To install through the installation wizard:
After the driver is installed, find and run the ODBC Data Source
- On some systems, the 32-bit version of the ODBC administrator is located at %systemdrive%\Windows\SysWoW64\odbcad32.exe.
- If you do not find the administrator utility in its default location, type odbc administrator into the Search box of the Windows Start menu.
- In the search results, double-click ODBC Administrator. (Note that on a 64-bit Windows system, you must select the 32-bit binary, not the 64-bit binary.)
- In the ODBC Data Source Administrator window, click the System DSN tab, then click Add....
- Select the Cloudera ODBC Driver for Apache Hive and click Finish. (This assumes you have first installed the driver per steps 1 and 2 above). The Hive ODBC DSN Configuration dialog box appears.
Fill in the fields with the the details of your data source.
The data source could be a Cloudera Impala server
or an Apache Hive server.
- Enter the hostname or IP address and the port number. To connect to Impala, specify the details for any node in the cluster that is running the impalad daemon.
- For Impala, leave the Type field blank when connecting to an Impala node secured with Kerberos authentication, or enter HS2NoSASL for the Type field if the node is not secured by Kerberos. For Hive, always leave the Type field blank.
- The default port number is 21050 for an Impala node, or 10000 for an Apache Hive server.
When connecting to a cluster that has Kerberos authentication enabled, fill in the Kerberos principal
for the HiveServer2 or Impala service, for example:
- Click OK .
The installation is now complete.
Uninstalling the Driver
installation_directory/uninstall.exeTo uninstall silently, add the /S option: