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

Athena: Delta Table DDL failed with an unexpected error.

4

I am trying to create the table using that following command that worked fine yesterday:

CREATE EXTERNAL TABLE IF NOT EXISTS `delta_gold`.`properties`
LOCATION 's3://org-delta/gold/properties/'
TBLPROPERTIES ('table_type' = 'DELTA');

, but today It creates the broken table without schema and important properties and error message as a result:

Delta Table DDL failed with an unexpected error.
This query ran against the ‘delta_gold’ database, unless qualified by the query. Please post the error message on our forum  or contact customer support  with Query ID: 47ea72b9-2b59-4ae0-8b82-dd0520715c1a
  • jgabriel
    3 years ago

    Facing exactly the same problem, starting today.

  • rePost-User-5816474
    3 years ago

    I also started suddenly having troubles with delta tables on Nov 3rd. I became unable to make new tables, but old ones stayed functional. If I drop the old tables and make a new one to the same table in S3, it will stop working despite the table not changing. Wondering if anyone has any updates on this? Working in us-east-1

  • Felipe Leite
    3 years ago

    I have the same problem on us-east-1. Changing to us-east-2 I had no problems creating new tables or performing a show create table

  • Zach
    3 years ago

    I am having the exact same issue. We can't create new delta tables or generate DDL on existing ones. Opened a support case and was told the Athena team is aware this is an issue.

Topics
Analytics
Tags
Amazon Athena
Language
English

asked 3 years ago1.4K views

3 Answers
1

I'm experiencing exactly the same issue now.

answered 3 years ago

1

Me too -- trying to execute the query from a lambda fails with "unknown error". The athena, s3, and glue clients are all instantiated with an access token belonging to a root admin.

Retrying the query from AWS console simply works...

answered 3 years ago

-1
Accepted Answer

I haven't heard back yet, but this morning my team is not having this issue with Delta Tables on Athena anymore.

answered 3 years ago

  • dytyniak
    3 years ago

    You are right, worked on my side as well. Thanks.

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.

Relevant content