trying to access the prestodb table from using pyspark with following code
spark = SparkSession.builder.master("local[*]").appName("testing presto connection").config('spark.driver.extraClassPath', 'dependencies/presto-jdbc-0.221.jar').getOrCreate()
jdbc_df = spark.read.jdbc(url="jdbc:presto://host:port/catalog_name",table="schema_name.table_name",
properties={"user": "username", "password": "password","SSL":"true"})
jdbc_df.show(10)
But I'm getting error as below,
Caused by: sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target
How to resolve that error?
