[root@mini1 bin]# ./hbase shell
SLF4J: Class path contains multiple SLF4J bindings.
SLF4J: Found binding .jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding .jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation.
SLF4J: Actual binding is of type [org.slf4j.impl.Log4jLoggerFactory]
HBase Shell; enter 'help<RETURN>' for list of supported commands.
Type "exit<RETURN>" to leave the HBase Shell
Version , r930b9a55528fe45d8edce7af42fef2d35e77677a, Thu Apr   :: PDT 

hbase(main)::> 

hbase shell

hbase(main)::> help
HBase Shell, version , r930b9a55528fe45d8edce7af42fef2d35e77677a, Thu Apr   :: PDT
Type 'help "COMMAND"', (e.g. 'help "get"' -- the quotes are necessary) for help on a specific command.
Commands are grouped. Type 'help "COMMAND_GROUP"', (e.g. 'help "general"') for help on a command group.

COMMAND GROUPS:
  Group name: general
  Commands: status, table_help, version, whoami

  Group name: ddl
  Commands: alter, alter_async, alter_status, create, describe, disable, disable_all, drop, drop_all, enable, enable_all, exists, get_table, is_disabled, is_enabled, list, locate_region, show_filters

  Group name: namespace
  Commands: alter_namespace, create_namespace, describe_namespace, drop_namespace, list_namespace, list_namespace_tables

  Group name: dml
  Commands: append, count, delete, deleteall, get, get_counter, get_splits, incr, put, scan, truncate, truncate_preserve

  Group name: tools
  Commands: assign, balance_switch, balancer, balancer_enabled, catalogjanitor_enabled, catalogjanitor_run, catalogjanitor_switch, close_region, compact, compact_rs, flush, major_compact, merge_region, move, normalize, normalizer_enabled, normalizer_switch, split, splitormerge_enabled, splitormerge_switch, trace, unassign, wal_roll, zk_dump

  Group name: replication
  Commands: add_peer, append_peer_tableCFs, disable_peer, disable_table_replication, enable_peer, enable_table_replication, get_peer_config, list_peer_configs, list_peers, list_replicated_tables, remove_peer, remove_peer_tableCFs, set_peer_tableCFs, show_peer_tableCFs

  Group name: snapshots
  Commands: clone_snapshot, delete_all_snapshot, delete_snapshot, delete_table_snapshots, list_snapshots, list_table_snapshots, restore_snapshot, snapshot

  Group name: configuration
  Commands: update_all_config, update_config

  Group name: quotas
  Commands: list_quotas, set_quota

  Group name: security
  Commands: grant, list_security_capabilities, revoke, user_permission

  Group name: procedures
  Commands: abort_procedure, list_procedures

  Group name: visibility labels
  Commands: add_labels, clear_auths, get_auths, list_labels, set_auths, set_visibility

SHELL USAGE:
Quote all names in HBase Shell such as table and column names.  Commas delimit
command parameters.  Type <RETURN> after entering a command to run it.
Dictionaries of configuration used in the creation and alteration of tables are
Ruby Hashes. They look like this:

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

and are opened and closed with curley-braces.  Key/values are delimited by the
'=>' character combination.  Usually keys are predefined constants such as
NAME, VERSIONS, COMPRESSION, etc.  Constants do not need to be quoted.  Type
'Object.constants' to see a (messy) list of all constants in the environment.

If you are using binary keys or values and need to enter them in the shell, use
double-quote'd hexadecimal 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 is the (J)Ruby IRB with the above HBase-specific commands added.
For more on the HBase Shell, see http://hbase.apache.org/book.html

hbase(main)::> status
 active master,  backup masters,  servers,  dead, 1.0000 average load

hbase(main)::> version
, r930b9a55528fe45d8edce7af42fef2d35e77677a, Thu Apr   :: PDT 

hbase(main)::> table_help
Help for table-reference commands.

You can either create a table via 'create' and then manipulate the table via commands like 'put', 'get', etc.
See the standard help information for how to use each of these commands.

