What is the latest Hive version available(as of 01/20) and from where I can download the binary?

[#1]

HDP 2.3.4 is currently the latest GA release of HDP and comes with Hive 1.2.1.2.3. You can install this using Ambari 2.2.0

Official steps available in Ambari docs here

Automation to easily install Ambari on test/dev environments available here

[#2]

@Pramit Mitra

If you are just looking for enterprise ready Hive then see this

Link

[#3]

@Pramit Mitra

That link give you access to latest version of Hive.

[#4]

@Ali Bajwa and @Neeraj Sabharwal - Thanks for your quick response! However, please allow me to clarify my requirements - I already have Hadoop cluster with Hive version 0.13. I have recently read the HDP blogpost-(http://hortonworks.com/blog/announcing-apache-hive-0-14/) and now trying to test 0.14 features (ACID property in particular). Therefore I only need the latest version of Hive, not entire Hadoop distribution. Also, I don't want to impact existing version of Hive, I just want an additional Hive version only for my user id. So that, other users are not effected.

When, I looked for the Hive download page (http://www.apache.org/dyn/closer.cgi/hive/), I am not seeing any version called "0.14". Is 1.2.1 is equivalent to 0.14 ? Also, this is Apache download link, therefore can this binary be directly applied to Hortonwork existing distribution? Or do I need to download Hortonworks specific Hive version?

Thanks in advance!

Regards,

Pramit

[#5]

@Pramit Mitra at this point Ambari does not support multiple versions of Hive on the same cluster. Hive 0.13 and 0.14 are old, the latest stable release is 1.2.1. If you want to test ACID, you need to use 1.2.1 as there are important fixes for ACID features. That said, you need to be on HDP 2.3 to take advantage of that. If you download our latest Sandbox, it has Hive 1.2.1 and you can take it for a test drive there.

[#6]

@Pramit Mitra are you still having problems with this? Can you provide your own solution or accept best answer?

[#7 · Accepted solution]

Here is what I did to get this done:

I downloaded Hive-1.2.1 binary from Apache hive repo (http://apache.arvixe.com/hive/hive-1.2.1/) into one of my edge node. Set up local HIVE environment and set HADOOP_USER_CLASSPATH_FIRST=true. This allowed me the switch Hive version on my specific bash_profile setup.

Thanks,

Pramit