Phoenix的安装和配置
目前最新的Phoenix版本是5.0.0-HBase-2.0,更新有点慢。
可以通过官方链接查看phoenix的最新版本:
http://phoenix.apache.org/download.html
以下步骤为工作笔记整理,共享给需要的人。
开始安装Phoenix运行的必要组件
下载5.0.0-HBase-2.0
wget http://mirror.bit.edu.cn/apache/phoenix/apache-phoenix-5.0.0-HBase-2.0/bin/apache-phoenix-5.0.0-HBase-2.0-bin.tar.gz
tar zxvf apache-phoenix-5.0.0-HBase-2.0-bin.tar.gz
cp -rf apache-phoenix-5.0.0-HBase-2.0-bin /opt/
下载hbase-2.0.0
wget http://archive.apache.org/dist/hbase/2.0.0/hbase-2.0.0-bin.tar.gz
tar zxvf hbase-2.0.0-bin.tar.gz -C /usr/local
安装java环境
yum install java-1.8.0-openjdk* -y
下载hadoop
wget http://archive.apache.org/dist/hadoop/core/hadoop-3.1.2/hadoop-3.1.2.tar.gz
tar zxvf hadoop-3.1.2.tar.gz
cd hadoop-3.1.2/etc/hadoop
cp core-site.xml hdfs-site.xml /opt/apache-phoenix-5.0.0-HBase-2.0-bin/bin/
cd /opt/apache-phoenix-5.0.0-HBase-2.0-bin
cp phoenix-core-5.0.0-HBase-2.0.jar phoenix-5.0.0-HBase-2.0-server.jar /usr/local/hbase-2.0.0/lib/
cp /usr/local/hbase-2.0.0/conf/hbase-site.xml /opt/apache-phoenix-5.0.0-HBase-2.0-bin/bin/
vi /etc/profile,在末尾添加:
export HBASE_HOME=/usr/local/hbase-2.0.0
JAVA_HOME=/usr/lib/jvm/java-1.8.0-openjdk
JAVA_PATH=$JAVA_HOME/bin
JAVA_CLASSPATH=.:$JAVA_HOME/lib/dt.jar:$JAVA_HOME/lib/tools.jar
export JAVA_HOME
export JAVA_PATH
export JAVA_CLASSPATH
export PATH=$HBASE_HOME/bin:$PATH
#phoenix
export PHOENIX_HOME=/opt/apache-phoenix-5.0.0-HBase-2.0-bin
export PHOENIX_CLASSPATH=$PHOENIX_HOME
export PATH=$PATH:$PHOENIX_HOME/bin
修改完成后source一下
source /etc/profile
安装zookeeper
cd /opt
wget https://archive.apache.org/dist/zookeeper/zookeeper-3.4.10/zookeeper-3.4.10.tar.gz
tar zxvf zookeeper-3.4.10.tar.gz -C /usr/local
mv /usr/local/zookeeper-3.4.10/ /usr/local/zookeeper
vi /usr/local/zookeeper/conf/zoo.cfg
tickTime=2000
dataDir=/Usr/local/zookeeper/data
dataLogDir=/Usr/local/zookeeper/logs
clientPort=4180
启动zookeeper
/usr/local/zookeeper/bin/zkServer.sh start
修改配置文件
vi /usr/local/hbase-2.0.0/conf/hbase-site.xml
<configuration>
<property>
<name>hbase.rootdir</name>
<value>file:///opt/hbase-2.0.0</value>
</property>
<property>
<name>hbase.zookeeper.property.dataDir</name>
<value>/opt/zookeeper</value>
</property>
<property>
<name>hbase.regionserver.wal.codec</name>
<value>org.apache.hadoop.hbase.regionserver.wal.IndexedWALEditCodec</value>
</property>
</configuration>
启动hbase
cd /usr/local/hbase-2.0.0/bin
sh start-hbase.sh
cd /opt/apache-phoenix-5.0.0-HBase-2.0-bin/bin/
chmod 777 psql.py
chmod 777 sqlline.py
编辑配置文件
cd /opt/apache-phoenix-5.0.0-HBase-2.0-bin/bin
vi hbase-site.xml
<configuration>
<property>
<name>hbase.rootdir</name>
<value>file:///opt/hbase-2.0.0</value>
</property>
<property>
<name>hbase.zookeeper.property.dataDir</name>
<value>/opt/zookeeper</value>
</property>
<property>
<name>hbase.regionserver.wal.codec</name>
<value>org.apache.hadoop.hbase.regionserver.wal.IndexedWALEditCodec</value>
</property>
<property>
<name>phoenix.queryserver.serialization</name>
<value>JSON</value>
</property>
</configuration>
运行sqlline.py,注意IPADDRESS用内网IP地址
./sqlline.py IPADDRESS:2181
如果要使用8765端口连接,需要启动
cd /opt/apache-phoenix-5.0.0-HBase-2.0-bin/bin
nohup ./queryserver.py > /dev/null &
连接命令 ./sqlline-thin.py localhost:8765