HBASE 常用shell命令,增删改查方法
1、首先给出本次操作的数据
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-techzone' 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、首先执行,创建表,增加数据操作,执行脚本/bin/hbaseshell./student.txt,然后查看内容scan‘student'
hbase(main):001:0>scan'student' ROWCOLUMN+CELL 1column=address:area,timestamp=1491533426260,value=High-techzone 1column=address:city,timestamp=1491533426239,value=zhengzhou 1column=info:age,timestamp=1491533426179,value=20 1column=info:class,timestamp=1491533426218,value=1 1column=info:name,timestamp=1491533426211,value=wang 2column=address:area,timestamp=1491533426297,value=CBD 2column=address:city,timestamp=1491533426292,value=beijing 2column=info:age,timestamp=1491533426269,value=21 2column=info:class,timestamp=1491533426287,value=1 2column=info:name,timestamp=1491533426277,value=yang 3column=address:area,timestamp=1491533426329,value=pudong 3column=address:city,timestamp=1491533426323,value=shanghai 3column=info:age,timestamp=1491533426305,value=22 3column=info:class,timestamp=1491533426317,value=2 3column=info:name,timestamp=1491533426311,value=zhao 3row(s)in0.1940seconds
3、修改操作也是用put命令,就是重新添加内容把,把以前的内容覆盖。
格式put't1','r1','c1','value'
命令put'student','1','info:age','18'
结果 hbase(main):010:0>get'student','1' COLUMNCELL address:areatimestamp=1491533426260,value=High-techzone address:citytimestamp=1491533426239,value=zhengzhou info:agetimestamp=1491533823331,value=18 info:classtimestamp=1491533426218,value=1 info:nametimestamp=1491533426211,value=wang 5row(s)in0.0110seconds
4、删除操作,分为删除单元格的内容,和整行删除
单元格
hbase(main):012:0>delete'student','1','info:name' 0row(s)in0.0800seconds hbase(main):014:0>get'student','1' COLUMNCELL address:areatimestamp=1491533426260,value=High-techzone address:citytimestamp=1491533426239,value=zhengzhou info:agetimestamp=1491533823331,value=18 info:classtimestamp=1491533426218,value=1 4row(s)in0.0120seconds
整行
hbase(main):023:0>deleteall'student','1' 0row(s)in0.0260seconds hbase(main):024:0>get'student','1' COLUMNCELL 0row(s)in0.0070seconds
5、查询
单行查询
hbase(main):026:0>get'student','2' COLUMNCELL address:areatimestamp=1491533426297,value=CBD address:citytimestamp=1491533426292,value=beijing info:agetimestamp=1491533426269,value=21 info:classtimestamp=1491533426287,value=1 info:nametimestamp=1491533426277,value=yang 5row(s)in0.0190seconds
指定列族
hbase(main):028:0>get'student','2',{COLUMN=>'info'} COLUMNCELL info:agetimestamp=1491533426269,value=21 info:classtimestamp=1491533426287,value=1 info:nametimestamp=1491533426277,value=yang 3row(s)in0.0150seconds
指定列名
hbase(main):029:0>get'student','2',{COLUMN=>'info:age'} COLUMNCELL info:agetimestamp=1491533426269,value=21 1row(s)in0.0080seconds
使用scan,指定startrow
hbase(main):031:0>scan'student',{COLUMNS=>['info:age','address'],LIMIT=>10,STARTROW=>'2'} ROWCOLUMN+CELL 2column=address:area,timestamp=1491533426297,value=CBD 2column=address:city,timestamp=1491533426292,value=beijing 2column=info:age,timestamp=1491533426269,value=21 3column=address:area,timestamp=1491533426329,value=pudong 3column=address:city,timestamp=1491533426323,value=shanghai 3column=info:age,timestamp=1491533426305,value=22 2row(s)in0.0190seconds
scan指定过滤
hbase(main):005:0>scan'student',{FILTER=>"(TimestampsFilter(1491533426297))"} ROWCOLUMN+CELL 2column=address:area,timestamp=1491533426297,value=CBD 1row(s)in0.0170seconds
以上这篇HBASE常用shell命令,增删改查方法就是小编分享给大家的全部内容了,希望能给大家一个参考,也希望大家多多支持毛票票。