Athena JDBC Driver issue running a Glue Job

Question

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

Gonzalo Herreros · Answer

Glue doesn't provide the Simba driver because it's proprietary and requires a license fee.   Have you added it somehow to your job?  
Otherwise, you could ask Athena to run the query using boto3 and read the result from s3.

Athena JDBC Driver issue running a Glue Job

Add your answer

Relevant content