By using AWS re:Post, you agree to the Terms of Use

delete operation on partitioned table is failing

0

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

asked 15 days ago19 views
1 Answer
0

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

profile picture
answered 15 days 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