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

No Column Lineage Parsed for DML with SELECT query in parenthesis #244

Closed
reata opened this issue Apr 6, 2022 · 1 comment
Closed

No Column Lineage Parsed for DML with SELECT query in parenthesis #244

reata opened this issue Apr 6, 2022 · 1 comment
Assignees
Labels
bug Something isn't working

Comments

@reata
Copy link
Owner

reata commented Apr 6, 2022

SQL:

INSERT OVERWRITE TABLE tab1
(SELECT col1 FROM tab2)

Column lineage is not correctly parsed while table lineage is fine.

$ sqllineage -f foo.sql -l table 
Statements(#): 1
Source Tables:
    <default>.tab2
Target Tables:
    <default>.tab1

$ sqllineage -f foo.sql -l column

The expected column lineage would be

<default>.tab1.col1 <- <default>.tab2.col1
@reata reata added the bug Something isn't working label Apr 6, 2022
@reata reata changed the title No Column Lineage Parsed with SELECT query in parenthesis No Column Lineage Parsed for DML with SELECT query in parenthesis Jun 11, 2023
@reata reata self-assigned this Jun 11, 2023
@reata
Copy link
Owner Author

reata commented Jun 11, 2023

Closed by #371. Note this is only supported with sqlfluff implementation. We won't fix non-validating dialect.

@reata reata closed this as completed Jun 11, 2023
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
None yet
Development

No branches or pull requests

1 participant