错误详情
[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"}
推荐阅读
- 10分钟理解Android数据库的创建与使用(附具体解释和演示样例代码)
- Android数据库高手秘籍(零)——前言
- Android 数据库升级
- android打开 res raw目录 中 数据库文件
- Android下数据库创建
- 学习Android数据库SQLite的笔记
- 2022虎符|2022虎符网络安全CTF部分wp(1)
- Android 数据库 短信 监听
- Android数据库框架-----ORMLite 的基本用法