However, as of 0.96, you can also get a reference to a table, on which you can invoke commands.
For instance, you can get create a table and keep around a reference to it via:

   hbase> t = create 't', 'cf'

Or, if you have already created the table, you can get a reference to it:

   hbase> t = get_table 't'

You can do things like call 'put' on the table:

  hbase> t.put 'r', 'cf:q', 'v'

which puts a row 'r' with column family 'cf', qualifier 'q' and value 'v' into table t.

To read the data out, you can scan the table:

  hbase> t.scan

which will read all the rows in table 't'.

Essentially, any command that takes a table name can also be done via table reference.
Other commands include things like: get, delete, deleteall,
get_all_columns, get_counter, count, incr. These functions, along with
the standard JRuby object methods are also available via tab completion.

For more information on how to use each of these commands, you can also just type:

   hbase> t.help 'scan'

which will output more information on how to use that command.

You can also do general admin actions directly on a table; things like enable, disable,
flush and drop just by typing:

   hbase> t.enable
   hbase> t.flush
   hbase> t.disable
   hbase> t.drop

Note that after dropping a table, your reference to it becomes useless and further usage
is undefined (and not recommended).

hbase(main)::> whoami
root (auth:SIMPLE)
groups: root

create '<table name>','<column family>'

hbase(main)::> create 'emp','personal data','professional data'
 row(s) in 1.2570 seconds

=> Hbase::Table - emp

hbase(main)::> list
TABLE
emp
 row(s) in 0.0480 seconds

=> ["emp"]

hbase(main)::> disable 'emp'
 row(s) in 2.3300 seconds

hbase(main)::> exists 'emp'
Table emp does exist
 row(s) in 0.3610 seconds

hbase(main)::> scan 'emp'
ROW                             COLUMN+CELL                                                                             

ERROR: emp is disabled.

Here is some help for this command:
Scan a table; pass table name and optionally a dictionary of scanner
specifications.  Scanner specifications may include one or more of:
TIMERANGE, FILTER, LIMIT, STARTROW, STOPROW, ROWPREFIXFILTER, TIMESTAMP,
MAXLENGTH or COLUMNS, CACHE or RAW, VERSIONS, ALL_METRICS or METRICS

If no columns are specified, all columns will be scanned.
To scan all members of a column family, leave the qualifier empty as in
'col_family'.

The filter can be specified in two ways:
. Using a filterString - more information on this is available in the
Filter Language document attached to the HBASE- JIRA
. Using the entire package name of the filter.

If you wish to see metrics regarding the execution of the scan, the
ALL_METRICS boolean should be set to true. Alternatively, if you would
prefer to see only a subset of the metrics, the METRICS array can be
defined to include the names of only the metrics you care about.

Some examples:

  hbase> scan 'hbase:meta'
  hbase> scan 'hbase:meta', {COLUMNS => 'info:regioninfo'}
  hbase> scan , STARTROW => 'xyz'}
  hbase> scan , STARTROW => 'xyz'}
  hbase> scan , ]}
  hbase> scan 't1', {REVERSED => true}
  hbase> scan 't1', {ALL_METRICS => true}
  hbase> scan 't1', {METRICS => ['RPC_RETRIES', 'ROWS_FILTERED']}
  hbase> scan 't1', {ROWPREFIXFILTER => 'row2', FILTER => "
    (QualifierFilter (>=, , ))"}
  hbase> scan 't1', {FILTER =>
    org.apache.hadoop.hbase.filter.ColumnPaginationFilter.new(, )}
  hbase> scan 't1', {CONSISTENCY => 'TIMELINE'}
For setting the Operation Attributes
  hbase> scan 't1', { COLUMNS => ['c1', 'c2'], ATTRIBUTES => {'mykey' => 'myvalue'}}
  hbase> scan 't1', { COLUMNS => ['c1', 'c2'], AUTHORIZATIONS => ['PRIVATE','SECRET']}
For experts, there is an additional option -- CACHE_BLOCKS -- which
switches block caching for the scanner on (true) or off (false).  By
default it is enabled.  Examples:

  hbase> scan 't1', {COLUMNS => ['c1', 'c2'], CACHE_BLOCKS => false}

Also for experts, there is an advanced option -- RAW -- which instructs the
scanner to return all cells (including delete markers and uncollected deleted
cells). This option cannot be combined with requesting specific COLUMNS.
Disabled by default.  Example:

  hbase> scan }

