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

转载于:https://www.cnblogs.com/codeOfLife/p/7399188.html