CREATE CATALOG setats COMMENT 'setats catalog' PROPERTIES ('type' = 'setats','setats.catalog.type' = 'hadoop','warehouse' = 'hdfs://<nameservice>/usr/setats','dfs.nameservices' = '<nameservice>','dfs.ha.namenodes.<nameservice>' = 'nn1,nn2','dfs.namenode.rpc-address.<nameservice>.nn1' = '<nn1-host>:4007','dfs.namenode.rpc-address.<nameservice>.nn2' = '<nn2-host>:4007','dfs.client.failover.proxy.provider.<nameservice>' = 'org.apache.hadoop.hdfs.server.namenode.ha.ConfiguredFailoverProxyProvider');
'hadoop.security.authentication' = 'kerberos','hadoop.kerberos.keytab' = '/usr/local/service/doris/kerberos.keytab','hadoop.kerberos.principal' = '<your-principal>'
CREATE CATALOG setats COMMENT 'setats catalog' PROPERTIES ('type' = 'setats','setats.catalog.type' = 'hms','hive.metastore.uris' = 'thrift://<metastore-host-1>:7004,thrift://<metastore-host-2>:7004','cos.endpoint' = 'cos.<region>.myqcloud.com','cos.access_key' = '<SecretId>','cos.secret_key' = '<SecretKey>','fs.ofs.bucket.region' = '<region>','fs.ofs.user.appid' = '<AppId>','fs.ofs.tmp.cache.dir' = '/tmp/chdfs/','fs.ofs.upload.flush.flag' = 'true','broker.name' = '<BrokerName>');
参数 | 说明 |
type | Catalog 类型，固定为 setats |
setats.catalog.type | Setats Catalog 类型，如 hadoop 或 hms |
warehouse | Setats Warehouse 地址，Hadoop Catalog 常用 |
hive.metastore.uris | Hive Metastore 地址，Hive / HMS 场景需要 |
dfs.nameservices | HDFS NameService 名称 |
dfs.ha.namenodes.<nameservice> | HA NameNode 列表 |
dfs.namenode.rpc-address.<nameservice>.nn* | NameNode RPC 地址 |
dfs.client.failover.proxy.provider.<nameservice> | HDFS HA Failover Provider |
cos.endpoint | COS 访问域名 |
cos.access_key / cos.secret_key | COS 访问凭据; 需要有 QcloudCOSListOnly 和 QcloudCOSDataReadOnly 权限 |
fs.ofs.bucket.region | 加速桶地域 |
fs.ofs.user.appid | 腾讯云 AppID |
broker.name | Doris Broker 名称 |
SWITCH setats;SHOW DATABASES;USE `testdb`;SELECT * FROM `demo_setats_table1`;
SELECT *FROM `setats`.`testdb`.`demo_setats_table1`;
文档反馈