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

jgabriel
7달 전
Facing exactly the same problem, starting today.
tlu
7달 전
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
7달 전
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
7달 전
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.

주제

분석

태그

아마존 Athena

언어

English

dytyniak

질문됨 7달 전610회 조회

3개 답변

최신
최다 투표
가장 많은 댓글

I'm experiencing exactly the same issue now.

wmich

답변함 5달 전

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

Leon

답변함 5달 전

-1

수락된 답변

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

Zach

답변함 7달 전

dytyniak
7달 전
You are right, worked on my side as well. Thanks.

Athena: Delta Table DDL failed with an unexpected error.

관련 콘텐츠