phoenix驱动操作hbase

 

$ sqlline.py localhost

 

0: jdbc:phoenix:localhost> !tables

 

0: jdbc:phoenix:localhost> create table test02(id INTEGER not null, age INTEGER not null, CONSTRAINT my_pk PRIMARY KEY (id, age))

 

 注：通过建立主键对应hbase中的rowkey

 

0: jdbc:phoenix:localhost> !columns TEST02

 

0: jdbc:phoenix:localhost> UPSERT INTO TEST02 VALUES(1, 23)

 

0: jdbc:phoenix:localhost> select * from TEST02;

 

alter table TEST02 add sex varchar(10);

 

0: jdbc:phoenix:localhost> DELETE FROM TEST02 WHERE ID = 1;

 

0: jdbc:phoenix:localhost> DROP TABLE TEST02;

 

链接：

phoenix官网;

phoenix installation;

phoenix datatypes;