总结类|报错doris Doris BrokerLoad No source file in this table

错误详情

[INFO] 2022-04-24 23:05:04.373 - {"State":"CANCELLED","LogTime":"2022-04-24 23:05:04", "ErrorMsg":"type:ETL_RUN_FAIL; msg:errCode = 2, detailMessage = No source file in this table(ods_grow_minusscreen_ad_info).", "Process":"ETL:N/A; LOAD:N/A","url":"NULL"}

报错detailMessage = No source file in this table
解决 【总结类|报错doris Doris BrokerLoad No source file in this table】broker load语句中的DATA FILE路径写错了,需要写的是文件,而不是目录。需要把指定日期下的文件夹换成里面的所有文件。
即:hdfs://xxxxxxxxx/ods/ods_grow_minusscreen_ad_info/date=20220423
修改为
hdfs://xxxxxxxxx/ods/ods_grow_minusscreen_ad_info/date=20220423/*
错误二
[INFO] 2022-04-24 23:15:47.330 - {"State":"CANCELLED","LogTime":"2022-04-24 23:15:47", "ErrorMsg":"type:ETL_RUN_FAIL; msg:errCode = 2, detailMessage = unknown reference column, column=date, reference=date","Process":"ETL:N/A; LOAD:N/A","url":"NULL"}

coulum list没有写date
错误三
[INFO] 2022-04-24 23:19:54.939 - {"State":"CANCELLED","LogTime":"2022-04-24 23:19:54", "ErrorMsg":"type:LOAD_RUN_FAIL; msg:errCode = 2, detailMessage =file: hdfs://zjyprc-hadoop/user/h_data_platform/platform/ods/ods_grow_minusscreen_ad_info/date=20220423/part-00001-9dd42d3d-d2be-4b74-9742-a29849f77724-c000 error:Invalid argument: Invalid Column Name:date","Process":"ETL:N/A; LOAD:N/A","url":"NULL"}

    推荐阅读