If this happens, move the phoenix-client jar out of the lib folder to an external location. I have noticed that in some cases loading the jar file can hang. Pick “.PhoenixDriver” as the driver class once the jar file finishes loading. Once all of these files are in place, create a new driver using the phoenix-client jar as the source for the driver. Place these files into the resources folder of your DBVisualizer installation. If you are working on a secure cluster, you will need to include three configuration files from the cluster Place both of these jars into the lib folder of your DBVisualizer installation. usr/hdp/current/hbase-client/lib/hbase-client.jar usr/hdp/current/phoenix-client/phoenix-client.jar In order to do so you will need to obtain the driver jars from your cluster. The first step when using DBVisualizer is to create a new database driver for Phoenix.
Your cluster may have slightly different paths and ports being used.
DBVISUALIZER UBUNTU INSTALL
This article is based on an install of Hortonworks Data Platform (HDP) 2.3.2. Instead, it allows users to continue to use a database tool and language with which they are already familiar. It is a solution to allowing more users access to the benefits of HBase without the steep learning curve of a new tool. Phoenix is a layer over HBase which provides SQL-like accessibility to the data stored within HBase.