Skip to content
This repository has been archived by the owner on Dec 8, 2021. It is now read-only.

Design syntax for using Lightning from SQL #293

Closed
kennytm opened this issue Apr 13, 2020 · 1 comment · Fixed by pingcap/parser#824
Closed

Design syntax for using Lightning from SQL #293

kennytm opened this issue Apr 13, 2020 · 1 comment · Fixed by pingcap/parser#824
Assignees
Labels
feature-request This issue is a feature request

Comments

@kennytm
Copy link
Collaborator

kennytm commented Apr 13, 2020

Feature Request

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

Integrating Lightning into TiDB requires an SQL syntax.

Describe the feature you'd like:

Describe alternatives you've considered:

Teachability, Documentation, Adoption, Optimization:

@kennytm kennytm added the feature-request This issue is a feature request label Apr 13, 2020
@kennytm kennytm self-assigned this Apr 13, 2020
@kennytm
Copy link
Collaborator Author

kennytm commented Apr 13, 2020

Referring to pingcap/parser#746, we will support use the syntax like this:

IMPORT DATABASE * FROM 'file:///data/sql_dump';
IMPORT TABLE db1.tbl1, db1.tbl2 FROM 'file:///data/csv_dump';

-- lightning options
IMPORT DATABASE * FROM 'file:///data/csv_dump' 
    CHECKSUM = 0
    ANALYZE = 0
    CHECKPOINT = 0;

-- view tasks
SHOW IMPORT;
SHOW IMPORT LIKE '%csv%';
SHOW IMPORT WHERE `Progress` = 'Wait';

The main issue is to sort out the list of options to be exposed.

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
feature-request This issue is a feature request
Projects
None yet
Development

Successfully merging a pull request may close this issue.

1 participant