​We are trying to connect Cognos Analytics (v11.0.11) to HIVE using Presto. Running into issues. The following steps were taken
1. Added presto-jdbc-0.227.jar to the Drivers directory on the Cognos (Application server)
2. Imported certs using ThirdPartyTool
3. Imports were successful. Certs loaded message
4. Restarted Cognos services
5. Using the Cognos JDBC connection from Cognos configuration to create a datasource connection and get the following error while testing

XQE-DS-0006 - Unable to logon to the data source.
Error fetching version from server
javax.net.ssl.SSLHandshakeException: com.ibm.jsse2.util.h:PKIX path building failed

Has anyone been successful in using the Presto JDBC to connect Cognos to a HIVE instance ?
Thank you

------------------------------
AB
------------------------------

#CognosAnalyticswithWatson

The error is indicative of an SSL problem even though it sounds like you went through all the right steps.

Here are the steps again just in case you did something different 
https://www.ibm.com/support/knowledgecenter/SSEP7J_11.1.0/com.ibm.swg.ba.cognos.inst_cr_winux.doc/t_ssl_datasource.html

Any chance you can test with a sandbox environment of a more recent version of Cognos (11.1.5 ideally) ?  There's been a lot of improvements overall since 11.0.11

------------------------------
Jason Tavoularis
------------------------------

Original Message:
Sent: Wed February 05, 2020 05:28 PM
From: Ashok Bhatia
Subject: Cognos Analytics - Presto Connection

​We are trying to connect Cognos Analytics (v11.0.11) to HIVE using Presto. Running into issues. The following steps were taken
1. Added presto-jdbc-0.227.jar to the Drivers directory on the Cognos (Application server)
2. Imported certs using ThirdPartyTool
3. Imports were successful. Certs loaded message
4. Restarted Cognos services
5. Using the Cognos JDBC connection from Cognos configuration to create a datasource connection and get the following error while testing

XQE-DS-0006 - Unable to logon to the data source.
Error fetching version from server
javax.net.ssl.SSLHandshakeException: com.ibm.jsse2.util.h:PKIX path building failed

Has anyone been successful in using the Presto JDBC to connect Cognos to a HIVE instance ?
Thank you

------------------------------
AB
------------------------------

#CognosAnalyticswithWatson

The <cognos>\logs should include the complete Java stack trace re the TLS/SSL error.

Similarly, you can enable Java's TLS tracing facility on the JRE's used within CA.

If you don't know how to do that, contact support.

-Djavax.net.debug=ssl:handshake:verbose:keymanager:trustmanager -Djava.security.debug=access:stack

------------------------------
NIGEL CAMPBELL
------------------------------

Original Message:
Sent: Wed February 05, 2020 05:28 PM
From: Ashok Bhatia
Subject: Cognos Analytics - Presto Connection

​We are trying to connect Cognos Analytics (v11.0.11) to HIVE using Presto. Running into issues. The following steps were taken
1. Added presto-jdbc-0.227.jar to the Drivers directory on the Cognos (Application server)
2. Imported certs using ThirdPartyTool
3. Imports were successful. Certs loaded message
4. Restarted Cognos services
5. Using the Cognos JDBC connection from Cognos configuration to create a datasource connection and get the following error while testing

XQE-DS-0006 - Unable to logon to the data source.
Error fetching version from server
javax.net.ssl.SSLHandshakeException: com.ibm.jsse2.util.h:PKIX path building failed

Has anyone been successful in using the Presto JDBC to connect Cognos to a HIVE instance ?
Thank you

------------------------------
AB
------------------------------

#CognosAnalyticswithWatson