Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Is there any way we can use the MERGE statement in Hive with External Tables ?

Is there any way we can use the MERGE statement in Hive with External Tables ?

New Contributor

I want to use the MERGE statement on an external table that we have in our data warehouse. However, the transactional table property cannot be set on an external table and thus I am not able to run any MERGE queries. Is there any workaround for this ?

1 REPLY 1
Highlighted

Re: Is there any way we can use the MERGE statement in Hive with External Tables ?

@Abhay Kasturia There is no workaround. Merge requires ACID and ACID is only supported for Hive managed tables.

Don't have an account?
Coming from Hortonworks? Activate your account here