Support Questions
Find answers, ask questions, and share your expertise

How to use hiveserver2 from Hive Views

Explorer

I am on HDP 2.6.1.0 and Ambari shows that Hiveserver2 is up and running. I created tables and ran querys via Hive View and everything was fine.

Now I wanted to optimize my table and saw I was using Hiveserver 1.2 all the time (see screenshot).

How can I make the Hive View use Hiveserver2?

38433-hiveserver.jpg

2 REPLIES 2

Explorer

I even have the same problem when i create the table using beeline and following connection string:

jdbc:hive2://XYZ:2181/;serviceDiscoveryMode=zooKeeper;zooKeeperNamespace=hiveserver2

When I then go back to Hive View, I see the same error.

Guru