- Le plus récent
- Le plus de votes
- La plupart des commentaires
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.
Contenus pertinents
- demandé il y a un an
- demandé il y a 7 mois
- demandé il y a 2 mois
- AWS OFFICIELA mis à jour il y a 3 ans