使用streamload和mysql的load data导入数据的时候, 如何忽略多余的列?

Viewed 18

比如有一个表

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

请问如何忽略其他的列将数据导入到表中?

1 Answers