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?

ログインしていません。 ログイン 回答を投稿する。

優れた回答とは、質問に明確に答え、建設的なフィードバックを提供し、質問者の専門分野におけるスキルの向上を促すものです。

質問に答えるためのガイドライン

関連するコンテンツ