使用版本sr 2.0.0-ga
1、创建hive资源
CREATE EXTERNAL RESOURCE “hive0”
PROPERTIES (
“type” = “hive”,
“hive.metastore.uris” = “thrift://node193:9083,thrift://node194:9083”
);
2、创建hive外部表
CREATE EXTERNAL TABLE dwd_worker_aged_pay_his_split_d_ext(
jflsid varchar(200) comment ‘缴费历史id’,
rydjid varchar(200) comment ‘人员登记id(跟单位对应)’,
ryid varchar(200) comment ‘人员id’,
…
) ENGINE=HIVE
PROPERTIES (
“resource” = “hive0”,
“database” = “***”,
“table” = “dwd_worker_aged_pay_his_split_d”
);
3、查询报错
ERROR 1064 (HY000): com.starrocks.common.DdlException: get partition detail failed: com.starrocks.common.DdlException: get hive partition meta data failed: java.net.UnknownHostException: myha