delete operation on partitioned table is failing

Question

We have an external partitioned table
and want to perform delete operation on it.
 Is it possible we can perform we delete the data from the external partitioned table?
As per my understanding we can not perform acid operations on external partitioned table.
Table has to be a managed partition table.
The table is in hive EMR

Answer

ACID transactions including Delete operations are supported by EMR V6.1. That should work for external partitioned tables as well. Please check the version and consider upgrading if needed. If you still face issues, please provide error message from the logs.

Reference: https://docs.aws.amazon.com/emr/latest/ReleaseGuide/emr-hive-differences.html

**Reference**: https://docs.aws.amazon.com/emr/latest/ReleaseGuide/emr-hive-differences.html

delete operation on partitioned table is failing

Relevant content