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?

로그인하지 않았습니다. 로그인해야 답변을 게시할 수 있습니다.

좋은 답변은 질문에 명확하게 답하고 건설적인 피드백을 제공하며 질문자의 전문적인 성장을 장려합니다.

질문 답변하기에 대한 가이드라인

관련 콘텐츠