Problems with views

[#1]

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.

[#2]

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.

[#3]

@Larry Wilson

I have a 2.6 single node kerberized cluster but I would think the setup should be the same.
Could you attach here the screenshot of the File view config in the Manage Ambari UI

[#4]

Hi @Larry Wilson

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

[#5]

@Larry Wilson

FYI mine is a single node HDP 2.6 kerberized cluster not a sandbox

Can you upload or what the error in /var/log/hive/hiveserver2.log

[#6]

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

[#7]

hi @Larry Wilson

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.

[#8]

Here is that log file. hive20-view.zip

[#9]

@Larry Wilson

There is a solution for exactly the same issue already posted in HCC have a look at this link

https://community.hortonworks.com/questions/122795/sandbox-cannot-open-a-hive-connection-with-connec...

That should help

[#10]

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.