databend icon indicating copy to clipboard operation
databend copied to clipboard

Feature: `replace into <table> from <stage>`

Open youngsofun opened this issue 1 year ago โ€ข 3 comments

Summary

just like copy into table, except

  1. 'copy' -> 'replace'
  2. support ON (<CONFLICT KEY>)

can solve https://github.com/datafuselabs/databend/issues/15774

youngsofun avatar Jun 13 '24 03:06 youngsofun

cc @dantengsky

youngsofun avatar Jun 13 '24 03:06 youngsofun

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);

wubx avatar Jun 13 '24 10:06 wubx

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

youngsofun avatar Jun 13 '24 11:06 youngsofun