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.

Where is Hive View on HDP 3 ?

Solved Go to solution

Where is Hive View on HDP 3 ?

New Contributor

I can't to find the Hive View on HDP 3, and i didn't to find any information about this on documentation.

What I use to replace the Hive View on HDP 3?

1 ACCEPTED SOLUTION

Accepted Solutions

Re: Where is Hive View on HDP 3 ?

Explorer

I think the answer is DAS (Data Analytics Studio), which is part of DPS (Data Plane Services). Check this blog post: https://www.cloudera.com/tutorials/loading-and-querying-data-with-data-analytics-studio.html

21 REPLIES 21
Highlighted

Re: Where is Hive View on HDP 3 ?

Super Collaborator

It looks that Ambari 2.7.0 only includes YARN,FILES,SMARTSENSE and WFM views.

https://docs.hortonworks.com/HDPDocuments/Ambari-2.7.0.0/administering-ambari-views/content/amb_unde...

I dont see any Jira related to hive view being removed from Ambari 2.7.0 version. Below jira gives a clue about Ambari Hive view 2.0 being removed.

https://issues.apache.org/jira/browse/AMBARI-23742

Additional reference from Ambari upgrade docs.

https://docs.hortonworks.com/HDPDocuments/Ambari-2.7.0.0/bk_ambari-upgrade/content/bhvr_changes_upgr...

Re: Where is Hive View on HDP 3 ?

New Contributor

Hive View is not present in HDP 3.0 or Ambari 2.7. Instead we have Superset service to access Hive. Details of it can be found here - https://docs.hortonworks.com/HDPDocuments/HDP3/HDP-3.0.0/integrating-hive/content/hive_visualizing_h...

Re: Where is Hive View on HDP 3 ?

Explorer

Apache Superset is a technical preview in HDP 3.0

- Really!? Why is Hortonworks always removing every good way to easily use the platform; Hue - removed; Ugly-Ambari-View - removed; What next? Removing Superset again?!

Re: Where is Hive View on HDP 3 ?

Rising Star

Superset also doesn't appear to work with Kerberos or Hive HTTP Transport so it's really not a replacement. We're going to have to wait to upgrade until Hortonworks can provided a suitable replacement for browsing Hive via web browser.

Re: Where is Hive View on HDP 3 ?

Rising Star

For the moment, Zeppelin can be a functional replacement, and many issues/features for Zeppelin/Livy/Hive have been addressed in 3.0 as well!

https://docs.hortonworks.com/HDPDocuments/HDP3/HDP-3.0.0/release-notes/hdp-release-notes.pdf

Re: Where is Hive View on HDP 3 ?

Rising Star

Some functionality is there but the ability to browse the hive structure in a visual fashion is gone and some capability like viewing the applicable Ranger policies aren’t possible from jdbc. Definitely a step backwards no matter what.

Re: Where is Hive View on HDP 3 ?

New Contributor

Hi, I'm the product manager of Hive view. Due to technical limitations we are not able to transition Hive view into HDP 3.0 platform. I'll provide details in the next few weeks with a replacement solution.

Superset is still in tech preview so it doesn't have all the security features for production yet. It's NOT a replacement for Hive view.

Re: Where is Hive View on HDP 3 ?

Explorer

Hi @wxu do you have news on this topic? Thanks!

Re: Where is Hive View on HDP 3 ?

Expert Contributor

Do you have some news about hive view alternatives?

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