SQuirreL connection phoenix installation configuration

Reference link: http://phoenix.apache.org/installation.html#SQL_Client

Windows connects to hbase on linux servers

Download the installation file: squirrel-sql-3.8.1-standard.jar (my directory is C:\Users\29126\Downloads)

Install C:\Users\29126\Downloads>java -jar squirrel-sql-3.8.1-standard.jar (my installation directory selection is: F:\software\squirrel-sql-3.8.1)

Copy jar

Copy phoenix-core-5.0.0-alpha-HBase-2.0.jar from Phoenix's lib directory, phoenix-5.0.0-alpha-HBase-2.0-client.jar to squirrel's lib directory (Java program uses phoenix-core-5.0.0-alpha-HBase-2.0.jar to connect, so put it in, but the document does not say to put this jar)

Open the software and configure the driver

New driver directory configuration is as follows

name: phoenix_diver

example url: jdbc:phoenix: 192.168.50.107 (can also be configured arbitrarily, the latter alias will use this as the default value)

class name: org. apache.phoenix.jdbc.PhoenixDriver

configuration alias:

name: rhel_phoenix

Driver: phoenix_diver

URL: jdbc:phoenix: 192.168.50.107 (Note: 192.168.50.107 here is the IP of zookeeper, and port 2181 of zookeeper is omitted here.) Phoenix and hbase are connected via zookeeper)

Enter your username and password

Then test,connect.