網上有不少文章,但基本都不行,主要還是hbase版本和phoenix版本的問題,經我測試,如下方法保證能連接成功。
1、下載phoenix:
https://phoenix.apache.org/download.html
要選擇和你的hbase版本對應的版本。
2、解壓phoenix-hbase-2.4-5.2.1-bin.tar.gz
3、復制 cp phoenix-server-hbase-2.4-5.2.1.jar /opt/datasophon/hbase/lib/
4、重啟hbase
5、驗證一下,如:
[root@dmp-mng-svr1 phoenix-hbase-2.4-5.2.1-bin]# bin/sqlline.py localhost:2181
sqlline version 1.9.0
0: jdbc:phoenix:localhost:2181> !tables
+-----------+-------------+------------+--------------+---------+-----------+---------------------------+------+
| TABLE_CAT | TABLE_SCHEM | TABLE_NAME | TABLE_TYPE | REMARKS | TYPE_NAME | SELF_REFERENCING_COL_NAME | REF_ |
+-----------+-------------+------------+--------------+---------+-----------+---------------------------+------+
| | SYSTEM | CATALOG | SYSTEM TABLE | | | | |
| | SYSTEM | CHILD_LINK | SYSTEM TABLE | | | | |
| | SYSTEM | FUNCTION | SYSTEM TABLE | | | | |
| | SYSTEM | LOG | SYSTEM TABLE | | | | |
| | SYSTEM | MUTEX | SYSTEM TABLE | | | | |
| | SYSTEM | SEQUENCE | SYSTEM TABLE | | | | |
| | SYSTEM | STATS | SYSTEM TABLE | | | | |
| | SYSTEM | TASK | SYSTEM TABLE | | | | |
| | SYSTEM | TRANSFORM | SYSTEM TABLE | | | | |
+-----------+-------------+------------+--------------+---------+-----------+---------------------------+------+
0: jdbc:phoenix:localhost:2181>
CRT+D退出
6、下載客戶端,放在dbeaver 驅動
這里要注意和你的服務端,hbase的版本都一致,否則會出錯,如我的:
https://repo1.maven.org/maven2/org/apache/phoenix/phoenix-client-hbase-2.4/5.1.2/phoenix-client-hbase-2.4-5.1.2.jar
url模板:jdbc:phoenix:{host}[:{port}]/hbase
測試一下,恭喜你,連接成功!!!