Hi all,
I have setup AWS Athena to query PostgreSQL DB data.
However, I encountered GENERIC_USER_ERROR when trying to query some data, with following messages:
Full Error Messages:
GENERIC_USER_ERROR: Encountered an exception[com.amazonaws.SdkClientException] from your LambdaFunction[arn:aws:lambda:eu-west-1:XXXXXXXXXXXX:function:jdbc_postgres] executed in context[retrieving meta-data] with message[Unable to execute HTTP request: Connect to s3.eu-west-1.amazonaws.com:443 [s3.eu-west-1.amazonaws.com/XX.XXX.XXX.XXX, s3.eu-west-1.amazonaws.com/XX.XXX.XXX.XXX, s3.eu-west-1.amazonaws.com/XX.XXX.XXX.XXX, s3.eu-west-1.amazonaws.com/XX.XXX.XXX.XXX, s3.eu-west-1.amazonaws.com/XX.XXX.XXX.XXX, s3.eu-west-1.amazonaws.com/XX.XXX.XXX.XXX, s3.eu-west-1.amazonaws.com/XX.XXX.XXX.XXX, s3.eu-west-1.amazonaws.com/XX.XXX.XXX.XXX] failed: connect timed out]
This query ran against the "XXXXX" database, unless qualified by the query. Please post the error message on our forum or contact customer support with Query Id: a01d4534-faad-4f4c-80b6-492c44fac1c4
Since it mentioned about to post this error message, hence posted this error message in AWS re:Post forum.
Does anyone have any ideas on how to resolve this issue?
Thanks in advance!
Best Regards,
Jerry Chong