安装步骤
- 首先进入容器
docker exec -it e16782e1e69c /bin/bash
- 安装apache phoenix 需要准备 phoenix 以及python
wget https://archive.apache.org/dist/phoenix/apache-phoenix-4.13.1-HBase-1.3/bin/apache-phoenix-4.13.1-HBase-1.3-bin.tar.gz
apk add --no-cache python
3. 集成apache phoenix
tar -xzvf apache-phoenix-4.13.1-HBase-1.3-bin.tar.gz
cp apache-phoenix-4.13.1-HBase-1.3-bin/phoenix-4.13.1-HBase-1.3-server.jar hbase-1.3.2/lib/
./bin/stop-hbase.sh
./bin/start-hbase.sh
- apache phoenix 试用
cd apache-phoenix-4.13.1-HBase-1.3-bin/bin/
./sqlline.py
- 使用phoenix进行curd
create table userinfo(name varchar,age integer not null primary key);
upsert into userinfo(name,age) values('dalong',1);
select * from userinfo;
delete from userinfo where age=1;
alter table userinfo add version varchar;
alter table userinfo drop COLUMN version;
注意:
(1)插入值如果是字符串要用单引号引起来,切记不能用双引号!!!
(2)表名如果要体现小写效果,必须要用双引号!!!
upsert into "person" values (1, 'test', 100); 正确
upsert into "person" values (1, "test", 100); 错误