Started using HDP 3.0.1. Past version I was used is 2.6.5, therefore I found many changes, new Ambari design, hive command starts beeline and so one.
One major change to me, hive view has been deleted since HDP 3.0.
https://community.hortonworks.com/questions/202444/where-is-hive-view-on-hdp-3.html
Tried
Data Analytics Studio instead of that.
You can move the page by
Ambari → Services → Data Analytics Studio → Data Analytics Studio UI
http://sandbox-hdp.hortonworks.com:30800
I guess it's BI tool from the name, but it seems the DBA tool. It has 4 components.
1. Queries
You can see query history. And Recommendations tab gives us suggested changes.
 |
Queries |
 |
Recommendations |
 |
Query Details |
 |
Visual Explain |
 |
Configs |
 |
Timeline |
 |
DAG Info |
2. Compose
This is almost the same as class hive view. We can use auto suggest.
 |
Compose |
3. Database
Partitions tab shows column name, column type and a comment if the table is partitioned. I want to see partition's numbers, size and so on.
 |
Columns |
 |
Partitions |
 |
Storage Information |
 |
Detailed Information |
 |
Statistics |
 |
Data Preview |
4. Reports
This page visualizes lineage from the query history. It looks really useful.
 |
Reports |
 |
Read and Write Report |
 |
Join Report |
No comments:
Post a Comment