question Re: Where is Hive View on HDP 3 ? in Support Questions

Where is Hive View on HDP 3 ?

br_gilvan — Sat, 14 Jul 2018 12:29:57 GMT

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?

Re: Where is Hive View on HDP 3 ?

rguruvannagari — Sun, 15 Jul 2018 14:08:13 GMT

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_understanding_ambari_views.html

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_upgrade_hdp3_amb27.html

Re: Where is Hive View on HDP 3 ?

smedoji — Mon, 16 Jul 2018 23:36:42 GMT

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_hive_data_using_superset.html

Re: Where is Hive View on HDP 3 ?

IM_Lipke — Wed, 18 Jul 2018 21:53:38 GMT

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 ?

sweeks — Thu, 19 Jul 2018 20:43:20 GMT

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 ?

wcbdata — Thu, 19 Jul 2018 23:26:06 GMT

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 ?

sweeks — Thu, 19 Jul 2018 23:31:14 GMT

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 ?

wxu — Sat, 21 Jul 2018 01:19:57 GMT

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 ?

djc0604 — Fri, 10 Aug 2018 00:04:31 GMT

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

Re: Where is Hive View on HDP 3 ?

ururu — Fri, 31 Aug 2018 20:58:33 GMT

Do you have some news about hive view alternatives?

Re: Where is Hive View on HDP 3 ?

rahuledavalath — Fri, 28 Sep 2018 18:40:58 GMT

hi wxu, any update regarding hive view replacement solution?

Re: Where is Hive View on HDP 3 ?

djc0604 — Mon, 04 Nov 2019 19:33:50 GMT

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

Re: Where is Hive View on HDP 3 ?

daniel_zafar — Mon, 08 Oct 2018 23:32:10 GMT

@wxu What should I be using to write my Hive scrips in Ambari today?

Re: Where is Hive View on HDP 3 ?

leo_atencio — Mon, 29 Oct 2018 22:17:26 GMT

Incredible. Ambari 2.7 is useless as it is, then. Just ODBC...

Re: Where is Hive View on HDP 3 ?

djc0604 — Mon, 29 Oct 2018 22:46:28 GMT

Hi Leonel, I don't think it is useless. Ambari's purpose is to help the administrator to properly deploy and manage its cluster and each project configuration in a centralized and organized manner. In that purpose, ambari performs as intended.

Personally I never liked HW approach with ambari views as HUE replacement, and in this version, HW has decoupled again administration from end user experience, which makes sense to me.

If you check HW documentation, you will find the new replacement is Data Analytics Studio which is part of Data Plane Services, once again, one could like it or not (but that's probably a different conversation).

You also could use HUE as nothing prevents you to deploy it in your HDP cluster, you could use bigtop's rpms or just build it from source code and set yourself the hui.conf for AD integration, blacklist unused application, connect to hive LLAP, etc. The only issue I've seen so far is that HDP 3.X rpm for httpfs is an empty package and that's the default package used for managing hdfs access when HA is enabled.

Cheers!

Re: Where is Hive View on HDP 3 ?

unchange — Sun, 04 Nov 2018 14:01:03 GMT

Hi All,

I'm rather new to HDP and HUE and was interested in setting HUE up for the search functionality it provides for HDFS with SOLR. With the deprecation of HUE in HDP 3.0 what are the alternative to provide the search functionality? I was researching on Ambari Views but it does not seem to be able to do that.

Hope to find out what other application can we look at for such functionality and if we can still install and setup HUE when its deprecated in HDP3.0

Thanks

Re: Where is Hive View on HDP 3 ?

sweeks — Thu, 08 Nov 2018 03:11:40 GMT

Data Analytics Studio (DAS) however is not open source or free and requires a Hortonworks Subscription.

Re: Where is Hive View on HDP 3 ?

djc0604 — Fri, 09 Nov 2018 05:07:57 GMT

it's available under GNU AGPLv3 license.
https://github.com/hortonworks/dps_platform/tree/DP-1.1.0.0
https://github.com/hortonworks/data_analytics_studio

Superset is still interesting, even if it is not intended to be a hive view replacement.

Re: Where is Hive View on HDP 3 ?

danilosousadba — Tue, 20 Nov 2018 03:04:07 GMT

Hello

I'm a problem with Hive + Superset HDP 3.0.1

When I perform insert with hive / beeline, the insert works normally

When I perform insert with Superset, I't create the job TEZ and the insert execute fast but the process gets stuck. Ater third job start a queue. ( Each job finish about 15 minutes )

Re: Where is Hive View on HDP 3 ?

jdefe81 — Wed, 06 Feb 2019 23:16:42 GMT

When you say it doesn't have all the security features, what do you mean exactly?