Besides the default 'toStringBinary' format, 'scan' supports custom formatting
by column.  A user can define a FORMATTER by adding it to the column name in
the scan specification.  The FORMATTER can be stipulated: 

 . either as a org.apache.hadoop.hbase.util.Bytes method name (e.g, toInt, toString)
 . or as a custom class followed by method name: e.g. 'c(MyFormatterClass).format'.

Example formatting cf:qualifier1 and cf:qualifier2 both as Integers:
  hbase> scan 't1', {COLUMNS => ['cf:qualifier1:toInt',
    'cf:qualifier2:c(org.apache.hadoop.hbase.util.Bytes).toInt'] } 

Note that you can specify a FORMATTER by column only (cf:qualifier).  You cannot
specify a FORMATTER for all columns of a column family.

Scan can also be used directly from a table, by first getting a reference to a
table, like such:

  hbase> t = get_table 't'
  hbase> t.scan

Note in the above situation, you can still provide all the filtering, columns,
options, etc as described above.

hbase> is_disabled 'table name'

hbase(main)::> is_disabled 'emp'
true
 row(s) in 0.0440 seconds

hbase> disable_all 'r.*'

hbase(main)::> disable_all 'raj.*'

raja
rajani
rajendra
rajesh
raju
Disable the above  tables (y/n)?

y

 tables successfully disabled

enable 'table_name'

hbase(main)::> enable 'emp'
 row(s) in 1.3610 seconds

hbase(main)::> scan 'emp'
ROW                             COLUMN+CELL
 row(s) in 0.0700 seconds

hbase> is_enabled 'table name'

hbase(main)::> is_enabled 'emp'
true
 row(s) in 0.0130 seconds

describe 'table_name'

