SelectDB 2.1.7
Doris通过Hive Catalog查询Hive表数据(parquet格式),小时级任务,每天偶尔会报(1105, 'errCode = 2, detailMessage = get file split failed for table: ods_cls_t8t_tbt_cls_cls_demo, err: java.lang.NullPointerException')错误。
create table if not exists tmp.dwd_clue_proj_con_content as
select
t01.id as clue_id
,cast(t01.phone_id as int) clue_phone_id
,row_number() over(partition by t01.phone_id order by t01.create_time asc,t01.id asc) row_number
from hive2.ods.ods_cls_t8t_tbt_cls_cls_demo t01
left join dim.dim_mkt_public_demo t02 on t01.channel_code = t02.channel_code and t02.new_team in ('图文营销','直播','短视频','视频号','SEO')
left join tmp.dwd_proj_recent_demo t03 on t01.phone_id = t03.phone_id
where t01.apply_status = 1
and t01.dt = '20250123'
and t01.create_time <= nvl(t03.first_operation_time,9999999999)
报错信息:
(1105, 'errCode = 2, detailMessage = get file split failed for table: ods_cls_t8t_tbt_cls_cls_demo, err: java.lang.NullPointerException')