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

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

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

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

edited Nov 26, 2024
baijun11
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
张彬华7678
answered Nov 26, 2024

感谢答复 已经解决

edited Jan 1, 1970
baijun11
answered Nov 26, 2024
Related Questions
upsert流UNIQUE KEY里主键修改,doris查询有两条数据,请问针对主键修改有什么方案?
profile显示不完整
tablet异常是怎么导致的?
2 answers
doris修改hivecatalog配置项不生效?
BE频繁挂掉, 2.1.6
1 answers
Doris 创建链接报错:Reach limit of connections
1 answers

Terms of service Privacy policy

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