Renaming column name in Athena

Question

Normal DDL commands does not affect the table (They cannot be executed). I am trying to change a column name in an AWS Athena table old_name to new_name. Is It possible to change a column name without deleting and re-creating the table from scratch?

Can someone help?

Answer 1

You can use :-

ALTER TABLE %%table-name%% CHANGE %%old-column-name%% %%new-column-name%%<string>;

You can find more about supported and unsupported DDLs here.

Hope this helps