Support Questions

Find answers, ask questions, and share your expertise

Where is Hive View on HDP 3 ?

avatar
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

avatar
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

23 REPLIES 23

avatar
Contributor

hi wxu, any update regarding hive view replacement solution?

avatar
Contributor

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

avatar
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

avatar
New Contributor

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

avatar
New Contributor

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

avatar
Explorer

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

avatar
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!

avatar
Expert Contributor

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

avatar
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.

avatar
Expert Contributor

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.