hbase(main)::> describe 'emp'
Table emp is ENABLED
emp
COLUMN FAMILIES DESCRIPTION
{NAME => ', IN_MEMORY => 'false', KEEP_DELETED_CELLS => 'FALSE', DA
TA_BLOCK_ENCODING => ', BLOCKCACHE => 'true', BLOCKSI
ZE => '}
{NAME => ', IN_MEMORY => 'false', KEEP_DELETED_CELLS => 'FALSE'
, DATA_BLOCK_ENCODING => ', BLOCKCACHE => 'true', BLO
CKSIZE => '}
 row(s) in 0.0430 seconds

hbase> alter 

hbase(main)::> alter
Updating all regions with the new schema...
/ regions updated.
/ regions updated.
Done.
 row(s) in 2.3050 seconds

命令格式：
hbase>alter 't1', READONLY(option)

hbase(main)::> alter 'emp', READONLY
Updating all regions with the new schema...
/ regions updated.
/ regions updated.
Done.
 row(s) in 2.2140 seconds

hbase> alter 't1', METHOD => 'table_att_unset', NAME => 'MAX_FILESIZE'

hbase> alter ‘ table name ’, ‘delete’ => ‘ column family ’ 

hbase(main)::> scan 'employee'
         ROW                   COLUMN+CELL
row1 column=personal:city, timestamp=, value=hyderabad
row1 column=personal:name, timestamp=, value=raju
row1 column=professional:designation, timestamp=, value=manager
row1 column=professional:salary, timestamp=, value=
 row(s) in 0.0160 seconds 

hbase(main)::> alter 'employee','delete'=>'professional'
Updating all regions with the new schema...
/ regions updated.
/ regions updated.
Done.
 row(s) in 2.2380 seconds 

hbase(main)::> scan 'employee'
ROW             COLUMN+CELL
row1 column=personal:city, timestamp=, value=hyderabad
row1 column=personal:name, timestamp=, value=raju
 row(s) in 0.0830 seconds

hbase(main)::> disable 'emp'
 row(s) in 1.4580 seconds
hbase(main)::> drop 'emp'
 row(s) in 0.3060 seconds

hbase(main)::> exists 'emp'
Table emp does not exist
 row(s) in 0.0730 seconds

hbase> drop_all 't.*'

hbase(main)::> list
TABLE
raja
rajani
rajendra
rajesh
raju
 row(s) in 0.0270 seconds

hbase(main)::> disable_all 'raj.*'
raja
rajani
rajendra
rajesh
raju
Disable the above  tables (y/n)?
y
 tables successfully disabled

hbase(main)::> drop_all 'raj.*'
raja
rajani
rajendra
rajesh
raju
Drop the above  tables (y/n)?
y
 tables successfully dropped

hbase(main)::> exit

./bin/stop-hbase.sh

put '<table name>','row1','<colfamily:colname>','<value>'

hbase(main)::> put ','personal data:name','raju'
 row(s) in 0.0210 seconds
hbase(main)::> put ','personal data:city','hyderabad'
 row(s) in 0.0140 seconds
hbase(main)::> put ','professional data:designation','manager'
 row(s) in 0.0120 seconds
hbase(main)::> put '
 row(s) in 0.0090 seconds

hbase(main)::> scan 'emp'
ROW                                        COLUMN+CELL
                                          column=personal data:city, timestamp=, value=hyderabad
                                          column=personal data:name, timestamp=, value=raju
                                          column=professional data:designation, timestamp=, value=manager
                                          column=professional data:salary, timestamp=, value=
 row(s) in 0.5880 seconds

put 'table name','row ','Column family:column name','new value'

hbase(main)::> scan 'emp'
ROW                                        COLUMN+CELL
                                          column=personal data:city, timestamp=, value=hyderabad
                                          column=personal data:name, timestamp=, value=raju
                                          column=professional data:designation, timestamp=, value=manager
                                          column=professional data:salary, timestamp=, value=
 row(s) in 0.5880 seconds

hbase(main)::> put ','personal data:city','New York'
 row(s) in 0.1710 seconds

hbase(main)::> scan 'emp'
ROW                                        COLUMN+CELL
                                          column=personal data:city, timestamp=, value=NewYork
                                          column=personal data:name, timestamp=, value=raju
                                          column=professional data:designation, timestamp=, value=manager
                                          column=professional data:salary, timestamp=, value=
 row(s) in 0.0470 seconds

get '<table name>','row number'

hbase(main)::> get '
COLUMN                                     CELL
 personal data:city                        timestamp=, value=NewYork
 personal data:name                        timestamp=, value=raju
 professional data:designation             timestamp=, value=manager
 professional data:salary                  timestamp=, value=
 row(s) in 0.0580 seconds

hbase>get 'table name', 'rowid', {COLUMN => 'column family:column name'}

hbase(main)::> get ',{COLUMN=>'personal data:city'}
COLUMN                                     CELL
personal data:city                        timestamp=, value=NewYork
 row(s) in 0.0250 seconds

delete '<table name>', '<row>', '<column name >', <time stamp>

hbase(main)::> delete
 row(s) in 0.0090 seconds

deleteall '<table name>', '<row>'

hbase(main)::> deleteall '
 row(s) in 0.0120 seconds

hbase(main)::> scan 'emp'
ROW                                        COLUMN+CELL
 row(s) in 0.0160 seconds

count '<table name>'

hbase> truncate 'table name'

hbase(main)::> truncate 'emp'
Truncating 'emp' table (it may take a while):
- Disabling table...
- Truncating table...
 row(s) in 4.5990 seconds

hbase(main)::> scan 'emp'
ROW                                        COLUMN+CELL
 row(s) in 0.1500 seconds