Get the App
SLTechnology News&Howtos  ›  Database  › 

Hbase pre-built partition table to modify compression mode

Shulou Source: shulou.com Published: 2022-06-01 14:45:12 10月28日 Update

Hbase creates region and builds it according to the division of rowkey:

Create 'BT_NET_LOG_000','cf', {SPLITS_FILE = >' splits.txt'} create 'BT_NET_LOG_001','cf', {SPLITS_FILE = >' splits.txt'} create 'BT_NET_LOG_002','cf', {SPLITS_FILE = >' splits.txt'} create 'BT_NET_LOG_003','cf', {SPLITS_FILE = >' splits.txt'} create 'BT_NET_LOG_004','cf' {SPLITS_FILE = > 'splits.txt'} create' BT_NET_LOG_005','cf', {SPLITS_FILE = > 'splits.txt'} create' BT_NET_LOG_006','cf', {SPLITS_FILE = > 'splits.txt'} create' BT_NET_LOG_007','cf', {SPLITS_FILE = > 'splits.txt'} create' BT_NET_LOG_008','cf', {SPLITS_FILE = > 'splits.txt'} create' BT_NET_LOG_009' 'cf', {SPLITS_FILE = >' splits.txt'} create 'BT_NET_LOG_010','cf', {SPLITS_FILE = >' splits.txt'} create 'BT_NET_LOG_011','cf', {SPLITS_FILE = >' splits.txt'} create 'BT_NET_LOG_012','cf', {SPLITS_FILE = >' splits.txt'} create 'BT_NET_LOG_013','cf' {SPLITS_FILE = > 'splits.txt'} create' BT_NET_LOG_014','cf', {SPLITS_FILE = > 'splits.txt'} create' BT_NET_LOG_015','cf', {SPLITS_FILE = > 'splits.txt'} create' BT_NET_LOG_016','cf', {SPLITS_FILE = > 'splits.txt'}

Contents of the splits.txt file:

0000189005000000000000000000000000000000

0000189010000000000000000000000000000000

0000189015000000000000000000000000000000

0000189020000000000000000000000000000000

0000189025000000000000000000000000000000

0000189030000000000000000000000000000000

0000189035000000000000000000000000000000

0000189040000000000000000000000000000000

0000189045000000000000000000000000000000

0000189050000000000000000000000000000000

0000189055000000000000000000000000000000

The following is to modify the compression of the table:

Create 'BT_NET_LOG_001','cf', {SPLITS_FILE = >' split_500.txt'}

Disable 'BT_NET_LOG_001'

Alter 'BT_NET_LOG_001', NAME = >' cf', COMPRESSION = > 'GZ'

Enable 'BT_NET_LOG_001'

Just change GZ to snappy.

Http://www.itinit.net/thread-1764-1-1.html

Tags: Method content file partition table Apple Docker Huawei Linux macOS MariaDB Microsoft MySQL NVidia OPPO Reno MySQL Shulou Tech Info Shulou Technology NVidia Linux