Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts,
I've installed Simba+Athena ODBC x64 and configured a system DSN and can see our db and tables in Athena :
When attempting to Select from a view in Athena into QV I get the following error:
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
For Information I seem to have fixed it... the ODBC configuration required an S3 Output Location (first image in my opening post)
For Information I seem to have fixed it... the ODBC configuration required an S3 Output Location (first image in my opening post)