Where is Hive View on HDP 3 ?

[#1]

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?

[#2]

hi wxu, any update regarding hive view replacement solution?

[#3]

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

[#4 · Accepted solution]

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

[#5]

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

[#6]

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

[#7]

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

[#8]

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!

[#9]

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

[#10]

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.

[#11]

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.