Apache Doris 中文技术论坛
Questions Tags Users Badges

【已解决】数据导入时,可以将空字符串自动转换为空值NULL吗?

Asked Nov 26, 2024 Modified Nov 26, 2024
Viewed 194
2.1 ingestion

使用stream_load导入数据时,Doris2.1现有功能,可以自动将导入数据中的空字符串转换成NULL吗? 如果有的话,是那个功能? 多谢

edited Nov 26, 2024
baijun15
asked Nov 26, 2024
3 Answers

导入的时候可以使用列变换表达式,result_slot=if(str = '', null, str)
https://doris.apache.org/zh-CN/docs/data-operate/import/load-data-convert#列转换

edited Jan 1, 1970
zclllyybb551
answered Nov 26, 2024

可以参考下数据转换这块:数据转换

edited Jan 1, 1970
张彬华7698
answered Nov 26, 2024

感谢答复 已经解决

edited Jan 1, 1970
baijun15
answered Nov 26, 2024
Related Questions
Doris执行Insert SQL时,导致3个BE同时挂掉
1 answers
delete bitmap XXX 日志的问题
1 answers
Flink Doris Connector lookup join 报错 query waiting queue is full, queue length=100
1 answers
Flink Doris Connector 的left join on查询不到数据
1 answers
Flink Doris Connector lookup join 报错 esource temporarily unavailable
1 answers
doris任务跑批失败,请问这个失败原因是什么?有什么好的解决方法吗?
1 answers

Terms of service Privacy policy

Powered by Answer - the open-source software that powers Q&A communities.
Made with love © 2026 Apache Doris 中文技术论坛.