JdbcIO ssl error

[Himanshu Hazari via user <us...@beam.apache.org>]

Hello,

Currently I am trying to copy data from Hive database to BigQuery. For this I am using JdbcIO as :-

[cid:image001.png@01DA5EEA.A476FAB0]

But I am getting error :-

Error message from worker: java.sql.SQLException: Cannot create PoolableConnectionFactory (Could not open client transport with JDBC Uri: jdbc:hive2://url:10000/default;ssl=true: javax.net.ssl.SSLHandshakeException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target)

Can someone please guide on this. I have cacert file stored on GCS bucket and I am fetching that in dataflow job.

Kind Regards,
Himanshu Hazari
Upcoming Leaves :



---
This e-mail may contain confidential and/or privileged information. If you are not the intended recipient (or have received this e-mail in error) please notify the sender immediately and destroy this e-mail. Any unauthorized copying, disclosure or distribution of the material in this e-mail is strictly forbidden.

Privacy of communications
In order to monitor compliance with legal and regulatory obligations and our policies, procedures and compliance programs, we may review emails and instant messages passing through our IT systems (including any personal data and customer information they contain), and record telephone calls routed via our telephone systems. We will only do so in accordance with local laws and regulations. In some countries please refer to your local DB website for a copy of our Privacy Policy.

Please refer to https://db.com/disclosures for additional EU corporate and regulatory disclosures.