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

Support Create Table Like Statement #29

Closed
reata opened this issue Nov 17, 2019 · 1 comment · Fixed by #42
Closed

Support Create Table Like Statement #29

reata opened this issue Nov 17, 2019 · 1 comment · Fixed by #42
Assignees
Labels
bug Something isn't working
Milestone

Comments

@reata
Copy link
Owner

reata commented Nov 17, 2019

drop table  if exists tab_a;
create table if not exists tab_a like tab_b;

drop before create, the result is tab_a exists after the above statements;

If we switch the order:

create table if not exists tab_a like tab_b;
drop table  if exists tab_a;

Although the above statements make no sense, still, we should output result as tab_a does not exist.

Under current circumstances, both cases will be that tab_a does not exists since tab_a is identified as temp table. This is related to #23

@reata reata added the bug Something isn't working label Nov 17, 2019
@reata reata added this to the v0.2.0 milestone Nov 17, 2019
@reata reata self-assigned this Nov 17, 2019
@reata reata added this to To do in SQLLineage v0.2.0 via automation Nov 17, 2019
This was referenced Nov 18, 2019
@reata
Copy link
Owner Author

reata commented Apr 9, 2020

The Drop Table order issue is already taken care of with #22 . And the new problem is that create like Statement is not supported. An AssertError is raised because like is identified as Comparison Operator.

CREATE TABLE new_tbl LIKE orig_tbl;

@reata reata changed the title drop table and create table, order matters Support Create Table Like Statement Apr 9, 2020
@reata reata closed this as completed in #42 Apr 11, 2020
SQLLineage v0.2.0 automation moved this from To do to Done Apr 11, 2020
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working
Projects
No open projects
Development

Successfully merging a pull request may close this issue.

1 participant