1 year ago

#237505

test-img

cloud_hari

Getting "javax.net.ssl.sslhandshakeexception pkix path building failed sun.security.provider.certpath" error in glue while accessing hive using jdbc

i am trying to access hive which is running on on-prmisis from a glue job

As hive use jdbc connection which requires authentication, i attached certificate(certificate.pem) in the job(using connection) and trying to load the table with below code:

Glue version: 2 spark:2.4

jdbcDF = spark.read \
    .format("jdbc") \
    .option("url", "jdbc:hive2://bigdatamr:10000/mydb;ssl=true;transportMode=http;httpPath=gateway/default/hive;trustStorePassword=selfSigned") \
    .option("dbtable", "mydb") \
    .option("user", "myusername") \
    .option("password", "xxxxxxx") \
    .load()

but job return below error:

javax.net.ssl.sslhandshakeexception pkix path building failed sun.security.provider.certpath
unable to find valid certification path to requested target

how to resolve this ?

java

pyspark

hive

aws-glue

aws-glue-connection

0 Answers

Your Answer

Accepted video resources