Skip to content

Import FROM INFILE#27655

Merged
tavplubix merged 12 commits intoClickHouse:masterfrom
FArthur-cmd:import_from_infile_syntax
Aug 18, 2021
Merged

Import FROM INFILE#27655
tavplubix merged 12 commits intoClickHouse:masterfrom
FArthur-cmd:import_from_infile_syntax

Conversation

@FArthur-cmd
Copy link
Copy Markdown
Contributor

I hereby agree to the terms of the CLA available at: https://yandex.ru/legal/cla/?lang=en

Changelog category (leave one):

  • Improvement

Changelog entry (a user-readable short description of the changes that goes to CHANGELOG.md):

  • Add FROM INFILE command.

Detailed description / Documentation draft:
Now it is available to import data in table from files.

Example

INSERT INTO TABLE table_name FROM INFILE file_name;

Data from file_name will be send to table_name. If file was compressed using one of supported by ClickHouse algorithms of compression, it's data will be extracted and send to server.

@robot-clickhouse robot-clickhouse added the pr-improvement Pull request with some product improvements label Aug 13, 2021
@tavplubix tavplubix self-assigned this Aug 14, 2021
@tavplubix
Copy link
Copy Markdown
Member

If we send INSERT ... FROM INFILE query directly to server (through http or grpc interface), then server will just ignore it. Maybe throw some exception?

@tavplubix
Copy link
Copy Markdown
Member

Looks like Style Check works incorrectly

@tavplubix tavplubix merged commit 9b45b26 into ClickHouse:master Aug 18, 2021
@FArthur-cmd FArthur-cmd linked an issue Aug 18, 2021 that may be closed by this pull request
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Labels

pr-improvement Pull request with some product improvements

Projects

None yet

Development

Successfully merging this pull request may close these issues.

insert from file for temporary tables

4 participants