Unable to delete a partition on Athena Table


I am running a simple drop partition query on a table which is partitioned on 3 columns - Load_date_string, mid, transaction_date in that order. Alter table Table_name drop partition (load_date_string = '2022-12-14 181434.139')

Enter image description here

asked a year ago618 views
1 Answer

I could see that you are trying to drop a partition in your query. As a general guidance, error in such scenarios come mostly due to the following reason.

1-> Please check if you are running this query in a table or view. i.e if "s4_gateway_transaction_base_tab_new" is a view or table.

2-> If "s4_gateway_transaction_base_tab_new" is a view, then partitions cant be deleted from view, since Athena doesn’t treat views as partitioned, a view is a logical table not a physical one.

3-> If "s4_gateway_transaction_base_tab_new" is a table, then you can check if the partition you are trying to drop exits or not, for this you can do a show partition query on the table, or you can even look that at the left side of the pane, it should be visible under table name.

4-> It could be an intermittent issue, please try to re run the query once.

answered a year ago
reviewed a year ago

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