How can I export to a TLS/SSL secured Hiveserver2?

Follow

Michael Ahn

• January 24, 2019 12:26

I try to setup a Hiveserver2 connection to an TLS/SSL secured Hiveserver2 with LDAP User/Password authentication. There are no options to activate SSL like they exist for the jdbc (import oly) connection for Hiveserver2. Are there options in the "Custom properties" field I can use?

0

• 

  Konsta Danyliuk

  • January 24, 2019 12:34

  Hello Michael.

  In case HiveServer2 instance you are trying to connect to is configured to serve via SSL, you could introduce the property hive.server2.use.SSL=true at Connection's custom properties.

  Please feel free to open a support ticket if you would need further assistance on this.

  0

  Comment actions Permalink
• 

  Michael Ahn

  • January 24, 2019 12:45

  Hi Konsta, thanks for the quick answer. It worked.

  But the certificate of the server is not accepted.

  Can I also set the path and pasword to the trust store?

  0

  Comment actions Permalink
• 

  Konsta Danyliuk

  • January 24, 2019 13:20

  Hello Michael.

  I guess you are facing the exception like

  PKIX path building failed SunCertPathBuilderException: unable to find valid certification path to requested target

  In this case it is required to gather SSL certificate from Hive service, add it into Datameer JVM truststore and restart conductor. Below articles describe the process you should follow to gather and add the certificate.

  • Trusting Custom Certificates from Other Services
  • How to Trust Custom SSL Certificates in HTTPS Connections

  0

  Comment actions Permalink

Please sign in to leave a comment.