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
Highlighted

Re: Where is Hive View on HDP 3 ?

hi wxu, any update regarding hive view replacement solution?

Highlighted

Re: Where is Hive View on HDP 3 ?

Contributor

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

Highlighted

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

View solution in original post

Highlighted

Re: Where is Hive View on HDP 3 ?

New Contributor

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

Highlighted

Re: Where is Hive View on HDP 3 ?

New Contributor

hi @wxu  please update with alternative of hive view in ambari

Highlighted

Re: Where is Hive View on HDP 3 ?

Explorer

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

Highlighted

Re: Where is Hive View on HDP 3 ?

Explorer

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!

Highlighted

Re: Where is Hive View on HDP 3 ?

Rising Star

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

Highlighted

Re: Where is Hive View on HDP 3 ?

Explorer

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 ?

Rising Star

At the time of my comment the source wasn't available and you had to have a support contract to get it. It still doesn't appear there is a way to get the installation without a support contract. However after the merger Cloudera's Data Science Workbench looks very intersting.

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