stevqin opened a new issue, #17642: URL: https://github.com/apache/doris/issues/17642
### Search before asking - [X] I had searched in the [issues](https://github.com/apache/doris/issues?q=is%3Aissue) and found no similar issues. ### Version 示例 （MySQL数据库原表） `create table t_org_unit ( unit_id int unsigned auto_increment comment '组织id' primary key, unit_name varchar(64) not null comment '组织名称', unit_code varchar(64) not null comment '组织编码', establish_date datetime not null comment '成立日期', effective_date datetime not null comment '生效日期', unit_type char(2) not null comment '组织类型,字典key', unit_attributes char(2) null comment '组织属性', parent_id int unsigned not null comment '父级组织id', path varchar(512) not null comment '组织全路径id,下划线分隔', unit_path_name varchar(1024) not null comment '组织全路径名', hiberarchy char(2) default '1' not null comment '维度,字典key', corporater varchar(128) null comment '法人代表', location varchar(255) null comment '组织地址', introduction varchar(512) default '' null comment '组织简介', description varchar(255) null comment '描述', order_no int unsigned default 0 not null comment '排序码', area_id int(8) null comment '所属行政地区', ding_dept_id varchar(25) null comment '钉钉部门ID', org_map_level varchar(6) null comment '组织图谱层级', core_business_segments varchar(6) null comment '业务板块', status char(2) default '1' not null comment '状态,0禁用, 1启用, 2冻结', create_date datetime null comment '创建日期', create_by int unsigned null comment '创建人', last_update_date datetime null comment '最后更新日期', last_update_by int unsigned null comment '最后更新人', hrbp int null comment 'HRBP', area_hrbp int null comment '区域HRBP', leader_second int null comment '第二负责人', quash_remark varchar(1000) null comment '撤销原因', brand_type char(3) null comment '字典 ORG_BRAND_TYPE', city_type char(3) null comment '字典 ORG_CITY_TYPE', constraint uk_unit_code unique (unit_code) ) comment '组织表'; create index idx_hiberarchy_unit_type on t_org_unit (hiberarchy, unit_type); create index idx_parent_id on t_org_unit (parent_id); create index idx_path on t_org_unit (path(255)); ` `CREATE EXTERNAL RESOURCE resource_ihr properties ( "type"="jdbc", "user" = "user", "password" = "pwd", "jdbc_url"="jdbc:mysql://10.1.16.145:3306/ihr_pro?useSSL=false&zeroDateTimeBehavior=convertToNull", "driver_url"="mysql-connector-java-5.1.47.jar", "driver_class"="com.mysql.jdbc.Driver" ); CREATE CATALOG catalog_ihr WITH RESOURCE resource_ihr; ` --- Apache Doris 版本为 1.2.2 ps: mysql驱动试过 mysql-connector-java-5.1.47.jar mysql-connector-java-5.1.27-bin.jar mysql-connector-java-8.0.25.jar 上面的错误依旧 ### What's Wrong? 使用select语句报错 `select * from catalog_ihr.ihr_pro.t_org_unit` [2023-02-24 12:47:41] [HY000][1105] errCode = 2, detailMessage = NoClassDefFoundError: com/mysql/jdbc/TimeUtil 若查询的表中字段 不是 日期、时间 类型的字段，则可以查询出将结果 比如： `select unit_name from catalog_ihr.ihr_pro.t_org_unit` ### What You Expected? 支持日期格式，等常用数据库字段格式 ### How to Reproduce? _No response_ ### Anything Else? _No response_ ### Are you willing to submit PR? - [X] Yes I am willing to submit a PR! ### Code of Conduct - [X] I agree to follow this project's [Code of Conduct](https://www.apache.org/foundation/policies/conduct) -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
