Athena JDBC Driver issue running a Glue Job

0

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

已提問 5 個月前檢視次數 218 次
1 個回答
0

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.

profile pictureAWS
專家
已回答 5 個月前
  • 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?

您尚未登入。 登入 去張貼答案。

一個好的回答可以清楚地回答問題並提供建設性的意見回饋,同時有助於提問者的專業成長。

回答問題指南