clickhouse 查询问题，报错:year 0 is out of range

[IplLL]

重现步骤

创建了clickhouse账户，测试也能正常连接，但是发现在查询表的时候报错 year 0 is out of range ，只有特定的几张表出现这个问题；

预期外的结果

日志文本

2024-06-24 15:16:08,393][MainThread:140080363759424][task_id:default][clickhouse.py:141][WARNING]- ClickHouse语句执行报错，语句：select * from EmaDrug limit 100;，错误信息year 0 is out of range
[2024-06-24 15:16:23,416][MainThread:140080363759424][task_id:default][clickhouse.py:141][WARNING]- ClickHouse语句执行报错，语句：select * from FdaDrug limit 100;，错误信息year 0 is out of range
[2024-06-24 15:16:39,668][MainThread:140080363759424][task_id:default][clickhouse.py:141][WARNING]- ClickHouse语句执行报错，语句：select * from JpDrug limit 100;，错误信息year 0 is out of range
[2024-06-24 15:16:53,109][MainThread:140080363759424][task_id:default][clickhouse.py:141][WARNING]- ClickHouse语句执行报错，语句：select * from MedicalBid limit 100;，错误信息year 0 is out of range
[2024-06-24 15:17:03,692][MainThread:140080363759424][task_id:default][clickhouse.py:141][WARNING]- ClickHouse语句执行报错，语句：select * from MedicalBid_temp_638546112000466005 limit 100;，错误信息year 0 is out of range
[2024-06-24 15:18:26,575][MainThread:140080363759424][task_id:default][clickhouse.py:141][WARNING]- ClickHouse语句执行报错，语句：select * from FdaDrug limit 100;，错误信息year 0 is out of range
[2024-06-24 15:20:49,606][MainThread:140080363759424][task_id:default][clickhouse.py:141][WARNING]- ClickHouse语句执行报错，语句：select * from MedicalBid_temp_638546112000466005 limit 100;，错误信息year 0 is out of range
[2024-06-24 15:21:59,140][MainThread:140080363759424][task_id:default][clickhouse.py:141][WARNING]- ClickHouse语句执行报错，语句：select * from EmaDrug limit 100;，错误信息year 0 is out of range
[2024-06-24 15:34:26,323][MainThread:140080363759424][task_id:default][clickhouse.py:141][WARNING]- ClickHouse语句执行报错，语句：select * from EmaDrug limit 100;，错误信息year 0 is out of range

版本

1.9.1

部署方式

Docker

是否还有其他可以辅助定位问题的信息？比如数据库版本等

mysql:5.7 archery:v1.9.1 redis:5

[nick2wang]

可能是这几张表中含有非法日期格式数据

[IplLL]

@nick2wang 是有一列出现这样的日期导致的，就是不能全部查询了，用起来不是很方便，不知道怎么解决

[nick2wang]

clickhouse是哪个版本的？