Admin: Apache Hive Configuration

This section describes how to create and configure an Apache Hive Data Source Name (DSN). Please follow the steps below.  Please note that you may skip steps 1 – 4 if you have already installed the ODBC driver. 

1. In a web browser, navigate to https://www.cloudera.com/downloads/connectors/hive/odbc/2-6-9.html to download the driver.  

2. Select latest Hive ODBC driver, click Windows Operating System and select 64 bit. Click Get It Now to download the driver: 

   

3. After downloading the file, go to your download folder. Locate and double click the ClouderaHiveODBC64.msi file. 

   

4. In the installation Wizard Window, click Next and follow the required steps to install the driver.

   

5. Once you have successfully installed the ODBC driver, go to Control Panel\System and Security\Administrative Tools and click ODBC Data Sources (64).

6. In the ODBC Data Sources Administrator Window, click the System DSN tab. 

7. Click the Add… button to create a new Data Source. 

   

8. Find and select Cloudera ODBC Driver and click Finish.

   

9. In the Cloudera ODBC Driver DSN Setup Window, configure the following details: 

   • Data Source Name 

   • Host: Hive host server (IP address or server name). 

   • Port: Hive server port number. Only numerical values are accepted. The default Hive server port is 10000. 

   • Database: the Hive database name (the default name is ‘default’). 

   • Hive Server Type: the type of Hive server configuration. Supported values are ‘Hive Server 1’ (the default) and ‘Hive Server 2’. Select ‘Hive Server 2’.    

   • Mechanism: the type of authentication used. In this case, select ‘User Name’.  

   • User Name: the username to be used to connect to Hive. Enter the value ‘hive’. 

     

10. Click the Test button. Once the connection has been made successfully, click the OK button to create the DSN.