databend icon indicating copy to clipboard operation
databend copied to clipboard

bug: copy into table cannot work

Open Dousir9 opened this issue 1 year ago • 4 comments

Summary

截屏2024-05-24 14 27 49

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

Dousir9 avatar May 24 '24 06:05 Dousir9

https://docs.databend.com/sql/sql-commands/dml/dml-copy-into-table#copyoptions

Maybe add parameter force.

wubx avatar May 26 '24 01:05 wubx

In my mind it's a bendsql err. Fixed in the newest version.

TCeason avatar May 26 '24 01:05 TCeason

cc @youngsofun

TCeason avatar May 26 '24 01:05 TCeason

after the first copy run succeed, the path of file loaded is remembered and skipped in the following two runs.

youngsofun avatar May 27 '24 06:05 youngsofun