pg enum类型映射报错

[wangtingrong]

为了更快的定位您的问题，请提供以下信息，谢谢
【详述】问题详细描述
【背景】做过哪些操作？
【业务影响】
【是否存算分离】
【StarRocks版本】3.0.5
【集群规模】1fe+1be混部署
【机器信息】CPU虚拟核/内存/网卡，例如：48C/64G/万兆
【联系方式】社区15-大象
【附件】
问题1.catalog外表映射无法解析自定义枚举类型
postgresql建表语句
CREATE TYPE study_project_authority_range AS ENUM (
‘true’,
‘false’
);
CREATE TABLE study_project (
id varchar(32) COLLATE pg_catalog.utf8mb4_general_ci NOT NULL,
authority_range study_project_authority_range DEFAULT ‘false’::study_project_authority_range NOT NULL
)
WITH (orientation=row, compression=no, fillfactor=80, collate=1537);

sr外部表
CREATE TABLE enterprise_1494262391330969999.enterprise_study_project
(
id varchar(32) COMMENT ‘主键’,
authority_range STRING COMMENT ‘是否启用管辖范围过滤数据:true/启用,false/不启用’
) ENGINE = jdbc
properties
( “resource” = “test1”,
“table” = “coolcollege_enterprise_1494262391330969999.study_project”);

问题2:自定义枚举类型无法查询 类型不匹配

catalog
CREATE EXTERNAL CATALOG hl_pg
PROPERTIES
(
“type”=“jdbc”,
“user”=“hwcool”,
“password”=“hwcool@123”,
“jdbc_uri”=“jdbc:postgresql://192.168.0.103:5432/hwcool?currentSchema=coolcollege&useSSL=false”,
“driver_url”=“https://repo1.maven.org/maven2/org/postgresql/postgresql/42.3.3/postgresql-42.3.3.jar”,
“driver_class”=“org.postgresql.Driver”
);

查询
set catalog hl_pg;
use coolcollege;
select * from study_project limit 1;

[wangtingrong]

从catalog来看 自定义枚举类型会转为binary类型

CREATE TYPE sys_post_type AS ENUM (
‘create’,
‘sync’,
‘wx_sync’,
‘seeyon_sync’,
‘fs_sync’,
‘third_oa_sync’,
‘moka_sync’
);

CREATE TABLE sys_post (
id bigint NOT NULL,
post_name varchar(255) COLLATE pg_catalog.utf8mb4_general_ci DEFAULT NULL::varchar,
parent_id bigint,
left_val integer DEFAULT (-1),
right_val integer DEFAULT (-1),
post_order integer,
level varchar(64) COLLATE pg_catalog.utf8mb4_general_ci DEFAULT NULL::varchar,
create_time timestamp(0) without time zone DEFAULT NULL::timestamp without time zone,
update_time timestamp(0) without time zone DEFAULT NULL::timestamp without time zone,
type sys_post_type DEFAULT ‘create’::sys_post_type,
post_type sys_post_post_type
)
WITH (orientation=row, compression=no, fillfactor=80, collate=1537);