- 清空表
hbase(main):048:0> truncate 'tmp'
Truncating 'tmp' table (it may take a while):
- Disabling table...
- Truncating table...
0 row(s) in 5.5370 seconds
- 查看表
hbase(main):049:0> desc 'tmp'
Table tmp is ENABLED
tmp
COLUMN FAMILIES DESCRIPTION
{NAME => 'add', DATA_BLOCK_ENCODING => 'NONE', BLOOMFILTER => 'ROW', REPLICATION_SCOPE => '0', COMPRESSION => 'NONE', VERSIONS =>
'1', TTL => 'FOREVER', MIN_VERSIONS => '0', KEEP_DELETED_CELLS => 'FALSE', BLOCKSIZE => '65536', IN_MEMORY => 'false', BLOCKCACHE
=> 'true'}
{NAME => 'col1', DATA_BLOCK_ENCODING => 'NONE', BLOOMFILTER => 'ROW', REPLICATION_SCOPE => '0', VERSIONS => '1', COMPRESSION => 'N
ONE', MIN_VERSIONS => '0', TTL => 'FOREVER', KEEP_DELETED_CELLS => 'FALSE', BLOCKSIZE => '65536', IN_MEMORY => 'false', BLOCKCACHE
=> 'true'}
{NAME => 'col2', DATA_BLOCK_ENCODING => 'NONE', BLOOMFILTER => 'ROW', REPLICATION_SCOPE => '0', VERSIONS => '1', COMPRESSION => 'N
ONE', MIN_VERSIONS => '0', TTL => 'FOREVER', KEEP_DELETED_CELLS => 'FALSE', BLOCKSIZE => '65536', IN_MEMORY => 'false', BLOCKCACHE
=> 'true'}
{NAME => 'col3', DATA_BLOCK_ENCODING => 'NONE', BLOOMFILTER => 'ROW', REPLICATION_SCOPE => '0', COMPRESSION => 'NONE', VERSIONS =>
'1', TTL => 'FOREVER', MIN_VERSIONS => '0', KEEP_DELETED_CELLS => 'FALSE', BLOCKSIZE => '65536', IN_MEMORY => 'false', BLOCKCACHE
=> 'true'}
4 row(s) in 0.0510 seconds
- 插入数据
hbase(main):050:0> put 'tmp','1','col2:birthday','1989'
0 row(s) in 0.2730 seconds
hbase(main):051:0> put 'tmp','1','col2:sex','M'
0 row(s) in 0.0170 seconds
hbase(main):052:0> put 'tmp','1','col2:edu','Master'
0 row(s) in 0.0150 seconds
- 获取数据
hbase(main):053:0> get 'tmp','1'
COLUMN CELL
col2:birthday timestamp=1474960341032, value=1989
col2:edu timestamp=1474960391040, value=Master
col2:sex timestamp=1474960365538, value=M
3 row(s) in 0.0440 seconds
- 插入数据
hbase(main):054:0> put 'tmp','1','col3:province','HeNan'
0 row(s) in 0.0160 seconds
hbase(main):055:0> put 'tmp','1','col3:city','AnYang'
0 row(s) in 0.0200 seconds
hbase(main):056:0> put 'tmp','1','col3:country','China'
0 row(s) in 0.0260 seconds
- 获取数据
hbase(main):057:0> get 'tmp','1'
COLUMN CELL
col2:birthday timestamp=1474960341032, value=1989
col2:edu timestamp=1474960391040, value=Master
col2:sex timestamp=1474960365538, value=M
col3:city timestamp=1474960445073, value=AnYang
col3:country timestamp=1474960469793, value=China
col3:province timestamp=1474960428960, value=HeNan
6 row(s) in 0.0290 seconds
- 获取某一列的数据
hbase(main):058:0> get 'tmp','1','col2'
COLUMN CELL
col2:birthday timestamp=1474960341032, value=1989
col2:edu timestamp=1474960391040, value=Master
col2:sex timestamp=1474960365538, value=M
3 row(s) in 0.0250 seconds
- 扫描整张表
hbase(main):059:0> scan 'tmp'
ROW COLUMN+CELL
1 column=col2:birthday, timestamp=1474960341032, value=1989
1 column=col2:edu, timestamp=1474960391040, value=Master
1 column=col2:sex, timestamp=1474960365538, value=M
1 column=col3:city, timestamp=1474960445073, value=AnYang
1 column=col3:country, timestamp=1474960469793, value=China
1 column=col3:province, timestamp=1474960428960, value=HeNan
1 row(s) in 0.0380 seconds
- 取某列族的某个值
hbase(main):060:0> get 'tmp','1','col2:edu'
COLUMN CELL
col2:edu timestamp=1474960391040, value=Master
1 row(s) in 0.0180 seconds
- 修改数据
hbase(main):061:0> put 'tmp','1','col2:birthday','1990'
0 row(s) in 0.0210 seconds
hbase(main):062:0> scan 'tmp'
ROW COLUMN+CELL
1 column=col2:birthday, timestamp=1474960599264, value=1990
1 column=col2:edu, timestamp=1474960391040, value=Master
1 column=col2:sex, timestamp=1474960365538, value=M
1 column=col3:city, timestamp=1474960445073, value=AnYang
1 column=col3:country, timestamp=1474960469793, value=China
1 column=col3:province, timestamp=1474960428960, value=HeNan
1 row(s) in 0.0460 seconds
hbase(main):063:0> get 'tmp','1','col2:birthday'
COLUMN CELL
col2:birthday timestamp=1474960599264, value=1990
1 row(s) in 0.0170 seconds
- 删除数据
hbase(main):064:0> delete 'tmp','1','col2'
0 row(s) in 0.0700 seconds
hbase(main):065:0> scan 'tmp'
ROW COLUMN+CELL
1 column=col2:birthday, timestamp=1474960599264, value=1990
1 column=col2:edu, timestamp=1474960391040, value=Master
1 column=col2:sex, timestamp=1474960365538, value=M
1 column=col3:city, timestamp=1474960445073, value=AnYang
1 column=col3:country, timestamp=1474960469793, value=China
1 column=col3:province, timestamp=1474960428960, value=HeNan
1 row(s) in 0.0300 seconds
hbase(main):066:0> delete 'tmp','1','col2:birthday'
0 row(s) in 0.0170 seconds
hbase(main):067:0> scan 'tmp'
ROW COLUMN+CELL
1 column=col2:edu, timestamp=1474960391040, value=Master
1 column=col2:sex, timestamp=1474960365538, value=M
1 column=col3:city, timestamp=1474960445073, value=AnYang
1 column=col3:country, timestamp=1474960469793, value=China
1 column=col3:province, timestamp=1474960428960, value=HeNan
1 row(s) in 0.0330 seconds
- 删除某一种
hbase(main):068:0> deleteall 'tmp','1'
0 row(s) in 0.0150 seconds
hbase(main):069:0> scan 'tmp'
ROW COLUMN+CELL
0 row(s) in 0.0270 seconds