表格存储服务 CLOUDTABLE-Hive:元数据缓存设置

时间:2023-11-10 14:32:20

元数据缓存设置

创建Catalog时可以采用参数file.meta.cache.ttl-second来设置Hive分区文件缓存自动失效时间,也可以将该值设置为0来禁用分区文件缓存,时间单位为:秒。示例如下:

CREATE CATALOG hive_catalog PROPERTIES (
    'type'='hms',
    'hive.metastore.uris' = 'thrift://127.x.x.x:port',
    'AWS_ACCESS_KEY' = 'ak',
    'AWS_SECRET_KEY' = 'sk',
    'AWS_ENDPOINT' = 'obs.cn-north-4.myhuaweicloud.com',
    'AWS_REGION' = 'cn-north-4',
    'file.meta.cache.ttl-second' = '60',
    'yarn.resourcemanager.address' = '192.X.X.X:port',   
    'yarn.resourcemanager.principal' = 'mapred/hadoop.hadoop.com@HADOOP.COM'
);
support.huaweicloud.com/devg-cloudtable/cloudtable_01_0392.html