Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
Senor_Dai
Partner - Creator II
Partner - Creator II

Installed Simba+Athena ODBC for Qlikview - Response Code error

Hi Experts, 

I've installed Simba+Athena ODBC x64 and configured a system DSN and can see our db and tables in Athena :

Screenshot 2021-10-15 at 10.27.27.png

 

When attempting to Select from a view in Athena into QV I get the following error:

Screenshot 2021-10-15 at 10.32.49.png

 

 

 

 

ODBC error

Connector reply error: SQL##f - SqlState: S1000, ErrorCode: 1040, ErrorMsg: [Simba][Athena] (1040) An error has been thrown from the AWS Athena client. Athena Error No: 130, HTTP Response Code: 400, Exception Name: InvalidRequestException, Error Message: outputLocation is null or empty [Execution ID: ]

SQL SELECT *
FROM AwsDataCatalog."my_db"."my_view"

Any ideas? Conversely, I can connect using QlikSense and the 'out of the box' Athena connector.

Thanks

 

Dai

Labels (1)
1 Solution

Accepted Solutions
Senor_Dai
Partner - Creator II
Partner - Creator II
Author

For Information I seem to have fixed it... the ODBC configuration required an S3 Output Location (first image in my opening post)

View solution in original post

1 Reply
Senor_Dai
Partner - Creator II
Partner - Creator II
Author

For Information I seem to have fixed it... the ODBC configuration required an S3 Output Location (first image in my opening post)