I have a Hortonworks HDP sandbox running inside of a docker container and when I remote into the container and run
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.
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.