Commonly used shell commands in HBASE, add, delete and modify methods

1. Give the data of this operation first.


create 'student','info','address'
put 'student','1','info:age','20'
put 'student','1','info:name','wang'
put 'student','1','info:class','1'
put 'student','1','address:city','zhengzhou'
put 'student','1','address:area','High-tech zone'
put 'student','2','info:age','21'
put 'student','2','info:name','yang'
put 'student','2','info:class','1'
put 'student','2','address:city','beijing'
put 'student','2','address:area','CBD'
put 'student','3','info:age','22'
put 'student','3','info:name','zhao'
put 'student','3','info:class','2'
put 'student','3','address:city','shanghai'
put 'student','3','address:area','pudong'
scan 'student'

2. First execute, create tables, add data operations, execute scripts / bin / HBase shell. / student. txt, and then view the content scan’student’


hbase(main):001:0> scan 'student'
ROW      COLUMN+CELL
 1       column=address:area, timestamp=1491533426260, value=High-tech zone
 1       column=address:city, timestamp=1491533426239, value=zhengzhou
 1       column=info:age, timestamp=1491533426179, value=20
 1       column=info:class, timestamp=1491533426218, value=1
 1       column=info:name, timestamp=1491533426211, value=wang
 2       column=address:area, timestamp=1491533426297, value=CBD
 2       column=address:city, timestamp=1491533426292, value=beijing
 2       column=info:age, timestamp=1491533426269, value=21
 2       column=info:class, timestamp=1491533426287, value=1
 2       column=info:name, timestamp=1491533426277, value=yang
 3       column=address:area, timestamp=1491533426329, value=pudong
 3       column=address:city, timestamp=1491533426323, value=shanghai
 3       column=info:age, timestamp=1491533426305, value=22
 3       column=info:class, timestamp=1491533426317, value=2
 3       column=info:name, timestamp=1491533426311, value=zhao
3 row(s) in 0.1940 seconds

3. Modification is also done with the put command, that is, to re-add the content to cover the previous content.

Format put't1','r1','c1','value'

Commands put'student','1','info: age','18'

Result
hbase(main):010:0> get 'student','1'
COLUMN      CELL
 address:area    timestamp=1491533426260, value=High-tech zone
 address:city    timestamp=1491533426239, value=zhengzhou
 info:age     timestamp=1491533823331, value=18
 info:class    timestamp=1491533426218, value=1
 info:name     timestamp=1491533426211, value=wang
5 row(s) in 0.0110 seconds

4. Delete operation, which is divided into delete cell content and delete whole line

Cell


hbase(main):012:0> delete 'student','1','info:name'
0 row(s) in 0.0800 seconds

hbase(main):014:0> get 'student','1'
COLUMN      CELL
 address:area    timestamp=1491533426260, value=High-tech zone
 address:city    timestamp=1491533426239, value=zhengzhou
 info:age     timestamp=1491533823331, value=18
 info:class    timestamp=1491533426218, value=1
4 row(s) in 0.0120 seconds

Whole line


hbase(main):023:0> deleteall 'student','1'
0 row(s) in 0.0260 seconds

hbase(main):024:0> get 'student','1'
COLUMN      CELL
0 row(s) in 0.0070 seconds

5, query

Single line query


hbase(main):026:0> get 'student','2'
COLUMN      CELL
 address:area    timestamp=1491533426297, value=CBD
 address:city    timestamp=1491533426292, value=beijing
 info:age     timestamp=1491533426269, value=21
 info:class    timestamp=1491533426287, value=1
 info:name     timestamp=1491533426277, value=yang
5 row(s) in 0.0190 seconds

Specified column family


hbase(main):028:0> get 'student', '2', {COLUMN => 'info'}
COLUMN      CELL
 info:age     timestamp=1491533426269, value=21
 info:class    timestamp=1491533426287, value=1
 info:name     timestamp=1491533426277, value=yang
3 row(s) in 0.0150 seconds

Specified column name


hbase(main):029:0> get 'student', '2', {COLUMN => 'info:age'}
COLUMN      CELL
 info:age     timestamp=1491533426269, value=21
1 row(s) in 0.0080 seconds

Using scan, specify startRow


 hbase(main):031:0> scan 'student', {COLUMNS => ['info:age', 'address'], LIMIT => 10, STARTROW => '2'}
ROW      COLUMN+CELL
 2       column=address:area, timestamp=1491533426297, value=CBD
 2       column=address:city, timestamp=1491533426292, value=beijing
 2       column=info:age, timestamp=1491533426269, value=21
 3       column=address:area, timestamp=1491533426329, value=pudong
 3       column=address:city, timestamp=1491533426323, value=shanghai
 3       column=info:age, timestamp=1491533426305, value=22
2 row(s) in 0.0190 seconds

Scan specifies filtering


hbase(main):005:0> scan 'student',{FILTER=>"(TimestampsFilter (1491533426297))"}
ROW      COLUMN+CELL
 2       column=address:area, timestamp=1491533426297, value=CBD
1 row(s) in 0.0170 seconds

Above this HBASE shell command commonly used, add, delete and modify the search method is a small edition to share with you all the content, I hope to give you a reference, but also hope that you support more developpaer.

Commonly used shell commands in HBASE, add, delete and modify methods

Recommended Today

Go carbon version 1.2.0 has been released to improve and optimize the multi scenario support for orm