【详述】 sr中无法创建cow的hudi外表，
cow的hudi表，建立sr外表是，报错说hudi表是hivetable
sr的resource的创建语句：
CREATE EXTERNAL RESOURCE “awk_hudi_01”
PROPERTIES (
“type” = “hudi”,
“hive.metastore.uris” = “thrift://xxx.xxx.xxx.xxx:9083”
);
hudi的建表语句：
CREATE TABLE awk_hudi_test_cow (
id int PRIMARY KEY NOT ENFORCED,
name VARCHAR(10),
price int,
ts int,
dt VARCHAR(10)
) PARTITIONED BY (dt)
WITH (
‘connector’ = ‘hudi’,
‘path’ = ‘hdfs://xxx.xxx.xxx.xxx:8020/tmp/hudi/awk_hudi_test_cow’,
‘table.type’ = ‘COPY_ON_WRITE’
);
– sr外表的建表语句：
CREATE EXTERNAL TABLE awk_hudi_test.sr_external_awk_hudi_test_cow (
id int,
name string,
price int,
ts int,
dt string
) ENGINE=HUDI
PROPERTIES (
“resource” = “awk_hudi_01”,
“database” = “hudi”,
“table” = “awk_hudi_test_cow”
);
【StarRocks版本】2.5
【集群规模】例如：3fe + 3be（fe与be混部）