Hue
Hue (see http://gethue.com/) is short for Hadoop User Experience. It is a web interface for making the Hadoop ecosystem easier to use. For Hive users, Hue offers a unified web interface for easily accessing both HDFS and Hive in an interactive environment. Hue can be installed alone or with the Hadoop vendor packages. In addition, Hue adds more programming-friendly features to Hive, such as the following:
Highlights HQL keywords
Autocompletes HQL query
Offers live progress and logs for Hive and MapReduce jobs
Submits several queries and checks progress later
Browses data in Hive tables through a web user interface
Navigates through the metadata
Registers UDF and adds files/archives through a web user interface
Saves, exports, and shares the query result
Creates various charts from the query result
The following is a screenshot of the Hive editor interface in Hue: