为了更快的定位您的问题，请提供以下信息，谢谢
【详述】导出csv到本地
【背景】查询sqlSELECT
eid AS feid,
stock_eid AS ceid,
eid,
stock_name AS NAME,
stock_eid AS stockeid,
is_history AS ishistory,
flag,
CASE
WHEN stock_percent = '' THEN
0 ELSE stock_percent
END AS stock
FROM
t_partners_alls
WHERE
stock_type != ‘111’
AND eid IS NOT NULL
AND eid != ‘’
AND stock_eid IS NOT NULL
AND stock_eid != ‘’
INTO OUTFILE “file:///opt/result_”
PROPERTIES
(
“column_separator” = “,”,
“line_delimiter” = “\n”,
“max_file_size” = “100MB”
);
建表语句
CREATE TABLE t_partners_alls (
id bigint(20) NULL COMMENT " ",
tb_name varchar(65533) NULL COMMENT “”,
eid char(36) NULL COMMENT " ",
stock_name varchar(256) NULL COMMENT " ",
stock_eid varchar(50) NULL COMMENT " ",
stock_pid varchar(36) NULL COMMENT " ",
stock_type varchar(256) NULL COMMENT " ",
stock_type_code varchar(20) NULL COMMENT “” ,
total_should_capi varchar(256) NULL COMMENT " ",
is_history tinyint(4) NULL COMMENT “”,
stock_percent varchar(256) NULL COMMENT “”,
update_dt datetime NULL COMMENT “”,
flag tinyint(4) NULL COMMENT “”
) ENGINE=OLAP
UNIQUE KEY(id, tb_name)
COMMENT “”
DISTRIBUTED BY HASH(id, tb_name) BUCKETS 14
PROPERTIES (
“replication_num” = “3”,
“in_memory” = “true”,
“storage_format” = “DEFAULT”,
“enable_persistent_index” = “false”,
“replicated_storage” = “true”,
“compression” = “LZ4”
);
执行导出操作报错
ERROR 1064 (HY000): Unmatched number of columns expected=8 real=6
【StarRocks版本】2.2.0
【集群规模】例如：3fe（3follower）+3be（fe与be混部）
【机器信息】28C56T/128G/万兆
【表模型】例如：主键模型
【导入或者导出方式】例如：Flink
【联系方式】1878848244@qq.com
【附件】
image|689x78
