Hbase 总结(6)

2019-08-30 19:35

201410 column=CF:DATA_TYP_CD, timestamp=1416195048037, value=1

201410 column=CF:G4_PNTRN_RT, timestamp=1416195048037, value=1.1

201410 column=CF:LOC_LVL1_CD, timestamp=1416195048037, value=GZ01

201410 column=CF:RETN_ARPU, timestamp=1416195048037, value=1.1

201410 column=CF:RETN_USR_CNT,

timestamp=1416195048037, value=200

201410 column=CF:SNAP_ARPU, timestamp=1416195048037, value=1.1

201410 column=CF:SNAP_USR_CNT,

timestamp=1416195048037, value=100 201410 column=CF:SPAY_PNTRN_RT,

timestamp=1416195048037, value=1.1 1 row(s) in 0.4600 seconds

[7]限制只取某个字段：scan

'TM_CORP_SNMBR_TOP35_M',{COLUMNS=>'CF:LOC_LVL1_CD'}

hbase(main):001:0> scan

'TM_CORP_SNMBR_TOP35_M',{COLUMNS=>'CF:LOC_LVL1_CD'}

2014-11-17 15:04:51,044 WARN [main] util.NativeCodeLoader: Unable to load

native-hadoop library for your platform... using builtin-java classes where applicable

ROW COLUMN+CELL 201410 column=CF:LOC_LVL1_CD, timestamp=1416195048037, value=GZ01

201411 column=CF:LOC_LVL1_CD, timestamp=1416195048037, value=GZ02 2 row(s) in 0.4410 seconds

[8]增加一条记录：put

'TM_CORP_SNMBR_TOP35_M','201409','CF:LOC_LVL1_CD','GZ03'

hbase(main):001:0> put

'TM_CORP_SNMBR_TOP35_M','201409','CF:LOC_LVL1_CD','GZ03'

2014-11-17 15:06:50,736 WARN [main] util.NativeCodeLoader: Unable to load

native-hadoop library for your platform... using builtin-java classes where applicable 0 row(s) in 0.4900 seconds

[9]查询主键等于某个值的记录：get 'TM_CORP_SNMBR_TOP35_M','201410' hbase(main):001:0> get 'TM_CORP_SNMBR_TOP35_M','201410'

2014-11-17 15:16:05,821 WARN [main] util.NativeCodeLoader: Unable to load

native-hadoop library for your platform... using builtin-java classes where applicable

COLUMN CELL CF:BIND_PNTRN_RT timestamp=1416195048037, value=1.1 CF:DATA_TYP_CD timestamp=1416195048037, value=1 CF:G4_PNTRN_RT timestamp=1416195048037, value=1.1 CF:LOC_LVL1_CD timestamp=1416195048037, value=GZ01 CF:RETN_ARPU timestamp=1416195048037, value=1.1 CF:RETN_USR_CNT timestamp=1416195048037, value=200 CF:SNAP_ARPU timestamp=1416195048037, value=1.1 CF:SNAP_USR_CNT timestamp=1416195048037, value=100 CF:SPAY_PNTRN_RT timestamp=1416195048037, value=1.1 9 row(s) in 0.4460 seconds

[10]查询主键等于某个值的某个列族的记录：get 'TM_CORP_SNMBR_TOP35_M','201410','CF'

hbase(main):002:0> get 'TM_CORP_SNMBR_TOP35_M','201410','CF'

[11]查询主键等于某个值的某个列族的某个字段记录：get 'TM_CORP_SNMBR_TOP35_M','201410','CF:LOC_LVL1_CD'

hbase(main):003:0> get 'TM_CORP_SNMBR_TOP35_M','201410','CF:LOC_LVL1_CD'

COLUMN CELL CF:LOC_LVL1_CD timestamp=1416195048037, value=GZ01 1 row(s) in 0.0080 seconds

[12]修改字段值：put

'TM_CORP_SNMBR_TOP35_M','201410','CF:BIND_PNTRN_RT','2.01' hbase(main):003:0> put

'TM_CORP_SNMBR_TOP35_M','201410','CF:BIND_PNTRN_RT','2.01' 0 row(s) in 0.0600 seconds

hbase(main):004:0> get

'TM_CORP_SNMBR_TOP35_M','201410','CF:BIND_PNTRN_RT'

COLUMN CELL CF:BIND_PNTRN_RT timestamp=1416208760428, value=2.01 1 row(s) in 0.0080 seconds

[13]删除主键为某个固定值的某个字段记录：delete

'TM_CORP_SNMBR_TOP35_M','201410','CF:BIND_PNTRN_RT' hbase(main):002:0> delete

'TM_CORP_SNMBR_TOP35_M','201410','CF:BIND_PNTRN_RT' 0 row(s) in 0.0590 seconds

[14]删除主键为某个固定值的所有字段记录：deleteall 'TM_CORP_SNMBR_TOP35_M','201410'

hbase(main):002:0> deleteall 'TM_CORP_SNMBR_TOP35_M','201410' 0 row(s) in 0.0460 seconds

hbase(main):003:0> scan 'TM_CORP_SNMBR_TOP35_M'

ROW COLUMN+CELL 201409 column=CF:LOC_LVL1_CD, timestamp=1416208011582, value=GZ03

201411 column=CF:BIND_PNTRN_RT,

timestamp=1416195048037, value=1.1

201411 column=CF:DATA_TYP_CD, timestamp=1416195048037, value=1

