表定义 describe
指令格式：describe 表名
hbase(main):003:0> describe 'tbTest' Table tbTest is ENABLED tbTest COLUMN FAMILIES DESCRIPTION {NAME => 'col-familyA', 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'} {NAME => 'col-familyB', 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'}单元格赋值和更新 put
指令格式：put 表名,行key,列簇+列名,值
hbase(main):006:0> put 'tbTest','10001','col-familyA:name','chy' 0 row(s) in 0.0240 seconds hbase(main):007:0> put 'tbTest','10001','col-familyA:age','21' 0 row(s) in 0.0100 seconds读取行内容 get
指令格式：get 表名,行key
hbase(main):008:0> get 'tbTest','10001' COLUMN CELL col-familyA:age timestamp=1528510968224, value=21 col-familyA:name timestamp=1528510958801, value=chy读取单元格内容 get
指令格式：get 表名,行key,{COLUMN => ‘列簇:列名’}
hbase(main):010:0> get 'tbTest','10001',{COLUMN=>'col-familyA:name'} COLUMN CELL col-familyA:name timestamp=1528510958801, value=chy删除单元格内容 delete
指令格式：delete 表名,行key,列簇+列名,版本(可选)
hbase(main):013:0> get 'tbTest','10001' COLUMN CELL col-familyA:age timestamp=1528510968224, value=21 col-familyA:name timestamp=1528511542284, value=chy2z 2 row(s) in 0.0130 seconds hbase(main):015:0> delete 'tbTest','10001','col-familyA:age',1528510968224 0 row(s) in 0.0620 seconds hbase(main):016:0> get 'tbTest','10001' COLUMN CELL col-familyA:name timestamp=1528511542284, value=chy2z hbase(main):020:0> get 'tbTest','10001' COLUMN CELL col-familyA:name timestamp=1528511542284, value=chy2z 1 row(s) in 0.0090 seconds hbase(main):021:0> delete 'tbTest','10001','col-familyA:name' 0 row(s) in 0.0040 seconds hbase(main):022:0> get 'tbTest','10001' COLUMN CELL 0 row(s) in 0.0060 seconds hbase(main):023:0>删除行所有单元格 deleteall
指令格式：deleteall 表名,行key
hbase(main):030:0> get 'tbTest','10001' COLUMN CELL col-familyA:age timestamp=1528512217440, value=22 col-familyA:name timestamp=1528512204762, value=chy 2 row(s) in 0.0210 seconds hbase(main):031:0> deleteall 'tbTest','10001' 0 row(s) in 0.0110 seconds hbase(main):032:0> get 'tbTest','10001' COLUMN CELL 0 row(s) in 0.0080 seconds显示表格所有数据 scan
指令格式：scan 表名
hbase(main):040:0> scan 'tbTest' ROW COLUMN+CELL 10001 column=col-familyA:age, timestamp=1528512394456, value=21 10001 column=col-familyA:name, timestamp=1528512371369, value=chy 10002 column=col-familyA:name, timestamp=1528512377539, value=chy2计算表格行数 count
指令格式：count 表名
hbase(main):041:0> count 'tbTest' 2 row(s) in 0.0620 seconds禁用删除重新创建表 truncate
指令格式：truncate 表名
hbase(main):042:0> truncate 'tbTest' Truncating 'tbTest' table (it may take a while): - Disabling table... - Truncating table... 0 row(s) in 5.4790 seconds hbase(main):043:0> count 'tbTest' 0 row(s) in 0.1250 seconds
