In HDP 2.5 Sandbox, I did a quick walk through.
First thing I liked was the Visualization:
The Data Explorer provided a nice query tool to view tables and graphs.
The Data Visualization tab provides some nice graphing capabilities.
After you run your queries you can look at the Tez results to see how it ran, it's a nice way to see what you may need to optimize.
The Hive Ambari View is getting to be a very solid tool for working with Hive. From DDL (creating tables is easy) to viewing data, to updates and inserts.