Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

feat: support columns for COPY INTO <TABLE> #10582

Closed
BohuTANG opened this issue Mar 15, 2023 · 2 comments · Fixed by #11371
Closed

feat: support columns for COPY INTO <TABLE> #10582

BohuTANG opened this issue Mar 15, 2023 · 2 comments · Fixed by #11371
Labels
C-feature Category: feature

Comments

@BohuTANG
Copy link
Member

BohuTANG commented Mar 15, 2023

Summary

To more easy to do transform in load:
https://databend.rs/doc/load-data/transform/data-load-transform

COPY INTO my_table (id, name)
FROM (SELECT t.id, t.name FROM @mystage t)
FILE_FORMAT = (type = parquet) PATTERN='.*parquet';
@BohuTANG BohuTANG added the C-feature Category: feature label Mar 15, 2023
@youngsofun
Copy link
Member

youngsofun commented Mar 15, 2023

planning, can manually provide the default values

COPY INTO my_table FROM (SELECT t.id, t.name, false  FROM @mystage t)
FILE_FORMAT = (type = parquet) PATTERN='.*parquet'

instead of

COPY INTO my_table (id, name)
FROM (SELECT t.id, t.name FROM @mystage t)
FILE_FORMAT = (type = parquet) PATTERN='.*parquet'

@lichuang lichuang self-assigned this Aug 9, 2023
@lichuang lichuang removed their assignment Aug 9, 2023
@lichuang
Copy link
Contributor

lichuang commented Aug 9, 2023

#11371

@lichuang lichuang closed this as completed Aug 9, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
C-feature Category: feature
Projects
None yet
Development

Successfully merging a pull request may close this issue.

3 participants