I have the HDP 2.6 sandbox installed. As I am going through the tutorial, I can not get anything to display in the Files view. I have tried this for both the admin and maria_dev accounts. When I try to open the Hive View 2.0, it runs through the checks and give me a "Cannot open a hive connection with connect string" error. I'd love to be able to make it through the tutorial so I can adequately evaluate Hortonworks, but I'm struggling with issues like these that don't seem to be documented and questions asked previously in this community for related issues don't seem to have been answered. Or at least the answers provided do not seem to resolve my issues.
The connect string that Hive View 2.0 is using looks ok, however, the Hive View logs show an underlying error: ava.sql.SQLException: org.apache.hive.jdbc.ZooKeeperHiveClientException: Unable to read HiveServer2 configs from ZooKeeper
Do you have HiveServerHA enabled?
I would start by starting/stopping ZooKeeper, then starting/stopping Hive all from Ambari and trying again. Can you do this and report back results.
It seems I have figured out part of the problem. I had been using Google Chrome. When I changed to use Microsoft Edge, I was able to see the Files View. However, I still get the same error when trying to view the Hive View 2.0.
I just did a fresh download of the 2.6.1 Sandbox for VirtualBox, and was able to use the 'admin' account to load the files view and the hive server 2.0 view without any issues. Do you have the following entry in your system's hosts file?
127.0.0.1 sandbox.hortonworks.com sandbox
As far as the Files View is concerned, I was able to get that to work - using a different browser. It won't work with Google Chrome, but will work with Microsoft Edge. In relation to the Hive View 2 issue, I am attaching my hiveserver2.log.hiveserver2.zip
The error could actually be in the Hive View log, and not necessarily in the hiveserver2 log. You might want to check
/var/log/ambari-server/hive20-view/hive20-view.log to see what the connect string error is and could help point us to the right resolution.
There is a solution for exactly the same issue already posted in HCC have a look at this link
That should help
I had seen that post, but was unable to find in the tutorial the optional prerequisite for installing JDBC. I do see the optional install for the ODBC driver, though.