![]() When I run libname, it just keeps running and no result. S3OutputEncKMSKey=XXX:aws:XXX:ap-southeast-2:XXXXXXXXXXXXXX:key/XXXXXXXXXXXXXXXXXXXXXXXXX S3OutputLocation= s3://temp-XXX-XXXX-XXXX-XXX-query-results/dev/athena_dev_x we have updated the odbc.ini file and specified the proxy server details too.ĭriver=/opt/simba/athenaodbc/lib/64/libathenaodbc_sb64.so The only difference I see is, I do not have internet connection on SAS box and hence I am using a proxy server to redirect my request to get it connected to AWS. S3OutputLocation=s3://temp-XXX-XXXX-XXXX-XXX-query-results/dev/athena_dev_x Schema= is required if you are using a non-default schema.Ĭomplete="DRIVER= If you use database= you will not see the table name in your SAS library. Your credentials will be different than the ones used here and you will need to store them in the default location for your OS. I used the Amazon Athena tutorial to create an Athena databases. I was able to get SAS/ACCESS Interface to ODBC to work with Amazon Athena using the Simba ODBC driver. Then again, there may be something on the DataDirect ODBC -> JDBC bridge happening. Are your credentials stored in ~/.aws/credentials directory? If so, can you share the environment variables that are stored in the credentials directory. ![]() Hi error message looks like the driver can't find the credentials. Consult the service documentation for details. ![]() Check your AWS Secret Access Key and signing method. The request signature we calculated does not match the signature you provided. MSG = : (100071) An error has been thrown from the AWS Athena client. (Service: AmazonAthena Status Code: 400 Error Code: InvalidSignatureException Request ID: fd368828-5cdc-11e8-b635-2b0a69392482)Īt .http.AmazonHttpClient$RequestExecutor.handleErrorResponse(AmazonHttpClient.java:1639)Īt .http.AmazonHttpClient$RequestExecutor.executeOneRequest(AmazonHttpClient.java:1304)Īt .http.AmazonHttpClient$RequestExecutor.executeHelper(AmazonHttpClient.java:1056)Īt .http.AmazonHttpClient$RequestExecutor.doExecute(AmazonHttpClient.java:743)Īt .http.AmazonHttpClient$RequestExecutor.executeWithTimer(AmazonHttpClient.java:717)Īt .http.AmazonHttpClient$RequestExecutor.execute(AmazonHttpClient.java:699)Īt .http.AmazonHttpClient$RequestExecutor.access$500(AmazonHttpClient.java:667)Īt .http.AmazonHttpClient$RequestExecutionBuilderImpl.execute(AmazonHttpClient.java:649)Īt .(AmazonHttpClient.java:513)Īt .(AmazonAthenaClient.java:802)Īt .(AmazonAthenaClient.java:778)Īt .(AmazonAthenaClient.java:684)Īt .(AmazonAthenaClient.java:660)Īt (dbpassjdbc.java:311) Consult the service documentation for details.Ĭaused by: .: The request signature we calculated does not match the signature you provided. Consult the service documentation for details.Īt .(Unknown Source)Īt .(Unknown Source)Īt .(Unknown Source)Īt .api.AJClient.(Unknown Source)Īt .(Unknown Source)Īt .(Unknown Source)Īt .(Unknown Source)Īt (DriverManager.java:664)Īt (DriverManager.java:247)Īt (jdbcutil.java:35)Ĭaused by: .exceptions.GeneralException: (100071) An error has been thrown from the AWS Athena client. : (100071) An error has been thrown from the AWS Athena client. Log4j:WARN Please initialize the log4j system properly. Log4j:WARN No appenders could be found for logger (.AmazonWebServiceClient). Please help me to resolve this connectivity issue, and let me know if you need more information on this. installed the software while testing the connection getting below error Note: by using AWS CLI we successfully connected to AWS S3 bucket.Īs you suggested Contacted for ODBC to JDBC bridges. Step -2 : Athena JDBC driver - Failed ( Proxy connectivity issue - as we are connecting through proxy server ) Step -1 : Athena ODBC driver - Failed ( SAS Says currently no plug-in available ) MY TASK : Configure SAS Application to access AWS S3 bucket by using Athena jdbc/odbc driver
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |