Hbase深入学习(四) Hbase操作命令列表

Hbase深入学习(四)　 Hbase操作命令列表

Connect to yourrunning hbase via the shell.

$ ./hbase shell

[WARN ]-XX:OnOutOfMemoryError=kill -9 %p is not a valid VM option. Ignoring

[WARN ]-XX:+UseConcMarkSweepGC is not a valid VM option. Ignoring

HBase Shell; enter'help<RETURN>' for list of supported commands.

Type"exit<RETURN>" to leave the HBase Shell

Version 0.94.11,r1513697, Wed Aug 14 04:54:46 UTC 2013

 

hbase(main):001:0>

Type help and then<return> to see a listing of shell commands and options.

HBase Shell, version0.94.11, r1513697, Wed Aug 14 04:54:46 UTC 2013

Type 'help"COMMAND"', (e.g. 'help "get"' -- the quotes are necessary)for help                                                                                                                                                             ona specific command.

Commands aregrouped. Type 'help "COMMAND_GROUP"', (e.g. 'help"general"') for h                                                                                                                                                            elp on acommand group.

 

COMMAND GROUPS:

  Group name: general

  Commands: status, version, whoami

 

  Group name: ddl

  Commands: alter, alter_async, alter_status,create, describe, disable, disable                                                                                                                                                             _all,drop, drop_all, enable, enable_all, exists, is_disabled, is_enabled, list,                                                                                                                                                              show_filters

 

  Group name: dml

  Commands: count, delete, deleteall, get,get_counter, incr, put, scan, truncat                                                                                                                                                             e

 

  Group name: tools

  Commands: assign, balance_switch, balancer,close_region, compact, flush, hlog                                                                                                                                                             _roll,major_compact, move, split, unassign, zk_dump

 

  Group name: replication

  Commands: add_peer, disable_peer, enable_peer,list_peers, list_replicated_tab                                                                                                                                                            les, remove_peer, start_replication, stop_replication

 

  Group name: snapshot

  Commands: clone_snapshot, delete_snapshot,list_snapshots, restore_snapshot, s                                                                                                                                                            napshot

 

  Group name: security

  Commands: grant, revoke, user_permission

 

SHELL USAGE:

Quote all names inHBase Shell such as table and column names. Commas delimit

commandparameters.  Type <RETURN> afterentering a command to run it.

Dictionaries of configurationused in the creation and alteration of tables are

Ruby Hashes. Theylook like this:

 

  {'key1' => 'value1', 'key2' =>'value2', ...}

 

and are opened andclosed with curley-braces.  Key/valuesare delimited by the

'=>' charactercombination.  Usually keys are predefinedconstants such as

NAME, VERSIONS,COMPRESSION, etc.  Constants do not needto be quoted.  Type

'Object.constants'to see a (messy) list of all constants in the environment.

 

If you are usingbinary keys or values and need to enter them in the shell, use

double-quote'dhexadecimal representation. For example:

 

  hbase> get 't1',"key\x03\x3f\xcd"

  hbase> get 't1',"key\003\023\011"

  hbase> put 't1', "test\xef\xff",'f1:', "\x01\x33\x40"

 

The HBase shell isthe (J)Ruby IRB with the above HBase-specific commands added.

For more on theHBase Shell, see http://hbase.apache.org/docs/current/book.html

Create a tablenamed test with a single column family named cf. verify its creation by listingall tables and then insert some values.

hbase(main):002:0>create 'test','cf'

0 row(s) in 1.2240seconds

 

hbase(main):003:0>list 'test'

TABLE

test

1 row(s) in 0.0500 seconds hbase(main):004:0> put 'test', 'row1', 'cf:a', 'value1'

0 row(s) in 0.0560 seconds

hbase(main):005:0> put 'test', 'row2', 'cf:b', 'value2'

0 row(s) in 0.0370 seconds

hbase(main):006:0> put 'test', 'row3', 'cf:c', 'value3'

0 row(s) in 0.0450 seconds

Above we inserted 3values, one at a time. The first insert is at row1, column cf:a with a value ofvalue1. Columns in hbase are comprised of a column family prefix – cf in thisexample – followed by a colon and then a column qualifier suffix (a in thiscase). Verify the data insert by running a scan of the table as follows

Verify the datainsert by running a scan of the table as follows

hbase(main):008:0>scan 'test'

ROW                                      COLUMN+CELL

 row1\x0A\x0A                             column=cf:a,timestamp=1377503568044, value=value1

1 row(s) in 0.0560seconds

Get a single row

hbase(main):015:0>get 'test','row2'

COLUMN                                    CELL

 cf:b                                    timestamp=1377503874806, value=value2

1 row(s) in 0.0190seconds

Disable and dropyour table.

hbase(main):017:0>disable 'test'

0 row(s) in 2.0600seconds

 

hbase(main):018:0>list 'test'

TABLE

test

1 row(s) in 0.0150seconds

 

hbase(main):019:0>drop 'test'

0 row(s) in 1.1950seconds

 

hbase(main):020:0>list 'test'

TABLE

0 row(s) in 0.0170seconds

Exit the shell bytyping exit.