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?

您未登录。 登录 发布回答。

一个好的回答可以清楚地解答问题和提供建设性反馈,并能促进提问者的职业发展。

回答问题的准则