【详述】外部表连接HIVE不通
【背景】单独远程连HIVE可以成功
【业务影响】
【StarRocks版本】2.5
【集群规模】1BE+1FE
【机器信息】CPU虚拟核/内存/网卡，例如：48C/64G/万兆
【联系方式】463545552@qq.com
【附件】
创建外部表脚本
CREATE EXTERNAL RESOURCE “hive0”
PROPERTIES (
“type” = “hive”,
“hive.metastore.uris” = “thrift://134.84.69.6:9083”
);
CREATE EXTERNAL TABLE latn(latn_id string,latn_name string,jtcode string)ENGINE = hive PROPERTIES (“resource” = “hive0”,“database” = “crmbs”,“table” = “latn”,“kerberos_principal” = “crmbs@MYCDH”,“kerberos_keytab” = “/app/crm_bs/hive/crmbs.keytab”);
