phoenix常用命令
1、登录命令
./sqlline.py localhost:2181:/hbase-unsecure
phoenix-sqlline localhost:2181:/hbase-unsecure
2、退出
!quit
!exit
3、帮助
4、列出metadata信息
5、创建表
create table if not exists ljc.student(id integer primary key,name varchar(20));
6、查看当前库中存在的表
!tables
phoenix中的表信息都存在SYSTEM.CATALOG表中，也可以通过下面的sql语句查看系统的表信息
select * from SYSTEM.CATALOG;
注意：
1、如果不加双引号，会自动将小写转为大写
2、phoenix表名区分大小写
7、删除表
drop table ljc.student;
8、查看表结构
!describe "METRIC_AGGREGATE"
注意：
phoenix/hbase对表名、字段名都是大小写敏感，如果直接写小写字母，不加双引号，则默认会被转换成大写字母
9、插入、更新
Phoenix中不存在update的语法关键字，而是upsert ，功能上替代了Insert+update
upsert into ljc.student(id,name) values(1,'zhangsan'); upsert into ljc.student(id,name) values(2,'lisi'); upsert into ljc.student(id,name) values(3,'wangwu'); upsert into ljc.student(id,name) values(4,'liuping'); upsert into ljc.student(id,name) values(5,'zhouhong');
10、示例SQL
create table if not exists ljc.student(id integer primary key,name varchar(20)); upsert into ljc.student(id,name) values(1,'zhangsan'); upsert into ljc.student(id,name) values(2,'lisi'); upsert into ljc.student(id,name) values(3,'wangwu'); upsert into ljc.student(id,name) values(4,'liuping'); upsert into ljc.student(id,name) values(5,'zhouhong'); create table if not exists ljc.score(id integer primary key,score integer); upsert into ljc.score(id,score) values(1,98); upsert into ljc.score(id,score) values(2,87); upsert into ljc.score(id,score) values(3,90); upsert into ljc.score(id,score) values(4,80); upsert into ljc.score(id,score)