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 |