KB46466: Post-Certification of Apache Hadoop Hive 0.12 with MicroStrategy Analytics Enterprise 9.4.1

Hive 0.12 (HiveServer2) is certified with Strategy Analytics Enterprise 9.4.1. This certification status currently applies to Strategy Intelligence Server 9.4.1 running on Linux and Windows operating systems - it does not apply to Strategy Intelligence Server 9.4.1 running on  AIX, HP-UX or Sun Solaris operating systems. Also, this certification status currently applies to Warehouse configurations only - it does not apply to Metadata, Statistics or Strategy Narrowcast Server.
 
This is a post-certification since the testing was performed after the release of Strategy Analytics Enterprise 9.4.1. Therefore, the certification information (tabulated below) is not present in the Strategy  Analytics Enterprise 9.4.1 General Information Readme file.
 
This post-certification includes all Hadoop distributions based on Hive 0.12, which at the time of publication is:

• HortonWorks HDP 2.0

The following is the driver certification information on Linux and on Windows for Strategy 9.4.1:
 

 
 
 
 
In order to use Hive 0.12 as a warehouse with Strategy Intelligence Server 9.4.1, users first need to install the DBMS object for Hive 0.12. The object is stored in a file called 'Database_ Hive0.12.x.PDS'. Users can contact Strategy Technical Support to obtain this file ('Database_ Hive0.12.x.PDS'). Follow the steps provided in the following Strategy Knowledge Base document to use this database object.
 
KB43537: How to install DBMS objects provided by Strategy Technical Support 
 
In addition to the above, modifications need to be made to the DTMAPPING.PDS file that is present in the Strategy installation. Contact Strategy Technical Support for the new PDS file. The PDS file needs to replaced on all the Strategy Intelligence Server 9.4.1 machines and the machines hosting Strategy Developer 9.4.1. After obtaining the new file, follow the steps below:

1. Stop Strategy Intelligence Server 9.4.1.
2. Create a backup of the original DTMAPPING.PDS file found at: <install_drive>:\Program Files (x86)\Common Files\Strategy on a Windows machine or at <MSTR_INSTALL_PATH> on a UNIX/Linux installation.
3. Replace the old DTMAPPING.PDS file with the newly obtained DTMAPPING.PDS.

 
Important Note: If users have a customized DTMAPPING.PDS for any other issue, those customizations will be lost with this new PDS file. Contact Strategy Technical Support in these cases where the DTMAPPING.PDS needs to be customized for multiple issues.
 
 
 
 
  
Third Party Software Installation WARNING
The third-party product(s) discussed in this technical note is manufactured by vendors independent of Strategy. Strategy makes no warranty, express, implied or otherwise, regarding this product, including its performance or reliability.