By using AWS re:Post, you agree to the AWS re:Post Terms of Use
AWS re:Postre:Post

Athena engine version 3 fail create table query

0

Athena engine version 3 fail create table query, but on version 2 works good. Error : "pyathena.error.OperationalError: Amazon Athena experienced an internal error while executing this query. Please try submitting the query again and if the issue reoccurs, contact AWS support for further assistance. We apologize for the inconvenience."

Create table not so simple include many sub queries and so one. Is it possible some think is create table query?

  • secondabhi_aws EXPERT
    10 months ago

    Can you post your create table DDL too after removing potential sensitive information.

  • rePost-User-3708923
    10 months ago

    The issue was fixed by moved couple base views to tables. Looks like query are to heavy for engine3

Topics
Analytics
Tags
Amazon Athena
Language
English
rePost-User-3708923
asked 10 months ago325 views
No Answers

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

Relevant content