hbase shell

# 或

bin/hbase shell

help

list

create 'user','basicinfo'

desc 'user'

# 语法为： put 表名,rowkey,列簇:列,值

#插入一条数据

put 'user','1001','basicinfo:name','roy'

put 'user','1001','basicinfo:age',18

put 'user','1001','basicinfo:salary',10000

#插入第二条数据

 put 'user','1002','basicinfo:name','sophia'

 put 'user','1002','basicinfo:sex','female'

 put 'user','1002','basicinfo:job','manager'

#插入第三条数据

put 'user','1003','basicinfo:name','yula'

put 'user','1003','basicinfo:school','phz school'

#可以查看所有列

get 'user','1001'

#查看指定列

get 'user','1001','basicinfo:name'

#查询整表数据

scan 'user'

scan 'user',{COLUMN=>'basicinfo'}

scan 'user',{COLUMN=>'basicinfo:age'}

scan 'user',{STARTROW => '1001',STOPROW => '1002'}

scan 'user',{STARTROW => '1001',STOPROW => '1002',LIMIT=>1}

scan 'user',FILTER=>"ValueFilter(=,'binary:18')"

scan 'user', FILTER=>"ValueFilter(=,'substring:roy')"

scan 'user', FILTER=>"ColumnPrefixFilter('age')"

count 'user'

help 'get'

help 'scan'

delete 'user','1002','basicinfo:sex'

deleteall 'user','1003'

truncate 'user'

disable 'user'

drop 'user'

enable 'user'

exists 'user'