查询、行-hbase Shell之简单命令说明-by小雨

最新推荐文章于 2024-10-05 11:27:00 发布

weixin_34281477

最新推荐文章于 2024-10-05 11:27:00 发布

阅读量107

点赞数

文章标签：大数据 shell

文章结束给大家来个程序员笑话：[M]

[hadoop@master hbase]$ bin/hbase shell

进入shell

hbase(main):001:0> help

******（Shell命令说明）

hbase(main):002:0> status

1 servers, 0 dead, 4.0000 average load （服务器，dead，负荷）

hbase(main):003:0> version

0.94.2, r1395367, Sun Oct 7 19:11:01 UTC 2012 （版本）

hbase(main):001:0> create 'member','member_id','address','info'

0 row(s) in 5.3700 seconds （建创表，功成）

    hbase(main):002:0> list
TABLE
htest
member
user
3 row(s) in 0.3400 seconds （查看TABLE信息）

    hbase(main):003:0> describe 'member'
DESCRIPTION                                                   ENABLED
{NAME => 'member', FAMILIES => [{NAME => 'address', DATA_BLO true
CK_ENCODING => 'NONE', BLOOMFILTER => 'NONE', REPLICATION_SC
OPE => '0', VERSIONS => '3', COMPRESSION => 'NONE', MIN_VERS
IONS => '0', TTL => '2147483647', KEEP_DELETED_CELLS => 'fal
se', BLOCKSIZE => '65536', IN_MEMORY => 'false', ENCODE_ON_D
ISK => 'true', BLOCKCACHE => 'true'}, {NAME => 'info', DATA_
BLOCK_ENCODING => 'NONE', BLOOMFILTER => 'NONE', REPLICATION
_SCOPE => '0', VERSIONS => '3', COMPRESSION => 'NONE', MIN_V
ERSIONS => '0', TTL => '2147483647', KEEP_DELETED_CELLS => '
false', BLOCKSIZE => '65536', IN_MEMORY => 'false', ENCODE_O
N_DISK => 'true', BLOCKCACHE => 'true'}, {NAME => 'member_id
', DATA_BLOCK_ENCODING => 'NONE', BLOOMFILTER => 'NONE', REP
LICATION_SCOPE => '0', VERSIONS => '3', COMPRESSION => 'NONE
', MIN_VERSIONS => '0', TTL => '2147483647', KEEP_DELETED_CE
LLS => 'false', BLOCKSIZE => '65536', IN_MEMORY => 'false',
ENCODE_ON_DISK => 'true', BLOCKCACHE => 'true'}]}
1 row(s) in 0.0340 seconds   （查看表）

hbase(main):002:0> alter 'member',{NAME=>'member_id',METHOD=>'delete'}
ERROR: org.apache.hadoop.hbase.TableNotDisabledException: org.apache.hadoop.hbase.TableNotDisabledException: member

（弗成直接改修，必须先把表离线，然后改修）

hbase(main):003:0> disable 'member'
0 row(s) in 2.2260 seconds （disable表，先设为弗成用）

hbase(main):004:0> alter 'member',{NAME=>'member_id',METHOD=>'delete'}

Updating all regions with the new schema...

1/1 regions updated.

Done.

0 row(s) in 2.5010 seconds （改修功成）

hbase(main):005:0> enable 'member'
0 row(s) in 2.2380 seconds （然后动启表）

hbase(main):009:0> disable 'member'
0 row(s) in 2.1470 seconds （删除表也须要先把表设为弗成用）

hbase(main):010:0> drop 'member'
0 row(s) in 1.3690 seconds （删除功成）

    hbase(main):011:0> exists 'member'
Table member does not exist
0 row(s) in 0.1170 seconds   （查看是不是存在表）

    hbase(main):015:0> is_enabled 'member'
true
0 row(s) in 0.0030 seconds   （查看表是不是可用）

hbase(main):016:0> is_disabled 'member'
false
0 row(s) in 0.0040 seconds （查看表是不是弗成用）

（插入记载）

hbase(main):017:0> put 'member','scutshuxue','info:age','24'

hbase(main):018:0> put 'member','scutshuxue','info:birthday','1987-06-17'

hbase(main):020:0> put 'member','scutshuxue','info:company','alibaba'

