Trying to query an athena view using a Glue Job I am getting this jdbc driver issue:
Error Category: UNCLASSIFIED_ERROR; An error occurred while calling o109.load. com.simba.athena.jdbc.Driver
Using following code to query an Athena view:
athena_view_dataframe = (
glue_context.read.format("jdbc")
.option("driver", "com.simba.athena.jdbc.Driver")
.option("AwsCredentialsProviderClass","com.simba.athena.amazonaws.auth.InstanceProfileCredentialsProvider")
.option("url", "jdbc:awsathena://athena.eu-central-1.amazonaws.com:443")
.option("dbtable", "AwsDataCatalog.cars.electric_cars_v")
.option("S3OutputLocation","s3://mybucket/temp")
.load()
)
I dont know how can I solve this error
yes, I already added it into the Dependent JARs path(s3://adb-glue-scripts/athena-jdbc-3.0.0-with-dependencies.jar) in the job configuration
What's the full stacktrace?