Support Questions
Find answers, ask questions, and share your expertise

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 ?

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

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.