hbase常用操纵操作——增删改查

查询某个资金账户的信息

get 'dmp:hbase_tags','资金账号'

创建表

create 'emp', 'personal data', 'professional data'

 

在HBase表中创建的数据，可以下面的命令和方法：

put 命令
put ’<table name>’,’row1’,’<colfamily:colname>’,’<value>’

hbase(main):005:0> put 'emp','1','personal_data:name','raju'
0 row(s) in 0.6600 seconds
hbase(main):006:0> put 'emp','1','personal_data:city','hyderabad'
0 row(s) in 0.0410 seconds
hbase(main):007:0> put 'emp','1','professional_data:designation','manager'
0 row(s) in 0.0240 seconds
hbase(main):007:0> put 'emp','1','professional_data:salary','50000'
0 row(s) in 0.0240 seconds

查看，获取所有数据

scan 'emp'

查看，获取单条数据信息

get 'table', 'row key'

读取单条的某一列数据

get 'emp','1',{COLUMN=>'personal_data:name'}

更新数据

put ‘table name’,’row ’,'Column family:column name',’new value’

put 'emp','1','personal_data:city','Delhi'

 删除数据，删除某一个“字段”

delete ‘<table name>’, ‘<row>’, ‘<column name >’, ‘<time stamp>’

删除某一行

deleteall ‘<table name>’, ‘<row>’