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.

Hortonworks HDP v2.6.1 using Hive v1.2.1

Hortonworks HDP v2.6.1 using Hive v1.2.1

New Contributor

I have a Hortonworks HDP sandbox running inside of a docker container and when I remote into the container and run

hive --version

The output is:

Hive 1.2.1000.2.6.1.0-129
Subversion git://c66-slave-38a0b1a6-3/grid/0/jenkins/workspace/HDP-parallel-centos6/SOURCES/hive -r 4c6995c87f30906625e01c28e5e111a53c2e582f
Compiled by jenkins on Wed May 31 03:19:31 UTC 2017
From source with checksum e3ee749ba0a797bb10a7e12265daa82d

Has anyone upgraded hive to version 2.0 or greater with success? I was wondering if you noticed any breaking changes after the upgrade?

If you were successful, if you have any documentation to walk through the upgrade it would be greatly appreciated.

Thank you for your time.

1 REPLY 1

Re: Hortonworks HDP v2.6.1 using Hive v1.2.1

Master Collaborator

HDP 2.6.1 ships with two Hive binaries - 1.x and 2.x. To use the Hive 2.x you will need to enable interactive query through Hive configs. This will enable new Hive service - HiveServer2 Interactive Server. Note that the hive cli is only available on Hive 1, to use Hive 2 you will need to connect using beeline to the Hive Server Interactive JDBC url, the URL will be available on the Hive Config Summary tab once you enable the interactive query. You can find detailed instructions here.

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