201411 column=CF:G4_PNTRN_RT, timestamp=1416195048037, value=1.1

201411 column=CF:LOC_LVL1_CD, timestamp=1416195048037, value=GZ02

201411 column=CF:RETN_ARPU, timestamp=1416195048037, value=1.1

201411 column=CF:RETN_USR_CNT,

timestamp=1416195048037, value=200

201411 column=CF:SNAP_ARPU, timestamp=1416195048037, value=1.1

201411 column=CF:SNAP_USR_CNT,

timestamp=1416195048037, value=100 201411 column=CF:SPAY_PNTRN_RT,

timestamp=1416195048037, value=1.1 2 row(s) in 0.0310 seconds

[15]删除全表记录：truncate 'TM_CORP_SNMBR_TOP35_M'

hbase(main):001:0> truncate 'TM_CORP_SNMBR_TOP35_M'

Truncating 'TM_CORP_SNMBR_TOP35_M' table (it may take a while):

2014-11-17 15:52:01,190 WARN [main] util.NativeCodeLoader: Unable to load

native-hadoop library for your platform... using builtin-java classes where applicable - Disabling table... - Dropping table... - Creating table...

0 row(s) in 2.5390 seconds

hbase(main):002:0> scan 'TM_CORP_SNMBR_TOP35_M'

ROW COLUMN+CELL 0 row(s) in 0.0430 seconds

[16]查询表是否存在：exists 'TM_CORP_SNMBR_TOP35_M'

hbase(main):001:0> exists 'TM_CORP_SNMBR_TOP35_M'

2014-11-17 15:24:09,838 WARN [main] util.NativeCodeLoader: Unable to load

native-hadoop library for your platform... using builtin-java classes where applicable

Table TM_CORP_SNMBR_TOP35_M does exist 0 row(s) in 1.0640 seconds

========================================== 【帮助文档】 [scan]

hbase> scan 'hbase:meta'

hbase> scan 'hbase:meta', {COLUMNS => 'info:regioninfo'}

hbase> scan 'ns1:t1', {COLUMNS => ['c1', 'c2'], LIMIT => 10, STARTROW => 'xyz'} hbase> scan 't1', {COLUMNS => ['c1', 'c2'], LIMIT => 10, STARTROW => 'xyz'}

hbase> scan 't1', {COLUMNS => 'c1', TIMERANGE => [1303668804, 1303668904]} hbase> scan 't1', {REVERSED => true}

hbase> scan 't1', {FILTER => \

(QualifierFilter (>=, 'binary:xyz'))) AND (TimestampsFilter ( 123, 456))\ hbase> scan 't1', {FILTER =>

org.apache.hadoop.hbase.filter.ColumnPaginationFilter.new(1, 0)} 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} [get]

hbase> get 'ns1:t1', 'r1' hbase> get 't1', 'r1'

hbase> get 't1', 'r1', {TIMERANGE => [ts1, ts2]} hbase> get 't1', 'r1', {COLUMN => 'c1'}

hbase> get 't1', 'r1', {COLUMN => ['c1', 'c2', 'c3']}

hbase> get 't1', 'r1', {COLUMN => 'c1', TIMESTAMP => ts1}

hbase> get 't1', 'r1', {COLUMN => 'c1', TIMERANGE => [ts1, ts2], VERSIONS => 4} hbase> get 't1', 'r1', {COLUMN => 'c1', TIMESTAMP => ts1, VERSIONS => 4} hbase> get 't1', 'r1', {FILTER => \ hbase> get 't1', 'r1', 'c1' hbase> get 't1', 'r1', 'c1', 'c2' hbase> get 't1', 'r1', ['c1', 'c2']

hbsase> get 't1','r1', {COLUMN => 'c1', ATTRIBUTES => {'mykey'=>'myvalue'}} hbsase> get 't1','r1', {COLUMN => 'c1', AUTHORIZATIONS => ['PRIVATE','SECRET']}

hbase> t.get 'r1'

hbase> t.get 'r1', {TIMERANGE => [ts1, ts2]} hbase> t.get 'r1', {COLUMN => 'c1'}

hbase> t.get 'r1', {COLUMN => ['c1', 'c2', 'c3']}

hbase> t.get 'r1', {COLUMN => 'c1', TIMESTAMP => ts1}

hbase> t.get 'r1', {COLUMN => 'c1', TIMERANGE => [ts1, ts2], VERSIONS => 4} hbase> t.get 'r1', {COLUMN => 'c1', TIMESTAMP => ts1, VERSIONS => 4} hbase> t.get 'r1', {FILTER => \ hbase> t.get 'r1', 'c1' hbase> t.get 'r1', 'c1', 'c2' hbase> t.get 'r1', ['c1', 'c2']

权限控制

2015年5月16日 10:50

修改配置文件

2015年5月16日 11:17

修改Hbase的配置文件，重启hbase服务

【HBase Region】 24 --注意是对应有 Region 的节点 /opt/mapr/hbase/hbase-0.98.9/conf/hbase-site.xml ---对应gpfs目录：/home/cloud_service/hbase/conf

hbase.rpc.engine

org.apache.hadoop.hbase.ipc.SecureRpcEngine

hbase.coprocessor.region.classes

org.apache.hadoop.hbase.security.token.TokenProvider,org.apache.hadoop.hbase.security.access.AccessController

共8页:

Hbase 总结(6).doc 将本文的Word文档下载到电脑下载失败或者文档不完整，请联系客服人员解决！

下载这篇word文档