ClickHouse S3引擎读取ORC文件Nullable(Date)空值报错求助

问题现象 #

• 使用ClickHouse的S3引擎读取包含空日期值的ORC文件时，触发空值读取异常；将同一份ORC文件转为CSV格式后读取正常，说明问题出在ORC文件读取环节。
• DateTime类型的Null值可正常读取，但仅Date类型列存在该问题，执行select null_date_column from s3('s3url','ORC')语句时触发报错。

错误信息 #

Code: 321. DB::Exception: Received from localhost:9000. DB::Exception: Input value 1834119856 of a column "end_date" is out of allowed Date32 range, which is [-25567, 120530]: (in file/uri s3url1-617e75a8f3f0.c000.snappy.orc): While executing ORCBlockInputFormat: While executing S3(_table_function.s3)Source. (VALUE_IS_OUT_OF_RANGE_OF_DATA_TYPE)

已尝试的ClickHouse参数配置 #

input_format_skip_unknown_fields = 1, input_format_null_as_default = 1, input_format_defaults_for_omitted_fields = 1,  input_format_allow_errors_num = 1000
input_format_allow_errors_ratio = 1 (100%);

内容的提问来源于stack exchange，提问作者Hemanth Kumar N R