databend
databend copied to clipboard
Feature: `replace into <table> from <stage>`
Summary
just like copy into table, except
- 'copy' -> 'replace'
- support
ON (<CONFLICT KEY>)
can solve https://github.com/datafuselabs/databend/issues/15774
cc @dantengsky
This feature is already supportedใ
replace into T on (pk) select $1.pk, $1.c1,$1.c2,... from @stage/prefix/ (file_format=>'ndjson', pattern=>'.*[.]ndjson);
This feature is already supportedใ
replace into T on (pk) select $1.pk, $1.c1,$1.c2,... from @stage/prefix/ (file_format=>'ndjson', pattern=>'.*[.]ndjson);
I mean without the select part