HBase集成Phoenix创建二级索引

在官网http://www.apache.org/dyn/closer.lua/phoenix/中选择提供的镜像站点中下载与安装的HBase版本对应的版本。本地使用的1.2.5，故下载的apache-phoenix-4.11.0-HBase-1.2/的tar.gz包。

tar -zxvf apache-phoenix-4.13.1-HBase-1.2-bin.tar.gz
mv apache-phoenix-4.13.1-HBase-1.2-bin.tar.gz phoenix

cp phoenix-core-4.13.1-HBase-1.2.jar /mnt/hbase/lib/
scp phoenix-core-4.13.1-HBase-1.2.jar slave01:/mnt/hbase/lib/
scp phoenix-core-4.13.1-HBase-1.2.jar slave02:/mnt/hbase/lib/
cp phoenix-4.13.1-HBase-1.2-server.jar /mnt/hbase/lib/
scp phoenix-4.13.1-HBase-1.2-server.jar slave02:/mnt/hbase/lib/
scp phoenix-4.13.1-HBase-1.2-server.jar slave01:/mnt/hbase/lib/

start-hbase.sh

# 进入phoenix下的bin目录
cd phoenix/bin
# 用python2.x启动
python2 sqlline.py matser

0: jdbc:phoenix:master> create table user(id varchar primary key,name varchar,age varchar,phone varchar,email varchar);
No rows affected (1.47 seconds)

upsert into user values(‘1001‘,‘caocao‘,‘26‘,‘13800000000‘,‘caocao@163.com‘);
upsert into user values(‘1002‘,‘liubei‘,‘24‘,‘13800000001‘,‘liubei@163.com‘);
upsert into user values(‘1003‘,‘guanyu‘,‘23‘,‘13800000002‘,‘guanyu@163.com‘);
upsert into user values(‘1004‘,‘zhangfei‘,‘22‘,‘13800000003‘,‘zhangfei@163.com‘);
upsert into user values(‘1005‘,‘sunquan‘,‘20‘,‘13800000004‘,‘sunquan@163.com‘);