比如有一个表
create table sl_demo_0531(
c1 varchar(100),
c2 varchar(100),
c3 varchar(100)
)
distributed by hash(c1)
properties(
"replication_allocation" = "tag.location.default: 3"
);
我用streamload方式导入的时候, 因为多余的列导入不进去
curl --location-trusted -XPUT -H "columns: c1,c2,c3" -H "column_separator: ^" -udcvip -T "aaa.csv" http://10.172.130.159:8030/api/dcvip/sl_demo_0531/_stream_load
使用mysql的load data也有这种情况
load data local infile 'aaa.csv'
into table sl_demo_0531
columns terminated by '^'
(c1, c2, c3);
其中aaa.csv的内容类似
111^222^333^555^666^777
222^333^444^999^000^000
请问如何忽略其他的列将数据导入到表中?