I am on HDP 22.214.171.124 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?
I even have the same problem when i create the table using beeline and following connection string:
When I then go back to Hive View, I see the same error.
Be sure to follow these directions when setting up your Hive View https://docs.hortonworks.com/HDPDocuments/Ambari-126.96.36.199/bk_ambari-views/content/settings_and_cluste...