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.