Hue is a web interface that is used to browse, query (hive, pig or impala) and to visualize data.
For hive, hive shell is available by default that allows to submit query. You can execute the same query in hive query editor that comes with hue.
The main advantages are Hue are:
- Nice interface
- Auto-completion
- Make things easier.
- Querying
- Scheduling job using oozie
- Browse files or folders present in HDFS.
If you want to learn Hadoop, I recommend this Hadoop Certification program by Intellipaat.
Also, check out this video on Hadoop Ecosystem: