connecting dbvisualizer to hive (running on hdp 2.2)

Created by Lester Martin
Apr 10, 2015
1 min read

Nothing makes my blog posts go faster than just pulling together a few links and calling it done.  That's all I have to do on this topic of connecting DbVisualizer with HiveServer2.  Check out David Streever's wiki page HS2 JDBC Client Jars (Hive Server2) to quickly pull together the needed jar files and then surf on over to cyanfr's How I Connected DBVisualizer 9.2.2 on Windows to Hortonwork HiveServer2 page and just jump down to the Create New Custom Driver in DBVisualizer section. 

I'd skip the who "new database folder" section unless your DbVisualizer Connections pane looks far more complicated than mine.  Also, I tested this with DbVisualizer Free 9.1.5 running on Mac connecting with Hive 14 running on an Azure-based HDP 2.2 cluster and all checks out great.

Thanks David and cyanfr!