Athena: Delta Table DDL failed with an unexpected error.


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
  • Facing exactly the same problem, starting today.

  • 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

  • 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

  • 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.

demandé il y a 6 mois554 vues
3 réponses

I'm experiencing exactly the same issue now.

répondu il y a 3 mois

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...

répondu il y a 3 mois
Réponse acceptée

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

répondu il y a 5 mois
  • You are right, worked on my side as well. Thanks.

Vous n'êtes pas connecté. Se connecter pour publier une réponse.

Une bonne réponse répond clairement à la question, contient des commentaires constructifs et encourage le développement professionnel de la personne qui pose la question.

Instructions pour répondre aux questions