Hbase的常用shell操作

2019-11-08 21:00:13

字体：大中小

来源：转载

供稿：网友

1.进入hbase的shell界面：[root@lijie bin]# ./hbase shell2.创建表hbase(main):002:0> create 'tablename','cf1','cf2'0 row(s) in 0.5830 seconds=> Hbase::Table - tablename3.列出所有表hbase(main):003:0> listTABLE stu t1 tablename 3 row(s) in 0.0100 seconds=> ["stu", "t1", "tablename"]4.插入数据hbase(main):005:0> put 'tablename','rowkey01','cf1:name','lijie'0 row(s) in 0.0570 secondshbase(main):006:0> put 'tablename','rowkey01','cf1:addr','chongqing'0 row(s) in 0.0070 seconds5.查看表的所有数据hbase(main):012:0> scan 'tablename'ROW COLUMN+CELL rowkey01 column=cf1:addr, timestamp=1486547683853, value=chongqing rowkey01 column=cf1:name, timestamp=1486547607486, value=lijie rowkey02 column=cf1:addr, timestamp=1486547771954, value=shenzhen rowkey02 column=cf1:name, timestamp=1486547737573, value=zhangsan 2 row(s) in 0.0280 seconds6.根据rowkey查看数据hbase(main):015:0> get 'tablename','rowkey01'COLUMN CELL cf1:addr timestamp=1486547683853, value=chongqing cf1:name timestamp=1486547607486, value=lijie 2 row(s) in 0.0250 seconds7.查询数据的条数hbase(main):016:0> count 'tablename'2 row(s) in 0.0410 seconds=> 28.获取一行指定列族的数据hbase(main):017:0> get 'tablename','rowkey01','cf1'COLUMN CELL cf1:addr timestamp=1486547683853, value=chongqing cf1:name timestamp=1486547607486, value=lijie 2 row(s) in 0.0120 seconds9.获取一行指定列族某列数据hbase(main):021:0> get 'tablename','rowkey01','cf1:name'COLUMN CELL cf1:name timestamp=1486547607486, value=lijie 1 row(s) in 0.0080 seconds10.删除列族hbase(main):027:0> delete 'tablename','rowkey01','cf1:addr'0 row(s) in 0.0030 seconds11.删除一整行数据hbase(main):029:0> deleteall 'tablename','rowkey01' 0 row(s) in 0.0090 seconds12.更新一条数据hbase(main):032:0> put 'tablename','rowkey02','cf1:addr','shanghai'0 row(s) in 0.0040 seconds13.是否enable或者disablehbase(main):034:0> is_enabled 'tablename'true 0 row(s) in 0.0070 secondshbase(main):035:0> is_disabled 'tablename'false 0 row(s) in 0.0050 seconds14.查看表是否存在hbase(main):036:0> exists 'tablename'Table tablename does exist 0 row(s) in 0.0050 seconds15.服务器状态hbase(main):037:0> status1 servers, 0 dead, 5.0000 average load16.hbase版本hbase(main):039:0> version1.0.3, rf1e1312f9790a7c40f6a4b5a1bab2ea1dd559890, Tue Jan 19 19:26:53 PST 201617.删除一个列族hbase(main):040:0> disable 'tablename'0 row(s) in 1.2310 secondshbase(main):041:0> alter 'tablename',{NAME => 'cf1',METHOD => 'delete'} Updating all regions with the new schema...1/1 regions updated.Done.0 row(s) in 1.1460 secondshbase(main):042:0> enable 'tablename'0 row(s) in 0.1550 seconds18.获得表的描述hbase(main):044:0> describe 'tablename'Table tablename is ENABLED tablename COLUMN FAMILIES DESCRipTION {NAME => 'cf2', DATA_BLOCK_ENCODING => 'NONE', BLOOMFILTER => 'ROW', REPLICATION_SCOPE => '0', VERSIONS => '1', COMPRESSION => 'NONE', MIN_VERSIONS => '0', TTL => 'FOREVER', KEEP_DELETED_CELLS => 'FALSE', BLOCKSIZE => '65536', IN_MEMORY => 'false', BLOCKCACHE => 'true'} 1 row(s) in 0.0150 secondshbase(main):045:0> desc 'tablename'Table tablename is ENABLED tablename COLUMN FAMILIES DESCRIPTION {NAME => 'cf2', DATA_BLOCK_ENCODING => 'NONE', BLOOMFILTER => 'ROW', REPLICATION_SCOPE => '0', VERSIONS => '1', COMPRESSION => 'NONE', MIN_VERSIONS => '0', TTL => 'FOREVER', KEEP_DELETED_CELLS => 'FALSE', BLOCKSIZE => '65536', IN_MEMORY => 'false', BLOCKCACHE => 'true'} 1 row(s) in 0.0240 seconds19.清空整个表hbase(main):046:0> truncate 'tablename'Truncating 'tablename' table (it may take a while): - Disabling table... - Truncating table...0 row(s) in 1.3600 seconds20.删除整个表hbase(main):048:0> disable 'tablename'0 row(s) in 1.1720 secondshbase(main):049:0> drop 'tablename'0 row(s) in 0.1720 secondshbase(main):050:0> listTABLE stu t1 2 row(s) in 0.0100 seconds=> ["stu", "t1"]

下次更新filter操作，未完待续。。。。

上一篇：读写分离

下一篇：回收表空间的几个方法