部署Hbase + Phoenix，并通过DBeaver连接Phoenix

1.Hbase安装步骤
https://blog.csdn.net/muyingmiao/article/details/103002598
2 Phoenix的安装
2.1 Phoenix 的官网
http://phoenix.apache.org/
2.2 Phoenix 安装文件地址
http://www.apache.org/dyn/closer.lua/phoenix/
https://mirrors.tuna.tsinghua.edu.cn/apache/phoenix/
如果不想自己编译对应的版本， 可以使用官网相应的版本，比如使用CDH5.16.1的，可以选择如下版本：http://www.apache.org/dyn/closer.lua/phoenix/apache-phoenix-4.14.0-cdh5.14.2/bin/apache-phoenix-4.14.0-cdh5.14.2-bin.tar.gz
2.3 Phoenix安装步骤

• Download and expand the latest phoenix-[version]-bin.tar.
• Add the phoenix-[version]-server.jar to the classpath of all HBase region server and master and remove any previous version. An easy way to do this is to copy it into the HBase lib directory (use phoenix-core-[version].jar for Phoenix 3.x)
• Restart HBase.
• Add the phoenix-[version]-client.jar to the classpath of any Phoenix client.（把clinet的jar包添加到海狸）

具体操作如下
2.3.1.下载（CDH环境：Hadoop Hbase + 4.14.0-cdh5.11.2（比如这个版本））
2.3.2.将phoenix的server的依赖包拷贝到hbase的lib下

[hadoop@hadoop002 phoenix]$ cp phoenix-4.14.0-cdh5.14.2-server.jar ../hbase-1.2.0-cdh5.15.1/lib/

2.3.3.修改hbase的hbase-site.xml配置文件，添加如下4个参数

	<property>
        <name>hbase.table.sanity.checks</name>
        <value>false</value>
    </property>
    <property>
        <!-- phoenix支持索引 -->
        <name>hbase.regionserver.wal.codec</name>
        <value>org.apache.hadoop.hbase.regionserver.wal.IndexedWALEditCodec</value>
    </property>
    <property>
        <name>phoenix.schema.isNamespaceMappingEnabled</name>
        <value>true</value>
    </property>
    <property>
        <name>phoenix.schema.mapSystemTablesToNamespace</name>
        <value>true</value>
    </property>

2.3.4.重启Hbase

[hadoop@hadoop002 bin]$ ./stop-hbase.sh 
stopping hbase....................
[hadoop@hadoop002 bin]$ ./start-hbase.sh 
starting master, logging to /home/hadoop/app/hbase-1.2.0-cdh5.15.1//logs/hbase-hadoop-master-hadoop002.out
Java HotSpot(TM) 64-Bit Server VM warning: ignoring option PermSize=128m; support was removed in 8.0
Java HotSpot(TM) 64-Bit Server VM warning: ignoring option MaxPermSize=128m; support was removed in 8.0
hadoop002: starting regionserver, logging to /home/hadoop/app/hbase-1.2.0-cdh5.15.1/bin/../logs/hbase-hadoop-regionserver-hadoop002.out
hadoop002: Java HotSpot(TM) 64-Bit Server VM warning: ignoring option PermSize=128m; support was removed in 8.0
hadoop002: Java HotSpot(TM) 64-Bit Server VM warning: ignoring option MaxPermSize=128m; support was removed in 8.0
[hadoop@hadoop002 bin]$ jps
9874 SecondaryNameNode
21667 QuorumPeerMain
9398 NameNode
17094 HMaster
10151 NodeManager
9513 DataNode
17561 Jps
22780 nacos-server.jar
17404 HRegionServer
10030 ResourceManager
[hadoop@hadoop002 bin]$ 

2.3.5.拷贝Hbase的配置文件hbase-site.xml到phoenix的bin目录下，替换之前phoenix的hbase-site.xml
建议做软连接

[hadoop@hadoop002 bin]$ ln -s /home/hadoop/app/hbase-1.2.0-cdh5.15.1/conf/hbase-site.xml hbase-site.xml
[hadoop@hadoop002 bin]$ ll
total 144
drwxrwxr-x 2 hadoop hadoop    24 Jun  5  2018 argparse-1.4.0
drwxrwxr-x 4 hadoop hadoop    96 Jun  5  2018 config
-rw-rw-r-- 1 hadoop hadoop 32864 Jun  5  2018 daemon.py
-rwxrwxr-x 1 hadoop hadoop  1881 Jun  5  2018 end2endTest.py
-rw-rw-r-- 1 hadoop hadoop  1621 Jun  5  2018 hadoop-metrics2-hbase.properties
-rw-rw-r-- 1 hadoop hadoop  3056 Jun  5  2018 hadoop-metrics2-phoenix.properties
lrwxrwxrwx 1 hadoop hadoop    58 Mar 21 09:30 hbase-site.xml -> /home/hadoop/app/hbase-1.2.0-cdh5.15.1/conf/hbase-site.xml

如果是CDH的HDFS的HA环境的话，要把/etc/hdfs/conf/core-site.xml /etc/hdfs/conf/hdfs-site.xml 两个文件拷贝到bin目录下
2.3.6.phoenix初始化，注意python的版本要用默认的2.7.5

[hadoop@hadoop002 bin]$ ./sqlline.py hadoop002:2181
Setting property: [incremental, false]
Setting property: [isolation, TRANSACTION_READ_COMMITTED]
issuing: !connect jdbc:phoenix:hadoop002:2181 none none org.apache.phoenix.jdbc.PhoenixDriver
Connecting to j