I am trying to connect using dbvisualizer it always throws error message saying illegal hadoop version my hdp is 2.6.x and hive is 0.14 , i have all the jar files coming from my unix installation box.
I like to use SQL Workbench/J. We use this tool for querying Amazon Redshift and Phoenix also. It's free and I haven't had any problems with it. I tried SQuirreL, but it was finicky and didn't like it much. Haven't tried DBVisualizer.