使用客户端工具DBeaver连接Phoenix

1. 新建连接

   在左边导航区域点击鼠标右键选择新建连接
   

2. 选择连接类型Phoenix
   

3. 设置驱动
   

4. 添加jar包

   注意：

   1. DBeaver上下载的jar无法连接成功。
   2. 需在安装Phoenix的服务器下载phoenix-4.14.0-cdh5.12.2-client.jar

      root@bigdata-dev-41:/opt/cloudera/parcels/APACHE_PHOENIX/lib/phoenix# pwd
      /opt/cloudera/parcels/APACHE_PHOENIX/lib/phoenix
      root@bigdata-dev-41:/opt/cloudera/parcels/APACHE_PHOENIX/lib/phoenix# ll
      total 316480
      drwxr-xr-x 6 root root      4096 Apr 18 12:13 ./
      drwxr-xr-x 3 root root      4096 Apr 18 12:13 ../
      drwxr-xr-x 3 root root      4096 Apr 18 15:10 bin/
      drwxr-xr-x 3 root root      4096 Apr 18 12:13 dev/
      drwxr-xr-x 3 root root      4096 Apr 18 12:13 examples/
      drwxr-xr-x 2 root root      4096 Apr 18 12:13 lib/
      -rw-r--r-- 1 root root 170794941 Jun  5  2018 phoenix-4.14.0-cdh5.12.2-client.jar
      -rw-r--r-- 1 root root  77541123 Jun  5  2018 phoenix-4.14.0-cdh5.12.2-hive.jar
      -rw-r--r-- 1 root root   7138747 Jun  5  2018 phoenix-4.14.0-cdh5.12.2-queryserver.jar
      -rw-r--r-- 1 root root  39216558 Jun  5  2018 phoenix-4.14.0-cdh5.12.2-server.jar
      -rw-r--r-- 1 root root  29344301 Jun  5  2018 phoenix-4.14.0-cdh5.12.2-thin-client.jar
      

   3. 下载Hbase的客户端配置并解压，使用压缩软件打开phoenix-4.14.0-cdh5.12.2-client.jar包，将hbase-site.xml放入phoenix-4.14.0-cdh5.12.2-client.jar中
      
      

5. 测试连接
   
   

6. Phoenix语法

   参见 https://phoenix.apache.org/language/index.html