athena complex query result internal error

0

Hi, I'm trying to build a quite complex query that runs on some views and if i get a couple of join it ends in this error [HY000][100071] [Simba]AthenaJDBC An error has been thrown from the AWS Athena client. [ErrorCode: INTERNAL_ERROR_QUERY_ENGINE] Amazon Athena experienced an internal error while executing this query. Please contact AWS support for further assistance. You will not be charged for this query. We apologize for the inconvenience. [Execution ID: ce2b6f7e-0ea3-49fe-9ae8-1eb6ecae40e7]

it join essentialli 3 view that make some calculation. first view alone takes 43Seconds to run second view takes 25 seconds and third view takes again 42 seconds to run...

if i join them it end in this error.. some advise?

asked a year ago126 views
1 Answer
3

How about datasets size? It may occur the problem, and hit the query execution limit as well as memory usage such issue.

EXPERT
answered 20 days ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions