Support Questions
Find answers, ask questions, and share your expertise
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Advanced Search
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 ?

Labels:
abhay_kasturia
New Contributor

Created ‎01-24-2019 06:37 PM

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 ?

Reply
523 Views
0 Kudos
1 REPLY 1
Highlighted

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

SQLShaw
Guru

Created ‎01-24-2019 06:43 PM

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

Reply
448 Views
0 Kudos
Don't have an account?
Register
Coming from Hortonworks? Activate your account here