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

Add IMPORT INTO statement to import data by SQL using lightning physical mode #42930

Closed
D3Hunter opened this issue Apr 11, 2023 · 2 comments
Closed
Labels
type/feature-request Categorizes issue or PR as related to a new feature.

Comments

@D3Hunter
Copy link
Contributor

D3Hunter commented Apr 11, 2023

Feature Request

Is your feature request related to a problem? Please describe:

Describe the feature you'd like:

Add INGEST INTO statement to import data by SQL using lightning physical mode

syntax

IMPORT INTO tbl_name [(col_name_or_user_var [, col_name_or_user_var] ...)]
[SET col_name=expr [, col_name=expr] ...]
FROM 'file_or_url'
[FORMAT string]
[WITH option=val [, option=val]...]

most syntax is similar to LOAD DATA statement.

allowed WITH options:

  • character_set ='<string>'
  • fields_terminated_by ='<string>'
  • fields_enclosed_by ='<char>'
  • fields_escaped_by ='<char>'
  • fields_defined_null_by ='<string>'
  • lines_starting_by ='<string>'
  • lines_terminated_by ='<string>'
  • skip_rows =<number>
  • detached to run ingest in detached mode.
  • disk_quota: see lightning disk-quota.
  • checksum_table: see lightning checksum.
  • max_write_speed: control how fast we write
  • DISABLE_TIKV_IMPORT_MODE: to avoid switching TiKV into import mode.
  • thread: to control import concurrency.

Describe alternatives you've considered:

Teachability, Documentation, Adoption, Migration Strategy:

@D3Hunter D3Hunter added the type/feature-request Categorizes issue or PR as related to a new feature. label Apr 11, 2023
@D3Hunter
Copy link
Contributor Author

most code changes links to issue #40499

ti-chi-bot pushed a commit that referenced this issue Apr 17, 2023
ti-chi-bot pushed a commit that referenced this issue Apr 19, 2023
ti-chi-bot bot pushed a commit that referenced this issue May 18, 2023
ti-chi-bot bot pushed a commit that referenced this issue Aug 22, 2023
ti-chi-bot bot pushed a commit that referenced this issue Sep 1, 2023
@D3Hunter
Copy link
Contributor Author

this part is released in v7.2.0, so close it

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
type/feature-request Categorizes issue or PR as related to a new feature.
Projects
None yet
Development

No branches or pull requests

1 participant