Athena reorder / rename Iceberg Table Column fails in Management Console

0

When excuting this sql in the AWS Management Console / Athena Query Editor

ALTER TABLE iceberg_table CHANGE COLUMN comment blog_comment string AFTER id

it should allow for renaming/reordering/retyping of a column. But if I execute this athena, it always fails with

mismatched input 'CHANGE'. Expecting: '.', 'ADD', 'DROP', 'EXECUTE', 'RENAME', 'SET'

If I execute the same thing via the aws cli from my local env, everything works as expected.

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