KB43744: How to setup connectivity to Cloudera Hive 0.10

Introduction: 
Cloudera Hive 0.10 has been post-certified as a warehouse in Strategy 9.3.1 for Strategy Intelligence Servers running on Windows and Linux Operating Systems.
 
The section below provides steps to establish ODBC connectivity to Hive 0.10 from Windows and Linux Operating Systems.
 
 
Windows 

• Install the certified ODBC driver (32-bit Cloudera ODBC Driver for Apache Hive, Version 2.0) to connect to Hive 0.10.
• From Windows ODBC Administrator (32-bit), choose to create a new system DSN and choose 'Cloudera Driver for Apache Hive'.
• On the DSN configuration editor, provide the required server parameters to connect to Hive 0.10, as shown below.
   
  

•  
  Note: It is not necessary to provide values for additional parameters such as User, Password, Type, Principal to connect to Hive 0.10 in a non-secure environment. When the environment is secure, these parameters should be provided.

 
 
Linux 

1. Install the certified ODBC driver (32-bit Cloudera ODBC Driver for Apache Hive, Version 2.0) to connect to Hive 0.10
2. Locate the odbc.ini file found in the home directory of the Strategy installation.
3. Edit the odbc.ini and add the following content at the end of the file to create a new DSN for Hive 0.10. Sections marked with <> should be filled in by users based on their environment.
   

   
    
   [Hive_0.10_WH] 
   Driver=full_path_to_driver>/cloudera/20v2/lib/libhiveodbc.so.1
   Description=Hive Driver 
   DATABASE=<provide name of database> 
   HOST=<provide name of the host server> 
   PORT=<provide port number> 
   FRAMED=0

   
    
   
4. Add the newly created DSN name entry to the ODBC Data Sources section as shown below:
   

   
   [ODBC Data Sources]
   Hive_0.10_WH=Hive Driver

   
    
   
5. Edit the ODBC.sh file found in the location <MSTR_HOME_PATH>/env and add the following section to the end of the file. Replace the <FULL_PATH_TO_LOCATION_OF_DRIVER> as per the location where the driver is installed.  
    
   

   
   # ODBC Driver for Hive
   #
   HIVE_CONFIG='<FULL_PATH_TO_DRIVER>/cloudera/20v2’
   if [ "${HIVE_CONFIG}" != '<HIVE_CONFIG>' ]; then
   export HIVE_CONFIG
   mstr_append_path LD_LIBRARY_PATH "${HIVE_CONFIG:?}"/lib
   export LD_LIBRARY_PATH
   fi

   
    
   

 
Users can also connect to secured CDH clusters using MIT Kerberos. Refer to the following Strategy Knowledge Base document for further information on how to configure connectivity on a Linux operating system:
 
KB43150 : How to configure a connectivity to a secured CDH cluster with Strategy 9.x with the Cloudera ODBC Driver for the Intelligence Server on a Linux operating system
 
 
Creation of Database Instance  

• After following steps outlined in KB43537  to install the new Hive 0.10 database object, create a new database instance by setting the database type to 'Hive 0.10' as shown below.
   
  

• In the advanced tab of the database instance editor, make sure that the option 'Use 2.0 ODBC calls' is selected as shown below.