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

使用Select * from table into outfile 导出到本地的csv文件没有表头,只有数据行。需要把列名也导出到csv文件中怎么设置呢?

Asked Dec 6, 2024 Modified Jan 1, 0001
Viewed 86
2.0 1.2

SELECT k1 FROM tbl1 UNION SELECT k2 FROM tbl1
INTO OUTFILE "file:///path/to/result_"
FORMAT AS CSV
PROPERTIES(
"column_separator" = ","
);
是需要在PROPERTIES中补充一个什么参数吗?官方文档中没有提及呢?

edited Jan 1, 0001
qmluo1
asked Dec 6, 2024
1 Answers

使用format_as:CSV_WITH_NAMES_AND_TYPES或CSV_WITH_NAMES即可

edited Jan 1, 1970
qmluo1
answered Dec 6, 2024
Related Questions
doris fe节点变更成高可用配置
1 answers
各位大哥在通过k8s安装doris3.0的时候,有没有遇到cg启动不起来,提示Set max number of open file descriptors to a value greater than 60000.
1 answers
doris2.0.2.1大量delete语句和stream load执行在5分钟左右
1 answers
doris主键表可以bucket配置太小,怎么修改?
1 answers
flink-doris-connector-1.20.24.0.0 2pc ,checkpoint处恢复数据重复
1 answers
Doris的json解析问题
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 中文技术论坛.