Can we delete the column of the table in Athena

Hello.

Deletion itself is possible.
You can do this by following the steps in the document below, but be careful as deleting columns may break the schema.
https://docs.aws.amazon.com/athena/latest/ug/types-of-updates.html#updates-removing-columns