hbase(main):025:0> put 'member','scutshuxue','address:province','zhejiang'

hbase(main):026:0> put 'member','scutshuxue','address:city','hangzhou'

hbase(main):027:0> put 'member','xiaofeng','info:birthday','1987-4-17'

hbase(main):028:0> put 'member','xiaofeng','info:company','alibaba'

hbase(main):029:0> put 'member','xiaofeng','address:contry','china'

hbase(main):030:0> put 'member','xiaofeng','address:province','guangdong'

hbase(main):031:0> put 'member','xiaofeng','address:city','jieyang'

hbase(main):032:0> put 'member','xiaofeng','address:town','xianqiao'

（查询记载：行键查询）

    hbase(main):001:0> get 'member','scutshuxue'
COLUMN                   CELL
address:city            timestamp=1365791240949, value=hangzhou
address:province        timestamp=1365791217245, value=zhejiang
info:age                timestamp=1365790872766, value=24
info:birthday           timestamp=1365790910608, value=1987-06-17
info:company            timestamp=1365790948776, value=alibaba
5 row(s) in 2.8340 seconds

（查询记载：行键、一个列簇的有所信息）

    hbase(main):002:0> get 'member','scutshuxue','info'
COLUMN                   CELL
info:age                timestamp=1365790872766, value=24
info:birthday           timestamp=1365790910608, value=1987-06-17
info:company            timestamp=1365790948776, value=alibaba
3 row(s) in 0.0220 seconds

（查询记载：行键、列簇的某列信息）

    hbase(main):003:0> get 'member','scutshuxue','info:age'
COLUMN                   CELL
info:age                timestamp=1365790872766, value=24
1 row(s) in 0.0130 seconds

（新更一条记载）

    hbase(main):004:0> put 'member','scutshuxue','info:age','99'
0 row(s) in 0.0940 seconds

hbase(main):005:0> get'member','scutshuxue','info:age'
COLUMN                   CELL
info:age                timestamp=1365792994491, value=99
1 row(s) in 0.0170 seconds

（通过时间戳查询记载）

    hbase(main):008:0> get'member','scutshuxue',{COLUMN=>'info:age',TIMESTAMP=>1365792994491}
COLUMN                   CELL
info:age                timestamp=1365792994491, value=99
1 row(s) in 0.0110 seconds

（全表扫描）

    hbase(main):009:0> scan 'member'
ROW                      COLUMN+CELL
scutshuxue              column=address:city, timestamp=1365791240949, value=hangzhou
scutshuxue              column=address:province, timestamp=1365791217245, value=zhejiang
scutshuxue              column=info:age, timestamp=1365792994491, value=99
scutshuxue              column=info:birthday, timestamp=1365790910608, value=1987-06-17
scutshuxue              column=info:company, timestamp=1365790948776, value=alibaba
xiaofeng                column=address:city, timestamp=1365791360361, value=jieyang
xiaofeng                column=address:contry, timestamp=1365791327027, value=china
xiaofeng                column=address:province, timestamp=1365791339666, value=guangdong
xiaofeng                column=address:town, timestamp=1365791380287, value=xianqiao
xiaofeng                column=info:birthday, timestamp=1365791274037, value=1987-4-17
xiaofeng                column=info:company, timestamp=1365791292933, value=alibaba
2 row(s) in 0.1540 seconds

（删除定制行键的段字）
hbase(main):010:0> delete 'member','temp','info:age'
0 row(s) in 0.0500 seconds

hbase(main):011:0> get'member','temp'
COLUMN CELL
0 row(s) in 0.0050 seconds

（删除整行）

hbase(main):013:0> deleteall'member','xiaofeng'
0 row(s) in 0.0070 seconds

（查询行）

hbase(main):014:0> count'member'
1 row(s) in 0.0670 seconds

（空清表）

hbase(main):015:0> truncate'member'
Truncating 'member' table (it may take a while):
- Disabling table...
- Dropping table...
- Creating table...
0 row(s) in 3.8280 seconds

Hbase API

《Hbase威望指南》第3-5章

http://hbase.apache.org/apidocs/index.html

文章结束给大家分享下程序员的一些笑话语录：一个合格的程序员是不会写出诸如 “摧毁地球” 这样的程序的，他们会写一个函数叫 “摧毁行星”而把地球当一个参数传进去。