Knime v5 Athena Connector

[MikePAM]

Hi

In Knime v4, the athena driver comes pre-installed. In v5, you need to install it yourself and everything I try is failing.

I downloaded from here

Athena JDBC 2.x driver - Amazon Athena

The jar file without the SDK.

Put it in my knime preferences as per this image

But I still can’t connect to Athena. Any help would be massively appreciated.

Thanks

Mike

[takbb]

Hi @MikePAM ,

I haven’t used Athena but what happens when you try to connect? What errors are you getting?

[tobias.koetter]

Hello @MikePAM ,
sorry for the inconveniences. Unfortunately we had to remove the driver from the KNIME installation due to the licensing of the JDBC driver that is provided by Amazon. The license does not allow us to distribute the driver with the KNIME Analytics Platform.

To register the driver do the following steps:

1. Download the version 2 without the SDK (the pure jar file) of the driver from here. The current version 2.1.1.101 can be directly downloaded from here.

2. Register the driver via the KNIME preferences as described here. Please make sure to not change the URL template
   

   

3. Select the newly registered driver in the Amazon Athena Connector node
   

   

Let us know if this works for you.

Bye
Tobias

[jvidin]

@tobias.koetter

e sure t

Hi Tobias , im facing the exact same problems as Mike .
I posted it on Friday (Read AWS Glue Catalog Tables)

im on Mac and trying Knime v5.2.0.v202311301336 for the first times …

I just did the steps you mentioned above but then after successfully registered the driver.

register the driver

I can select the registered driver

I can successful connect to S3 in my account and browse buckets.

But every time I try to run Athena Connector it fails with the below messages .

ERROR Amazon Athena Connector 4:3        Execute failed: com/fasterxml/jackson/databind/ObjectMapper
ERROR Amazon Athena Connector 4:3        Execute failed: Could not initialize class com.amazonaws.auth.DefaultAWSCredentialsProviderChain
ERROR Amazon Athena Connector 4:3        Execute failed: com/amazonaws/auth/AWSCredentialsProvider
ERROR Amazon Athena Connector 4:3        Execute failed: Could not initialize class com.simba.athena.amazonaws.ClientConfiguration
ERROR Amazon Athena Connector 4:3        Execute failed: Could not initialize class com.simba.athena.amazonaws.ClientConfiguration
ERROR Amazon Athena Connector 4:3        Execute failed: Could not initialize class com.simba.athena.amazonaws.ClientConfiguration
ERROR Amazon Athena Connector 4:3        Execute failed: Could not initialize class com.simba.athena.amazonaws.ClientConfiguration
ERROR Amazon Athena Connector 4:3        Execute failed: Could not initialize class com.simba.athena.amazonaws.ClientConfiguration

At this point I think I tried all the available drivers to download from AWS documentation and all failed.

Any help , appreciate.
Thanks

[MikePAM]

@tobias.koetter That worked. But it doesn’t work if I try the default credentials chain authentication. Only if I put in the access and secret access directly.

Is that a bug or do I need to do something different?

Thanks

Mike