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.

How to use Hive 2.1 on HDP 2.6.4 ?

How to use Hive 2.1 on HDP 2.6.4 ?

New Contributor

Hi,

I am trying to create a table with a primary key in Hive, adding a primary key constraint was a feature which was introduced in Hive 2.1. I am using HDP 2.6.4 and have already enabled interactive query in hive config, which has enabled Hive 2.0 view.

I am only using Hive 2.0 view for all the query tests.

When I run the version check command in the remote shell box, I see that the hive version is still 1.2, which is the same version shown in the "Stacks and Versions" tab on the Ambari page.

Is there any way to use the Hive 2.1 on HDP 2.6.4?

,

Hi, I tried using some of the features introduced in Hive 2.1 and could not use it with HDp 2.6.4. On checking the hive version in the remote shell box, I can see that the Hive version is still showing as 1.2.

I have already enabled Interactive query and I am trying the new hive features in Hive 2.0 view, but it still fails to run the commands.

Does anybody know a solution to change the Hive version on the HDP?

2 REPLIES 2

Re: How to use Hive 2.1 on HDP 2.6.4 ?

Master Collaborator

Can you verify that the setup for View is correct? Check the following doc:

https://docs.hortonworks.com/HDPDocuments/Ambari-2.6.1.5/bk_ambari-views/content/settings_and_cluste...

Pay close attention to the "HiveServer2 JDBC URL" parameter, it should be pointing to the JDBC URL for the HSI, typically that URL will contain the string "zooKeeperNamespace=hiveserver2-hive2"

Re: How to use Hive 2.1 on HDP 2.6.4 ?

New Contributor

I am using HDP 2.6.3 and enabled LLAP but HvieServer2 Interactive service is not running.

Please advice in this regard.

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