databend
databend copied to clipboard
bug: copy into table cannot work
Summary
Reproduce:
drop table t;
create table t(a int, b int);
COPY INTO t FROM 'fs:////Users/xujinkai/Desktop/UNdata/' PATTERN = 'table_0_01.csv' FILE_FORMAT =(type = 'CSV' field_delimiter = ',' record_delimiter = '\n' skip_header = 0);
table_0_01.csv:
0,0
https://docs.databend.com/sql/sql-commands/dml/dml-copy-into-table#copyoptions
Maybe add parameter force.
In my mind it's a bendsql err. Fixed in the newest version.
cc @youngsofun
after the first copy run succeed, the path of file loaded is remembered and skipped in the following two runs.