常用的HBase命令
进入HBase shell:hbase shell
退出HBase shell:exit
SRE实战 互联网时代守护先锋,助力企业售后服务体系运筹帷幄!一键直达领取阿里云限量特价优惠。查看HBase中所有的表:list
查看某个表中的记录总数:count 'table name'
查看某个表中的全部信息:scan 'table name'
创建表,命令格式:create '表名称','列族名称1','列族名称2','列族名称N',创建一个表名称为users,列族名称为id和sex的表:
hbase(main):004:0> create 'users','id','sex'
0 row(s) in 1.2820 seconds
=> Hbase::Table - users
查看表结构,命令格式:describe '表名称',如下:
hbase(main):010:0> describe 'users'
Table users is ENABLED
users
COLUMN FAMILIES DESCRIPTION
{NAME => 'id', BLOOMFILTER => 'ROW', VERSIONS => '1', IN_MEMORY => 'false', KEEP_DELETED_CELLS => 'F
ALSE', DATA_BLOCK_ENCODING => 'NONE', TTL => 'FOREVER', COMPRESSION => 'NONE', MIN_VERSIONS => '0',
BLOCKCACHE => 'true', BLOCKSIZE => '65536', REPLICATION_SCOPE => '0'} {NAME => 'sex', BLOOMFILTER => 'ROW', VERSIONS => '1', IN_MEMORY => 'false', KEEP_DELETED_CELLS => ' FALSE', DATA_BLOCK_ENCODING => 'NONE', TTL => 'FOREVER', COMPRESSION => 'NONE', MIN_VERSIONS => '0', BLOCKCACHE => 'true', BLOCKSIZE => '65536', REPLICATION_SCOPE => '0'} 2 row(s) in 0.0190 seconds
向表中插入数据,命令格式:put '表名称','行名称','列族名称'(列族只有一列的情况)或 put '表名称','行名称','列族名称:列名称'(列族多列的情况),如下:
hbase(main):011:0> put 'users','001','sex:info','male' 0 row(s) in 0.0100 seconds
插入结果为:
hbase(main):012:0> scan 'users'
ROW COLUMN+CELL 001 column=sex:info, timestamp=1554882308361, value=male 1 row(s) in 0.0100 seconds
继续插入:
hbase(main):013:0> put 'users','001','id','001' 0 row(s) in 0.0050 seconds
查询结果为:
hbase(main):014:0> scan 'users'
ROW COLUMN+CELL 001 column=id:, timestamp=1554882816082, value=001 001 column=sex:info, timestamp=1554882308361, value=male 1 row(s) in 0.0050 seconds
继续插入:
hbase(main):016:0> put 'users','002','sex:num','1'
0 row(s) in 0.0050 seconds
hbase(main):017:0> put 'users','001','sex:num','0'
0 row(s) in 0.0040 seconds hbase(main):018:0> put 'users','002','id','002' 0 row(s) in 0.0050 seconds
查询结果为:
hbase(main):019:0> scan 'users'
ROW COLUMN+CELL 001 column=id:, timestamp=1554882816082, value=001 001 column=sex:info, timestamp=1554882308361, value=male 001 column=sex:num, timestamp=1554883284741, value=0 002 column=id:, timestamp=1554883308366, value=002 002 column=sex:num, timestamp=1554883260287, value=1 2 row(s) in 0.0050 seconds

更多精彩