Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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 (2)
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)