Error message: "Validation of the data source template definition failed. Database driver.com.cloudera.hive.jdbc41.HS2Driver not found."

Error message: "Validation of the data source template definition failed. Database driver.com.cloudera.hive.jdbc41.HS2Driver not found."

Resolution:

The above error message (See the attached image - Error message.jpg) is displayed while saving the data source template for Cloudera Apache Hive (See KB 48553 for reference). The message indicates that the Cloudera Apache Hive driver is missing from the lib folder in the Spotfire Server installation directory.

To resolve the problem, do the following:

1. Open the link - http://www.cloudera.com/downloads/connectors/hive/jdbc/2-5-16.html to download the JDBC driver.

2. Once the download is complete, save this .zip file in a folder and unzip (extract) it. You will see multiple folders in it. (See the attached - JDBC driver.PNG)

3. Unzip the "Cloudera_HiveJDBC41_2.5.16.1044" folder.

4. Copy all files from the "Cloudera_HiveJDBC41_2.5.16.1044" folder (except the PDF files) into the lib folder. (See the attached: Hive Driver Details.PNG)

5. Restart your Spotfire Server service, so it can recognize the newly added drivers.

Reference:

http://www.cloudera.com/downloads/connectors/hive/jdbc/2-5-16.html