5. [pinpoint 설치] hbase 스키마 생성

## pinpoint에서 제공하는 파일을 사용하여 스키마 생성
## hbase-create.hbase
 
 
[root@localhost scripts]# pwd
/usr/local/pinpoint/hbase/scripts
[root@localhost scripts]# ll
total 48
-rw-rw-r-- 1 root root 15763 Apr 27 16:12 hbase-create.hbase
-rw-rw-r-- 1 root root 16139 Apr 27 16:12 hbase-create-snappy.hbase
-rw-rw-r-- 1 root root 854 Apr 27 16:12 hbase-drop.hbase
-rw-rw-r-- 1 root root 375 Apr 27 16:12 hbase-flush-table.hbase
-rw-rw-r-- 1 root root 542 Apr 27 16:12 hbase-major-compact-htable.hbase
-rw-rw-r-- 1 root root 2371 Apr 27 16:12 README.md
 
 
## TTL 값 변경 : 31536000 초(365일), 5184000 초(60일) 로 데이터를 유지하도록 되어있어 604800 초(7일)  로 변경.
[root@localhost scripts]# sed 's/31536000/604800/' hbase-create.hbase > hbase-create-my.hbase
[root@localhost scripts]# sed -i 's/5184000/604800/' hbase-create-my.hbase
[root@localhost scripts]# ll
total 64
-rw-rw-r-- 1 root root 15763 Apr 27 16:12 hbase-create.hbase
-rw-r--r-- 1 root root 15747 Jun 17 13:56 hbase-create-my.hbase
-rw-rw-r-- 1 root root 16139 Apr 27 16:12 hbase-create-snappy.hbase
-rw-rw-r-- 1 root root   854 Apr 27 16:12 hbase-drop.hbase
-rw-rw-r-- 1 root root   375 Apr 27 16:12 hbase-flush-table.hbase
-rw-rw-r-- 1 root root   542 Apr 27 16:12 hbase-major-compact-htable.hbase
-rw-rw-r-- 1 root root  2371 Apr 27 16:12 README.md
 
## 스키마 생성
 
 
[root@localhost scripts]# /usr/local/pinpoint/hbase/hbase-1.2.7/bin/hbase shell ./hbase-create-my.hbase
2020-06-17 13:57:41,080 WARN  [main] util.NativeCodeLoader: Unable to load native-hadoop library for your platform... using builtin-java classes where applicable
0 row(s) in 1.5430 seconds
0 row(s) in 4.3280 seconds
0 row(s) in 2.3160 seconds
0 row(s) in 1.2730 seconds
0 row(s) in 1.2630 seconds
0 row(s) in 1.2420 seconds
0 row(s) in 1.2440 seconds
0 row(s) in 1.2940 seconds
0 row(s) in 1.2410 seconds
0 row(s) in 4.3230 seconds
0 row(s) in 1.2420 seconds
0 row(s) in 1.2400 seconds
0 row(s) in 1.2580 seconds
0 row(s) in 1.2460 seconds
0 row(s) in 1.2410 seconds
 
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.0200 seconds

 

확인