hbase创建语句

//创建数据表 kb08:命名空间 mobilephone:表名 'huawei/iphone' rowkey  base/price:列族 VERSION:版本

create

create 'kb08:mobilephone',{NAME=>'base',VERSION=>'0'},{NAME=>'price'}

delete 'kb08:mobilephone','huawei','price:resolution'

//查询表结构

desc 'kb08:mobilephone'

//导入数据  huawei:rowkey

put 'kb08:mobilephone','huawei','base:seriesNo','nova4'

put 'kb08:mobilephone','huawei','base:cpu','4c 8ths'

put 'kb08:mobilephone','huawei','base:resolution','1024*768'

put 'kb08:mobilephone','huawei','price:costPrice','1200.00'

put 'kb08:mobilephone','huawei','price:retailPrice','3200.00'

 

put 'kb08:mobilephone','iphone','base:seriesNo','12'

put 'kb08:mobilephone','iphone','base:cpu','4c 8ths'

put 'kb08:mobilephone','iphone','base:resolution','1680*1024'

put 'kb08:mobilephone','iphone','price:costPrice','1200.00'

put 'kb08:mobilephone','iphone','price:retailPrice','4800.00'

//设置别名

mp = get_table 'kb08:mobilephone'

//查看内容

mp.scan

//查询列族

mp.get 'huawei','base:cpu'

//修改列

mp.put 'huawei','base:cpu','8c,16t'

//查看是否被禁用

is_disable/enable 'kb08:mobilephone'

//查看是否存在

exists 'kb08:mobilephone'

//删除一列

mp.delete 'iphone','price:retailPrice'

//删除一个rowkey

mp.deleteall 'iphone'

//禁用

mp.disable

//启用

mp.enable

禁用后才可删除

mp.drop

mp.get 'huawei'

mp.get 'iphone'