pinpoint数据过大，清理hbase

查看数据目录大小

du -sh /home/pinpoint/hbase/data/default/* | grep G

21G ApplicationTraceIndex
76G TraceV2

进入hbase数据库

/opt/hbase/hbase-1.2.6/bin/hbase shell

hbase(main):001:0> list
TABLE
AgentEvent
AgentInfo
AgentLifeCycle
AgentStatV2
ApiMetaData
ApplicationIndex
ApplicationMapStatisticsCallee_Ver2
ApplicationMapStatisticsCaller_Ver2
ApplicationMapStatisticsSelf_Ver2
ApplicationStatAggre
ApplicationTraceIndex
HostApplicationMap_Ver2
SqlMetaData_Ver2
StringMetaData
TraceV2
15 row(s) in 0.1670 seconds

=> ["AgentEvent", "AgentInfo", "AgentLifeCycle", "AgentStatV2", "ApiMetaData", "ApplicationIndex", "ApplicationMapStatisticsCallee_Ver2", "ApplicationMapStatisticsCaller_Ver2", "ApplicationMapStatisticsSelf_Ver2", "ApplicationStatAggre", "ApplicationTraceIndex", "HostApplicationMap_Ver2", "SqlMetaData_Ver2", "StringMetaData", "TraceV2"]

修改TraceV2表TTL数据保存时间7天

查看表详情

hbase(main):002:0> describe 'TraceV2'

禁用表

hbase(main):002:0> disable 'TraceV2'

修改TTL为7天：604800

hbase(main):002:0> alter 'TraceV2' , {NAME=>'S',TTL=>'604800'}

启用表

hbase(main):002:0> enable 'TraceV2'

进行收缩

hbase(main):002:0> major_compact 'TraceV2'

修改ApplicationTraceIndex表TTL数据保存时间14天

查看表详情

hbase(main):002:0> describe 'ApplicationTraceIndex'

禁用表

hbase(main):002:0> disable 'ApplicationTraceIndex'

修改TTL为7天：604800

hbase(main):002:0> alter 'ApplicationTraceIndex' , {NAME=>'I',TTL=>'1209600'}

启用表

hbase(main):002:0> enable 'ApplicationTraceIndex'

进行收缩

hbase(main):002:0> major_compact 'ApplicationTraceIndex'

查看收缩后大小

du -sh /home/pinpoint/hbase/data/default/* | grep G

8.0G ApplicationTraceIndex
11G TraceV2