报错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

解决

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"}