I use Aginity at work to connect as a interface for Hive query. It's user friendly interface and utilities makes it one of the best querying tool in market. Creating a new connection profile is very easy and quick. Queries can be saved as a file and also a set of files, so that you can open all at once next time you need it.
What do you dislike?
Export results function works most of the times but has a huge lag. Formatting query works but could be better.
* We monitor all Aginity reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. Validated reviews require the user to submit a screenshot of the product containing their user ID, in order to verify a user is an actual user of the product.