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.

Using Hive MERGE with Hive 1.2 on HDP 2.6.5

Using Hive MERGE with Hive 1.2 on HDP 2.6.5

New Contributor

Can the MERGE DML feature added to Hive 1.2 on HDP 2.6.5 be used on Production.

The following blog shows benchmarks that seem to be from Hive2 Interactive with LLAP
https://hortonworks.com/blog/apache-hive-moving-beyond-analytics-offload-with-sql-merge/

However I wanted to understand if the same feature could be used with Hive 1.2, of course under performance limitations that are there with Hive 1.2. I also wanted to hear about use cases where the same is being used on Production.

2 REPLIES 2
Highlighted

Re: Using Hive MERGE with Hive 1.2 on HDP 2.6.5

@Abhishek Gupta

Hive Merge is available from Hive 2.2 [Details]. Back port the feature to Hive 1.2.1 would be a challenge, since it includes many changes related to ACID, transactions etc.. You could use Hive Merge on Hive 2.1 without LLAP as well with hive.llap.execution.mode=none [Property details].

Hope this is helpful.

Re: Using Hive MERGE with Hive 1.2 on HDP 2.6.5

New Contributor

Hi @Sindhu

I am not able to get Hive2 Interactive to start on HDP 2.6.5, I have provided the details about my setup and issues I am facing in this post https://community.hortonworks.com/questions/231690/hive2-interactive-llap-fails-to-start.html

Also, I did try the MERGE feature on Hive 1.2 after reading the comments on this blog https://hortonworks.com/blog/apache-hive-moving-beyond-analytics-offload-with-sql-merge/and it did work on Hive 1.2

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