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?

gefragt vor einem Monat66 Aufrufe
Keine Antworten

Du bist nicht angemeldet. Anmelden um eine Antwort zu veröffentlichen.

Eine gute Antwort beantwortet die Frage klar, gibt konstruktives Feedback und fördert die berufliche Weiterentwicklung des Fragenstellers.

Richtlinien für die Beantwortung von Fragen