As you said, Hue is a web interface that allows you to browse, query (hive, pig or impala) and visualizie data.
By default, for hive you are provided a hive shell which is used to submit query.
Now, you can run the same query using hive query editor that comes with hue. Here is the screenshot of that:
Besides nice interface, there are various advantages of using hue. One of the great feature is auto-completion as shown in the image below:
This is the main intention behind developement of hue i.e. to make things easier. Besides querying you can do lot of other stuff like scheduling job using oozie or browse files or folders present in hdfs.
To download hue and get other details about it, you can visit the website: https://gethue.com