How to operate HBase shell
Editor to share with you how to operate HBase shell, I believe that most people do not know much about it, so share this article for your reference, I hope you will learn a lot after reading this article, let's go to understand it!
Enter hbase Shell
[root@test31 ~] # hbase shell
HBase Shell; enter 'help' for list of supported commands.
Type "exit" to leave the HBase Shell
Version 0.92.1, r1298924, Fri Mar 9 16:58:34 UTC 2012
1. View server status
Hbase (main): 001VR 0 > status
1 servers, 0 dead, 3.0000 average load
two。 View HBase version
Hbase (main): 002purl 0 > version
0.92.1, r1298924, Fri Mar 9 16:58:34 UTC 2012
3.DDL operation
1) .create command
Create a table "member" with three column families "member_id" and "address" or "info", where table names, rows, and columns are enclosed in single quotes and separated by commas.
Hbase (main): 003 create 0 > member','member_id','address','info'
0 row (s) in 1.1770 seconds
2) .list command
See which tables are available in the current HBase
Hbase (main): 004VR 0 > list
TABLE
Member
Test
2 row (s) in 0.0170 seconds
3) .describe command
View the description of the table
Hbase (main): 006 describe 0 > member'
DESCRIPTION ENABLED
{NAME = > 'member', FAMILIES = > [{NAME = >' address', BLOOMFILTER = > 'NONE', REPLICATION_SCO true
PE = > '0mm, VERSIONS = >' 3mm, COMPRESSION = > 'NONE', MIN_VERSIONS = >' 0mm, TTL = > '2147483647
', BLOCKSIZE = >' 65536', IN_MEMORY = > 'false', BLOCKCACHE = >' true'}, {NAME = > 'info', BLO
OMFILTER = > 'NONE', REPLICATION_SCOPE = >' 0mm, VERSIONS = > '34th, COMPRESSION = >' NONE', MIN_
VERSIONS = > '013, TTL = >' 2147483647, BLOCKSIZE = > '65536, IN_MEMORY = >' false', BLOCKCAC
HE = > 'true'}, {NAME = >' member_id', BLOOMFILTER = > 'NONE', REPLICATION_SCOPE = >' 0mm, VERS
IONS = > '319, COMPRESSION = >' NONE', MIN_VERSIONS = > '0mm, TTL = >' 2147483647, BLOCKSIZE = >
'65536, IN_MEMORY = >' false', BLOCKCACHE = > 'true'}]}
1 row (s) in 0.0320 seconds
4)。 Delete a column family: disable,alter,enable
To modify the table structure, you must first disable
Hbase (main): 004VR 0 > disable member
NameError: undefined local variable or method `member' for #
Hbase (main): 005hbase 0 > disable 'member'
0 row (s) in 2.1560 seconds
Delete the info column of the member table
Hbase (main): 006 member', 0 > alter 'member',' delete' = > 'info'
Updating all regions with the new schema...
1/1 regions updated.
Done.
0 row (s) in 1.3370 seconds
Remember the enable table:
Hbase (main): 009 enable 0 > member'
0 row (s) in 2.2330 seconds
5)。 Delete a table test (disable,drop)
Hbase (main): 025 disable 0 > test'
0 row (s) in 2.2100 seconds
Hbase (main): 026 drop 0 > test'
0 row (s) in 1.2350 seconds
6)。 Query whether the table exists
Hbase (main): 033 exists 0 > test'
Table test does not exist
0 row (s) in 0.1820 seconds
7)。 Check to see if the table is enable
Hbase (main): 032 is_enabled 0 > member'
True
0 row (s) in 0.0070 seconds
4.DML operation
1)。 Insert data
Hbase (main): 005hbase 0 > put 'member','scutshuxue','info:age','24'
0 row (s) in 0.0790 seconds
Hbase (main): 005hbase 0 > put 'member','duansf','info:age','37'
0 row (s) in 0.0790 seconds
Hbase (main): 001put 0 > member','scutshuxue','info:company','alibaba'
0 row (s) in 0.6520 seconds
Hbase (main): 002 put 0 > member','xiaofeng','address:contry','china'
0 row (s) in 0.0090 seconds
Hbase (main): 007put 0 > member','xiaofeng','info:birthday','1987-4-17'
0 row (s) in 0.0120 seconds
Note: there must be no spaces after the insert statement.
2)。 Get a piece of data
Hbase (main): 012 get 'member','xiaofeng'
COLUMN CELL
Address:contry timestamp=1488307463293, value=china
Info:birthday timestamp=1488307533852, value=1987-4-17
2 row (s) in 0.0130 seconds
3)。 Get information about a column family in a record
Hbase (main): 013 get 0 > member','xiaofeng','info'
COLUMN CELL
Info:birthday timestamp=1488307533852, value=1987-4-17
1 row (s) in 0.0100 seconds
4)。 Get information about a column in a column family of a record
Hbase (main): 020 get 0 > member','xiaofeng','info:birthday'
COLUMN CELL
Info:birthday timestamp=1488307533852, value=1987-4-17
1 row (s) in 0.0090 seconds
5)。 Update a record
Change the age of duansf to 38
Hbase (main): 022 get 'member','duansf','info:age'
COLUMN CELL
Info:age timestamp=1488308172957, value=37
1 row (s) in 0.0090 seconds
Put 'member','duansf','info:age','38'
6)。 Delete a column in the member table
Hbase (main): 032 delete 'member','scutshuxue','info:age'
0 row (s) in 0.0080 seconds
7) .member table full table scan (similar to relational database select *)
Hbase (main): 002 scan 0 > member'
ROW COLUMN+CELL
Scutshuxue column=info:age, timestamp=1488306890710, value=24
Scutshuxue column=info:company, timestamp=1488307003752, value=alibaba
Xiaofeng column=address:contry, timestamp=1488307463293, value=china
Xiaofeng column=info:birthday, timestamp=1488307533852, value=1987-4-17
2 row (s) in 0.9780 seconds
8)。 Delete the entire row
Hbase (main): 036VR 0 > deleteall 'member','scutshuxue'
0 row (s) in 0.0090 seconds
9)。 Query how many rows are in the member table
Hbase (main): 041 count 0 > member'
2 row (s) in 0.0240 seconds
10)。 Empty the whole table
Hbase (main): 045 truncate 'member'
Truncating 'member' table (it may take a while):
-Disabling table...
-Dropping table...
-Creating table...
0 row (s) in 4.8640 seconds
Attached picture:
HBase Shell command interpretation
The above is all the content of this article "how to operate HBase shell". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!
