Phoenix hbase常用操作 阳光穿透心脏的1/2处 2022-04-24 10:50 277阅读 0赞 **查看所有表** !table **查看表结构** !desc table\_name **创建schema(相当于数据库)** create schema cg; **创建表** create table if not exists cg.company(id bigint primary key,name varchar(20),address varchar(100)); **插入数据** upsert into cg.company(id,name,address) values(20,'xuxiao','德国柏林') upsert into cg.company (id,name,address) values (1, '阿里', '杭州') upsert into cg.company (id,name,address) values (2, '百度', '北京') upsert into cg.company (id,name,address) values (3, '腾讯', '深圳') upsert into cg.company (id,name,address) values (4, '小米', '武汉') upsert into cg.company (id,name,address) values (5 ,'捷越', '北京') upsert into cg.company (id,name,address) values (6, '向前向未来', 'http://www.fowardfuture.com/') **查询插入数据** select \* from cg.company **创建视图** create view cg.view\_user\_all as select \* from cg.company ;
还没有评论,来说两句吧...