- Hbase建表
hbase(main):046:0> create 'LXW','CF'
0 row(s) in 1.2120 seconds
=> Hbase::Table - LXW
hbase(main):047:0> put 'LXW','row1','CF:NAME','lxw'
0 row(s) in 0.0120 seconds
hbase(main):048:0> put 'LXW','row1','CF:AGE','18'
0 row(s) in 0.0080 seconds
hbase(main):049:0> put 'LXW','row1','CF:ADDRESS','BeijingYiZhuang'
0 row(s) in 0.0070 seconds
hbase(main):050:0>
- Phoenix 建视图
0: jdbc:phoenix:localhost:2181> create view lxw(id varchar(200) not null primary key,cf.name varchar(50),cf.age varchar(20) ,cf.address varchar(200));
No rows affected (5.869 seconds)
0: jdbc:phoenix:localhost:2181> select * from lxw;
+-------+-------+------+------------------+
| ID | NAME | AGE | ADDRESS |
+-------+-------+------+------------------+
| row1 | lxw | 18 | BeijingYiZhuang |
+-------+-------+------+------------------+
1 row selected (0.228 seconds)
0: jdbc:phoenix:localhost:2181>
如上所示,建的视图可以显示hbase中put的数据